Summary
Overview
Work History
Education
Skills
Certification
Languages
Websites
Affiliations
Timeline
Generic

kiran kumar pendyala

Harrisburg,NC

Summary

Actively participate in business meetings and document the project related documents. Actively involve in the project management meetings and understand the business requirements of the client. Experience in all phases of project development including requirements gathering and analysis as well as project design, development, implementation, and deployment. Mentor the business users and end users for the project management related requirements and responsibilities. Utilize the experience in using enterprise-wide requirements definition and management systems and methodologies required. Co-ordinate with the team members on daily basis for project management related documents and requirements. To obtain a challenging and growth-oriented career utilizing my technical skills and experience in System analysis, design, and development of Enterprise Data Warehouse. Excellent knowledge of data modeling - dimension modeling Star schema, Snowflake schema designs with expertise in using ETL and other Development tools (Datastage, Business Objects). Automation Architect builds the RPA project using the RPA tooling. Provides architectural solutions to the RPA engineers. Participate in architecture and deployment of new features for the RPA tool Team oriented individual with a result driven attitude, strong interpersonal and communication skills in effective information exchange and interaction with clients at all levels of management and getting Sign off from users by doing Users Acceptance testing (UAT). Highly motivated and hardworking individual with the capacity to take on multiple assignments and complete them in a timely and efficient manner under minimum supervision. A team player with strong management, communication skills and computer skills gained through work experience and academic training.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Senior ETL Developer

AMKO SOFTWARE SOLUTIONS INC
Charlotte, NC
04.2014 - Current
  • Develop software deliverable for the Customer Data Solutions (CDS) Project - (Code and unit test);
  • Develop approach for coding – review, analyze and collaborate with business analyst and development teams to fully understand requirement
  • Collaborate with development team on data approach for coding – Understand data guidelines, and understand data sources available, what is new based on requirements, and how the project will impact common data stores
  • Collaborate with core team, Project Management, Quality Assurance, Security, and other cross functional teams to provide the appropriate solution
  • Develop, Design and Analysis of Database, Business Intelligence Solutions including SQL Scripts, Database objects, ETL Frameworks, data conversion and reporting
  • Extensively used Azure Synapse Database using SQL for data validations
  • Developed, Validated, and generated Data Reports using Tableau Reporting tool
  • Automated the ETL test scripts using Query Surge and DBfit tools
  • Extensively used Hive and Impala for Data Analysis and Data Integrity checks
  • Extensively worked on migration project from Hadoop to Azure for both Javelina and Health Pack Data sources
  • Developed and automated the scheduled load processes using Autosys Scheduling tool
  • Extensively used DataStage Designer to develop various Parallel jobs to extract, cleanse, transform, integrate and load data into Enterprise Datawarehouse
  • Developed Job Sequences to run Staging load, EDW Load, Data Mart load and make sure the target tables as per the mapping rules and transformations
  • Extensively used Blue Prism process Studio and Object Studio to develop and test the Bots based on given process model
  • Extensive Experience in managing robot workloads using Blue Prism work queues
  • Working closely with development team to resolve issues being agile
  • Responsible for handling the most complex quality assurance and test environment problems and issues
  • Working as a lead in the creation, preparation, and conduct of quality assurance reviews and the development and execution of test plans and test scripts
  • Works with client to establish and maintain a consistent test methodology and to resolve questions during the testing process
  • Involved in RPA Life cycle by Analysis, Bot Development, Testing, Deployment and Maintenance
  • Designed and implemented RPA tasks using Blue Prism framework
  • Extensively used Blue Prism process studio and object studio to test the robot based on given business process model
  • Hands on experience in managing robot workloads using Blue Prism Work Queues
  • Developed and Tested the Bots as per the Business requirements
  • Validated the data in Microfocus Service Platform in 708 and 936 clients
  • Automate processes using RPA technology and manage robot’s workloads using Blue Prism work queues
  • Worked on creating the scheduler in the Blue Prism
  • Analyzes, tests, and certifies application-specific software and performs ambiguity reviews of business requirements and functional specification documents
  • Uses advanced knowledge of applications to provide technical assistance in identifying, evaluating, and resolving highly complex test problems
  • Research new products and industry methodologies and facilitates the development of new concepts, techniques, and standards
  • Plans and directs quality assurance schedules and assignments, and monitors project status in comparison to cost/time projections
  • Logs, tracks, and verifies resolution of software and specification defects
  • Documents all phases of QA process
  • Directs and serves as a mentor to less experienced staff
  • Involved in writing the test cases and Test plans based on Datastage parallel jobs and Complex Transformations
  • Involved in Manual Testing, Integration Testing, System Testing, UAT Testing, Regression Testing, Functional Testing and Performance Testing
  • Analyzing the Business Requirements Document (BRD), Detail Design Document (DDD), Solution Design Document (SDD) and prepare High level test plans
  • Running the UNIX shell scripts to count the records for EDW Source to Staging Tables
  • Developing DataStage jobs to pull data from various source systems, cleanse, transform and load data into databases
  • Excellent experience in performance tuning of ETL jobs and query optimization of the SQLs

Quality Analyst Engineer

AMKO SOFTWARE SOLUTIONS
Charlotte, NC
03.2013 - 06.2013
  • Participated in gathering the user requirements and involved in writing technical design documents
  • Involved in the analysis, data modeling, detailed system design, development, and technical documentation
  • Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translated business rules and functionality requirements into ETL procedures using Data Stage
  • Extensively used DataStage Designer to develop various jobs to extract, cleanse, transform, integrate, and load data into data warehouse database
  • Designed DataStage Parallel jobs involving complex business logic, update strategies, transformations, filters, lookups, and necessary source-to-target data mappings to load the target
  • Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command
  • Used DataStage Director to Run and Monitor the Jobs for Performance Statistics
  • Implemented logic for Slowly Changing Dimensions Type II by using Date methodology
  • Involved in Performance Tuning of Parallel Jobs using Performance Statistics
  • Extensively worked with database objects including tables, views, indexes, schemas, PL/SQL packages, stored procedures, functions, and triggers
  • Involved in solving Production support issues

Education

Master of Science in Management -

Sullivan University
04.2014

Master of Computer Science -

UNVA
09-2012

BTECH in Electronics & Communications Engineering -

JNTU
05.2007

Skills

  • ETL/RPA Tools
  • IBM Datastage 117
  • Business Objects
  • BLUEPRISM 6
  • MS Word
  • MS PowerPoint
  • MS Excel
  • Windows NT/95/98/2000
  • MS-DOS
  • SQL
  • PL/SQL
  • C
  • C
  • Net Technologies
  • Oracle
  • DB2
  • SQL Server
  • Netezza
  • Tera Data
  • Performance Tuning
  • Team leadership abilities
  • Version control systems
  • ETL Tool Proficiency
  • Data Visualization Techniques
  • Data Modeling Techniques
  • Data Validation
  • Data Security
  • Data Warehousing
  • Databases: Oracle, MongoDB
  • Continuous Integration Systems
  • RDMS Development
  • Software Testing and Validation
  • Project Management
  • Requirements Gathering
  • Software Quality Assurance
  • Project Specifications
  • Effective Communication
  • Project Documentation
  • Testing and deployment

Certification

369046281, 1060247117

Languages

English
Professional
Hindi
Professional
Telugu
Professional

Affiliations

  • Likes to Play Professional and Competitive Cricket and Table tennis games.

Timeline

Senior ETL Developer

AMKO SOFTWARE SOLUTIONS INC
04.2014 - Current

Quality Analyst Engineer

AMKO SOFTWARE SOLUTIONS
03.2013 - 06.2013

Master of Science in Management -

Sullivan University

Master of Computer Science -

UNVA

BTECH in Electronics & Communications Engineering -

JNTU
kiran kumar pendyala