SUMMARY

• An IT professional with over 8 years of experience in Business Intelligence Applications using Business Objects, Xcelsius 2008, Crystal Reports, Tableau, Oracle and Informatica Power Center within several business areas including Engineering, Pharma, Sales/Marketing, Medical, Learning & Development, Aviation and Federal.
• Over 8 years of rich experience in Business Objects (BI 4.1 & XI R3.1 - BOBJ) - Universe (UDT and IDT), Web Intelligence, Rich Client and Dashboards/Xcelsius 2008.
• MS EXCEL: Experience in validating and analyzing data in worksheets using sorting, filtering, Vlookup and charts.
• Has involved and led all phases in Business Intelligence / Data warehousing area - Business Requirement gatherings, Analysis, Proof of Concept(POC), data modeling/database design, project documentation & estimation, data integration / ETL development, Reports/Dashboards development, testing, user training, enhancement and performance tuning.
• Good Knowledge in Data warehousing concepts.
• Expertise in working with relational databases such as oracle 10g/9i/8i and SQL Server 2005.
• Extensive experience in developing Stored Procedures, Functions, Views, Triggers and Complex SQL queries using Oracle PL/SQL.
• Good experience in creating reports using SAP Crystal Reports 2008.
• Hands-on-experience in working with Microstrategy 10 and Tableau as part of an organizational Proof of Concept.
• Expertise in debugging and optimizing the Business Objects universes, WEBI Reports, Xcelsius Dashboards and Informatica mappings / workflows.
• Strong knowledge on OLAP, ROLAP, MOLAP, OLTP, Star Schema and Snowflake Schema.
• Implemented projects in various project methodologies - ASAP, Agile and Waterfall.
• Integrated reports and dashboards to web portals.
• Experience in interacting with end users and providing training for them on developed reports and dashboards.

TECHNICAL SKILLS

ETL / Reporting: Business Objects (BI 4.1, BI 4.0, XI R3.1 and XI R2) Web Intelligence, Rich Client, Universe Design Tool (UDT), Information Design Tool (IDT)Universe Designer, SAP Business Objects Dashboards (Xcelsius 2008), Crystal Reports 2008, MicroStrategy, Tableau and Informatica PowerCenter 7.1.9/9.1.6.

Databases: Oracle (10g/9i/8i) and SQL Server 2005.

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Senior Business Objects Consultant

Responsibilities:

• Interacted with the business users to understand the requirements.
• Analyzed the business requirements and designed the best suited solution.
• Prepared the project proposal documentation and implementation plan as per Agile methodology.
• Preparing Business Objects-Database mapping document.
• Act as an SME for BI reporting team for resolving technical complexities.
• Provide support to Business Objects(BOBJ) enterprise environment.
• Provide support in building and tuning complex SQL statements.
• Involving in dimensional data modeling.
• Involved in developing Business Objects universe using SAP Business Objects Universe Design Tool.
• Involved in creating OFLC management reports using SAP Business Objects Web Intelligence (WEBI) reporting tool.
• Developed Tableau dashboards for higher management in Agile methodology.
• Provide expertise in advance analysis, SOA design, development, implementation, deployment, and maintenance of BI applications
• Support application development and architecture using Business Objects.

Environment: SAP Business Objects BI 4.1, Oracle 11g

Confidential

Data Warehousing / Business Objects Lead

Responsibilities:

• Gathered business requirements and understood the existing business processes related to HR Employee Services (HRES) business.
• Analyze the requirements and Create URS and SOW documents, estimation sheets and getting sign off from the end users.
• Involved in analyzing and development of the Data Warehouse.
• Involved in Relational and Dimensional Data Modeling Techniques to design ERWIN data models.
• Created technical design specifications for mappings, sessions, workflows, etc.
• Worked on different OLTP data sources such as Oracle, SQL Server and Flat files for data extraction.
• Created complex mappings in Informatica PowerCenter Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Sorter, Lookup, Joiner transformations etc.,
• Implemented Type II slowly changing dimensions using date-time stamping.
• Created reusable transformations and mapplets to reuse while creating ETL mappings.
• Configured and used the Debugger to troubleshoot the Informatica mappings.
• Proficient in using Informatica workflow manager, workflow monitor, pmcmd (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Worked with DBA team to fix performance issues at Database.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Preparing BO-Database mapping document.
• Change the existing Universe to support development of the new WebI reports using Business Objects.
• Developed 50+ Web Intelligence reports and 20+ Dashboards.
• Testing and supporting UAT for the developed reports.
• Followed best practices and guided the client in preparing their BI road-map.
• Prepared user guide for SAP Business Objects application.
• Trained client side end users to be the power users in creating adhoc reports.
• Created Lumira analytical views for higher management using multi data sets.
• Promoted the content to Production environment and supported Production validation.
• Providing post-production support after promote.
• Created PL/SQL packages to support development of highly summarized management dashboards.
• Developed KPI dashboards using Xcelsius 2008 and Tableau.
• Designed Tableau workbooks, tableau reports and dashboards.
• Developed Reports and Dashboards in Agile methodology.

Environment: SAP Business Objects BI 4.1, Xcelsius 2008, Microstrategy10, Informatica 9.1.6, and Oracle 11g

Confidential

Business Objects/Crystal Reports Developer

Responsibilities:

• Collaborate effectively with operations Managers and Business Analysts to gather requirements.
• Design, Develop and test Crystal Reports based on detailed specifications.
• Creating project related documents and testing documents, release notes, Change request forms as per industry standards.
• Develop and test PL/SQL code for developed crystal reports using Oracle PL/SQL Developer.
• Propose and design optimized solution for complex reports using analytical and specialized technical skills.
• Modifying existing complex reports based on functional changes.
• Create parameterized crystal reports using tables, queries and verify joins between them.
• Created crystal reports for Details, Summary, Cross-tab reports using filters, Sorting, Groupings based on different fields.
• Format reports in Crystal Design before moving to Production.
• Participate and contribute in daily SCRUM meetings to achieve organizational goal as team and as an individual.

Environment: SAP Business Objects BI 4.1, Crystal Reports 2008 and Oracle 11g

Confidential

Business Objects / Xcelsius Developer

Responsibilities:

• Analyzing the Client Requirements and preparing the Healthcare Payer Dashboard specification document.
• Worked on modification of Universes.
• Developed WebI reports using various functions, operators, report filters and variables.
• Developed the WebI reports and created live office objects to these reports.
• Worked on Conceptual design of the Dashboard.
• Involved in Data Connectivity to the databases using Query as a Web Service (QaaWS) connections and XML connections.
• Worked on the Performance tuning of the Dashboard.
• Worked on Designing the Dashboard according to Color style guide given by client.
• Conducted Unit Testing of the Dashboard.
• Worked on Change Requests of the existing Dashboards.

Environment: SAP Business Objects BI 4.1, Xcelsius 2008 and Oracle 10g

Confidential

Business Objects Developer

Responsibilities:

• Creating WEBI reports according to the business requirements/ rules using Business Objects WEBI.
• Communicating with the onshore people in understanding the healthcare requirements.
• Involved in developing the Business Objects universes and implementing the universe features to improve the performance using Business Objects Enterprise universe designer tool.
• Making change in the Business Objects universe level to add more objects or to do some modifications in the universe level.
• Involved in creating web intelligence (WEBI) reports.
• Implementing CRP Changes as per client.
• Linking universes as per the end user requirements.
• Involved in ST / UAT phases and resolving bugs for the tickets raised through JIRA.

Environment: SAP Business Objects BI 4.1 and Oracle 10g

Confidential

Informatica ETL Developer

Responsibilities:

• Gathered business requirements from Business users.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources.
• Designed and developed Informatica ETL mappings to extract master and transactional data from multiple source systems.
• Installed and Configured the Informatica Client tools.
• Worked on loading of data from several flat files to XML Targets.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.

Environment: Informatica Powercenter and Oracle 10g

Confidential

PL/SQL and Informatica ETL Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Powercenter and Oracle 11g