Database Analyst

Job Description:

Develop reports for IT, Finance, and other Corporate departments using SSRS and Crystal Reports XI R2.
Develop reports which include dynamic grouping fields, dynamic group sorting, on-demand sub-reports, drilldown and summary report/Created Cross Tab reports highlighting key summary information
Ability to re-design or customize the existing Views and Stored Procedures to suit the reporting needs.
Perform ad-hoc data analysis.
Responsible for all aspects of reporting solution including: new report generation, report optimization, customization of existing reports and standardization of reports.
Development and implementation of reports primarily utilizing Crystal Reports XI R2.
Experience in interacting with business users, gathering requirements, and preparing report specifications.
Experience in developing Procedures and Views, on Microsoft SQL Server 2008.
Skilled in the use of Structured Query Language (SQL) as a tool for retrieving, updating, inserting, deleting, manipulating and managing data stored in enterprise databases.
Experience in installation, configuration and administration of Crystal Reports and ODBC.
Development of reports which include parameterized reports (Static, Dynamic & Cascading Prompts), formulas, nested groups, manual running totals, summaries, conditional formatting and charts.
Ability to optimize reports by making existing reports more dynamic and flexible by utilizing parameters, prompts and triggered alerts.
Enhanced old reports utilizing comments, descriptions, edit masks and by improving overall documentation standards.
Published Crystal Reports in web based environment using Business Objects Enterprise XI.
Export reports into various formats such as PDF, HTML, EXCEL
(5+) Years of SQL Development and Reports Development Experience
(2+) Years SQL 2008
(3) Years of SSRS/SSIS Experience
(5) Years of Crystal Reports Experience
Excellent Communication and Interpersonal Skills

SKILLS

SQL Development and Reports Development, SQL 2008, SSRS/SSIS, Crystal Reports, Communication and Interpersonal Skills

Synectics is an Equal Opportunity Employer.