We provide IT Staff Augmentation Services!

Senior Software Engineer- Business Analyst Resume

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.

Hire Now