SUMMARY

• 6.5 years of experience in Datawarehousing/Datamining, job scheduling and Monitoring Tools technologies on Windows, UNIX and Linux platforms.
• Extensive experience in Informatica (9.x) applications. Designed and developed the Workflows, Worklets, Mappings, Mapplets, Sessions, Tasks, Transformations and schedule the Workflows and Sessions.
• Interacted with end - users and functional analysts to identify and develop Business Specification Documents (BSD/BTRD) and transform it into technical requirements.
• Strong experience with Informatica tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository.
• Designed and developed complex mappings to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator, Update Strategy from varied transformation logics in Informatica.
• Having strong hands on experience in extraction of the data from various source systems ranging from Mainframes like DB2, Flat Files, VSAM files, etc. to RDBMS like Oracle, SQL Server, Teradata etc.
• Extensively used Slowly Changing Dimension (SCD) technique in insurance application. Expertise in OLTP/OLAP System Study, Analysis, E-R modeling, developing Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modeling.
• Worked on optimizing the mappings by creating re-usable transformations and Mapplets. Created debugging and performance tuning of sources, targets, mappings, transformations and sessions.
• Worked on Qlikview reporting tool for Business reporting, Dashboard set up and end to end testing.
• Exposure in overall SDLC including requirement gathering, data modeling, development, testing, debugging, deployment, documentation, production support.
• Experience in Task Automation using UNIX Scripts, Job scheduling and Communicating with Server using pmcmd. Extensively used Autosys/Ctrl-M/WLM for Job monitoring and scheduling.
• Excellent analytical, problem solving and communication skills with ability to interact with individuals at all levels.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.

TECHNICAL SKILLS

Operating Systems: Windows, Linux, HP-UX

Software / Applications: MS XP, MS 2000, MS Word, MS Excel, MS Access, Outlook, PowerPoint

Database: SQL Server 2008/2005/2000 , Oracle 11g/10g/9i, Teradata 12.0

ETL: Informatica PowerCenter 8.6.1/Informatica PowerCenter v9.x, Informatica Power Exchange

Data Modeling: ERWIN, Visio

OLAP/BI Tools: Qlikview

Languages: SQL, PL/SQL, BTEQ, PERL

Web/Apps Servers: IBM Web Sphere 4x, Sun iPlanet Server 6.0, IIS, Tomcat

Tools: TOAD, Visio, Eclipse

PROFESSIONAL EXPERIENCE

Technology Lead

Confidential

Environment: Informatica, SQLServer, Autosys, Powershell.

Responsibilities:

• Designed the distribution of tables and various instances in mappings and implemented the concept of concurrent running of mapping for various instances.
• Designed the concept of file streaming on a daily basis, keeping in mind the number of source system the application is being fed from.
• Designed the transaction distribution strategy based on which Deals Type can be segregated to the customer.
• Developed mappings, workflows and UNIX script to cope up with the business needs.
• Designed and developed the trigger management in Autosys (Job Scheduler tool).

Confidential

Environment: Informatica, Oracle, Power Exchange, CA7.

Responsibilities:

• Designed the distribution of tables and various instances in mappings and implemented the concept of concurrent running of mapping for various instances.
• Developed mappings, workflows and UNIX script to cope up with the business needs.

Confidential

Environment: Qlikview, Teradata, MSFT Excel.

Responsibilities:

• Created tables with entries in Teradata with various relevant records.
• Generated reports with the above tables.

Environment: Informatica, Teradata, Power Exchange, WLM.

Responsibilities:

• Developed Workflows for Revenue Subject Area for all the regions Covered under the Project (GA/VA/NY/WEST/CENTRAL).
• Lead Role for delivery and Handovers.

Environment: Informatica, Teradata, WLM.

Responsibilities:

• Designing& development of Relational between the two DW’s and creating a data map and process flow.
• Designing and Development of Workflows for the Data extraction from the New Warehouse and Comparison of the same with the Old Warehouse.
• Designing and Development of job Scheduler using WLM.
• Lead a team of seven members for Execution of SIT and UAT for the above processes.

Environment: Informatica, Teradata, WLM.

Responsibilities:

• Designing Data map for the Process flow.
• Design and Developing the Workflows for the Job Execution.
• Lead a team of 6 for project exec and SIT and UAT for the above processes.

Environment: Informatica, Teradata, UNIX.

Responsibilities:

• Design and development of the process.
• Build the code for Annuity and Beta Systems.
• Lead a team of two for execution of build and above processes.