Niranjan Deshpande

Cell No: 408-***-****

Email: ac35u8@r.postjobfree.com

Summary of Qualifications

More than 16 years of total IT experience in Software Development Environment.

Over 5 years of Professional experience as Technical Team Lead with solid understanding of Business Requirements Gathering, Business Process Flow, Business Process Modeling and Quality Assurance

In depth knowledge in Banking, Finance, Child Support, Mortgage Industry, Retail, Automobile and Healthcare Services

More than 10 years of Oracle PL/SQL experience with Strong SQL and Performance Tuning and Strong understanding of Data modelling, database design, transactional and data warehouse systems

More than 8 Years of experience in Data Analysis and Data Migration

Hands-on experience in preparing Source to Target Mappings, Requirements Gathering using Software Development Life Cycle (SDLC) methodology and Rational Unified Processes (RUP)

Worked on complex SQL queries and SQL artifacts (Stored Procedures and Views)

Proficient with creating Test Cases and creating Test Data and Screen Mockups for Quality Assurance of client server and web-based systems

Experience in Materialized Views, Analytical Functions, PL/SQL Collections & Bulk collections, Debugging

Experience in Oracle Warehouse Builder(OWB) and Business Objects

Experience in Oracle Application Express (APEX)

More than 9 years of experience in PLSQL code debugging skills within Procedures

Experience in working in all phases of Software Engineering, expert in gathering, developing and documenting Business Requirements Document (BRD), User Requirement Specification (URS), Functional Requirement Specification (FRS), System Design Specification (SDS), System Requirement Specification (SRS)

Extensive experience in Object Oriented Analysis and Design (OOAD) techniques with UML using Flow Charts, Use Cases, Class Diagrams, Sequence Diagrams, Activity Diagrams and State Transition Diagrams

Experience with SQL*Plus, SQL*Loader, Data Pump, Export/Import, TKPROF, Oracle scheduler, Advanced Queues

Experience in ODI Logical and Physical Architecture, Context

Experience in performance tuning - analyzing query plans and query tuning, partitioning, optimizer hints

Experience in ODI Pub Admin Maintenance and Operator Page for setting up directory structure for File systems using FTP/SFTP, defining locations, Process and process steps

Experience using Bulk processing, ETL operations, REF cursors, collections, DBMS packages.

Experience in Monitoring Integration Process using ODI Navigator

Experience in web development technologies like HTML, CSS, and JavaScript

Strong background in Unix environment, FTP, data transfer from legacy Systems, shell scripting

Experience in Database architecture, data modeling, design and development in Oracle technologies

Experience in performing User Acceptance Testing (UAT) and documenting test results

Experience with Designing and verifying Databases on Oracle and SQL Server RDBMS using Entity-Relationship Diagrams (ERD)

Proficient with Unix including bash and/or ksh

Involved in evaluating, architecting, developing, testing, implementation, and documentation of a migration

Project Experience

Massachusetts Department of Revenue, Chelsea, MA

Project: Child Support Enforcement Systems Implementation

ETL/ODI Conversion Analyst January 2016 – Present

As a Conversion Analyst, I involved in the Conversion project and I am working with a team of designers and developers through the Software Development Life Cycle (SDLC).

My role was to assess the impact on downstream data management environments of processing different child support functionality via different systems and processes. I was also, involved in requirements gathering, data mapping, and documenting metadata.

Analysis of the data identifying source of data and data mappings of child support

Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.

Define data mapping requirements, write conversion specifications, create conversion routines, perform conversion verification testing and assist with the conversion from the legacy system to the new Child Support Enforcement System

Interacted with the SME's to analyze the data extracts from Legacy Comets Systems (Mainframes and COBOL Files) and determine the element source, format and its integrity within the system.

Worked on creating Oracle Data Integrator (ODI) installation/ repository creation/ configuration, interfaces/packages development.

Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information.

Design of relational database model for conversion team as per business requirement as part of business intelligence team

Ensured that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.

Develop ETL development and load management Standards and Processes.

Performed small enhancements (Element additions, data cleansing/data quality).

Contributed significantly towards initiating work request to fix root cause/enhance exiting process and/or also add new functionality with exact code detail requirements

Working with the full conversion lifecycle, including development of source/target mappings, business rules, transformation logic, error handling and control total reports

Extract, transform and load data into target data location from source data location using (Oracle DB 11.x) database development tools.

Participated in weekly technical team meetings for effective and efficient operations of production services.

Supported development teams creating applications against supported databases

Performing in depth unit testing for all enhancements/new development – including data analysis for verification of accuracy and performance tuning for optimal execution.

Write complex SQL queries (involving multiple joins, sub-queries and analytical functions).

Managing timely written and verbal communication on project progress, load status, issue tracking, and concerns for management attention and/or escalation

Directly interact with end-user for requirement gather gathering and understanding business process.

Provided inputs to development team in performing extraction, transformation and load for data warehouses.

Environment: ODI 12c, Oracle 11G, ER/Studio, Toad, IBM Rational Team Concert, MS Excel, PL/SQL, UNIX

Farmers Insurance, Plantation, FL

Project: SOON Migration from OWB to ODI

Lead Data Analyst May 2014 – December 2015

For SOON project, I worked for Data migration project. Data Migration contains the process of translating data from one format to another. This consists of Data Import/Export, Data cleaning and Data migration. The data is collected and migrated as per the requirements.

Interpreting and implementing business requirements for ETL development.

Was responsible for Integration of various data sources in Oracle

Write complex SQL queries (involving multiple joins, sub-queries and analytical functions).

Migrate OWB ETL Experience (code/debug/fix/QA Prod issue) to ODI.

Wrote documents on OWB, ODI objects and functionality in the form of ETL specification and design documents.

Performed data load from customer sent files into Oracle database.

Created document for best practices in ODI.

Developed / designed / supported applications related to insurance within groups in Data management technologies.

Played key team role developing UNIX shell scripts and PL/SQL scripts. In addition, actively contributed towards tuning and executing SQL reports related to data requests related to insurance application

Interpreting and implementing business requirements for ETL development, Experience in slowly changing dimension.

Implementation of Metadata Repository, Maintaining Data Quality, Data Cleanup procedures, Transformations, Data Standards, Data Governance program, Scripts, Stored Procedures, triggers and execution of test plans

Participated in weekly technical lead meetings for effective and efficient operations of services.

Performing in depth unit testing for all enhancements/new development – including data analysis for verification of accuracy and performance tuning for optimal execution.

Adhering to existing ETL development and load management Standards and Processes.

Experience in Integration between applications and servers, operating system

Managing timely written and verbal communication on project progress, load status, issue tracking, and concerns for management attention and/or escalation

Knowledge and application of Kimball Methodology in an Oracle 10g or 11g environment leverage OWB 10gR2 or 11gR2 including Star/Snowflake Schema.

Designed and developed new Oracle objects and customized existing objects as per business need.

Developed validations using SQL

Environment: OWB 10/11, ODI 12c, UNIX, FTP, Oracle 11G, ER/Studio, PL/SQL, Toad, Bash Script, Quality Center 12.2

Snap-On Business Solutions, Richfield, OH

Project: Ford - EPC5 - R8 Pub - Develop

Data Migration Analyst September 2013 – April 2014

Working for Ford’s EPC5 R8 Pub Project for publishing process using all these (RAW-BL-CDR-CEPC-QLINK) phases. This project consists of Analysis, design and Technical specification which contains Oracle and ODI development. Snap-On supports a global application named as EPC4 and need to re-write a CDR based EPC application which will help to meet these growing demands and move forward with the products worldwide.

Preparation of documents (Business functionality, Process Understanding, Technical system Design)

Design and implement data quality and data auditing processes

Triaged/resolved production issues for Oracle suite, especially focused on performance tasks

Performs moderately complex development tasks following SBS system development life cycle

In ODI Topology define different file systems and creates logical and physical schemas.

Map business requirements into ODI Interfaces, Packages, and Load Plans using source to target mappings.

Supported inbound/outbound data transfer for all customers that interface into Oracle systems.

Created Source and Target Data stores to map in interface to Transform and load data into various schemas based on Business rules defined.

Worked on Application architecture and design

Write complex SQL queries (involving multiple joins, sub-queries and analytical functions).

Created Load Plan and schedules load plan based on timing given by source system

Architect/Develop/Enhance system functionality that will categorize and create subsets of data

Developed cleansing, transformation and loading tools for Data model based on data validation use cases.

Analysis, Technical specification writing in ODI, Oracle SQL coding, testing and tuning

Development of Stored procedures, Triggers, PL/SQL programs along with developing UNIX shell scripts and PL/SQL scripts

Experience in Integration between applications and servers, operating system

Works with Lead Developers, Data Analysis, DBA’s, and end users in the specification, design, and construction, testing and implementation of publishing services

Work on application development projects as well as enhancements and maintenance of existing applications

Researches and understands the business and technical requirements for a publishing process/system, including target environment and performance criteria; suggests technical approaches to management on projects

Participate in software inspections and quality reviews

Automated testing scripts using Oracle Unit Test

Working on data integration solutions to utilize the Oracle Data Integration platform

Strong unit, integration and system testing skills.

Enforce business rules using ODI Constraints and data quality functions

Developed steps for Unit Testing and Test scenarios / Test Plans with QA Team

Performed End-to-End testing on the release version using AccuRev for the software application and detected & track bugs using JIRA.

Environment: ODI, UNIX, Oracle 11G, ER/Studio, FTP, Perl, APEX, Oracle Developer, PL/SQL, Bash Script, JIRA, AccuRev

Snap-On Business Solutions, Richfield, OH

Project: GM NextGen & CornerStone Publishing using CDR

Role: Sr Data Analyst September 2011 – September 2013

Working for General Motor’s NextGen and Cornerstone Projects for publishing process using CDR. This project consists of Analysis, design and Technical specification which contains Oracle and ODI development. Snap-On supports a global application named as EPC4 and need to re-write a CDR based EPC application which will help to meet these growing demands and move forward with the products worldwide.

Preparation of documents (Business functionality, Process Understanding, Technical system Design)

Design and implement data quality and data auditing processes

Developed technical design specifications, which included design of database for star schema related to data warehouse project as per client business requirements.

In ODI Topology define different file systems and creates logical and physical schemas.

Map business requirements into ODI Interfaces, Packages, and Load Plans using source to target mappings.

Developed cleansing, transformation and loading tools for Data model based on data validation use cases.

Write complex SQL queries (involving multiple joins, sub-queries and analytical functions).

Developed Oracle PL/SQL ETL packages from related technical specifications for data population into star schema tables.

Created Source and Target Data stores to map in interface to Transform and load data into various schemas based on Business rules defined.

Developed PL/SQL packages and shell scripts for customizations to Oracle module based on system design specifications.

Analysis, Technical specification writing in ODI, Oracle SQL coding, testing and tuning

Developed ETL packages and reports using Oracle tools

Worked on developing UNIX shell scripts and PL/SQL scripts, packages

Works with Lead Developers, Data Analysis, DBA’s, and end users in the specification, design, and construction, testing and implementation of publishing services

Enforce business rules using ODI Constraints and data quality functions

Created Load Plan and schedules load plan based on timing given by source system

Researches and understands the business and technical requirements for a publishing process/system, including target environment and performance criteria; suggests technical approaches to management on projects

Experience in Integration between applications and servers, operating system

Participate in software inspections and quality reviews

Automated testing scripts using Oracle Unit Test

Strong unit, integration and system testing skills.

Developed steps for Unit Testing and Test scenarios / Test Plans with QA Team

Performed End-to-End testing on the release version using AccuRev for the software application and detected & track bugs using JIRA.

Environment: ODI, UNIX, Oracle 11G, Perl, FTP, APEX, ER/Studio, PL/SQL, Oracle developer, Bash Script, JIRA, AccuRev

Northern Trust, Chicago, IL

Project: Exchange Traded Derivatives Reconciliation

Role: Data Analyst March 2011 – September 2011

Design and implement data quality and data auditing processes

Estimation & costing experience, Resource and team planning

Enforce business rules using ODI Constraints and data quality functions

Conducted interviews with the Source Team and Business Customers for gathering Business Requirements, System Requirements and Functional Requirements

Preparation of documents (Business functionality, Process Understanding, Technical system Design)

Automated testing scripts using Oracle Unit Test

Write complex SQL queries (involving multiple joins, sub-queries and analytical functions).

Worked on writing UNIX shell scripts and PL/SQL scripts, procedures, packages

Created and reviewed Functional Specifications, Project Schedules, and Test plans

Created Business Process Models using RUP to document current business process

Map business requirements into ODI Interfaces, Packages, and Load Plans using source to target mappings.

Experience in Integration between applications and servers, operating system

Performed extensive requirement analysis including data analysis and GAP analysis

Designed and developed Use Cases and UML models using Visio

Reviewed various Project Artifacts like High Level Design, Detailed Design, Unit Test Cases, and Integrated Test Plans etc.

Performed End-to-End testing on the release version of the software application and detected GUI bugs

Environment: ODI, UML, UNIX, MS-Visio, Perl, APEX, MS Project, MS Office, Oracle 10G, Rapid SQL, Crystal Report, PL/SQL, FTP, Bash Script

Cricket Communications, San Diego, CA

Project: Billing from IRB to EDW for Back Office and ETL

Role: Technical Team Lead April 2010 – February 2011

Involved in database design and writing store procedures and functions.

Acquainted with opportunities to optimize performance of ETL code & existing data structure

Preparation of documents (Business functionality, Process Understanding, Technical system Design)

Worked on different Knowledge Module like LKM,IKM, CKM,JKM

Automated testing scripts using Oracle Unit Test

Write complex SQL queries (involving multiple joins, sub-queries and analytical functions).

Design and implement data quality and data auditing processes

Enforce business rules using ODI Constraints and data quality functions

Worked on writing UNIX shell scripts and PL/SQL scripts, procedures, packages, forms

Worked with the business community of different departments to gather their report requirements and analyzed them to create Business and Functional Requirements

Map business requirements into ODI Interfaces, Packages, and Load Plans using source to target mappings.

Performed GAP analysis between the current state and future state Data Warehouse environment identifying data gaps and quality issues

Worked closely with the users to understand their current state of information availability and defined future needs based on analysis of Business Requirements, current state environments, Gap Analysis, and future state warehousing implementation

Defined timelines for project delivery, and provided the status update to the client team on a regular basis

Environment: UML, Bash Script, ODI, UNIX, FTP, BODI, SQL Server, Perl, APEX, PL/SQL, Crystal Reports, Clear Case

Cricket Communications, San Diego, CA

Project: Migration of DW5 to EDW

Role: Technical Team Lead December 2009 – April 2010

Execution of the Test Scripts/Test Scenarios

Creating the Defect descriptions and all relevant information

Involved in Requirements Gathering from user groups and analyzed workflows and UI screen dynamics

Customized the RUP framework and implemented it in the project

Created Activity and Sequence Diagrams in UML using Rational Rose and also involved in creating the Business Process Models

Documented and reviewed high level and detailed level requirements in Detailed Design Specification (DDS) document

Worked on writing UNIX shell scripts and PL/SQL scripts, procedures

Created Need Analysis Documents of the requirements gathered through JAD sessions and individual elicitation sessions using Rational Requisite Pro

Created the specs for the stored procedures and triggers, based on the business logic

Participated in entering, tracking system defects in Rational Clear Quest

Environment: ODI, Requisite Pro, FTP,PL/SQL, Rational Rose, UNIX, BODI, Test Manager, Perl, Share Point, MS Visio, MS Project, Bash Script

State Street, San Francisco, CA

Project: Business Process Re-engineering for Deployment

Role: Technical Team Lead April 2009 – November 2009

Responsible for the study of the requirements and designing of the system

Preparation of Technical System Design Document

Involved in designing and development of project

Working on an In-depth Analysis of the data files for different global custodians (Nos. 70) including JP Morgan Chase, Bank of New York, Northern Trust, Mellon Bank, Brown Brothers Harriman, U.S. National Bank, Dresdner Bank Luxembourg etc.… and thereby suggesting the enhancements eventually increasing the auto match percentile of the existing Recon application. Resultant in FTE saves.

Gathering the requirements from Client Source IT teams and thereby explaining the functional aspect and liaising with technical team for feeds development.

Involved in Requirements Gathering from user groups and analyzed workflows and UI screen dynamics

Customized the RUP framework and implemented it in the project

Created Use Cases based on the Business Needs and Features (BNF’s) provided by the business team

Created Activity and Sequence Diagrams in UML using Rational Rose and also involved in creating the Business Process Models

Participated in entering, tracking system defects in Quality Center

Environment: ODI, Requisite Pro, FTP, Test Manager, Share Point, MS Visio, MS Project

Confluence Pittsburgh, PA, USA

Project: Confluence Consulting Project

Role: Technical Team Lead August 2008 – April 2009

Confluence Unity software is a Platform aimed at Mutual Fund administration. It offers a variety of products to track Holdings, create financial statements and create Surveys.

Provide technical support for the implementation of the Unity platform and products.

Responsible for the creation of customized code and reports as per customer requirements.

Writing Queries, Stored Procedures and working on other Database Objects

Re-execution of the Test Scripts after fixing

Execution of Stored Procedures as part of Testing/Data Creation

Writing Scripts and creating Database Objects

Involved in Requirements Gathering from user groups and analyzed workflows and UI screen dynamics

Customized the RUP framework and implemented it in the project

Created the specs for the stored procedures and triggers, based on the business logic

Set up definitions and process for test phases including Product Test, Integration Test, System Test and User Acceptance Testing (UAT)

Environment: Test Manager, ODI, Share Point, MS Visio, MS Project, Oracle 10G, SQL Server 2005, Sybase, VB Script, Unity Platform and Crystal Report

SmartStream Technologies Ltd., Bristol, UK

Project: Smart Stream CoAc Porting (Migration and Upgrade)

Role: Technical Team Lead March 2008 – August 2008

Migrating database from SQL Server, Sybase to Oracle

Init: Admin User, Role, Tablespace, Create Batch files, User setup

Reference: Static BCP Method (Event Manager, SWIFT and Price Feed)

Upgrade Project from SQL Server to Oracle with various versions

Running each upgrade version in SQL Server and Oracle

Migrating Common, GUI, Excel and Alarm Stored Procedures and Temp Objects in Oracle

Working on Schema, application and data migration design and Unit Testing

Creating User Space, Roles for Database and Application Users

Environment: UML, ODI, ETL Tool, Oracle, SQL Server, MS Office and Sybase

SmartStream Technologies Ltd., Bristol, UK

Project: Smart Stream CoAc Porting (QA/Testing and documentation)

Role: Technical Team Lead January 2008 – March 2008

Installation of the Applications as per the standards and pre-requisites

Identification of Test Data for test execution

Execution of the Test Scripts/Test Scenarios

Creating the Defect descriptions and all relevant information

Re-execution of the Test Scripts after fixing

Understanding the application and knowledge transfer by means of Knowledge Sessions and creating of Understanding documentation for installations and product modules.

Environment: UML, MS Office, ODI, ETL Tool, C++, Oracle, SQL Server and Sybase

State Street IMS MUNICH, Irvine, CA

Project: Simcorp Dimension

Role: Technical Team Lead July 2007 – January 2008

Coordinates with the Client for acceptance of deliverables.

Involved in analyzing and reviewing the Custodian data to design one uniform format of custodian statements.

Writing and Maintaining Database Objects

Requirements gathering and preparing functional specification document.

Ensured standards are maintained at all the stages of the Process.

Designed and implemented the reports as per the formats compatible to reconciliation Tool (CT2000 Tool).

Environment: UML, BODI, ETL Tool, Oracle, Excel VBA, Visual Basic 6.0, Sybase 12.5, SQL Server 2000.

State Street IMS WEST, Irvine, CA

Project: CashTape2000 and Sign off Reporting Tool

Role: Technical Team Lead November 2006 – July 2007

Developed test cases in accordance to business requirements, technical limitations and product knowledge and ensured all the possible scenarios are included in the test plan

Controlled and tracked defects and change requests using Test Director

Used Test Director to create reports and graphs to help review the progress of planning tests, running tests, and tracking defects

Reviewed test objectives to make sure that all the possible scenarios are tested for the system enhancements

Documented Meeting Minutes of various meetings and Brainstorming Sessions

Developed project delivery schedule, managed projects and identified resources to successful completion

Designing and developing the various components for Accounting System.

Identifying the test cases for Accounting Infrastructure.

Creating Stored Procedures, Triggers and related database objects

Environment: Test Director, UNIX, Share Point, MS Project, MS Office, Excel VBA, Visual Basic 6.0, Oracle, Sybase 12.5 and SQL Server.

State Street IMS WEST, Irvine, CA

Project: Claim Automated Tracking System (CATS)

Role: Technical Team Lead May 2006 – November 2006

Conducted various interviews and meetings for requirement gathering with key business users and SMEs

Maintained and kept track of stakeholders requests for system enhancements and changes

Used Rational Requisite Pro to analyze and document requirements

Interfaced with development and testing teams to accomplish timely release objectives

Analyzed the system functionality in relation to impacts of the change requests and other system modifications

Technical Solution for adding Emailing Options to Store and Retrieve files after drag-drop.

Involved in Coding, Unit Testing

Environment: Share Point, MS Project, MS Office,Visual Basic 6.0, Oracle, Sybase 12.5, MS Excel and SQL Server.

State Street IMS MUNICH, Irvine, CA

Project: Six Sigma Pimco Munich

Role: Technical Team Lead November 2005 – May 2006

Acts as second-level escalation point for resolution of issues

Handling day-to-day project planning, controlling and execution.

Writing Database Objects and scripts for database roles

Manage Project Deliverables.

Environment: Share Point, MS Project, MS Office, Excel VBA, Visual Basic 6.0, Oracle, SQL and Sybase.

Ajanta Pharma Limited, India

Project: Financial Accounting System

Role: Team Lead May 2005 – October 2005

Responsible for multiple modules or one or more projects.

Writing Stored Procedures, Packages, Functions and Triggers

Executes project related responsibilities as assigned by PM.

Provides induction training to new members of the project team.

Designing the various components for Accounting System.

Identifying the test cases for Accounting Infrastructure.

Coordinating account activities with account dept.

Environment: Test Director, UNIX, Share Point, MS Project, MS Office,Visual Basic 6.0, Oracle 9, and Crystal Report 8.5.

Fine Jewelry India Limited, India

Project: Order Processing and Invoicing System

Role: Module Lead March 2004 – May 2005

Development and Unit testing of various sub-systems.

Coordinating project activities with team

Writing Database Objects and scripts for database roles

Environment: Visual Basic 6.0, Oracle, Sql Server 2000, and Crystal Report 7.0.

The Hodeidah Shipping & Transport Co. (SYC), India

Project: Container Tracking and Management System

Role: Senior Software Engineer March 2003 – March 2004

Development of various modules and Reports

Writing Database Objects and scripts for database roles

Environment: Visual Basic 6.0, Sql Server 2000, and Crystal Report 7.0

FDC Pharmaceuticals Ltd / Boston Scientific International, India

Project: Financial Accounting, Order Processing, Sales and Distribution System

Role: Software Engineer December 2000 – March 2003

Development of various modules and Reports

Writing Database Objects and scripts for database roles.

Environment: Visual Basic 6.0, Sql Server 2000, and Crystal Report 7.0

Technical Skills:

Operating System Windows 98/2000/XP/NT/2003/7/10, UNIX

RDBMS Oracle 9i/10g/11g, SQL Server 7.0 / 2000 / 2005, Access, Sybase 12.5, Rapid SQL, Oracle SQL Developer, PL/SQL Developer, Toad

ETL Tool Business Objects Data Integrator (BODI) 11.5/12.2, Oracle Data Integrator 10/11/12, OWB 10/11, Sql Server (DTS), SAP Data Integrator

Report Tool Crystal Report 4.5 / 7.0 / 8.5 / 9.0 / 10.0 / 11.0, Actuate

Modeling Tool UML, Erwin, IBM RTC, Microsoft Visio, Embarcadero ER/Studio

Front End Visual Basic 6.0, Excel VBA, Perl, DOT NET, VB Script, Shell Scripting, APEX, Java Script

Code Repository VSS, PVCS, AccuRev

Quality Tool HP Quality Center 9.2/11/12.2, JIRA

Education: Bachelor’s Degree in Mechanical Engineering

Certification:

Microsoft Certified Professional (MCP) in SQL Server 2000

Microsoft Certified Solution Developer (MCSD) in DOT NET

Oracle 9i Certified Professional (OCP) in DBA Track

Contact this candidate