SUMMARY:

Over 18 years of Data Architect experience designing, development and implementing applications using Oracle and various other database technologies. Strong experience in performance tuning and optimize performance of SQL scripts, maintaining datawarehouses, Development/Setting up ETL batch jobs, custom code in PL/SQL, SQL queries using Toad/PLSQL developer/SQL Plus. Strong knowledge of Data Modeling (Conceptual, Logical and Physical Data Model), Use Case Modelling and/or designing Data Warehouse using Embarcadero/Erwin/Designer/Power Designer, Created Process flow using BPMN. Design/Development of Oracle Data - Mart/ETL jobs with PL/SQL procedures and SQL/Shell scripts, Visual Studio/Team Foundation server/VSS/SVN for Change Management, experience working with very large databases. Designing and transforming legacy ETL using Informatica, SSIS/SSRS, Datastage. Developed, build and manage MDMimplementation through IBM Infosphere Collaborative Edition (11.3).

SKILLS PROFILE:

Hardware: Sun-Fire series, Pentium PCs

Operating System: Windows 7/8, SCO-UNIX, Sun Solaris

Software/Tools: Developer Suite 11g, Oracle Discover, Oracle OWB, ODI, SQA Suite, Toad, Oracle Enterprise Manager, MS Office, MS Project, MS Team, Erwin, MS Visio, BPMN, Visual Studio 2010/Team Foundation server, SVN, JIRA, Bladelogic

Reporting /Dash Boarding Tools: OBIEE 11g, Cognos

ETL Tools: Informatica PowerCenter 8.6.1/8.1.1/7.1.2 , SSIS, Datastage

MDM Tools: IBM Infosphere 9.1/11.3 (Collaborative Edition)

Languages: PL/SQL, SQL*Plus, Pro*C, C

Databases: Oracle 8i-11g, Sybase, SQL server, DB2

PROFESSIONAL EXPERIENCE:

Confidential

MDM Consultant

Responsibilities:

• Designing and implementing complex solutions while steering the execution of Customer MDM initiatives. Experienced implementing MDM Solutions using IBM Infosphere Collaborative Edition (11.3) including Data Architect, Datastage, Metadata Asset Manager, Information Governance Catalog, Data Quality Console.
• Managing design and Implementation of Agency Wide Data Strategy with main focus on MDM, working as Prime Data Information Strategist withstakeholders/business decision makers and technology managers, Build relationships with business stakeholders and partner to understand information needs.
• Translate needs into strategy and high-level requirements fordatawarehouse / data related solutions into Datawarehouse / MDM / ETL / feeds / Dashboards. Major part of this project are MDMimplementations across multiple sources (9 datawarehouse, 6 databases).
• Main objective is to bring rigor and quality focus to MDMimplementation so that a quality architecture and quality infrastructure is delivered.
• The quality of the implementation is supported by understanding of the client’s vision, goals, limitations, data sources and timeline.
• Defining enterprise Data Governance strategy and technology roadmap that aligns with agency goals and CIO vision by using IBM Infosphere Collaborative Edition.
• Design conceptual, logical and physical models including traditional 3rdnormal forms and dimensional to integrate and implemented into applications anddatawarehousing solutions. Supervise physical model implementation across the enterprise as required by development teams and business stakeholders.
• Own the modeling process and associated modeling platform.
• Participate in thedatagovernance process as a member of the enterprisedatacouncil. Definedataquality strategy and oversee implementation for key datasets.
• Definedatasecurity standards in collaboration with the Security & PolicyArchitect.Evolve the metadata strategy and enhancements to the firm’s metadata platform.
• Research and oversee tool selection and integration.

Special Software: Toad, IBM Infoshphere 9.1/11.3, DataStage

RDBMS: Oracle 11g, SQL Server.

Confidential

Sr. Data Warehouse Architect

Responsibilities:

• Involved with design and development of algorithms for failed Banking institutions so data can be mined and future failures of institutions can be prevented.
• Extensive experience merging multiple databases, dimensional data modelling, designing ETL solutions for complex, multi-source data warehouses.
• Performs analyses and data modelling (Logical, Physical ERD), Process Flow, development and evaluation of data mining in a data warehouse environment, metadata and repository creation.
• Developed data mining and data analysis tools with custom codes in PL/SQL.
• Reviews data loaded into the data warehouse for accuracy, writes scripts for Load, Transform, Validation. Interacts with users/SME’s and responsible for preparation of scope, system requirements, analyses and design throughout the development, data Loading, QA, implementation.
• Supervised and work with 10-12 team members. Liaised to User/business managers for technology transfer, provide data architecture, business intelligence, and management consulting in support of various projects; managing ongoing strategy, obtaining requirements, and streamlining the enhancement/defect prioritization; Project planning, scopes & estimation,
• Deployment planning and coordination between User/Technology dept., team assignments;
• Recognized as primary leader to triage and resolve critical/daily issues; Oversaw personnel hours, budgets and development cycle for team members,
• Reported all results and status updates for risk assessment.

Hardware: Pentium PCs and Sun Solaris Unix Terminals. Operating System: Windows XP/7

Software: Various tools available for Query/Extraction.

Special Software: Toad, Oracle, various COTS products, SSIS, Cognos, Informatica, OBIEE 10g

RDBMS: Oracle 10g, SQL Server, DB2, Sybase, other proprietary databases.

Confidential

Sr. Database Engineer/Architect

Responsibilities:

• Involved in transforming data requirements into enterprise data architectures and data warehouse architectures by creating Logical Data model and then converting into physical model
• Also involved in the Design/Development of in-house developed ETL tool using Unix and SQL/PLSQL involving VPD and tablespace plugins which publish and used by application developed in Java, C++ and . Net framework.
• I also worked on Data Modelling including Logical Data Model using Designer 9i tools as ER-Diagrams, Functional Hierarchy Diagrams, Server Module Diagrams, I was responsible for Designing, Developing code, debugging in Oracle 11g using Toad and PL/SQL, my job also required Performance tuning or change legacy processes to use latest oracle function to enhance performance.
• Also managing Oracle Application Servers with Oracle Forms, Reports, Discoverer applications, I have to develop and setup Cron Job/ Unix shell scripts on Sun Solaris supporting JAVA/Javascripts and XML code over the web products, as our development teams spread over three continents I have to support Change Management including merge/labelling and promote changes we are using Visual Studio 2008/Team Foundation server/VSS for change management.
• Using Informatica to load data from various sources, extensively involved into Designing of legacy ELT migration to Informatica and used various transformation,
• My job at Confidential heavily involves redesigning / restructuring / converting legacy database systems to Oracle RDBMS whenever new clients acquired/merge by Confidential .

Hardware: Pentium PCs and Sun Solaris Unix Terminals.

Software: Designer/Developer 9i, Discoverer, PL/SQL, SQL*Plus

Special Software: Toad, OEM, Oracle Application Server, RDBMS: Oracle 11g

Confidential, California

System Analyst

Responsibilities:

• I was involved in the analysis, design, development, implementation and testing for the entire system.
• I was responsible for designing database including stored procedures, functions, packages, and database triggers using PL/SQL.
• I also developed forms and reports using Developer 6.0 (Forms 6.0 and Reports 3.0 and Webserver applications) in Oracle 8i

Hardware: Pentium PCs, Operating System: Windows NT/95

Software: Developer 6.0, PL/SQL, SQLPlus 8.0, SQL Net 2.3, Special Software: Designer 6.0, Toad 6.3

RDBMS: Oracle 8i/9i, SQL server 5.0

Confidential

Module Leader

Responsibilities:

• I was involved in the analysis, Data Modelling, development, implementation and testing for the entire system.
• I was responsible for designing and writing stored procedures, functions, packages, and database triggers using PL/SQL.
• I also developed forms and reports using Designer/Developer 2000 (Forms 4.5 and Reports 2.5) in Oracle 7.3.
• During this project, I was also responsible for conducting user training and demonstrations, requirement study and documentation, generation of the Data warehouse applications with the help of views on history data backup and monthly online data. My responsibility in Data warehousing module, which consist many different database/platform and history database, includes ETL jobs, SQL scripting for rollup, drilldown and cubes analysis.

Hardware: Digital Pentium PCs

Operating System: Windows NT/95, Software: Developer2000, PL/SQL, SQL*Plus, Discoverer

Special Software: Designer 2000 1.3, OEM, Toad 6.3, RDBMS: Oracle 7.3