Summary:

• 8 Years of experience in Software development Life cycle SDLC which includes Business Requirements Gathering, System Analysis, Design, Data Modeling, Development, Testing and Implementation of Data Warehouse.
• Working knowledge on different data sources such as Flat files, Oracle, SQL Server and Excel files.
• Experience in Data Warehouse development working with Data Migration, Data Conversion, and Extraction/Transformation/Loading using Informatica Power Center with Oracle, SQL Server and Teradata.
• Good Understanding of Data warehousing concepts like Star schema, Snowflake schema methodologies.
• Experience in using power center features n-way source partitioning, Recovery for concurrent sessions, version controlling of the ETL process.
• Implemented Various Performance Tuning techniques on Sources, Targets, Mappings and Workflows in all versions of Informatica
• Developed shell scripts for invoking Informatica workflows and File automation process.
• Involved in Informatica Performance tuning of the ETL process and SQL tuning.
• Strong experience in Data Migration including Data profiling and Data quality.
• Experience in optimization techniques such as concurrent caching, auto memory calculations and using push down optimization.
• Experience in formulating error handling mechanism in problem management,
• Created slowly changing dimensions, Type1/2/3
• Worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Involved with Netezza in Data profiling.

Technical Skills:

• ETL Tools/DWH Tools: Informatica Power Center 9.5/9.0.1/8.5/8.6, Informatica, OLAP, Control M
• Database: Oracle11g/10g/9i/8i, SQL Developer, PLSQL
• Test Management Tool: HP Quality Center
• Scripting Languages: Korn Shell, Bash shell scripting, HTML, CSS
• Languages: C, C , COREJAVA, SQL, PL/SQL
• Environment: Sun Solaris, Linux, AIX, UNIX WINSCP , Windows

Professional Experience:

Confidential

Business System Analyst

Responsibilities:

• Interacted with the software developers and SME's to liaison the business requirements to ensure that the application under development confines to the business requirement
• Involved in requirement gathering and creating Business and User requirement document for approval and sign off.
• Worked closely with the Business in gathering requirements and prepared the data mapping documents.
• Conducted meetings with the development team in communicating the business requirements and was also responsible in performing for high level Data validation.
• Responsible for analyzing and elucidation of information for development of business and functional requirements tailored for BI development.
• Created Functional Specifications document and conducted walkthrough sessions with the stakeholders to get approval and signoff.
• Created Test approach and Test plan for the project, conducted walkthrough for both documents and achieved approval and signoff form all stakeholders.
• Created Test cases for the project in HP Quality Center and was responsible for reporting on various metrics required as part of ongoing process.
• Conducted peer review sessions for all documents requiring signoff's.
• Involved in testing the application through the various development environments such as Development environment, Product Test environment, Regression Environment and production environment
• Assisted in developing UAT test scripts for operations and running them in HP Quality Center.
• Conducted two UAT User Acceptance Testing sessions for different stakeholders in the project.
• Involved in preparing test data for the functional test cases. Executed test cases, evaluated test results and prepared test summary reports
• Involved in post implementation activities such as Deployment verification and product verification processes.
• Experience in coordinating and conducting meeting with the BI development and data warehouse team.
• Hands on Experience in using JIRA for project tracking, capture requirements to tasks and action items.
• Also used JIRA for getting feedback from people outside the product team.
• Experience in analyzing and comparing existing data against new data structures and documenting differences.
• Expertise in Creating use case scenarios to be used in all testing phases.

Environment: MS Office 2007, MS Visio 2003, Windows XP, AFS, SQL server 2008, oracle10g , Power center 9.0.1, MS Excel, SharePoint, PowerPoint, MS Project, UML, SQL Server, Erwin, Business Objects, MS Outlook

Confidential

Data Analyst

Responsibilities:

• Worked heavily with Business owners to understand the business and to design the architecture of the data flow.
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables, Populating the Enterprise Data Warehouse by transforming the data into business needs Populating the Data Mart with only required information.
• Created re-usable transformations to clean the data, which were used in several mappings.
• Improved current data processes, like automating processes that were currently manual in the existing system using UC4.
• Used UC4 thoroughly to provide the ability to check and validate jobs and notify on failures.
• Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder.
• Performed pervasive data quality for all stakeholders, projects, and applications using a single, unified platform using Data Migration concepts.
• Involved in Discovery and analysis of data, detection of hidden risks, location of structural issues, using Data Migration.
• Used Data Migration concepts thoroughly for the integration, and delivery of data quickly and cost-effectively without hand coding and normalizing of data into target table formats and loading into new systems.
• Wrote the test cases and technical requirements and got them electronically signed off.
• Created new reports based on requirements.
• Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders.
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
• Involved in defining the source to target data mappings, business rules, business and data definitions.
• Created Report-Models for ad-hoc reporting and analysis.
• Created Logical/physical Data Model in ERwin and have worked on loading the tables in the Data Warehouse.
• Worked extensively with the ERwin Model Mart for version control.
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Provided 24 x 7 problem management support to the development team.
• Document various Data Quality mapping document and performed small enhancements data cleansing/data quality .
• Worked on daily basis with the main frame team and lead data warehouse developers to evaluate impact on current implementation.
• Communicated with the third party vendor to do the programming.
• Upgraded the present application by adding new functionalities and adding new reports.
• Conducted User Acceptance testing UAT and worked with users and vendor who build the system.

Environment: MS Office 2007, MS Visio 2003, Windows XP, AFS, MS Excel, SharePoint, PowerPoint, MS Project, UML, SQL Server, Erwin, Business Objects, MS Outlook

Confidential

Sr. Data Analyst

Responsibilities:

• Participated in the Analysis, Design and Development Phases of report development, performance tuning and production rollout for every report of Information Technology Department.
• As a Sr. Data Analyst, I was responsible for the fulfillment of various project tasks. I was also responsible for the entire software life cycle development methodologies SDLC for migration, SQL, Reporting, documentation, Use case development and testing.
• Worked closely with Business owners and other analysts and gathered Business Requirements, schedule meetings.
• Gathered requirements, analyzed and wrote the design documents.
• Providing End-user Training and documentation for customer reporting services.
• Attended JAD sessions and created reports for Budgeting, Finance and Project Management departments of HP.
• Worked on Quick extraction of data from legacy systems with zero impact on operational performance during data migrations.
• Performed testing to ensure that data remains free of damage from movement or transformation during data migration
• Worked on Legacy system retirement and data archival after migration to a new target system, saving operational and maintenance costs of legacy systems
• Was involved Masking of sensitive data before it is moved into new systems during data migration.
• Queried the databases, wrote test validation scripts and performed the System testing.
• Worked with the users to do the User Acceptance Testing UAT .
• Worked with the developers during coding and while doing the remediation of the software.
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements
• Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
• Created data trace map and data quality mapping documents.
• Performed Data Profiling and Data Quality.
• Used ERwin for data modeling.
• Extensively involved in Data Extraction, Transformation and Loading ETL process from Source to target systems using Informatica Power Center 7.1
• Designed and implemented report layouts according to reporting standards of the department.
• Owned the assigned reports, worked on them and updated the Report Development Scheduler for status on each report.
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic.
• Have taken initiative to drive the report development process.
• Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF.
• Responsible for making the report available for scheduling or viewing on demand.
• Worked with Technical Experts to Improve Report Performance and performed System testing.

Environment: Oracle 11g, SQL Server 2008, Windows XP, Microsoft Project 2000, Informatica, HTML, Business Objects, Erwin, MS Excel, SharePoint 2010, PowerPoint, MS Visio and MS Outlook

Confidential

Sr. Informatica Developer

Responsibilities:

• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Prepared the DDL's for the staging/work tables and coordinated with DBA for creating the development environment and data models.
• Involved in analyzing the source data coming from different Data sources such as XML DB2, flat files etc.
• Worked on Informatica Power Center tools Source Analyzer, Warehouse Designer, Mapping Mapplet Designer, and Transformation Developer.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Normalizer, Union, Stored procedure, and XML transformations.
• Converted existing PL/SQL Packages to ETL Mappings using Informatica Power Center.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Used IDQ for understanding data analysis.
• Wrote UNIX Shell scripts to automate and scheduled workflows.
• Worked on Erwin to create tables.
• Worked effectively in achieving a visibility and control for business users to create, manage, and share critical business context in the Data migration process.
• Was involved Masking of sensitive data before it is moved into new systems during data migration.
• Was responsible for Creation of secure subsets of production data from large, complex databases during Data migration.
• Developed stored procedures using T-SQL and optimized queries for report generation and data modifications activities.
• Worked with the oracle forms which generate the screen that presents the data.
• Schedule and run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Used Informatica features to implement Type II changes in slowly changing dimension SCD tables.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.

Environment: Informatica Power Center 8.6, Oracle 11g, PL/SQL, Oracle Forms, SQL Plus, Erwin 4.0/3.5.2, DB2, MS SQL Server 2008, MS-Excel, MS Access, XML, Flat files, Windows NT, Control

Confidential

Sr. Informatica Developer

Responsibilities:

• Coordinated with Business Relationship team and business partners in the creation of Business Intelligence functional requirements.
• Created source to target data mapping documents.
• Developed Informatica ETL mappings and workflows.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Extensively used transformations like Joiner, Expression, Connected/Unconnected lookups, and Filter, Aggregator, Rank, Update, Router, Stored Procedure, Normalizer and Sequence generator
• Designed Mapplets to encapsulate re-useable code.
• Fine-tuned Informatica mappings for performance optimization.
• Resolved Logical, Design Errors in mapping with the help of Debugger and different Log files.
• Developed Informatica mappings for Slowly Changing Dimensions.
• Responsible for migration of code from one environment to other
• Provided Production support. Was actively involved in troubleshooting the issues related to ETL and reporting that occur on day-day basis.
• Wrote Triggers, PL/SQL Procedures, Packages and Shell Scripts to apply and maintain the Business Rules. Created and executed Sessions and Batches using Server Manager.
• Developed reusable mappings using Mapplets Designer.
• Involved in Setting up Environments for Development, Test and UAT, which involved Configuring Informatica, Rep Server and running full loads in all the three environments.
• Involved in fine-tuning the ETL mapping by studying the session logs and coming up with a better strategy to deal with bottlenecks such as time involved in building the cache.

Environment: Informatica Power Center 8.1, Oracle 10g, SQL 2008, Teradata, UNIX, Windows7, Flat files, TOAD

Confidential

Sr. Informatica Developer

Responsibilities:

• Involved in the meetings with various business teams and closely worked with the business analysts in the requirement gathering sessions.
• Worked with the data modelers during the Logical and Physical data model design.
• Closely worked with the Data Stewardship team in defining the data quality rule.
• Responsible for defining the standards in building the data warehouse.
• Closely worked with Solution/Information Architects during the design phase.
• Responsible for converting Functional Requirements into Technical Specifications.
• Extracted data from various heterogeneous sources like Sybase, DB2, XML and Flat Files.
• Used Ralph Kimball Methodology for building the data warehouse.
• Worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, and Mapping Designer.
• Used various active and passive transformations like Filter, Router, Expression, Source Qualifier, Joiner, Look up, Update Strategy, Sequence Generator, Rank and Aggregator Transformation Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr, and IIF functions in Expression Transformation.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Used both Connected and UN connected Lookup transformations.
• Worked with various lookup caches like Static Cache, Dynamic Cache and Persistent Cache.
• Worked with joiner functions like normal join, full outer join, master outer join, and detail outer join in the joiner transformation.
• Used Update Strategy DD INSERT, DD DELETE, DD UPDATE, and DD REJECT to insert, delete, update and reject the items based on the requirement.
• Developed Re usable Transformations, and re-usable Mapplets.
• Worked with Shortcuts across Shared and Non Shared Folders.
• Developed Slowly Changing Dimension Mappings for Type 1 and Type 2.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Responsible for Unit Testing and Integration testing of mappings and workflows.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.

Environment: Informatica Power Center 8.1 Repository Manager, Designer, Workflow Manager, Workflow Monitor , Informatica Power Exchange, Data Explorer, PL/SQL, Oracle 10g, XML, Flat Files, UNIX Shell Scripting, Autosys

Confidential

Informatica Developer

Responsibilities:

• Interacted with business analysts and translated business requirements into technical specifications.
• Designed and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Extensively worked on Informatica to extract data from Flat files, Excel files, and MS Access database to load the data into the target database.
• Implemented the Incremental loading of Dimension and Fact tables.
• Created Stored Procedures for data transformation purpose.
• Created Tasks, Workflows, and Sessions to move the data at specific intervals on demand using Workflow Manager.
• Developed the control files to load various sales data into the system via SQL Loader.
• Developed Unix Shell scripts for maintaining Files.
• Designed and created an Autosys job plan to schedule our processes.
• Created PL/SQL Stored procedures and implemented them through the Stored Procedure transformation.
• Develop, test and implement break/fix change tickets for maintenance.
• Involved in writing test cases, assisting Testing team in testing.
• Developed the document of the complete ETL process.

Environment: Informatica 7.1.1, UNIX, TOAD, IBM DB2 8.1, Oracle 8i SQL/PLSQL , MS Access 2006, Win 2000, Autosys, MS Excel 2006, UNIX, UNIX Shell Script

Confidential

Informatica Developer

Responsibilities:

Developed and supported the Extraction, Transformation, and load process ETL for data migration using Informatica power center.

• Responsible for developing Source to Target Mappings.
• Extensively used Informatica Client tools- Source Analyzer, Warehouse Designer, Mapping Designer.
• Developed Informatica mappings for data extraction and loading worked with Expression, Lookup, Filter and Sequence generator and Aggregator Transformations to load the data from source to target.
• Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation.
• Developed mappings, sessions for relation and flat source and targets.
• Imported data from various source Oracle, Flat file, XML and transformed and loaded into targets using Informatica.
• Created and scheduled Session, jobs based on demand, run on time
• Monitored Workflows and Sessions
• Identified the facts and dimensions and designed the relevant dimension and fact tables.

Environment: Informatica 5.1, Oracle 8i, Erwin 4.0, PL/SQL, UNIX and Windows NT