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 using Unix Korn shell scripts / sed / nawk / awk. Extensive experience using Developer/Designer 9i, custom code in PL/SQL, SQL queries using Toad/PLSQL developer/SQL Plus. Providing database support to applications developed in JAVA/Javascripts/.NET. Maintaining and managing Oracle Application Server with Oracle 11g as the back end. 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, Process flow using BPMN. Design/Development of Oracle Data-Mart/ETL jobs with PL/SQL procedures and SQL/Shell scripts, Writing/executing test script and application testing using SQA suite/utPLSQL, Using BPMN/MS Visio to define and design new processes, Visual Studio/Team Foundation server/VSS for Change Management, experience working with very large databases. Designing and transforming legacy ETL to ELT using Informatica, SSIS/SSRS. Designed / Created dashboard using OBIEE 11g, Experience with Agile SDLC.
• Provide data architecture, business intelligence, and management consulting in support of various projects write and present training seminars to project managers and development staff to accelerate new technology integration. Examine current business functions and suggest strategies for technology development that streamline operations and automate data processes. Compose Proof of Concept presentations and suggest integration solutions.

SKILLS PROFILE:

Hardware: Sun-Fire series, Pentium PCs

Operating System: Windows 7, HP9000, SCO-UNIX, Sun Solaris

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

ETL Tools Informatica PowerCenter 8.6.1/8.1.1/7.1.2, SSIS/SSRS, OBIEE 11g.

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

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

PROJECT DETAILS:

Confidential

Role: Sr. Data Architect

• Managing design and Implementation of Agency Wide Data Governance Strategy, working as Prime Data Information Strategist with 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 / Dashboards/ Metadata Repository Management. Major part of this project are MDM implementations across multiple sources 9 datawarehouse, 6 databases . Main objective of the project is to bring rigor and quality focus to MDM implementation so that a quality architecture and infrastructure is delivered. The quality of the implementation is supported by understanding of the client's vision, goals, limitations, data sources, rollouts and timeline.
• Define enterprise Data Governance strategy and technology roadmap that aligns with corporate goals and CIO vision. Design logical and physical models, both traditional 3rd normal forms and dimensional, for business 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. Maintain vendor relationships.

Special Software: Toad, Infoshphere, Custom Inhouse ETL tool builds from Shell scripts/PLSQL.

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

Confidential

Role: Sr. Database Engineer/Architect

• During this tenure, Involved in transforming data requirements into enterprise data architectures and data warehouse architectures OLTP/OLAP 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, migration, transformation, 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