SUMMARY:

Alok Padaki is a Senior Business Analyst & ETL - Developer with 8 years of IT experience and with responsibilities spread across different phases of the SDLC. He also have done requirements gathering, Application Development, testing, documentation and Production support.

CORE COMPETENCIES:

• Data Warehousing
• Unix
• Requirements gathering
• ETL- Pentaho
• Oracle 11g, PLSQL
• Requirements Analysis
• ETL- Informatica
• Teradata-12, BTEQ
• Requirements documentation
• Data Integration
• Stored Procedures
• Performance Tuning
• Data Conversion
• Hadoop and HDFS Basics
• Change Management
• Data Analysis
• Team building

TECHNICAL PROFICIENCIES:

• Expertise ETL process & Pentaho.
• Expertise ETL process & Informatica.
• Proficient in writing Complex SQL Queries
• PL/SQL, Unix Shell Scripting
• Oracle, Teradata
• Pentaho Kettle, Informatica Power Center.
• SQL Developer, TOAD, Teradata SQL Assistant 12.
• Performance Tuning, Data Analysis, Data Modelling, Data Profiling
• Excellent written and oral communication skills.
• Extensive Experience SDLC, Agile methodology, Finance, Telecom & Communication and High-tech domain Data Integration & Conversion projects.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Software Engineer- Business Analyst

Responsibilities:

• Requirement gathering for Centralized Regulatory Reports.
• Development of new stories for Regulatory Reporting (FFIEC-009 and FRY 14M)
• Testing the reports on UAT environment with complex SQL Queries involving multiple tables with joins.
• Task estimation and Sprint Planning.
• Design and lead development of test strategy.
• Communicate status to report owners.
• Worked on Data Analysis and Data Validation for multiple reports.
• Testing of Regulatory reports by writing complex queries and documentation of the changes/code fixes that are implemented as per the specifications.
• Created Data Dictionary for FFIEC-031, FFIEC-041 and FRY-14 regulatory reports.
• Provide technical guidance and support for the development and troubleshooting of the application.
• Conducted peer design and code reviews.
• Performance tuning and disaster recovery testing.
• Trained myself on AXIOM and leveraged it to test the Regulatory reports against the traditional reporting system of Confidential .
• Trained a team of 9 to help them understand the entire SDLC process followed in the project.

Confidential

Senior Software Engineer- PLSQL Developer

Responsibilities:

• Requirement gathering from Product team
• Development for new issuer add to 360 control Database, store procedures, functions, tables, views.
• Wrote complex SQL Queries involving multiple tables with joins.
• Task estimation and Sprint Planning.
• Worked on UNIX Shell Scripting.
• Worked on Data Profiling and Data Validation.
• Testing and documentation of the changes/code fixes that are implemented as per change requests. Supported the deployment/release activities.
• Provide technical guidance or support for the development or troubleshooting of applications or systems.
• Provide necessary support to clients in installing and usage of the newer version of application and resolve all issues encountered by clients. (Production Support)
• Conducted peer design and code reviews.
• Performance tuning and disaster recovery testing.

Confidential

Senior Software Engineer- ETL Developer

Responsibilities:

• Requirement gathering from Client, Business Analyst and Data Architect
• Technical design/specifications for data Extraction, Transformation and Loading.
• Defining of the overall ETL framework using Pentaho.
• Design and development of Pentaho Kettle ETL complex mappings/code, store procedures, functions, tables, views, and functions in SQL.
• Wrote complex SQL Queries involving multiple tables with joins.
• Overall ETL environment configuration in cluster mode.
• Integration of the batch scheduler with the ETL flows.
• Defining the physical data models for the DWH.
• In-depth understanding of Data warehousing concepts.
• Developed Technical Specifications of the ETL process flow.
• Task estimates and Sprint Planning.
• Worked on UNIX Shell Scripting.
• Worked on Data Profiling and Data Validation, Data Integration
• Testing and documentation of the changes/code fixes that are implemented as per change requests. Supported the deployment/release activities.
• Created code for capturing, reporting, and correcting error data.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL advanced techniques.
• Performance tuning of the ETL flows.

Confidential

Software Engineer - ETL Developer

Responsibilities:

• Requirement gathering from Client, Business Analyst and Data Architect
• Technical design/specifications for data Extraction, Transformation and Loading.
• Design and development of Pentaho/Informatica complex mappings/code tables and views and Oracle.
• Efficient code for processing fact and dimension tables with complex transformations and SCD type 1 and SCD type 2 changes.
• In-depth understanding of Data warehousing concepts, OLAP, SCDs (type1, type2 and type3).
• Developed Technical Specifications of the ETL process flow.
• Worked on UNIX Shell Scripting.
• Performance tuning of Pentaho/Informatica code (sources, mappings, targets and sessions) and tuning of the SQL queries.
• Testing and documentation of the changes/code fixes that are implemented as per change requests. Supported the deployment/release activities.
• Developed Parallel Processing flows to increase Performance throughput.
• Created code for capturing error data in tables for further analysis.
• Sprint meetings with Clients to update the progress of the on-going code level activities or any enhancements.
• Conducted peer design and code reviews.

Confidential

Associate Software Engineer - Teradata Developer

Responsibilities:

• Requirement gathering
• Technical design/specifications for data Extraction, Transformation and Loading.
• Developed scripts that loaded tables with different business logics using Teradata BTEQ, FAST LOAD, MULTI LOAD and other Teradata utilities and UNIX and Datastage ETL.
• Owned development of modules from end-to- end which involved scripting Teradata quires to scheduling of those scripts to load the tables and analyzing the data for end users.
• Worked on fixing the defects which needed lots of delicate code handling.
• Involved in performance Tuning post live.
• Worked on CONTROL M which involved scheduling the scripts developed and setting up the dependencies according to the business requirements.
• Generating the Control-M XML and deploying it in the various environments.