SUMMARY:

• 11+ years of IT experience in various technologies focusing on data warehousing, Informatica power center, Power Exchange, OBIEE11g, SAS EG, Oracle, Business Objects, Unix, SQL, Cobol, synergy
• 8 years of proven IT technical leadership using Informatica power center 8.X/9.1, Power exchange CDC delivering Data Warehousing projects involving Analysis, Administration, 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, Pro*C and knowledge of Python.
• Experience in designing and developing complex mappings and using almost all the transformations in Informatica Power center.
• Experience in implementing various Performance Tuning techniques of targets, sources, mappings and sessions
• Proficient in using Informatica Admin console, creating roles, access, handling deployments, Workflow manager, Workflow monitor, pmcmd (Informatica command line utility) to create schedule and control Workflows, tasks and sessions along with Production support experience.
• Strong experience is leading team and architectural solutions to complex problems and multi system integrations.
• Experience in modeling Transactional Databases and Data Warehouses using tools like Erwin.
• 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).
• 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.
• 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.
• 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

TECHNICAL SKILLS:

ETL Tools & Utilities: Informatica power center 9.6.1 HF3, 9.5, 9.1, 8.6, Power Exchange Navigator, ODI, SAP BI 7.0, SAS EG

Reporting tools: OBIEE11g, Business Objects, BEx, Power analyzer

Languages: SQL, PL/SQL, Basic UNIX Shell scripting, Python

Databases: Oracle 11g R2/ 10g/ 9i, SQL Developer

Hardware: Windows 2000/XP/7/Vista, Open VMS

Programming: COBOL, synergy, DIBOL

Query Tools: SQL Developer, Informatica Power Analyzer

Scheduling Tools: Crontab, Upath, Control M

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Informatica Technical Lead/Solution Architect

Responsibilities:

• Involved from the scratch of the project in architecture, system integration reviews and key solution making ensuring project success with frequently changing business requirements.
• Exhibited strong expertise in Informatica with end-end handling project handling from the requirement gathering, preparing technical specs, complex development and involved in business test for signoff.
• Designed loading strategies for TPM tables by reading from multiple sources and guiding team members on solutions on the spot guiding them to achieve their priorities.
• Handled complete deployments from DEV till production, code reviews and managing migration documents.
• Providing status updates to client leaders on the project progress and hiccups and solutions.
• Used all the transformations including loading IBM message queues, Oracle CDC express for Power exchange, reading from i-series journal files as an alternative approach to CDC.
• Extensively used and built reports using power analyzer to generate Informatica run stats and trends and metadata reports.
• Provided CAT1 support for all the live applications and priority point of contact for production issues.
• Managed team of 6 ensuring the project deliverables to meet business needs.
• Strong experience in business team facing in understanding their needs and delivered their requirements as Informatica solutions.

Environment: s: Power center 9.6.1, AIX, DB2, Oracle, Power exchange CDC, Unix shell script, IBM MQ, Python

Confidential, NJ

Informatica Technical Leader/Solution Architect

Responsibilities:

• Exhibited strong expertise in Informatica with end-end handling project handling from the requirement gathering, preparing technical specs, development and involved in business test for signoff.
• Became part of the solution providing group and decision making leveraging Informatica tool.
• Used almost all the Informatica transformations including XML parser, XML generator, HTTP, Java, web service consumer transformation and implemented business critical process with short turnover.
• Implemented performance tuning techniques both from database side and Informatica side that reduced execution times by 60%.
• Developed number of workflows using all the transformations and critical and tricky logics.
• Developed power exchange data maps using power center navigator and implemented CDC technique using Oracle express for CDC product from Informatica. used web services consumer transformation to run workflow as service and XML transformations and responsible for maintaining and deploying workflows from one environment to other and monitoring
• Provided 24x7 production support as part of post-production support.
• Managing team of 5 playing lead Role and guiding and reviewing design by peer developers, responsible for code reviews and all the ETL team at client site.

Environment: s: Power center 9.6.1, AIX, DB2, Oracle, Power exchange CDC, Unix

Technical Lead/Project Lead

Responsibilities:

• 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.
• Documented the technical specification documents and CLG functional documents by understanding the business requirements and functional specification documents.
• Managing user and group access in Informatica.
• 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.5, OBIEE 11g, SAS EG, UNIX, Windows 7.

Project Lead

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.

Module Lead/System Analyst

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

Module Lead/System Analyst

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

Senior Software Engineer

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

Software Programmer

Responsibilities:

• Understanding the User request based on the user requirement gathering sessions by understanding the existing completed phases and analysis.
• Detailed analysis of user requirements and technical requirements provided by team lead and involved in brain storming sessions with lead for requirements.
• Involved in very deep coding and analysis and used open VMS, DIBOL, Synergy language for development and responsible for code migrations and releases for the objects developed by self.
• Exceptional in issue tracking and analyzing bug fixing on timely manner and provided quick solutions.
• Creating Test Plans for the changes and worked closely with Testing team.
• Actively participated in release meetings and proactively worked with stake holders in accomplishing release targets.
• Shown great adoptability with the frequent changing requirement and successfully delivered on the committed deliverables on time.
• Guiding junior members and doing code reviews for the new developments.
• Coding, Unit Testing, System integration Testing, User Acceptance Testing.
• Actively involved in releasing and Post Implementation Support.

Environment: Open VMS, DIBOL, Synergy, Oracle