CAREER OBJECTIVE:

To obtain a position of responsibilities that utilizes my skills/experiences and keen to achieve high carrier growth through a continuous learning process by keeping myself dynamic, visionary and competitive with the changing scenario of today’s world.

PROFESSIONAL SUMMARY:

• Overall 9 plus years of IT experience in Data warehousing projects, primarily as specialist in performing Analysis, Design, Requirement gathering, Development, Testing, Implementation, Migration, Deployment, Release Co - ordination, Enhancement and Maintenance of Informatica ETL solutions in Production and Non-Production Environments.
• 8+ years of strong experience in Informatica (Powercenter) versions and UNIX shell scripting.
• Strong Business and Data Warehousing understanding of verticals like in CCAR regulatory project in the Banking Domain, Corporate Insurance Domain and Retail & Supply chain Domain.
• Experience in Data Warehouse projects using Informatica as ETL tool, Oracle as RDBMS, UNIX and Windows Operating Systems.
• Expertise in ETL process using Informatica Power Center components; Mapping Designer, Workflow manager, and Workflow monitor.
• Expertise in transformations like Source Qualifier, Aggregator, Filter, Joiner, Expression, Lookup, Update Strategy, Expression, Sorter, Union, Router, Sequence Generator, Stored procedure, Rank, Transaction control transformations according to the business rules and technical specifications.
• Extensive use of mapping and session parameters and properties, variables, pre-session and post-session SQLs.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow
• Proficient in understanding business processes / requirements and translating them into technical requirements, creating conceptual design, development and implementation of software application and integrating new enhancements into existing systems
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills
• Certified in ORACLE SQL.

EXPERIENCE SUMMARY:

Confidential, San Ramon, CA

ORACLE DBA

Responsibilities:

• Understanding the business requirements and functional specifications of the client module
• Design and development standpoint for the development team
• Prepare the templates for the functional specification review, technical specification, unit test case
• Designing and corresponding actuate report templates
• Development of migrating actuate reports
• Identify the process gaps and provide alternatives to the project team
• Test planning for cumulative updates
• Generating proxies and buddy testing and peer code review
• Prepare the templates for the technical specifications, unit test case, string test case, based on functional specification
• Build technical specification and technical specification review based on functional specification
• Interface development and complete design, build, test and deploy phase
• Technical assistance from design and development standpoint
• Documenting the test case scenario steps followed for various tasks for specific module
• Planning the test activities and preparation of test scenarios as per customer requirements
• Customization of various applications/reports and implementation of selected business model.
• Make additional setups to implement new business processes, develop integration test scripts to repair business flow
• Define test data for integration testing from legacy deport repair process and carry out system study set-up of various modules,
• Functional analysis of specifications, tracking tickets arise from customers and resolving problems
• Identify customer’s business flow and gap analysis, provide recommendations in key strategic areas involving competitor performance
• Design, tracking and coordinating project activities to meet project deliverables
• Develop enhancements, system documentation, and production support and implement procedures for quality improvement and development.
• Release Coordinator for Production/UAT implementation and migrations.
• Single handedly built an overall CCAR Production job Dashboard report as a value adds.
• Single handedly implemented Gather statistics maintenance on whole of CCAR table and frameworks as a value adds.
• Recently Confidential passed the CCAR Fed submission and was one of the few developers worked from initial days of the project.

Confidential, Richardson, Texas

Responsibilities:

• Business Requirement Analysis.
• Provided consulting support to the Tech Infrastructure team for Installing, Configuringthe ETL and Reporting engines
• Preparing the A Functional specification document.
• Development of Customized Informatica ETL Mappings for UniversalAdaptor (flat file sources)
• Understanding the ETL Data Extraction for Oracle/ Confidential Adapters
• Involved in ETL process from development to testing and production environments.
• Extracted data from various sources like - Flat files,Oracle,Teradata and loaded it into Target systems.

Confidential

Responsibilities.

• Understanding of the User requirements
• Business Requirement Analysis.
• Provided consulting support to the Tech Infrastructure team for Installing, Configuring the ETL and Reporting engines
• Preparing the CF250/MD200 Functional specification document.
• Development of Customized Informatica ETL Mappings for Confidential Adaptor (flat file sources)
• Understanding the ETL Data Extraction for Oracle/ Confidential Adapters
• Involved in ETL process from development to testing and production environments.
• Extracted data from various sources like - Flat files,Oracle,Teradata and loaded it into Target systems using Informatica 8.6.1
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation, transaction control transformation
• Tuning of Informatica ETL mappings for maximum performance
• Development of Custom OBIEE reports as User requirements
• OBIEE Development/Administration
• Creating and Assigning OBIEE Catalog Permission to Users groups.
• Gained good knowledge in Perl/Shell Scripting and implementing complete automation of ETL batch extraction

Confidential

Responsibilities:

• Involved to Prepare Technical design documents based on Functional Design documents.
• Extract data from oracle sources, transform it and load into OOD Application using Web services consumer transformation.
• Worked on various types of Transformations like Lookup, Expression, Router, Update Strategy, Joiner, Filter, Aggregator, Web services consumer, Http, Transaction control and Sequence Generator.
• Involved in preparing the Documentation for the mappings based on the Business Requirement.
• Worked on Informatica - Source Analyzer, Data Warehousing designer and Mapping Designer Mapplet Designer and Transformations.
• Review the code and technical design documents prepared by other team members.
• Done Unit Testing for the developed mappings
• Maintain the relations with Offshore and Onshore Team members to improve the quality of Development.