Parthasarathy Seshadri
Eden Prairie,MN
Summary
Seeking opportunities to leverage expertise in Data Warehousing and Business Intelligence area to deliver impactful results.
Solution Architect with solid skills in Data warehousing and Business Intelligence with a career spanning 25+ years having worked on all phases of data warehouse development life cycle, from gathering requirements to final implementation
Experienced and enthusiastic Consultant with track record of success across wide range of industries. Possesses exceptional interpersonal, problem-solving and analytical skills to provide advice and expertise to client organizations improving business performance. Experienced in all aspects of SDLC
Overview
31
31
years of professional experience
Work History
Consultant
Tata Consultancy Services
08.2010 - 04.2024
- Walgreens
- Firestarter Program - Migration of On prem application to Azure Cloud, Rewrite of ETL Jobs in Data Factory Pipeline and created data flow from landing to curated layer in Azure Synpase, Build Data lake on Azure and Data modeled Curated layer.
- NCPDP F6 Standard adaption - Solution Architected the claim data consumption for Pharmacy account receivable system in Talend DI and Big data.
- Rx Renew - Solution Architected near real time data ingestion from new billing engine to Pharmacy accounting system. This solution was built in Talend Bigdata and DI with Oracle DB
- Best Buy
- Solution Architect for Large Product fulfillment, Logistics and Order Health Management application. Building largest In-memory Db using MS Tabular and MS PDW (Parallel Data Warehouse)
- Target India
- Managed delivery for BI performance engineering and Platform management on DB2, Teradata, Data Stage and Oracle
Senior Manager
Mascon Global Ltd
11.2007 - 07.2010
Established and managed Business intelligence and data warehousing practice.
Project Manager
Wipro Technologies
12.2001 - 11.2007
Architected complete solution for ingesting real time data into data warehouse for Gas transport in UK, with complex business operations, with data modeling of 1200+ tables in Star schema, snow flake schema, Operation data store (ODS) in Oracle and Business Objects
Consultant
MASCON GLOBAL LTD
11.1996 - 11.2001
Numerous projects executed as manager and developer in data warehouse area.
Consultant
ENERGY TECHNOLOGIES
03.1996 - 11.1996
Developer in sybase and oracle
Consultant
Softcon
04.1995 - 02.1996
Developer in Sybase, Power Builder for various projects
Developer
Kenwood Inc
01.1993 - 04.1995
Developer in C, Sybase and Power Builder
Education
B.E (Electrical & Electronics) -
Bharathidasan University
01.1989
Skills
- Data warehousing & Business Intelligence
- Data Architecting
- MS Azure, Data Factory Pipeline, MS SYNAPSE
- Oracle, MS SQL Server, Teradata, Sybase, DB2
- MS PDW (APS)
- Talend DI & Big Data, Datastage, Informatica, MS SSIS
- Power BI, SSAS Tabular, Business Objects & BO Web Intelligence
- Oracle Streams & Oracle AQ
Professional Highlights
- Solution Architected near real time data ingestion for Pharmacy billing for accounting system at Walgreens.
- Adaption of NCPDP F6 standard for billing of claims
- Migration of On Prem application to MS Azure
- Solution Architected largest in-Memory tabular model implemented at Best Buy
- Solution Architected multiple programs at Best Buy catering to Supply Chain and Logistics
- Performance Engineering and Platform Management of large BI applications with Target Corporation
- Established BI/DWH practice in Mascon; building collaterals; identify service offerings to customers and work closely with other business verticals to identify the most practical/beneficial solution.
- Architected completed DWH solution for System Operations for National Grid Transco – UK, complex business applications, solution had more 1300 table data modelled.
- Managed and Architected data migration and cutover for suite of Front Office applications at NGN
- Technical guidance and mentoring the team to develop their competencies.
Workauthorization
Green Card
Projects
PARS – NCPDP F6 standards adoption, Walgreens, 06/2023 - present, Oracle, Talend, Abinitio, NCPDP standard to F6 from D0 for claims data., Architected the claim load process of data ingestion to new NCPDP standard. Data modelling and ETL process redesigned to consume new date elements for F6 standards. PARS - RXR Integration, Walgreens, 03/2021 – 06/2023, Oracle, Talend, Ingest claim data from Billing engine to Accounting system., Architected near real time data ingestion for claim data into PARS from billing engine. Designed real time data consumption from SAG queues using Talend ETL for data processing. Firestarter program, Walgreens, 04/2020 - 01/2021, Azure Cloud, Cloud migration for Macrospace data, Cloud data migration from Onprem Oracle data base to Azure SQL using Azure Data factory. Created complex data pipelines and data executors to transform the data end to end. large product fulfillment, Best Buy, 02/2018 – 02/2019, Teradata, Power BI and Fortrunner, Build report Dashboards about the performance of DC and identify the root causes of Imperfect Orders, Data architecting for Large Product Fulfillment and developing scripts in Teradata (BTEQ) for processing data for reporting and developed Power BI reports based on the user requirements. Definition of a perfect orders was quiet agile, which changed rapidly and need to update the scripts on ad-hoc basis as per each business users needs. order health and Logistics, Best Buy, 06/2014 – 01/2018, MS PDW, MS SSAS, SSRS, SSIS, Build Self Service ad-hoc reporting for Supply Chain users providing complete visibility to customer orders and measure performance of fulfillment processes, Solution Architect for entire Logistics program, which consumed data from 12 different source systems. Architected solution from Near real time reporting. Designed the largest In-Memory Tabular model at Best Buy (about 480 GB). Worked with Microsoft consultant for improving the performance of PDW. BI Performance Engineering and Platform Management, Target Corporation, 10/2010 – 01/2014, DB2, Teradata, Datastage 7.x/ 8.x, Oracle 11i, Performance engineering of various BI applications and provide stability to existing BI environment, Played lead architect role in establishing the Platform Management for BI environment (Both Prod and NP Environments). As part of Performance Engineering, have to identify all the performance bottlenecks of the existing BI applications and provide solutions for the same. EIG Data Warehouse, Energy Intelligence Group, 07/2009 - 07/2010, Microsoft SQL Server 2008, EIG DWH is a complete data warehouse solution for various publications published by EIG for Energy Industry, Provide complete solution architecture and design the data warehouse solution and along with data manipulation project for all the existing publications. Manage the delivery of the project and interact with project manager for resolving technical and non technical issues that arise within the delivery team BI DW practice, 08/2007 - 07/2010, Establish BI DW practice at Mascon Global, Initiated the BI DW practice at Mascon Global. Manage the resources for delivery of projects, worked with Sales and marketing teams to establish practice. SKU COMPLEXITY, P&G, 11/2006 - 06/2007, Oracle 10g, Informatica, Seibel Analytics, Web OSA, SKU Complexity is an add-on application for P&G’s Atomic data warehouse built on Oracle 10g database with Informatica as the ETL tool, Seibel Analytics and Web OSA for reporting., Interact with the customer (located in Europe and USA) for day to day execution of the project and manage the delivery from offshore without any onsite support. Apart from day to day execution, co-ordinate with HP for the release to production process for global implementation. GAS DIStribution network systems (GDNS), Northern Gas Networks-UK, 07/2005 - 09/2006, Oracle 9i, OWB, SAP R/3, SAP BW, LSMW, GDNS is a suite of front office application for NGN. Played 3 distinct roles simultaneously within the program namely data integrity manager, cutover architect and SAP BW Basis administrator., Data Integrity Manager: Master data management across various applications in GDNS program. Maintaining data consistency across and ensuring all the data management principles are adhered by various products / vendors. Authored the data migration strategy and data management principle for the GDNS program, managed the execution of the data migration into SAP and other applications, and Co-ordinate with NG and other product vendors for data migration and validation of data. Cutover Architect: Authored the cutover strategy for 29 applications including emergency and metering business processes. Orchestrated smooth transition of business from NG to NGN applications, without business going into manual mode of operation during the cutover periods. Co-ordinate with other third parties for transition of business and applications. SAP BW Basis Administrator: Configuration of SAP BW across the system landscape including the transportation mechanism across SAP R3 and BW as well as within BW landscape. Managed a team of 4 SAP BW consultants for requirements and development. IGMS- MIS, NG Transco - UK, 12/2001 - 06/2005, Oracle 9i, OWB, BO 5.1.6, Web Intelligence 2.7.2, Oracle Designer6i, Oracle Streams and AQ, A large Data warehouse for Strategic decision support system for Operations and Trading department of NG Transco. This is part of Integrated Gas Management System (IGMS) application. IGMS MIS having both Near Real Time and conventional Data Warehouse components., As the chief Architect, responsibility was to provide architecture solution for the entire application to meet both Business and Technical requirements. Lead the Proof of Concept for tool selection. Designed the Data, Interface, ETL, OLAP and Security layers of the application. Designed Logical Data Model and Physical database. MIS was designed and developed in parallel with multiple source systems. Integration of MIS with source applications using Oracle Streams and AQ technologies; managed the customization of Web interface of Web Intelligence and provided single sign on with site minder. Designed Purging and archival solution. Defined the performance measurement criteria for both Reports and ETL mappings. Estimation of Database size and forecasted the growth rate for the database. AEROSPACE HARDWARE exchange, ahxonline.com, 09/2000 - 11/2001, MS SQL 7.0, Windows NT, ASP, Lead a team of 8 developers, in developing www.ahxonline.com, a B2B website for aerospace hardware. Responsibilities include coordination between customer and development team, database design and implementation, managing the development and implementation of the project. Also was involved in various “in-house” projects (Defect Tracking System, ITNeeds) within Mascon Global - Chennai, providing technical guidance and management of these projects. CTSI- DATA WAREHOUSE, Continental Traffic Services Inc, 05/1999 - 07/2000, MS SQL 7.0, Windows NT, Information Advantage, MS OLAP Manager, Active X Script, As the Project manager, responsibility includes defining the Project Scope, Designing the Architecture of the warehouse, Hardware and Software tool evaluation and selection, Project Scheduling, Resource Allocation and management, Analysis of Source System and Reports, Data Modeling, Coordinating with Client and development team, Administrating the data base, develoed Database and OLAP specification, OLAP design and development, Data base design and development, Balancing and Testing. Quality DATA WAREHOUSE, GM Truck, 12/1998 - 02/1998, Developed Stored Procedures and triggers for data migration from various source systems to warehouse, managing the Oracle 8.0 database. ACRON, Columbia Forest Products (CFP), 07/1998 - 10/1998, MS SQL 6.5, Windows NT, Visual Basic 5.0, and Crystal Reports, Involved in development of ACRON a DSS (Decision Support System) for CFP. The System was developed on MS SQL 6.5 environment with Visual Basic and Crystal Report as the Graphical User Interface. Responsibility included writing stored procedures, performance tuning, testing and debugging. DATA WAREHOUSE ADMINISTRATION, Colonial Pacific Leasing, 03/1998 - 05/1998, Sybase System 11, Oracle 7.3, Involved in the administration of the warehouse developed on Sybase System 11 and Migration to Oracle 7.3 environment. DEPARTMENTAL DATA WAREHOUSE, Specialty Operations Dept. CNA Insurance, 06/1997 - 02/1998, Oracle 7.2, Prism Warehouse Manager 4.5, Windows NT, Erwin 2.6/3.0, Development and Implementation of Data warehouse using Prism Warehouse Manager and Oracle 7.2 for Specialty Operations Dept. Responsibilities include designing the Physical Database Model on Oracle7.2 using Erwin2.6. Using Prism Warehouse Manager defined the Data Mapping, Data Transformation Rules and Business Rules, Extraction of Data from Main Frame based systems, and developed SQL Loader scripts to load data STRATEGIC BUSINESS MANAGEMENT INFORMATION SYSTEM ( SBMIS), CNA Insurance - Excess & Select Business Group, 01/1996 - 05/1997, Sybase System 11, Essbase 4.0, Powerbuilder 4.0/5.0, Erwin 2.5x, Design, Development and Implementation of a Data warehouse application using Sybase System 11, Essbase 4.0 and Powerbuilder 5.0, Responsibilities included Requirement analysis; Design of Data warehouse Data Mart, design and development of data extraction from legacy and other source system. Coding of Transformation and Loading program in C and Sybase stored Procedures. MARKETING & CUSTOMER MAINTENANCE(MCM), Equitable Gas, 06/1995 - 12/1995, Sybase System 10, Power Builder 3.0 PRODUCTION PLANNING CONTROL, 06/1994 - 04/1995, Sybase System 4.9.2, Power Builder 3.0 HOSPITAL INFORMATION SYSTEM, 10/1993 - 05/1994, Powerbuilder OILSOL, 01/1993 - 09/1993, C on DOS platform
Timeline
Consultant
Tata Consultancy Services
08.2010 - 04.2024
Senior Manager
Mascon Global Ltd
11.2007 - 07.2010
Project Manager
Wipro Technologies
12.2001 - 11.2007
Consultant
MASCON GLOBAL LTD
11.1996 - 11.2001
Consultant
ENERGY TECHNOLOGIES
03.1996 - 11.1996
Consultant
Softcon
04.1995 - 02.1996
Developer
Kenwood Inc
01.1993 - 04.1995
B.E (Electrical & Electronics) -
Bharathidasan University
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services