SUMMARY

• Technical Experience: Over 10+ years of experience in developing, testing and maintaining Data Warehouse Applications and ERP Applications using Oracle 12c, IBM InfoSphere DataStage 8.7 & Quality Stage 8.7 and UNIX scripting.
• Domain: Enterprise Risk Management, Insurance and Finance.
• Roles: Lead Developer, Senior Developer and Onsite offshore Coordinator.
• Expertise: Application building, Writing Parallel Processing & Multi - threading in PLSQL, ETL Frame Work & Job Design(Using DataStage & PLSQL), Feed Automations, Performance Tuning and Data Migrations.
• Proficient in Agile Methodology implementation.
• Proficient in DataStage production issues, performance tuning and migration.
• TEMPEffective management of cross-functional and global teams.
• Experience converting business requirements into feasible technical solutions.
• Proficient in implementing principles of DW using Dimension Modeling.
• Expert in reading & loading data from multiple sources
• Highly organized, detail-oriented with TEMPeffective negotiator and multi-tasking skills.
• Excellent communication and a great team player.
• Storage analytical and problem solving skills.
• Training: Attended training on Hadoop 2.0

PROFESSIONAL EXPERIENCE

Confidential

Test Director

Responsibilities:

• Created Hadoop frame work for extracting data from Oracle DB to Hive which save 50% user time on querying
• Created parallel frame work which decreased report execution time by 50%.
• Lead a team to do fastest migration using reusable component which increased productivity by 25%
• Automated a data warehouse project with frame work that's easily scalable on pluggable input feeds and decreased development effort by 50%.
• Implemented NO COST file processing application using UNIX scripting

Confidential

Material Management System

Environment: Red Hat Linux, Oracle 12c, DataStage 8.7,Hadoop (Hive), Oracle Discoverer for ad-hoc reporting.

Responsibilities:

• As senior developer me was responsible for End to End development & delivery.
• Trouble shooting of production issues.
• Application performance tuning.
• Involved in rewrite of database design to improve performance of the application.
• Created generic bulk loading scripts for migrating legacy application data to new multi SID architecture.
• Created parallel & multi-threading frame work for reporting in PLSQL.
• Created Generic ETL jobs which will read the schema design from tables and load the target.
• Created data models such as Java bean (DTO) to get the result from database using JDBC connection.
• UNIX script creates the schema file based on the input in tables.
• Set up Hadoop cluster with Resource Manager
• Set up extraction process in Sqoop from Oracle DB

Integrated Data Repository

Environment: Red Hat Linux, DataStage & Quality Stage 8.5, Oracle 11g, Toad, Java and Autosys

Responsibilities:

• Participated in requirement gathering session with business users to understand the business requirement.
• Developed the automated scripts to create database objects in production.
• Designed table driven approach for generic ETL job load the ODS tables
• Prepared functional, system, performance and integration test cases.
• Developed UNIX shell scripts for running daily data loads using global environment file.
• Developed autosys jobs for running in production.
• Conduct Design Reviews and Code Reviews.
• Off shore task allocations and handling & Release verification.

Confidential

Environment: Red Hat Linux, DataStage 8.5, Oracle 11g, Toad, SQL Developer and Autosys

Responsibilities:

• Participated in requirement gathering session with stakeholders to understand the business requirement.
• Involved in data model review.
• Designed and developed ETL frame work.
• Developed SQL*LOADER scripts to load reference data into meta schema
• Created data lineage reports
• Involved in design and code review
• Prepared functional, system, performance and integration test cases.
• Developed Unix shell scripts for running daily data loads.
• Mentored junior developers by providing technical guidance and motivating them to meet the tight deadline.

Confidential

Environment: Red Hat Linux, Oracle 11g, SQL Developer and Autosys

Responsibilities:

• Participated in requirement gathering session with stakeholders to understand the business requirement.
• Manual mapping of ticker to internal ID
• Designed and developed UNIX frame work.
• Developed dynamic SQL*LOADER to load file to staging Created data lineage reports
• Involved in design and code review
• Developed Unix shell scripts for running daily data loads.
• Mentored junior developers by providing technical guidance and motivating them to meet the tight deadline.

Confidential

Environment: Red Hat Linux, DataStage 705, Oracle 11g, Toad, SQL Developer

Responsibilities:

• Participated in requirement gathering session with stakeholders to understand the business requirement.
• Involved in data model review.
• Designed and developed ETL frame work
• Performance tuning and production bug fixes
• Developed automated database build and installer using Unix shell scripts.
• Performed technical code review.

Confidential

Environment: Red Hat Linux, DataStage 705, Oracle 11g, Toad, SQL Developer

Responsibilities:

• Participated in noledge transition sessions and prepared system study documents.
• Migrated Pricing and Reference business logics builds in DataStage into Oracle PL/SQL APIs.
• Designed and developed end-to-end ETL process for Corax feed using Oracle (SQL, complex views, collections, procedures, functions, packages and triggers in PL/SQL).
• Designed and Implemented Error Log frame work to capture database/application errors and send alerts to operations team.
• Designed and Implemented database purge frame work to purge queue and staging tables using PLSQL and metadata.
• Enhanced Builder Director/Publisher API performance by making use of PL/SQL collections (BULK FETCH/BULK INSERTS) and Parallel Executions of SQL.
• Developed SQL*LOADER scripts to load Reference/corporate actions SDI files into DSE scheme.
• Fine Tuned business logic SQL’s and PL/SQL APIs by using EXPLAIN PLAN and TKPROF.
• Participated in Migration of application from Oracle 9i to 10g.
• Developed Unix shell scripts for running daily data loads.
• Created Database build/release and configuration management procedures.
• Developed automated database build and installer using Unix shell scripts.
• Performed technical code review.