SUMMARY

• 9.6 years of IT experience in various technologies focusing on data warehousing, Informatica ETL, OBIEE11g, SAS EG, Oracle, Business Objects, Unix, SQL, Cobol, Open VMS, synergy, DIBOL.
• 7 years of proven IT technical leadership using Informatica 8.X/9.1 delivering Data Warehousing projects involving Analysis, Design, Data, Modeling, Development, Integration, Implementation, Maintenance, Testing, and Production Support of Applications along with reporting experience.
• Loaded and maintained Data Warehouses and Data Marts/Semantic layer using ETL Informatica and ELT ODI 11 processes.
• Collected requirements and laid out the Technical Design/Mapping of how data warehousing applications should work quickly identified and resolved design flaws early in design life cycle.
• 4 years of reporting experience that includes reporting tools like OBIEE 11g ,Business Objects XI R2/R3, Crystal reports 2008 and analytical tool like SAS EG.
• 3 years of programming experience in Cobol, Unix shell scripting, PL/SQL and Pro C.
• Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner
• Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions.
• Proficient in using Informatica Workflow manager, Workflow monitor, pmcmd Informatica command line utility to create schedule and control Workflows, tasks and sessions.
• Experience in modeling Transactional Databases and Data Warehouses using tools like Erwin.
• Experience in Production support and SLA's.
• Experience in incident management, problem management and change management
• Experience in creating entity relational dimensional relational data models with Kimball Methodology
• Documented design procedures, operating instructions test procedures and troubleshooting procedures.
• Experienced in estimation, planning, Risk Management, finalization of technical / functional specifications, communication management and quality management of the deliverables .
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets, SQL scripts and triggers and PL/SQL stored procedures.
• Expertise in Data modeling concepts/techniques like Dimensional/ Star Schema, and Snowflake modeling, Slowly Changing Dimensions SCD Type 1, Type 2, and Type 3 .
• Used partitioning in Informatica to improve session performance for very large loads.
• Solid time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews according to the varied needs of the people involved
• Knowledge in OBIA 7X and OBIA 11X in Order management and Procurement and Spend Modules.
• Knowledge in installing, configuring and utilization of DAC.
• Thorough knowledge of Data Warehousing Principles and architectural methodologies to build complex hybrid data mart schemas as well as OLTP and OLAP concepts.
• Expertise in SDLC process in streams waterfall and agile methodologies.
• Knowledge on other BI tools and reports like BI 7.0/ODI 11X
• Strong Knowledge on Legacy technologies like COBOL, Unix, DIBOL, synergy, Open VMS , EDI and lead Home depot- Home Delivery Order creation process as Responsible Analyst RA .
• Lean Six Sigma Green Belt certified for quality
• Achieved 98.9 in Software Development on SAP HANA .

Work History

Confidential

Technical Lead/Project Lead

Responsibilities:

• Managing user and group access in Informatica.
• Documented the technical specification documents and CLG functional documents by understanding the business requirements and functional specification documents.
• Analysis of the entire product registration process and the information being captured and what kind of information business is expecting in the analysis by regular brainstorming sessions with business users.
• Involved in Testing, Debugging, Validation and Performance Tuning of data warehouse. Help develop the optimum solutions for data warehouse deliverables.
• Coordinated with Appliance park business team and off shore team members to fill gaps.
• Managed a team of 4 as Lead.
• Raised change requests, incident Management, analyzed and coordinated resolution of program flaws for the Development environment and hot fixed them in the QA, Pre-Prod and prod environments, during the runs using JIRA ticketing system.
• Did code reviews for the fellow team members to follow company standards and responsible for maintaining project tracking and presenting to A L BI Lead
• Implemented the SCD type3 to keep track of historical data.
• Responsible for Informatica complex mappings along with using JAVA transformation and implemented the Performance tuning and partitioning best practices handle testing.
• Created reusable transformations for converting varchar into upper case and string to date.
• Participated in dimensional modelling design, building business models and repository creation using OBIEE 11g to build analysis those provide business critical data.
• Edited different kinds of Partition points and Created partitions to improve performance by activating multiple Transformation Threads for optimal use of system resources.
• Responsible for generating critical campaign data using SAS EG based on which campaigns are sent that increases parts sales and hence the revenue.

Environment: Informatica Power Center Designer 9.1, OBIEE 11g, SAS EG, UNIX, Windows 7. Highlights : Project star of the Quarter award for the good performance with 100 say/do.

Confidential

Project Lead

Implementation of OBIA11g

Responsibilities:

• Being track leader of procurement and Spend module across GE appliances with team by effective communication with business and technical team by overcoming road blocks between the existing native functionality and packaged functionality.
• Customized ODI by creating new blue and yellow interface to extract data from EBS till warehouse.
• Created data patches to load data from EBS to target.
• Analysed RPD to add new customized columns to build dashboard related to spend analyser.
• Helped fellow team members in meeting their deliverables being lead.

Environment: OBIA 11g, OBIEE 11g, ODI, Windows 7.

Confidential

Module Lead/Sr.Informatica developer

Concessions Management

Responsibilities:

• Module lead at offshore and managed a team of 3.
• Co-ordinated with the Siebel team and came up with high level design document.
• Did code reviews for the fellow team members to follow company standards.
• Designed the technical specification document, logical data map sheets by analyzing the business requirements.
• Extensively used Informatica Client Tools - Source Analyzer, Warehouse Designer, Transformation Developer, and Mapping Designer to develop mappings.
• Implemented Change Data Capture CDC techniques like Slowly Changing Dimensions.
• Hands-on expertise over transformations like Source Qualifier, Lookup, Expression, Filter, Router, Sequence Generator, Update Strategy etc.
• Performed data validation of the fact and dimension tables on targets and supported varied Test cases and execution and used designer debugger to test the data flow and fix the mappings.
• Translated the business processes into Informatica mappings for building the data mart.
• Created Work Flows with Command Tasks, Worklets, Decision, Event Wait and Monitored sessions by using workflow monitor.
• Worked on Concession site detail report using BO Webi to create daily schedule reports for business users.
• Environment: Informatica Power Center Designer 8.6.1, Oracle 10g, SQL developer, BO Webi

Highlights : Silver award winner for quick turnaround on designing changes during discussions.

Confidential

Module Lead/Sr.Informatica developer

Responsibilities:

• Gathering requirements, conducting a design overview, detailing ETL specifications,data analysis/troubleshooting, implementation tasks, and general mentoring.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Providing in-depth technical consultation to ensure development of efficient application systems by utilizing standard methodologies and best practices.
• Writing program specifications and developing mappings.
• Created the mappings according to technical design document and ETL documents.
• Hands-on expertise over transformations like Source Qualifier, Lookup, Expression, Filter, Router, Sequence Generator, Update Strategy etc.
• Designing and implementing schemas for reference data, Change Data Capture, process control and audit balancing.
• Did code reviews for the fellow team members to follow company standards.
• Extracted data from various source systems like relational data bases, Flat files and load data into the database after performing certain validations.
• Full technical support for Project to UAT testing team.
• After each post data load, analyzing and fixing the defects raised by UAT team.
• Ensuring the zero down time for the ETL system with strong 24x7 support by helping junior team members.
• Environment: Informatica Power Center Designer 8.6.1, Oracle 10g, Winscp, SQL developer

Highlights : Received appreciation certificate from business for achieving excellent delivery.

Confidential

Informatica Developer

Responsibilities:

• Worked closely with application teams, business analysts, data support team, database administrators to ensure ETL processing is running efficiently and accurately as per the business requirements.
• Did multiple enhancements by adding new columns in the Informatica mappings to desired data to warehouse and hence on report apart from developing new mappings.
• Prepare and maintain ETL documentation including lineage document, elaborating source target mappings, dataflow diagrams and business driven transformation rules.
• Level 1, Level 2 Production support to the deployed systems by actively responding and resolving issues.
• Developed ETL mappings using Informatica Power center 8.6. Extensively used Informatica client tools Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer, Workflow Manager.
• Worked on reusable transformations and transformations like expression, aggregation, lookup, router, filter, update strategy.
• Prepared test plans and load plans.
• Proactive communication with business on the status and needs.
• Extensively used transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update strategy, SQL, Normalizer .
• Used SQL queries and PL/SQL for database programming writing Packages, Stored Procedures/Functions and Database Triggers .
• Implemented procedures/functions in PL/SQL for stored Procedure Transformations
• Created Complex Informatica Mappings to implement complex business rules by using mapplets, reusable transformations, and mapping parameters.
• Created and executed Unit Test Plans for the various Mappings.
• Provided extensive support and monitoring of ETL loads on 24x7 basis.
• Worked on enhancement and application support of Order creation process for Home Depot for Order entry online application
• Worked as Responsible analyst RA for Home depot Order creation process.
• Environment: Informatica power Centre designer 8.6, Unix, sql Developer, Cobol

Highlights: 3 Bronze awards for best performance in the team

Confidential

Software Programmer

Responsibilities:

• Understanding the User request based on the user requirement gathering sessions.
• Detailed analysis of user requirements by preparing analysis Level1, Level 2 documents.
• Preparation of Functional Specification.
• Preparation of Design Specification. This includes both high and low level design specification documents.
• Creating Test Plans for the changes
• Guiding junior members and doing code reviews for the new developments.
• Coding, Unit Testing, System integration Testing, User Acceptance Testing.
• Implementation, Post Implementation Support.

Environment: Cobol, Unix, synergy, open VMS,PL SQL

Confidential

Software Programmer

Responsibilities:

• Understanding product requirements with product architecture team on daily basis.
• Involved in part of coding.
• Actively participated in release meetings and roactively worked with stake holders in accomplishing release targets.
• Handled UAT and worked with testing teams for 100 bug free releases
• Shown great adoptability with the drequent changing requirement and successfully delivered on the committed deliverables on time.
• Participated in feasibility study of the product and cameup with many suggestions.
• Designed User interface screens for multiple modules Sales and product modules.
• Implementation, Post Implementation Support.

Environment: Cobol, Unix, synergy, PL/SQL