SUMMARY

• 7 years of IT experience with ETL experience throughout which include 7 years of INFORMATICA full life cycle implementations including analysis, design, development, testing, deployment, post - production support/maintenance, documentation, performance tuning.
• Comprehensive industry experience. Have worked in Banking (Risk Technology), Media & Publishing, Insurance and Logistics industries.
• 5 years of experience in Banking Domain, especially in Trade Finance and Risk Technology.
• 7 years of working experience with Informatica tool through 6.x to 8.6.1, designing and developing Informatica mappings for ETL.
• Excellent implementation of data warehouse/data marts using various data warehouse concepts and principles like Slowly Changing Dimensions, Normalization/Denormalization (Star and snow-flake Schema Modeling), data enrichment, data quality check(nullability, length, data type check, domain value check, granularity, integrity check)
• Strong ETL design and development skills to cater to data needs for applications, to supply data to middle office/ back office from various front office systems, for risk calculations, to cleanse and enrich data from third party or vendor, to create temporary data marts for validating changes during mergers. Also have experience upgrading mappings from 7.x to 8.6.1
• Experience in extracting/massaging/loading data from various sources like Oracle 9i/10g, DB2, Flat Files, MS SQL Server 2008/2005, Sybase, Stored Procedures.
• Developed simple to Complex mappings from varied transformation logics like UnConnected/Connected lookups (static/dynamic cache), Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Good understanding of Unix Shell scripting (for pre and post session commands, for starting and controlling informatica workflows using pmcmd commands in script) and scheduling tools like Autosys (creating/changing JIL files, monitoring/controlling jobs).
• Extensively worked with SFTP/SSH file transfer and loading using SQL, PL/SQL, SQL *Loader.
• Expertise with SQL - Oracle, DB2, SQL Server.
• 2 years of experience designing and implementing web based and windows based applications. Worked on a complete software development lifecycle of applications web based applications using VB/ASP/XML/XSL and C#. Net/ASP .Net and windows based applications using VB .Net. Experience working with Telephony API SBTSAPI with VB.Net to establish desktop telephony.
• Proactive in running pilot projects and doing proof of concepts, intuitive and continually learn new technologies and update my skills. Strong analytical skills and a problem solver. Excellent communication and interpersonal skills.
• Proven team player and a team leader for a team of 10+.

TECHNICAL SKILLS

Methodologies: ETL, Object Oriented

Programming: SQL Oracle 10g, DB2

ETL Tool: Informatica 8.6.1

Scripting: UNIX Shell Script

Other Technology known: Dot Net

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Tech Lead

Responsibilities:

• Coordinating a team of 10+ which includes guiding the team technically, ensuring quality and on time deliveries, tracking tasks with regular status updates. Also handling new inductees to the team.
• Understanding the requirements for the enhancement or fix through mail communications, Conference calls and Query Logs.
• Performing Impact analysis, creating proof of concepts and communicating the observations.
• Creating design, providing estimates and test plan.
• Coding in Informatica and UNIX - Shell Script, writing Oracle SQL scripts.
• In case of performance improvement, finding the best performance tuning technique, creating environment to test performance and implementing.
• Process improvements like creating automated scripts for repetitive tasks, creating induction manual for new entrant. Regular team meeting to share challenges, s and best practices, creating process documents and having regular revisions.

Confidential

Team Leader

Responsibilities:

• Communicating and understanding requirements with regular meetings with client, participating in stakeholder’s meetings, updating client with offshore activities, scheduling meetings to discuss impact of a new change with downstream and upstream application representatives.
• Assigning tasks to offshore team members, providing them with necessary inputs for development tasks, tracking the task with regular status updates, scheduling meetings to discuss work challenges and issues, reviewing mappings and test results.
• Analyze Design and Develop Scripts for changes to existing feeds or additional source feeds.
• Coding in Informatica and Unix - Shell Script, writing Oracle SQL scripts.
• Unit test, Integration test and System test.
• Running a complete refresh of test environment data starting from the first day load to the current day load in a single day.
• Creating deployment groups and tracking new releases, providing warranty support during test environment and production environment implementation. Also creating documents and for support activities.
• Providing L3 support to production issues.

Confidential

Module Leader

Responsibilities:

• Analyze Design and Develop Scripts, Unit test, Integration test and co-ordinate with onsite for System testing.
• Creating the end to end design for data process consisting of several sub-processes that make up the complete Transaction-Hub BASEL Process.
• This also includes providing estimates and test plan.
• Developing ETL process and feeds that will take data from the various Trade Transaction Systems (and other data sources) and then store this data in the Transaction-Hub data repository.
• As this involves multiple lines of business system records, the design and development includes integrating the data into single data repository.
• As a module leader, coordinating between onsite coordinator and the team members. Also reporting to project lead with status updates.
• Unit testing based on the test plan and collecting the test results to prove correctness of load. Performing many iterations of test load for checking change data capture methodology implemented in the code.
• Creating a complete migration document for all the work products which also includes the step by step method of implementation in higher environments.
• Creating documents on how to perform test loads and helping the testing team perform it. Looking into the defect entered in Quality center and providing a fix.

Confidential, Minneapolis, MN

Programmer

Responsibilities:

• Analyze Design and Develop Scripts, Unit test, Integration test and co-ordinate with onsite for System testing.
• Integration of It Project Request and IT Project Effort Tracking.
• Pull out required tables in separate database.
• Providing Estimates.
• Coding in VB, VB .Net, XML etc.
• Unit Testing and System Testing

Confidential, Dallas, TX

Programmer

Responsibilities:

• Analyzing, Designing, Implementing, Testing and deploying the Silverlight application using C# and Sql Server 2000.
• Providing Estimates.
• Coding in VB, VB .Net, XML etc.
• Unit Testing and System Testing

Confidential, Minneapolis, MN

Programmer and Configuration Manager

Responsibilities:

• Analysis of Informatica Loads
• Providing Estimates for Informatica Workflows
• Coding in Informatica
• Test Loads.