***** ***** **.,

Wharton -*****

Email id: -ad453r@r.postjobfree.com

US Cell: +1-973-***-****

US Home : +1-973-***-****

Ashok Panwar

Data Architect Data analyst Data engineer Oracle PL/SQL Unix/Python specialist

Over 20 years of hands-on experience in Oracle PL/SQL, IBM DB2, Postgres, Unix shell scripting, IBM DataStage (ETL tool), IBM Cognos Analytics, Tableau, Power BI, Oracle forms 9i, Oracle reports 9i, Apache Cassandra, Data Warehouse/data lake, Data Modeling/data architecture, Performance tuning, Denodo (Data virtualization, Python, Pyspark, AWS Redshift, AWS Glue, Apache airflow, AutoSys and S3.

Professional Summary: A highly accomplished data professional with over two decades of expertise in leading, architecting and implementing robust data solutions across diverse platforms and domains. Proficient in a wide range of technologies including Oracle PL/SQL, IBM DB2, Postgres, and IBM DataStage. Proficient in leveraging visualization /virtualization tools such as Tableau, Cognos, Power BI and Denodo to extract actionable insights from complex datasets. Experienced in data modeling (relational/non-relational databases), ETL processes (build databases in Postgres/Apache Cassandra), and data warehousing/data lake/data lake house architecture. Proficient in scripting languages like Unix Shell and Python for automation and efficient data processing. Proficient in using scheduling tools like Autosys/Apache airflow. Strong background in cloud technologies, particularly AWS Glue, redshift and S3, for scalable and cost-effective data management solutions. Wrangling, filtering, and transforming distributed data with pyspark and spark SQL.

Key Skills:

Oracle PL/SQL

IBM DB2

Postgres

IBM DataStage

IBM Cognos Analytics

Tableau

Power BI

Denodo

Oracle forms 9i

Oracle reports 9i

Apache Cassandra

Data Warehouse/data lake/data lake house architecture

Data Modeling

Unix Shell Scripting

Python

Pyspark

Redshift

AWS Glue

Autosys/airflow/CloudWatch

Athena

Dat modeling tools- Erwin/IBM rational rose

Version control- SVN, TFS, VSS, ALM

Web technology- JSON/XML

Other tools- JIRA, Amplify, Jenkins, TFS

Processes / Methodologies: Agile, SCRUM, SDLC process, Application lifecycle Management Services (ALM), Root Cause Analysis (RCA), IBM Metrics tool, Application Management Services Transition/Transformation Methodology.

Professional Experience:

IBM

Role: Data delivery manager/Senior data engineer/Senior data analyst/Data architect

Client- Prudential Financial (Group Insurance and Retirement services) / Empower

Years of service: 12.7 years and current (Sep,2011. till date)

Led the design and implementation of complex ETL pipelines using IBM DataStage, ensuring efficient data extraction, transformation, and loading processes.

Optimized db2 script, Oracle PL/SQL scripts for performance and scalability, resulting in significant improvements in data processing speed and resource utilization.

Built ETL pipeline that extracts data from S3, stages in Redshift, and transform data into a set of dimensional tables for an analytical team.

Worked with sensor data that trains ML model. Load S3 JSON data from a data lake into Athena using Spark and AWS Glue.

Created and automated a set of data pipeline with airflow.

Architected and maintained data warehouse solutions, integrating diverse data sources to provide a unified view for reporting and analytics.

Utilized Tableau, Cognos and Power BI to create visually compelling dashboards and reports, empowering stakeholders with actionable insights.

Designed and implemented data models for various applications, ensuring data integrity, consistency, and performance.

Developed and maintained automated data pipelines using Python, Pyspark, and Unix Shell scripting, streamlining data processing workflows.

Designed, implemented, and maintained complex data pipelines using Autosys and Apache Airflow, ensuring smooth execution of ETL processes.

Deployed and managed data solutions on AWS cloud platform, leveraging services like AWS Glue and S3 for scalable and cost-effective data management.

Collaborated with cross-functional teams to define data requirements and develop strategies for data governance and compliance.

Conducted thorough data analysis to identify trends, anomalies, and opportunities for process improvement.

Played a key role in the implementation of Apache Cassandra for real-time data processing, enhancing the organization's ability to handle large volumes of data with low latency.

Led the migration of legacy data systems to modern platforms, facilitating seamless integration and improved data accessibility.

Led migration projects to migrate huge amount of data from onprem to cloud using schema convertor, AWS DMS.

Led migration projects to migrate data from legacy systems using IBM data stage, Unix via parallel processing of ETL jobs.

Collaborated with cross-functional teams to define data requirements and design scalable data models for diverse business needs.

Mentored junior team members in best practices for database development, data modeling, and ETL workflows.

Conducted regular performance evaluations and provided mentorship to team members to foster professional growth and development.

Worked closely with stakeholders to gather requirements and define project scope for data engineering initiatives.

Wipro Infotech

Role: Oracle DB/Form9i lead / Module lead /Data analyst/ Data architect

Client: EICI and Genpact

Years of service: 4.3 years (Jun,2007. Sep,2011)

Led the design and implementation of customized application built on oracle form 9i, report 9i, oracle database.

Requirement Analysis, Preparing Business specification Requirements, SRS, HLD, LLD

DB designing using ER-Win and Microsoft Visio

Worked on procedure, Function, Packages, Trigger, Types, Cursor, materialized View

analytical functions, performance tuning,

Worked on oracle forms 9i and reports 9i

Worked on Unix shell scripting and SQL loader utility.

Led migration projects to migrate data from db2 to Postgres

Utilized Tableau, Cognos and Power BI to create visually compelling dashboards and reports, empowering stakeholders with actionable insights.

Designed and implemented data models for various applications, ensuring data integrity, consistency, and performance.

Performance tuning using indexes, materialized views, hints, partitioning, explain plans, TKproof utilities.

Database admin activities like export and import, backup of oracle DB, partitioning

Owner for complete database Modification and changes.

Deployed completed application on Production Server

Working on mail module, billing module, Accrual module, Scheduling of jobs, data

migration

Leading big team and technical mentoring of team and Project with respect to all the

Database related issues

Techbooks/Aptara Inc.

Role: Senior software engineer

Client: Inhouse development

Years of service: 9 months (Oct,2006. Jun,2007)

Led the design and implementation of customized application built on oracle form, oracle reports, oracle database.

Requirement Analysis, Preparing Business specification Requirements, SRS, HLD, LLD

Production Support

Customization of forms/reports and modifying packages/procedures/db. objects on change request

Implementing new modules using oracle pl/SQL on demand and Unix shell scripting

Generating reports using Cognos and oracle reports 9i

Technical mentoring of team and Project with respect to all the Database related issues

Design, Code, UTC Reviews for the developed modules.

Deployment and Execution plan for the Development, UAT and Production environment

Nucleus Software Exports Ltd. Infotech

Role: Software Engineer

Client: In house product -> Cash@will (Core banking product)

Years of service: 9 months (Mar,2005. .Nov,2005)

Project Description

Working in cash@will(Finnone) FinnOne™ (Complete Banking): The flagship product of Nucleus

is an integrated suite of applications designed to support the business offerings of banks and

financial services companies.

Project Responsibilities

Creating forms and reports using d2k

Oracle SQL

Oracle pl/SQL coding

Unix shell scripting

Reports and data visualization using oracle reports 9i

Unit testing/performance tuning

Source control using VSS

SQL Star International Ltd.

Role: Software Engineer

Client: Delhi Development Authority

Years of Experience: 1 year(Apr 20024, Feb 2005)

Project Description

Housing Management Information System (HMIS)

This project is basically a facility management Project. It includes 8 modules- Registration, Master maintenance, Allotted Payment Maintenance, Draw Of lots, Queries Demand Letter Maintenance, Post Allotment and Compactor module.

Registration of applicants is done through Registration module.

Major draws of flats are done through draw of lots, module.

After performing draws, demand letter generation and post allotment activities are performed.

All receipts and payments of allottees are handled through allottee payment maintenance module.

Frequent queries of users are handled through queries module.

Project Responsibilities

Facility Management and Support using oracle forms and oracle reports.

Customization of oracle forms/reports and modifying packages/procedures/db objects on change request, oracle pl/sql

Implementing new modules using oracle pl/sql on demand

Technical mentoring of team and Project with respect to all the Database related issues

Design, Code, UTC Reviews for the developed modules.

Deployment and Execution plan for the Development, UAT and Production environment

Involved in unit cases, DB designing using ration rose and Microsoft Visio

Performance tuning

Technical mentoring of team and Project with respect to all the Database related issues

Education:

B.Com. (Bachelor of Commerce) from Delhi University, Delhi, India.

Post graduate in Information Systems Management from All India Management Association, Delhi, India

Certifications:

Oracle Certified Analyst (OCA)

AWS Certified Cloud Practitioner

AWS Certified Associate Architect

Certified Scrum master/ SAFe (Scaled Agile framework)

Tableau Desktop Certified Professional

Training:

Oracle sql

Oracle pl/sql

Oracle forms

Oracle reports

Oracle DBA

DB2

Sybase

Unix shell scripting and admin

Denodo data virtualization

Post man API testing

Post man concurrent user testing on API

JSON request/response

Informatica power center

Competing Against Amazon Web Services (AWS)

Hadoop training

Introduction to Java and Spring boot service.

Introduction to data warehousing

Oracle DB architecture

2020 Business Conduct Guidelines Program

Insurance industry foundation

IBM mentor training

IBM recognized teacher/educator

2019 Annual Cybersecurity Education (Day in the life)

Security and Privacy for Developers 101

Securing Secrets (Enterprise & Technology Security)

Test Your Knowledge (Enterprise & Technology Security)

FAQs (Enterprise & Technology Security)

Links & Tools (Enterprise & Technology Security)

Introduction (Enterprise & Technology Security)

Introduction to Security & Privacy by Design (SPbD) @ IBM (Enterprise & Technology Security)

AppSec Fundamentals - Secure Software Development

AppSec Fundamentals - Audit and Compliance

AppSec Fundamentals - Application Security Services

AppSec Fundamentals - Security Aspects of Other Domains

AppSec Fundamentals - Industry History

AppSec Fundamentals - Introduction

Required Training for All Roles

JTC - Red Hat (IBM Journey to Cloud)

Wrap-up (IBM Journey to Cloud - Red Hat)

Red Hat Portfolio Alignment (IBM Journey to Cloud - Red Hat)

Red Hat Portfolio At-a-Glance (IBM Journey to Cloud - Red Hat)

Red Hat Overview (IBM Journey to Cloud - Red Hat)

JTC - Solution Core (IBM Journey to Cloud)

Wrap-up (IBM Journey to Cloud - Solution Core)

IBM Solution Focus: IBM Cloud Private on Systems (IBM Journey to Cloud - Solution Core)

IBM Solution Focus: IBM Cloud (IBM Journey to Cloud - Solution Core)

Managing It All (IBM Journey to Cloud - Solution Core)

Design, Develop, Deliver, Done: A DevOps Primer (IBM Journey to Cloud - Solution Core)

Matching the Right App to the Right Cloud (IBM Journey to Cloud - Solution Core)

The Microservices "Macro" (IBM Journey to Cloud - Solution Core)

The World of Kubernetes (IBM Journey to Cloud - Solution Core)

The World of Containers (IBM Journey to Cloud - Solution Core)

Learn About Linux (IBM Journey to Cloud - Solution Core)

Cloud Infrastructure (IBM Journey to Cloud - Solution Core)

Introduction to Solution Core (IBM Journey to Cloud - Solution Core)

JTC - Solution Value (IBM Journey to Cloud)

Wrap-up (IBM Journey to Cloud - IBM Journey to Cloud - Solution Value)

Client Stories (IBM Journey to Cloud - IBM Journey to Cloud - Solution Value)

Competitive Landscape (IBM Journey to Cloud - IBM Journey to Cloud - Solution Value)

IBM and Red Hat: A Winning Combination (IBM Journey to Cloud - Solution Value and Red Hat (shared activity))

IBM's Multicloud Offerings (IBM Journey to Cloud - IBM Journey to Cloud - Solution Value)

IBM's Multicloud Capabilities (IBM Journey to Cloud - IBM Journey to Cloud - Solution Value)

IBM's Cloud Approach (IBM Journey to Cloud - IBM Journey to Cloud - Solution Value)

Application Modernization (IBM Journey to Cloud - IBM Journey to Cloud - Solution Value)

IBM Cloud Point of View (IBM Journey to Cloud - IBM Journey to Cloud - Solution Value)

IBM Cloud Value Proposition: Simply Put (IBM Journey to Cloud - IBM Journey to Cloud - Solution Value)

Drivers of Cloud (IBM Journey to Cloud - IBM Journey to Cloud - Solution Value)

Introduction to Solution Value (IBM Journey to Cloud - IBM Journey to Cloud - Solution Value)

JTC - 14 in 4 (IBM Journey to Cloud)

Wrap-up (IBM Journey to Cloud - Journey to Cloud 14 in 4)

Cloud Engagement Hub (IBM Journey to Cloud - Journey to Cloud 14 in 4)

IBM Garage Method for Cloud (IBM Journey to Cloud - Journey to Cloud 14 in 4)

Multicloud Management (IBM Journey to Cloud - Journey to Cloud 14 in 4)

Private/Public Cloud and Integration (IBM Journey to Cloud - Journey to Cloud 14 in 4)

Modernize Legacy Enterprise Infrastructure (IBM Journey to Cloud - Journey to Cloud 14 in 4)

Advise, Move, Build and Manage: Step by Step (IBM Journey to Cloud - Journey to Cloud 14 in 4)

Manage on Cloud (IBM Journey to Cloud - Journey to Cloud 14 in 4)

Build for Cloud (IBM Journey to Cloud - Journey to Cloud 14 in 4)

Move to Cloud (IBM Journey to Cloud - Journey to Cloud 14 in 4)

Advise on Cloud (IBM Journey to Cloud - Journey to Cloud 14 in 4)

Introduction to 14 in 4 (IBM Journey to Cloud - Journey to Cloud 14 in 4)

Message from Tia Silas, VP Global Chief Diversity & Inclusion Officer

Crossing the line: workplace bullying prevention (Workplace Training)

Take our short survey. (Workplace Training)

Show what you know! (Workplace Training)

Consequences, guidance: (Workplace Training)

Be an upstander. (Workplace Training)

I think I'm being bullied. (Workplace Training)

I think I witnessed bullying. (Workplace Training)

Others might think I'm a bully. (Workplace Training)

Costs of bullying behavior in the workplace (Workplace Training)

Can you identify it? (Workplace Training - Crossing the Line: Bullying Behavior (English))

What bullying behavior is and what it is not (Workplace Training)

Sexual Harassment Prevention for Employees: Global Training

IBM's Journey to Cloud

CMMI V2.0 In Practice

2019 Business Conduct Guidelines Program

Contact this candidate