Professional Summary:

• Over 7 years of professional IT experience in Design, Development, Implementation, , Business Analysis and Reporting using Crystal Reports and Business Objects.
• Expertise in production Data Warehouse maintenance, database designing/modeling for new applications and database changes to existing OLTP applications for data warehouse.
• Worked with Informatica Power Center to create complex mappings using expressions, Routers, Lookups, aggregators to develop and to move data to multiple databases.
• Performed data analysis and defined metrics using dashboards, scorecards in XCelcius 2008.
• Good experience in Reporting tools like Crystal XI R2/X/2008/8.5, Actuate Reports, Business Objects, Web Intelligence and SSRS.
• Created views, triggers, functions, stored procedures, packages in PL/SQL.
• Built static and dynamic parameters with various data type as Date, number, string, boolean, currency. These parameters were mostly used with record selection formula.
• Experience in building Universes and involved in distribution and maintenance of universe.
• Extensively used Database fields, Formula fields, SQL Expression fields, Parameter fields, Group Name fields, special fields and running totals,Formula workshop for writing custom formulas and other features.
• Created UNIX shell scripts for automating Autosys jobs.
• Experience in using different types of data providers to create reports in Business objects.
• Experience in working with ETL tools like Informatica 8.1.6, SSIS.
• Created documentation for deploying reports, scheduling reports & installation of Crystal Reports on Client machines.
• Have experience working with databases DB2, Oracle, SQL Server 2008/2005 and MS-Access.
• Demonstrated excellent interpersonal skills and communication skills during identification of user requirements.
• Established analytical capabilities with good problem solving skills.

Technical Skills:

Reporting Tools:Crystal Reports 8/9/X/XI, Crystal Report/Business Object Enterprise, MS Access Reports, Microsoft reporting Services, Crystal Management Console, SQL Server Reporting Services Database(s):ORACLE 10g/9i/8i/7, DB2 9.5/7/5, Sybase 12/11.5, MS SQL Server 2008/2005/2000, MySQL 5.1/5.0, MS Access 2003. Data modeling Tools:RapidSQL, ER Studio 7.5, Toad 4.5 Programming Languages:C, C++, SQL, PL/SQL, XML, HTML Scripting  ETL:JavaScript, UNIX Shell Script , Informatica Power Center 8.6.1/7.1/6.2 (Repository Manager, Designer, Server manager, Work Flow Monitor, Work Flow Manager), Power Exchange, SQL Server Integration Services Operating System: Windows 95/98/2000 /NT/XP. Office suite:MS Office 2007/2003. Ticketing Systems:HP Service Center 6.2

Professional Experience:

Confidential, Atlanta, GA Dec’11-Present 
BO/Crystal Reports DeveloperAutomatic Data Processing, Inc. (NASDAQ: ADP), with about $10 billion in revenues and approximately 570,000 clients, is one of the world\'s largest providers of business outsourcing solutions. Leveraging over 60 years of experience, ADP offers a wide range ofhuman resource,payroll,taxandbenefits administrationsolutions from a single individual.
Working on Third Party Payroll project as Crystal Reports Developer converting existing reports based on MS Access DB to Oracle DB in Production. Also involved in designing Universes using Business Objects and scheduling reports using Repsched for the internal Vista application.Responsibilities:

• Collaborate effectively with Client Service Managers, Project Managers, Business Analysts, DBA and other team members.
• Develop Crystal Reports based on detailed specifications, design and unit testing documents, release notes, Change request forms as per industry standards.
• Develop and test PL/SQL code for reports for web based Vista application using Oracle SQL Developer.
• Propose and design optimized and solution for complex reports using analytical and specialized technical skills.
• Modifying existing complex reports based on MS Access to Oracle DB on TPPayroll schema and perform validations on them.
• Create parameterized reports in Crystal using tables, queries and verify joins between them.
• Created Details, Summary, Cross-tab reports using filters, Sorting, Groupings based on different fields in Crystal.
• Validate, format and review reports in Crystal Design before moving to Production.
• Automating the Crystal reports using Company_ID parameter in Business Objects Infoview.
• Perform Report management, Admistration and scheduling reports using Repsched.
• Involved in migrating reports from Legacy Repsched to New Repsched in Production.
• Participate and contribute in daily SCRUM meetings to achieve organizational goal as team and as an individual.

Environment: Crystal Reports XIR2, Business Objects XIR3.1, Oracle SQL Developer 3.0.04, PL/SQL, Oracle 11g, Microsoft Excel 2010, Repsched, MS Access 2010.

Confidential, Weehawken, NJ Sept ‘10-Sep’11
BO DeveloperConfidential combines wealth management, investment banking and asset management businesses with our Swiss operations to deliver superior financial solutions and manage in invested assets. Wealth Management Americas provides advice-based relationships through financial advisors who deliver a fully integrated set of products and services specifically designed to address the needs of ultra high net worth, high net worth and core affluent individuals and families. 
The Enterprise Data Warehouse (EDW) approximately a 4 terabyte data warehouse, formalized with the merger of departmental reporting databases EDW, CIS and other operational systems. The Data Warehouse environment covers Client, Employee & FA, Accounts, Costs, Product, Revenue, Trade & Order, Branch, Assets, and Transactions etc. Data is propagated from the core data warehouse to a variety of data marts to support reporting and analysis. The “Business Intelligence” application is an implementation of Business Objects to support WMUS’s financial advisors.Responsibilities:

• Gathered, analyzed and documented Business requirements, clarified Business rules and data design requirements, functional requirements and data specifications for Crystal reports.
• Designed Universes for applications namely Auction Rate Securities, Finance and Control, FA Compensation System and HCPsystemas per the User Requirement.
• Created folders and User groups and applied security access restrictions as per the user roles through CMC.
• Migrated reports from Dev to Prod using Biar files and PVCS version control.
• Responsible for Creating Complex and Multi Dimensional reports, Master/Detail, Cross Tab, Slice and Dice, and Sub Queries in Crystal.
• Monthly batch load for processing full calls using FTP and verifying transactions.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Involved in publishing Crystal Reports using Source and recipient report for large user group.
• Created mappings, transformations (Source-Target, Expression, Lookup, Joiner), workflows and monitored them using Informatica Power Center.
• Deployed Crystal reports to CMC (Central Management Console) for users to view reports in Infoview and run, schedule them in PDF and Excel formats.
• Used the Universes, Stored Procedures as source for Business Objects Querying, analysis and reporting.
• Manage multiple BO universes using Business Objects Designer and Infoview.
• Creation of ad-hoc reports and modified existing reports.
• Created variables, formulas and filters in report level.
• Created hyperlinks, alerters and ranking for WEBI reports.
• Validated the report data from backend using DB Artisan.

Environment: Crystal 2011, Crystal Reports XIR2, Business Objects XIR2 Designer, Informatica Power Center 8.6, SSH Client, Actuate 9, SFTP, UNIX 8, Oracle 10g, Embarcadero DBArtisan 8.1.5, Toad 9.

Confidential, NewYorkCity, NY Mar’09-Aug ‘10
BO Developer
The goal of this project (FOCUS) is to build a Customer-Centric data warehouse called Commercial Finance Data Warehouse (CFDW) to analyze transactions across Finance, Marketing, Risk, Tax processing, Collections, and Consumer relations and to develop set of standard BO reports to give better analysis to the financial group. With clean customer data successfully implemented, the data warehouse is growing in analytical richness, including the functionality.Responsibilities:

• Constantly worked with Business users to provide them with the data in form of complex reports and excel sheets for analysis.
• Created reports in WEBI for HP Service Center data on Service Center Reporting Universe.
• Modified existing reports according to user requirements.
• Involved in the creation of Materialized Views and created indices on look up tables and fact tables for improving query performance.
• Created stored procedures, functions and views in SQL to extract data from the database for the creation of new Crystal Reports according to the end-user requirements.
• Upgraded server instances running on Business Objects XI R2 to Business Objects XIR3.1.
• Involved in analyzing, developing and testing various Crystal Reports based on grouping, drill downs, charts and custom formulas etc.
• Actively involved in user training and testing of Crystal Reports for final deployment. Interacted directly with the user for getting specs, draft specs and generated Crystal reports.
• Extensively involved in using of formula fields, parameter fields, group selection and record selection in Crystal Reports.
• Created reports on Call, Changes, Problem and Incident records for Service Center requests.
• Created dynamic filters for the users to select the different filter values.
• Created queries using add Command object in Crystal Reports XI. Created linked, unlinked and on-demand sub reports.
• Created various Cross-tab, Master-detail, Tabular and Summary reports.
• Used alerters, Merge cells and sorts (ascending, descending) in the reports and dashboards in XCelsius.
• Exported reports to PDF and Excel and validated data and automated using UNIX scripts.
• Tested reports on SQL Server database and closed incident tickets.

Environment: Crystal Reports XI, Business Objects XI R3.1/R2, SQL Server 2008/2005, Informatica Power Center 8.6.1(Data warehousing designer, Mapping Designer, Workflow Manager, Workflow monitor), Actuate 7, WEBI, HP Service Center Enterprise Client 6.2, XCelsius 2008, Oracle 10g, UNIX, PL/SQL, MS Excel 2003.

Confidential, Wayne City, PA Jan ’08 – Jan’09
BO DeveloperAs one of the world’s leading specialty biopharmaceutical companies, Shire has emerged as a company fully focused on a single purpose: to enable people with life-altering conditions to lead better lives.
This projects Data Ware House was about creating rules, events, and Webi reports making use of ranking, filters and alerters. Developed several Complex reports and customized several reports into EXCEL, PDF and CSV.Responsibilities:

• Gather user requirements, draft specifications, design and deploy reports using Crystal Reports Designer, Crystal Query.
• Created reports using of formula fields, parameter fields, group selection, record selection, and Crystal syntax in Crystal reports.
• Developed complex business reports using custom formulas, conditional formatting, sub reports, drill-down reports, cross-tab reports, ad-hoc reports.
• Developed data models using star schema and snow-flake schema for the data warehouse (OLAP).
• Designed and Built the Universes, Classes and Objects in Business Objects XI R2.
• Created Source-Target mappings using Lookup, Merge, Sorter transformations in Informatica.
• Developed standard, advanced, graphical and cross-tab, on demand and Drill-down reports using Crystal.
• Created databases, forms, queries and (standalone and embedded) macros in MS Access.
• Created DTS packages for loading data from Oracle, SQL Server tables to Data warehouse.
• Involved in enhancing and converting few of excel macro reports to Crystal reports.
• Created Indexes, Views, Triggers, and Stored Procedures in PL/SQL for Oracle database.
• Created dashboards for analyzing statistical billing data using XCelsius.
• Exported the universes to the Repository to share the resources among the users.
• Created Static, Dynamic and Cascading parameter fields for filtering data in Crystal Reports.
• Used Parameters, Graphics, Charts and many other features in Crystal Reports XIR2.
• Created reports by extracting the data directly from database by writing Free Hand SQL and automated in UNIX.
• Designed and developed Crystal Reports, the Cross Tab Reports, Top N Reports for highlighting significant data, summary reports with drill-down capabilities.
• Documented test cases and test scripts along with technical specifications.

Environment: SQL Server 2008/2005, DTS, SSRS, Toad,Business Objects R3/XI R2, XCelsius 2008, ER Studio 7.5, Crystal Reports X, Web Intelligence, MS Access 2007, Desktop Intelligence, Toad 9, Oracle 9i/10g, PL/SQL, and Windows 2000.

Confidential, Richmond, VA June ’04 – Jun’06
BO DeveloperWellPoint works to simplify the connection between Health, Care and Value. We help to improve the health of our communities, deliver better care to members, and provide greater value to our customers and shareholders. Worked with ITSM (Information Technology Service Management) as Reports Developer creating WEBI reports for HP Service Center Data consisting of Change, Call, Problem and Incident records. This project of WellPoint’s Data Ware House was about Creating rules, events, and Webi reports making use of several Queries (union, minus). Developed several Complex reports and customized several reports into EXCEL, PDF, and CSV.Responsibilities:

• Involved in understanding the end-user requirements and business processes in creating new reports.
• Worked with Data Analyst in developing Universes based on data model, reporting requirements.
• Weekly, Monthly, and Forecasting reports were created using existing universes with respect to user requirements and integrated using Deski.
• Designed Scorecards & Dash Board formats with Metrics, Rules, Goals & sets.
• Installed and configured Business Objects XI R2 on Windows serves.
• Created Indexes, Views, Triggers, and Stored Procedures in PL/SQL scripting.
• Generated reports in WEBI involving numerous prompts and linking several data providers and automated them.
• Developed procedures to convert reports in Oracle 10g to Crystal Reports XI for Investment management system.
• Validated the data and the joins in the Universe by running BO reports and exporting the output to the Excel Spreadsheets and again testing it against the data that was fetched from backend tables.
• Generated pictorial view in the reports in the form of 3D, bar, pie charts from existing reports and also used chart wizard for creating charts.
• Documented test cased and report specifications.

Environment: SQL Server 2005, Oracle 9i/10g, Deski, Crystal Reports XI, XCelsius, DB2 8.0, Informatica-PowerCenter/PowerMart 7.1.3/6.2.2 (Data warehousing designer, Mapping Designer, Workflow Manager, Workflow monitor), Power Exchange, PL/SQL, HTML, XML, Windows 2003, UNIX.

Confidential, Hyderabad, India Nov’03 – May’04 Reports DeveloperConfidential is a distinctive family of financial services companies that provides products and services for financial planning and consulting designed to build and protect financial wealth of clients. The project was designed for the investment management system, Using Business objects as front end and Oracle as back end. The system was primarily written to provide reports for our portfolio managers who could use these reports to provide our clients with the highest total rate of return consistent with their performance goal, cash flow requirements, need for liquidity, and preservation of capital.Responsibilities:

• Designed universe for standard reporting and ad-hoc reporting requirements.
• Created Contexts and alias for resolving Loops in the Universes.
• Designed Complex reports using sub reports, manual cross tabs using Crystal Reports syntax with extensive usage of Local, Global, and Shared variables at report formulas.
• Modifying the existing universes, adding new objects, editing joins and mapping the existing objects with renamed tables.
• Created User groups, Users, Database connections, Managed user privileges, Import/export of universes in production environment.
• Designed Scorecards & Dash Board formats with Metrics, Rules, Goals & sets.
• Worked with different universes and used linking of different universes using Designer.
• Worked with Distributing, Importing, Exporting and deploying of universes using Deski.
• Implemented different level of hierarchies for drill down reports.
• Involved in Writing Detailed Level Documentation for reports and Universe design.
• Involved in developing both static and dynamic reports.
• Controlling Reports data by working with Universe and queries. Using Filters, Sorts and Rankings.
• Used various @Functions, Created customized functions/hierarchies for reports.
• Created several complexes-cross tab reports using Business Objects Reporter.
• Involved in resolving issues relating to pre implementation of Reports.

Environment: SQL Server 2000, Oracle 9i/8i, Business Objects 6.5 (Designer, Reporter, Desktop Intelligence), Crystal Reports IX, XML, Windows 2000, Java Script, PL/SQL.