Pranav Patel Email & Phone Number

Irvine, California, United States

Management- Manage integrations to new and existing external data partners- Establish and lead cross-functional teams to ensure successful go-live of data partner integrations- Manage and work with a team of direct reportsCollaboration- Partner with internal and external development teams for data integration implementations- Establish a line of communication with internal product teams as well as external data partners- Facilitate communication and understanding of active projects amongst various product teams- Collaborate with internal teams to create and track data integrations performance improvement KPIsTechnology- Provide technical leadership to build census among stakeholders around proposed designs- Ensure integrations with new or existing data sources are designed with performance, scalability, and redundancy considerations- Exhibit subject matter expertise in data partner integrations- Establish knowledgebase for all data partner integrations related artifacts

- Ensure successful delivery of projects based on the scope, product goals, and overall business value- Coordinate between cross-functional teams to deliver high quality data products- Manage the delivery of the enterprise data platform content by actively working with key stakeholders and incorporating their feedback into product releases- Ensure the teams are effective and improving its internal processes within the Scrum framework guidelines- Facilitate & lead the teams through key Scrum ceremonies (daily scrum, sprint planning, sprint review, & sprint retrospective)- Partner with the Product Owner to align, manage, and prioritize the product backlog within Jira- Help improve the teams' productivity by tracking key metrics and undertaking process and tools enhancement tasks- Partner with solution architects and solution managers to establish data architecture models using globally adopted tools (Erwin, Visio) and processes- Establish and help business adopt standard tool(s) and processes to collect and maintain globally consistent data definitions- Ensure that the solution design and implementation meets the enterprise architectural goals and applicable standards- Collaborate with stakeholders from IT as well as other functional teams to facilitate the creation and evolution of company's ability to capture, store, and deliver data

Bloomington, Indiana Area

- Responsible for managing the North American Business Intelligence environment (SAP BI4, Qlik)- Oversaw the Data Engineering team in the maintenance and enhancement of SQL Server data marts, ETL procedures, Business Objects universes, Qlik data models and other related artifacts- Recruited and mentored new Data Engineering team members- Provided guidance and support to colleagues and key users of the system while acting as the primary point of contact for the region- Managed cross-functional projects in accordance with globally defined priorities and project timelines- Identified and communicated dependencies to key stakeholders throughout the project lifecycle- Helped teams adopt the scrum framework in order to increase predictability, visibility, and accountability of work

- Partnered with cross-functional stakeholders to improve overall reporting and data analysis across all functions of Cook Medical.- Gathered reporting requirements to implement various reporting data models (Accounts Payable, HR, Employee Requisition System, Customer Relationship Management).- Liaised with the reporting team to create process efficiencies and introduced ways to verify data accuracy & integrity.- Oversaw system maintenance, upgrades, and patch roll outs.- Led conversion of local and global reporting databases from SQL 2005 to 2012.

- Maintained and developed department website which was used to reach out to prospective IU students from grades 4 to 12.

Metadata Management- Built prototype to extract technical metadata from ProClarity Analytics and Dashboard server.- Developed metadata prototype to provide business and technical audience data lineage starting from the source system to the BI tool.- Designed and Implemented ETL utilizing T-SQL, XPath, XQuery, and SSIS to load the extracted metadata into dimensional structure.- Developed the prototype using logical processes (requirements gathering, analysis, design, development, testing/validation)

- Performed web application testing using Java and SeleniumHQ.- Implemented CRM application modules according to the business requirements.

- Gathered & analyzed business requirements to build Business Objects Universes allowing users to create ad-hoc reports.- Integrated data into MS SQL database from various sources using Microsoft SSIS and T-SQL.- Implemented merge replication to distribute local data across Cook companies on a global basis.- Helped globalize Business Intelligence solution.- Administered SAP Business Objects Server components.

Masters

Ba