SUMMARY

• Over 8 years of strong experience in gathering design requirements, developing software, maintaining proper documentation for future reference
• Extensive experience in Crystal Reports and creating complex, professionally formatted, readable reports
• Excellent work experience as Report developer and Report Analyst with in-depth knowledge in working and implementation of Crystal Reports versions 2008/XI/10/8.5, Oracle 10g/9i, MS SQL Server 2008 and MS Access
• Expert in planning, modeling, designing, developing, implementing, administering, and maintaining Microsoft SQL Server 2008/2005/ 2000 and Access 97-2007 databases. Some experience with Oracle 10g and MYSQL 6.0 Databases.
• Experience of working in structured environment designing and developing analytical and financials reports
• Expertise in SQL, stored procedures, triggers, cursors, tables, views and joins
• Expertise in defining Queries, testing the queries, performance tuning and query optimization
• Expertise in generating drill-down, cross-tab, parameterized reports, sub reports, query based reports, and customized templates
• Experience of Data Warehousing and Analytical experience
• Experienced in working on Web Intelligence Universe Designer and Dashboard Builder
• Experienced in Server side reporting solutions using SSRS, data integration and migration solutions using SSIS, and data analysis solution using SSAS.
• Expert knowledge and experience authoring, managing and deploying reporting solutions using SSRS.
• Expert in using tools like SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools.
• Expert in writing script to provide solution using T-SQL commands.
• Excellent using command prompt application using SQLCMD.
• Strong leadership, communication, problem-solving and multi-tasking abilities.
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.
• Ability to prioritize and remain focused on the essence of an issue.

EDUCATION
BS in Information Technology

TECHNICAL SKILLS

Reporting Tools Crystal Reports 2008/XIR2/10.0, SSRS,
Programming: SQL Developer, SQL*plus, SQL, PL/SQL, C, VB.NET,Toad, C#, HTML
Databases: Oracle 11g/10g/9i, SQL Server 2008/2005/2000, MS Access
Software Packages Visual Studio 2008, MS Office 2010/07 (Word, Excel, PowerPoint),
Operating Systems Windows 7/Vista/XP/2000, Macintosh OS

PROFESSIONAL EXPERIENCE

Confidential,NY
Crystal Report Developer Augl’12 Sep’12

Responsibilities:

• Developed Reports using Crystal Reports using Crystal report 10.
• Developed and published critical reports ranging from complex drill-downs, cross-tab reports.
• Develop complex report which includes several sub- reports.
• Developed reports using store procedures.
• To gather information for reporting purpose.
• Working with High-level grouping data.
• Working with Store procedure.
• Developed reports with less information provided.
• Together information to convert business specs to technical specs

Environment: Crystal Reports 10, Oracle server 11 g , Windows 7

Confidential,NY Jan ’12 May\'12
Crystal Reports Developer

Responsibilities:

• Developed new reports according to requirement using Crystal report XIR2.
• Modified pre-created reports according to new requirements.
• Write queries according to requirements in reports.
• Work with Parameters, Views, Filter, Shared variables, with tools and queries .
• Work with Avatar to upload reports.

Environment: Crystal Reports XI R2, SQL Server 2008, Windows 7, Microsoft Office 2010, Avatar,unix

Confidential,Southportland, ME Jul’11 Dec’11
Crystal Reports Developer

Responsibilities:

• Developed Reports using Crystal Reports using Crystal report XIR2.
• Developed and published several Crystal Reports ranging from complex drill-downs, cross-tab reports and charts.
• Create different Forms using Crystal Reports.
• Filter Reports Using different parameters.
• Create reports using drill down, charts.
• Create cross tab reports.
• Working with High-level grouping data.
• Working on Business object XIR2.

Environment: Crystal Reports 2008, XI R2, Business Object XIR2,SQL Server 2008, Visual Studio 2008, .NET, Windows XP

Confidential,Wethersfield, Ct Jan’10 May’11
Crystal Reports Developer

Responsibilities:

• Performed as a Business Analyst to gather requirements and simultaneously studied database resources.
• Interacted with the users to understand and gather business requirements.
• Worked with the stakeholders to design reports including parameter development.
• Developed the reports as per end-user’s requirements, using Crystal Reports.
• Generated queries and stored procedures
• Created standard reports, cross-tab, sub reports, drill down reports, on demand sub reports using Crystal reports 2008
• Developed various charts and graphs like bar chart, line charts, pie charts etc. by using chart expert.
• Customized data by adding Filters, Calculations, Prompts, Summaries and Functions
• Strong experience in working with advanced features like incorporating a parameter into a formula, parameter with multiple prompting etc.
• Worked on multi level grouped reports while using section expert that require running totals, SQL expressions, graphs, sub-totals, sub-reports, and conditional display of groups, database fields and text objects using conditional formatting.
• Tested the queries and reports before publishing including performance testing
• Interacted with the project manager, business analyst and report developers in the team during quality control testing and deployment.
• Involved in the analysis, design, development, testing, deployment and user training of analytical & transactional reporting system.
• Maintained high level of customer satisfaction with custom reporting services from both internal and external customers.

Environment: Crystal Reports 2008, XI R2, SQL Server 2008, Visual Studio 2008, .NET, Windows XP

Confidential,Jacksonville, FL Nov’07 Dec’09
Crystal Reports Developer

Responsibilities:

• Generated Reports from the newly implemented administrative application which uses Oracle 10g database.
• Managed sections by controlling visibility of sections in a report by hiding or suppressing sections. Kept sections together or splitting sections as per the situation. Adding and deleting objects, sizing objects and sections working with guidelines.
• Built static parameter list to get static user information and dynamic parameters retrieving data from the database table dynamically at run time. These parameters were mostly used with record selection formula.
• Involved in creating Crystal Reports and design documentation regarding courses and students status for the Retention Office, Academic Affairs.
• Served as primary technical resource and assisted the director and staff in the resolution of problems.
• Interacted with users to obtain specifications and assisted in the implementation phase.
• Responsible for the design, development and support of databases/statistical reports using MS Access 2007, Crystal Reports 10.0, SQL, and MS Excel.
• Developed queries to collect information from the school’s Banner System that uses an Oracle relational database and stored that data in the local MS Access database tables.
• Exported Crystal Reports into various formats like PDF, HTML, EXCEL, and WORD for the users.
• Changed and Performance tuned old Crystal reports as per the change in the requirement.
• Worked with Dreamweaver, PHP and Filezilla for updating web pages.

Environment: Crystal Reports 10, Visual Studio 2005, Oracle 10g, MS Access 2007, MS Excel, Windows XP

Confidential,Boca Raton, FL Jul’05-Oct’07
Crystal Reports Developer

Responsibilities:

• Developed Reports using Crystal Reports 8.5 / 9.
• Actively involved in gathering end user requirements, user/system documentation, user training and testing developed reports for final deployment.
• Interacted with business analyst, project manager and other report developers to understand their needs.
• Developed and published several Crystal Reports ranging from complex drill-downs, cross-tab reports and charts.
• Applied formatting for reports and developed reports with necessary Formula fields, Parameters fields, Group and Record Selections.
• Created Stored Procedures, Views, Queries, and Templates to produce the reports.
• Created linked, unlinked sub reports. These sub-reports were built to open on-demand or inline to the main report.
• Also involved in working with the UI developers in designing web pages.

Environment: Crystal Reports 8.5/9, SQL Server 2000, Visual Studio, Windows 2000.