Vinod Reddy.

Project Title: RBD,COKE and RHC Data Warehouses

Reyes Holdings, LLC is an American foodservice wholesaler and distributor that ranked in 2020 as 8th largest privately held company in United States. It has 4 business units: Reyes Beer Division, Martin Brower, Great Lakes Coca-Cola Bottling and Reyes Coca-Cola Bottling.

The Project is a data migration and enterprise data warehouse project for different business units of the company like RBD, COKE and RHC from existing SQL Server Azure cloud environment to Snowflake cloud data warehouse.

Key Deliverables:

• Preparing data flow and model for each and every dimension and fact tables in data warehouse by understanding existing ETL process like SSIS, Cognos Decision stream and process built in Java.
• Involved in creating Snowflake objects starts from tables, views , procedures and functions, streams etc.
• Implemented incremental data loading using streams and dynamic stored procedures with merge functionality.
• Developed several ADF pipe lines for data ingestion from different sources to Snowflake also involved in testing, deploying and monitoring ADF pipelines.
• Worked on Azure features like Logic apps for Data flow automation and Azure storages like blob, files and tables.
• Involved in all stages of project from designing, developing, testing, deployment and Production Support
• Involved in data testing using automated test scripts post migration nd peer reviews for migrating tables from existing environment.
• Developed various reports and dashboards in Power BI.

Environment: Snowflake , Azure, Power BI.

Project Title: Datalink

Health Plan Services (HPS) is nation's largest independent provider of sales, benefits administration, retention, and reform and technology solutions to insurance and managed care industries.

Role involved in Data Link reporting platform which gives ability for producing various reports on top of enterprise Data Warehouse for customer enrollment, reconciliation, billing and finance information.

Key Deliverables:

• Involved in ETL Development for Incremental Data Warehouse with new and enhanced features of Product
• Worked in developing SSIS packages, SQL server stored. Procedures and views for full and incremental loads of Policy Based payment transactions and for reporting
• Worked in developing SSIS packages and SQL Server objects for organizational SLA project for heterogeneous sources like DB2 windows/Linux, Service Now, SQL server and file system
• Developed many SSIS packages for interactive reporting
• Involved in Performance tuning of SQL server and SSIS packages to reduce load timings
• Involved in all stages of project from designing, developing, testing, deployment and Production Support
• Prepared different documents in Designing ETL process and Data Warehouse like Visio, Kimball Data model and test plan documents
• Worked on converting and consolidating business inputs for SLA project from different sources using Python code
• Have done Administration activities in monitoring SQL server Agent jobs, Data backups and restores

Environment: SQL Server 2014, Integration services, Python,DB2.

Project Title: Bigdata

Dorchester Collection is the successor to the Dorchester Group, originally established in 1996 to manage a portfolio of some of the world's foremost luxury hotels in Europe and the USA.

This project is on enterprise data warehouse called Big Data to improve business, marketing, campaigning. Improving hospitality by knowing the guest preferences and profile.

Big Data tackles the volume, velocity and variability of large volumes of data, to allow businesses to query and report on broader spectrum of information.

Key Deliverables:

• Production ETL support, monitoring and daily report preparation on data statistics
• Fixing daily ETL issues like any Primary Key violation issues and backlog data process for different source systems and sanity check for different data sources
• Cluster failover for any software updates or planned restart of physical servers
• Worked on ETL automation on identified part of big data solution and dealt with FTP servers for different type of file operations as part of data integration
• Worked on backup and restore of different production server databases and proactive space management like shrinking of log files and file management
• Worked on dynamic SQL for SCD handling of different source systems and enhancement
• Worked on performance improvement of long running loads like purging of data and index management

Environment: SQL Server 2012, Integration services.

Project Title: BOS PNL
Profit and Loss reporting for management of Business Operations Support, this is a monthly process of capturing BOS financial data from ESSBASE and loading into PNL data warehouse for management dashboards and reports. The data contains profit and loss information across different dimensions like Profit center, Cost center, Vendor, Vendor PO, WBS, Cost Elements and Head count etc.
Key Deliverables:

• Physical data warehouse design and development for BOS finance
• Development of SSIS packages to consume data from files with xlsm extension from Share Point.
• SSRS dashboards/ PNL reports for management
• Data massaging/scrubbing to eliminate manual intervention and updating finance data
• Development of PNL cube for analysis

Environment: SQL Server 2012, SSIS, SSRS and SSAS
Project Title: BOS PNL
Alliance provides sales and support of hardware products, the support and sales transactions distributed across different live servers, Database subscriptions are set to integrate the sales, shipping, Agent and support information into a central repository Management reports/dashboards created for trending and analysis of delivery, fix and billing of Alliance hard ware products.
Key Deliverables:

• Database subscriptions set up to pull data from different live servers to reporting database
• SSIS packages and stored procedures to load data from live servers on daily basis
• ETL jobs to schedule and automate data refresh
• Development of SSRS reports and subscriptions/schedules

Environment: SQL Server 2012, SSIS and SSRS

Project Title: Data Migration

Migration of data from Oracle finance system to SQL server Database on monthly frequency. Migration of data starts from Oracle database to the intermediate tables in SQL Server then population of Dimension tables and fact table by applying transformations in SQL Server Integration services.

Profit and Loss BI reports taken from SQL server database, total thirty SQL server Integration Services packages (SSIS) and three procedures are involved in the migration, Out of thirty packages, nineteen intermediate tables to capture the monthly finance data and ten dimensional packages like Account, unit, Location, Geography, Process to load the master data and one Profit and Loss fact package to load the transnational finance system data.

Key Deliverables:

• Support for monthly run of SSIS packages to load data from Oracle to SQL Server, Finding reasons for rejected records in SQL server and fixing them
• Development of Dimensional packages and modifications in Fact package and tables corresponding to packages at back end
• Resolved bugs and hard coding in current design
• Performance tuning of SQL server Integration services packages
• Automated monthly ETL run process by designing SQL
• Jobs and configuration of SMTP server to get automated mails
• Development of SSRS reports to monitor SSIS packages execution
• Involved in end-to-end development starts from requirements gathering to code migration to Production
• ETL testing on different instances for R12 migration of finance system

Environment: - SQL Server 2008, SSRS, SSIS

Project Title: Social Media Analysis:

Custom dashboard analysis on different areas in a banking domain like Credit Cards, iBanking, Treasures, Mortgages, Auto loans, Personal Loans, Call Center, Branches, SSB and Deposits in different country regions.
Social Media Analytics pulls data from micro blogs, twitter, face book and different websites based on configuration provided by the user at configuration section in SMA.
Dashboard built on the Cognos DMR model using Cognos report studio The custom dashboard shows the analysis of different types and concepts using charts and graphs for a period in different country regions.
Key Deliverables:

• Development of various charts and graphs in dashboard using Cognos report studio
• Conditional formatting of various labels and conditional colors in charts
• Development of column, bar, line, 100 percent stacked bar and combination charts in report studio
• Data sanity and data testing in various charts using adhoc list and cross tab reports
• Development of various dashboards for different country regions for different time-periods based on user requirement
• Supporting and maintenance of dashboards for changes and delivering dashboards on weekly basis
• Manually selected snippet text incorporation in dashboards, running and delivering dashboards weekly
• Auto generation and scheduling of dashboards for different time-periods

Environment: - Cognos Report Studio and SMA

Project Title: PRESTO

Data Migration from Old System to New System based on changed schema and functionality, This is one time migration job.

Migration involved in 6 modules AX(Customers, Finance and Feedback),Card Master(Cards, E-purse, Contracts and period passes),OSR(Operator Sales Report),TUR(Transaction Usage Report),List and TRX(Transaction).

• Key Deliverables:
• Developed various SSIS packages Using Framework based on requirements and functionality
• Developed Customer migration Packages those will migrate all customers from old system to new system
• Developed Card Order History migration Packages those will migrate sales, cards, and purchase and vendor history from old system to new system
• Developed various Packages with Exception Handling and explicit Transaction Mechanism
• Configured variables and used variables throughout SSIS project
• Migration involved in three phases, Extract Data from old system applying transformations load into staging and finally load into new target system, Total 40 packages are developed along with Grand master Package to integrate all modules
• Number Sequences and Record ID's are generated on fly in all Packages
• Event handlers are developed to generate stage, insert, update, error, ignore count of records in report
• Framework will generate migration staging report
• Involved in Unit testing, Assembly testing and bug fixing in SSIS packages
• Environment: - SQL Server 2008R2, SSIS

Project Title: Data Migration

Data Migration from Flat Files to oracle Database, Data is extracted from Policy Management System and flat files are generated

Flat files data is then extracted, transformed, and loaded into new Oracle Database.

Key Deliverables:

• Have been Involved in developing ETL functionality for data migration from flat files to oracle database
• Developed several SSIS Packages and SSRS reports based on requirements
• Good understanding of Flat files data and configuration of flat files
• Developed various SSIS packages and SSRS reports based on requirement
• Developed Flat files load package with error logging mechanism
• Developed cleansing package based on cleansing requirement with error logging and roll back mechanism
• Configured variables and used variables throughout SSIS project
• Based on staging tables design, developed unique keys when inserting data into tables to maintain data integrity
• ETL happens in 3 phases(Staging-1(Extract data from flat files),Staging-2(Transform extracted data in staging area),Load(Load transformed data in to Oracle database)
• In all, 11 various SSIS packages are developed to perform above mentioned ETL scenario, Including 3 packages to generate data migration related reports, which explains data migration activity(Bad data, Errors, Rejected records, Successfully migrated records etc.) at different phases of data migration
• Involved in fine-tuning of SSIS packages, by eliminating Sort components
• Implemented checkpoint mechanism, created as many control flows as possible to improve checkpoint functionality
• Deployed packages in test environment
• Implemented SSIS error logging mechanism and redirected warning and error messages to text file
• Configured environmental variables

Environment: - SSRS, SSIS, T-SQL