Quality Assurance Project

CHRISTIAN K. GARCIA

*********.*.******@*****.***

Over twelve years of diversified experience in the Information Technology

industry working primarily as a Data Warehousing analyst with strong

technical leadership skills. Solid understanding of data modeling, data

mining relational database management. An accomplished Software Engineer

specializing in Object-Oriented Design and analysis with extensive

experience in the full cycle of Data Warehousing design process including

requirements definition, prototyping, proof of concept, design, interface

implementation, testing, and maintenance. Strong understanding of business

process methodologies and reengineering projects. Excellent team player

with proven inter-personal skills in working with cross-cultural teams

across multiple projects.

Technical Skills:

Development Tools: Informatica 8.6.1, 8.5, 8.1, 7.1.3, 6.2, Erwin, Actuate

7.0 and Siebel Systems 2000.

Operating Systems: AIX, SUN Solaris, Windows NT, Windows XP, MS-DOS

RDBMS: Oracle, DB2, MS SQL, Redbrick and extensive knowledge of Siebel

Applications: Quest TOAD, SQL Navigator, Visual Studio, and Microsoft

Office

Languages: SQL, UNIX Shell Scripting, PL/SQL, C, HTML, XML, Pearl, Siebel

VBA, Java, JavaScript, ASP, Microsoft Visual Basic.

Professional Skills:

CIBER, Woburn, MA

January 2008 - Present

Lead ETL Developer

Major Accomplishments:

Responsible for leading offshore development teams through the Development

Life Cycle. Implementation of the ETL solution for the European, Asian-

Pacific and US Siebel Call center Data marts. Expertise includes data

analysis, UNIX scripting and end to end implementation of ETL solutions for

Data Warehouse.

. Responsible for leading an offshore team throughout several Warehouse

Data mart projects.

. Worked very closely with Management to present status updates on a

weekly basis.

. Create all technical documentation and specifications, including the

codification of business rules, effort estimation and coordinated

development.

. Coordinate development, System testing, User Acceptance Test and

Production migration among several teams onshore and offshore to

enhance and maintain clear communications.

. ETL architecture and Data modeling involvement throughout the life

cycle of the project.

. Assist testing and deployment migration among various developers

during the life cycle of the project.

. Supervise the development of ETL Informatica mappings developed by

other team members to assure object reusability and best practices.

. Develop the complex ETL Informatica mappings and UNIX scripts to

invoke Informatica jobs and verify file transmission and manipulation.

. Provide mentoring, training and support to junior developers and team

mates.

IBM, New York, NY

March 2007 - December 2007

Lead Developer

Major Accomplishments:

Responsible for leading the development team through the Development Life

Cycle for one of the leading Pharmaceutical Companies. Responsible for the

implementation of the ETL solution for the State Spend project. Expertise

includes data analysis, UNIX scripting and end to end implementation of ETL

(Informatica) solutions for Data Warehouse.

. Responsible for leading a team throughout phase two of the State Spend

project.

. ETL architecture and Data modeling involvement throughout the life

cycle of the project.

. Worked very closely with Management to present status updates on a

weekly basis.

. Coordinated development, System testing, User Acceptance Test and

Production migration among several teams onshore and offshore to

enhance and maintain clear communications.

. Maintained existing documentation and specifications, including the

codification of business rules, effort estimation and coordinated

development.

. Assisted testing and deployment migration among various developers

during the life cycle of the project.

. Supervised the development of ETL Informatica mappings developed by

other team members to assure object reusability and best practices.

. Provided mentoring, training and support to junior developers and team

mates.

. Led and coordinated knowledge transfer efforts to operation teams.

. Developed the complex ETL Informatica mappings and complex UNIX

scripts to invoke Informatica jobs and verify file transmission and

manipulation.

. Designed and developed PL/SQL stored procedures.

. Developed new Business rule load component in the solution to load the

state and system specific parameters in the system.

BANK OF AMERICA, Providence, RI

Jan 2005 - March 2007

Tech Lead/ ETL Informatica Developer

Major Accomplishments:

Tech Lead: Responsible for leading a team throughout many projects.

Preparation of Technical specifications, including the codification of

business rules and effort estimation.

. Direct involvement in the functional sessions to define scope

translating business requirements into design specs for developers.

. Document each project development with related information and issues

encountered and coordinate with team members to set up or modify

affected objects.

. Collaborate with DBA to complete ETL performance tuning and

optimization.

. Administration of Informatica Repositories throughout the Projects

Life Cycle.

. Responsible for UNIX and Informatica migration throughout the life

cycle of the project.

. Direct involvement in upgrading Informatica Repositories from 6.2 to

7.1.3.

Data Analyst: Responsible to source system analysis to identify data to

meet user requirements.

. Define scope and design specs with the user community.

. Provide analysis, diagnose and resolve business and technical issues.

. Test and document all aspects of a case necessary to escalate

incidents to quality assurance and/or Development Team.

. Provide research and data validation for general technical questions.

. Design and carry out performance tests on customer queries and analyze

results.

ETL Developer: Responsible for the creation of the design and development

of new data marts, and existing ones while enforcing objects reusability

and best practices.

. Direct involvement in the development and delivery of complex ETL

mappings, sessions, worklets and workflows.

. Perform mapping and optimization by studying bottlenecks, performance

indicators and throughput using different techniques and strategies.

Suggesting changes to ETL architecture to achieve desired performance.

. Document of ETL processing systems.

. Coordinate development among various developers during project cycle.

. Excellent problem solving capabilities.

. Able to handle multiple rapidly-changing tasks.

. Able to work independently with cross-functional teams.

. Meticulous quality focus and attention to details.

. Analyze the source data and decide on appropriate extraction,

transformation and loading strategy.

. Create and schedule Workflows and Sessions using Informatica and/or

UNIX.

. Designed and develop unit test cases for the ETL processes.

ALLMERICA FINANCIAL, Worcester, MA

January 2001 - Jan 2005

Tech Lead/ ETL Informatica Developer

January 2002 - Jan 2005

Major Accomplishments:

ETL Developer: Responsible for the creation of the design and development

of new data marts while enforcing object reusability and preparation of

Functional and Technical specifications, including the codification of

business rules.

. Direct involvement in the development and delivery of complex ETL

maps, sessions and workflows.

. Coordinate development among various developers during project cycle.

. Able to handle multiple rapidly-changing tasks and work independently

with cross-functional teams.

. Analyze, diagnose and resolve business and technical issues.

. Test and document all aspects of a case necessary to escalate

incidents to quality assurance and/or Development Team.

. Provide research and data validation for general technical questions.

. Design and carry out performance tests on customer queries and analyze

results.

. ETL architecture and Data modeling involvement throughout the life

cycle of the project.

. Maintain Technical Specifications and required documentation within

CMM level 3.

. Direct involvement in the design specifications with the user

community.

. Working with DBA and Technology architecture to optimize ETL

performance.

Software Engineer January 2001 -

August 2002

. Played a Configurator and Developer role in the implementation of

Siebel 2000 - Financial Vertical for a Leader Insurance Company. Role

included Definition, Design, Development and testing tasks.

. Direct involvement in the functional sessions to define scope and

design specs with the user community. The implementation was focused

in Siebel Service around Accounts, Contacts, Service, Activities,

Assets and Products Objects. It included configuration efforts, as

well as, real time data interface between Siebel and Allmerica's

legacy Systems involving the following technologies/components:

Tools Configuration, Virtual Business Components, Business Service

Creation and Integration, Siebel Visual Basic, XML Converters,

Property Sets Handling, XML Parsing

EDUCATION

Worcester State College, Worcester, MA

B.S. in Computer Science

Contact this candidate