SUMMARY:

• Over 15 years of experience in IT industry with an expertise in Business Intelligence and Data Warehouse architecture and applications.
• Certified Project Management Professional (PMP).
• 9+ years of hands - on expertise in Business Objects Enterprise products - BO BI 4.0, XI R2 with immense knowledge in CMC, Designer, Reporting modules, Web intelligence, Infoview.
• 9+ years of experience in analysis, design and development of various data warehouse applications using BODS/BODI.
• Extensively worked on BODS components - Jobs, Workflows, Data Store and Scripts.
• Experience on BODS administration tasks like Repository Configuration, Job Server Configuration, Local Repository and Central Repository Configuration, Job Scheduling and Monitoring.
• 9+ years of technical experience in working and implementation of Crystal reports.
• 7+ years of expertise in Universe designing, generating complex adhoc, dashboard reports, list of values.
• Experience in Data Modeling, Star/Snowflake schema modeling, Physical and Logical data modeling.
• Expertise in BI/DW design, development, testing and trouble shooting.
• Expert in tuning the performance of SQL queries and ETL process.
• Expertise in Business Objects XI R2/6.X, utilizing full BI suite for Administration and development.
• Expertise in creating dynamic list of values using Business View Manager.
• Experience in creating Repositories, Folders, Groups, Users, assigning privileges to users and maintaining the Repository.
• Experience in SSIS data services.
• Involved in migrating business objects applications from BO XI R2 to BI 4.0 to BI 4.2.
• Well experience in writing queries, stored procedures and functions using SQL.
• Managed and delivered large and complex assignments on time within the budget.
• Experienced in leading on-site and off-shore project teams (small to medium size).
• Participated in Trainings & Workshops with User Groups and Technical teams.
• Experienced in multiple industry processes and applications such as manufacturing, retail, payroll and finance.

TECHNICAL SKILLS:

BI Tools: SAP BO BI 4.0/4.2/XI R2, Crystal Reports 2008/ XI R2, Universe Designer, Web IntelligenceInfo View, Crystal Reports, Import Wizard, Business View Manager, APOS Burst Tool

Databases:: SQL server 2008, MS Access 2000, DB2, IDMS, Sybase, Progress, SQL/DS

ETL Tools: Business Objects Data Integrator (Data Services XI 3.2), BODS 4.1, SSIS

Languages: SQL, C, COBOL, VB.Net, HTML, FORTRAN

OS: Windows Server 2003/NT/XP/7, MVS Z/OS, VM

Other Tools: Visual Source Safe, Visual Studio 2013/2015, Visio 20013, SharePoint 2007, Jira, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Oakbrook, IL

Senior Business Object Administrator & BODS Architect

• Participated in project planning sessions with the business managers and users.
• Involved in the development of Membership, Officers and Donations data mart using BODS.
• Designed various data flows to extract data from different sources, implemented slowly changing dimensions to load current and historical data, used look-up functions, implemented conditional flows to load full data or delta.
• Worked on different transformations like history preserving, table comparison, row generation, SQL transformation.
• Developed complex SQL stored procedures for report development.
• Developed the new ETL processes using Data Services for real-time and batch mode.
• Involved in data migration, conversion, data quality and validations.
• Performed the architect roles like Design, Development and Implementation.
• Involved in full life cycle of Business Objects reporting application.
• Involved in report template design documents.
• Developed complex reports using WEBI.
• Created complex reports like sub-reports, Drill Down and Drill Up.
• Developed and implemented new Universes for Officers and Donations Data mart and created new Webi reports on these universes.
• Developed custom hierarchies in Universe design as per the business rule for the reports to be viewed at selected reporting level.
• Build new dynamic variables using Business View Manager for Company Hierarchies in Crystal reports.
• Developed a new application to create monthly online statements in multiple languages using crystal reports.
• Created queries to burst reports using APOS burst tool.
• Involved in upgrade to SAP BO BI 4.0 from XI R2.

Environment: SAP Business Objects XI R2/BI 4.0, BODS XI 3.2/4.1, WEBI, Crystal Reports, Info View, SQL Server 2008/2016, Windows Server 2007, SSIS, MS Visual Studio 2013/2015

Confidential, Greenville, SC

Onsite Manager - Hewlett Packard (SPI)

• Successfully implemented EDI process with Bank of America for financial applications.
• Developed and implemented new check generation process to pay vendors directly and eliminated the third-party check generation expenses.
• Involved in the development of vendor portal to provide the status of payments and invoices for vendors to get the up-to-date details.
• Worked on upgrade of Cyborg application for HR/Payroll systems, 401K and pension process implementation for different unions.
• Provided support, maintenance and development of financial and payroll applications.
• Involved in planning sessions with project managers, business analysts and team members to analyze requirements and outline the solution.
• Involved in coordinating and negotiating with the client and offshore resources during various project phases.
• Successfully completed the projects on time with in the budget.
• Maintained schedules to ensure that key milestones were being met at every phase.
• Successfully managed and implemented the major upgrade project with the offshore team.
• Communicated effectively with all the stake holders and provided accurate information regarding the project status during daily and weekly meetings.
• Provided training, application knowledge transfer and assistance during the project execution and monitoring.
• Involved in preparing estimates using WBS, project schedule, project milestones for all the projects.
• Involved in reviewing the project progress, issue identification, resolution and escalation to the management.
• Adhered to the SEI CMM quality process and standards while executing the project.
• Involved in post-production support and resolved the issues as per the business requirements.

Environment: Cyborg, COBOL, CICS, JCL, VSAM, DB2, Endevor, EDI, AIMS, Control-D and Control-M.

Confidential, Greenville, SC

Consultant

• Developed and implemented on various project for manufacturing applications and supply chain management.
• Coordinated with offshore resources and executed the projects successfully.
• Participated in client meetings to discuss the issues and provided the resolutions.
• Successfully converted and implemented the Y2K changes for manufacturing applications.
• Developed new online screens for TACS (Tire Adjustment and Claim System).

Environment: COBOL, DB2, IDMS, CICS, VSAM, VM, SQL/DS, REXX, Endevor, Intertest

Confidential, Memphis, TN 8

System Analyst

• Involved in analysis and design of the applications.
• Developed new batch and online programs for accounts payable and accounts receivable applications.
• Provided day-to-day support for the accounts payable and accounts receivable applications.