SUMMARY:

• 16 years of IT experience in all stages of the Project lifecycle from Requirements Gathering, Analysis and Design, Development, Testing, Deployment, Support, Education and Documentation of end to end Enterprise Data Warehousing solutions
• 14 + years of Informatica Architect/Development experience in providing solution by analyzing client operations, applications, programming and evaluating current systems. Developed integration solutions by designing proposed system, database physical structure, Informatica Mappings and functional capabilities.
• 10 + years of experience in Business Objects Reports and Dash Boards development using SAP Business Objects Enterprise 4.1/4.0/3.1/R2 versions, Web Intelligence, Rich Client, Dashboard Designer, Xcelsius 2008, Query as a Web Service and Live Office applications.
• 5 + years of experience in SAP BI/BW in SAP Info Cube Modeling, Data Extraction from SAP ECC, Generic extractors, BEx Reporting and HANA data modeling using Attribute View, Analytic View and Calculation View.
• 3 + years of experience in Cognos Reporting and Tableau dashboard designing and development
• Implemented solutions and made modifications and enhancements to existing hardware/software applications or a suite of integrated systems.
• Provided/reviewed data integration solution (Quality Review for ETL design and ETL code) for application development/production teams
• Domains worked - Pharmaceuticals, Financial Services, Insurance and Power System Applications.
• Experienced in defining Roadmap, providing Solutions, Architecting, Modeling, Designing and Developing Database, Data warehouse and Business Intelligence Applications
• Strong Data Warehousing ETL experience of using Informatica 10.1/9.5/9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Worked extensively in End to End Data warehousing Projects using Data Integration tools like Informatica and AbInitio and BI Tools like SAP BO, OBIEE, Cognos and Hyperion
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Experience in designing and implementation of data architecture solutions
• Translated business and data requirements into logical data models in support of Enterprise data models. Developed dimensional modeling constructs and maintained DW business matrix architecture.
• Maintained data mapping documents, business matrix and other design artifacts that defines technical data specifications and transformation rules
• Experience in installation, administration and upgrading Informatica and Business Objects on Windows and Unix Servers.
• Good experience in SAP HANA data modeling on designing and creating Attribute View, Analytic View, Calculation View, multiple schemas and table definitions.
• Developed and prepared written project plans addressing, tasks, roles and responsibilities, risk, resources, budget, communications, quality and organization.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.1/9.5/9.1/9/8 , SAP BW, SAP HANA, BO Data Services and AB Initio

Reporting: Business Objects Enterprise (4.1 SP4 / SP3 / 4.0 / 3.X / XI R2 / 6.0), IDT, Designer, Web Intelligence, Rich Client, BO Explorer 4.x, Dashboard Designer/Xcelsius, QAAWS, Live Office, OBIEE 10g, Cognos 10, Hyperion and Tableau

SAP: SAP HANA, SAP BI 7.3/7.0,SAP ECC 6.0 and BEx

Databases: Oracle 11G/10G/9I, SQL Server 7.0/6.5

O/S: Windows server 2008/2003 and Linux 6/2.x

Languages: SQL, PL/SQL, SQL Loader

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Sr. BI Lead / Developer / Tester

Responsibilities:

• Translated complex business requirements into scalable technical solutions meeting Data warehousing standards
• Completed data modeling and database design & development using ETL techniques
• Interacting with Business Users to analyze the business process and requirements and transforming requirements into screens, designing/analyzing database and documenting
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems
• Done creation of ETL frame work and review of high level design document
• 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.
• Worked with the business management to ensure business objects are appropriately utilized for all required management and adhoc reporting, as well as data extracts for shared data agreements.
• Designed and Developed UI reporting solutions like Executive dashboards is a big plus
• Lead onsite and offshore team for tracking solution and development.

Environment: Informatica 10.1 / 9.6, Business Objects XI 4.2 SP2, Lumira 1.3, Tableau 10.4, Informatica 10, Oracle 11g and Linux

Confidential, CA

Sr. BI Solution Architect/Developer

Responsibilities:

• Responsible for planning, directing and coordinating the appropriate life cycle phases for implementation and support for one large and multiple small projects.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Involved and ETL job deployments in various domains and designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Assisted in building the ETL source to Target specification documents by understanding the business requirements
• Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings
• Reusable transformations and Mapplets are built wherever redundancy is needed
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput
• Partnered with stakeholders and source system owners to gather business requirements for Inventory and Sales Data into the Data warehouse.
• Created filters, prompts, calculations and determinants for efficient data retrieval and analysis using Cognos.
• Created parameter maps; stored procedures for importing as data source, checked for corrupted models and restored to original.
• Proficient in Report building using Report Studio, and Analysis Studio.
• Created List, Crosstab and Drill-Through reports using Report Studio.
• Created Ad-Hoc reports using Query Studio.
• Designed warehouse Reports that meet the Field and Management delivery needs of business intelligence systems
• Currently leading and managing an enterprise-wide effort of identifying the Key Performance Indicators (KPIs) across all the domains of the organization. These KPIs will be used to develop a corporate dashboard to facilitate fact based decision making.
• Extensive experience with Business Objects security architecture/configuration, Business Contingency/Disaster Recovery, and backup/restore process administration.
• As part of requirements gathering capturing and managing business definitions/ metadata.

Environment: Informatica 9.5. Business Objects XI 4.2 SP2, Cognos 10, Lumira 1.28, SAP BW, Crystal Reports 2013, Teradata, SQL Server 2008 R2, Qlik View 12/11 and Linux 2.6

Confidential, NY

DW Architect

Responsibilities:

• As part of the Batch Stabilization and Optimization Program we built a data repository to store metrics around batch job schedules, executions and abend/exception tickets to facilitate analytical and management Reporting.
• Data Structures we built are capable of supporting standard and ad-hoc reporting, providing actionable intelligence via real-time batch performance reporting, consolidated RFB and Incident Management Reporting
• Designed Master list of metadata for all application areas, batch systems and jobs to define actual critical paths, dashboard analytics for executive management and real-time monitoring reports.
• Reviewed and analyzed ETL requirements, created design documents based on business requirement and function requirement documents
• Experience building/implementing scalable, reliable, and high-performance ETL architectures
• Proficiency with RDBMS systems, SQL, Oracle PL/SQL, UNIX shell scripting, and database optimizations
• Designed, developed and tested ETL processes to interface data from multiple internal and external systems. Developed ETL jobs that satisfy identified data model and business requirements.
• Designed and maintained complex Informatica ETL Mappings that supports business requirements and provide fast performance
• Provided solution to the team in the development of Informatica framework and scheduled the jobs in Autosys
• Involved in creation of Change Management Process and make sure that the right code is moved to QA and production
• Worked with Business Intelligence Operations team to ensure control objectives are implemented for all data movement processes, implement change control for production data, establish and follow proper incident management procedures
• Designed & Developed BSM Reports that meet the Field and Management delivery needs of business intelligence systems
• Provided solution to the team in the development of business objects framework for reporting, dashboards, delivery and scheduling for complex information systems
• Functioned with the business users to ensure business objects reports and dash boards are appropriately utilized for all required management and ad-hoc reporting as well as data extracts for shared data agreements.
• Involved in gathering, analyzing, and documenting user requirements and data specifications for developing Business Objects Universes and Reports

Environment: Informatica 9.5, Business Objects XI 4.1 SP6, Oracle 11g, SQL Server 2008 R2 and Linux 2.6

Confidential, NY

ETL / BO Consultant

Responsibilities:

• Designed Confidential data integration application and mapping the business requirements to systems/technical requirements and works as a team member to deliver the complete solution for the application.
• Installed, configured and administered the Informatica server. And responsible for keeping the Informatica server software up to date and patched
• Provided Informatica user administration and Informatica server tuning
• Participated in all phases of ETL development on assigned projects including reviewing technical documentation, allocating ETL development work, conducting design reviews, coordinating packaging and release deployments and testing of solutions in highly complex environments with high volume of projects and changes in flight
• Worked with developers, business analysts, and DBAs to develop and implement ETL solutions.
• Designed the ETL mappings and defining the strategies for the data migration, Planning and execution.
• Designed & Implemented Confidential Reports that meet the information delivery needs of business intelligence systems
• Generated Complex reports in Cognos 10.1 report studio including Drill Down reports from DMR modeled Frame work model.
• Created Dashboards to present critical company data in a single report.
• Created list reports & cross tab reports using Cognos 10.1
• Manually modified the SQL in ReportStudio to tune and/or to write complicated reports. Used union/Join objects in ReportStudio
• Experience in developing Framework Manager Models and analyzed those models in analysis studio.
• Performed technical and advisory functions in the development of business objects architecture and the creation of framework for reporting, dashboards, delivery, scheduling and object retention policies for complex information systems
• Worked with the business management to ensure business objects reports and dash boards are appropriately utilized for all required management and ad-hoc reporting as well as data extracts for shared data agreements.

Environment: Informatica 9.5, Cognos 10.1, Oracle 11g, Teradata and Linux 6x

Confidential, NJ

Sr. Informatica and BI Consultant

Responsibilities:

• Designed, developed and tested ETL processes to interface data from multiple internal and external systems.
• Developed ETL jobs that satisfy identified data model and business requirements.
• Participated in the design sessions. Collaborated in the planning, design, development, and deployment of new functionality, and enhancements.
• Created system design documents and created systems models, specifications, diagrams, and charts to provide direction to business and other IT teams.
• Performed in-depth tests, including end-user reviews, for changes to the system, and other post-implementation support.
• Managed the creation, review, and approval process for BRD (Business Requirements Document).
• Maintained technical support documentation. Performed other related duties as assigned.
• Maintained Training documents and keep them updated based on System/Process changes.
• Managed the ETL environment with regular updates and different Data Quality transforms in Informatica like Address cleanse, Data cleanse, Data transport, Table comparison and Mapping Operations etc.
• Lead and Participated in strategy, analysis, design, development, testing, deployment & support of Business objects solutions for multiple subject areas in Canada BI
• Involved in gathering, analyzing, and documenting User Requirements, and data specifications for developing Business Objects Universes and Reports.
• Guided and played key role in business requirements, BO Universe and Reports design document preparation, data dictionary and DDL scripts.
• Involved in creation of Web Intelligence Reports with different functionalities like Dynamic cascading prompts, drill down, linking reports, charts and graphs, ranking and alerts.
• Responsible in BO security model setup for setting up security at application level, user level, folder level, group level, universes and application level using CMC
• Conducted user meetings and project planning sessions to analyze business requirements and outline the proposed solution.
• Involved in creating complex reports using Web Intelligence 3.1 in CICB Project.
• Created RoamBI Views for multiple projects by RoamBI publisher to display BO WebI Reports in iPad and iPhone.
• Converted BO Reports into Mobile Reports by using SAP Mobi tool and Roambi.
• Scheduled, Bursted WebI Reports and converted into Roambi views in Infoburst application
• Developed BEx Queries for MDS and Nulojix Reporting
• Created multiple BO Auditing Reports to get all different kinds of Statistics for TopLine Users and Customer 360 Users.
• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Involved in gathering, analyzing, and documenting User Requirements, and data specifications for developing Business Objects Universes and Reports.
• Created standard Rich client/WebI reports, created canned and ad-hoc Reports Using Business Objects user module.
• Involved in different phases of testing like Unit Testing and in UAT.
• Provided the go-live support and solved the production issues on priority.
• Prepared Test Plans for testing BO Reports in HP Quality Center Tool and Tested reports before posting them to the repository.

Confidential, PA

Senior BI Consultant

Responsibilities:

• Involved in gathering Dash board requirements from Higher Level Executives.
• Designed and developed the OBIEE Metadata Repository including the physical layer, business model, mapping and presentation layer for various subject areas
• Designed, developed and configured Dashboards, Answers requests, prompts, and BI Publisher reports as per user requirements
• Installed and configured BO XI3.1 Servers, Clustering and administration of Business Objects servers.
• Extensively worked on Business Objects upgrade, migration and issues related to it.
• Supporting and maintaining the Business Objects servers and application suite.
• Involved in Designing and developing Xcelsius Dashboards for Generic Adderall XR product in Confidential .
• Exclusively Used Xcelsius, Live Office as per the Dash board requirements.
• Created various ad-hoc Reports to provide Technical Support for Sales Analysis Services.
• Developed complex Reports with Multiple Data providers on IMS Data Source which includes Data Analysis using Merging Dimensions in Reports.
• Prepared technical documentation for all Dashboards and reports.

Environment: OBIEE 10g, Xcelsius 2008, Business Objects XIR3, BO Designer, InfoView, QAAWS, Live Office, SQL Server, Windows 2003

Confidential, NJ

SAP ETL/BI Consultant

Responsibilities:

• Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
• Defined and worked with mapping parameters and variables.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Performed the performance evaluation of the ETL for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Created test cases for unit testing and functional testing.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.
• Involved in various activities of the project like business requirements gathering, designing, documenting, developing, testing and deploying the Reports & Dashboards.
• Participated in project planning sessions with project manager and team members
• Done the upgrades and migration from BO 6.1 to BO XIR2 to move all the Security, Universes and Documents and tested all the migrated reports and documented the validated results
• Planned and implemented XIR2 security model through CMC.
• Created universes based on the user requirements for different business units like Managed Market Reporting Users, Atlas Users and iPLAN Users.
• Good experience with Crystal Xcelsius dynamic data presentation, Query as a Web Service (QAAWS) and Live Office tools.
• Provided Reports & dashboards for ATLAS business intelligence by using Crystal Xcelsius and WebI Reports for HCM group. Developed multiple dashboards to analyze NRx / TRx Volumes by Channel, Share within Channel, Key Responsibilities and Share Change within Channel information in Crystal Xcelsius application.

Environment: Informatica Power 8, Center Business Objects XIR2, Crystal Xcelsius & SAP BI7.0

Confidential, CT

SAP BO Administrator/Designer

Responsibilities:

• Installed and configured BO XIR2 in Development server on windows and Production server on UNIX.
• Done the migration from BO 5.1 to BO XIR2 to move all the Universes, Reports.
• Interacted with Business Users and Business Owners to know their Business views in developing and modifying Universes and Reports accordingly
• Designed and developed summary tables to convert Hyperion Essbase Cubes (MOLAP) into Business Objects XIR2 (ROLAP).
• Involved in the designing and Building of Universes, Classes and Aggregate awareness objects.
• Upgraded Business Objects Universes, Users and user groups, and reports from Version 5.x to Version BO XIR2 using the Import Wizard.
• Involved in migration and deployment of the universes and reports across multiple domains.
• Created and customized application dashboards using Performance Manager to meet the requirements of higher level analysis.

Environment: Business Objects XIR2, InfoView, Hyperion Essbase / Analyzer and AbInitio