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 -