Candidates About

§  15+ Plus years of IT experience in the field of  Oracle Database Development, ETL Development, Data Modeling and Project Management using Oracle SQL, PL/SQL, Unix Shell script, DatStage, Autosys,  Informatica, J2EE/Java/Servlet/Javascript/HTML etc,

§  Extensive knowledge in using VARRAY, Ref-cursors, collections and nested tables for processing of data.

• Extensive knowledge in Data Analysis, Application Design,  Interface Design, Data Modeling, SQL Performance Tuning, Ad-hoc and BI Reporting.

§  Solid understanding of SDLC, dimensional modeling and data mart development. 

• Extensive working knowledge in Informatica 9.6/Data Stage 8.1/9.1.  Worked across multiple databases to pull the data into target database.

§  Expertise in performing Data Migration/Data Integration from various legacy systems to target database.

§  Autosys/JIL  Implementation and Scheduling the Data Stage Jobs.

§  UNIX and Shell scripting.

• Production Support L1/L2.
• Outstanding Technical analysis, architecture, design and implementation.

§  Liaison with business, Negotiated project specifics, and deadlines, oversaw development and testing of software for existing and emerging products/technologies.  Gathered and analyzed business requirements, created Functional and Technical Specification Document.

§  Provide leadership. Project Tracking, Working with various functional groups/cross functional teams to develop, document and communicate business model, requirements. Work with business process owners, stakeholders, cross functional team to understand the requirements, manage and execute implementations of business process and IT solution.

Database Analyst, CA, WELLSFARGO BANK                                                     Oct 2013 - Present

Employee: WELLSFARGO, Insight Global, Teamsoft  CA, USA.

§  Scrum Lead: Created several ad-hoc reports using SQL and PL/SQL to support business users and stakeholders.

§  Developed complex PL/SQL Procedure, Packages, Functions, Triggers, View and Materialized Views.

§  Wrote many complex/advanced SQL queries and did SQL tuning.

• Created and Implemented Batch scripts using NDM, Perl, UNIX and Oracle PL/SQL.
• Created mapping using Informatica 9.6.
• Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr, and IIF functions in Expression Transformation
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache and Persistent Cache

§  Expertise in performing Data Migration/Data Integration from various legacy systems to target database.

• Exporting and importing the Datastage jobs from development environment to the testing environment and also to production environment.
• Create and maintain DataStage ETL jobs to extract data and load into Oracle tables for the outbound interfaces.
• Created JIL. Maintained and implemented Autosys jobs

§  Implemented Anthill Pro to Automate Build and Release Process.

§  Maintained Source in SVN resolved source code conflicts.

§  Created PRDB ( problem and Resolution document ).

• Investigated and identified requirement using ALM, Data flow, use cases, interviewing and determining the current and future state of the application functionality. Communicated to stakeholders to define the system requirement. 
• Interacted with cross functional team to facilitate the gathering of business requirement. Gathered the business requirement and helped defined scope of the project.

§  Created Application Architecture and Technical specification Document.  Conducted design review meeting.

§  Worked with SOR data owners along with support team members and stewards to remediate data issues in a complex multi-systems environment.

NGS Program Manager ( Reporting and Analytics ), NetApp,                                         Feb 2011 – July 2013

Employer: NetApp, Trianz

§  Track Lead. Managed and track deliverables, Project schedules and milestones, act in the role of in-house consultants and manage all processes and systems relevant to the successful completion of internal services/support goals including: review of users technical and logistical requirements, identifying tasks, assigning and coordinating resources and creating/tracking project schedules

§  Performed requirements gathering and analysis of both the “as-is” and “to-be” data processing. Collaborated with SMEs and senior I.T. executives to define the   vision, create high level and detailed BRDs, User Stories and SLAs as well as negotiated service delivery commitments, etc. 

• Analyzed large data sets and build reports in Excel (pivot tables, Vlookups, Index/Match, etc.)

§  UNIX & PL/SQL programming, SQL Performance Tuning and ETL Scripting.

§  Extensive experience in Database query tuning, Performance tuning (Explain Plan and TKPROF utility) of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.

• Involved in the Data Modeling, design, development and implementation of the Enterprise Data Warehousing (EDW) process and Data Mart.

Subject Matter Expert, Sun Microsystems/Oracle – Santa Clara, CA                             Nov 1997 – Feb 2011

Employer:  Sun Microsystems, CSC, Formula Systems

§  Root cause analysis and resolve production problems and data issues.

§  Investigate and provide recommendations to enhance the existing product and functional offerings.

§  Implemented complex views, procedures, functions, packages and triggers in PL/SQL

§  Physical and Logical Design and Architecture of Database, Data Mart and Data Warehouse.

§  Data Modeling and ER Diagrams .

§  Integration, Acceptance Testing and Product Release Management and deployment

§  Created Data load interface using C and C++.

Bachelor's Degree in Mechanical - University of Madras (India)

·         PMI Certified Project Management Professional (PMP),

·         Microsoft Certified Project Manager (MCTS).

·         Year End – Team Excellence Award ( 2015 )

·         Sun Academy award (2004)

Programming Languages:  Oracle PL/SQL 11G, UNIX Shell Script, DataStage 9.1,  Autosys, SHELL Script, Perl, isql,  Java, Servlet, C, C++,  XML, XSLT, JavaScript,  HTML,  CGI .

Software/Tools/Applications: DataStage 9.1, ERWIN, Make, Ant, CVS, tkcvs, Clearcase,  SVN, Enact,  MS Project,  Informatica PowerCenter 7.1, Information Highway ( asynchronous messaging ), bcp, SQR, ABAP, COBOL.

RDBMS: Oracle 7x/8x/9x/10g/11g ,  SQL*Plus 9.2.0.5, PL/SQL 9.2.0.5, Oracle Import/Export Utility, Sybase 12.5,  isql, bcp, SQR

ERP:  ERP/Oracle 11i,  SAP/GTS

Operating Environments: UNIX (Solaris, SunOS, HP-UX, Linux), Windows NT/XP/2000/9