Sachin Paka
Fremont,CA
Summary
Analytical data professional with over 15 years of experience prepared to deliver innovative data architecture solutions. Recognized for developing efficient data frameworks and enhancing data systems to drive business growth. Known for collaborative teamwork and adaptability to evolving project needs. Proficient in data modeling, database design, data integration and data visualization techniques.
Overview
16
16
years of professional experience
6
6
years of post-secondary education
7
7
Certifications
Work History
Advisory Data Architect
Zoll Medical
Pittsburgh, Pennsylvania
04.2017 - Current
- Defined technical principles, vision, and standards for cloud data platform
- Led a team of 10 data engineers and analysts, fostering collaboration and skill development, resulting in a 25% increase in project efficiency over two years
- Architected Sales data platform with advanced ML techniques used for forecasting and targeting specific territories
- Successfully managed a $2M enterprise-wide analytics project, delivering actionable insights and reporting capabilities 4 weeks ahead of schedule
- Developed and executed a three-year roadmap for a centralized data warehouse, aligning with organizational growth objectives and reducing reporting time by 40%
- Played key role in data pipeline project completion for FDA approved LifeVest devices
- Restructured the analytics team workflow to address reporting bottlenecks, reducing delivery time by 30% and improving stakeholder satisfaction
- Implemented real-time analytics with Kinesis Analytics, enhancing the ability to derive actionable insights from live data
- Successfully implemented an enterprise-wide MDM solution leveraging Salesforce
- PowerBI SME within the division
- Developed and executed project plans using Agile methodologies, resulting in timely delivery of product features and enhancements
- Pivotal in establishing data governance policies
- Presented complex analytics solutions to C-suite executives, simplifying technical details to align with business strategies, resulting in the approval of key initiatives
- Developed and evangelized standards used within BI, including Data Warehouse (DW) best practices and design patterns, frameworks and templates, naming conventions and coding standards
Lead Data Engineer
QBE North America
Sun Prairie, Wisconsin
01.2016 - 03.2017
- Strategized onboarding of insurance data providers
- Lead and motivated teams towards achieving project objectives, while also fostering collaboration and communication among team members
- Built Microsoft project plans to plan
- Track and manage projects
- Facilitated communication and alignment among cross-functional teams, fostering transparency and accountability throughout the project lifecycle
- Created, maintained, and optimized data pipelines leveraging tools such as Apache Spark, Apache Kafka and ETL technologies
- Documented data engineering processes, best practices, and system architecture
- Communicated technical concepts and solutions effectively to non-technical stakeholders
- Developed PowerBI Dashboards, power maps, pivots and reports for business solutions
- Working with different teams for finalizing specifications for data sources for ETL Design and Development
- Environment: PySpark, MS SQL Server, Analysis Services, IoT, Azure, Oracle, PowerBI
BI Team Lead
Cincinnati Bell Telecom
Cincinnati, OH
01.2015 - 12.2015
- On-shore Lead for Application Transition between Cincinnati and Accenture team
- Set up of Knowledge Transition sessions with business teams and developed high-level project plans for transition
- Identified key areas in projects where process and methods could be implemented
- Lead the Migration team to migrate legacy application into new technologies
- Processing of Cubes developed in Hyperion Essbase
- Authored deployments document notes for deployments
- Assisted test team, production team during deployments
- Developed ETL packages
- Configuring Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages
- Updating the BRD, technical specification documents
- Deployed SQL packages to different environments
- Tracked work items within the team and implemneted process improvements techniques
- Created concise and clear reports for distribution and presentation to higher management on weekly basis
- Environment: MS SQL Server 2012/2008R2, Visio, MS SQL Analysis Services 2012, XML, MS Excel, Visual Studio 2008, Windows Server 2003
BI Consultant -Microsoft
Accenture
Hyderabad, India
07.2013 - 12.2014
- Senior consultant for design and development using SQL Server Databases, ETL, SSIS, SSAS and Power Views
- Worked with business in gathering requirements
- Engaged cross teams for finalizing specification for data sources for ETL design and development
- Designed mapping specs and developed ETL packages using SSIS to move data in between the systems
- Designed and developed tabular models and multidimensional models using SSAS (also Tabular) based on the insights provided by the business users
- Designed ETLs, Dimensions, and hierarchies in SSAS cubes based on star schema from Data warehouse
- Developed on the fly tabular models and power BI solutions which helped business analysis
- Developed power views, pivots and reports for business solutions
- Provided requirements for the development team regarding mappings and views that are to be built
- Environment: MS SQL Server 2012/2008R2, Visio, MS SQL Analysis Services 2012, Excel, Visual Studio 2012, Windows Server 2008/2012
- SQL/SSRS Developer Microsoft
BI Developer-Microsoft
Accenture
07.2009 - 07.2013
- Standardized report formatting across departments, ensuring consistent presentation style and content structure that facilitated ease-of-use for all users.
- Optimized database performance through careful monitoring, tuning, and troubleshooting.
- Scorecards Development using SSAS/Performance Point Server
- Developed cubes with star schema using SQL Server Analysis Services (SSAS)
- Analyzing cubes and dimensions and worked on integration of SharePoint with PPS
- Streamlined data analysis by implementing efficient BI solutions and tools.
- Worked on creating partitions and designing various storage modes to increase the performance of SSAS cubes
- Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
- Developed queries for generating drill down and drill through reports in SSRS 2005/2008R2/2008
- Implemented effective backup and recovery plans, ensuring minimal disruption in case of data loss or system failure.
Education
MASTER OF COMPUTER APPLICATIONS, MCA -
OSMANIA UNIVERSITY
01.2010 - 01.2013
BACHELOR OF COMPUTER SCIENCE, BSC - undefined
OSMANIA UNIVERSITY
01.2006 - 01.2009
Skills
Skills Summary
Certification
Year
Timeline
Advisory Data Architect
Zoll Medical
04.2017 - Current
Lead Data Engineer
QBE North America
01.2016 - 03.2017
BI Team Lead
Cincinnati Bell Telecom
01.2015 - 12.2015
BI Consultant -Microsoft
Accenture
07.2013 - 12.2014
MASTER OF COMPUTER APPLICATIONS, MCA -
OSMANIA UNIVERSITY
01.2010 - 01.2013
BI Developer-Microsoft
Accenture
07.2009 - 07.2013
BACHELOR OF COMPUTER SCIENCE, BSC - undefined
OSMANIA UNIVERSITY
01.2006 - 01.2009
Similar Profiles
Halie EvansHalie Evans
Territory Manager at ZOLL MedicalTerritory Manager at ZOLL Medical
George BakerGeorge Baker
Warehouse Storeperson at Zoll MedicalWarehouse Storeperson at Zoll Medical
Ginger JacksonGinger Jackson
LifeVest Senior Executive Territory Manager at ZOLL MedicalLifeVest Senior Executive Territory Manager at ZOLL Medical
HYUNJIN KIMHYUNJIN KIM
Sr. Industrial Engineer at Vitesse SystemsSr. Industrial Engineer at Vitesse Systems
Kathryn SiebenKathryn Sieben
Behavior Technician at AGES Learning SolutionsBehavior Technician at AGES Learning Solutions