Ab Initio, Unix, SQL, Spark Scala, AWS, Databricks

Location:

Collierville, TN

Posted:

March 14, 2023

Contact this candidate

Resume:

Resume of Senior Ab Initio Developer/Lead/Analyst – Pankaj Gusain

Contact No: (001)224-***-**** (U.S.)

Email Id: *************@*****.***

Visa Type: H1B visa

Title

Ab Initio Consultant

Primary Skills

Ab Initio, Unix, Pl/Sql and Perl

Location

Collierville, TN, US

RESUME DETAILS

Summary:

• 17+ years of experience in requirement analysis, software development, design, testing, implementation and supporting applications in Ab Initio, UNIX, Pl/Sql and Windows environments

• Received ATOS SYNTEL spot awards in the years 2019 and 2020 for showcasing excellent application knowledge and exemplary contributions to the projects

• Received NTT DATA service excellence award in the year 2014

• Received Star Performer Award in TCS yearly town hall meet held on Dec 2011 in Chicago, for stretching beyond work responsibilities and Client appreciations for value and excellence

• Received several commendations for consistently surpassing Service Level Agreement targets, including delivery, application availability, and support call turnaround time

• In the year 2010 performance tuned a critical Walgreen forecasting batch application to reduce its run time by 10 hrs compared to the way it was designed in 2003, this was counted as one of the biggest performance improvements in Walgreen inventory portfolio

• Worked extensively on ETL tool Ab-Initio (GDE Versions 1.10, 1.11, 1.14, 3.0.2, 3.1.7, 3.2.6, 3.3.5, 4.1.1) (CO>OP Versions 2.10, 2.11, 2.14, 3.0, 3.1.7, 3.2.7, 3.3.5, 4.1.1)

• Worked on Continuous flows, Conduct>It, XML processing, Web Services, Micrographs, ICFF

• Worked on TRMC tool for maintaining EME repository, code promotion, creating tags and save files

• Knowledge in EME check –in, check –outs, sandbox creation

• Worked on Data Lineage dependency analysis concepts. Familiar with the concepts of Metadata Hub, Data profiler, BRE, TRW

• Around 3 years of work experience in Big data technologies such as Spark, Scala. Alongside worked on Databricks, AWS S3 buckets and parquet files.

• Around 1 year of design and development experience in Informatica Power Center V6 and V7, C and C++

• Strong relational database development skills using PL/SQL, Oracle 11g

• Familiar with HDFS and Hadoop technologies

• Extensively involved in critical production support project with time bound SLAs

• In depth experience in doing business system analysis and RCA, helped business users by identifying gaps in business rules implemented in AbInitio flows of various applications

• Strong experience with batch job automation tools like ESP scheduler, Control M and Automic Scheduler

• Experience in data modeling concepts like STAR schema and snowflake schema

• Experience in object oriented design/analysis

• Provided Ab Initio best practices to different clients

• Worked extensively in implementing data warehouse applications, data integration and business intelligent applications. Familiar with the data warehouse concepts like Data Mining, querying, ETL, OLTP, OLAP, reporting

• Extensive Knowledge in Retail, Health Care, Telecommunications, Finance, Logistics and Banking Projects

SKILLS:

Platform: Sun Sparc, x86, IBM Compatible PC family. OS: UNIX, Solaris 2.6, MS-DOS, Windows-95/98 and Windows NT. Languages: C/C++, Java, Perl.

SQL & RDBMS: DB2, Oracle 9i/11g, PL/SQL, Snowflake. Other: UNIX Shell Scripting, Vi, MS Office, MS Excel, Power Point, MS Word. Tools: Abinitio, TRMC, Informatica, Toad, Pl/Sql Developer, Putty, Telnet, WinScp, SFTP, SFD, VSS, CVS, Visio2000, RTC, SNOW, MFT, ALIS, Jira, Snowflake, Automic Scheduler, Databricks.

EDUCATION: B-Tech Electronics and Communication Engg. completed in the year 2004 EXPERIENCE

Client: Capital One, US

Place: Working remotely from Collierville, TN

Duration: Aug 2020 - Till Date

Project: CapOne Merchant Partner Conversions(RPM/WSI/Ridge/BB) As part of the project, set of raw source files containing the customer demographics, human data, NPI, PCI, income, credit worthiness data, events, transactions, statements, Offer, etc. were processed using Ab Initio, Spark, Scala and Databricks. The processing involved decrypting/converting the files and tokenizing them using Ab Initio and Spark scala codes. For further downstream processing the tokenized files were processed through the implemented business rules in Ab Initio Conduct IT plans, psets, graphs and were used to create the LR files using Databricks. Those LR files were then shared with TSYS, who in turn generated a new set of Day0 files for CapOne. Those Day0 files were then processed through Ab Initio conversion plans, pset and graphs setup as workflows and jobs on Automic Scheduler to go through the business rules and generate the LR files on AWS S3 buckets for downstream teams and to also load into Snowflake database and created Views for various applications and user teams.

Client: FedEx World Technology Center, US

Place: Collierville, TN

Duration: October 2018 – Aug 2020

Project: Cheers Ratesheets Conversion to Ab Initio As part of the MF conversion program, FedEx converted the Cheers rate sheets generation process to Abinitio processes. Cheers rate sheets generated current and proposed rates for letter, pak, service and heavy weight package types for the current and proposed proposals sent by the EPRS users. In order to generate those rates the new programs process the messages through Ab Initio continuous flow graphs received from the Java application Xopco, pull data from different EDD tables and IMS databases that were converted to Ab Initio ICFF, process data collected from multiple Ambassador services using Abinitio continuous flows, pull data from multiple SSI files and internal db at various stages of the program flows to be processed by the complex set of program rules implemented in multiple Conduct It plans, psets, graphs and micrographs. Apart from different types of rates, the ratesheets also contain zone chart information if the user requested for it. Rate Sheets can be of different types like, Non-US Intra, Import, Export, Inbound, L3P and G3P, depending on the need of the business and the users, for each kind a different set of Ab Initio process was designed and developed.

Client: Blue Cross Blue Shield NC, US

Place: Durham, NC

Duration: March 2018 – September 2018

Project: JCAPS Remediation to Ab Initio – PSOR to Callidus Blue Cross is in the process of phasing out legacy JCAPS processes from its environment so as part of that initiative the legacy JCAPS processes are being rewritten in Ab Initio. PSOR to Callidus is one such JCAPS process that consumes Agency, Producer and relationship data from PSOR application and generates records with new Agency, new Producer, new Producer Customer relationship and records with attribute changes for Callidus. With some complex business rules, Ab Initio CDC pipeline and extraction logic the process generates seven different types of record sets and provides them in one smart file to Callidus. Client: Blue Cross Blue Shield NC, US

Place: Durham, NC

Duration: July 2017 – Feb 2018

Project: Care Radius FEP Migration to Care First

The aim of this project was to migrate the inpatient and outpatient authorization of FEP members from Care Radius application to CareFirst for Claims processing using Ab Initio. The extracts from the Care Radius application were processed and business rules were implemented to create XML extracts for Care First tool. Checks and balances were implemented in order to detect and alert in case of any issues in the extracts, also email reports were sent out to the business groups with a summary authorizations that were sent to Care First.

Client: Blue Cross Blue Shield NC, US

Place: Durham, NC

Duration: Jan 2017 – June 2017

Project: Streamlining ID Data Integration

This project was executed to streamline the delivery of information from the CIL layer to various downstream consumers. It was a Technical Implementation project and the aim was to revise the design of the old data flow architecture from CIL to the downstream consumers, which was flawed with data losses in the MQ channels, delays in data deliveries and in some places absence of adequate checks and balances. Some of the changes implemented as part of this project were switching the data staging layer from MQ to soft links, implementation of checks and balances, smart reading/archiving/deleting of the soft links in Ab Initio.

Client: Blue Cross Blue Shield NC, US

Place: Durham, NC

Duration: Jan 2016 – Dec 2016

Project: Enhancements and Incident Fixes in Commission application of Blue Cross This project was part of an Enterprise Initiative that was run by Blue Cross to fix all gaps and data issues that had accumulated over the span of couple years since the Enrollment, Product, Producer, Delinquency and Income data of Blue Cross was migrated to Facets. Because of the out of sync old Commission application process and the accumulated data issues the data coming out of the Commission app was down to 40% accuracy rate, which was resulting in faulty Commission payments to the Producers and was also creating a lot of manual work for business users. To improve the data accuracy, all the Enrollment, Product, Producer, Delinquency and Income data coming from the Facets system was thoroughly analyzed along with the old business rules implemented in Commission application and then a series of enhancements and fixes were implemented in Ab Initio processes. That resulted in the improvement of data accuracy from 40% to more than 98% rate, which significantly reduced the faulty Commission payment and manual work for Business users. Client: Blue Cross Blue Shield NC, US

Place: Durham, NC

Duration: July 2014 – Dec 2015

Project: Provider Information Management System (PIMS) The project is aimed to integrate McKesson application PIMS into provider management processes of BCBSNC. After integration PIMS a Provider Information Management System application would be used by BCBSNC to store & process updates related to Business Entities, Providers, Practitioners, their locations, specialties, affiliations & networks. Updates fed through PIMS would be provided to downstream applications such as PMHS, NTS & EDW. This project involves a one-time setup of PIMS Data Warehouse, which would house all the necessary information for Business Entities, Provider, Practitioners, etc. This information is extracted from the currently operational sources such as PMHS, Blue Provider & NTS. This one time setup would be done with the help of Ab Initio, Unix & Pl/Sql. Project also involves creation of an adapter that would process daily updates to downstream applications such as PMHS, Blue Provider & NTS, after the Data Warehouse is ready and PIMS application is live in the production environment.

Client: Blue Cross Blue Shield NC, US

Place: Durham, NC

Duration: Oct 2013 – June 2014

Project: Care Radius/Facets Integration

This project is aimed to develop a real time data interface process between Topaz/Facets and Care Radius applications. Real time updates generated in member, group and plan data would be processed in XML format adhering to the canonical layout defined by the Enterprise Information Model. The data would be staged in the Common Information layer to be consumed by all the downstream stakeholder applications. The updates from CIL would be supplemented with necessary information and after being processed through sets of business rules, through the AbInitio CDC flow for change data capture and data quality checks would be supplied to Care Radius. This information will be used to process claims. The authorization data generated by Care Radius would be continuously supplied back to CIL and as per the canonical layout will be processed and provided back to Topaz/Facets. Role: Senior Ab Initio Developer/Team Lead

• Conduct meetings with business users and different project groups to understand the project scope and requirements.

• Involved in Agile project development life cycle.

• Understand the E-R data model for all different interacting applications.

• Understand the canonical format as defined by EIM for all different applications.

• Conduct meetings with different application groups to understand the VDXF and CDXF formats along with the significance of various attributes for various applications.

• Create high level design of ETL adapters for various interfacing application systems

• Design continuous flows to process the data in real time.

• Processed the data through Abinitio CDC pipeline for change data capture, to collect the new records, deleted records and updates to the existing records

• Design plans in Conduct>IT to perform conditional run of Ab Initio processes and conditional integration of different processes.

• Design and develop Ab initio graphs to process the XML files and generate the XML output files for downstream teams in some processes.

• Develop graphs in Ab Initio & Pl/Sql to transform & migrate the information related to Business Entities, Providers, Practitioners, their locations, specialties, affiliations & networks.

• Pass on all the requirements and knowledge gathered to the offshore team.

• Work with Offshore team to create low level design and develop Ab Initio processes.

• Provide technical direction to all team members and ensure on-time deliveries at various stages of project life cycle.

• Work with the QA team to build exhaustive test cases and coordinate with them during the entire testing process.

• Provide guidance to the developers in implementing some complicated business rules in the Abinito codes.

• Coordinate with BCBS team to get all required accesses for the team members to design/develop/test/deploy the project codes/deliverables. Environment:

Operating System: SUN Solaris, Windows XP

Languages: Unix Shell, Pl/Sql

RDBMS: ORACLE 11g

Special Software: Ab Initio (GDE: 3.1.6, CO>OP: V3.1.5), Putty, Control-M, Pl/Sql Developer, SharePoint, Quality Center, WINSCP, Teradata. Client: Walgreen Co., US

Place: Deerfield, IL

Duration: Aug 2012 – Sep 2013

Project: Planogram – Item Shelf Min Override

In the existing Walgreen’s system, the Minimum Shelf Quantity for an Item at a Store is calculated based on the variable, store, BDM shelf min, corporate overrides and based on the item setup in planograms. Walgreens decided to change the current system in order to provide the screens to override Minimum shelf quantity by entering the specific WIC, planogram. The Shelf Min Qty Override at Planogram-Item level would affect the process of calculating the Total Min Shelf Qty for its Controlling Item at the store. Hence the Item Shelf Min process was to be changed to recalculate the Min Shelf Qty for a Controlling Item at a store if there is a Min shelf Qty override for its Item-Planogram. All this was being done in order to come up with the most optimum value of the shelf quantity for an Item at the Walgreens stores which in turn would directly impact the overall profit margin.

Role: Senior Ab Initio Developer/Team Lead

• Participation in all the stages of the agile project development life cycle.

• Development of high performing, easily maintainable Abinitio ETL graphs and shell scripts.

• Held meetings with business users and gathered business requirements along with other senior members of the team.

• Coordinated with the front end application teams to understand the type of data business users could process through web apps and structure the Ab initio implementation accordingly.

• Carried out risk analysis to identify risk areas for the given project.

• Created high level and low level design documents for processing each feed and documented the various implementations done during the course of the Project.

• Created reusable transformations to implement specific business rules in Ab Initio codes.

• Generated ASCII metadata from the COBOL copybooks and validated those against the sample data sets.

• Providing technical direction to all team members, and ensuring on-time delivery of all projects

• Provided guidance to the developers in implementing some complicated business rules in the Abinito codes.

• Queried and analyzed data loaded to the Datamarts and Data Warehouse.

• Involved in code reviews and performance tuning the Ab initio codes.

• Helped the QA team in creating an exhaustive list of various test scenarios.

• Managing and supervising technical team of 12 developers and other roles; managed development, maintenance and production support services to meet clients' business needs and deadlines.

• Interfaces with L1 & L2 support teams to define operational processes and procedures.

• Created work orders for the project based on the project plans discussed with WAG managers and got them approved.

Environment:

Operating System: SUN Solaris, Windows XP

Languages: Unix Shell, Perl, Pl/Sql

RDBMS: ORACLE 11g

Special Software: Ab Initio (GDE: 3.0.2, CO>OP :V3.0), Putty, ESP, TOAD, Pl/Sql Developer, CVS, VSS, VMWare, Remedy, SharePoint, JIRA, TRMC, SFTP, WINSCP. Client: Walgreen Co., US

Place: Deerfield, IL

Duration: January 2012 – July 2012

Project: Multi-sourcing FoRS Impacts

Walgreen wanted to implement a vendor multi-sourcing strategy for their items across all stores. In this strategy there are multiple vendors that compete to get the orders for a single Walgreen item. Different vendors may offer different deals, discounts or bonuses to get the orders for the item. Walgreen would then choose the most profitable offer and the contract for supplying the item would go to the vendor giving the offer. In order to implement the strategy the functional processes creating order forecast for Walgreen items had to be changed. Concepts like MVS item, Bonus item, Active Sub, Corp view, Sub Distr, Purch Sub had to be incorporated in the process. Forecasted orders that were earlier provided at the primary level had to be provided at the sub level to business users and vendors. CFP application had to be provided with the flexibility to view totals by Control WIC for all DCs or totals by WIC only for the DCs that WIC is supplied to. Users need to have multiple views to allow different roll-ups depending on how they intend to use CFP to work alerts, collaborate with a vendor or export data for analysis. VIF and EDI supply processes had to be changed to provide them the view of forecasted data and Item/Distr information at different levels. PMM data had to be interpreted and processed with the changing levels of Distr information.

Role: Senior Ab Initio Developer/Team Lead

• Conducted meetings with WAG managers and business users to understand project scope, budget and delivery timelines.

• Carried out risk analysis to identify risk areas for the given project.

• Created work orders for the project based on the project plans discussed with WAG managers and got them approved.

• Held meetings with business users and gathered business requirements along with other senior members of the team.

• Created high level and low level design documents for processing each feed and documented the various implementations done during the course of the Project.

• Helped Data architects and Data analysts to build Data Mart part of inventory Data Warehouse for PMM sales data.

• Held meetings with WAG users at different stages of design/development to keep the project on track with changing business requirements or scope of the project.

• Providing technical direction to all team members, and ensuring on-time delivery of all projects

• Provided guidance to the developers in implementing some complicated business rules in the Abinito codes.

• Involved in code reviews and performance tuning the Ab initio ETL codes.

• Helped the QA team in creating an exhaustive list of various test scenarios.

• Managed and supervised technical team of 14 developers and other roles; managed development, maintenance and production support services to meet clients' business needs and deadlines.

• Tracking team member performance against schedule and targets, providing feedback, resolving issues, and coordinating changes to enhance project performance.

• Produced project status reports, managed the team and resolved day-to-day issues with emphasis on SDLC.

Environment:

Operating System: SUN Solaris, Windows XP

Languages: Unix Shell, Perl, Pl/Sql

RDBMS: ORACLE 11g

Special Software: Ab Initio (GDE: 3.0.2, CO>OP :V2-14), Putty, ESP, TOAD, Pl/Sql Developer, CVS, VSS, VMWare, Remedy, SharePoint, JIRA, TRMC, SFTP, WINSCP. Client: Walgreen Co., US

Place: Deerfield, IL

Duration: June 2011 – December 2011

Project: Item Sub-owner for RDF Workbooks

RDF workbooks are grid/graph views for day to day approvals and adjustment by RDF Forecasters and RBs. Workbooks are created by IF weekend batch and can be also created manually.

There are mainly two issues with current design:

• When a single RB or forecaster is assigned a huge number of opstudy and items, workbooks take too long to be built.

• New opstudy does not automatically come in WB. Since WB are created by a reference set of opstudy, which is static, new opstudy gets missed coming into WB if it is not in the reference file.

To resolve the issue, the new design will update the RDF product hierarchy to split the workbook in smaller sizes. This split will be based upon user provided data where one RB/FCT will be split in multiple for different sets of opstudy. Unlike static reference files, this process will be dynamic and include new opstudy every week. Also WB built time will be reduced due to the split of one big WB into many.

Role: Senior Ab Initio Developer/Team Lead

Responsibilities:

• Participated in Software Requirements Specifications (SRS) meetings with various downstream application teams and stakeholder business groups.

• Assessed risks and hazards to the success of the project and took appropriate measures for avoidance.

• Managed and supervised technical team of 12 developers and other roles; managed development, maintenance and production support services to meet clients' business needs and deadlines.

• Coordinating directly and indirectly with project staff to ensure successful completion of the project – directed, supervised, supported and coordinated the project team members/staff.

• Involved in developing high level and low level design documents for processing each feed and documented the various implementations done during the course of the Project.

• Developed a number of Ab Initio generic graphs and reusable transforms based on different business requirements.

• Held meetings with WAG users at different stages of design/development to keep the project on track with changing business requirements or scope.

• Providing technical direction to all team members, and ensuring on-time delivery of all projects

• Provided guidance to the developers in implementing some complicated business rules in the Abinito ETL codes.

• Traced, analyzed and resolved various issues related to project constraints that came up during the course of the project, also held meetings with clients for the same.

• Involved in code reviews and performance tuning the Ab initio codes.

• Reporting on project progress and communicating relevant information to superiors and company management.

• Involved in UAT along with development/QA team and WAG business users.

• Supervised the migration and deployment of codes to the production environment.

• Post deployment followed up with clients to verify satisfaction.

• Coordinating the lessons learned process.

Environment:

Operating System: SUN Solaris, Windows XP

Languages: Unix Shell, Perl, Pl/Sql

RDBMS: ORACLE 9i

Special Software: AbInitio(GDE: 1.14, CO>OP :V2-14), Putty, ESP, TOAD, Pl/Sql Developer, CVS, VSS, VMWare, Remedy, SharePoint, JIRA.

Client: Walgreen Co., US

Place: Deerfield, IL

Duration: December 2010 – May 2011

Project: IF PMM process revamp

Promotional Merchandise Management is a Walgreen custom built tool to forecast and manage promotional events. When there is a Promotional Event at the store, the appropriate PMM forecasts are selected so that an Ad Bulletin Projected Store Order can be generated in a future step. Only weeks with promotion events should have an Ad Bulletin Projected Store Order attached. Every week IF process gets feed from the PMM system regarding the promotions going on for different Walgreen items at different US locations. IF process then converts the feed to promotion forecasts for the items and sends it to PSO in order to generate orders.The IF PMM process needs to be revamped in order to improve the accuracy of PMM forecast that it generates for PSO. The sub processes like Ad Overlapping and Distr Overlapping need to be restructured. The concept of rolling ahead the PMM forecast for an Item on a particular Ad at a particular location, in order to replenish the store before the promotion starts needs to be revised. Role: Senior Ab Initio Developer/Analyst Programmer Responsibilities:

• Managed and supervised technical team of 11 developers; managed development, maintenance and production support services to meet clients' business needs and deadlines.

• Interacting with customers as well as the team for requirement gathering, risk assessment, finalization of technical specifications.

• Coordinated directly and indirectly with project staff to ensure smooth execution of the project – directed, supervised, supported and coordinated the project team members/staff.

• Responsible for identifying cross-project issues and working with R&D management to identify and implement solutions.

• Ensure project compliance with company Software Quality processes.

• Responsible for software design reviews, peer code reviews and software acceptance test activities on a regular basis.

• Involved in developing high level and low level design documents for processing each feed and documented the various implementations done during the course of the Project.

• Held meetings with WAG users at different stages of design/development to keep the project on track with changing business requirements or scope.

• Providing technical direction to all team members, and ensuring on-time delivery of all projects

• Provided guidance to the developers in implementing some complicated business rules in the Abinito ETL codes.

• Extensively worked on fixing the performance issues and gaps between business rules and designs implemented throughAbinitio Graphs.

• Held meetings with WAG users at different stages of design/development to keep the project on track with changing business requirements or scope.

• Involved in UAT along with development/QA team and WAG business users.

• Supervised smooth implementation of the project and extended post-implementation, application maintenance and technical support.

Environment:

Operating System: SUN Solaris, Windows XP

Languages: Unix Shell, Perl, Pl/Sql

RDBMS: ORACLE 9i

Special Software: AbInitio(GDE: 1.14, CO>OP :V2-14), Putty, ESP, TOAD, Pl/Sql Developer, CVS, VSS, VMWare, Remedy, SharePoint, JIRA.

Client: Walgreen Co., US

Place: Deerfield, IL

Duration: May 2010 – Nov 2010

Project: Scan week to Ad week conversion

The DC Forecasting week is Sun-Sat to allow replenishment buyers to have all information available to them on a Monday morning. Hence PMM week must align to this week.Two Wed-Tue PMM forecasts are generated for one Sun-Sat promotion week. These forecasts need to be summed to get total promo demand so that inventory can be ordered and front loaded before the promotion.

Action Items:

a)If a store adjusted PMM forecast exists, replace the original PMM forecast for week X and week X+1 with the store adjusted PMM forecasts(these incorporate store manager changes to suggested ad bulletin quantities.) Otherwise, use the original PMM forecasts for week X and

week X+1.

b)Add the non-zero PMM forecast for week X to the non-zero PMM forecast for week X+1 to get the total promo sales forecast for the event

this week.

Role: Senior Ab Initio Developer/Analyst Programmer Responsibilities:

• Managed and supervised technical team of 11 developers; managed development, maintenance and production support services to meet clients' business needs and deadlines

• Interacting with customers as well as the team for requirement gathering, risk assessment, finalization of technical specifications.

• Handle the tasks of tracking progress of projects against goals, objectives, timelines, and budgets. Generatedstatus reports

• Worked as Onsite Coordinator for getting the work done from an offshore team.

• Extensively involved in various iterations for designing and developing the code.

• Extensively used Ab Initio (GDE Ver 1.13.27 and GDE 1.14.31) and EME for ETL processing.Created dynamic DMLs and complex XFRs wherever required.