SUMMARY

• Adept IT Professional with solid 19+ years of experience in Financial & Retail sectors.
• Data Architect with solid experience in architecting the complete Data Warehouse lifecycle and delivering (E)xtract, (T)ransform & (L)oad and Business Intelligence solutions to data warehousing applications.
• Built Logical and Physical data models using ERWIN and Power Designer.
• Implemented Star schemas using Ralph Kimball's Dimensional Modeling methodology and Snowflake schemas.
• Designed and developed ETL components using Informatica PowerCenter 10.2 and Pentaho Data Integration 8.0.
• Implement Associative Data Modeling using Qlikview 12 and code scripts for ETL data processing.
• Built rich visualizations using Qlikview 12 and created dashboards using components List like Boxes, Multi Boxes and different chart types like Gauges, Pie, Bar, Combo, Line, Heat Maps, Scatter etc.
• Involved in Data Analysis and defined the Key Performance Indicators (KPI) using Qlikview.
• Expert Programming skills in Oracle database 19c PL/SQL to write program units and create database objects. implemented Database partitioning schemes on Huge Fact Tables.
• Identified performance bottlenecks on both the ETL & the database layers and implemented various optimization techniques for performance tuning.
• Designed and developed Interactive Dashboards using Tableau 2019/2018 working with different Chart Types like Gantt, Bubble, Bump, Motion, Waterfall, Scatter & Box Plots, Histograms etc.
• Created Stories using Tableau Desktop by integrating multiple dashboards together.
• Scheduled ETL workflows using Control - M 9.0 workload automation.
• Built User Interfaces using Oracle Forms and Reports 10g.
• Self-motivated, strives for excellence in software development and delivery with strong communication skills, fostering relationships and active participation in process improvement.
• Adhered to Agile methodology development practices to deliver technical solutions to the business.
• Managed onsite and offshore teams and committed to productivity towards deliverables.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.2, Pentaho Data Integration 8.0

BI/Visualization Tools: Qlikview 12/11, Tableau 2019/2018

Data Modeling Tools: ERWIN Data Modeler 2019, SAP Power Designer 16.5

Relational Databases: Oracle Database 19c, SQL Server 2012, MySQL 8.0

Front End Tools: Oracle Developer 6i/9i/10g (Forms & Reports), Visual Basic 6.0

Web Technologies: HTML, CSS, XML

Client-Side Scripting: JavaScript, VB Script

Programming Languages: C, C++, Java 8.0, Python 3.7

Scheduling Tools: Control-M workload Automation 9.0, Unix/Linux Crontab.

Version Control: Git, Rational Clearcase 7, PVCS 8.2

Team Collaboration Tools: Atlassian Jira, Bitbucket & Confluence

Other Tools: TOAD 12, PL/SQL Developer 9.0, SQL Developer 4.2

PROFESSIONAL EXPERIENCE

Confidential

Application Developer Lead/Architect

Environment: Informatica Powercenter 10.2, Pentaho DI 8.0, Qlikview 12, Oracle Database 19c, Control-M Workload Automation 9.0 GIT version control on Bitbucket Repository, ERWIN 2019, SAP Power Designer 16.5

Responsibilities:

• Architected the ETL and BI solutions for the Funds Data warehouse.
• Built the Data Architecture with Logical and Physical Data Models using ERWIN and Power Designer.
• Analyzed the development efforts and provide timeline estimates for the delivering the components.
• Split the development work into pieces and delegated to the Team members in an Agile Development environment.
• Architected developed ETL Mappings, Mapplets, Workflows and Worklets using Informatica Powercenter.
• Designed and developed ETL transformations and jobs using Pentaho Data Integration.
• Implemented Star Schemas by applying Ralph Kimball's Dimensional Modeling Techniques.
• Designed and developed Dashboards, Scorecards, KPI and other reports using Qlikview.
• Built rich visualizations with Worksheets, Dashboards and Stories using Tableau.
• Schedule ETLs and shell Scripts using Control-M scheduling tool.
• Performance tuned the Daily and Monthly Batches and ensured data readiness well before the agreed SLAs.
• Implemented Partitioning schemes for huge tables for better query performance for the ETLs and reports accessing them.
• Developed a generic module using Oracle PL/SQL for Data Archival, Purging routines, logging and other database utilities.
• Continuous Integration (CI) and Continuous Delivery (CD) for ETL and DB components using Jenkins.
• POCs for visualizations using Tableau and Qlikview and choose the right tool for the application.
• Worked with the business during User Acceptance Testing and obtain UAT sign-off.
• Lead the DevOps Team to stabilize the data warehouse and reduced the Production calls received the from business.

Confidential

Environment: Oracle Database 11g (with RAC), Task Orchestration (Internal Scheduling tool), Rational Clear Case 7 Red Hat Enterprise Linux AS release 4

Responsibilities:

• Understood the requirements and preparing technical specification documents.
• Implemented a generic PL/SQL module using Oracle Dynamic SQL that generates SQL extracts for different consuming applications based on the data points selected on the Reference Data Visualization GUI.
• Tuned the application for performance using the Oracle supplied tools like Explain Plan, TK-Prof etc.
• Implemented and adhered to the Coding standards for the PL/SQL program units developed.
• Ensured on-time, quality release of application components.
• Performed weekly On-call rotation for support coverage.

Confidential

Application Designer Developer

Environment: Oracle Database 10g, Oracle Developer 10g (Forms & Reports), Oracle 10g AS, UNIX Itanium & Shell Scripting.

Responsibilities:

• Lead the Development efforts of various international store openings and operation optimization initiatives.
• Created Database Objects and writing PL/SQL program units including packages, procedures, functions and Triggers etc.
• Designed and Developed User Interface using Oracle Forms and Oracle Reports.
• Oracle XDB package for parsing and processing XML documents.
• Scheduled jobs using Oracle Scheduler and UNIX crontab.
• Performance Tuning the application using Oracle tools like Automatic Workload Repository (AWR).
• On Call Production Support on a rotation basis.

Confidential

Senior Software Engineer (Oracle Consultant)

Environment: Oracle Database 10g, Oracle Developer 6i (Forms & Reports) Oracle 9i AS, Unix, Oracle Retek, PVCS 8.2

Responsibilities:

• Bulk Data Load using Oracle SQL Loader and External Tables.
• Created Database Objects Packages, procedures, functions and Triggers in Oracle PL/SQL.
• Developed Graphical User Interfaces (GUI) Oracle Forms and Oracle Reports.
• Worked on the Various Oracle Forms Triggers, Canvases, LOVs, Menus, Object libraries, Object groups, PL/SQL Libraries etc.
• Wrote Shell scripts and scheduled jobs on UNIX crontab.
• Performance tuning using TK-Prof, SQL Trace and Explain Plan.

Confidential

IT Analyst

Environment: Oracle Database 9i, Unix, Express Options for Windows (EOWIN), PVCS 7.0

Responsibilities:

• Developed Oracle PL/SQL program units like stored Procedures/Functions/Packages/Triggers.
• Creating, scheduling batch programs using UNIX Crontab and writing Shell Scripts.
• Production Data Refresh to UAT and Development Environments with Data Copy scripts.
• Writing Technical Requirement specifications.
• Performed Unit Testing and System Integration Testing.
• Worked in Production Support for the existing application and identifying issue and implemented Code fixes.

Confidential

Application Developer

Environment: Oracle Database 9i, Oracle Developer 6i (Forms & Reports), Java Swing, Unix, PVCS 7.0

Responsibilities:

• Built user Interfaces using Oracle Developer 6i (Forms and Reports).
• Created several PL/SQL stored Procedures/Functions/Packages/Triggers.
• Performance Tuning using TK-PROF and Explain Plan.
• Created Tables, Views, and Synonyms, Indexes, Sequence and other Database Objects.
• Writing Shell Scripts and scheduling jobs through UNIX Crontab.
• Performing Unit Testing as well as System Integration Testing.
• Effective Version Control of the existing code through PVCS.