SUMMARY

• 16 years of Experience in medical Insurance, Pharmaceutical, Manufacturing, Educational, data processing industries
• 7 years of total Data Warehousing experience in developing and managing full life cycle, multi - terabyte Data Warehouses, Data Marts, Operational Data Stores using Star Schema, Snowflake Schema and 3NF modeling concepts
• 8 years of experience in Studying, Documenting, Designing, Developing, Testing full life cycle (SDLC) Enterprise software applications like GL,AP,AR, Inventory, Payroll, Plant Management, Data Processing. Support and customization of ERP applications like AVALON Financials
• 4 years experience as Database Administrator, installing and tuning Oracle database and supporting development project in tuning/optimization aspects.
• Excellent knowledge about data modeling, architecture, ETL architecture and design, logical and physical data modeling, partitioning strategy, and information delivery layer design
• Designed and implemented Full life cycle data warehouse projects running into multi-terabytes in size
• Designed and implemented Full life cycle OLTP projects.
• Strong orientation towards quality, superior communication and interpersonal skills, excellent analytical capability, oral and written communication skills, ability to work in a team, lead and be led
• Good knowledge of meta-data pertaining to data definitions, lineage, rules, and taxonomy
• Ability to work with limited resources, capable of pursuing business objectives through formal and informal channels, can defend own position with support of data and reasoning, no hesitation of being a tryst to find better solutions

TECHNICAL SKILLS

System Development: Data Architecture, Data Modeling, ETL Architecture, ETL Design, and Application Design with full life cycle and using. Thorough understanding of SDLC.

ETL Tools: Informatica Power center Tools, Sagent Design Studio 4.5i,Sagent Automation, Sagent Reports and Analysis, Ab-Initio

Operating Systems: MS Windows, MS-DOS, Unix (Aix, Solaris, HP)

DBMS/RDBMS: Oracle 8/9i/10g/11g, SQL Server 2000, MS Access, FoxPro, Dbase, and Clipper.

Languages and Software: PL/SQL, Perl, Java

Reporting / BI Tools: Business Objects 5, Brio Hyperion Solution, SQR, Microsoft Analysis Services, Cognos ReportNet and PowerPlay, Oracle Report, and Oracle Forms 4.5 - 6i

Other Tools: Erwin Data modeler, Model mart, System Architect, Oracle Designer, Oracle Enterprise Manager, MS Visio, MS Project, MS PowerPoint, MS Word, MS Excel, SQL*Plus, andTOAD, Lombadi Teamworks

PROFESSIONAL EXPERIENCE

Confidential, Detroit MI

Sr Data Architect

Responsibilities:

• Accountable for the Trust Data Model for the data Analytics solution.
• Provide technical expertise to the Trust on Data architecture
• Provide Data control and metrics for the BI solution
• Define and maintain data dictionary and data control documents
• Data Governance guidelines on usage of the data warehouse and the BI vendors
• Provide Leadership with guidance on issues or risks related to the data and data architecture
• Develop and update the data governance policies and procedures needed to successfully implement the BI application
• Directs quality control and auditing to ensure accurate and appropriate use of data.
• Accountable for reviewing data quality and integration of all BI architecture components.
• Work with the business and writing technical specification for the BI vendor.
• Assist others in the accomplishment to work assignments through technical leadership

Confidential, Warren MI

Business Intelligence Architect

Responsibilities:

• Accountable for reviewing Logical Data Model and recommending best practices and communicating development managers towards Business intelligence projects of Global Product Development.
• Accountable for defining, common business entities, dimensions, Data Marts and data warehouse.
• Accountable for defining data model standards and model templates.
• Make technical decisions by applying fundamental engineering principles and specialized knowledge or skills to assigned tasks
• Accountable for reviewing data quality and integration of all BI architecture components.
• Assist others in the accomplishment to work assignments through technical leadership
• Define and manage data quality (data profiling) programs

Confidential, MI

Data Architect

Responsibilities:

• Analysis of the requirements provided by the clients
• Construct, refine and maintain information models, as needed, to meet business requirements
• Participate in key project design quality reviews as part of the methodology process to ensure application designs adhere to enterprise information architecture guidelines
• Data Modeling, dataflow diagram and Detail Design
• Coordinate new development activities and ensure they are consistent and well integrated with the established enterprise information architecture
• Defining Data persistence, Data security and levels of access
• Helping ETL development team with the clarity of data model and writing complex queries
• Participate in technical discussion, documenting alternate design option, pros & cons of each and select appropriate options
• Assist in post-implementation continuous-improvement efforts to enhance performance and provide increased functionality
• Preparation of Coding Standards and Conventions
• Provide technical expertise and counsel to management, other organizations, and special projects personnel
• Perform data analysis on production data issues.

Confidential, MI

Data Architect

Responsibilities:

• Gap analysis between the CPF and FACETS and PORTICO system.
• High Level Design for the data migration from CPF and FACETS systems to PORTICO System.
• Data Modeling . Defining Meta data structures.
• Helping development team with the clarity of data model and writing complex queries.
• Writing the Detail Design, Data mapping Document.
• Participate in technical discussion, documenting alternate design option, pros & cons of each and select appropriate options.
• Preparation of Coding Standards and Conventions.

Confidential, MI

Data Architect

Responsibilities:

• Participating in requirement analysis study.
• Creating logical data model using BCBSM DA standard.
• Designing the architecture to get the data from various sources.
• Designing the data stores and lookup tables for the web reporting.
• Creating Data loading templates for other developers to use the same standard.
• Participate in technical discussion, documenting alternate design option, pros & cons of each and select appropriate options.
• Preparation of Coding Standards and Conventions.
• Writing the Detail Design Document.
• Writing functions and preparing the data to be used in the Hyperion reporting.
• Presentations & User Training.
• Involve in Brio~Hyperion reporting Upgrade

Confidential, MI

Data Architect

Responsibilities:

• Creating data model using BCBSM DA standard.
• Designing the architecture to get the data from various sources.
• Lead team members in writing PL/SQL packages, stored procedure and functions for data Extraction, Transformation and loading.
• Involve in tuning the SQL query for quicker data retrieval from the database.

Confidential, Wilsonville, OR

Data warehouse Architect

Responsibilities:

• Participated in the requirement analysis study.
• Analyzing the possible solution, attending user meetings.
• Designing/Data Modeling of XML Stage, Relational Stage (ODS) and Star Schema.
• Design of Common LOAD process XML data to relational Staging design using advance PL/SQL, JAVA stored procedure.
• Design of Common LOAD process from relational Staging to Target(Star schema) using PL/SQL.
• Generated DDL to create the database objects and implemented the model in Stage, Star Schema using SQL Navigator.
• Developing ETL process using XDB, PL/SQL.
• Helping ETL development team with the clarity of data model and writing complex queries.
• Designed Audit reports using Crystal reports and PL/SQL.
• Design and modify the Universe Using Business Object 5.1.6.
• User Training.

Confidential, Sacramento, CA

Data warehouse Architect

Responsibilities:

• Participating in requirement analysis study.
• Analyzing the existing system, attending user meeting
• Preparing Requirement Analysis Document and Technical architecture document.
• Using Oracle Designer6i created Process Model, FHD, ERD and Server Model diagram.
• Designing/Data Modeling of Stage, ODS and Star Schema.
• Generated DDL to create the database objects and implemented the model in Stage, ODS and Star Schema using Oracle designer6i.
• Developing ETL plans by using Sagent design studio 4.5i.
• Creating Tasks in Sagent Automation.
• Sagent data flow services (DFS) setup and administration.
• Executed nightly backups and data load transfers.
• Testing data load for entire application.
• Migrated 400 million records from CHS legacy database to Oracle8i data warehouse
• Designed 12 reports using Sagent Analysis, Reports and Crystal reports.

Confidential, SFO CA

Lead Data warehouse Developer

Responsibilities:

• Analysis of the specifications provided by the clients
• Data Modeling (Dimensional)
• High Level Design
• Detail Design
• Preparation of Coding Standards and Conventions
• Writing the Detail Design Document
• Presentations & User Training

Confidential, Dayton OH

Sr. Application DBA

Responsibilities:

• Analysis of the specifications provided by the clients
• Design of the screens and Reports for the Natural Resource and Conveyance module using Developer2000.
• Performance tuning for many screens as well as packages.
• Written around 30 Stored Procedures, 5 Packages and Triggers using PL/SQL 8.
• Written PL/SQL programs for many batch update processes like interest calculation.

Confidential

System Manager

Responsibilities:

• Support user departments
• Initiate and manage new projects
• Initiate and manage customization of ERP modules.
• Manage developers and support personnel.
• Prepare status report and report to top management on IT application health.
• Support organization initiates with new project and software applications.
• Develop and manage Decision support systems and integrate data into it.
• Procurement Planning and IT equipment procurement
• Manage hardware vendors and third party support personnel.

Confidential

Manager, Systems

Responsibilities:

• Automation of the Study materials and Inventory Management.
• System study, documentations and feasibility study
• Coding and developing applications
• Testing and documentation of applications
• User training and support of applications