SUMMARY

• A good team player with excellent Communication, Problem Solving, and Analytical abilities having 10 Years of Cumulative experience in Dimensional Data Modeling
• Hands on good ETL applications like Informatics Power Centre, Oracle Warehouse Builder, Oracle Data Integrator
• Possess Good Functional and technical knowledge with end to end implementation of Data Warehouse and report development lifecycle
• Experienced in Data Analysis, Data Migrations, Data Profiling and Data quality and Data Cleansing
• Integrate data from multiple source into Data Warehouse through ETL methodologies
• Hands on Experience in Dimensional Data Modeling, Creation of Star Schema with knowledge of Confidential 's Data Modeling Concepts
• Well experienced in creating Packages, Designing and Optimizing queries in SQL and Pl/SQL
• Design and build ETL processes to create an Operational Data store and ETL for relational reporting

Areas of strength

• Banking and Finance
• Logistics
• Incident Management
• Telecom
• Change Management
• M2M Platform
• Supply Chain Management
• Health Care
• Problem Management

TECHNICAL SKILLS

Operating Systems: MS - WINDOWS XP/2000 Prof. MS-WINDOWS NT/2000/2003, AIX 5.2/6.1

Oracle Technologies: SQL, PL/SQL, SQL * Loader

ETL Tools: Oracle Warehouse Builder 11g R2, Informatica Power Center 8.6.1

BI Reporting Tools: Business Objects X1 4.0, R3, R2, Crystal Reports 8, OBIEE, Discoverer

Databases: MS Access, MS SQL SERVER 2000/2005/2008 , Oracle 10g, DB2

Database Tools: PL/SQL Developer 5.1, TOAD 9.5, and SQL*Loader

Scripting Languages: SQL / PLSQLConcepts SDLC Methodology (Waterfall, Agile), RDBMS

PROFESSIONAL EXPERIENCE

Confidential, Albany NY

DWH Architect

Responsibilities:

• Providing Solution, Development and support for the full Systems Development Life-Cycle (SDLC) for Data Warehouse Application
• Responsible for creating and converting BRDs and FRds in to Technical Specs
• Developed aConceptual modelusing Erwin based on requirements analysis
• DevelopedData Mapping, TransformationandData qualityrules for the MDW
• Performed Data Analysis related to Medicare Data Warehouse and create mapping documents
• Provide solutions to implement the ETL logic using OWB application
• Wrote complex queries to analyze the data in order to achieve the accuracy for loading
• Create procedures and views to generate Data Delivery Extracts
• Responsible for analyzing and loading Data from Other External Sources like Flat Files
• Identifying the Changing Dimensions and Implemented the SCD of Type 2 data
• Performed Data Mining,, Data Migration and Validation of Data

Confidential, Herndon VA

DWH Architect

Responsibilities:

• Crated BI Mapping documents and Report Specifications
• Data Analysis of the existing Multi Family TM system Identified the Dimensions, Measures and Identified cubes
• Created BI Metric document identified required attributes from existing MMB reports and mapped to BI Metric sheet
• Analyzed BI tool by interacting with Multiple vendors and Stake holders and produced BI MATRIX evaluation template
• Performed System Analysis, Data Analysis and successfully created mapping specs, Solution Specs and design documents
• Worked closely with the Multifamily Business for implementing the DWH realease1
• Responsible for handling the requirement through IBM DOORS and successfully generated the RTM
• Created mapping document for designing Informatica Maps for Analyst self service utility
• Analyzing business requirements related to Multiple Data warehouse Applications and create maps in Informatica Power Centre
• Successfully performed the System Analysis for Enterprise Data Quality team in the Single Family business handled complex queries and generated various documents
• Created Profiles and Data Quality Rules using IDQ Analyst application
• Created a User Guide for DQ Analyst Self-Service utility analyzing multiple systems
• Designed UA Test Plan document and created UA Test cases for EDQ Rules Platform 6.0

Confidential, Mount Laurel NJ

ETL Architect

Responsibilities:

• Responsible for analyzing business requirements related to Curam Data Model
• Performed extensive Data Analysis for the creation of Curam Data Warehouse
• Created Mapping specs, Solution Specs and Detailed design documents
• Integratedatafrom multiple sources intoDataWarehouse through Informatica
• Designed and Developed maps as per the requirement by making use of the available transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, and Aggregator etc..)
• Provided solutions using various Variables, Procedures and Functionalities using Informatica Suite
• Identifying the Changing Dimensions and Implemented the SCD of Type 2 data
• Used workflow manager for session management, database connection management and scheduling of jobs
• Worked on the performance tuning of the Mappings as well as the sessions
• Developed the control files to load large volume of data into the system via SQL*Loader
• Strong Query Writing and Optimizing skills with Customizing the Views, Stored Procedures, Functions and ensured data migration across various environments
• Responding to and Resolving Database Access and Performance Issues
• Designing Universes and Reports using SAP Business Objects Suite
• Involved in all Analysis, Development, Testing, and Maintenance, as well as resolved problems during implementation

Environment: Oracle 11 g, Business Objects XI R3, UNIX, Curam

Confidential

IT consultant

Responsibilities:

• Responsible for Defining the Data Warehouse Architecture for the creation of ODS and Data Marts
• Created workflows and sessions and handled successful execution of the maps
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Tasks, Workflows and the Target Data.
• Performance tuning and Loading large volumes of data
• Expertise in designing Universes and Reports using SAP Business Objects 4.0
• Expert in designing, developing, maintaining and optimizing the Universes using Business Objects 4.0 Information Design tool and universe design tool
• Designed Complex and Multi dimensional graphical reports in Business Objects 4.0 Web intelligence (BI launch Pad)
• Experienced in Handling Production issues and Providing data Mapping solutions

Environment: oracle 10 g,, Oracle Warehouse Builder, Oracle Data Integrator, UNIX, Business Objects, BMC, BRM

Confidential

Lead Consultant

Responsibilities:

• Responsible for Designing Star Schema by Data Modeling concepts
• Extensively worked in Creating the Physical Model after the Conceptual and Logical Model
• Handled Data Analysis for the Banking operations by creating complex queries
• Designed the Maps using Mapping Operators. Source and Target operators and Data flow operator to Extract the Data and Load it to Operational Data Store
• Experienced in Extracting the Data from T24 core banking system and Oracle ERP system in to ODS using OWB
• Developed a system to Track the Credit History of Customers by using Oracle Warehouse Builder
• Migrated data from legacy systems environments to Data warehouse using OWB ETL transformations
• Tuned and optimized mappings to reduce ETL run times
• Experience in creating, deploying and Successfully testing the MDL packages across various domains after deployment
• Created POSTILLION Data mart using Informatica as an ETL tool
• Built the the maps using transformations like Aggregator, Expression, Filter, Joiner, Lookup, External Procedure, Router & Update Strategy etc
• Experienced in Designing and Developing Reports using COGNOS Reports Studio and COGNOS Planning
• Designing Universes as per the user requirements by identifying the required tables and by defining the universe connections using designer Module in Business Objects XI R3
• Designed Simple, Complex and Multi dimensional graphical reports in Web Intelligence using SAP Business Objects
• Exported the data in Excel Sheet to perform data mining activities
• Made use of the Excel Functions, Formulas, Vlooksups,pivot tables to represent the data as per the management needs

Environment: oracle 10 g, Oracle Warehouse Builder, Oracle Data Integrator Business Objects, MS Visio, MS excel

Confidential

Software Engineer

Responsibilities:

• Effectively Communicate with clients to understand their needs for design and development
• Designed various Maps Using Informatica as the ETL tool and load the data to Operational Data Store
• Extensively used Key operators to Transform and Load the Data to Target Schema
• Creating Targets using other than tables like Flat files Informatica
• Make use of the available Transformations to build the business logic
• Creating Work flows, Sessions and Deploying the MDL packages across various platform
• Designed Universes by selecting the Tables from ODS, developed and created classes with Dimension, Detail& Measure Objects and Specified hierarchies using SAP Business Objects suit
• Created the relations among tables by doing Equi,Complex and Theta Joins in the BO Universe
• Designed the reports like Combined Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formulae using Web intelligence in Business Objects
• Involved in all Analysis, Development, Testing, and Maintenance, as well as resolved problems during implementation
• Involved in Unit testing, UAT and Publishing the reports for user access

Environment: oracle 10 g, Oracle Warehouse Builder,Business Objects, MS Excel, MS Visio

Confidential

Reporting Analyst

Responsibilities:

• Effective Interaction with the Business Analyst to Understand the Needs and Requirements
• Perform Data Profiling and Analysis of Source Systems; provide data exception reports
• Designed and Managed Universes
• Designed Monthly, Weekly & Daily Report as per operational needs
• Extensively used Free Hand SQL as an External data provider to design reports
• Written Complex queries and Created Reports on Case Management for
• Ensured the better performance by Optimizing SQL queries by creating Indexes and Views
• Created User Conditions and Filters to improve report generation & readability of report and displayed the summary of data by creating Charts
• Used advanced reporting and formatting functionalities while designing the reports
• Perform QA of reports and Publish the reports to Corporate document

Environment: Oracle 9g,Support works, Business Objects, MS access, Business Object