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 MDM implementation 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

PROJECT DETAILS:

Confidential

Role: MDM Consultant

• Currently working with OCIO Solution Architect group. 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 with stakeholders/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 for data warehouse / data related solutions into Datawarehouse / MDM / ETL / feeds / Dashboards. Major part of this project are MDM implementations across multiple sources 9 datawarehouse, 6 databases . Main objective is to bring rigor and quality focus to MDM implementation 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 3rd normal forms and dimensional to integrate and implemented into applications and data warehousing 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 the data governance process as a member of the enterprise data council. Define data quality strategy and oversee implementation for key datasets. Define data security standards in collaboration with the Security Policy Architect. 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 Role: Sr. Data Warehouse Architect.
• 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 Role: Sr. Database Engineer/Architect
• Thomson Financial is the premier database related product based company in the Financial and mutual fund area.
• During this tenure, 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 Thomson heavily involves redesigning / restructuring / converting legacy database systems to Oracle RDBMS whenever new clients acquired/merge by Thomson Reuters.
• 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

Role: System Analyst

• Amgen is one among the world largest Biotech Companies. During this project, 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 Role: Module Leader
• Maxis is East Asia's largest Telecom Service provider. 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

Confidential

Role: Module Leader

• As a module leader, I was responsible for design, development and implementation of an ERP solutions and SAP order interface/integration with newly deployed ERP solutions.
• Software: Developer 2000, Designer/2000 Ver 1.3, Oracle Headstart 2.1, PL/SQL, SQL Plus, SQL Net 2.3

Confidential

Role: Analyst/Developer

• Design and developed an ERP solution based on the life cycle of cargo consignments/shipments.
• Software: Developer 2000, PL/SQL, SQL Plus, SQL Net 2.3 RDBMS: Oracle 6-7.3