SUMMARY:

• Around 16 years working experience in Business Intelligence, OLTP databases, Data Warehousing, Data mining and BIG Data
• Experience working with relational databases Oracle, MYSQL, Teradata and BIG Data
• Strong skills in ETL Scripts, Shell, Perl scripting to implement business logic in oracle database.

SKILLS / TOOLS:

Databases: Oracle 6.0/7.3/8.0/8 i/9i/10g/11g/12C, Greenplum (PostgreSql)

Oracle Products: SQL*Plus, PL/SQL, Oracle 8i/9i/10g/11g, Oracle Streams, Oracle Web Application Servers 9i/10gAS, Oracle Discoverer 4.X, Oracle Forms 6i, Datapump, Export, Import, Oracle SQL*Loader, JDBC, Oracle Warehouse Builder, Oracle ERP (AR, AP, FA, GL, OE, AOL)

Database Utilities: OLAP, Data Warehousing (Oracle Warehouse Builder), MDX, UNIX Shell Programming, Perl, JDBC, JAVA, SQL*Plus, SQL*Loader

ETL Tools: Informatica PowerCenter 8.6/8.5/8.1//7. x/6.x/5.x

Reporting Tools: Business Objects, OBIEE, Oracle Reports

Data Modeling: ERWin Data Modeler r7.3/4.x (ERD), MS Visio 2000

Other Tools: DBArtisan, PL/SQL Developer, TOAD, MS Access & MS Excel, XML, MS Office (MS Access, MS Excel, MS PowerPoint), Hadoop, Hive

Predictive Analytics: Oracle Data Miner, Alpine Data Labs, Madlib

Tools: Job Schedulers CRONTAB, AUTOSYS

Languages: COBOL, Java, J2EE, SQL, Oracle PL/SQL, PERL & Shell Scripts

Operating Systems: Linux (Red Hat), UNIX (Solaris, AIX v5.2), Windows (98, NT, 2000, 2003, XP, Vista)

PROFESSIONAL EXPERIENCE:

Confidential, Brisbane, CA

Senior Data Analyst

Responsibilities:

• Involved in doing the Requirement Analysis and documenting
• Created Tables, Indexes, Partitioned Tables, Materialized Views, Stored Procedures and Packages in oracle and hive
• Worked on designing the table layout in hive, scripts to write the data into hadoop
• Automating the analytics report using Java UI
• Writing sql’s for analytics in oracle and hive
• Designing the reports layout
• Working on Teradata BI Environment for generating the Analytics on Members, Revenue etc.

Confidential, Milpitas, CA

Senior Tech Lead

Responsibilities:

• Analyzing BIG Data Software Stack on Confidential servers etc.
• Involved in doing the Business Analysis and Requirement, writing the technical document and data modeling for Business Intelligence solutions
• Creation of SQL Scripts, stored procedure, functions and packages in Oracle
• Involved in analyzing Credit Data Analysis and Data Mapping etc.
• Wrote ETL Scripts using plsql, Shell and Perl scripts
• Created Tables, Indexes, Partitioned Tables, Materialized Views, Stored Procedures and Packages
• Worked on designing the table layout in hadoop, scripts to write the data into hadoop
• Analyzed the sales data using Machine Learning Algorithms like Regression, Support Vector Machine for prediction using Oracle Data Miner
• Created several dashboard in tableau on Retail Store Data and Credit Card Data
• Active member of BIG DATA and BIG DATA Science MeetUP
• Helped in organizing the BIG DATA and BIG DATA Science MeetUP
• Presented on machine learning algorithms like SVM, Decision Tree Clustering etc. in BIG Data Science MeetUP
• Filed a patent on BIG DATA Software stack

Confidential, Sunnyvale, CA

Senior ETL Lead/Architect

Responsibilities:

• Involved in doing the Business Analysis and Requirement, writing the technical document and data modeling
• Written Data Mapping Document, created Data Flow Diagram
• Created Data Model for Yidea application
• Creation of SQL Scripts, stored procedure, functions and packages in Oracle 10g
• Working with Users for gathering the report requirements and validation of reports
• Involved in doing the Data Analysis and Data Mapping etc.
• Modified the ETL Scripts, Shell and Perl scripts
• Created Tables, Indexes, Partitioned Tables, Materialized Views, Stored Procedures and Packages

Confidential, Mountain View, CA

Principal Analyst/ Senior Programmer

Responsibilities:

• Involved in doing the Business Analysis and Requirement, writing the technical document
• Creation of SQL Scripts, stored procedure, functions and packages in Oracle 10g
• Created Tables, Indexes, Partitioned Tables, Materialized Views, Stored Procedures and Packages
• Working with Users for gathering the report requirements and validation of reports
• Working on datawarehousing application, creating the star and snowflake schema
• Involved in writing the Shell scripts for scheduling

Confidential, MountainView, CA

Data Analyst/ Senior Oracle Programmer

Responsibilities:

• Working with users in understanding the requirement, writing the BRD and functional doc
• Creation of SQL Scripts for Reports, stored procedure, functions and packages in Oracle 10g
• Involved in doing the testing, validation of reports and writing the technical document
• Created Tables, Indexes, Partitioned Tables, Materialized Views, Stored Procedures and Packages
• Written several UNIX, PERL and Shell script
• Written PERL script (using PERL DBI) to extract the data from MYSQL to Oracle and flat file and vice versa
• Scheduling the Processes using cronjob and dbms job
• Created around 400 reports using Oracle SQL, Crystal Reports
• Worked on evaluation of the Reporting Tools like Business Objects, Proclairty, Inteliview and Oracle Business Intelligence Enterprise Edition (OBIEE)
• Created the reports using OBIEE for Customer Satisfaction, Written ETL Scripts for Data loading
• Created ERD Diagram (Data Modelling) using Visio for GUTS Report and Customer Satisfaction
• Worked on Teradata for getting the data for reports
• Working with Users for gathering the report requirements and validation of reports

Confidential, Brisbane, CA

Senior Tech Lead

Responsibilities:

• Involved in the process of the requirement gathering, writing the doc for users and programmers
• Designing database, including table structures and schemas
• Designing, testing and debugging new forms using Oracle FORMS 6i
• Desgining new reports and making new reports using REPORTS 6i, Excel and Crystal Reports
• Writing new packages, procedures, functions, triggers.
• Used SQL TRACE, EXPLAIN PLAN in doing SQL query tuning and tracing forms execution
• Worked on Java API, HTML and JavaScript
• Migrating SQL queries and packages from Oracle erp (OE) 10.7 to 11i
• Writing the technical doc for the users and technical programmers, studying the requirement form doc and existing Reports and excel reports
• Building OLAP Cubes, Dimension using Analysis Services.
• Creation of SQL Scripts, PL/SQL package for XML and flat file, stored procedure and functions in Oracle 9i
• Involved in doing Data Conversion, Data Cleaning, Data Movement, DW mapping and transformation (ETL) such as Filter, Aggregator, Expression, router using INFORMATICA, Repository Manager, Server Manager, Workflow Manager and Workflow Monitor in INFORMATICA for Backlog Orders, AR, AP etc.
• Defining OLAP Cube measures and dimensions and writing MDX
• Doing Report development using ProClarity and Business Object, and worked on Creation of universes and generation of Reports using Business Objects
• Extensively used Calculations, Sorting, Rank, Drilldown, Drill through, Slice and Dice, Formatting, Changing Displays in Business Objects
• Created the ETL Migration Document after studying the user requirement
• Creation of SQL Scripts, stored procedure and functions in Oracle 9i
• Importing source/target table from respective databases and created reusable transformation, creating mapplets and mappings using Informatica designer, creating WorkFlows in INFORMATICA Powercenter, Scheduling sessions and batches in Informatica Workflow for OM, AR, Booking and Metering
• Involved in creating reports using Business Objects, DashBoards
• Working with database connections, SQLjoins, Cardinalities loops, Aliases, aggregate conditions, and hierarchies in Business Objects

Confidential, Redwood Shores, CA

Senior Programmer

Responsibilities:

• Working with ER diagrams in ERWIN
• Designing of table structures and schemas
• Creation of indexes, writing of procedures, packages in PL/SQL, Java stored procedures, Tuning of queries, Creation of dblinks, Java programming.
• Written Perl & Shell scripts

Confidential, Los Angeles, CA

Programmer

Responsibilities:

• Writing new reports like Costing by Phase/Task/Group etc,
• Modification of already developed reports using REPORT2.5
• Analysis and design of FIXED ASSET module using Designer 2000
• Designing new forms using forms 4.5
• Writing PL/SQL script, Database triggers, Procedures, tuning of Reports, and study of Oracle Web Server