PROFESSIONAL SUMMARY:

• I have 20+ years of experience in various stages of the IT software development life cycle, the last 10+ years as a Data Modeler / Data Architect / ETL Architect for a variety of large companies/ clients. I have deep technical experience in data warehousing, MDM, data management practices, database design techniques, implementation and migration practices, ETL processing and BI Technologies. I have a successful history as a Team leader, and I am sincere, well - organized, a quick learner, and a self-motivated team player that has experience in all phases of the Systems Development Life Cycle.
• Designing Data warehouse / Dimensional Model for large DB
• Designing OLTP systems for complex business requirements
• Data Integration solutions/ ETL Framework
• MDM, Data Management and Data Governance Practices.
• Agile Development Methodologies
• Reporting / BI Technologies
• Requirement gathering / Business Analysis
• Managing Development / Support Team including Offshore teams

TECHNICAL SKILLS:

Data Modeling Tools: ERWIN, ER Studio, Visual ParadigmDatabases: Oracle, SQL Server, DB2, Teradata

ETL Tool: Ab Initio, Informatica, Data Stage

BI/Reporting Tools: Business Objects, MicroStartegy, Tableau

Programming Skills: TOAD, PL/SQL, COBOL, C, Unix Scritping

Version Control: PVCS, Harvest, IBM Rational Clear Case

PROFESSIONAL EXPERIENCE:

Confidential

CGI, Director, Consulting ( Project Management / Architecture)

Responsibilities:

• Worked as Project Manager and Architect for multiple client/projects for Business Intelligence and Analytics Practice, leading team of data modelers, business analysts and development team. Interacting with client to get the business requirements and converting them into technical requirements. Handledall complex project planning from concept through completion including Resource planning, design, development, delivery and support.

Confidential, PA

Director, Project Co-coordinator and Architecture - Mortgage and Consumer Lending

Responsibilities:

• Worked as SME and solution Architect for Confidential to develop strategy and future state of multiple application systems. Worked with business stakeholders and created future roadmap applications like Mortgage and Consumer Lending to give best experience to customer . Documented the proposed future state and transition state of the application architecture. Also documented the redundant data flow or data elements in the future state.

Environment: Oracle, Unix, ERWIN.

Confidential, DC

Director, Architecture - Open Payment System

Responsibilities:

• Worked as Project Manager and solution Architect for CMS - Confidential and Medicaid Services - open payment system project initiative, it is OLTP and DW environment, to collect all the payments made by AM/GPO to physician and teaching hospitals under the law and publish the same to general public. Designed and implemented the OLTP for web based system for AM/GPO and dimensional model for end user management level reporting for business decisions. Data integration using ETL tool Informatica and reporting using Micro strategy.
• Improved the performance of the whole ETL / DB process and successfully brought down from 24 hours to less than 10 hours.
• Documented the future roadmap to handle the growing data within ETL and DB, also implemented data backup/archival process to keep only the required data online and enable users access the data quickly.
• Successfully designed, developed and implemented the business centric analytical reports from DW data, to enable business to take right steps to expand the visibility of the program. .

Environment: Oracle, Unix, ERWIN, Informatica, Micro strategy .

Confidential, CT/PA

Project Manager, Architect - Specialty Reporting Project

Responsibilities:

• Worked as Manager business intelligence/reporting architecture for enterprise level strategic Reporting initiative, designed and implemented the dimensional model for different reporting requirements. Team includes ETL and Tableau Reporting developers. Complexity is the source data coming from different legacy systems. Designed and developed the data integration scripts using Teradata from different sources. Implemented simplified solutions for process control dataset for monitor the processes. The design includes Metadata/ Data design and implementation.

Environment: Teradata, UNIX, Talend, Agile Methodology.

Confidential, GA

Sr Database Architect/ETL Architect

Responsibilities:

• Worked as database Architect and data modeler for Cable Lab for Cable Industry application project. Responsibility includes work with application architect, study application model (UML) and from tmforum architecture documents and create ERD (logical and physical) for each subject area. Also responsible for creating reporting view layer (star schema / Dimensional Model) and publish ERD and DDL for phase 2 physical designs. Worked with Core team to publish a set of best practices and implementation guidelines for BI teams.

Environment: Visual Paradigm, UML, Agile Methodology.

Confidential, NY

Database Architect/ETL Architect

Responsibilities:

• Worked as database Architect and data modeler for Jail management project for DOC, NY. Studied business requirement and created use cases and document the BPM, helped functional team to finalize requirement and then created ERD for client. Created logical and physical data model to support the application. Also created technical design/framework for ETL processes to move the data to new JMS application

Environment: E R Studio, Toad, UML, DB2, Windows, Unix, Data Stage, Agile Methodology.

Confidential, MA

Architect (Data Conversion )

Responsibilities:

• Worked as Architect for managing legacy data conversion team for Massachusetts Health Exchange initiative under Affordable care act (Obama Care). This is huge project using Agile methodology of development initiated by Mass health and University of Massachusetts Medical school to design and implement the modern system for all the residents of MA can access and shop and enroll for medical insurance program. Studied the legacy system/application data structure, designed and implemented new database and created the framework/ process to bring all the data from legacy to new database..

Environment: Windows, Unix, Oracle, ERWIN, Informatica, Visual Paradigm, Agile Methodology .

Confidential, PA

Sr. Architect (Data warehouse Design and ETL)

Responsibilities:

• Worked as Sr. Architect leading a team for database design and ETL for Confidential to convert legacy system which feeding to downstream application with claims, payments and other related data. Created the scalable data model to receive the date from upstream, store and reformat and send it to downstream applications using ETL. Also re-designed the online transactional claims and payment application.

Environment: Windows, Unix, Oracle, ERWIN, Data stage .

Confidential, PA

Project Manager and Sr. Architect (Datawarehouse Design and ETL)

Responsibilities:

• ING needed enterprise level reporting data warehouse across different insurance products such as Retail annuity or Life Insurance products or 401K managed plans. As Sr. Architect at Confidential ( wealth management / Retail Annuity Division) gathered the requirement from top management team, created the road map for the overall project and secured the funding for multi-year project. Architected enterprise level - dimensional model - sales reporting data warehouse. The project was developed and implemented using Agile method..
• Implemented ETL architecture/ETL process, team consisting of onsite and offshore consultants. Led BI development team to design and implement the front end reporting using Business Objects.
• For OLTP application system implemented the electronic delivery options for the customers to capture their p and use the ps to send out the statements and legal information electronically.

Environment: Windows, Unix, Oracle, Sybase, DB2, ERWIN, Informatica 8.x, Business Objects.