Developer Data

Manohar Patidar

SUMMARY

Over all ** years of programming experience as Data engineer in IT industries, especially health care, retail, and banking domain.

Worked on architecture design and table design for implementing data solution for reporting need.

Having proven experience in Oracle SQL, PL/SQL, PostGres, PLpgSQL, SQL Server, Informatica, SSRS, Qlikview, Qliksense, Power BI, Pig, Hive, Python and others technologies.

Having exposure on cloud services Azure and AWS.

Having exposure a good on MySql 's SQL and NO SQL.

Worked on query analysis, query creation, performance tuning for reporting tool and PL/SQL program.

worked on rebuilding legacy queries and implementing them with new business logic.

Having good experience in Data modelling as per business need.

Worked with business analysts, data scientists, product managers, software development engineers, and other BI teams to develop and implement report solution.

Experience in data mining, profiling, and analysis.

Experience in Linux command line and Shell scripting.

Experience in Big Data technologies such as Pig, Hive and Hbase.

Expertise in Client-Server application development using Oracle database, PL/SQL, SQL *PLUS, TOAD, SQL Developer and SQL*LOADER.

Effectively made use of Collections, Indexes, Table Partitioning, Analytical functions, Materialized Views, Temporary Tables.

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Developed materialized views for data replication in distributed environments.

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Partitioned large Tables using range partition technique.

Worked extensively on Ref Cursor, External Tables and Collections.

Expertise in Dynamic SQL, Collections and Exception handling.

Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

Excellent communication, interpersonal, analytical skills and strong ability to handle team of developers.

TECHNICAL SKILLS

Languages : Oracle SQL, PL/SQL and Unix Shell script, Python,

Technologies : Oracle SQL, PL/SQL, PostGres,PLpgSQL, SQL server and SSRS

Cloud Platform : Azure (Synapse, ADLS, Databricks, Data factory)

ETL Tool : Informatica

Software Products : Oracle Forms, Oracle 11g, Oracle 12C, QlikView, PIG, HIVE, Python

Tools : Toad, SQL Developer, PL/Sql Developer, SQL Tools,

Databases : Oracle 12 C

PROJECT SUMMARY

Client: Humana Inc from 1-Aug-2013 to 15-Nov-2020

Role: Data engineer

Project: CMS audit

Description: The CMS audit module provide the data solution to organization that help to present the Healthcare data for Audit. It include getting data from various sources and cleansing and validations according to certain Govt rules and regulations.

Responsibilities:

Involved in requirement in gathering and implementing data solution.

Involved in creating queries for reporting purpose and tuning then when required.

Coordinated with the Web Services team to provide them with the necessary stored procedures and packages.

Worked on reporting tool like SSRS, Qlikview, Qliksense, and Power BI.

Created PL/SQL stored procedures, functions and packages for moving the data from staging area to Base Tables.

Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Effectively used of Cursors, Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.

Involved in internal QA and code review activities.

Engaged in Estimation and Solution Design Review Calls.

Created design, understanding and deployment documents for the deliverables.

Working with business team directly for requirement analysis solution development in critical timeline.

Attending Project status call, Scrum call and coordinating with offshore resource

Environment: Oracle PL/SQL, shell scripting, Toad, SQL Developer, $universe scheduler,

Unix, Windows7 and Oracle 11g Database.

Humana

Role: Oracle SQL Developer

Project: Plancompass

Description: RX Compass is a Reporting package that provides comprehensive end to end view of Utilization patterns of Large Commercial Groups and helps Humana Sales Staff to identify ways to guide members. The packages include – Anvita that summarize the Demographic Profile, Utilization Summary, Clinical and Pharmacy Data, Member engagement and Service Profile etc. The team is involved in creation of summary tables from the EDW, and creation of reports using BI Publisher and Qlikview.

Responsibilities:

Worked as a Pl/SQL Lead developer and onshore coordinator.

Used SQL* loader to load the bulk data

Created database packages, procedures, functions, triggers, views, materialized views using Oracle PL/SQL

Worked on SQL performance tuning using Index, Hint etc.

Developed and Bug fixed Stored Procedures and Packages in Oracle 10g.

Tuned existing ETL job to improve performance and reduce loading time.

Scope involved modification of job in lower environment, comparison of before and after modification status, migration of updated scripts and jobs to production after business validation, monitoring production run for more than a week and closure of request

Used Qlik view and CIA for reports generation.

Environment: Oracle PL/SQL, shell scripting, SQL Developer, Qlikview,$ universe scheduler, Windows7 and Oracle 11g Database.

Humana

Role: Developer

Project: Plan Pulse

Description: Plan Pulse is a Reporting package that provides comprehensive end to end view of Utilization patterns of Small Commercial Groups and helps Humana Sales Staff to identify ways to guide members. The packages include –Demographic Profile, Utilization Summary, Clinical and Pharmacy Data, Member engagement and Service Profile etc. The team is involved in creation of summary tables from the EDW, and creation of reports using BI Publisher and Qlikview.

Responsibilities:

Worked as a Pl/SQL Lead developer and onshore coordinator.

Created database packages, procedures, functions, triggers.

Created database packages, procedures, functions, triggers, views, using Oracle PL/SQL

Worked on SQL performance tuning using Index, Hint etc.

Developed and Bug fixed Stored Procedures and Packages in Oracle 10g.

Tuned existing ETL job to improve performance and reduce loading time.

Used Qlik view and CIA for reports generation.

Worked in Informatica ETL

Environment: Unix and Oracle 10g DatabaseOracle PL/SQL, SQL Developer, Informatica.

Client: Humana Inc

Role: Developer

Project: Customer Reporting

Description: This project includes demoralization of data from core table and creation of different wellness table for reporting purpose and creating reports for customer.

Responsibilities:

Worked as a Pl/SQL Lead developer and onshore coordinator.

Created database packages, procedures, functions, triggers.

Created database packages, procedures, functions, triggers, views, using Oracle PL/SQL

Worked on SQL performance tuning using Index, Hint etc.

Developed and Bug fixed Stored Procedures and Packages in Oracle 10g.

Tuned existing ETL job to improve performance and reduce loading time.

Supported daily,weekly and monthly jobs.

Environment: Unix and Oracle 10g DatabaseOracle PL/SQL, SQL Developer, Informatica.

Client: Humana Inc 1-Jan-2011 to 31-jul-2013

Role: Developer

Project: Wellness Data mart support and NIM

Description: This project includes integration of outside data into humana database and support of existing wellness jobs.

Responsibilities:

Worked as a Pl/SQL developer.

Created database packages, procedures, functions, triggers.

Created database packages, procedures, functions, triggers, views, using Oracle PL/SQL

Worked on SQL performance tuning using Index, Hint etc.

Developed and Bug fixed Stored Procedures and Packages in Oracle 10g.

Supported daily,weekly and monthly jobs.

Environment: Unix and Oracle 10g DatabaseOracle PL/SQL, SQL Developer

Sapient India 1-Sep-2009 – 1-Dec-2010

Role: Developer

Project: Pyramid Retrial

Description: This project related to report centre that include raw data collection and report generation.

Responsibilities:

Worked as a Pl/SQL developer.

Created database packages, procedures, functions, triggers.

Created database packages, procedures, functions, triggers, views, using Oracle PL/SQL

Worked on SQL performance tuning using Index, Hint etc.

Developed and Bug fixed Stored Procedures and Packages in Oracle 10g.

Supported daily,weekly and monthly jobs.

Environment: Unix and Oracle 10g Database Oracle PL/SQL, SQL Developer

Reuters 15-Mar-2007 – 9-Sep-2009

Role: Developer

Project: Credit Dim

Description: Credit Dimensions is a vertical credit market community providing cutting edge technology for credit risk professionals. This application provides data to its customer on adhoc basis.

Responsibilities:

Worked as a Pl/SQL developer.

Developed packages, procedures and functions for CDIM (ETL tool).

Monitoring the scheduled tasks and making report for them.

Created tables, views, synonyms, indexes, database links, plan table and jobs.

Development for the changes in the system as requested by client and fixing the existing defects.

Testing the existing and newly developed code to ensure its bug free execution in production.

Disseminating knowledge among colleagues and subordinates and succession planning through building backups..

Tuned the PL/SQL code and SQL queries for optimization.

Checking the coding standards Issue Handling.

Coordinated deployment of the code to production.

Environment: Unix and Oracle 10g Database Oracle PL/SQL, SQL Developer

Client: Sansui Bank of Japan 12-May-2006 to 13-Mar-2007

Role: Developer

Project: FinnOne

Description: FinnOne Lending is a software module of the FinnOne suite, which has been built with the objective of providing operational and decision-making support to all the asset side business lines of Banks and Financial Services Companies.

Responsibilities:

Worked as a Pl/SQL and form developer.

Created tables, views, synonyms, indexes, database links, plan table and jobs.

Development for the changes in the system as requested by client and fixing the existing defects.

Testing the existing and newly developed code to ensure its bug free execution in production.

Disseminating knowledge among colleagues and subordinates and succession planning through building backups..

Tuned the PL/SQL code and SQL queries for optimization.

Checking the coding standards Issue Handling.

Coordinated deployment of the code to production.

Environment: Unix and Oracle 10g Database Oracle PL/SQL, SQL Developer, oracle forms

EDUCATION

Master of science (MS) in computer from Barkatullah university, Bhopal, INDIA in 2005.

Bachelor of Science (BS) from Devi Ahilya University, Indore, INDIA in 2002.

Personal Profile

Name: Manohar Patidar

Marital Status: Married

Gender: Male

Contact this candidate