Candidates About

 

• Acquired extensive experience in various SDLC methodologies like Waterfall, Iterative, Agile (Scrum).
• Proficient at analyzing and interpreting BRD, FSD, User Stories.
• Efficient problem solving skills allowing rapid assimilation and resolution of complex problems.
• Extensive project and team management experience covering large and small projects.
• Good experience in handling people and their performance management.
• Excellent Communication, Client Interfacing Skills, Good Team Leadership & Collaboration Skills, Quick Learner of new technologies, Consistent and Key performer in every project executed.

 

 

Technical Skills:

 

ETL                            :  Informatica Power Center, Informatica Cloud

Data Quality             :  Informatica Data Quality (IDQ)

Database                   :  Netezza, Redshift, DB2

AWS Stack                :  S3, Athena, Glue Data Catalog, IAM, Redshift Spectrum

Scheduling Tool       :  Control-M

Scripting                   :  Unix shell scripting

Mainframe Stack     :  COBOL, JCL, SUPRA

Query Language      :  SQL, Hive

 

 

KEY PROJECTS:

 

Data Warehouse Analyst                                                                                      Nov 2017 - Till Date

Infosys Limited, Roanoke VA

Customer: Advance Auto Parts, Roanoke VA 

 

Technologies: SAP BODS, SAP BO, Unix Shell Scripting

 

 

Provide support to the Car Quest EDW application system. Car Quest was acquired by Advance Auto Parts and the sales and inventory data from Car Quest flows into Advance Auto Parts EDW. Project involves, supporting the Car Quest EDW application which contains Store/DC Sales, Store/DC Inventory.

 

Roles & Activities:

Ø  Make sure that the EDW system and reporting application is up and running 24/7 hours.

Ø  Perform minor enhancements as per the business requirement. Create ETL process in SAP BODS and Reporting in SAP BO.

Ø  Analysis, Estimation & staffing of the requirements that come from business users.

 

 

 

Data Warehouse / AWS Analyst                                                                                      May 2017 – Oct 2017

Infosys Limited, Houston TX

Customer: Sysco Corporation, Houston TX 

 

Technologies: AWS S3, AWS Redshift, AWS Athena, Hive Query Language, AWS Glue Data Catalog, IAM, Netezza, Unix Shell Scripting

 

Sysco’s SAP system is retiring and 5 years’ worth of enterprise data (Sales, Demand Planning, TMS, etc.,) lying in their Enterprise Data Warehouse (EDW) IBM Netezza, needs to be preserved for historical reporting and business analytics purpose. Given the fact of higher operating/maintenance cost of storing data in Netezza, cloud storage services in AWS has been identified as a viable alternative to keep this data for further analytics usage.

 

Roles & Activities:

Ø  Analyzed the usage of SAP EDW data using the Netezza query history logs for a specific period of time to identify the potential tables that need to be migrated to AWS S3/Redshift.

Ø  Automated the process of extracting the data from Netezza tables into external flat files, loaded the data into AWS S3 cloud storage in compressed format (.csv.gz).

Ø  There were instances where the Netezza tables with the same name present in various SAP schemas. These situations were handled meticulously in the automated data migration process so that the data will not be overwritten across the schemas and separate versions of the data gets stored in S3.

Ø  There were really large Netezza tables with the size of more than 600 GB. Migration of the data from these tables was handled with the data splits identified based on the Netezza audit fields.

Ø  Handled various data quality checks to check the non-ASCII characters in the extracted data stream and converted them form Latin-9 to Utf-8 to keep the data integrity between Netezza and AWS S3.

Ø  Checked for Carriage Return/Line Feeds (CR/LF) in the data stream and cleaned them up before loading the data into the target data storage in AWS S3.

Ø  Executed POCs to identify the best storage format in AWS S3 for the extracted data from Netezza. These POCs were to find out the performance of the queries while retrieving the data from AWS S3 and enable the mechanism to let the business users connect to the data stored in AWS S3 to get their reports and other details. In order to measure the performance, different AWS S3 file formats like .csv.gz, .parquet.gz were used and analyzed.

Ø  Created Athena external tables using Hive DDL to point to the data stored in AWS S3.

Ø  Executed Athena queries on both partitioned and non-partitioned external tables and measured the performance of each combination.

Ø  Worked on setting up S3 bucket policies, IAM console management activities.

Ø  Working on POC/framework to distinguish/define the usage of Redshift-Spectrum.  

Ø  Loaded the data from some of the tables into AWS Redshift.

 

 

Data Warehouse / Informatica Data Quality (IDQ) MDM Analyst                                 Jan 2017 – May 2017

Infosys Limited, Houston TX

Customer: Sysco Corporation, Houston TX                                                                                                                   

 

Technologies: Informatica Data Quality (IDQ), Informatica Analyst, Informatica Power Center, SQL Server DB, Web Services API

 

Sysco wanted to have a clean, unique and useful master data (MDM) in their landscape to make the business process functions accurate. This project is to identify the master data anomalies in the existing landscape with respect to Vendor, Customer and Item, identify the cleansing requirements, and enhance/enrich the data.

 

Roles & Activities:

Ø  Worked with the business leads from each master data domain (Vendor, Customer, and Item) to get the requirements on the list of master data attributes that are required for the data profiling. Basic IDQ (Informatica Data Quality) column profiling results were used for identifying the requirements.

Ø  Created Data Profiling rules document which contains profiling rules to be checked covering all the aspects of data quality – Accuracy, Completeness, Conformity, Consistency, and Integrity.

Ø  Worked on creating the IDQ profiling rules based on these requirements and executed the IDQ profiles to capture as-is nature of the master data.

Ø  For address verification and validation, used Address Doctor Webservice API in IDQ using various process status codes and Mailability scores.

Ø  For E-mail/Phone number verification and validation, used StrikeIron Webservice API in IDQ.

Ø  Identified duplicate data using the Match and Merge process with the inbuilt IDQ algorithms – String match, Edit distance, Bigram Distance, Reverse Hamming Distance.

Ø  Created IDQ scorecards using the various profiling output for the business leads to get the understanding of the data anomalies and decide on the data clean-up and enrichment requirements.

 

 

 

Data Warehouse / AWS Redshift migration Analyst                                                     Sep 2016 – Dec 2016

Infosys Limited, Chennai - India

Customer: Sysco Corporation, Houston TX

 

Technologies: Informatica Power Center, UNIX scripting, AWS Redshift, IBM Netezza

 

As part of migrating the Enterprise Data Warehouse (EDW) system from existing in-house DWH to Cloud based DWH, Sysco identified one of its Netezza boxes’ to be migrated off to AWS. AWS Redshift was identified as its DWH Database in AWS Cloud. Data loading and Data consumption pointing to Netezza DWH needed to be re-pointed to AWS Redshift as part of this migration.

 

Roles & Activities:

Ø  Worked on existing Informatica mappings (ETLs) and Shell scripts (ELTs) to re-engineer the Netezza SQL queries to load the data into Redshift.

Ø  Several Redshift query performance improvement measures were taken to make sure that the time taken by the data load into Redshift process was faster.

 

 

 

Data Warehouse Analyst/Lead                                                                                                      Mar 2016 – Aug 2016

Infosys Limited, Chennai - India

Customer: Sysco Corporation, Houston TX                                                                                                                     

 

Technologies: Informatica Power Center, UNIX scripting, IBM Netezza

 

Enterprise business users wanted more insight into the demand and forecast of the item/inventory to plan better for the continuation of business operations at warehouse. For this purpose, data from the Demand and Planning system in Legacy landscape needed to be brought into the EDW warehouse to make it available for the business users for reporting and analytical processing.

 

Roles & Activities:

Ø  Held discussions with the demand planners to identify different data that needed to be available in the Enterprise Data Warehouse (EDW).

Ø  Created data/column mapping between the source system columns and the data objects needed by the demand planners.

Ø  Based on the information provided by the planners, created the future data model for the EDW tables.

Ø  Created the tables in Netezza with the identified columns as part of requirements and data modelling phase.

Ø  Created Informatica powercenter mappings to read the data from source and populate them into the Netezza DWH.

Ø  Created Unix scripts for RI check, pre-post sessions to populate the Netezza audit logging.

 

 

 

Data Warehouse Analyst/Lead                                                                                                   Nov 2014 – Feb 2016

Infosys Limited, Chennai - India

Customer: Sysco Corporation, Houston TX                                                                                                                    

 

Technologies: Informatica Power Center, UNIX scripting, IBM Netezza, Control-M, SAP Business Objects (BO 3.1)

 

This project involves the maintenance of data warehouse applications that load data and the reports that utilize the warehouse data. The business objective of this project is to enable quick and efficient strategic decision making by the business users, through different metric reports, which shows data out of the Data warehouse. The scope of the project involves resolution of daily client issues on reporting and data load by means of tickets, portfolio projects and enhancement of existing data warehousing applications. This project also involves deeper support activities involving Informatica / Business objects / UNIX scripts, unit testing and code reviews.

 

Roles & Activities:

Ø  Handled the incidents raised on priority within the SLA breach.

Ø  Fixed issues, errors and bugs in the developed Informatica mappings, BO Reports etc.

Ø  Have provided immense support to the clients through On-Call support.

Ø  Co-ordinated with the other support teams like infra, server, source team whenever there were needs to involve them to solve critical issues.

Ø  Excellent communication skills which enabled in bridging with the clients.

Ø  Solved major issues in various client’s custom built applications related to Sales, and Supply Chain.

Ø  Have worked on modification and enhancements to the Informatica mappings and Business objects reports as part of Change Request Management.

Ø  Monitored the Informatica jobs using the scheduling tool – Control M and thus by made sure that the data load SLAs are met.

 

 

 

Technology Lead                                                                                                                                 Feb 2012 – Oct 2014

Infosys Limited, Columbus OH, Chennai - India

Customer: Victoria’s Secret, Columbus OH

 

Technologies: IBM Mainframe, COBOL, JCL, DB2, Control-M

 

 

1)       Implemented two retail business features as part of this project.

·         SOOS - Store Out Of Stock - When the item that customer is seeking is not present in the store, the store associate can place the order for that item online.

·         BORIS - Buy Online Return In Store - The customer can return the online purchased item in the store instead of shipping it back to the DC.  

 

2)       PayPal Implementation project was to introduce PayPal as one of the payment methods for online customers in L Brands e-commerce website. Changes were made to the existing business system to accept the PayPal pay type and process it throughout the system.  

 

3)       There was one more track handled to introduce Electronic Gift Card (EGC) as one of the payment methods. The main objective of this project was to give an option to the international customers (Other than USA) to buy the retailer’s products through their website by paying in their respective local currencies.

A third party vendor eShopWorld was involved to authorize and process these International transactions and to calculate the taxes/duties. After the payment is confirmed, eShopWorld will pass on the payment information to the retailer to process that order further.  

 

Roles & Activities:

Ø  Scrum (Agile) methodology was followed for this project. Acted as Technology Lead during pre-sprint period (sprint 0) and during sprints took on the additional responsibility of a Scrum master.

Ø  Participated in the product owner meetings with business to understand the scope of the changes the business needs.

Ø  Created the list of complex functionalities like settlement processing, Backorder processing which need to be implemented from the discussion with product owners and started parallel development.    

Ø  Executed POC to validate the connectivity between the Payment Gateway vendor PayPal and L Brands.

Ø  Executed POC to validate the connectivity between the Payment Gateway vendor eShopWorld and L Brands.

Ø  Created Sprint planning, Capacity planning for each sprint.

Ø  Analyzed the User stories and questioned the requirements which were not clear/complete at/before the beginning of each sprint.

Ø  Conducted daily stand-up meetings and tracked the status to identify anything obstructing the developers from delivering the shippable product at the end of the sprint.

Ø  Maintained the burn down chart for the team to track project development.

Ø  Conducted technical reviews as Technology Lead.

Ø  Conducted Sprint retrospective, Target vs Built review at the end of each sprint.

 

 

 

Software Engineer/Technology Analyst/Lead                                                                                 Dec 2006 – Jan 2012

Infosys Limited, Kansas City, MO, Chennai-India

Customer: Hallmark Cards, Kansas City, MO

 

Technologies: IBM Mainframe, COBOL, JCL, DB2, CA-7, SUPRA

 

The objective of this project was to provide 24*7 support to business-critical Order Processing application systems such as Customer Database and its Management, Order entry, Order processing and tracking, Promotion and Marketing Programs, Invoicing and Billing, and Automated Distribution to the retailers.

 

Roles & Activities:

Ø  Handled the business critical questions and resolved them within the various severity levels set by the business and IT.

Ø  Handled the research intensive questions by creating Problem management tickets.

Ø  Gathered requirements from the business users for implementing the enhancements in the existing production IT systems by following the appropriate Change Management process. Some of the minor enhancements done are

o    The existing middleware LU6.2 between the Automated Distribution system and the

                  Distribution control system was replaced by the MQ Series.

o    Implemented the business enhancements in the marketing system in order to enable the Mobile Phone Marketing to its customers.

o    Printing of different documents like BOL, Pick list, Invoicing, etc., at distribution centres were enhanced to have additional details by making modifications to the AFP code.

Ø  Performed Impact Analysis to make sure that the new enhancements do not negatively impact the already existing business functionalities.  

 

 

 

EDUCATION

Bachelor of Engineering (Electronics & Communication Engineering), Sathyabama University, Chennai.