Professional summary:

Over ** years of experience analyzing, designing, developing, implementing, tuning and supporting OLTP, OLAP and Reporting applications.

Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies.

Over 8 Years of experience DW and BI Application. Working with very large databases in size and volume of transactions.

Managed all activities necessary to take an ETL project from concept to production including system architecture definition, data modeling (star, snowflake) design (Kimball & Inmon’s Data modeling design principles), prototyping, development and testing.

Excellent analytical, organizational, management, technical and creative skills with a strong understanding of data warehousing technologies, data analysis, OLTP vs. OLAP flows and Operational Data Stores vs. Data marts design.

Over 7 years of experience of Data Analysis like Inspecting, cleaning and transforming data with SQL and Excel including uncover issues by debugging process of data collection.

Project Management Professional (PMP) certified. Proficient in Project Management - Initiate/Plan/Execute/Control/Close.

In depth understanding of Hadoop architecture and various components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node and MapReduce concepts. Hands on design and development experience with Hive, Sqoop, Impala, Spark and Spark SQL.

Very good experience of database performance tuning. Carrying out Performance benchmarks and tuning bottlenecks.

Good understanding of statistics including Linear Regression, Multi Regression, Decision Analysis, Decision tree.

Excellent team player with matured soft skills. Experienced in guiding, mentoring and leading the team. Proven record of accomplishment of strong analytical skills and communication skills.

A practiced mentor and advisor, able to establish rapport and trust with diverse groups of people at all levels. Highly regarded as an analytical problem solver and solutions provider with strong organizational and supervisory skills.

Technical skills:

Windows, Unix, Linux, Sun Solaris

Oracle 8i/9i/10g/11g, SQL Server, Mongo DB

PL/SQL, Java, J2EE (JSP, Java Beans, Java Servlet ), Java Script, HTML, XML,Python, Scala

TomCat application server, WebLogic Server, Maven,GitHub, SVN

Developer 2000 (Form 6i/9i/10g), Developer Reports 6i/9i/10g

Informatica Power Center (9.1, 8.6), Ab-initio 3.0, SAP BO Enterprise XI 3.0, Tableau

Oracle E-Business Suite – 11i/12 R (AP, PO, PA, GL, CM, OIE, F A, OM, BOM, INV, HRMS)

Big Data Technologies: Hadoop, HDFS, Hive, Map Reduce, Hive, Pig, Impala, Sqoop, Spark, Spark SQL

Professional career:

Sunera Technology: Programmer Analyst : July-2013 till date

Polaris Software: Sr. Tech Project Manager, Mar-2005 till Jun-2013

ARI, Mumbai: Sr. Software Engineer, Apr-2004 till Feb-2005

Eastern Software system: Sr. Software Engineer, May-2003 till Feb-2004

Project summary:

Client: Cisco Inc., San Jose, CA, July 2013 – Till Date

Project: Country Enablement

Role: Tech Lead / Sr. Application Developer

The Cisco CE-LSS project is to enable globally consistent processes and policies that adhere to industry standards with Oracle Release 12 as the foundational ERP system Migrate All Legal entity to CG1 ( Oracle Release 12 Environment).

Achievements:

Groomed offshore team members to increase their proficiency in using unfamiliar technologies, this resulted in reduction of project cost by 40 percent.

Streamlined CML creation process which reduced turnaround time by 50 percent.

Suggested and provided solution as a POC for CML creation using Big Data Technologies: Sqoop, Hive, Spark, Spark SQL.

Designed and developed ETL data lineage for Customer migraiton ETL pipeline.

Responsibilities:

Architect and lead the development and testing effort of CML creation and Custormer migration ETL Pipeline with strong results for 7 ETL releases for businesses.

Data Study and Data preparation from different sources of data like sales order, service lines for business critical process of CML creation (Customer Master List to identify customer to be migrated).

Create of Technical designed document from Business Requirement Documents including logical database model and get it approved from higher management along with others downstream teams.

Developed and maintained Customer migrations ETL Pipeline using Oracle procedures, functions and packages.

Loading huge volume of transactional data in to staging tables. Validate, map, transform and load data into the base table.

Performance tuning of Sql and PL/SQL like replacing bulk update with rowid update, buck collect, optimizer hint, insert with append etc. Used multithreading with Oracle dbms_Jobs.

Designed and developed POC for the CML creation using Big Data Technologies Sqoop, Hive, impala and Spark, Spark SQL.

Data modeling of CML application using hive ( Staging, ODS and Reporting schema )

Designed and developd ERMO Transition Planning Accuracy KPI and Changes post HLEP freeze with Python and SQL.

Environment: Oracle 11g, Oracle 11i/12R, UNIX, SQL, PL/SQL, SQL*PLUS, TOAD, SQOOP, ETL, HIVE, SPARK, Python

Client: CITI Bank, Tampa, FL July 2009 – June 2013

Project: Business Activity Warehouse (BAW)

Role: Technical Manager / Sr. Application Developer

BAW is expense warehouse of CITI Bank’s Accounts Payable program. It helps Citi Finance in its Accounts Payable (AP) functions. It ensures that spending in compliance with CITI Expense Management Policy (CEMP). Citibank Implemented Oracle P2P for Accounts Payable program

Achievements:

Suggested and provided solution to redesign legacy batch load which reduced monthly load time by 40%.

Managed to increase off-shore deliverable to 70 percent up from 30 percent there by reduced project cost by 30 percent.

Successfully converted a 6 year old T&M project in to a managed project.

Reduced average production ticket turnaround time from 15 days to 5 days.

Partnered with QA lead, came up with a synthetic data set for testing Monthly load in integrated environment. Introduced regression Testing frame work which reduced production issues by 50%.

Successfully designed, developed and implemented OLAP Cube frame work with Summary fact and High Availability tables.

Responsibilities:

Single point of contact for the BAW Application from Polaris. Project/Team/Stack holder Management. Prepared status reports and updated the project plan as required.

Architect and lead the development and testing effort of BAW with strong results for more than 15 ETL releases for businesses through offshore-onsite model.

Worked at conceptual/logical data model level and created Physical Data Model with DDL according to requirements from the Logical Data Model, which included creating tables, Partitions, views, synonyms, indexes.

Designed and developed aggregation reporting layer, high availability and point in time reporting model. Hands on experience in modeling Semantic (BO Universe) data layer and Interactive dashboard.

Designed and Developed high availability, point in time reporting and aggregation reporting layer with PL/SQL and Ab Initio. Involved in performance tuning of Application as well as reports and Dashboard.

Developed and maintained packages, functions and procedures to load the Staging, Fact (Invoice, Purchase Order, requisition and general ledger, T&E, UPS, Fedex) Fact tables, Aggregate Tables, Dimensions Table from source data.

Designed and developed Packages, Stored Procedures, Functions and Triggers using PL/SQL for common utilities. Created Oracle coding standard and naming conversion document. Code Review of other team member.

Involved in production support activities.

Have performed various testing activities like Unit Testing, Integration-System Testing, Regression Testing, and User Acceptance Testing and ensured that the code is ideal.

Provided development support for BO Universe design and development, Excelsius Dashboard and Ad-hoc reports.

Environment: Oracle 11g/10g, Oracle 11i/12R, UNIX, SQL, PL/SQL, SQL*PLUS, TOAD, Erwin, Ab Initio, Business Objects XI Re2, 3.1, SAP Xcelsius, SVN, MS Project

Client: CITI Bank India, Hong Kong & Taiwan March 2008 – June 2009

Project: CAPS MIS Strategy (ARIS)

Role: Sr. Project Lead / Sr. Application Developer

System with a three-fold functionality (Credit, Admin, Portfolio Management System), CAPS serves as an end-to- end loan processing system, catering to the entire life-cycle from credit appraisal and approval to credit administration and finally collateral management.

Responsibilities:

Involved in SDLC gathering requirements from end users Involved in Delivery and Project plan creation and execution. Involved in RDBMS design and developed ER data model using Erwin. Participated in code walkthroughs and review sessions with the development team.

Participated in Data Study, Inspect, clean and Transform data from 33 sources (flat files) to input into CAPS system.

Participated in system analysis and worked at conceptual/logical/physical data model level using Erwin according to requirements, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.

Created programming code using advanced concepts of Records, Collections and Dynamic SQL. Developed procedures, functions, packages and triggers to facilitate consistent data entry into the database.

Developed PL/SQL common utilities like packages, functions and store procedures.

Environment: Oracle 10g, J2EE, WebLogic 6.1, Business Object, UNIX, Sun Solaris, PL/SQL, SQL*PLUS, SQL Developer

Client: Royal Bank of Scotland, London October 2006 – March 2008

Project: Algo Suite Implementation

Sr. Integration Engineering

Responsibilities:

Involved in Monthly Batch script creation and maintenance. Involved in Running and maintenance of low volume and synthetic for testing and investigation.

Worked on Integration of different Algo software for Created several Unix shall script to support the Algo software configuration and debug.

Complex query building and tuning for ADE reporting for US FED and GB FSA.

Involved in creation of new environment. Installed all components of Algo software.

Environment: Sun Solaris, Oracle 9i, Core Java, Perl, Algo Suite

Client: Citibank, India March 2005 – September 2006

Project: Custody Enhancement and Support

Sr. Programmer

Client: MMD, Mumbai April 2004 – February 2005

Project: MMD Apps

Role: Sr. Programmer

Client: GlaxoSmithKline, Mumbai May 2003 – March 2004

Project: Implementation of Ebizframe (ERP)

Role: Programmer

Education & Certifications:

Master of Computer Applications from Sambalpur University, Orissa, India

Bachelor of Science (Mathematics), 1994-1997, Sambalpur University, Orissa, India

Project Management Professional (PMP), Project Management Institute (PMI)

MongoDB for Java Developers, MongoDB University

Learning Germany from German School of Fremont

Professional Reward /recognition

GEM Award for month, GEM of GEM for Quarter and Konark from Polaris Software Lab

Contact this candidate