yyyyyy x. yyyyyy

6914 parkridge blvd. #0000 xxxxxx xxxx , xxxx , xxxxx 00000

phone: (xxx-xxx-xxxx

abc@xyz.com

objective

 

dedicated, analytical and quality-oriented data warehouse architect/modeler eager to contribute exemplary technical talents toward supporting a progressive organization in optimizing performance.

areas of strength

 

         etl scripting/development

         ibm information framework (ifw)

         banking data warehouse (bdw)

         project management & team leadership

         oltp and dimension data modeling

         oracle and sql technologies

         architecture design

         data analysis and modeling

         software development life cycle

         structured data and process modeling

         data sourcing and data mapping

         order entry & erp solutions

         payroll processing applications

         stored procedures & database triggers

technical/computer skills

 

databases: oracle (7.x, 8i, 9i, 10g)

tools: ab initio data profiler, gde, co>operating system version 2.14, cognos reportnet, cognos 8.2 framework manager / analysis studio, informatica power center 7.1 repository, workflow manager, erwin 7.2, visio, sql navigator, toad, enterprise java beans (entity beans)

languages: c, c++, sql, pl/sql, java, uml, shell and perl scripting

operating environments: unix, windows

professional experience

 

citigroup commercial business group, usa, 2005 to present

architect / senior consultant

• expertly plan and architect credit platform initiative (cpi) requiring reporting data mart and repository out of loanpath data.
• apply dynamic organizational skills to devise strategy and roadmap for deliverables, provide functional solution and frd (functional requirements documentation) to eti team, and conduct analysis of banking source systems such as afs and impacs.
• cooperate with citi business and 3^rd party vendor (third pillar) to deploy integrated client view and achieve real-time data processing of loan.
• assemble and integrate etl scripts in ab-initio framework for icv (integrated client view) as well as cpi reporting projects, exhibiting strong attention to accuracy and efficiency.
• perform analysis of loanpath application and frequently communicate with clients and team members regarding data status and issues.
• instrumental in expediting $65m cpi project by synchronizing legacy system with vendor product.

 

data warehouse architect

         actively contributed to icv solution for cpi project that features real-time feeding of loanpath data for credit scoring and syncs it with banking data warehouse.

         built denormalized data model on real application cluster (rac) of oracle 10g database to fulfill business requirement of data extraction and querying.

 

continued

 

arpit pandya ~ page 2 of 2

 

professional experience continued

 

         defined and conveyed functional specifications to etl team, provided frd, analyzed banking source systems, and implemented etl scripts in ab-initio framework.

         contributed to complete process of acquiring data from source system, integrating within cbg customer hub, and transferring to loanpath (third pillar s credit application tool).

         formally recognized by citi management for displaying exceptional performance throughout project.

 

data modeler (business process, etl flow and bi reports)

         participated in customer profitability project ibm s bdw with repository, data mart, integrating metadata layer to the architecture and master data management of customer information.

         seamlessly integrated business requirements with data/etl processes within soa (service-oriented architecture), and implemented ibm s information framework via m1 for bdw.

         wrote reporting scripts in cognos framework and etl scripts in ab-initio framework.

         created dimensional data models such as star and snowflake in data mart and data repository.

         exercised a strong team player work ethic in contributing to profitability model components encompassing expense, cost of fund and credit, revenue, and returns.

         defined aggregations, hierarchies and sub-dimensions in data mart to optimize query performance in cognos.

         played a major role in analyzing customer and dealer data, and hierarchies for customer, dealer, relationship manager (rm), and product using sql navigator and ab initio data profiler.

         handpicked as sole independent consultant among team of 55 based on provide technical acumen and troubleshooting proficiency.

 

daimler chrysler, michigan, 2002 to 2005

oracle data warehouse modeler team lead

• advanced from role as pl/sql developer to direct team of 12+ project team members in oracle data warehouse application for company s human resources department.
• spearheaded implementation efforts with a constant eye on ensuring data integrity, business continuity, and minimum downtime.
• demonstrated excellent multi-tasking skills in designing etl routines via oracle pl/sql, writing shell scripts for data file uploading/downloading, and preparing ad-hoc reports based on sql logic.

 

additional experience:

 

data architect iron mountain record management, canada, 2005

consultant / database developer juniper bank, delaware, 2001 to 2002

application developer kansult computers, india, 1998 to 2001

senior programmer hi-tech software services, india, 1997 to 1998

certifications

 

pmp project management institute (pmi)

itil information technology service management forum

sun certified java 2.0 programmer (scjp)

oracle certified professional (ocp) database sql expert (1z0-047)

education

 

bachelor s in engineering, first class with distinction, gujarat university, india, 1995

 

training/professional development:

         oracle financials (general ledger, payable, receivables) ● sap bw 2005

         ab initio graphical development environment ● cognos reportnet

 

yyyyyy x. yyyyyy

6914 parkridge blvd. #0000 xxxxxx xxxx , xxxx , xxxxx 00000

phone: (xxx-xxx-xxxx

abc@xyz.com

 

 

 

 

date

 

 

 

hiring agent name

title

company name

address

city/state/zip code

 

dear__________________:

 

i am currently seeking a challenging career opportunity in a <insert job title/position> capacity and am submitting my resume for your review. in advance, thank you for your time and consideration.

 

as indicated in the accompanying resume, i bring to you a 12-year background in it, proven talents in project/team management, and exceptional strengths in data warehousing, data modeling, and etl development/scripting. to complement these qualifications, i offer solid analytical, problem solving, critical thinking, and planning skills as well as proficiency in using ab initio, informatica and cognos tools. my certifications include:

        pmp project management institute (pmi)

        itil information technology service management forum

        sun certified java 2.0 programmer (scjp)

        oracle certified professional (ocp) database sql expert (1z0-047)

 

as a proactive contributor to your organization, you will find me to be a self-motivated professional and stellar leader committed to supporting you in achieving your objectives through technical acumen, versatility, and exemplary communication skills. i am confident that i could be a valuable asset to your company, and look forward to interviewing with you in the near future.

 

sincerely,

 

 

arpit pandya