Vijay Tadepalli
Summary
Results-driven Engineering leader with 20+ years of experience in healthcare industry, specializing in Data Analytics and Clinical Data Interoperability. Proven track record of leading global teams to deliver innovative products using Scrum methodologies. Skilled in leveraging cloud-based technologies, particularly Azure, for enhanced efficiency and scalability. Strong project management skills and experience managing development staff and external IT vendors.
Overview
22
22
years of professional experience
Work History
Sr.IT Data Analytics Manager and Technical Advisor- Advanced Business Analytics
UnitedHealth Group
12.2007 - Current
- Managed and supervised a team of 25 on/off-shore staff throughout the full development and maintenance life cycle for new EDW and existing legacy UHG data warehouses.
- Collaborated with program and project managers, solution architects, quality assurance experts, information management specialists, and infrastructure managers to successfully deliver projects within specified timelines and budgets.
- Met SLA's for Existing and New Data Warehouses as Service Level Owner
- Accountable for and provided leadership to technical leads and senior level professionals
- Coordinated resource management across teams, ensuring proper allocation for project delivery and revenue goals
- Ensured adherence of technical processes with established standards
- Established standards for efficient data processing in warehousing
- Effectively supported business strategies with a strong focus on Enterprise data warehousing and a vision for business analytics.
- Collaborated with a product team to analyze and interpret user requirements, delivering technical architecture and design specifications.
- Collaborated with business users, solution architects, and development leads to design and execute application-level architecture
- Acted as the application(s) functional expert; provide expertise in the business processes supported by the data warehouse
- Worked with other architects in defining software / hardware requirements and in planning and delivering infrastructure
- Identify cross-team issues, and communicate them to the appropriate team leads
- Collaborated with product and technical leads to provide precise estimates during PI Planning sessions.
- Drafted innovative design strategies and software appraisal documents with architecture, product and SRE team that were highly appreciated
- Defined and documented best practices for the successful execution of new EDW implementations covering ORG, ORC, Deployment and Post-Deployment processes.
- Oversight and contribution to planning and execution of Performance Test
- Engage in the evaluation of software tools and packages.
- Collaborated in bringing on board a diverse team of on-shore and off-shore technical consultants and permanent staff.
- Maintained and monitored data quality standards across multiple databases.
- Developed and implemented data analysis strategies to improve the accuracy of analytics results.
- Collaborated with stakeholders to identify areas of improvement by leveraging existing data assets.
- Conducted interviews with subject matter experts to gain a better understanding of their needs and expectations.
- Developed data security and disaster recovery procedures.
Development Lead / ETL Architect
UnitedHealth Group
07.2007 - 12.2007
- Worked as an ETL Development Lead/Architect designing ETL process for one of the largest Data Warehouses (Pharmacy PARTD Data) in the company
- Provided technical and organizational direction to both permanent and technical Consultants
- Created development plan and coordinated development with on-shore and off-shore ETL team
- Involved in creating the technical design and development documents for the entire project
- Interacted with business users for further drill down to understand the logistics of data
- Interacted with clients and business users to gather the requirements, by understanding the needs
- Analyzed the data for the creation of the Star and Snowflake Models
- Created Metadata repository for the entire project
- Understand and analyze the need for making the optimal usage of Database and Operating system space usage by interacting with DBAs
- Created the Data Models by using ERWIN
- Communicated with the users and business clients for any updates and changes in design and development
- Created Multiple Facts and Dimensions for the Data Mart requirement
- Extracted the data from SSIS packages using import and export facility and created the required formatted files as the source for project
- Involved in detailed project level discussion for setting the environment for the entire project
- Explained the need of setting of DB2 Enterprise stage for loading the high volumes of data into Marts
- Involved in getting the detailed business requirements for the process
- Set up the business required rules to use the Stranded Stages on Datastage such as DB2 EE, Oracle EE, ODBC stages for Database side, Pivot, Change Capture, Change Apply, Remove duplicates, Complex Flat files, Transformer, Lookup, Join, Merge, Filter, Modify, etc
- Identify cross-team issues, and communicate them to the appropriate team leads
- Responsible for the design and development of work estimates and act as the primary point of contact for work estimates
- Oversight and contribution to white papers on design approaches and software evaluation
- Responsible for detail designs, build, and testing support of Interface, ETL-Population, Data Management, Data Quality, and Reporting services
- Provided technical direction to the developers while troubleshooting Datastage jobs that were having issues with nodes and configurations
- Designed UNIX scripts for Bulk Loading the data using DB2 load utility by processing the data based on partitions by individual year and month
- Assist developers in migrated the code Datastage, jobs, UNIX scripts to Pre-Prod, Prod using the ITG tool
- Provided technical direction for Qlikview developers to support UHG Marketing and compliance supporting applications with Qlikview9.0/10.0
- Supported Business Users with Issue relating to Collaboration objects, bookmarks, and access issues
- Worked with end users to gather the functional requirements and customize Qlikview dashboards according to their requirements
- Configured Qlikview software to solve the Reload and Publishing issues to optimized RAM usage
- Upgrade Qlikview Software from version9 SR4 to version10 SR4 worked with Automation Team to perform Load Test
- Technical environment: DataStage 7.5.2/7.X, Datastage,DB28.9/9.1/9.7, Oracle 10g/11i, SQL Server 2005 SSIS, AIX 5.3/6.1 UNIX, Autosys4.5, Subversion, Erwin 6.0, Teradata, Qlikview
Development Lead
UnitedHealth Group
07.2004 - 07.2007
- Involved in the successful implementation of major Data Warehouse releases in UnitedHealth Group sales Data Warehouse
- Actively involved in the set-up, coordination and management of offshore/onsite development team
- As a Development Lead, involved in leading the ETL design, development and testing activities
- Involved in leading the Data Warehouse team upgrading the existing Oracle Data Warehouse from 7.5.3 to 7.9.4
- Extensively involved in preparing the project estimates based on the business requirements
- Delegated work load to team members and ensured project timelines were met
- As a Subject Matter Expert/Development Lead, extensively involved in interacting with Business Analysts and end-users to gather requirements for Oracle BI reporting
- Created the high-level designs and detailed designs from the business requirements
- Conducted design and code reviews of fellow team members
- Extensively worked with Informatica/Datastage to pull data from existing Siebel Applications Rosetta, Atlas and flat files to Data Warehouse
- Involved extensively in identifying the bottlenecks and fine tuning the mappings
- Fine tuned SQLs which were identified as potential bottlenecks using SQL Quest Optimizer
- Developed shell scripts to schedule workflows using Informatica post session commands
- Set up the business required rules to use the Stranded Stages on Datastage such as DB2 EE, Oracle EE, ODBC stages for Database side, Pivot, Change Capture, Change Apply, Remove duplicates, Complex Flat files, Transformer, Lookup, Join, Merge, Filter, and Modify stages
- Developed several mappings to scrub corrupted data in the warehouse using Conversions
- Involved in moving jobs from Windows batch scheduler to Autosys to automate the existing dependencies
- Extensively involved in setting up environments for development, testing and UAT environments
- Involved in coordinating with database team in resolving ETL issues related to database such as identifying runaway queries which need indexes and table space issues
- Involved in managing the Data Warehouse production support team
- Technical environment: Informatica 6.1/7.1.2,8.1.1,Datastage7.5.x Oracle BI EE (10.1.3.3.1), Siebel Analytics (7.5.3), Siebel Analytics Server, Admin Tool, DB2 8.2.3
ETL/Data Warehouse Consultant
Pacific West Corporation
08.2003 - 07.2004
- Met with Project Coordinators, Business Analysts and end-users to gather requirements
- Addressed critical areas of impact involving data integrity
- Moved data by extracting it from Siebel OLTP using Informatica Power Mart 6.1 OEM for Siebel; loaded the data in to Siebel e-business Data Warehouse creating meaningful data for Siebel Analytics (OLAP)
- Used various transformations Viz., Filters, Stored Procedure, Sequence Generator, Expression, Lookup and Aggregator in the mappings, thus eliminating redundant and inconsistent dependencies
- Worked on the Siebel Admin Tool to configure the business model based on the end users requirement
- Configured Logical Layer, created Logical tables/dimensions, columns, created Logical Joins/keys, Set levels to support Drill-down, Aggregation / Sum over Columns, etc
- Used Time Series Wizard to work on the Calculation measures
- Added analytics contents to Siebel EBusiness Applications using Siebel Tools and the symbolic URL infrastructure
- Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities
- Created OLAP reports using Siebel Analytics 7.5, Siebel Answers, Siebel Dashboard, Catalog Manager, etc
- Implemented the delivery of IBots using Siebel Delivers to alert the associated teams
- Technical environment: Siebel Analytics (7.5.3), Siebel Analytics Server, Admin Tool, Informatica 6.1, Windows NT, Oracle 8i
ETL/Data Warehouse Consultant
10.2002 - 08.2003
- Identified the granularity level of the data required to be available for analysis Performed ETL using Informatica to populate the DW as per the business requirements
- Identified Fact tables, Dimension Tables- to store business attributes, identified Aggregate tables & their definitions and performed data modeling for proposed architecture
- Proposed/recommended design alternatives to confirm to the business requirements
- Identified Data Sources (Siebel Enterprise DW) & extension columns identified Siebel OLTP tables, fields, mapped them with Staging Tables and finally mapped them to OLAP Physical layer tables/schemas
- Added analytics contents to Siebel eBusiness Applications using Siebel Tools and the symbolic URL infrastructure
- Modified Metadata repository suiting Clients data requirements by using Siebel Analytics Server Admin tool
- Created reports using the Siebel Answers
- Customized Dashboards and created appropriate links to suit the requirements of the client
- Created Pivot Tables and manipulated Init Blocks for report analysis
- Technical environment: Sales Analytics (7.5.3), Siebel Analytics Server Admin Tool Informatica 6.1, Windows NT, Oracle 8i
Education
Master of Science - Computer Science
University of Oklahoma
Skills
Technical Skills
Cloud Technologies:
- Azure: Extensive experience with Azure services including Azure DevOps, Azure Machine Learning, and Azure Kubernetes Service (AKS)
Data Analytics & AI:
- Data Analytics: Expertise in data visualization tools like Tableau and Power BI, and data processing with SQL and Python
Clinical Data Interoperability:
- FHIR: Knowledgeable in Fast Healthcare Interoperability Resources (FHIR) standards for healthcare data exchange
- HL7: Proficient in Health Level Seven (HL7) protocols for clinical data interoperability
Software Development & Methodologies:
- Scrum Methodologies: Proven track record of leading Scrum teams, conducting sprint planning, and managing product backlogs
- Data Quality Management
Timeline
Sr.IT Data Analytics Manager and Technical Advisor- Advanced Business Analytics
UnitedHealth Group
12.2007 - Current
Development Lead / ETL Architect
UnitedHealth Group
07.2007 - 12.2007
Development Lead
UnitedHealth Group
07.2004 - 07.2007
ETL/Data Warehouse Consultant
Pacific West Corporation
08.2003 - 07.2004
ETL/Data Warehouse Consultant
10.2002 - 08.2003
Master of Science - Computer Science
University of Oklahoma
Similar Profiles
Amanda BurbankAmanda Burbank
Senior Provider Relations Advocate, Account Manage at UnitedHealth Care, UnitedHealth GroupSenior Provider Relations Advocate, Account Manage at UnitedHealth Care, UnitedHealth Group
Fawn DillonFawn Dillon
Clinical Transformation Manager at UnitedHealth Group- UnitedHealth Care DivisionClinical Transformation Manager at UnitedHealth Group- UnitedHealth Care Division
Vikas KansalVikas Kansal
Senior Director Digital Product at UnitedHealth Care, UnitedHealth GroupSenior Director Digital Product at UnitedHealth Care, UnitedHealth Group
Shalalah HarveyShalalah Harvey
Workforce Analyst at UnitedHealth Care, UnitedHealth GroupWorkforce Analyst at UnitedHealth Care, UnitedHealth Group
Brian BlackburnBrian Blackburn
Advanced Business Analyst / Data Management & Analytics at FIRST ENERGYAdvanced Business Analyst / Data Management & Analytics at FIRST ENERGY