SUMMARY

• Over 14 years of extensive experience as a Data Architect / Data Modeler for Analysis, Design, Development, Implementation, Administration and Maintenance of Online Transaction, Business Intelligence / Data Warehouse / Data Mart requirement across Banking, Financial Service, Supply Chain and Retail domain.
• Strong understanding of the concept and life cycle of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using data modeling tools ERwin, Oracle SQL Developer Data Modeler and Sybase PowerDesigner.
• Worked extensively on forward and reverse engineering of Data Models. Created DDL scripts for implementing Data Modeling changes. Created ERwin and Sybase PowerDesigner reports in HTML for Online reference, RTF format for End User Data Base Design Documentation. Created ERwin Volumetric Report for Capacity Planning. Depending upon the requirement, published Data model in model mart, created naming convention files, co - coordinated with DBAs to apply the data model changes.
• Worked in Production Support Project from both Onsite and Offshore.
• Worked extensively in Oracle PL/SQL coding, Informatica ETL coding and ETL Process Implementation.
• Expertise in SQL, PL/SQL, UNIX shell scripts, ETL Tool Informatica and ETL Process.
• Expertise in use of DM Tools ERWin, Oracle SQL Developer Data Modeler and Sybase PowerDesigner.
• Exposed to CMM and CMMI quality process and procedures.
• Experience of over 7 years in Banking and Financial Service, over 3 year in Air Transportation and 9 Months in Retail and Supply Chain Management domain.

TECHNICAL SKILLS

Application Servers: Microsoft Internet Information Server (IIS), Oracle Application Server

Databases: Oracle 8i/9i/10g/11g/12C, Microsoft SQL Server 2000 / 2008 R2, IBM DB2 UDB v 8.2 / v9.7 / DB2 BLU, PostgreSQL and Sybase.

Languages: PL/SQL, C, C++, Pascal, COBOL and Java.

Applications: Oracle Developer 2000 / 9i / 10g, Visual Basic 6.0, Visual C++ Version 6.0.

ETL Tool: Informatica 10.1.1 (PowerCenter), SSIS

Database Design Tool: Computer Associates ERwin, Oracle SQL Developer Data Modeler 3.1 and Sybase PowerDesigner 9.5.

Database Migration Tool: IBM Migration Tool Kit (MTK), Oracle Migration Work Bench.

Data Integration Tool: Oracle Golden Gate 10.4.

Software Tool Automation: Microsoft Office 2010 and Star Office.

Version Control Tools: IBM Rational Clear Case, Borland Star Team, SVN, Smart CVS.

OS: MS-DOS, SCO - UNIX, Redhat Linux, Windows, Sun Solaris 8.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Performed extensive Data Profiling on IMS data source.
• Created High Level Documents, SLA, Traceability matrix, Application interface design, ETL Mapping Document, reporting specification for the new source and legacy systems.
• Design of 3NF enterprise data model (EDW) to meet business demands and to meet enterprise needs and different source Data acquisition.
• Worked with DBA team to ensure implementation of the databases for the physical data models intended for data marts.
• Created required Primary Key and Indexes taking into consideration of DB2 Blu column based architecture.
• Propose Architectural design changes to improve data warehouse performance.
• Created High level and detail design documents for above data mart projects containing process flows, mapping document, initial and delta load strategies, Surrogate key generation, Type I and Type II-dimension loading, Balance and control, Exception processing, Process Dependencies and scheduling.
• Created Process Flow Diagram, Business Standards, ER diagram, Conceptual, Logical and Physical Data Model
• Design, implement, and manage operation of a Data Lake and related services
• Actively work with internal and external customers to analyze business data needs, gather and document business and data architecture requirements
• Develop, implement and maintain a metadata solution and associated processes
• Ensure highest levels of data accessibility, security, and quality in the environment
• Provide advanced technical, systems development and OA services to solve complex business needs including written detailed technical specifications for developers, use cases, and test plans
• Interact with management and Sr. management on special projects and Proof of Concept development

Skills Used: MS SQL Server 2005, Oracle 12c, Informatica 10.1.1, Erwin, DB2 mainframe, DB2 BLU, HP Quality Center 10.0/9.0,Azure,python,spark, Power BI, Tableau, CA Workload Automation ESP.

Confidential

Responsibilities:

• Created and Implemented the Integrated Regulatory Data Mart for Credit Risk Reporting Application.
• Provided high level Architectural Design for Data Governance to meet regulatory requirement in Financial Reporting.
• Created Structure Oriented Architecture (SOA) framework for data flow management.
• Created the mapping document, extracting and translation from JDE to Oracle for the engineering data.
• Implemented Multi Layer ETL Data Extracts, Data Load Logic, Mapping, Work Flows and Stored Procedure rule engine.

Skills Used: Oracle 11g/12c Database, Oracle SQL Developer, SQL, PL/SQL Release 12.1.0.2.0 , Pentaho, Oracle SQL Loader, Shell Script, Linux, Windows 10, Atlassian JIRA, GitHub, Serena PVCS, CA Workload Automation ESP and Autosys scheduler.

Confidential

Responsibilities:

• Designed and implemented a Data Transaction and Analytical Reporting design and process for highly complex banking application.
• Designing Conceptual, Logical and Physical Data Models using Erwin Tool for OLTP and Data Warehousing Systems.
• Represented Data Architecture team in Infrastructure, Technology and Services Management (ITSM) meetings.
• Strong understanding of the concept and life cycle of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
• Worked extensively in SQL, SQL Migration and SQL Tuning across Oracle, MS SQL Server Databases.
• Expertise in SQL, PL/SQL, ETL Tool Informatica and ETL Process.
• Expertise in UNIX shell script.
• Extensive experience in Database Design, Development of Business Application using Database Design Tool, Oracle SQL Tuning, Oracle PL/SQL, T-SQL in MS SQL Server Database and Sybase Database, Oracle Databases, Oracle Developer 2000, MS SQL Server Database and Sybase Database.
• Development and Coding of PL/SQL Programming and UNIX Shell Script.
• Possess technical expertise in Oracle Golden Gate and Informatica.
• Database Backups and Recovery.
• Database and SQL Tuning.
• Database refresh from Production to staging and Development databases.
• Managing Production, QA and Development Databases on support

Skills Used: Oracle 11g, 10g and 9i, SQL Server 2000/2008, IBM DB2 UDB v9.7, Sun Solaris 9/10, Redhat Linux 4/5/6, HP UNIX 11.31, Windows Server 2003 / 2007, Unix Shell Script, Erwin, TOAD, ITIL standards, Oracle Golden Gate 10.4, Informatica 9.5.1 (Power Center), SSIS, Autosys scheduler, Citrix, IBM Tivoli Storage Manager, TIBCO Frame Work, Star Team and Calibre RM.