Resume Company – The Internet’s Very Best
The Following Text Is An Unformatted Professional Resume Sample
From The Writers At Resumes Guaranteed

Click HERE!

yyyyyy x. yyyyyy

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

phone: (xxx-xxx-xxxx



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 3rd 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.




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



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)



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









hiring agent name


company name


city/state/zip code




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.





arpit pandya

<< Previous           Back to Sitemap           Next >>

Remember: Hire Us To Write YOUR New Resume
And We GUARANTEE That If You’re Not Working In 60 Days Or Less,
We’ll Revise Your Resume, Refund Your Money,
AND Give You $50 EXTRA!

Click HERE!