Mohnish Swaroop
New York,NY
Summary
Results-driven leader with 18 years of comprehensive experience in delivery leadership, program management, and specialization in Data Warehousing, Cloud Architecture, BI Implementation, and CRM using Salesforce & MS Dynamics. Adept at transforming business requirements into actionable insights through expertise in BI tools, data warehousing, and quality assurance. Skilled in collaborating with cross-functional teams, I consistently deliver innovative solutions that drive business excellence.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Delivery Director
Slalom
07.2021 - Current
- As a Solution delivery lead, I owned the end-to-end delivery of a large and complex data strategy engagement for a global healthcare organization, managing the entire program and ensuring the successful project delivery that set the stage for the implementation phase
- In my role as a data strategist and Solution delivery lead, I have successfully contributed to the transformation of a top health insurance company by designing a future state roadmap, laying the foundation for a Customer Data Platform (CDP) implementation
- Additionally, I provided leadership in designing and implementing a new analytics platform for the client, collaborated closely with vendor companies and managed service providers, worked on project schedules and scope changes, and played a key role in leading a development team to foster talent and ensure project success
- My responsibilities also involved monitoring delivery performance at the client and making recommendations for continuous improvement.
Senior Principal
Slalom
01.2021 - Current
- I orchestrated the design of a Commercial Data Warehouse (CDW) for a prominent biotechnology and life science company, focusing on mastering Healthcare Professional (HCP) data and creating customer-facing dashboards
- Additionally, I established an analytics platform to generate Patient Journey Reports using advanced data and analytics tools
- Contributing to a series of Data Analytics dashboards and the creation of Enterprise Data Hubs (EDH), I designed solutions to meet diverse reporting requirements
- This included crafting Sales dashboards and scorecards for Preneed reporting needs
- My role also involved developing a comprehensive Test strategy, Test scenarios, and Test cases for data validations
- I designed a robust security architecture aligned with hierarchy-based access requirements, and I efficiently managed the scheduling of daily data loads from the Data Warehouse
- Lastly, I played a vital role in facilitating team efficiency by creating Quick Reference Guides (QRGs) and preparing a production rollover plan.
Solution Principal, Data & Analytics
Slalom
01.2020 - 12.2020
- In my role, I successfully delivered comprehensive data strategy, roadmap, data governance (DG), and data architecture solutions
- Leading a team, I played a key role in gathering requirements for graphical user interface design and standardized processes to create a unified view of customers across multiple channels
- Additionally, I implemented a Master Data Management solution for both In/Outbound data sets spanning multiple sources and developed a Customer Master Model, ensuring business integrity and data quality
- Furthermore, I established Enterprise Information Management (EIM) data governance for future endeavors.
Data & Analytics Consultant Manager
Slalom
01.2019 - 12.2019
- Engaged in a pivotal role within a Data Integration project, I focused on mapping data between Legacy systems, specifically a DB2-based application, and Salesforce (SFDC)
- My responsibilities included conducting a detailed data analysis of source input files, resulting in the creation of a robust data model for the project
- Furthermore, I played a key part in enhancing user insights by generating tailored reports, dashboards, and KPIs for Sales users through SFDC
- As a part of ensuring data security and access control, I successfully set up and managed security measures within the Sales Force portal, overseeing user configurations, groups, and roles.
Solutions Architect
Slalom
05.2011 - 12.2018
- As a Solution Architect at Mass Mutual, led the architecture for the Lead Generation Project
- At Forethought, I oversaw the Preneed Reporting Project's data architecture and solution delivery
- Transitioning to XL Insurance, I led a Quality Assurance team for the EMI Project and played a crucial role as a Data Modeller/Architect at Forethought
- Finally, at XL Insurance, I served as the Data Quality Lead for the MS Dynamics (CRM) Project, ensuring project integrity through effective data quality measures.
Technical Lead
Johnson & Johnson
10.2009 - 05.2011
- Collaborated with Data Stage Team members to ensure accurate data acquisition for business needs
- Actively participated in database design discussions with cross-functional teams, including ETL, Cognos, and Database experts
- Managed the scheduling of reports, maintenance of folders, distribution lists, users, groups, and roles using Cognos connection
- Facilitated the deployment of packages from the Development environment to Test and Production environments, ensuring a seamless transition.
Admin/Team Lead
Sony Electronics
11.2008 - 06.2009
- Managed an off-shore team providing 24/7 production support for SONY's Cognos application, ORBIT
- Successfully upgraded Cognos 8.1 to 8.3 in three distinct environments
- Conducted a proof of concept (POC) for utilizing Cognos 8.3 to meet the company's reporting needs
- Developed intricate reports, including a Calendar Layout Report and Sales Performance reports with dynamic user prompt selections
- Implemented Cognos GoOffice to enhance user-friendliness in the reporting environment.
Data Architect/Modeler
Boeing
01.2008 - 10.2008
- Designed the Sales and Marketing data architecture for competitive airplane data analysis, developing logical/physical data models, data marts, and reports
- Conducted interviews with SMEs to gather business requirements, performing gap analysis, and formulated data conversion strategies for source-to-target system migration
- Initiated the setup of the Cognos environment infrastructure in collaboration with the BICC team
- Additionally, I led a team in gathering requirements for graphical user interface design.
Senior Cognos Developer/Team Lead
Lockheed Martin
06.2007 - 12.2007
- Led the development of system requirements by collaborating with stakeholders, conducted data mapping, and successfully delivered over 100 SSA-related reports within three months
- Developed a comprehensive multidimensional database, optimized for enhanced system performance, and personalized user experience through package optimization and custom homepage creation for multiple users.
Senior Cognos Developer
Georgia-Pacific LLC
01.2007 - 05.2007
- In a leadership role, I spearheaded a team of data modelers in the development of both logical and physical data models
- My responsibilities extended to formulating data conversion strategies, particularly focusing on migrating legacy systems to a seamlessly integrated system
- Leveraging my expertise, I developed intricate reports and ad-hoc queries using Cognos 8.1, having successfully upgraded reports from Impromptu
- Additionally, I took charge of the system administration function, overseeing user access and sign-on procedures to implement different levels of authentication and privileges.
Lead Cognos Developer
Pfizer
02.2006 - 12.2006
- As a key contributor on the Global Talent Management team, I played a pivotal role in collecting business requirements essential for designing and developing new reports within the PeopleSoft Data Warehouse framework
- My responsibilities extended to overseeing the requirements gathering process, ensuring a meticulous approach to detail in the creation of a comprehensive functional design
- This involved engaging with business users and analysts to facilitate effective communication and collaboration.
Education
M.S - EE and Computer Science
Syracuse University
01.2005
B.S - Electronics and Telecommunications
Mumbai University
01.2002
Skills
- Oracle, SQL Server, Snowflake, DB2
- Salesforce, Tableau CRM, MS Dyanmics
- JIRA, Azure DevOps, Asana, Trello, Microsoft Project
- Informatica, Cognos, Microstrategy, Power BI, Tableau, ThoughtSpot, Alteryx, Business Objects, Collibra, Alation
- SQL, PL/SQL, Python, VB, NET
- Program Management, Solution Delivery, People Leader, Data Integration, CRM (Salesforce & MS Dynamics), Data Strategy, Data Warehousing, Data Governance, Cloud Architecture, BI Implementation, Data Modeling/Architecture, Data Visualization & Advanced Analytics
Websites
Certification
- Tableau Desktop 9 Qualified Associate - Tableau
- ADM 201 - Salesforce
- Tableau Certified Associate Consultant - Tableau
Industries
- Media & Comm
- Insurance
- Finance
- Retail Banking
- Call Centers
- Life Sciences
- Health Care
- Pharmaceutical
- Paper Industry
- Aerospace
- Government
Affiliations
An active member of Filling in the Blanks since March 2022, dedicated to community services and fundraising for poverty alleviation. Passionately involved in supporting the organization's mission, contributing time and effort to make a positive impact on those in need. Committed to fostering positive change and enhancing the well-being of underprivileged communities through meaningful participation in fundraising initiatives and community service projects.
Timeline
Delivery Director
Slalom
07.2021 - Current
Senior Principal
Slalom
01.2021 - Current
Solution Principal, Data & Analytics
Slalom
01.2020 - 12.2020
Data & Analytics Consultant Manager
Slalom
01.2019 - 12.2019
Solutions Architect
Slalom
05.2011 - 12.2018
Technical Lead
Johnson & Johnson
10.2009 - 05.2011
Admin/Team Lead
Sony Electronics
11.2008 - 06.2009
Data Architect/Modeler
Boeing
01.2008 - 10.2008
Senior Cognos Developer/Team Lead
Lockheed Martin
06.2007 - 12.2007
Senior Cognos Developer
Georgia-Pacific LLC
01.2007 - 05.2007
Lead Cognos Developer
Pfizer
02.2006 - 12.2006
M.S - EE and Computer Science
Syracuse University
B.S - Electronics and Telecommunications
Mumbai University
Similar Profiles
Oscar RegaladoOscar Regalado
Quality Engineer at SlalomQuality Engineer at Slalom
Daniel PragerDaniel Prager
Alliance Director, Google Cloud Business Unit at SlalomAlliance Director, Google Cloud Business Unit at Slalom
Nathan ThesingNathan Thesing
Cloud Practice Lead – Advisory, Transformation, Execution at SlalomCloud Practice Lead – Advisory, Transformation, Execution at Slalom
Mario DiBartolomeoMario DiBartolomeo
Associate Software Engineer at SlalomAssociate Software Engineer at Slalom
Bridget WillardBridget Willard
Account Manager at The Trade DeskAccount Manager at The Trade Desk