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