PROFESSIONAL SUMMARY:

• An excellent leader/team player with strong communication and interpersonal skills with the ability to effectively and professionally communicate with clients and customers.
• Experience in all phases of the project life cycle including Requirement Analysis, Design, Coding and testing. Worked in technical architecture, data modeling, requirement study, system analysis and testing.
• Extensive experience in the development of mapping, transformation standards and processes using Informatica PowerCenter as the ETL tool. Experience in leading technical teams.
• Over 9 years of IT experience with Data Warehouse/Data Mart Development Life Cycle.
• Specialized expertise in the use of all modules in the Informatica Power Center 5.1/6.x/7.x/8.6 suite.
• Well experienced in translating business users’ needs into ETL Technical Design Documents, Process Documents and Requirement Specification documents. Participated in the requirements gathering, sizing, designing, developing, testing and deployment of the requirements.
• In - depth, hands-on knowledge of Data warehousing, methodologies, designing of complex multi dimensional schema, enterprise wide data warehouses and data marts. End-to-end experience in large and complex data warehouses, from conceptualization to production roll out.
• Proficient knowledge and experience in working with Relational and Non-Relational Source and Target systems.
• In-Depth understanding of DB2, Oracle and MS-SQL Server and Teradata Databases. Proficiency in Oracle PL/SQL. Expert in creation of stored procedures, packages to define ETL processes.
• Release management, build and code migration to environments and version control techniques as applicable to DW/BI. Have worked in ISO 9000 environments. Have developed and fine tuned procedures and methodologies in a DW/BI context to achieve optimal results.
• Have successfully managed onsite/offshore delivery models. Developed processes and methodologies to ensure quality and consistency in delivery.
• Proficient in designing and implementing Unix/AIX /MKS Toolkit Shell Scripts.
• Six Sigma methodology implementation, active and progressive Quality Initiatives.
• Process Review responsibilities (Software Auditing). Active Quality Ambassador who suggests means to improve the processes followed by different projects within an organization. Pointing out and suggesting Best Practices for each of the projects reviewed.
• Extensive experience in dissemination of work and coordinating with offshore resources to produce quality work within aggressive deadlines. Strong leadership, planning, execution, people management and mentoring skills.
• Excellent analytical, problem-solving and communication/interpersonal skills.

TECHNICAL SKILLS:

Data Warehouse ETL Tools: Informatica PowerMart 4.7/5.0/6x, Informatica PowerCenter 5.1/6x/7x/RT/8.1/8.6, Informatica PowerConnect. Knowledge of IBM Datastage 7.1

Reporting Tools: Knowledge of Business Objects 5.1, Cognos, Brio, Microstrategy, Web Intelligence

Data Modeling/Tools: Star & Snow Flake Schema, Dimensional Modeling, Erwin 4.1

Methodologies: Ralph Kimbal, Bill Inmon, Waterfall, IBM Methodology

RDBMS: DB2 v8.1, Teradata, MS: Access, Oracle 10g/9i/8i, MS-SQL Server 2000

Programming: C, C++, SQL, PL/SQL, Assembly Language

Scripting Tools: Unix/AIX/MKS Shell scripting and Perl Scripts

Web Technologies: HTML, XML

DB Utilities: SQL * Plus, SQL * Worksheet, SQL * Loader

OS: AIX, Sun Solaris, MS Windows NT / 2000 / XP

PROFESSIONAL EXPERIENCE:

Confidential, Thousand Oaks, CA

Informatica Developer

Responsibilities:

• Currently working on the interfaces for external vendors for CMA (Covance, Pharmagistics, Accredo/McKesson etc). Brought down the execution time by an average 20% for all the external interfaces.
• Worked on Informatica 7.1/8.6 - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformations and Session Manager.
• Creation of Unix Scripts/MKS Toolkit shell scripts to define/control ETL processes, interlink between Windows and Unix machines as Informatica 8.6 is a pure windows machine.
• Involved in the enhanced development of Informatica mappings and also tune them for better performance. For CMA, the process was improved by 35% in accordance to performance.
• Creation of Design documents, Test case documents and UAT/Production support in time constraint assignment.
• Study data cleansing needs and interact with users for cleansing of data before it is loaded into the Data Warehouse.
• Performance tuning of Mappings/Sessions and work flows.

Environment: Informatica Power Center v7.1/8.6, Oracle 10g/9i - PL/SQL, MS-SQL Server, DB2 v8.1, Perl, MKS Toolkit.

Confidential

Project lead/ ETL Developer

Responsibilities:

• As a startup, created Functional and Application Information Documents for all related applications and brought the process under GWA and GNA architectures without any documentation in place.
• Involved in four applications (RoHS, CRS, ASource and CBB Metrics), and all associated databases/datawarehouse development.
• Involved in “IPD Divestiture” in 2005, a complex migration and integration of all applications identified by Lenovo users, when Lenovo took over the PC division from IBM. This Divestiture was implemented as 2Q 2005 release. Efficiently handled the assignment to deploy this within tight timelines.
• Actively participated in the requirements gathering, sizing, designing, developing, unit testing and deploying of business needs. Supported Integration/UAT testing.
• Data Integration and ETL from different source systems including flatfiles, excel files, relational databases, xml sources and MQ Series data. Creation of stored procedures, packages, custom functions to define ETL processes in Oracle 9i and DB2.
• In association with the extended team, designed and implemented end-to-end solution from source definitions, target definitions, transformations, mappings, mapplets, sessions, workflows and worklets. Created re-usable mapplets, worklets wherever possible.
• Handled frequent requests for change of dataload-CRONs from Lotus Notes to DB2 as well as from different legacy systems to DB2 so as to maintain a central repository called Datamart. Worked on PowerConnect to handle real time MQ Series data.
• Lead and manage the team by co-coordinating with the extended team. Responsible for maintaining all documentation for technical as well as process quality purposes.
• Generated BRIO reports based on the centralized repository maintained and as and when requested by the users. Used Brio for testing purposes too, keeping in mind, Brio query is much simpler than the SQL query.
• Provided Training, Production support and Knowledge transfer to the clients and end-users.
• Survey of customer queries and resolution on “ON-DEMAND’ basis.

Environment: IBM Datastage, Informatica Power Center v6.0/7.1.2/RT, Oracle 10g/9i - PL/SQL, Brio v6.1, Teradata, DB2 v8.1, Lotus Notes/Domino v6.0, Perl, AIX v5.0.

Confidential, Atlanta

ETL developer

Responsibilities:

• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformations and Session Manager.
• Creation of stored procedures, packages, custom functions to define ETL processes using Oracle 9i.
• Involved in the enhanced development of Informatica mappings for Basement to 1st floor to 2nd floor and also tuned them for better performance.
• Creation of Design documents, Test case documents and UAT/Production support.
• Running and Testing Base load and Incremental load. Used ETL to load data from Oracle. Developed routine for data extraction/loading.
• Study data cleansing needs and interact with users for cleansing of data before it is loaded into the Data Warehouse.
• Performance tuning of Mappings/Sessions and production support and scheduling of loads for different datamarts.
• All the above-mentioned activities were reiterated for new business needs and evolvement of the Data warehouse.

Environment: Informatica 5.1/6.0, Business Objects 5.x/6.5, Oracle 8i/9i, Citrix, PL/SQL.

Confidential

ETL developer

Responsibilities:

• Involved in requirement analysis, design and development of mappings.
• Maintenance of logical & physical data model by defining strategy for Star schema with fact & dimension tables based on functional designs featuring Dimensional Modeling.
• Involved in the development and maintenance of data loads, changes in mappings and monitoring the data.
• Provided data analysis and feedback on transaction accounts.
• Efficiently involved in support-act to familiarize the prompt and effective use of the system.

Environment: Informatica, Cognos BI Impromptu, PowerPlay Transformer, Oracle 8i.

Confidential

ETL Developer, BO Developer

Responsibilities:

• Involved in the creation of a number of ETL programs using Informatica for transforming data from various sources and legacy systems into a warehouse.
• Managed user profiles for effective distribution of responsibilities.
• Designed BO universes for proper understandability of various sections of business.
• Also created intermediate user classes and subclasses for effective and easier usage of data keeping in mind, the different types of users. The data was represented in the form of dimensions, details and measures for usage in universes and documents and filtered according to the business need.
• Implemented contexts and aliases as a method of avoiding fan traps and chasm traps in the database design.
• Provided assistance and guidance for the end-users in the respective areas by generating and publishing reports for analysis purpose.
• Worked exclusively on BusinessMiner so as to forecast new and innovative trends in businesses and to dig out hidden information imperative for businesses.
• Also provided assistance for the reciprocal usage of InfoView and WebIntelligence for effective distribution of generated documents to concerned and respective end users.

Environment: Informatica, BusinessObjects 5.0, BusinessMiner, WebI 2.6.

Confidential

Application Developer

Responsibilities:

• Studied the project requirement and designed the project.
• Created tables, views, synonyms and sequences
• Created Database Triggers, Stored Procedure, Functions and Packages
• Optimized queries using rule based & cost based approach.
• Used SQL Loader for data loading.
• Modified existing forms, reports, and graphs as per the enhancement.
• Tested all the new and modified program units.

Environment: Oracle 8i, PL/SQL, Windows, Unix