Consultant - Lead Analyst & Team Leader Resume Wilmington DE - Hire IT People

SUMMARY

9+ years of IT experience in analysis, design, development, testing and Implementation of Informatica Workflows using Data Warehousing/Data mart design, ETL, OLAP client /server applications.
Solid understanding of ETL design principles and good practical knowledge of performing ETL design processes through Informatica.
Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
Maintained outstanding relationship with Business Analysts and Business Users to gather information needs as per the business requirement. Lead a Team of 10 resources in working with offshore and onsite co - ordination.
Critical thinker who is self-starter and willing to take initiative and work with little or no supervision.
Demonstrated proficiency in improving re-usability, automation of data loads, performance tuning in Informatica by identifying bottlenecks and database performance.
Analytical and Technical aptitude with the ability to solve complex problems.
Excellent Written, Communications and Analytical skills with ability to perform independently as well as in a team.
Ability to work in teams as well as individually, quick learner and able to meet deadlines.

TECHNICAL SKILLS

ETL Tools: Informatica power Centre 9.x/8.x, Datastage

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting

Operating Systems: WINDOWS 7/Vista, XP/2003/2009/NT/98/95, MS-DOS, Unix/Linux

Office Applications: Microsoft Word, Excel, Outlook, Access, Project, PowerPoint

Databases: DB2.SQL Server 2008/2005, Oracle 11i/10g/9i

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington DE

Consultant - Lead Analyst & Team Leader

Responsibilities:

Leading a Team of 10 resources in Current Project - Collection, Litigation & Recovery Process to CACS system
Developed complex mapping using Informatica Power Center tool and configured Informatica with DAC.
Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
Lead a Team of 3 people used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings.
Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA, UAT,Prod).
Performed a DB Administration roles for Monitored and improved query performance by creating views, indexes, hints and sub queries.

Confidential, Washington, DC

Consultant - Senior ETL Developer

Responsibilities:

Understanding the functional specifications and the documents related to the Architecture.
Understanding legacy systems data and building, designing Target DB schema.
Developed InformaticaMappings, Sessions and Workflows.
Tuned Queries on Oracle DB to improve performance.
Responsible for populating the business rules using mappings into the Repository for Meta data Management.
Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
Monitored and improved query performance by creating views, indexes, hints and sub queries
Extensively involved in enhancing and managing Unix Shell Scripts.
Developed workflow dependency in Informatica using Event Wait Task, Command Wait.

Confidential

Consultant - Senior Developer (Offshore)

Responsibilities:

Participated in all phases including Client Interaction, Design, Coding, Testing, Release, Support and Documentation.
Interacted with Management to identify key dimensions and Measures for business performance.
Generated weekly and monthly report Status for the number of incidents handled by the support team.
Worked on data conversions and data loads using PL\SQL and created measure objects, aggregations and stored in MOLAP mode.
Involved in Performance Tuning.
Worked for some time in Support Activities (24*7 Production Support), Monitoring of Jobs and worked on enhancements and change requests.
Familiarity with Data Analysis and building Reports and Dashboards with OBIEE.

Confidential

Consultant - Developer

Responsibilities:

Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer &Mapplet, and Transformation Developer.
Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.
Scheduled Sessions and Batches on theInformaticaServer usingInformaticaServer Manager/Workflow Manager.
Writing documentation to describe program development, logic, coding, testing, changes and corrections.
Optimizing the mappings by changing the logic to reduce run time.