SUMMARY:

• 8+ years of experience in the IT field, related to various aspects of Data Warehousing and Business Intelligence such as business understanding, requirement gathering, Data Analysis, design, ETL development, Analytical Reporting, Enhancements & production support.
• Extensive Experience in Oracle Data warehouse/Informatica/Siebel Analytics/OBIEE, ETL Processes and Database Deliverables in various Projects.
• Expertise in Application Development with full lifecycle which includes Requirement gathering, Customization, Testing and Maintenance of various Business Applications in Data Warehouse.
• Strong in Data warehousing concepts and Methodologies, Data Modeling Concepts: Dimensional Data Modeling, Fact Table, Dimension Table, OLTP, OLAP, Star schema, Snow Flake schema.
• Over 7 years of Data Warehousing/ETL experience using Informatica Power Center 9.x/8.x/7.x, Repository Admin Console, Repository Manager, Mapping Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer.
• Extensively worked with OBIEE Administration Tool to customize the RPD in all the layers Physical, BMM and Presentation Layers.
• Extensively worked with BI Answers, Dashboards, Delivers & Presentation server Administration
• Strong Technical skills on Data Warehouse Administration Console (DAC)for scheduling Informatica workflows. Create New Execution Plans and scheduled them.
• Possess wide range of IT industry experience with Banking / Finance, Insurance, Retail Store, Pharmaceutical, Healthcare.
• Coordinated with Business Teams / Functional Subject Matter Experts (SME) for the objective of Requirement Gathering and subsequently for the translation of those requirements into technical specifications.
• Thorough understanding of Software Development Life Cycle (SDLC) including Requirements gathering, System Analysis, Design, Development, Documentation, Testing, Deployment and post - implementation support.
• Data Modeling: 5 years of Data Modeling using Erwin and SQL Designer.
• Experience in implementing the complex business rules by creating re-usable transformations, developing complex Mapplets and Mappings, PL/SQL Stored Procedures.
• Proficient in using Workflow Manager Tools like Task Developer, Worklet Designer.
• Hands on experience in DWH concepts, DataModeling and DataProfiling.
• Experience in designing/developing complex mapping using Connected and Unconnected Lookups, Normalizer, Source Qualifier, SQL Transformation, Router, Filter, Expression, Aggregator, Sorter, Joiner, Update Strategy and Stored procedure etc
• Extensively used Slowly Changing Dimension (SCD) technique for incremental updating of the targets.
• Experience in Oracle 11g, IBM DB2, MS SQL Server 2008, PL/SQL.
• Experienced in Windows 7/NT/XP/2000/NT/98, UNIX, and Linux.
• Experienced in Testing, Debugging, Validation and Tuning of mappings, workflows.
• Extensively worked with Parameter files, PipelinePartitioning, PushdownOptimization, and InformaticaScheduler.
• Strong experience in Error handling, Performance tuning and Optimizing- the source, mappings, transformations, sessions, and the targets, and expertise using Informatica Debugger.
• Solid experience in writing SQL queries, PL/SQL, Stored Procedures, and optimization.
• Experience in Unix Shell Scripting for scheduling/running ETL jobs in production environment.
• Experience in Customer relationship Management and addressing customer issues.
• Strong Team working spirit, communication and relationship management skills.

TECHNICAL SKILLS:

Functional: Business Requirements Analysis and Process mapping

DWETL Tools: InformaticaPower Center9.0.1/8.X/7.0/6.x/x (Repository Manager, Designer, Server manager, Work Flow Monitor, Work Flow Manager), Datamart, ETL, OLTP, Star Schema, Snowflake Schema, Oracle Warehouse Builder 9.2/10g,Data Meer(Big Data ETL tool)

Reporting &BI/OLAP: OBIEE 11g(11.1.6.0), 10.1.3.4.1 (Siebel Analytics 7.8.4/7.8.2/7.7 ), TibcoSpotfire

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, Erwin 4.0/3.5.2/2. x

Databases Scheduling tools: Oracle 11g/10g/9i,MS SQL Server 2008, DB2, Web services, PL/SQL, SQL*Loader, Autosys, TOAD,Aqua Data Studio

Environment: Windows 95/98/00/XP/7, UNIX, LINUX

Others: Java, JavaScript, HTML

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Responsibilities:

• Worked on Data Movement Frame work to land the data from Different sources systems to HDFS.
• Created Hive tables and written the Hive scripts to extract the data.
• Developed Generic UDF, UDAFs for data in hive windowing functions.
• Created Pig Transformations to transform and load the data to Data Lake.
• Implemented SCD1 and SCD2 loading strategies on HDFS and HBase.
• Designed Hbase schema with row distribution by date and consumer
• Implemented a very intelligent ingestion framework from various data sources. Both bulk loads and event loads exists
• Created Oozie workflows and Scoop jobs to import the data from different RDBMS sources to HDFS Data Lake.
• Created Dispatch scripts to dispatch the data from HDFS to Teradata data.
• Created Logical and Physical data models for Hive using SAP Power designer.

Confidential, New Jersey

Responsibilities:

• Lead and guided development of Informatica based ETL architecture for the client.
• Developed solution in highly demanding environment and provided hands on guidance to other team members.
• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build the Data Mart.
• Assessed requirements for completeness and accuracy
• Determined organizational strategies for data integrity validation processes. Established policies and best practices for optimizing ETL data throughput/accessibility
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Monitored data quality, compatibility and stability to meet current and future needs of the organization.
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregatortransformations to pipeline data to DataMart.
• We used to go beyond traditional B2B capabilities, such as managed file transfer and trading partner management, to deliver full multi-enterprise data integration capabilities.
• Written SQL Queries, Triggers, and PL/SQL Procedures to apply and maintain the Business Rules.
• Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.
• Written Indexes, primary keys and checked other performance tuning at data base level.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Written shell scripts to run the workflows and automated them through maestro job scheduler.
• Defects were tracked, reviewed and analysed.
• Used Source Analyser and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.

Environment: Informatica v9.0.1. Informatica Power Center, Windows 7, Oracle 11g, OBIEE 11g ( 11.1.1.0.6 ),Autosys, UNIX, Toad, B2B, PL/SQL, XML,SQL Server 2008,Shell Scripting

Confidential,Alpharetta, GA

Responsibilities:

• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Developed Slowly Changing Dimension for Type 1 SCD
• Used mapplets for use in mappings thereby saving valuable design time and effort
• Used Informatica Workflow Manager to create, schedule, and run sessions,workletsand workflows.
• Installation and configuration of Siebel Analytics and administrating permissions, privileges to users
• Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Created testing metrics using MS-Excel
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.
• Defects were tracked, reviewed and analyzed.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.
• Extensively used OBIEE Answers and rpd Design design, ad-hoc reporting and advanced report authoring
• Developed Complex Reports in OBIEE
• Created Subject areas in OBIEEfor users to be Analyze specific business function
• Developed OLAP solutions using OBIEE and published Reports using BI Publisher
• Creating prompts, conditions, filters and calculations in OBIEE
• Creating multilingual reports in OBIEE
• Created Tasks,Subject areas and Execution Plans in DAC to schedule ant automate the ETL daily,weekly and Monthly Loads
• Defined the KPI(Key Performance indicators) for the business populated them in Warehouse and exposed them in the reporting layer.

Environment: Informatica v9.0.1. Informatica Power Center, Windows 7, Oracle 11g, OBIEE 11g ( 11.1.1.0.6 ),Oracle Business Intelligence Applications 7.9.6.3, Data Warehouse Administration Console(DAC) 11.1.1.0.6, UNIX, Toad, B2B, PL/SQL, XML,SQL Server 2008,Shell Scripting,TibcoSpotfire, Datameer

Confidential

Responsibilities:

• Interacted with various business people in External Vendors side and gathered the business requirements and translated them into technical specifications.
• Documented business requirements, discussed issues to be resolved and translated user input into ETL design documents.
• Experienced working with team, lead developers, Interfaced with business analysts, coordinated with management and understand the end user experience.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Involved in ETL process from development to testing and production environments.
• Responsible for creating interfaces using different types of mappings using various transformations like Expression, filter, router, Aggregator, Look up, Joiner, Stored Procedure, Update Strategy, Etc.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters for the delta process to extract only the additional data added during that period.
• Extensively Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Worked with mappings to dynamically generate parameter files used by other mappings.
• Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Documented the mappings used in ETL processes including the Unit testing and Technical documentof the mappings for future reference.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Target.
• Scheduled the Informatica Workflows to start running at specified date and time repetitively forever.
• Participated in unit testing to validate the data in the flat files that are generated by the ETL Process.
• Logged on to the QC Centre to find out the defects posted by testing team and fixed those defects.
• Used SQL Loader to load the flat file data into temp tables to compare the data with that generated from CMA.
• Involved in creation of Schema objects like Indexes, Views, and Sequences.
• Wrote SQL, PL/SQL codes and stored procedures for dropping and re creating indexes, to generate oracle sequences, procedures that update the Process Run table automatically to make the delta process work accurately.
• Extensively worked with Unix Shell scripting to validate and verify the data in the flat files generated by the ETL process.
• Developed the UNIX shell scripts to send out an E-mail on success of the process indicating the destination folder where the files are available.
• Involved in migration of Informatica mapping from Development to Production environment.
• Coordinated with the Informatica administration team during deployments.
• Provided the production support and solved the production issues immediately after they are noticed.
• Interacted with Subject Matter Experts (SME), Business Analysts and Users for gathering the business and reports / dashboards requirements.
• Involved in the migration of OBIEE 10g to OBIEE 11.1.1.6.2 .
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Region and Product dimensions, using Session Variables.
• Developed Performance Tuning Strategies for optimizing the performance.
• Performed unit testing and system testing of all components of OBIEE Analytics.
• Performed unit testing and system testing of all components of OBIEE Analytics.
• Developed different levels of Security set-up for the entities of the application (on both Repository file and Web catalog file) using OBIEE 11g.
• Created an initialization block to retrieve allowable values.
• Configured the BI Delivers scheduler to schedule reports.
• Involved in GAP A nalysis and requirements gathering of the various work streams by meeting with the Business Analyst and Business Users and base lining the details.
• Organized testing schedules and test scripts. Managed execution and sign-off tests and also played an active role in product rollouts.
• Coordinated with offshore team and handled the situations very well.
• Attended daily review meetings and weekly status meetings.

Environment: Informatica v9.0.1. Informatica Power Center, Windows 7, Oracle 11g, OBIEE 11g ( 11.1.1.0.6 ),Oracle Business Intelligence Applications 7.9.6.3, Data Warehouse Administration Console(DAC) 11.1.1.0.6, UNIX, Toad, PL/SQL, Shell Scripting

Confidential

Enhancements & production support

Responsibilities:

• Interacted with various business people in External Vendors side and gathered the business requirements and translated them into technical specifications.
• Documented business requirements, discussed issues to be resolved and translated user input into ETL design documents.
• Experienced working with team, lead developers, Interfaced with business analysts, coordinated with management and understand the end user experience.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Involved in ETL process from development to testing and production environments.
• Responsible for creating interfaces using different types of mappings using various transformations like Expression, filter, router, Aggregator, Look up, Joiner, Stored Procedure, Update Strategy, Etc.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters for the delta process to extract only the additional data added during that period.
• Extensively Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Worked with mappings to dynamically generate parameter files used by other mappings.
• Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Documented the mappings used in ETL processes including the Unit testing and Technical documentof the mappings for future reference.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Target.
• Scheduled the Informatica Workflows to start running at specified date and time repetitively forever.
• Participated in unit testing to validate the data in the flat files that are generated by the ETL Process.
• Logged on to the QC Centre to find out the defects posted by testing team and fixed those defects.
• Used SQL Loader to load the flat file data into temp tables to compare the data with that generated from CMA.
• Involved in creation of Schema objects like Indexes, Views, and Sequences.
• Wrote SQL, PL/SQL codes and stored procedures for dropping and re creating indexes, to generate oracle sequences, procedures that update the Process Run table automatically to make the delta process work accurately.
• Extensively worked with Unix Shell scripting to validate and verify the data in the flat files generated by the ETL process.
• Developed the UNIX shell scripts to send out an E-mail on success of the process indicating the destination folder where the files are available.
• Involved in migration of Informatica mapping from Development to Production environment.
• Coordinated with the informatica administration team during deployments.
• Provided the production support and solved the production issues immediately after they are noticed.

Environment: Informatica8.6.1, Informatica Architecture, Informatica Power Center 8.6.1, DB2, Oracle 11g/, Data Transformation, UNIX, Toad, PL/SQL Shell Scripting

Confidential, Alpharetta, GA

Responsibilities:

• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Developed Slowly Changing Dimension for Type 1 SCD
• Used mapplets for use in mappings thereby saving valuable design time and effort
• Used Informatica Workflow Manager to create, schedule, and run sessions, workletsand workflows.
• Installation and configuration of Siebel Analytics and administrating permissions, privileges to users
• Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Created testing metrics using MS-Excel
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.
• Defects were tracked, reviewed and analyzed.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.
• Extensively used OBIEE Answers and rpd Design design, ad-hoc reporting and advanced report authoring
• Developed Complex Reports in OBIEE
• Created Subject areas in OBIEE for users to be Analyze specific business function
• Developed OLAP solutions using OBIEE and published Reports using BI Publisher
• Creating prompts, conditions, filters and calculations in OBIEE
• Creating multilingual reports in OBIEE
• Created Tasks, Subject areas and Execution Plans in DAC to schedule ant automate the ETL daily,weekly and Monthly Loads

Environment: Informatica v 7.1.3. Informatica Power Center, Oracle10g, OBIEE 10g( 10.1.3.4.1 ),Data Warehouse Administration Console(DAC), UNIX, Toad, PL/SQL, Shell Scripting