MADIREDDY GOPAL
Hoffman,NJ
Summary
- Senior Oracle Developer with more than 13 years' experience analyzing, designing, developing, testing, and implementing Oracle PL/SQL programming and database solutions and processes with architecture Oracle 10g/12c/19c/21c and SQL server databases and cloud data integration using ADF. Experience in Healthcare, Retail and Publishing domain Canned reports and ad hoc client facing reports on demand. Worked in both technical lead, developer and analyst positions. 24x7 on-call pager support for production database jobs and client reporting. Strong Knowledge in Oracle Underlying architecture Experience in data migration tools SQL
- Loader, Import/Export, Batch Processing , Golden Gate replication Extensive experience with PL/SQL stored procedures and triggers and Query Performance Tuning. Experience in maintenance, development of UNIX shell and PL/SQL scripts, T-SQL development and support with batch processing. Ability to work independently in a fast-paced environment. Experience as Technical Lead and providing support for client facing reports. Clients include Cigna, Aetna, Select Health, Blue Cross Blue Shield etc. Dimensional Data Modeling experience using Data modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling Experience in data ware data modelling and migration of data from source to targets. Unit, Regression, Integration, System Testing besides writing Test Cases and Test Scripts. Experience in support, development of ETL scripts for QlikView and Qlik Sense Loads creating QVDs. QMC scheduling for Qlik View and Qlik Sense ETL jobs. Strong communication, analytical and problem-solving skills Understanding of PySpark and Azure Databricks. Schedule and monitor complex jobs written in PL/SQL through crontab, control-m Understanding and Usage of Agile Scrum and JIRA Azure Databricks architecture, Azure Data Factory and notebooks. Data migration of datasets to Azure cloud using data factory pipelines.
Overview
16
16
years of professional experience
Work History
Technical Lead/Developer/Analyst
Claritev (formerly Multiplan)
New York
01.2015 - Current
- Logical data modelling and extension of network provider, Claims data warehouse using Erwin data modeler, defining entities, attributes, primary/foreign keys and relation cardinalities facilitating development activities.
- Designed and developed complex PL/SQL processes to load from from source systems to Target structures through multi staging into Data warehouse.
- Modelled claim dimensions, associated claim dimensions and claim fact datasets besides Client, Provider, Specialty Category dimensions.
- Extensively involved in performance and SQL tuning and loading large sets of data for client reporting improving overall response.
- Maintained shell scripts and used crontab, control-m jobs for automation of Database ETL processes.
- Maintenance and enhancement of PL/SQL scripts and packages.
- Development of new and modification of new procedures, packages
- Work with large datasets for batch reporting and Qvds creation for Qlik Sense and Qlik View dashboards.
- Extracted and transformed data from diverse sources (e.g., Oracle, SQL Server, Flat Files) into optimized QVD layers.
- Designed and developed interactive executive dashboards featuring KPIs, charts, pivot tables, and custom UI in Qlik View and Qlik Sense.
- Claims Utilization Dashboard: developed to report claims utilization at enterprise level with KPI and ability to generate reports for various clients. Dashboard was developed in QlikView and later migrated to Qlik Sense.
- Scheduled Qlik Sense, Qlik View jobs through QMC
- Mp3 Provider Networx Dashboard: Developed back-end processes with data pull from various Networx provider sources including credentialing to assist business to run provider reports. Oracle ETL process was used to prep the data consumed by Qlik View and Qlik Sense
- T-SQL development and batch processing support with Duke OON.
- Provided reporting support for client requests for United, Cigna, Select Health etc.
- Worked with DBA on backend database related activities such as deployment, production support
- Generated standardized reports for regular use and ad hoc client facing reports on demand.
- Designed and deployed end-to-end ADF pipelines to migrate legacy Oracle healthcare data to ADLS Gen2, reducing data latency by 40% and ensuring 100% encryption at rest via Azure Key Vault.
- Automated the deployment of cloud infrastructure by implementing Azure DevOps CI/CD pipelines for ADF
- Environment: Oracle 10g/12C/18C/19C/21C, Golden Gate, Data Guard, Qlik View 12.4..12.100, Qlik Sense, Control-M , Crontab, Informatica, Business Objects InfoView,JIRA
Developer/Analyst
John Wiley
Hoboken, NJ
01.2014 - 12.2014
- Involved in requirement analysis, architectural design and implementation of BMIS Data warehouse.
- Designed and developed complex mappings using WareHouse Builder to load data from source systems to Target structures.
- Developed Unix scripts to process the incoming files.
- Improvised the load performance
- Extensively involved in performance and sql tuning.
- Developed and maintained batch scripts and used crontab for automation of ETL processes.
- Utilized the sql loader for loading the stage tables.
- Developed various packages to process data
- Created Dimension Hierarchies and level based measures for business requirements and aggregate tables and aggregate levels.
- Worked with DBA on backend database related activities like export, import, golden gate replication.
- Support for client facing and ad hoc reports.
- Production support and ad hoc reporting.
- Integration of financial and statistical data from different source. Sales data from different global systems is extracted and loaded daily into BMIS
- Create revenue and expense monthly and quarterly financial reports.
- Environment: Oracle9i/10g, AIX 4.3, TOAD, Shell Scripting, Perl, Cognos Impromptu, Cognos Power play7.1, Oracle Warehouse Builder 9.2/10x, OWB client, OWB Runtime Audit Browser
Developer/Analyst
PepsiCo
New York
01.2013 - 12.2013
- Involved in enhancements, maintenance, end-to-end testing, and documenting the loading and extraction process.
- Prepared Source Data Analysis, Transformation logics and Update Strategies.
- Wrote Oracle PL/SQL Functions, Procedures and Perl scripts were used for the staging, transformation and loading of the data into the MDW.
- Wrote UNIX shell programming to do file handling and to run the mappings using process flow.
- Interacted with Business Analyst to understand the business requirements and data models.
- Conducted gap analysis on the client data and MDW data.
- Designed Audit process and error handling process for ETL process.
- Wrote PLSQL procedures for complex calculations, error tracking and called in the mappings.
- Setting standards and templates for the ETL process.
- Optimized Queries for performance tuning.
- Tuned and optimized the tables by partitioning, parallelizing for loading and reporting.
- MDW: Products, Calendar Time, Geography, Organization, SKU, Brand, Brand Owner against Pepsi Measures.
- Environment: Oracle9i/10g, AIX 4.3, TOAD, Shell Scripting, Perl, Informatica ETL, Informatica Power Center6.2/7.2, Business Objects6.5, Oracle Sales Analyzer 11i, Oracle Express Server 6.3.4
Oracle Developer /Analyst
Citibank
NY
02.2011 - 12.2012
- Involved in design, requirements analysis, gathering system information, testing, and implementation for the CitiSolve work flow investigation project.
- Involved in Data Conversion from DB2 Mainframe to Oracle.
- Migrated data between different Oracle instances and refreshed databases using Oracle export/import utilities.
- Created, backup, cloned and restored the databases using Oracle utilities like Export and Import and Operating System backup tools.
- UNIX shell scripts were written to stage, split and parse the data from Citisolve COB files obtained through call center on daily basis.
- Responsible for logical/physical database implementation, capacity planning for production rollout, and performance tuning of the application and SQL tuning.
- Involved in legacy data conversion from old Case Venice System to the current Work Flow Investigation system.
- Participated in the Data Modeling and Database Design.
- Involved in the full life cycle of the Project (SDLC).
- Generated planning matrix for the rollout of the application automated scripts to handle DBA tasks of rebuilding indexes, computing statistics for application tables, checking for the chaining/migration of tables and extent growth for tables.
- Oracle Advanced Message Queuing was used for uploading, posting and case closures.
- Involved in performance and SQL tuning.
- Monitored database objects stored procedures, triggers, tables, indexes, views etc.
- Analyzed tables and indexes for performance tuning.
- Wrote scripts to process and feed the data into the staging area and from staging area into the production Master and Detail tables.
- Optimized the design, loading and analysis process through tuning
- Used hints like Parallel and Hash, besides Partitioning, for optimal pruning of the data.
- Prepared the Acceptance Test and feedback and implementing Change Control Management.
- Responsible for data quality checks and maintenance.
- Worked with .Net developer to debug oracle procedures for performance and unit testing.
- Involved in Conversion of Vendor Accounts Data, Demographics and List management Data from Sybase Server into target Oracle9i Database.
- Environment: Oracle9i/10g, AIX 4.3, TOAD, VB.net
Education
Master of Science - Engineering
City University of New York (CUNY)
NYAccounting
LAGCC, CUNY
NYSkills
- Languages/Development tools: ETL Tools (Informatica62/70), Informatica workflow manager, SQL, PL/SQL, T-SQL, ERWIN, Shell Programming, VBA scripting, Business Objects, Shell Scripting, Qlik View, Qlik Sense, NPrinting, Azure Databricks, PySpark, SparkSQL, Cron-tab, Control-M, DB2 Mainframe Cobol, Erwin, Golen Gate Replication, Informatica, PowerPoint, Azure Data Factory, Databricks
- Databases: Oracle8i/9i/10g/12c/19c/21c, SQL Server 2016/2017/2019/2022/2025, Access, DB2 Mainframe Cobol
- Cloud Orchestration: Azure Data Factory (ADF), Azure DevOps (CI/CD), ARM Templates, Azure Databricks
- Cloud Security & Storage: Azure Key Vault, ADLS Gen2, Azure Blob Storage, Managed Identities
Personal Information
Nationality: US Citizen
Timeline
Technical Lead/Developer/Analyst
Claritev (formerly Multiplan)
01.2015 - Current
Developer/Analyst
John Wiley
01.2014 - 12.2014
Developer/Analyst
PepsiCo
01.2013 - 12.2013
Oracle Developer /Analyst
Citibank
02.2011 - 12.2012
Master of Science - Engineering
City University of New York (CUNY)
Accounting
LAGCC, CUNY