SUMMARY

• Over 12 years of experience in analysis, design, development, testing and implementation of application software as Database Engineer/ Database Analyst
• Deep understanding of the process that generates the data and influence design considerations for optimum data generation
• Owning the Validation of data from source systems to the data warehouse
• Monitor and validate data ensuring high - quality information is collected and accurately stored
• Consult with HRBPs and COEs to understand challenges and analytics needs in their organizations
• Develop and present data and insightful analytics using Tableau to COEs and HRBPs
• Help to improve data management methods and systems. Proactively suggest opportunities to avoid problems and anticipate future data needs.
• Use data-driven insights to understand and improve complex internal people processes like interviews, hiring, manager effectiveness, compensation, employee retention, employee engagement, diversity and inclusion
• Experience and knowledge of Workday and HRMS processes (Talent Hiring, Performance and Compensation tool, Manage Self Service, Talent Management tool, Resume Uploads, Onboarding, Benefits, Payroll)
• Experience in using Python for Data Analysis (Extracting, Modifying and saving data using Python)
• Advanced skills with Microsoft Excel and Analytical SQLs manipulating very large datasets
• High level understanding in at least one scripting language such as Ruby, Shell, Python.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Experience in developing a Conceptual model using Erwin based on requirements analysis
• StrongData Modelingexperience usingER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using ERWIN
• Expertise in Client-Server application development using advanced concepts of Oracle12c/11g/10g/9i/8i, PL/SQL, Oracle Forms, PLSQL Cartridge
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO), Query Optimizer, Execution PlansandIndexes, Explain PlanandHINTS
• Experience and knowledge in Data Encryption, Data Security and SQL Injection
• Good knowledge Telecom, Manufacturing, Investment Banking and Financial services industry
• Expertise inSQL and PL/SQL programmingand strong Knowledge onoracle architecture and database design.
• Expertise in using tools such asTOAD, SQL developer, PL/SQL developer, SQL loader
• Extensive experience in Performance tuning, SQL Tuning and Instance Tuning using AWD, ADDM, Queest Spotlight
• Data Analysis, Design, Development, Implementation and Testing of Data Warehousing usingData Extraction, Data Transformation and Data Loading (ETL)
• Knowledge with Slowly Changing Dimensions Type1, Type2 and Type3.
• Ability to programUNIX shell scriptsin applications that schedule, validate flat file data, execute SQL, archive files or FTP files.
• Solid foundation on Statistics/ETL/Programming

TECHNICAL SKILLS

Scripting/ Data Analytics: Python 3, Anaconda 3

Reporting and Visualization Tools: Tableau, Power BI, Oracle Reports

Oracle Tools: Reports 2.5/6i/9i, Developer 2000/6i/9i/10g

IDE: TOAD, PL/SQL Developer, Eclipse

Database: Oracle 11g/10g/9i/8i

Database Tools: PL/SQL Developer, SQL Developer, Forms10g/9i/6i, TOADOracle Enterprise Manager, SQL Navigator, Erwin Data Modeler

Languages: C, C++, JAVA, SQL, PL/SQL, UNIX Shell Scripting, HTML

Version Control: Tortoise SVN, StarTeam, ClearCase

Operating Systems: UNIX, Windows NT/2000/2003/XP/7

Defect Tracking: Rational Clear Quest, JIRA, GitHub, HPQC

PROFESSIONAL EXPERIENCE

People Data Analyst/DB Engineer

Confidential, San Jose

Responsibilities:

• Develop standardized metrics, dashboards, and reports using Tableau and Power BI
• Bringing data from different data sources to HR Datawarehouse using Talend and Python.
• Using Python to integrate data analysis with web apps and packages like Pandas and NumPy to slice data in excels.
• Writing Python scripts for Data Manipulation and Data Analysis.
• Writing Python scripts to automate report generation and scheduling.
• Establish processes and documentation to ensure People data quality
• Serve as front-line support for ad hoc report requests
• Assist with design and implementation of internal employee surveys
• Clearly communicate insights to key stakeholders and influence teams to take action based on our recommendations
• Act as an advocate of data driven culture on the People Team and across eBay

Confidential, San Jose

Responsibilities:

• Involved in Analysis, documentation, Development and Unit Testing. Developed the application logic in PLSQL using packages and advanced PLSQL concepts.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Created the enhancedlogical model in 3NFusing ER/Studio and the many to many relationships between the entities are resolved using associate tables
• Performed various operations likeData Cleansing, Data Scrubbing, Data Profiling
• Gathered and documented Functional and Technical Designdocuments

DB Lead/PLSQL Lead

Confidential San Jose

Responsibilities:

• Analysis, Design, documentation, Development and Unit Testing. Developed the application logic in PLSQL using packages and advanced plsql concepts.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages according to the new business measures.

Environment: Oracle 11g, SQL, PL/SQL, SQL * Plus, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows.

Confidential

Responsibilities:

• Monitor performance, analyze AWR identify top SQLs and continuously improve the system. Maintain source code for all database objects using SVN.
• Implemented various Data Transformations usingSlowly Changing Dimensions.
• Developed back end interfaces usingPL/SQL Stored packages,Procedures, Functions, Collections, Object Types, Triggers.
• Responsible forSQL tuning and optimizationusingExplain Plan, TKPROFutility and optimizer hints
• Used Bulk Collect feature to improve performance.
• Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages likeDBMS SQL, DBMS XPLAN, DBMS PROFILER, DBMS JOB, and UTL FILE.
• Creating builds/baselines using Maven. And also moving code from production to a code repository SVN

Environment: Oracle 10G, SQL, PL/SQL, UNIX, XML, ETL, SQL*Loader, Maven

System Engineer Oracle pl/sql Developer

Responsibilities:

• Worked with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents
• Allocated to Sales and finance module (in customized ERP) for client Bestseller A/S, a development& maintenance project in Manufacturing/ Retail domain, involved in various phases of SDLC in it and worked as primary PL/SQL developer for various applications individually as well as in team
• Worked on Agile/ SCRUM methodology
• Handling the key areas in BI2 i.e. Warehouse Valuation, Open To Buy, Sales operation Plan working as a SME in these area.
• Developed variousPL/SQL stored procedures and functions

Environment: Oracle 10G, SQL, PL/SQL, PLSQL Cartridge

Oracle pl/sql Developer, Jr. Technical Associate

Confidential

Responsibilities:

• Analyzed tables and indexes for Cost Based Optimization (CBO) for improving performance and work efficiently.
• Configuration of Oracle Enterprise Manager (OEM) to monitor database and report on events as defined by the DBA group.
• Involvement in the Requirement Impact Analysis (RIA) and FPA according to latest IFPUG guidelines.
• Involvement in Requirement Capturing, Analysis, coding and also UFE (User Familiarization Event).
• Thus involved in the complete cycle of development for a particular BS (Business Scenario) and CR (change request).
• Created several wizard-based forms usingHTML DBas Per the requirement
• Involved in RDBMS design related issues such as development ofEntity Relation diagramsusingERWIN
• Developed reporting applications, which provide users with canned and open queries to produce customized reports UsingOracle Reports
• DevelopedOracle 9i Formsapplications for user access to DSS data andOracle 9i

Environment: Oracle9i, SQL, PL/SQL, Toad5.0, UNIX, Erwin, Oracle Forms 6i, Reports 9i, Teradata.