OBJECTIVE:

• To provide technical leadership on Database Architecture, Business Intelligence, Engineering and Operations to innovate, deliver and achieve company goals.

SUMMARY:

• Extensive experience as Manager/Architect/Team Lead/Data Modeler/Developer with extensive US experience in Data Warehousing (OLAP) and OLTP applications.
• Results - driven, team-oriented and proven ability to manage teams in cross-continental/multi-cultural environment and provide 24x7 operation support in fast-paced online industry.
• Extensive familiarity with the technological challenges, specialized tools and IT systems that are unique to OLTP and OLAP, SaaS, PaaS and Async Collaboration platforms.
• Strong abilities with Database Design, Administration, Deployment and Performance tuning in Clustered environments.
• Experience working with large volume data sets using 3rd party/open source/custom ETL tools.
• Designed/developed/implemented ETL using SQL/PL SQL, loader, shell scripts, perl, Shareplex replication, Golden Gate for data warehouse/data marts, integrating various sources - database, flat files, xml etc.
• Logical and physical designing of data warehousing applications using ERWin and other data modeling tools.
• Performance tuning of sql scripts, applications, partitioning, database reorganization.
• Created builds to install applications in production environments.
• Worked as owner of several data marts in production environments.
• Extensive experience working in Linux, Unix and Windows environment.

TECHNICAL SKILLS:

Hardware: DELL Servers, SUN E-3500/E-450 and E-250, SUN Ultra 10, SUN SPARC 10, HP-9000 K Series, Cisco UCS, Windows (32 Bit and 64 Bit)

Operating System: RHEL (ES/AS), CentOS, FreeBSD, Solaris, HP UX, Windows

Development: PL/SQL, XML, JAVA, PERL, JavaScript, UNIX shell script, PRO*C, C, Import/Export, PHP.

Tools: TOAD, Oracle SQL Developer, Oracle Forms/Reports, JDBC/ODBC, ANT, WebTrends web analytic tool, Discoverer, SQL*Loader, Visio

Version Control: Perforce, CVS, ClearCase, SVN, PVCS, Razor, Object Cycle Manager, MS Visual SourceSafe, Git

Databases: Oracle 7/8i/9i/10g/11g/12c, Oracle Exadata, Vertica 4.x to 7.x, Microsoft SQL Server 2008/2014, MySQL 5.x, PostgreSQL, TimesTen.

Data Modeling: Oracle Designer, ERWIN, Sybase PowerDesigner, Embarcadero Data Architect

ETL Tools: Data Stage, PDI Kettle, Informatica

Data Management: Oracle 9i/10G/11G, RAC, Oracle Advance Replication, Data Guard, RAMN, SharePlex, Oracle Streams, Golden Gate

Technologies/Methodologies: OLAP, OLTP, KETL, Autosys, Memcached, AWS Kinesis, Confidential Analysis, Kimball methodologies

WORK EXPERIENCE:

Confidential, Milpitas CA

Sr Data Architect Consultant

Responsibilities:

• Sr. Data Architect and contributing towards database architecture, design, development and technical guidance to TVS 2.0 project. Tasks include owning entire data platform layer, creating end-to-end database ETL architecture, data modeling, design documents which contains source to target mapping, data dictionaries
• ETL process details and ER diagrams. Job responsibilities include performance tuning of database and SQL queries to match sub-second SLA. Working with business team to translate business requirements into Business Intelligence solutions. Working as database lead to guide database and java team to make sure that they understand the requirements and hold them accountable to business requirements. Assisting quality assurance team with data quality and correctness issues. Working closely with project managers, DBAs, release planning and operations team. Technologies used: Oracle 11G on Exadata, Vertica 6.x/7.x, ErWin data modeler, PL/SQL, Linux, Shell script etc.

Confidential, Santa Clara CA

Managing Partner/Principal Data Architect

Responsibilities:

• Worked with customers to formulate scope and define objectives as per their business requirement in Data Warehouse and Business Intelligence domain. Defined project requirements by identifying key deliverables, project phases and acceptance criteria. Worked with Business Intelligence team to translate BI requirements into BI solutions. Worked with development team to make sure that the team has necessary resources to meet business requirement and hold the development team accountable to business requirements. Created architecture and design for the projects and created project documents like
• Software Architecture & Design Document. Helped customers/stakeholders prioritize deliverables as business needs evolve. Assisted QA team with data quality issues. Worked closely with project managers, build, release planning and operations team. Expert in performance tuning in Oracle and Vertica, fine tuning system workloads, review design and optimize application codes, build projections, determine statistical requirements and produce performance benchmarking results. As a Lead, responsibility included managing a team of analysts, developers, and testers and drive delivery of a module within the project (Delivery/Maintenence/Testing) Technologies used were Oracle 11G, Vertica 6.x/7.x, DataStage ETL tool, custom PL/SQL, ErWin, Embarcadero Data Architect, Python, Linux etc.

Confidential, San Francisco CA

Senior Data Architect

Responsibilities:

• Architected, designed and implemented ETL solution for Confidential Direct data warehouse project. Responsibility included creating data warehouse architecture, data modeling, schema design, guiding a team of six engineers and QA to execute the project, production installation etc. Managed production support and provided on DataStage to India team. Technologies used were Oracle 11G, custom PL/SQL, DataStage ETL tool, Linux etc.

Confidential, San Francisco CA

Senior Data Architect

Responsibilities:

• Reviewed the architecture and design of Cadreon’s ETL process to find Confidential in their system with their current requirements. Proposed new architectural and design changes and lead a team of four engineers to rewrite ETL process with new architectural and design changes. Technologies used were Vertica 5.x, MySQL, SQL Server, shell script, python, Linux, Windows Server etc.

Confidential, Palo Alto CA

BI Architect

Responsibilities:

• Involved in architecture and design for creating central scalable business analytics data warehouse. Currently, Confidential operates in over 50 countries and as such data from all units is being integrated into one centralized repository as a scalable central data warehouse for business intelligence purpose. Responsibility include fine tuning ETL workloads, review design and optimize application codes, performance tune Vertica and SQL queries, build projections, and help administration issues. As an architect, responsibility included mentoring junior members of the project team, analysts and testers. Technology used are Hadoop, Hive, Pig, Sqoop, Vertica 5.x, Teradata and MicroStrategy to process extremely large sets of data daily.

Confidential, San Jose CA

Engineering Manager

Responsibilities:

• Hands on Engineering Manager, also worked as technical lead, architecting and designing various projects. Responsibilities included working with product management team to define requirements, timeline and scope, worked closely with Architects, QA, business development team and other stake holders and interacting with customers on an as needed basis. Managed a team of 12 engineers, including offshore team members.
• Usage DB Reporting project: Architected and designed the project and managed onshore and offshore resources working on this project. Other tasks involve guiding and mentoring team members with technical and project issues, coordinating with operations, deployment and other groups. Usage DB is a collaboration project based on SaaS model and is highly scalable and highly available reporting project of WebEx11. Technologies used in this project are open-source software: Pentaho Data Integration Kettle, Big Data, Hadoop, Map-Reduce and Vertica 4.x.
• TEO Report Enhancement project: Redesign and re-architecture of slow running EC and SC reports of the WebEx core product, which is based on SaaS model. These reports used to execute from 3NF schema and so it used to time out. The new schema design has dimensional modeling and performance has vastly improved. Managed onshore and offshore resources working on this project. Other tasks involve coordinating with operations, deployment and page (front-end) groups. Technologies used in this project are Oracle 10g, sql/plsql, shell script, CA Erwin.
• Database Monthly Releases: Managed offshore team responsible for on-going monthly DB release cycle meant for bug fixes and enhancement of the WebEx core product. Other responsibilities include coordination with operations, deployment and page (front-end) groups. Technologies used in the project were MySQL, Oracle 10g, sql/plsql.

Confidential, Sunnyvale CA

Senior BI Architect

Responsibilities:

• Wrote PL/SQL database packages (procedures and functions) on Oracle 10G for Confidential ’s multi-tenant database project. The task also involved interacting with business stakeholders to convert business requirements into database solutions.

Confidential, San Francisco CA

Senior Data Architect

Responsibilities:

• Re-architected and redesigned ProfitMax NextGen project with emphasis on metadata design. This redesign significantly increased efficiency and helped cut down daily data processing time from 26 hours to four hours every day having original SLA of six hours. Guided and mentored team members with technical issue/project issue for trouble shooting and efficient design. Automated ETL process using Autosys. Automated build process and deployment of data warehouse code. Performed database, application and sql and database performance tuning and contributed to efficient design of the data warehouse application. Technologies used: Oracle 10g, PL/SQL for custom data warehouse code, shell script, sql*ldr, external table, perl, Clearcase, Autosys, Sybase Power Designer (data modeling tool) etc.

Confidential, Mountain View CA

Senior Data Warehouse Consultant

Responsibilities:

• Global Revenue Operations (GRO): Worked as lead for the dimensional module of the project and performed analysis, architecture, design, coding, implementation and support for the project. The source database was in MySql and the ETL technology used were shell script and pl/sql on Oracle 10g.
• Budget Tracker: Designed, developed and provided support for the Purchase Order module of the Budget Tracker project. The source data was in Oracle Financials(ERP) and the target system used pl/sql on Oracle 10g. Worked as Tech Lead for the project and was involved in analysis, architecture, design, coding and implementation of the project.
• Conformed Dimension project: Analyzed, designed, implemented and supported and worked as lead in Confidential ’s Conformed Dimension project and published various dimensions to the Conformed Dimension repository.
• Flex Reporting System: Designed and developed Flex Payment system for Confidential ’s customer payment system. The source data consisted of text files and the target system consisted of pl/sql on Oracle 10g. Worked as Tech Lead for the project and was involved in analysis, architecture, design, and coding of the project.
• System Credits: Modified existing code to load additional service ids to the database. The service ids provided in flat files were loaded into Oracle 10g database using pl/sql. This application was part of SOX compliant database.
• Revenue Data Mart: Provided support/enhancement to the Finance Data Warehouse Revenue reporting data mart as well as month-close process on monthly basis. This application was part of SOX compliant database.

Confidential, Sunnyvale CA

Senior Software Consultant

Responsibilities:

• Involved in the design of Marketing data warehouse data-mart and also wrote code for the ETL process using PL/SQL on Oracle 10g.
• Provided production support to CMDM, NETOPT and Key Metrics Systems on a daily basis. Played the lead role in ET5 to ET4 migration for CMDM Data Mart. Technologies used: Oracle 10g, Ascential Data Stage, PL/SQL, SQL.
• Involved in the migration of aggregate and detailed data from CMDM, NETOPT and Key Metrics into Marketing Data Mart.
• Purple P&L Migration: Migrated the Data warehouse ETL code for Purple P&L Reporting system. The PPL system has two processes running from the same data source and producing two similar reports but with different level of details. Before the migration the result from two processes did not matched. Made changes to the code to match the data and performed data validation on the results.
• SOO ETL process: This task was designed to provide ETL data from one data source to another for the SOO reporting system. Wrote PL/SQL code to perform ETL operation for the above task. Created Free-form SQL report using MicroStrategy Business Intelligence reporting tool.
• Performed database tuning to optimize ETL processes and SQL tuning to optimize the extremely slow running reports on MicroStrategy Business Intelligence reporting tool.

Confidential, Redwood City CA

Sr. Database Engineer

Responsibilities:

• Data Warehouse Reporting Project: Was instrumental in the analysis, design, development, implementation and maintenance of the project using Oracle 8i on UNIX. Used PL/SQL for writing stored procedures to extract data from various data sources - Oracle, MySQL, SQL Server, PostgreSQL, WebTrends log files to transform and load data into data warehouse tables. Led the schema design effort using ERWin and led several tuning efforts using Statspack, SQL tuning, and the wait events interface that resulted in significant improvements in response times for both application and data migration modules.
• Report Manager System: Design develop and maintain Report Manager using Oracle Portal 3.0 and Brio 7.0
• Worked as build master for Data Warehouse releases. Created application startup and installation scripts using Perl. Worked as development DBA for the Data Warehouse project.
• Created graphical user interface for the Data Warehouse project using Oracle Forms 6i.

Confidential, San Jose CA

Senior Software Engineer

Responsibilities:

• Designed, developed, implemented and maintained graphical user interface for the project - RoamFree Gateway 100 (RFG100) using Developer 2000 Forms 6i and Reports 6i on UNIX environment.
• Designed, developed, implemented and maintained graphical user interface for the project - RoamFree Gateway 200 (RFG200) using Developer 2000 Forms 6i and Reports 6i on UNIX environment.
• Designed, developed, implemented and maintained graphical user interface for the project - Secure Authentication Center (SAC) using Developer 2000 Forms 6i and Reports 6i on UNIX environment.
• Design and develop prototype for a three-tier client/server application using applets, Java RMI, Socket and JDBC.