IT Specialist Senior

| Agency Name: | Information Technology Services (ITS)

 | Engagement Length in Months: | 12

•               Working with NYS Agency representatives to develop report specifications and understand Agency business rules
 •               Write complex report SQL against databases such as Oracle database.
 •               Performance tuning report SQL to improve efficiency.
 •               Design, develop, test and maintain reports using tools such as Crystal Reports and Oracle Service Cloud.
 •               Assist with data migration and conversion projects.
 •               Support and report on COTS products such as NYS E-Licensing system.
 •               Identify and resolve or facilitate the resolution of problems with production reports.
 •               Provide knowledge transfer to Agency report developers.


| 60 Months of Experience writing complex SQL, PL/SQL, Packages and Triggers against an enterprise Oracle database
| 74 Months of Experience performance tuning complex SQL, PL SQL against an enterprise Oracle database, data analysis and root cause analysis
| 74 Months of Experience working with stakeholders to determine reporting and data conversion/migration specifications
| 60 Months of Experience with Crystal Reports - designing, developing reports with Oracle back-end, testing and deploying reports.
| 60 months of Experience in designing reports and having a good understanding of the underlying data sources as well as the expertise in interpreting the requirements provided by Business Analyst for ad-hoc reports
| 24 Months of Experience with Oracle Service Cloud. Designing, developing reports with MySQL back-end, testing and deploying reports
| 24 Months of Experience in data analysis, cleansing and migration.
| 48 Months of experience with incident ticket management, Ex. ALM HP Quality Center; 36 Months of experience with version control systems