SUMMARY

• Result Driven Data Architect having experience in configuration, implementation and consulting in Industrial, Banking, Telecom and Business Intelligence domain.
• 14 years of experience on Data warehousing and Business Intelligence.
• Over 4 years of experience working as Data Modeler and Data Architect to provide teh Enterprise Data Warehouse solution using Agile Data Modeling.
• 16 years of experience working in Insurance, Banking, Retail, and Telecom domains.
• 14 years of experience expertise in DWH design, development and BI report generation & deployments.
• Extensive working experience in ETL tools Data Stage/AbInitio, Data Modeling tool Erwin, Report tools BO XI / Cognos and teh databases Oracle, Teradata, and DB2 as warehouse repository.
• Experienced on Agile methodology and proven in delivering successful sprints.
• Expertise in teh Financial Services Logical Data Model (FSLDM) of Teradata. Experienced in building data models starting from analysis of source requirement to designing teh Physical Data Models (PDM).
• 5+ year’s onsite experience in leading team and providing data modelling solutions to teh client.
• Strong experience in managing Business Intelligence (BI) & Data Warehousing (DW) projects, starting from Initiation, planning, Execution, Control & Completion, under fast - paced and time-sensitive environments.
• Strong technical expertise as data Architect to design conceptual, logical and physical data models.
• Strong expertise in Relational Data Modeling, Agile data Modeling and Dimensional Data modeling.
• Expertise in defining and delivering various SDLC processes, tools for large projects.
• Ability to Coach/Mentor teams in ETL, Data Modeling & Database designing and supporting areas and providing a quality solution wifin teh time frame.
• Personal Strengths - Enjoy working wif team, ability to quickly analyze and troubleshoot problems, able to learn new technologies quickly and design architectural solutions.

TECHNICAL SKILLS

ETL Tools: Data Stage 11.5, AbInito and Informatica

Data Modeling Tool: Erwin 9.5.x wif FSLDM (Teradata) and IBM IIW/IIA

OLAP Tools: BOE XI, BO 6.x, Cognos

Scheduling Tool: AutoSys, Control-M

Processes: Agile methodology (VersionOne)

DBMS: Netezza, DB2, Oracle 12c, Teradata, and Oracle Application Express

IDE: Toad, DB2Visualizer, Aginity and SQL Developer

O/S: UNIX (Shell script) and Windows

Ticket Tool: Remedy and Service Now

Scripting and Languages: PL/SQL, Basic Java and C++

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Environment: Erwin 9.x and Data Stage 11.5, Oracle and Control-M

Responsibilities:

• Responsible for teh integration, expansion and support of teh North American Automotive OLTP and data warehouse solutions.
• Responsible for interpreting, organizing, designing execution and coordinating technical assignments wifin teh Auto Finance division.
• As Data Analyst responsible to plan, coordinate and perform activities related to migration and integration of data from multiple internal and external 3rd party source systems including source to target mapping of each data element, maintaining metadata and data governance and data profiling.
• Responsible for developing and maintaining data quality, overseeing teh development of data components and overseeing performance testing and fine tuning of data components.
• Ensure consistency of teh Conceptual, Logical and Physical Data Models for all Data Warehouse applications. Wif teh expertise in Modeling tool Erwin.
• Possesses a broad understanding of multiple technologies, including DBMS (Oracle), ETL (DataStage) Reporting, OLAP and performance tuning.
• Maintain responsibility for global data definitions used in Data Warehouse.
• Participate in architectural decisions for data transitions from source to staging to ODS to EDW.
• Providing teh logical and physical design and conducting reviews wif client's solution and architecture team.
• Providing teh Data Model design validation walkthroughs to business user.
• Publish Data Model design and mapping documents to teh client after teh review and sign offs for teh build and test teams to start development testing phases.
• Providing walk through of teh physical model, High Level and detail mappings to development and testing teams.
• Process document of Agile Data Modeling and generate document of standardized naming convention in teh database design.
• Communicate regularly and TEMPeffectively wif team members and supervisor. Point out system or process problems when noticed and engage teh team in problem solving. Plan and participate in cross-training wif staff.
• Responsible to Coach/Mentor teams in ETL and Data Modeling design and supporting areas and providing a quality solution wifin teh time frame. Work wif on-shore and off-shore contractors. To work independently and to resolve complex system or data integration issues.
• Report project status to teh team and management. Willing to learn teh business and new technology.
• Participate in project meetings, as necessary, to understand application and integration requirements.
• Provide recommendations for process improvements.
• Fill in for other developers as requested and recognize accomplishments and contributions of team members. Provide high level of customer service. Responsible for assignment completion and follow through.
• Establish and maintain good working relationships wif internal and external customers.
• Ensure adherence to Customer standards, tools, policies and best practices.

Confidential, Ohio

Sr Data Analyst

Environment: Data Stage 8.5, Netezza and Control-M

Responsibilities:

• Responsible to relate teh business requirements to teh enterprise wide information architecture by developing high level and low level design documents for ETL applications.
• Work wif source system owners, SMEs and business analysts to resolve source data issues (data profiling) and refine transformation rules to develop source to target mappings.
• Identified and resolved performance issues in report generation from taking several minutes to few seconds.
• Responsible to relate teh business requirements to teh enterprise wide information architecture by designing Logical Data Model and Physical Data Models for Guide Wire and legacy 5.3 PMS Systems.
• Developed generic jobs using RCP property in Data Stage to extract data from different source systems like DB2, SQL Server and load teh data into Netezza.
• Developed complex sequencer jobs using generic job using allow multiple invocation property in Data Stage.
• Developed generic jobs to perform load balancing on various source system to target system.
• Consistently handling issues caused by challenging client situations TEMPeffectively, including finding teh right balance between resolving things self when possible and escalating only when necessary.
• Identify high cost production support items using scientific approach and provide solutions for support reduction.

Confidential

Data Modeler

Environment: Informatica, Tera data 13.x (FSLDM) and Erwin 9.5

Responsibilities:

• Teh primary responsibilities of this project are to provide teh normalized data model solution based on teh various project requirements.
• Responsible to relate teh business requirements to teh enterprise wide information architecture by designing Logical Data Model and Physical Data Models for UIS, Guide Wire and Quote Store source systems.
• Work wif source system owners, SMEs and business analysts to resolve source data issues (data profiling) and refine transformation rules to develop source to target mappings.
• Providing teh logical and physical design and conducting reviews wif client's solution and architecture team.
• Providing teh Data Model design validation walkthroughs to business user.
• Publish Data Model design and mapping documents to teh client after teh review and sign offs for teh build and test teams to start development testing phases.
• Providing walk through of teh physical model, High Level and detail mappings to development and testing teams.
• Process document of Agile Data Modeling and generate document of standardized naming convention of Table and field names.
• Weekly report of Project status to share wif teh weekly status meeting wif team and tan to client.
• Consistently handling issues caused by challenging client situations TEMPeffectively, including finding teh right balance between resolving things self when possible and escalating only when necessary.
• Consistently handling teh conflicting demands of both main project and a project for which me was providing support (both projects wifin teh DLG and RBS portfolio).

Confidential

Team Lead/Data Analyst

Environment: Data Stage, Oracle 10g, and Autosys

Responsibilities:

• Analysis and design of Data-warehousing models using agile methodology.
• Integration of high quality source data, development of data models, business intelligence delivery to users.
• Agile data warehousing for DM2 data model for Confidential reduce teh risks associated wif up-front analysis and provide more timely BI value by taking a highly iterative, incremental and collaborative approach to all aspects of DW design and development.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Regularly report to IT Manager(s) / project manager(s) on project(s) activities
• Successfully delivered all teh projects and gained teh client satisfaction & built-up assurance to teh client.
• Managed on-site/offshore model team to deliver teh project wifin teh given budget and in-time.

Confidential, Sunnyvale, CA

Team Lead/Data Architect

Environment: DataStage, Oracle 10g, and Unix

Responsibilities:

• Analysis and design of Data-warehousing models using agile methodology.
• Integration of high quality source data, development of data models, business intelligence delivery to users.
• Performing various reconciliations under Finance tower such as Shipment, Invoice (billing), Reserve and Deferred and non-Deferred Revenue data marts and communicating teh reconciliation results to NetApp Revenue Business team.
• Agile data warehousing methodology is applied to various data marts for NetApp reduce teh risks associated wif up-front analysis and provide more timely BI value by taking a highly iterative, incremental and collaborative approach to all aspects of DW design and development.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Regularly report to IT Manager(s) / project manager(s) on project(s) activities
• Successfully delivered all teh projects and gained teh client satisfaction & built-up assurance to teh client.
• Managed on-site/offshore model team to deliver teh project wifin teh given budget and in-time.

Confidential, Atlanta, GA

Application Developer

Environment: AbInitio, Oracle 10g, and Unix

Responsibilities:

• Analysis, design, development and implementation of Data-warehousing projects under DWH IT department.
• Integration of source data, development of data models, business intelligence delivery to users.
• Creating several graphs using various AbInitio components using Test Data Driven methodology.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Regularly report to IT Manager(s) / project manager(s) on project(s) activities
• Successfully delivered all teh projects and gained teh client satisfaction & built-up assurance to teh client.
• Managed on-site/offshore model team to deliver teh project wifin teh given budget and in-time.
• As a Lead responsible for design, development, testing and implementation and supported of customized TPR, ALLL,TM1,TPR-BU and GL Reconciliation, Credit Risk Data Provisioning (CRDP) solutions for new implementations and upgrades for Confidential .