Warehouse Architect Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Mia Bahirat                                                                         

Email mia.bahirat@capgemini.com

Phone +1(207)-838-9876

Experience summary

• Exceptional background in analysis, design, development, customization, and implementation and testing

of software applications and products.

• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and DataStage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2 UDB, Teradata, Netezza.
• Data warehouse architecture development and enhancement.
• Data modeling using a variety of popular ERD tools.
• Physical and logical modeling of database and associated objects.
• ETL architecture design, development and implementation.
• Structured and iterative data warehouse and application development lifecycle methodologies.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Strong leader with experience training developers and advising technical groups on ETL best practices.
• Excellent exposure towards design/prototype building of reusable components.
• Production and development Oracle, DB2 UDB, MySQL, Teradata database administration.
• Experience in database migration projects.
• Excellent in UNIX shell scripting – Application related.
• In-depth knowledge of SQL. Experienced in implementing business logic in backend using Stored Procedures, Triggers, Views, Scripts and Functions.
• Experience in large team handling, getting project executed as per project plan.
• Quick learner with any tools.

Technical experience

Tools:                                     DataStage PX, Ab Initio, Informatica, ERWIN, Visio, Oracle Designer.

Operating systems:              Unix (SCO, UnixWare, SunOS, Linux), Windows NT/2000.

Databases:                            Oracle versions 7 to 10g database/associated tools/Oracle Enterprise Manager, Teradata, DB2 UDB EE/EEE, Microsoft Access, MySQL, Flat File systems.

Reporting tools:                   Crystal, Business Object XI, and Oracle Discover.

Languages:                           SQL, PL/SQL, TSQL, Unix Shell Scripting, Cobol, C, C++

Industries:                             Finance, Manufacturing, Banking.

GUI Tools:                             Developer 2000.

Work Experience Summary

Capgemini (Feb 2005 to Till Date) – Lead Consultant.  (7 years)

Kinetic Engineering Ltd (Sept 1999 to Jan 2005) – Senior Programmer. (5 years & 5 moths)

Experience

TD Bank, Portland, ME                                                                                                   

Duration: April 2009 to Till Date

·         Business logic modeling, development & implementation using Oracle PL/SQL Package

·         Optimization and Performance tuning for SQL’s and PL/SQL

·         Development metadata based reporting architecture for complex Basel II mandatory elements

·         Business Intelligence report development using Crystal report and Webi (Business Objects)

·         Custom application development for performance tuning

·         Major component delivered

o    Substitution report (Basel II mandatory elements)

o    Commercial dashboard. – Technical specification, data unload scripts, designing dashboard using Tableau tool

o    Basel II Reconciliation reports

o    Basel II data extracts

o    Performance tuning of MySQL, Oracle database

Environment: Oracle 10g, PL/SQL, Crystal report, Business Objects, Informatica.

UBS, Stamford, CT

Duration: Feb 2009 to Mar 2010

·         Requirement gathering

·         POC & Prototype for book hierarchy project

·         Data analysis for source’s – MOR, Indigo, and FX/MM. Identifying relationship with trading books to Functional hierarchy

·         Building logical model for Hierarchy (Functional, Legal & Geography) and trading books

·         Building mapping documents, technical specifications as per requirement in functional specification

·         Warehouse architecture development for Book Hierarchy project

·         Warehouse development using Informatica and PL/SQL ETL development

·         Trail balance & Balance sheet generation using PL/SQL and WEBI report for trading books

·         Performance tuning of warehouse and SQL’s

·         Lingua architecture implementation – Messaging queue

·         Building of universe for book hierarchy

·         Unix application development for executing the informatica workflow, to load the data in warehouse based on monthly, weekly & on demand load based on availability of sources

·         Major component delivered

o    Function Hierarchy

o    Legal Hierarchy

o    Geographic Hierarchy

o    Cost Centers

o    Trading books

o    Cost Centre to Function Hierarchy Relationships

o    Cost Centre to Legal Hierarchy Relationships

o    Book to Cost Centre Relationships

o    Book Feeds from OBS, Geronimo, Stealth and Jetpack

o    Graphical User Interface to view the Hierarchies and Books

o    Graphical User Interface to update the Book attributes: Status, Type and Trading Location

o    Publication of Hierarchies, Cost Centers and Books to the Integration Framework

Environment: Oracle 10g, PL/SQL, Informatica, Lingua, Unix shell scripting, Business Objects XI.

Compass Bank, Birmingham, AL

Duration: Aug 2008 to Feb 2009

·         Understanding the credit risk data mart logical and physical model.

·         Enhancement and development credit risk warehouse loading application using PL/SQL.

·         PL/SQL package development for automated Oracle table partition creation, based on the load activity in warehouse.

·         Warehouse load rest and restart development.

·         Warehouse enhancement for – E3 (Loan origination) – Logical model for dimensions and relationship with fact table.

·         Implementation of process flow and process documents.

·         Preparation of test cases and test module for monthly releases.

Environment: Oracle 10g, PL/SQL, Informatica, Lingua, Unix shell scripting, Business Objects XI.

HSBC Bank, Tampa, FL, Pune India.

Duration: Nov Feb 2005 to July 2007

                Role - warehouse architect, developer

·         Data warehouse development for Auto Loan warehouse.

·         Development and design of interim area (staging) for data warehouse - Auto ODS.

·         Development of shadow area for data warehouse.

·         Documentation related to - Technical specification, Test scripts.

·         Atomization of data loading scripts to staging area.

·         Data transformation from staging area to dimension tables and fact tables.

·         Data reconciliations.

·         Backup and purge process for staging area. 

·         Warehouse development for Basel.

·         Warehouse architecture development to maintain centralize repository for HSBC North America. – DB Metrics

o    Logical and physical model.

o    Utility to extract the required information from across – Oracle, DB2, DB2 UDB, Sybase, SQL Server, Teradata databases.

o    BU wise server, database cost calculations.

o    Automation of MIS Information.

·         Front-End Data

o    POC and Tool finalization for CDC.

o    Attunity CDC - Implementation of CDC (change data capture) tool.

o    Architecture flow for extracting the feeds from DB2& AS400 database, and plugging it into Risk MI (Risk calculation) and Basel process.

o    Generation of staging area.  (Approximate 650 tables)

o    ETL jobs design and implementation using Database PX.

o    Resource recruitment and on boarding.

o    Onsite coordinator.

o    Technical project planning & tracking.

Role – Oracle DB administrator

·         Oracle database administrator for Midwest region database.

·         Physical database creation. – Development, UAT & Production.

·         Release management.

·         Installation and preparation of Standby database.

·         Data refresh for standby/development database using Production dumps.

·         Time and cost saving initiatives for business critical queries executing on production database.

·         Unix bases application development for database audit.

·         Data migration from Oracle to DB2 (NLS character set)

Environment: Oracle 9i, 10g, DB2 UDB, Teradata, PL/SQL, DataStage PX, Control M, Autnity CDC, Unix shell scripting.

Kinetic Engineering Ltd, Pune India

Duration: Sept 1999 to Jan 2005

·         Techno functional consultant for implementation of manufacturing ERP solution modules – Inventory, PPC and Finance.

• Designed and developed new functionalities integrating with modules such as Inventory, Production Planning and vehicle warranty.
• Development of vehicle roll down system.
• Y2K Implementation.
• Complex business logic development in Pro*Cobol and Pro*C.

·         Development of Vendor material accounting system.

·         Development and Implementation of Industrial engineering module, to calculate employee’s efficiency and production cost.

·         Development and Implementation of EDI (Electronic Data Interchange) between Kinetic Engineering Ltd and its vendor.

·         Warehouse development for Vehicle warranty system.

·         Raw material scheduling system – maintenance of SOB (Share of business), explosion of Bill of Material, Costing and pricing module for vehicle.

·         Trail balance and balance sheet application using Pro*C.

·         Installation oracle server, up-grading, customizing database.

·         Database patches management.

·         Storage management.

·         Backup and recovery strategy.

·         Unix server administration – administrating of network services, configuration of network services, configuration of hardware, managing backup using TAR backup, terminal configuration, managing users, group and environment.

·         System admin activity using SCO-Unix admin.

 Environment: Oracle 7, 7.3 (WG), SCO-Unix, UnixWare, Developer 2000, Pro*C, Pro*Cobol. 

Educational Qualification

·         Bachelor of commerce, from Pune University - 1995

·         Master in computer management, from Pune University – 1999

Download Resume Format