SUMMARY

• About 11 years of professional IT experience in Analysis, Design, Development, Testing and Implementation of Crystal Reports 8.5/11.0.
• Crystal Reports: 7+ years of experience in Crystal 11.0 /8.5. Worked in various Crystal Environments extracting data from multiple sources, applying several functionalities
• Business Intelligence: 5+ years of Business Intelligence experience in building universes, developing reports. Worked in various BO environments linking data from multiple sources, applying several functionalities, and using various Data Providers. Trained users in producing documents and running queries.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Table, Matrix.
• Good experience in working with RDMS including MS SQL Server, MS Access
• Database experience: 6+ years of experience in MS SQL Server 2012/2008/2005/2000 , (stored procedures, functions), and DB2.
• Expert in creating various SQL stored procedures, functions and temporary tables for data input to the Crystal Reports
• Deployed reports on the web using Crystal Management Console (InfoView)
• Major responsibilities included getting requirements from the user, developing Crystal Reports & maintaining proper documentation of the reports for future reference
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the Software Development Life cycle.
• Excellent communication skills, both written and verbal and ability to work in both individual and team environments
• Good backend skills in creating SQL objects like tables, stored procedures

TECHNICAL SKILLS

Programming: C#, asp.net, ColdFusion, SQL, C++, VB.Net, JAVA, HTML, JavaScript, XML.

Operating Systems: UNIX (SunOS), Windows 8, Windows 7, XP, 2000 NT, Windows 8, Windows 10, and MSDOS.

Applications: APTIFY, Personify, SAP Crystal Reports Version 11.0/11.5(R2), DB2, Microsoft SQL Server 2008, and 2005, SQL Enterprise, Crystal Enterprise 8.5, Business Objects, webi, Crystal Management Console, Actuate, Oracle 9i, Oracle 8i, Microsoft Office 2010 and above, and Microsoft Project, Lotus Notes 7.0, Lotus Notes Domino Designer, Graphical User Interface (GUI), Adobe Photoshop, Macromedia Fireworks 8, WinRunner, LoadRunner, Test Director, Quick Test Professional

PROFESSIONAL EXPERIENCE

Confidential

Crystal Report Developer

Responsibilities:

• Migrated Crystal Reports from Personify to APTIFY (vendor tools).
• Participated in requirements gathering for new task.
• Developed Templates in APTIFY for Sales Team when providing invoice/quotes to prospect clients.
• Scheduled Crystal Reports to internal clients on weekly, bi - weekly, and monthly basis.
• Modified SQL queries from one system to new system.
• Wrote stored procedures to be used for several reports.
• Created views and base views in APTIFY bases on internal client needs.
• Created historical reports bases on sales for specific products.
• Worked closely with end users/testing team to resolve any issues regarding about SQL queries or layout of the report.
• Involved in training end users, business users and customers on how to create modify and interpret WEBI reports and Crystal reports.

Confidential

Crystal Report Developer

Responsibilities:

• Created the Crystal reports using tables and tested the reports by cross checking and verifying data against the reports generated.
• Wrote formulas to calculate the group summaries based on the group levels in Crystal Reports.
• Was part of a project which required developing many UPDATE SQL statements to tables based on the business requirement.
• Reviewed team members SQL queries as part of Code Review.
• Worked as a part of the team responsible for generating reports for the End users and different business teams across.
• Modify report content and export reports in multiple formats based on user requirements (MS Excel, PDF, Text, and CSV) .
• Reviewed User Requirements, created detailed functional design documents and Report design details documents for the reports.
• Resolved the Performance issues/Data issues with in the Reports.
• Worked extra hours to meet deadlines (weekends or after business hours).
• Managed a team of two Crystal Report Developers to meet deadlines during crunch time for WVS track.
• Held daily meetings with Crystal Report Developers to make sure the track was on right track in order to meet deadlines for WVS track.
• Did code review of developers SQL queries to make sure the all business requirements are met.
• Engaged into data modeling and table structure part for WVS system.
• Train users to use the tool and create Ad-hoc business objects reports.
• Participated in weekly basis meetings with manager’s/team leads to give status on progress of allocated work assigned.
• Worked closely with testing team to resolve all issues that arose either regarding about SQL queries or layout of the report.
• Executed batch jobs to generate reports on intranet site.
• Responsible for Installation and Configuration of Crystal Reports.

Confidential

SSRS Report Developer

Responsibilities:

• Developing reports on SSRS on SQL Server (2008).
• Generated matrix reports, drill down, and multi parameterized reports
• Updated existing reports to match new report layout standards.
• Interacted with end users in defining the requirements and developed documentations of the gathered requirements.
• Created reports which pertained to company financial information’s, human resources (bonus and salary) data.

Confidential

Web Application Developer / Report Developer

Responsibilities:

• Worked closely with internal customers analyzing problems and to create and maintain reports
• Designed report options and/or database queries to meet the needs of both internal/external clients.
• Maintaining internal reports and ad-hoc SQL scripts.
• Performed and maintained data extracts and imports
• Provided analysis services for business data needs and made recommendations for viable solutions.
• Troubleshoot data issues, validated result sets, recommends and implements process improvements.
• Utilized Visual Studio in creating Web Applications for internal users.
• Possess strong communication and analytical skills to effectively elicit, capture, develop and implement customer requirements.
• Created complex reports using Crystal Reports.
• Enhanced/modified existing reports by creating new Parameters, Formulas etc,
• Created reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Scheduled reports to run on daily/weekly/monthly basis and to distribute the output in different formats to various users.
• Responsible for setting up the Database logon info and parameters on Info View for the users to run the reports.
• Expert in creating various SQL stored procedures, functions and temporary tables for data input to the Crystal Reports.
• Optimized various SQL queries to make the reports run faster
• Used SQL extensively in command objects of Crystal reports
• Created test data by creating procedures for reporting purpose
• Worked on stored procedures for data access and get the data integrity.
• Fine tuning the performance of queries, stored procedures
• Responsible for defects rose during testing of the reports.
• Modified the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically
• Migrated reports from Crystal 8.5 to Crystal 11.0
• Exported reports to various formats like MS Excel, PDF, MS Word, Text, and CSV .
• Modifying existing reports and to develop new reports by analyzing databases, data sources, and structures for the benefit of internal users.
• Created Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.
• Published and scheduled the reports in Crystal Enterprise using Crystal Management Console so that reports are accessed from Front-end application.
• Train users to use the tool and create Ad-hoc business objects reports (With my own documentation).

Confidential

Web Developer

Responsibilities:

• Maintained web user interfaces, web pages, and developed web pages in Cold Fusion MX 7.
• Provided support for applications which were developed in Cold Fusion MX 7. .
• Created reports for customers using SQL Server, and created reports for customers which were viewable in customer portal.
• Developed new code for software applications in applicable languages using Cold Fusion (7.0), Java Scripts, and HTML with SQL.