SUMMARY

• Over 10 years of IT experience, with more than 8 years in design, development of Enterprise Data Warehouses/Data Marts, Data Extraction, using Informatica as ETL Tool.
• Functional Knowledge in Retail, Tax Financial services and Telecom Applications
• Strong knowledge in Dimensional Data Modeling Technique, E-R modeling, Multi Dimensional Database Schemas like Star schema and Snowflake schema Fact Tables, Dimension Tables , and handling SCD's.
• Expertise in Informatica, SSIS, SSRS, Oracle, SQL Server and UNIX
• Experience in Data Warehousing, Data modelling for OLTP and OLAP
• Strong experience in single and multi dimensional data warehousing applications using Informatica, ETL, Business Intelligence, Decision Support System tools.
• Proficient in the Design and Development of process required Extracting, Transform, and Load data and Data warehousing modeling. Good understanding of source to target data mapping and Business rules associated with the ETL processes.
• Expertise in Multithreading, Object-oriented programming and Unix Shell Scripting
• Working Knowledge in C, C , C , Java Script and HTML.
• Experience programming with source control tools TFS, VSS, CVS and Subversion
• Good Knowledge in OBIEE, Business Object and Netezza.
• Good understanding and work experience with Agile/Scrum methodology
• Advocate solutions, participating in all the stages of Software life cycle, starting from Requirements procurement to realization of the system. Ability to work on multiple projects and deliver the results within estimated budget and time
• Experience in managing projects on the Onshore Offshore model.
• Proven ability to understand business problems and apply technology to formulate and manage workable solutions.
• Lead Managing a team of 8 members spread across 3 different locations and handled task allocations, clarifications to their queries effectively
• Quick Learner, willing to Learn, Adapt New Technologies, Ability to handle multiple tasks or Projects and Ability to take leadership and ownership of the entire Deliverables.

Technical SKILLS

• Operating System : Windows 2000/XP/7/8, HP-UNIX Alpha, PA-RISC, Itanium
• DW Tools : Informatica 8.6, 9.1
• Databases : Oracle 9i, 10g, 11g, SQL Server 2008, Netezza
• Languages : C , C, C , ASP.NET, PL/SQL, SSIS
• Scripting : UNIX Shell Scripting, Java Script
• Tools : Perforce, VSS, CVS, Entrek, HP Code Advisor, TFS, TOAD
• Telecom Applications : HP IUM Internet Usage Manager
• Development Methodologies : Agile and Scrum

EXPERIENCE

Senior Informatica Developer

Confidential

Experience Highlights

• Requirement Analysis Brainstorm on requirements by driving the discussions with Business Analyst and Stakeholders.
• Identify the Risks/technical challenges involved. Prototype the modules that involve technical investigations.
• Responsible for preparing the System Requirement Specification document which included the Workflow diagrams and System architecture diagrams.
• Developed mapping/session using Informatica power center for data loading.
• Used Informatica Workflow Manager Monitor to Create, Schedule, and Monitor and Send the Messages in case of process failures.
• Implementation of Different Task like event wait, event raise, email, decision, command, control.
• Deployed the developed workflows from one environment to other environment and ensured its successful running.
• Involved in so many SQL, PL/SQL Tuning activities
• Responsible for code / mapping review of team members
• Provide technical support and technical quality control to the team throughout in all stages of the project
• Responsible for guiding and mentoring offshore team on allocated tasks
• Troubleshoot and diagnose the customer issues and identify the fixes for the same.
• Have experience working with high volume systems
• Lead a team of 6 members spread across 3 different locations and handled task allocations, clarifications to their queries effectively

Senior Informatica developer

Confidential

Environment : Informatica 8.6 /9.1, Oracle 10g, SSIS, SSRS, SQL Server, Netezza, PL/SQL, UNIX, Autosys

Experience Highlights

• Involved in Designing, Development of ETL Package and customization of Reports using SSRS
• Have developed/modified complex ETL programs to populate staging tables to run the reports
• Involved in SQL, PLSQL Tuning activities
• Scheduling, Monitoring and reporting jobs using Autosys
• Provide technical support and technical quality control to the team throughout in all stages of the project.
• Responsible for guiding and mentoring offshore team on allocated tasks

Senior Software Engineer

Confidential

Environment : Informatica 8.6 /9.1, Oracle 10g, SSIS, SSRS, SQL Server, Netezza, PL/SQL, UNIX, Autosys

Experience Highlights

• Involved in design, development and testing of ETL changes
• Analyzing the data according to business requirement.
• Understanding existing business model and customer requirements.
• Involved with Design Process of Functional Design to Technical Design ETL Spec.
• Developed mappings/sessions using Informatica power center for data loading.
• Used Informatica Workflow Manager Monitor to Create, Schedule, and Monitor and Send the Messages in case of process failures.
• Implementation of Different Task like event wait, event raise, email, decision, command, control.
• Maintain the business logic like System Audit System Dimension
• Deployed the developed workflows from one environment to other environment and ensured its successful running.

Senior Software Engineer

Confidential

Environment : C , UNIX, Visual studio 2008, Oracle 10g, SQL and PL/SQL, Visual Studio 4.2, Borland C

Experience Highlights

• Have taken the complete responsibility to upgrade the STAR technology refreshment from VS4.2 Borland C to VS2010Responsible for reverse engineering the existing STAR application and prepared technical specifications.
• Responsible for gathering new requirements from the client, task Estimation, Plan, work allocation, Monitoring and Delivery.
• Involved in Code optimization, SQL Query tuning Performance improvement of the project
• Involved the project integration and end-to-end testing of the project.
• Responsible for guiding and mentoring team on allocated tasks
• Lead a 4 members team
• Involved the project integration and end-to-end testing of the project.

software Engineer

Environment : C , Pro C, SQL, PL/SQL, Oracle9i, Shell scripts, HP-UNIX Alpha, PA-RISC, Itanium , Windows XP

Experience Highlights

• Involved in development of custom solutions, Integration, Deployment and UAT
• Involved in Product Benchmark Identify the major bottleneck modules by running with the high volume of data
• Responsible for maintaining the previous version of ERM product and provided the hot fixes and patch release whenever required.
• Responsible for troubleshoot and diagnose the customer issues and identify the fixes for the same.
• Responsible for monitor execute support related tasks.
• Assisted the module owners in their overall responsibilities