Manager Resume Building 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

Geeta Nagarajan

Cell phone: +1 630-670-9876

geeta@gmail.com

Summary

·         Delivered mission-critical results in information management and functioned as data modeler and data architect

·         I have hands on and leadership experience working on the Oracle RDBMS and Unix/Linux Platform for warehouse and transactional systems on

o   Data analysis

o   Conceptual, Logical and Physical DB Design for OLTP, ETL and MDM

·         I have experience in working with executive and technical stakeholders over the years in delivering enterprise data and solution architecture with a team of experienced solution professionals

·         I have demonstrated competencies in guiding the conceptualization of solutions and leading multiple IT projects and ensuring quality deliverables on schedule and budget.

·         I am well organized with a track record that demonstrates self-motivation, creativity and initiative to achieve both corporate and personal goals.

·         I have broad competence in strategic management of technical matters with the distinction of launching and driving new delivery initiatives and achieving organizational objectives in time.

·         I have in-depth understanding of the various facets of the software services framework including the on-site/ offsite/ offshore delivery models.

·         I am Adept in analyzing information system needs, evaluating end-user requirements and troubleshooting problems in the process along with strong analytical and communication skills.

·         I am a US CITIZEN and have OCI that allows me to work in US and India and travel for business in many more.

Industry exposure

●      Financial industry

○    Investment banking

○    Credit Card account management

○    Retail banking customer master data

○    Understanding of the Mortgage industry (focus on pre-payment )

●      Retail

○    Online content management systems

○    Online systems customer Master Data

○    Enterprise Task Management for retail vendor

○    POS data warehouse – ETL and DW design

●      E-commerce

●      Classified advertisement syndication and management

●      Airline revenue management

●      Supply chain

○    supply chain exception management

○    vendor managed inventory management

○    Warehouse Management System – Exception routing

●      Education

○    Course enrollment

○    student management

 Technical Expertise

Data Modeling

          Powerdesigner, ER Win, MySQL Workbench Embarcadero ER/Studio, Visio

Database Systems

Oracle (5.3.2 to 11g), MySQL, DB2, SQL Server, Sybase,

Database Development

PLSQL Developer, Toad, SQL Navigator, DBArtisan

ETL Tools

IBM Datastage, Pentaho Data Integration (Open Source)

Operating systems

         Solaris, AIX, HP/UX, Linux, Dynix/PTX, Windows (XP/2000/NT/WFW/3.1),

Hardware

        Intel (x86), Sun, HP 9000, IBM RS 6000, Dec Alpha

Languages exposed

Informix 4GL, PL/SQL, Java, HTML, XML, VBscript, Perl, Unix Shells (ksh, bash, csh), JavaScript, TSQL, DTS, C/C++, SQL, Visual Basic, ASP, JavaScript,

Software Engineering

Rational Clear case, Clear quest, Requisite Pro, CVS, Subversion

Microsoft Project, Microsoft office, Presentation Tools (PowerPoint)

Training

●      2012 Accenture Advanced Architect Training School, St Charles, IL

●      2011 Accenture Delivery Manager Training, St Charles, IL

●      2009 MySQL Boot Camp, Dallas, TX

●      2002 PMP Boot Camp for Manager Mumbai India.

●      2001 Portal based application development with BroadVision

Education

INDIAN INSTUTUE OF SCIENCE, Bangalore, India 1988-1992 
Master of engineering (focus on Electrical Communication Engineering)

University of Delhi. New Delhi, India 1985-1988 
Bachelor of science (Physics)

 

Professional Experience

01/2011 - Present: Accenture - Manager (Consultant: AS&T)

Client: Wal-Mart Corporation

At Wal-Mart Corporation, I was responsible for managing the database design, data flow and QA data management

Role: Manager

Responsibilities:

• Support the enterprise data model for the task management application
• Create 3NF data models
• Extend existing data models with 3NF principles
• Analyze data requirements for data modeling and flow
• Lead the software development team for store component of the task management system
• Analyze and design the application database
• Provide solution roadmap for data flow from Home office to Store
• Be the SME for all deliverables related to database architecture and design

Project Management Tool

Microsoft Project

Technology Used:  

Erwin, Perl, Informix, 4GL, DB2 (SQL, SQL-PL, Perl, DB WorkBench), AIX, Linux

09/2009 - 01/2011 Purisma (A D&B Company), Chicago, IL

Client: A Bank Holding Company – Customer and Investment Banking

The bank holding company with many banks wanted to build a Master Data Management (MDM) hub for managing their customer and account base across their holdings. The project involved integrating and enriching customer data using Purisma Data Hub product and Dun and Bradstreet data.

Role: Principal Consultant

Responsibilities Included:

• Lead the data integration task across 5 banks
• Design and develop a data integration tool for data transportation from all sources to the project servers and D&B servers
• Implement the data integration tool
• Developed a configurable data validation tool based on database tables and SQL roles
• Performed GAP analysis that identified enhancements and extensions to be built to the MDM tool.
• Defined Capacity and Data retention metrics
• Define data security measures
• Data Management concepts built in this project was included in the product road map for future releases.
• Since the solution was database independent, it enabled future users of the product to use original data sources, reducing the lead time for data integration.

Project Management Tool

      Microsoft Project, Visio

Technology Used:  

Power Designer (Sybase), Oracle 10g (PLSQL, SQL, Perl), Linux, ERWin, SQL Navigator, Datastage, Pentaho, DB2 (SQL, SQL-PL, Perl, DB WorkBench), AIX

6/2006 - 09/2009 Sears Holdings. Hoffman Estates IL

●      Managed Multiple Projects and worked on data modeling and other database architecture tasks for projects including

○    Product MDM

○    Data Integration

○    Product Content Management

○    Warehouse ETL

●      Contributed as a database architect by developing Conceptual, Logical and Physical database design for online applications

○    SHC Universal Profile - including a Customer Data Integration for Online Customer Base

○    SHC Centralized Order Management System - Integrated Order management system for All SHC Assets - Sears.com KMart.com etc.)

○    Integrated Content Management system db

Project Management Tool

      Microsoft Project, Visio

Technology Used:  

Power Designer (Sybase), ERWin, Oracle 10g (PLSQL, SQL, Perl), Linux, SQL Navigator, Datastage, Pentaho, DB2 (SQL, SQL-PL, Perl, DB WorkBench), AIX

6/2006 - 06/2007 Data Architect (Paid Search and Data Warehouse)

DoubleClick Inc. Chicago IL

○    Project Manager – ETL / Data Warehousing (ETL: DB2 MySQL to Oracle 10g)

○    Managed the Selection of strategy, and provided the necessary leadership for Agile database design

○    Developed the first data warehouse model for the paid search division of DoubleClick Inc. (Performics).

○    Lead, Managed and drove the implementation of a data transformation and loading process for loading web logs into the data warehouse OLTP (UDB)

○    Designed, developed and implemented data components for data products

○    Developed a process to accelerate data summarization from OLTP tables to reporting environment 

Technology Used:  

    ERWin, ERStudio, DB2 (SQL, SQL-PL, Perl, DB WorkBench), Oracle 10g (PLSQL, SQL, Perl), Linux, Solaris

3/2006 06/2006 Technical Consultant (Physical Operations Management)

BP, Warrenville, IL.

●      Project Lead (Data Analysis )

○    Lead a group of three analysts for the coverage and capacity analysis process for estimating physical operations data in DB2.

○    Designed and built an Oracle (PL/SQL) processes for extracting and transforming data.

○    Analyzed the current physical operations system including SAP and Operations Management systems and Middleware Integration systems

○    Conducted workshops to elicit system details and presented ETL and E-LT models for consolidating the databases

○    Developed DTS packages for loading data into a SQL Server 2000 and Oracle

Technology Used:  

    ERWin, DB2, Oracle 9i, SQL Server 2000, DTS, VB Script, Stored Procedures,

10/2005 03/2006 Database Architect/Team Lead

JP Morgan Chase, Chicago, IL.

●      Designed and developed migration subsystem using Oracle 10g (SQL/PLSQL) for the integration of Banc One Corporation and JPMorgan Chase corporations IB Assets to their new CRM platform

●      Developed data model for the ETL System and a mart for process reporting

●      Developed data flows to marshal data from several data sources

●      Developed packages and a script library to facilitate synchronized execution of data loads

●      Designed developed and implemented a reporting system for the migration process

    Technology Used:  

ERWin, Oracle 10g, UNIX (Solaris) shell scripting, PLSQL, SQL Server, Perl, SQL Server, DTS, ER Win,

01/2005 10/2005- Industry Solutions Architect/Project Lead

Acxiom Corporation, Chicago, IL

●      Manage a project for Grid base data load for IRI (Designed data models for OLTP data load and management system as a database architect for this solution)

●      Architected, designed and developed process Flows and data flows

●      Developed a system to manage Mart Build and Report build requests for a CPG data warehouse (Oracle 9i/Oracle 10g, Shell Script, PL SQL)

●      Developed C programs to manage IBM Big Endean data.

●      Developed DTS Scripts to control and manage data loads along with dependency checks

●      Developed stored procedures to manage data transformation

Technology Used: 

ERWin, Oracle 9i, Oracle 10g, DB2, Perl, Shell Scripting, SQL Server, Red Hat Linux, Grid Computing, Data Stage, C, and MS Project

09/2004 01/2005- Database Architect

Information Resources, Chicago, IL

●      Designed a dimensional model for Pepsi and 7/11 sales data

●      Designed a data mart for sales and promotion analysis

●      Designed and developed database components for

●      Loading and scrubbing dimension and fact data

●      Staging the scrubbed data into the star schema

●      Lead a team of database engineers for the implementation

Technology Used: 

           ERWin, MS SQL Server, Analysis Services, ER Win, Visual Basic

09/2003 09/2004- Senior Database Engineer

Classified Ventures, Chicago, IL

●      Created the data model and database architecture for CARS.com FSBO NG (ER Win Oracle 8i, Oracle 9i. PLSQL)

●      Developed FSBO NG data feed  - Perl, Shell, Java (JDBC), Oracle 9i

●      Developed a feed architecture to delivery data to MSN auto Oracle 9i, PLSQL, Java, Korn Shell, and XML.

●      Designed and developed a feed architecture for delivery of cars data to OEMs (Toyota, Lexus, Acura and GM) Oracle 8i, PLSQL, DBMS Jobs, Shell Script

●      Lead a team of 5-7 engineers (database) in building a scalable database architecture

Technology Used: 

ERWin, Oracle 8i, 9i, Perl, XML, JAVA, MS SQL Server, Analysis Services, ER Win, VB

08/1997 09/2003- Senior Architect

Nexgenix Inc., Irvine, CA; Atlanta, GA; Mumbai, India

●      Designed and developed several Oracle based system for various clients

●      Architected an Oracle/VB/VMI system for Warner Brothers for Wal-Mart inventory

●      Provide a mechanism to load the Warehouse status to Teradata

●      Built solution and database architecture for a SCEM product using SQL Server and .NET platforms

●      Worked as architect in several web and client server applications based on Microsoft (SQLServer/IIS/VB) platforms and hybrid (Oracle/Visual Studio or Oracle/.NET)

●      Delivered Framework and Application based web applications as an architect

●      Worked as technical lead coordinating full lifecycle and post production lifecycle of web applications

Technology Used: 

ERStudio, ERWin, VISIO, Oracle (6, 7,8i, 9i), MS SQL Server, Informix, Teradata, Sybase, ER Win, Visual Basic, Java, C, C++, Perl, XML, XSD

12/1994 08/1997 System Analyst/Engineer

Century Computer Software, New York, NY

• designed a C/C++ library that provided database independent access to data (Supported Database: Oracle/Informix/Sybase)
• Designed and developed Oracle base Microsoft office driven distribution mechanism for investment banking
• developed an algorithm to manage inventory in a Multi Warehouse system for Kroger and United Warehouse using C on AIX

Technology Used: 

Oracle (6, 7,8i, 9i), MS SQL Server, Informix, Sybase, ER Win, Visual Basic, Java, C, C++, Perl, XML, XSD

05/1992 12/1994 System Analyst/Engineer

Tata Consultancy Services, New Delhi, India

• Systems Engineering Division Develop Linux code (C/C++)
• National Stock Exchange of India Order Management system (MFC/EICON)
• Subscription Management System (Oracle Pro*C, Forms, Reports)

Technology Used: 

Oracle (6, 7,8i, 9i), MS SQL Server, Informix, Sybase, ER Win, Visual Basic, Java, C, C++, Perl, XML, XSD

Download Resume Format