Production Support Scrum Master
Resume:
Vijay K Byagari - ETL Lead/Developer
(U S Citizen)
ad5qsr@r.postjobfree.com
www.linkedin.com/in/vijay-byagari-265954129
Summary
Over 12+ Years of experience in the field of Data warehousing as a Lead/Developer/Analyst/Tester with expertise in the ETL
Administering, analysis, data modeling, design, development, testing, deployment, and production support solutions (ETL, Data Mart, Data Warehouse, ODS) in OLTP technologies using star and snowflake dimensional modeling.
Hands on experience on various ETL tools including DataStage, Informatica (IICS) cloud.
Roles – Successfully accomplished various roles as ETL Lead, Scrum Master, Production support, Developer, Tester, and technical writer.
Detail oriented with good problem solving, organizational, analysis, highly motivated and adaptive with the ability to learn quickly.
Managed end to end complex data migration, conversion, integration, and data modelling (using Alteryx, SQL), and created visualization using tableau to develop high quality dashboards.
Working Knowledge on different data sources as Flat Files, Oracle, DB2, Hadoop, Teradata, Netezza, SQL Server, XML and Excel.
Experience on cloud databases and data warehouses (SQL Azure, Redshift).
Expertise in administering, development and designing of ETL methodology for supporting data transformations.
Experience in developing test plans, test cases, test scripts, and test validation data sets for Data Mart, Data Warehouse, and ETL systems
Expertise in implementing complex Business rules by creating robust mappings, mapplets, and reusable data transformations using Informatica Power Center and IICS.
Involved in Data Analysis, Data Validation, Data Cleansing, Data Verification using complex SQL on various source systems
Experience in Scheduling jobs using Control – M and Autosys.
Developed High- and low-level technical design specification and Mapping documents.
Versatility in production support, data load performance tuning, test data management, and enhancement specific.
Worked closely with Technology Infrastructure Teams, Development & Testing Teams in supporting Integrated / Independent releases, software/hardware upgrades, server upgrades etc
Experience in deployment processes, post-deployment support, and hand over product support.
Strong experience in documenting existing process, analyzing business requirements and designing to the state process documents and also working with the Quality Team.
Worked in both waterfall and agile methodology
Professional Skills
Certifications
Scrum SMC, Fundamentals of Azure & AWS. Tableau, Power BI.
ETL Tools
DataStage, Informatica, IICS, Talend, SSIS, SSRS, Abinitio, Tableau, Tableau Prep, Power BI, AlterYX, Control-M, Autosys
Database
Oracle, Netezza, SQL Server 2008/2012, DB2, Teradata, Sybase, My SQL, MS Access, Snowflake, Redshift, MemSql, and Hadoop.
Tools
HP ALM, Oracle Developer, Toad, Erwin, Remedy, HP service desk, Quality Center, Rally, Service Now, AzureDevops, Git hub, and JIRA, Visio
Languages
SQL, LINUX/ UNIX shell scripts.
Professional Experience
Waste Management: Feb 23 – Till date
Informatica Lead / Data Engineer (Infosys)
Project: RFP for Enterprise Analytics & Data Management digital services support.
Key Responsibilities:
•Conduct a thorough Discovery on all existing EADM Applications and Services (140)
•Understand existing support process and identify opportunity for process harmonization.
•Validated/refined scope & assumptions, identify key pain areas.
•Identified gaps in ITSM and provide action plan to populate ServiceNow Product Catalog
•Identified and categorized the various applications / services complexity in terms of business and technologies.
•Performed trouble shooting, analysis, research and resolution using advanced query and programming skills and conducted root cause analysis.
•Rationalize all EADM Support capability into an efficient outsourcing model.
•Proposed value-added tools driving EADM support to state-of-the-art automation (Dashboard Bot, self-service. etc.).
•Developed and did code review on the data transformations using ETL tools-DataStage/Informatica.
•Created Azure & AWS instances as and when needed.
•Performed data profiling activities to provide statistics and informative summaries by writing complex SQL queries using SQL developer against Oracle database.
•Defined solution approach, delivery model, Transition plan and commercials for the Proposal.
Huntington Ingalls: (Federal Project – Security Clearance passed).
ETL Informatica LEAD (Infosys) Aug 22– Dec 2022
HII (formerly Huntington Ingalls Industries, Inc.) is the largest military shipbuilding company in the United States as well as a provider of professional services to partners in government and industry.
Project: Migration from MARS to IFS system.
Key Responsibilities:
•Architected & strategically planned to migrate 160+ extracts from MARS to IFS system by using IICS tool.
•Developed Informatica cloud mappings and integrated App & API using IICS.
•Mentored the client on creating mapping documents from sources (Oracle, flat files) to target tables (SQL Server).
•Lead a team of 8 guided them in mapping appropriately from different source to target tables, data transformations ETL jobs, and creation of objects in SQL server.
•Peer reviewed the mapping documents, build, and testing.
•Implemented data governance strategy by developing an enterprise wide MDM system to provide consistency across 160+ systems.
•Communicated with line of business and management the overall status and health of the application.
•Reported to the client 2 x day on the status of the activities/ project deliverables.
•Performed 400+ data profiling activities to provide statistics and informative summaries by writing complex SQL queries using SQL developer against Oracle database.
•Designed and developed ETL workflows and datasets in Alteryx to be used in-reporting.
Northern Trust: May 21 – July 2022
ETL Lead / Developer (Infosys)
Project: Integration of applications such as RSD/KYC/Actimize solution in the AML department.
Key Responsibilities:
•Coordinated with client to streamline the SOW, formulated the requirements, and categorized the requirements into different phases.
•Lead a team of 5 and assigned various activities so that the milestones of the project are met.
•Created the architectural diagram for the future state, and got it signed off by the client.
•Guided & coordinated with client and offshore team as to which logic to be used to create mapping documents based off requirements.
•Guided the client while reviewing the mapping documents and got the mapping documents signed off.
•Created HLD, DTD, & DRD documents, went through few iterations with client to get the documents signed off.
•Scheduled daily meetings with client and with offshore team for various activities such as for reviews and status calls.
•Wrote complex SQL queries using joins, sub queries, and various conditions to perform data analysis for data extraction and management discussion.
•Guided other development team members in understanding the business functionalities so that coding is done correctly.
•Reviewed and corrected the data transformation of ETL code other team members.
•Involved in the performance tuning of DataStage jobs.
Bank of America: Mar 20–Mar 2021
Lead Consultant / Analyst (Infosys)
Key Responsibilities:
•Planned, lead, and designed ETL jobs for migrating / Replicating / synchronizing data between DB2 and Memsql using ETL tools.
•Reviewed ETL code, and created Autosys scripts / evaluated data through testing.
•Data profiling / analysis based on the requirement and due to issues.
•Created views and stored procedure as when need during validation.
•Involved in the performance tuning of DataStage jobs.
•Meticulously developed and implemented data governance strategies to ensure accuracy, consistency and completeness of organizational data; reduced errors in reports by 30%.
•Wrote complex SQL queries to perform data profiling and for management discussion.
•Created / reviewed migration documents for deployment in various environments.
•Interacted with client on daily basis in regards project and coordinated with offshore team to get task completed.
Mr. Cooper: July 19–Dec 2019
Lead Consultant / Analyst (Infosys)
Key Responsibilities:
•Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing for a migration project.
•Planned, lead, and guided both the client and offshore team to do migration of Data from Netezza DB to SQl Server DB
•Planned, executed the tested parallel the CDC and Attunity replication process.
•Wrote complex queries for data profiling, analysis, and for comparing Source and Target table data from Netezza to SQL server
•Planned, executed and tested the ETL Jobs to validate data in OnPrem SQL to Azure DB.
•Involved in the creation of stored procedures using T-SQL according to the requirement.
•Worked with DBA team, did Inventory of tables in SQL server, and assessed which tables needed for the project.
•Worked with IDQ for data cleansing, data matching, and data conversion.
•Proficiently used Excel, Power BI, Tableau, and other tools to develop reports and data visualizations.
•Substantially increased accuracy and completeness of all datasets through regular auditing & validation activities; improved customer satisfaction ratings by 15%.
•Designed, developed, and implemented ETL process using IICS data integration.
•Created IICS Connections using various cloud connectors in IICS Administrator.
•POC done for using Data integration tool (Talend/AZURE).
Harley-Davidson Aug 2018 – June 2019
Production Support Lead Analyst / Developer / Tester: (Infosys Ltd)
Key Responsibilities:
Involved in performing regular system audits to ensure accuracy of the various environments and applications along with monitoring Control M batch processes and perform trouble shooting using ETL job logs.
Making sure all the jobs were completed before 7 am, and data is loaded appropriately into the respective marts.
Support included research, triage, defect resolution, test support, coding, compliance and all other production support functions.
Provided on call support for problem triaging and coordinated with various support teams across the organization
Interacting with the Business users on daily basis to discuss day-to-day issues and matters.
Maintaining and/or creating all relevant documentation including but not limited to documents supporting change management process and procedures, job run book, data backup and retention policy, and applicable access controls documentation.
Facilitated the development of comprehensive data governance policies and procedures, resulting in improved accuracy and completeness of corporate data sets by 25%.
Responsible for validation & to check integrity of data when Oracle upgrade done from 11g to 12c.
Involved in the migration project, moved 5000 + plus jobs from legacy system (Day Break) to OFSLL system.
Obtained source data, data profiling by writing complex queries.
Created views and stored procedure as when need during validation.
Modified JIL’s using shell scripting (bash) as per requirement.
Designed & documented the flow of jobs in the Control M for the new OFSLL system.
Worked on the REGABii project, coordinated with Business and with third party vendor so that the data in files are in the correct format before being transmitted to the SEC.
Created JSON file using Hierarchical stage.
Involved in the development, unit testing and assisting Business and QA team
USAA (San Antonio, TX) Feb 2018 – July 2018
Sr. ETL Developer:
Project: The Advising team, involved in the assisting the end users to get up to date information about personal Budgeting and Savings Goals. I have designed and developed new and modified the existing jobs.
Key Responsibilities:
Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing in the Agile environment.
Extracted Data from heterogeneous sources including Sales force and loaded into heterogeneous targets.
Modified the existing SQL queries to increase performance and to meet the new requirement.
Structured and sequenced the jobs in Control – M based on requirement and monitored the jobs at Test and Production level.
Played key role in analysis of defects and fixing the defects in jobs in Production.
Assisted Scrum Master with all the developmental activities, Updated Version One to create task of ETL development.
Bank of America: Agoura Hills, CA (HCL America) Sept 17- Feb 2018
ETL Developer:
Key Responsibilities:
Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing
Created / modified Shell scripts for the upgrade project.
Created shell scripts to invoke Data Stage jobs, pre/post processing files and schedule using Autosys scheduling tool.
Created Autosys JIL's - command jobs to automate the ETL process.
Created various documents for the Upgrade project
Worked closely with Admin team to create Groups and Users
Worked with IBM team to create various NDM for different environment and servers
Assisted Scrum Master with all the developmental activities, Updated Rally to create stories, Features and tasks of ETL development
Freddie Mac Mclean, VA (TCS) Oct 2016 – May 2017
ETL Developer
The project is about Customer Central Data mart, created Dimensional and Fact tables using top-down approach.
Key Responsibilities:
Created DataStage jobs to extract, transform and load data from CDW (Corporate Data Warehouse) and load into Staging and then into DB2 Database according to the requirement.
Extracted, transformed data from heterogeneous systems like DB2, SQL Server and flat files and loaded into DB2 tables
Created Autosys JIL's - command jobs to automate the ETL process.
Performed data analysis, gap analysis and data validation according to the requirement.
Used Team Forge for distributed version control (Git) and to maintain governance, compliance and code security.
Assisted Scrum Master with all the developmental activities, Updated Version One to create task of ETL development
Macy’s. July 16 – Oct 2016
ETL Developer
Project:
RTO (Real Time Offer, project) captures the clicks and purchases data. The data is collected sent through various databases and finally into Warehouse. Marketing/Advertizing team extracted data from Warehouse for internal reporting and for RTO campaign.
Key Responsibilities:
Reviewed business and technical requirements and ensure the data integration platform meets requirements.
Interacting with Business users for Gathering information on new requirements.
Load and transform large sets of structured, semi structured and unstructured data using Hadoop.
Making sure to meet the coding standards of Data Stage for ease of understanding.
Involved in the documentation of existing as well as upcoming projects for support perspective.
Implement parallel processing, load balancing, near real-time and real-time ETL, ELT processes.
Conducted End to end Testing - execute job flows, investigate system defects, resolve defects and document results
Assist in the development, documentation and application of best practices and procedures that govern DW implementations and operations.
Baylor Scott & White, Dallas, TX March 2016 – June 2016
ETL Developer:
Key Responsibilities:
Reviewed business and technical requirements and ensure the data integration platform meets requirements.
Interacting with Business users for Gathering information on new requirements.
Lead design, development and implementation of end-to-end complex ETL system using DataStage tools
Adhere to the SLA of different modules in daily basis.
Involved in the documentation of existing as well as upcoming projects for support perspective
Implement ETL systems that are operationally stable, efficient and automated
Implement parallel processing, load balancing, near real-time and real-time ETL, ELT processes
Assist in the development, documentation and application of best practices and procedures that govern DW implementations and operations
Achievement’s:
Designed the dynamic jobs for level 5.1/5.2 for Type1/Type2 jobs which would create file per source per thread at run time based on driving meta data table.
BCBS July 2015 – Feb 2016
Informatica Developer
Key Responsibilities / Achievements:
Understand business processes and collaborate with business users/analysts to get specific user requirements.
Prepare the high- and low-level technical specification documents based on the Business requirements.
Designed a STAR schema for Immunization data involving shared dimensions (Conformed) using Erwin Data Modeler.
Developed Parallel jobs with various stages including Aggregate, Join, Lookup, Sort, Merge, Expression, Surrogate Key generator and slowly changing dimension (SCD) stages.
Worked on resolving the performance issues.
Companion Data Services (CDS), TX Jan 2015 – June 2015
Informatica Developer
Project – EDW data integration
This project mainly aimed at extracting the data from multiple sources and loading it into Enterprise Data warehouse.
Key Responsibilities / Achievements:
Propose system solutions and architect the solutions using Informatica Powercenter 8.5 for integration from various data sources with Data warehouse.
Developed / designed various new processes and fixed the existing process with new business requirements, various meetings with users input.
Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, MULTI LOAD, and FASTLOAD
Conducted peer designing, code reviews, and standard documentation of ETL procedures
MICHAELS STORES Inc. Irving, TX May 2014-Dec 2014
DataStage Lead Developer
Key Responsibilities / Achievements:
Understand business processes and collaborate with business users in requirements analysis, functional design, and technical design documentation.
Followed Agile development practices to the Inbound and Outbound ETL interfaces
Propose system solutions and architect the solutions with IBM DataStage for Promote integration.
Build end-to-end integration between Oracle Promote and Netezza enterprise Data warehouse using IBM DataStage 8.7 to implement promotional planning optimization (PPO) solution.
Designed and developed Oracle SQL queries and Stored procedures. Used 'NZload' utilities.
Blue Cross Blue Shield of TX, Richardson, TX Sept 2013 – May 2014
Business / Data Warehouse Analyst
Key Responsibilities:
Worked closely with a project team for gathering business requirements and interacted with Stakeholders and business users to translate business requirements into Functional and Technical specifications and Data movement documents to build Java applications.
Interacted with Users for verifying User Requirements, managing change control process, updating existing documentation.
Facilitated (JAD) Joint Application Development sessions to resolve issues relating to difference between business requirements and technical design.
Formulated rules, and created flow using Paper free, in the creation of - 837 dental, 837 professional, and 837 institutional maps in accordance with HIPPA compliance
Conducted and performed analysis of EDI transactions (834,835 and 837), document and produced metric reports.
Progressive Insurance, Colorado Springs, CO Sept 2012 - Aug 2013
Sr.Informatica Developer
MICHAELS STORES Inc., Irving, TX Mar 2009–Aug 2012
DataStage Developer
Human Health Service Commission, Austin, TX Sept 2006 – Jan 2009
SSIS / SSRS/Analyst
Contact this candidate