Mansi Malegaonkar

Senior Developer/Analyst

OVERVIEW

. Around 9 years of experience working on various phases of Software

Development Life Cycle (SDLC)

. Around 9 years of Experience in SQL/PLSQL/T-SQL

. Around 9 years of Experience in Oracle, SQL Server, have development

expertise in queries, stored procedures, triggers, index

. Around 5 years of data analysis experience

. Around 5 years of Experience in Data Warehousing and various ETL Tools

like SAP Business Objects Data Services (BODS), Oracle Data

Integrator(ODI) and Sql Server Integration Services(SSIS) and analytic

tools like SQL Server Analysis Services(SSAS) and Star/ Snowflake

Schema model

. Over 4 years of experience in Database Design.

. Over 2 year of Experience in BI Reporting tools like Crystal Reports, SSRS, Oracle reports

. Around a year working with Data visualization tools like Tablue

. Hands-on experience in Oracle queries tuning using SQL Trace, Hints,

explain plan.

. Excellent communication skills and ability to handle responsibilities

independently as well as being a proactive team member.

. Ability to learn new systems and procedures with minimal direction and

supervision in a rapidly developing environment.

. No not require Visa SponsorShip

TECHNICAL SKILLS

Operating Systems: Microsoft Windows XP/NT/2000/98, UNIX, Linux

Tools: TOAD, PL SQL Developer, SQL Server Management Studio, SQL

Server Management Studio, SQL Server Analysis Services,

Oracle Reports, Crystal Reports, Tableau Reports,

Languages: SQL, T-SQL, PL/SQL, Pro*C

Technologies: SQL server Integration Services(SSIS), Oracle Reports,

SQL Loader, Oracle Data Integrator(ODI), Unix, SQL Server

Analysis Services (SSAS),

Databases: Oracle 9i/10g/11g/12c, SQL server 2007/2009.

PROFESSIONAL EXPERIENCE

Caterpillar (Peoria, IL)

Application Developer Analyst

Apr 2016 - July 2016

Working with the ASC portal team as their Data Analyst/ Developer for

Global Supply Chain department and involved with the Business Analyst in

gathering the data related requirements, creating the data model where

needed and Bridging the gap between database developers and Business

Analyst. Also, working as the database developer to developing,

maintaining, analyzing and designing the Web portal for the team.

. Working on designing new Database and involved in requirement

gathering meetings, and other technical meetings

. Delivering deliverables like ER diagram, data flow diagrams, Data

dictionary for the design part of the database

. Creating tables, constraints and indexes and working with UI team to

incorporate their needs in the existing design

. Worked on Transition in Getting some of their Projects/Modules to

resolve errors and be functional

. Worked on Performance Improvement stuff and fixing major bottleneck in

the system

. Source Controlling the DB code

. Resolving the project related Support issues as and when needed and

being available on support call as needed.

. Creating the migration plan and actually migrating the data from

different sources and writing PL SQL procedures, functions and

packages as part of the migration and making sure refreshes run fine.

. Writing Migration scripts when moving from one environment to another.

Caterpillar (Peoria, IL)

Application Developer Analyst

September 2014 - Mar 2016

Working with GIS-PLM team of Caterpillar as the Lead Database Analyst

developer and have been involved in developing, maintaining, analyzing and

designing the applications like FMEA (existing application support as DB

person as well as new application re-write), PIN and VIN application

(design to Support), MCT (Material content Tool), APQP (which involved

complex team center related data), Record Locator, ROPS and also

involved in Support for other applications.

. Working on designing new Database and involved in requirement

gathering meetings, and other technical meetings

. Delivering deliverables like ER diagram, data flow diagrams, Data

dictionary for the design part of the database

. Creating tables, constraints and indexes and working with UI team to

incorporate their needs in the existing design

. Worked on Transition in Getting some of their Projects/Modules to

resolve errors and be functional

. Worked on Performance Improvement stuff and fixing major bottleneck in

the system

. Writing new PL SQL procedures, functions and packages as part of the

application development and as and when needed by the UI team.

. Working on existing system to fix bugs, implement new changes and

testing and deploying the code as needed

. Working with the analysts in old applications rewrite and suggesting

on utilizing new oracle features and implementing stored procedures,

packages as per the requirement

. Migrating data from old systems to newer systems meeting the

constraints and new business rules implemented

. Resolving any implementation and after deployment issues if any and

monitoring the jobs for their execution and success.

. Designing a new Database system as per the requirement for the team

and creating Data Flow diagrams, ER diagrams.

. Writing the DDL scripts, Views, Materialized views to get the new

Structures in Oracle and Populating the data.

. Involved in Major testing for Upgrading the system

. Implemented Error Logging and Periodic Data purging for all of their

major systems.

. Testing the system for performance and Building unit as well as

regression testing Test cases.

. Creating ad hoc tableau reports for the applications as requested by

the user.

Pekin Insurance (Pekin, IL)

May 2012 - May 2013

ETL Data warehouse Oracle Developer

Working with the Data warehouse team to maintain the existing ETL jobs and

develop new ETL which consists of loading data from Cobol copybooks (System

being on Mainframes) into Oracle and also jobs which Integrate data from

multiple Copybooks or tables at time.

. Involved in mapping functional requirements to technical design

documentation.

. Interacting with individual application owner to understand the

respective system.

. Creating DDL scripts for the System which included creating Tables,

Indexes, Constraints, Views, and also partitioning the tables. DML, TCL

on tables

. Creating Packages for SAP Data services

. Implementing performance improvements for already existing processed

in database (scripts) or ETL load

. Writing testing scripts for Testing if the ETL load ran successfully

. Writing queries for Data Quality checks

. Working on ways to limit the data so that a faster loading time could

be achieved

. Unit testing and system testing for developed code

. Working with the QA Team on Testing data

. Working on Data services to implement different Transformations needed

to be performed for data transformations

. Writing complex sql queries to validate the data for ETL and also for

auditing queries

Monsanto (St. Louis, Mo)

January 2012 - May 2012

Oracle PL SQL /ETL developer

Working with the Technical Development team to Maintain and develop their

database which consists of huge agricultural data for harvesting seasons

across Monsanto. This is an ETL project which uses Dimensional Modeling

and Oracle's packages and procedures to design the ETL system. The database

for this project is Oracle 11g and the tools being used are Toad, Autosys

and Sybase Power designer.

. Involved in mapping functional requirements to technical design

documentation.

. Interacting with individual application owner to understand the

respective system.

. Data Modeling using Power Designer.

. Creating DDL scripts for the System which included creating Tables,

Indexes, Constraints, Views, and also partitioning the tables. DML, TCL

on tables

. Creating Oracle Packages for the Business Needs

. Implementing performance improvements and introducing partition loading

across the entire system so that incremental loads can be enabled.

. Writing Dynamic SQL and PL SQL

. Tuning the queries for Faster Execution

. Working on ways to limit the data so that a faster loading time could

be achieved

. Implementing AUTONOMOUS Transactions, Bulk Processing, Exception

Handling.

. Unit testing and system testing for developed code

. Unit Testing and Testing the PL/SQL packages in UAT

. Sourcing the data from files into Oracle Tables and cleaning the data

to bring to a consistent state.

. Transforming the data and loading the Dimensional and Fact tables with

the data and validating the constraints.

. Helping the Reporting team with tuning the queries and help with ad hoc

reporting.

Reinsurance Group of America (St. Louis, Mo)

October 2010 - November 2011

Oracle DW(PLSQL) Developer

Working in Enterprise Reporting Team, worked on ETL and Reporting part. ETL

is mainly done using PL/SQL packages and scheduling theses packages to load

the Facts and Dimensions which are later used as source by SSAS to load the

cubes which would be used to generate reports by the Users. The Database

for this project was Oracle 10g and the other tools being used were SSAS,

Toad, and Oracle scheduler.

. Involved in mapping functional requirements to technical design

documentation.

. Interacting with individual application owner to understand the

respective system.

. Data Modeling.

. Creating DDL scripts for the System which included creating Tables,

Indexes, Constraints, Views, and also partitioning the tables. DML, TCL

on tables

. Creating Oracle Packages for the Business Needs

. Implementing AUTONOMOUS Transactions, Bulk Processing, Exception

Handling.

. Making changes to the Existing Packages as per the requirements.

. Writing Dynamic SQL and PL SQL

. Working with the Project plan creating data warehouse from a

dimensional model

. Tuning the queries for Faster Execution

. Analyzing the cube queries for faster execution

. Creating a new Cube afresh from the mart, and creating aggregations

. Working on Process Full and Incremental Updates for the Cube

. Tuning the cube for better performance.

. Implementing AUTONOMOUS Transactions, Bulk Processing, Exception

Handling.

. Unit testing and system testing for developed packages.

. Designing and implementing the cube design.

. Unit Testing and Testing the PL/SQL packages in UAT

. Creating the Schedule for implementing the execution of Packages.

. Writing Maintenance Scripts and Executing them

JP Morgan Chase (Columbus, OH)

Apr 2010 - October 2010

Oracle PL SQL Developer

Currently working on the Intranet Deal Model (IDM) project which is an in-

house tool developed for the Business Clients of JPMC Bank. The project is

intended to model the scenarios for the services offered by JPMC to its

clients in which it can offer specific deals according to the services and

volume of services. This project is the part of the Big Treasury Services

Project of JPMC. The database for this project is Oracle and the Front End

GUI has been developer using Java.

. Involved in mapping functional requirements to technical design

documentation.

. Interacting with individual application owner to understand the

respective system.

. Data Modeling.

. Design of Tables, Indexes and Constraints.

. Designing stored Procedures, Packages, Dynamic DML's DDL's for

maintaining and designing new applications.

. Importing data from various files (Historic Data) into the existing

system (Tables) using SQL*Loader.

. Implementing AUTONOMOUS Transactions, Bulk Processing, Exception

Handling.

. Unit testing and system testing for developed packages.

. Tuning queries.

. Required writing dynamic SQL as data was originated in different

sources and required writing complex queries.

. Designing to new reports and maintaining existing reports using Crystal

Reports.

. Creating complex reports using multiple sub-reports and Complex

Formulas in Crystal Reports

Persistent System (Pune, India)

February 2007 - April 2009

Developer (Data warehouse developer for ETL/Reports)

Developer on an internet advertising project where the database was used to

track advertisers, campaigns, and method of payment. The project was a

Business Intelligence implementation for Yahoo Advertising market

. Involved in mapping functional requirements to technical design

documentation.

. ERWIN was used as the Data Modeling tool.

. Designed and wrote queries to retrieve appropriate data from the

database.

. Wrote triggers, stored procedures and Dynamic SQL queries.

. Tuned queries for faster execution and performance improvement.

. Responsible for maintenance of defect logs, field trouble reports,

change requests and change register.

. Created unit and module test cases.

. Recorded erroneous data and communicated with the modules regarding

erroneous data.

. Performed application and system deployment.

. Created end user reports.

. Created test case and testing results reports.

. Implemented ETL using Oracle packages (Dimesnional Modeling)

. Was a part of design and development group for ETL.

Tata Consultancy Services (TCS) (Mumbai, India)

January 2005 - February 2007

Assistant System Engineer (Database Developer)

Key areas of work included PL/SQL and Oracle Warehouse Builder. The

business details of the company were monitored with Oracle Financials and

Oracle CRM.

. Involved in mapping functional requirements to technical design

documentation.

. Involved in preparation of high level and low level technical design

document (Class Diagrams and Sequence Diagrams) for e-Commerce module

using Rational Rose Tool.

. Involved in the design and writing of queries to retrieve appropriate

data from the database.

. Created triggers, stored procedures, views and Dynamic SQL queries as

required by the Reporting Team.

. Maintained the database and handled issues regarding data load.

. Involved in actively tuning queries for faster execution and

performance improvement.

. Created materialized views for faster execution of queries.

. Created unit and module test cases.

. Involved with Oracle Financials modules.

. Maintained version control for software components using VSS.

. Defined system test requirements and scenario creation to enable end-to-

end testing.

. Developed mappings using Oracle Data Integrator.

. Used Oracle Data Integrator to integrate the data from different

sources.

. Data was gathered from different sources and modules such as Microsoft

SQL, Oracle, Spread Sheets, and CSV files.

. Primary contact point for ODI.

. Developed Static Flow and Control Flow Rules for integrating data in

ODI.

. Defined and executed interfaces.

. Logged erroneous data using ODI.

. Executed Oracle Jobs.

. Made changes in the existing mappings according to business needs.

. Involved in the design and writing of queries.

. Wrote triggers, stored procedures, views and Dynamic SQL queries as

required by the Reporting Team.

. Responsible for Production Support.

. Tuned queries for faster execution and performance improvement.

. Wrote materialized views for faster execution of queries.

. Created and Maintained batch programs.

. Creating test cases and testing reports.

Contact this candidate