PROFESSIONAL SUMMARY:

• Over 15 years of experience in the IT industry. Main area of expertise in Informatica and Business Objects
• Over 10 years of experience in Data Warehousing, Data Analysis, Reporting, ETL, Data modeling, Development, Maintenance, Testing and Documentation
• Good knowledge in Data Modeling (logical/physical) using Erwin 3.5/4.0
• Used ETL methodology for supporting data extraction, transformation and loading process, in a corporate - wide-ETL Solution using Informatica and other ETL tools
• Experienced in analysis of different systems for system study and data warehouse implementations
• Strong experience in client interaction and understanding business application, business data flow and data relations
• Good experience in leading teams and managing multiple projects
• Good communication, analytical skills and flexible to learn advancements in the IT industry

TECHNICAL SKILLS:

ETL Tools: Informatica 8.6.1/9.0.1/9.5.1/9.6.1 , Informatica BDE, SSIS

OLAP Tools: OBIEE, Business Objects XI R2/XI R3.1.1/4.0, SSRS

Databases: Oracle9i/10g/11g, Sql Server and IBMDB2

Data Modeler Tool: Erwin 3.5/4.0/4.5

Scheduling Tools: Zena, Control-M and DAC

Domain Knowledge: Banking, Finance, Insurance, Telecom, Energy & Retail

Telecom Related Skills: SMS-MO, SMS-MT, GPRS and WAP

Operating Systems: Windows 98/XP/2000/NT/7/8, UNIX and AIX

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, MO

Informatica Consultant

Responsibilities:

• Production support and regular maintenance work fixing data customizing Informatica mappings
• To study and understand business and technical requirements of the system.
• Coordinated the onshore teams for Data mapping Gap analysis, Logical and physical Data model gaps using Erwin 4.5.
• Created the design documents SDS (System Delivery Specification-ETL) and TSD (Technical System Design Document-ETL)
• Prepared the Impact analysis documents for each work requests from the business
• Estimations done on each release based on the work requests
• Shared the work requests to each team members and assigned the work to each team member
• Created the design and test plan documents for each work requests
• Uploaded the designing documents to share point (FRE) for Onsite Team Approval
• Developed Mappings using source Qualifier, Joiner, lookups, Expression aggregator, filter, router, update strategy, transformations
• Created sessions and workflows using Informatica 9.6.1
• Used MDM for single version of truth and used Java SOAP and REST protocols for parsing and validation
• Involved in performance tuning at various levels including target, source mappings and session for large data files.
• Executed Unit Testing and data validations for each work request.
• Prepared the consolidated promote checklists for the QA in testing environment.
• Migrated the mappings from Dev to QA using Informatica repository manager.
• Compared the mappings from Dev to QA before QA run and created the deployments groups
• Implemented the shell scripts, pram files and scheduling the jobs using cron in UNIX to invoke Informatica workflows.
• Conducted regression testing using Informatica (DVO) Data Validation Option tool.
• Prepared the consolidated promote checklists for production environment.
• Prepared the ETL process flow documents for UAT.

Environment: Informatica 9.6.1, MDM, Oracle11g, Erwin 4.5, Toad & UNIX, Java

Confidential, St Louis, MO

Informatica Consultant

Responsibilities:

• Understand the Business requirements and convert into functional and technical specifications and developed maps for Extraction Transformation, Cleansing and Loading process of DW to make the deliverables at appropriate time.
• Did POC for the unstructured data loading like (PDF, Social Media Twitter, weblogs, HTML) into HDFS & Hive environments using Informatica Developer Client & Informatica Big Data Edition (BDE) tools.
• Involved in the designing of the Data Model in deriving Conceptual, Logical and Physical model’ Confidential using Erwin with Architect teams. Defined, and documented the technical architecture of the Data Warehouse, including the physical components and their functionality.
• Contribution includes Requirements gathering, design, development, implementation and Client co-ordination.
• Developing Informatica mappings and enhancing the current functionality of the mappings.
• Extensively worked on creating, executing test procedures, test cases and test scripts using Manual/Automated methods.
• Performing system testing and support in fixing the defects raised in phases of all SIT (System Integration Testing).
• Managing a team of developers to achieve the project specific goals.

Environment: Informatica 9.6.1, Informatica BDE, Erwin 4.5, Oracle11g, Toad & UNIX

Confidential, Carmel, IN

Informatica Consultant

Responsibilities:

• Maintenance and support of existing OBIA/DAC implementation as administrator
• ETL and OBIEE design reviews and validations
• Master data management and data reconciliation testing
• Customized reconciliation summary and performance analysis reports
• Source data analysis and profiling
• Design and development of Informatica mappings
• MSAD integration for external authentication
• Security implementation and authorization to subject areas, reports and dashboards as per security role
• Migration of rpd, reports, dashboards through different environments and production validation
• Configuration and customization of financial reports
• Developed Essbase cubes for ad-hoc reporting and performance gain
• Customized Income statement and Balance sheet statement Dashboards
• Developed spend analytics webi reports and implemented data level security
• Configuring OBIA, Data warehouse Console (DAC) and Informatica
• Developed unix scripts for data validation, data loading
• Developed unix scripts to maintain Informatica services
• DAC scheduling for full and incremental loads
• Analyzed Discoverer reports needed for conversion to OBIEE
• Conversion of Discoverer reports to OBIEE
• Implementation of financial, Procurement and Spend module analytics

Environment: OBIEE 11g/OBIA, Informatica 9.x, Erwin, SQL developer, DAC, Discoverer, TOAD

Confidential, Chicago, IL

Informatica Architect

Responsibilities:

• System study and analysis of as-is system
• ETL and OBIEE design reviews and validations
• Master data management and data reconciliation testing
• Source data analysis and profiling
• Identifying the granularity and validation of data warehouse and data mart models
• Customizing/extending OBIA pre-built content
• Developed and customized PTD,QTD and YTD financial reports to compare budget numbers
• Design and development of Essbase cubes
• String testing of data from source to stage, stage to data warehouse and from data warehouse to data mart
• Implementation of Sales analytics, Inventory analytics and Procurement analytics modules
• Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client

Environment: Informatica 9.x, Erwin, SQL developer, AS/400, SSIS, Discoverer

Confidential, Boston, MA

Informatica Consultant

Responsibilities:

• Manage and participate in all phases of the implementation lifecycle
• Requirement and Technical specification documentation
• Estimation and execution of different modules of project
• Enhancement of the existing model to support history and new peoplesoft tables for analytical reporting
• Customizing seeded ETL mappings and developed new ETL mappings to match the reporting requirements
• Did performance tuning
• Extensively used Informatica mappings for data loading and data reconciliation
• Developed Mappings using source Qualifier, Joiner, lookups, Expression aggregator, filter, router, update strategy, transformations
• Implemented the CDC logic according to the Business requirements
• Did code reviews, technical and functional document reviews
• Implemented object level and data level security based on user login profiles
• Developed financial module reports/Dashboards related to A/R, A/P, Trial Balance and G/L
• Developed Asset management and portfolio management reports
• Unit testing, Regression testing, Integration testing, Implementation and support
• Monitored incremental and full load of data extraction through Data Warehouse Administration Console (DAC) and Informatica

Environment: Informatica 9.x, PeopleSoft Financials 9.x, People Soft HRMS 9.x, DAC

Confidential, NY

BI Consultant

Responsibilities:

• Manage and participate in all phases of the implementation lifecycle
• Estimated work effort for delivery schedule
• Mentoring team members
• Implemented and customized financial analytics
• Identified the granularity level of the data required to be available for analysis
• Developed hierarchies, dimensions, and aggregates in BMM layer and presentation layer
• Developed and implemented ragged and skip level hierarchies in financial ratings reports
• Developed interactive reports with dynamic grouping and custom hierarchies
• Developed data visualizations for profiling
• Did performance tuning of the system
• Developed master detail linking compliance reports
• Developed Interactive Dashboards with drill-down
• Implemented best practices during physical and business layer design for developing intuitive reports
• Did code reviews, technical and functional document reviews
• Developed finance reports using BI publisher using different data sources
• Implemented object level and data level security
• Configured Agents to send the Reports through Emails to the user group

Environment: OBIEE 11g, SCM, Informatica 9.x/8.x, Erwin, Unix, SQL

Confidential, CA

Sr BI Analyst

Responsibilities:

• Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Created new logical measures required as per the business requirements
• Leading teams, project estimations and execution
• Implementation of financial analytics
• Development and maintenance of Exposure and Breach OBIEE Dashboard reports
• Developed enterprise BI reports(List, crosstab, funnel, chart)
• Developed interactive reports with drill downs using OBIEE Business layer hierarchy
• Preparing the Documentation for the mapping according to the designed logic used in the mapping
• Developed Source-Target mappings for the transformations needed for data load
• Implementing the breach logic during transformations in ETL
• Performance tuning of the system
• Used SQL, PL/SQL for data validations, data extraction from different data sources
• Application administration and support
• Developed BI publisher auto mail reports
• Document Administration environment and support processes

Environment: OBIEE 11g, Informatica 8.x, Erwin, Answers, Dashboards, Unix, SQL, Oracle EBS

Confidential, Rockland, MA

BI Consultant

Responsibilities:

• Developed the functional and technical specification documents for PCD analytics solution
• Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE
• Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.
• Development and unit testing of Analytical dashboards/reports which were developed for various hierarchies in the organization
• Implemented and tested the data level security on analytic dashboards/reports
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner
• Created iBots to deliver scheduled reports with the desired frequency
• Create backup and recovery processes for critical components
• Worked with Oracle data integrator(ODI) for data transformations and loading

Environment: OBIEE 10.x, Answers, Dashboards, ODI

Confidential, Pittsburgh, PA

BI Consultant

Responsibilities:

• End to end implementation of DWBI system
• Requirement study, analysis, architecture and report development
• Developed mappings and transformation in Informatica for data load
• Developed OBIEE 10.x repository
• Developed Physical and Business layer, was involved in developing complex parameterized, interactive reports
• Created business reports using BI Answers as per requirements
• Generated various Analytics Reports using global and local filters
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates
• Implemented Security Features of like row level, object level and report level to make the data secure
• Developed different Dashboards/Reports with different view (Calculation, Detailed, Pivot, Charts, Filters) and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Answers.

Environment: OBIEE 10.x, Informatica, Dashboards, Answers

Confidential

DWBI developer

Responsibilities:

• Tool evaluations, proposals, building competencies and accelerators.
• Tool comparisons and beta testing of BI tools
• Developed point solutions for Banking and finance domains with Dashboards and Scorecards
• Pre sales activities and BI tool selections

Environment: OBIEE, Informatica, BO XI R2/R3, Informatica