SUMMARY:

• Over 16 years of experience in the Analysis, Design and development and maintenance of Business Intelligence applications, ETL and wide range of RDBMS including ORACLE, SQL Server, DB2, Green Plum. Responsible for all activities related to the development, implementation, and support of BI Reporting solutions for large - scale data warehouses.
• Expertise in Universe designing, developing and generating complex and adhoc reports, List of values along with User Acceptance Test and data accuracy Test. Experience as an ETL developer using Informatica, Talend and Ab Initio. Knowledge of Data Warehousing concepts and principles. Experience working in Agile Environment.

TECHNICAL SKILLS:

BI Tools: SAP Business Objects 4.2/4.1/4.0/XI R3, Information Design Tool (IDT) and Dashboard 4.0, Tableau 7.X/8.0, Cognos

Languages: C/C++, Visual Basic 5.0/6.0, VBA, MS IIS Server, HTML/DHTML, XML, Stored Procedures, Triggers, Packages, T - SQL, SQL*Loader, PL/SQL, JCL, COBOL

Databases: MS-SQL-Server 2005 and 2008, Oracle 7.x/9i/10g, GUI Tools Oracle Toad, Green Plum, DB2

ETL Tools: Informatica, Ab Initio, Talend

PROFESSIONAL EXPERIENCE:

Confidential, New Carrollton, MD

Lead Business Objects Developer

Responsibilities:

• Supported FACTA project as Lead Business Objects developer.
• Developed and maintained Business Objects reports for Confidential and QI Releases.
• Reviewed requirements and translate into technical tasks using Business Objects.
• Provided Business Objects recommendations on developing and deploying Business Objects Universe that allows for LB&I to develop the reports necessary for FFI Registration R1.1.
• Worked with business management to ensure business objects are appropriately utilized for LB&I Confidential reporting, management reporting and ad hoc reporting.
• Creates and coordinates the continued development and enhancement of Business Object Universes. Supervises and offers technical advice to Business Object developers.
• Deployed Universe and Reports to higher environments and assisted with deployment activities exporting BIAR files.
• Ensured formatting of data or views between DB2 and Business Objects Universe to ensure continued relevancy of data and implement necessary data refreshing.
• Provided/Trained Business stakeholders/users giving informative sessions about the functionality and capability of Business Objects.
• Responsible for unit, integration, stress/load testing of reports and dashboards to ensure functional and performance requirements are met.
• Directly and through subordinates, manages the Business Object development that defined report creation.
• Supervised Business Objects Developers, assigned, and reviewed work; provides guidance and to assigned staff.

Confidential

Report development SAP Business Objects

Responsibilities:

• Supported the creation and development of ACA IS&R Business Objects reporting.
• Involved in requirements gathering, creating technical specifications for designing Universes and Reports.
• Used Agile approach to elicit and refine requirements through an iterative process of planning, defining acceptance criteria, prioritizing, developing and reviewing the results.
• Developed report prototypes and fine tune report deliverables.
• Developed Universes and number of reports, created report design documents.
• Involved in defining and preparing solutions for O&M changes to existing reports.
• Participated in full life cycle of BI development including requirements gathering, design, development, testing, deployment and providing end user support.
• Performed Unit testing and validation of Business Objects Reports and Universes.
• Scheduled reports for distribution and provided ongoing production support of Business Objects reporting environment.
• Written sql in Green Plum using PG Admin to Unit Test Reports data.

Confidential, Ashburn, VA

ELT Developer

Responsibilities:

• Supported ARIA EDW project at Confidential .
• Involved in designing ETL processes and develop source to target data mappings using Informatica.
• Actively involved with business users in preparing source to target mapping document to design EDW.
• Implemented SCD Type 2-dimension mapping for inserting/updating target tables in DW.
• Conducted meetings with key business team to understand Confidential ’s current data and systems environment.
• Designed Staging Database and PDS Database. Mr. Confidential also administered and maintained the ETL environment.

Confidential, Washington, DC

Enterprise Data Warehouse

Responsibilities:

• Supported NEPDW project for Confidential (DOE) as a lead Informatica developer.
• Analyzed the functional specs provided by the data architect and created technical specs documents for the ETL process.
• Developed complex mappings, created workflow connections, session parameter files.
• Worked closely with QA team during the testing phase and fixed bugs that were reported.
• Worked with Informatica Best Practices guidelines for tuning of ETL mappings, targets, sources and minimize performance issues.
• Implemented SCD Type 2-dimension mapping for inserting/updating target tables in DW.

Confidential, Rockville, MD

Drug Administration

Responsibilities:

• Supported Confidential project for Confidential Drug Administration( Confidential ) as Business Objects developer.
• Performed design, analysis, development, maintenance, optimization and troubleshooting of Desktop Intelligence and Web Intelligence reports he functional specs provided by the data architect and created technical specs documents for the ETL process.
• Performed design, analysis, development, maintenance, optimization and troubleshooting of Desktop Intelligence and Web Intelligence reports.
• Migrated Shelf Life Application SQR reports to the Pre-Prod/Prod environment as part of ICT21 migration, DPEM PAC and TBL 7e Oracle utilities to Production Environment.
• Created Release Package/Deployment Instructions document for Shelf Life, DPEM PAC and TBL7e oracle forms applications for migration into Production Environments

Confidential, Rockville, MD

Drug Administration

Responsibilities:

• Supported Confidential project for Confidential Drug Administration( Confidential ) as Lead Business Objects developer.
• Performed Optimization and conversion of 30+ of Oracle forms Reports to Business Objects Reports.
• Integrated Business Objects with JAVA interface to call BO reports from JAVA application.
• Designed and created Confidential Universe to meet reporting requirements.
• Mentored Team members in Business Objects reports and Universe Design. Also coordinated in migration/deployment of Universes and reports to Test and Production Environment.

Confidential, Arlington, VA

Claims Administration System

Responsibilities:

• Supported Confidential project for Confidential by leading full life cycle design and development of Business Objects Reporting.
• Designed, developed and delivery of Universe and 30 Business Objects Reports.
• Integrated Business Objects with PEGA interface to call Business Objects reports thru PEGA online applications.
• Integrated Business Objects with PEGA interface to call Business Objects reports thru PEGA online applications.
• Developed User documentation guide for end users .