SUMMARY:

• Over Eight years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Extensive experience with analysis, design, development, customizations and implementation of complete life cycle of an Enterprise Data warehouse
• Extensive experience with analysis, design, customization and implementation of Banking Data Warehouse and International Insurance Ware house.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Strong database skills, Object Oriented Programming and development knowledge.
• Experience in leading and managing teams. Handled multiple roles - ETL Architect, Project Lead, Developer, and Application Administrator.
• Executed software projects for Insurance, Manufacturing, Banking, Retail, Pharmaceutical and Process industry.
• Exceptional analytic and problem solving skills. Team Player with the ability to communicate effectively at all levels of the development process.
• Hands on experience in Star and Snow flake schema design and De-normalization techniques
• Well versed with Data warehousing concepts
• Used multiple RDBMS including Teradata, Oracle 8i/9i/10g/11g, SQL Server and MS Access
• Well versed with Pushdown Optimization in Informatica.
• Worked extensively on variety of Teradata fast load techniques using Informatica.
• Have complete knowledge on job scheduling using UC4, AutoSys, Control-M.
• Worked with different Data sources ranging from flat files, Teradata, Oracle, SQL server, DB2 databases
• Worked with Different types of files, EBCDIC, Delimeted, Fixed width. Used Power exchange to extract EBCDIC file data and load to Teradata tables.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS:

• Data Warehousing/ETL Tools Informatica Power Center 7x/8x/9x & IBM InfoSphere DataStage Operating Systems Win3.x/95/98/2000
• Windows NT 4.0
• Sun Solaris 5.8
• and IBM AIX 5.x Databases Teradata
• DB2UDB/EEE 8.2/7.1
• Oracle 11g/10g/9i/8i/8.0/7.0
• MS SQL Server and MS-Access Languages PL/SQL and SQL
• Java
• Oracle SQL
• C
• C++ and Java Script Database Tools SQL Loader 9.2
• TOAD 7.5
• SQL* Plus 9.2
• DB2 Import
• DB2 Export and Rapid SQL. Other Tools Quality center
• Rational Clear Case and Clear Quest
• Peregrine
• ITPAM
• Clarity
• i2 Supply Chain Planner (SCP)
• i2 Performance Manager(PM)
• i2 Demand Manager Trained Tools Information Analyzer
• Teradata Viewpoint
• Power Analyzer Scheduling Tools Autosys 4.0/4.5
• TWS Tivoli - Maestro
• Control M 6.4
• IBM UC4 Systmes
• Control-M

PROFESSIONAL EXPERIENCE:

Confidential, OH

ETL Lead

• As a lead ETL Lead - my primarily roles includes ETL Design, Task planning, scheduling, allocation and tracking the task closely to identify potential risks and issues to ensure on time delivery.
• Responsible for designing End to End ETL Solution for Credit Data Mart for Business Banking part of JPMC.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results
• Responsible for leading a project team in delivering solution to our customer in the Financial sector.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Utilize in-depth knowledge of functional and Technical experience in Data Warehousing and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment & Skills: Informatica 9.1.1, Informatica PowerExchange, Teradata 12, UNIX AIX, Control M 6.4, Peregrine, ITPAM, SVN.

Confidential, VA

Project Lead/Informatica Consultant

• As a Project Lead responsible for Analysis, design, development, testing and implementation of customized IIW model solutions for new implementations and upgrades for our IBM US customer Confidential .
• Responsible for leading a project team in delivering solution to our customer in the financial sector.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Responsible for managing scope, planning, tracking, change control, aspects of the module in the project.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of functional and Technical experience in IIW and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment: Informatica PC 8.6, MS SQL Server, Oracle 9i, Automate, HP Quality Center

Confidential, Columbus, OH

Team Lead

• Understanding the Supply Planning and Order Fulfillment planning processes of Infineon
• Understanding the SCM IT Landscape and interfaces between various applications like SAP, i2 SCP and i2 DF
• Understanding the business requirements clearly and creating the SRS and DSD documents.
• Coordinating with Other Planning systems for executing Integration testing and User Acceptance testing
• Work with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents
• Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization; Analyze product impact
• Present and defend product designs and architecture to clients
• Coordinate and communicate tasks with developers
• Ensure that development is performed as per requirements
• Communicate activities/progress to project managers, business development, business analysts and clients
• Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients to oversee the acceptance and dissemination process

Environment: i2 Supply Chain Planner, i2 Demand Manager, PL/SQL Developer, Oracle 10G, Business Objects XI, UC4 Automated Systems.

Confidential

Module Lead

• Designing the interfaces between i2 systems and reporting databases
• User interface design and development for reporting and data maintenance using i2 Performance Manager (PM)
• Automate business processes using i2 Agile Business process Platform.
• Designing and develop the integration between i2 TM, i2 ABPP and i2 PM.
• Created and designed mappings and mapplets using Informatica S ource analyzer, Warehouse designer, Transformation developer, Mapplet designer and Mapping designer .
• Designed and developed various Derived facts to fullfill KPI requirements.
• Created various Reports, Dashboards, Indicators, and Score Cards using Power Analyzer .

Environment: i2 Performance Manager, i2 Agile Business Process Platform, i2 Transportation Manager, Informatica 8.1.1, Oracle 10g, MS-VSS, PLSQL Developer

Confidential

Offshore Team Lead

• Studied the project requirement and designed the project.
• Analyzed the sources, Targets, Transformed the data and Mapped the data and loading the data into Targets using Informatica.
• Experience in Development the Mappings using needed Transformations in Informatica Tool according to technical specifications.
• Developed various mappings to load data from various sources using different transformations like Router, Aggregator, Joiner, Lookup, Update Strategy, Expression and Sequence Generator to store the data in target table.
• Developed various clients of Mappings.
• Testing and maintaining of Informatica Mappings.
• Resolving if any issues in transformations and mappings with the help of technical specifications.
• Involved in Unit Test cases.
• Created tables, views, synonyms and sequences. Used SQL Loader for data loading.
• Optimized queries using rule based & cost based approach.
• Used SQL Loader for data loading.
• Modified existing forms, reports, and graphs as per the enhancement.