SUMMARY

• Over 9 years of experience in modeling and development of Business Intelligence, Crystal Reports and Dashboards
• Experience in Crystal 2013/2011/2008/ XI /10/9/8.5 and 5+ year of experience in SAP BW and Business Objects tools.
• Experience with MS SQL Server Developer/ ETL Developer in analysis, design, implementation & administration of Business intelligence solutions (SSIS/SSAS/SSRS) with Microsoft SQL server 2012/2008 - R2/2008/2005 in development, testing & production environment and as well as Tableau, data discovery, data visualization, data analysis, report development.
• Expertise in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008 and MS SQL Server 2005 respectively.
• Extensive Knowledge in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• Used ETL to implement the SCD transformation, to maintain historical data in data warehouse.
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as For Each Loop, For Loop to loop over a Directory to load inbound files coming daily.
• Expertise in developing SSIS Packages and using data transformations and deploying them on various production servers.
• Used SSRS to create and manage a wide variety of different types of report, and deliver them in a range of formats
• Used SSRS to create basic reports containing tables and graphs and also more complex data visualizations, using charts, maps and sparklines.
• Used Report Manager for users to view the reports within the web based applications.
• Worked on SSRS reporting using the report wizard, designing the tables and creating reports using report designer
• Created interactive, tabular, graphical and free-form reports from relational, multidimensional, or XML-based data sources using SSRS.
• Worked in various Crystal Environments extracting data from multiple sources, applying several functionalities and used different Data providers like OLEDB, ODBC, etc. Created compelling reports with stunning visualizations using Crystal 2008.
• Used BICS connectivity to connect directly to the Bex queries and build Dashboards for the various objects in rows, columns and key figures.
• Developing reports using Crystal Reports including: extracting data from SQL server to satisfy standard reports, ad-hoc requests, developing databases, spreadsheets, and other applications to manipulate data.
• Connected to several SAP BW data sources and built reports on top of Cubes, Infoproviders and BEx Queries.
• Enhanced new InfoObjects to be attached/mapped in InfoSources/Communication structures. Changed transformation rules as per customer requirements (ABAP routines)
• Designed, developed ETL, extracted BW Data to Non- SAP System using Open Hub service
• Maintained Process chains to automate and schedule the background performance tuning jobs of BW query using Indices, aggregates, Compression, Achieving and Partition
• Designing and deployment of Dashboards and Reports using BI tools.
• Facets replicated DB to support ad hoc reporting across the enterprise.
• Integration of Crystal Reports with Web applications to deliver the reports on the web.
• Developed Crystal Reports using Crystal reports formulas, Grouping, Parameters, Selection criteria to handle the customer’s requests from Tables, Views and Command Objects
• Worked with Crystal Report 2013/2011 and Crystal Enterprise for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based reports, drilling reports, analysis reports, data reports along with LOV
• Worked on new features of Crystal 2013 Streamlined report design, Improvements to data sources, Mobile and viewer support, OEM and developer features
• Created reports using Crystal 2013 for Mobile support.
• Experience in Public Sector domain for Department of Commerce
• Experience inHealthcareandInsurancedomains.
• Creating Functional Specifications using the Facets Database like Facets Table Names and Facets column names including Facets Criteria.
• Coordinated with ETL, Data warehouse team to implement the Star Schema modeling from Facets 4.31 to ODS data model.
• QA Testing of the reports developed in Crystal Reports and comparing with Facets query results
• Experience with multipleRDBMSincludingMS SQL Server 2000/2005/2008 , Oracle 10g/9i/8i, DB2, and Microsoft Access.
• Extensive knowledge inSQL & PL/SQLprogramming, writingStored Procedures, Functions, Packages using SQL Server Management studio, PLSQL Developer, SQL Plus, SQL Navigator and TOAD.
• Designed reports with complex sub reports, Drill down, Cross Tabs, formulas, functions, parameters, scheduled reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections,mailing label.
• Good experience in report customization via the use ofGrouping, Sorting, Field Highlighting, Conditional Formatting, Running Totals, Summaries, Static & Dynamic Parameters, Static & Dynamic Graphic Objects,Custom Formulasand Custom Functions (SQL Queries).
• Good knowledgeCMC(Central Management Console) for user management, content management, and server management tasks andCCM(Central Configuration Manager) to manage local and remote servers
• Sound working knowledge of MS Access,Excel, MS Project and Version Control tools (PVCS, subversion, TFS).
• Experience in developingreport specificationsbased on business requirements.
• Experience in developingtest plans,preparingtest dataand performingunitandintegration testing
• Scheduled and published reports using CMCandInfo view.
• Experience with .NET application platform and development using Visual Basic.
• Extensive experience in preparing Use Cases, Functional Specifications, Scenarios, Source-to-Target Mapping doc, Business processes, Workflows, Process flows, Test cases and Test Plans.
• Soundknowledge of Software Development Life Cycle (SDLC) and Project management.
• Excellent problem solving and interpersonal skills withdocumentationand communication skills and anexcellent team playerto maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS

Data Warehousing: SAP BI 7.0 / BW 3.5

ERP: SAP R/3

Reporting Tools: Crystal Enterprise 10.0/9.0/8.5 , Crystal reports 2013/20112008/ XI/ 10.0/9.0/8.5

Languages: ABAP/4, Java, C, C++, PL/SQL, SQL

DBMS: Oracle, SQL Server, DB2, MS Access

OS: UNIX, Linux, Windows NT/2000/XP

Web Tools: HTML, DHTML, CSS, JavaScript, XM

PROFESSIONAL EXPERIENCE

Confidential, DC

Crystal Reports Developer

Responsibilities:

• Worked with Crystal Report 2013/2011 and Crystal Enterprise for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based reports, drilling reports, analysis reports, data reports along with LOV
• Worked on Creating reports with Crystal Reports/Spectrum relationship
• Used several formulas to perform calculations and linking additional database tables into a report and Integrating modified reports into Spectrum
• Used spectrum LIMS for optimizing laboratory performance and time and resource management
• Worked to add and remove data from reports like the Job Overview and Contract Status Reports using Spectrum.
• Worked on adding terms and conditions to Spectrum forms, like subcontracts and purchase orders
• Worked on various processes for Process for customizing Spectrum reports
• Used Crystal report Wizards to complement Spectrum on specific requirements
• Analyzing and preparing data for future Spectrum upgrades.
• Create and modify existing spectrum reports
• Creating the Connection Between Spectrum + Crystal Reports
• Used the tools built into Spectrum to quickly locate the data file you need for your reports
• Created reports using Spectrum’s multi-company tables that consolidated information from two or more Spectrum companies.
• Worked on new features of Crystal 2013 Streamlined report design, Improvements to data sources, Mobile and viewer support, OEM and developer features
• Created reports using Crystal 2013 for Mobile support.
• Designed cascading prompts in the universe to filter the list of account names based on the business units for Crystal.
• Used Aggregate Navigation in Universe. Created Crystal reports using Business Objects functionalities like queries, Slice & Dice, Drill Down, Cross Tab, Master/Detail and Formulas etc.
• Linked multiple universes.
• Involved in configuration of OracleSubscriber/Memberapplication.
• Worked onOracle /SQL Data tables and created audit reports using queries. Manually loaded data in SQL and Oracleand have good knowledge onOraclebusiness rules.
• Did the forward andbackwarddata mapping between the fields in mainframe andFACETS.
• Provided support tofull Software Development Life Cycle, testing, training and implementation.
• Responsible for working with the State to review and modify process flows to increase productivity and effectively utilizeOraclefeatures not provided by the legacy systems.
• Developing reports using Crystal Reports including: extracting data from SQL server to satisfy standard reports, ad-hoc requests, developing databases, spreadsheets, and other applications to manipulate data.
• Created standard reports, cross-tab reports, Mailing reports & OLAP reports.
• Authored extensive SQL, PL/SQL stored procedures, oracle packages, ETL programs, partitioning, materialized views, functions and triggers, UNIX shell scripts and SQL*Loader programs to perform data migration while preparing Source Staging, Migration Staging and Target environments.
• Involve database analysis and design. Also responsible for designing the forms for the entire application.
• Developedstored proceduresusingPL/SQL.
• Responsible for writing stored procedures and triggers.
• UsedVisual Source Safeeffectively for Source Control like file tracking, simultaneous checkouts, merging etc
• Created Report templates, Detail Reports,Parameterized Reports and Cross-tab reports.
• Create Crystal Reports with multiple drilldown and sub-reports.
• Published and scheduled the reports inCrystal Enterpriseusing Crystal Management Console so that reports are accessed from Front-end application
• Conducted user-training sessions and technical support customers and troubleshoot data validity, connectivity access issues, and web issues.

ENVIRONMENT: Business Objects XI R2 /XI R3 DESKI, WEBI 3.2(Designer, Supervisor, Web Intelligence, Performance Manager, CMC, CMS, CCM), SQL Server 2005/2000, Crystal Reports 10, Erwin, Window XP

Confidential, Baskin ridge, NJ

Business Objects Developer

Responsibilities:

• Played key role in developing, implementing and demonstrating the successful pilot project using Crystal reports
• Designed, Developed and Implemented around 45 plus reports for 2 departments on development server as Pilot project.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• Designed the data requirements by analyzing the existing Impromtu reports.
• Designed and Developed existing Impromtu reports in Crystal Reports Developer
• Implemented Crystal Enterprise development environment by installing Crystal Enterprise on IIS 5.0 web server.
• Recommended changes and updates on Views used by Impromtu reports.
• Deployed and tested the Crystal Reports on Crystal Enterprise environment.
• Configured and trained users to use Crystal Reports.
• Demonstrated Crystal's strength by enhancing the report performance as much as 70 percent when compared to Impromtu reports mainly by using materialized views and stored procedures to develop Crystal Reports.
• Tipped the developers with tricks in crystal reports development.
• Executing, monitoring various Unix scripts, escalating and bug fixing the related issues as required, providing solution's, implementing code logic as per functional, AdHoc requirements.
• Optimized the Oracle PL/SQL queries.
• Fine tuning PL/SQL stored procedures
• Created Logical and Physical models for Staging, Transition and production Warehouse using Erwin 3.0
• Responsible for creating the Complex Crystal Reports (on demand, AdHoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Aging Reports).
• Created Complicated Formulas and Running Totals on Summarized Totals for Business Measure Calculations based upon various End-User Requirements Worked on various backend Procedures and Functions using TSQL.

ENVIRONMENT: Business Objects XI R3/R2, DESKI, WEBI (Designer, CCM, CMS, CMC, BO Full Client, Web Intelligence, Broad Cast Agent (BCA), Publisher), XCelsius 4.5,, SQL Server 2005/2000, Erwin, Informatica PowerCenter 7.1, Teradata, Tomcat 4.0, Apache server 1.3, Unix (IBM AIX 5.1, Sun solaries 8), JAVA/J2EE, PL/SQL,C#, VB.Net, ASP.Net, HTML, Crystal Reports 10/XI, TOAD, Pro*C, WinNT UNIX, Window XP

Confidential, VA

Crystal Reports /SAP BO Developer

Responsibilities:

• Create various complex reports usingCrystal Reports XI R2
• Enhance/modify existing reports by creating newParameters, Formulasetc,
• Schedule the reports usingInfo Viewto run at specific times in a day/week as desired by the Business Users
• Assist BO administrator in setting up security for various reports on Enterprise
• Responsible for setting up the Database logon info and parameters on Info View for the users to run the reports
• Interact directly with the business users ingathering requirements
• Optimize variousSQL queriesto make the reports run faster
• UsedSQLextensively in command objects of Crystal reports
• Create test data by creatingviews/proceduresfor reporting purpose
• Create and edit alerts on Reports, as per User request
• Modify the existing reports by addingnew logicand deletingexisting logicas the line of Business changes periodically
• Migrate reports from Dev to Production
• Provide on call support after reports aredeployed to production
• Export reports in various formatslike MS Excel, PDF, MS Word, Text and CSV
• Generate reports withparameters, sub reports, cross tabs, chartsusing Crystal Reports
• Use prompts, alerts, drill down analysis as per the end user requirements
• Createnested, conditional subgroupsandformatting features inreports
• CreateSub reportscalled from the main report to implement the business logic
• Create various database objects like Tables,ViewsandStored Proceduresby using Toad
• Responsible for defects raised during testing of the reports
• Created linked, unlinked and on-demand sub reports.

ENVIRONMENT: Business Objects 6.5/XI R2, WEBI, DESKI, Crystal Reports XI, Crystal Xcelsius 4.5, Oracle 8i/9i, PL/SQL Developer, SQL Server 2005/2000, Java 2, Windows 2000 and UNIX

Confidential, NJ

Crystal Reports Developer

Responsibilities:

• Used SQL extensively in command objects of Crystal reports.
• Tested the reportsfor accuracy using SQL queries inTOADandSQL Developer.
• Created Custom functions,formulae,cross tabs, graphs and charts.
• Develop an understanding of the business and data requirements to ensure a successful project.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL,Command Objects,Selection Criteria, grouping,sub reportsetc.
• Created reports withdrill downoption,Parameter fields, formulae, and heavy formatting.
• CreatedCross Tab Reports,Pie and Bar Charts, and Parameter Reports,Running totals,Sub Totalsandembedded linked and unlinked sub-reportsto separate and organize key information and to promote reusability in data reporting.
• Developed stored procedures inPL/SQLusingTOADto be used in the reports.
• Developed various database objects like Tables,ViewsandStored Proceduresby using Toad, PL/SQL in Oracle.
• Used Crystal Reports 2008 to develop reports with Dynamic parameters according to the requiremnt
• Involved in resolving the loops, Cardinalities, contexts and checked the Integrity of the Universes.
• Involved in the creating the reports on the web using the BO Web Intelligence from the online internet database and migrated from third party database.
• Designed and developed universes for reporting generation from different database.
• Called one report from another and bypassed prompts when there is no data used.
• Involved in the designing and building of universes, classes and objects.
• Created repository and user, user groups using supervisor module,

ENVIRONMENT: Business Objects 6.5, DESKI (Designer, Reporter, Supervisor, Broadcast Agent and Web Intelligence), PL/SQL, Informatica Power Mart 5.1, Oracle 8i, SQL Server 7.0, and Windows NT.

Confidential, DC

Crystal Reports Developer

Responsibilities:

• Created blueprint documentation for outlook design development based on functional and technical specification requirements.
• Developed executive dashboards using Xcelsius 2008 for regional and financial directors.
• Support role for Business objects admin involving in creating rolls and permissions in central management console and restricting the access levels based on their role.
• Created custom ad-hoc reporting using Liveoffice, web intelligence, CMS XI and crystal reports by building universes.
• Worked on various consolidated financial statement reporting using WebI to generate financial statements like trial balances, profit and loss accounts, income statements, cash flow statements and balance sheets.
• Performed user surveys to determine the customer satisfaction and resolving any issues occurred during the process.
• Responsible for data capturing through designing, applying and implementation processes.
• Deployed and configured business objects in distributed environment on windows.
• Knowledge of BOXI series on application servers like, tomcat, Weblogix, IIS, WebSphere on windows environment.
• Primary point of contact for Business objects customers for troubleshooting issues related to development and administration.

Confidential, DC

Crystal Reports Developer

Responsibilities:

• Designed Web intelligence reports in form of tables and charts.
• Worked on enhancing presentation of data in reports using breaks, sorts, report filters, ranking, tracking, using alerts and sections.
• Calculated data using formulas and variables used multiple data sources and analyzing data within the scope of analysis.
• Best practices for SAP business objects enterprise were implemented.
• Provided subject matter expertise to the business intelligence team for key initiatives.
• Designed complex dashboards in Xcelsius using Webi reports based on Bex query as a source.
• Created various Crystal reports using functions like parameters, grouping and formulas based on the requirement.
• Modified available dashboard completely using Design studio.
• Restriction on user and group in objects at universe level were applied based on the user and group
• Created new users, managed and restricted access using the Central Management Console (CMC).
• Web intelligence ad hoc reports were generated providing users with option of selecting values from the prompts or through the input controls.