Product Management Data Warehouse

Suhasini Gokhale

********.*****@*****.*** 484-***-****

https://www.linkedin.com/in/suhasini-gokhale/

Norristown, PA

Senior Information Systems Professional with extensive hands-on experience in product management, data architecture, software development and systems implementation in Financial Services, Healthcare, Defense and Retail industry verticals. Ability to work in a fast-paced team environment, and desire to expand existing skills through technical project work. Consistently deliver results by exceeding defined goals and objectives. Partner with business leaders and stakeholders to enable teams to implement scalable and efficient solutions.

Areas of Expertise

Product Management Data Architect Data Analytics Data Warehouse Database Design, development Big Data Data Modeling Data Migration Client Relationship Stakeholder Management Business Support Application Development and Integration Waterfall SAFe Agile Methodology Kanban Requirement Gathering System Analysis Continuous Integration CI/CD Optimized solutions Onsite/Offshore Model

Technical Skills

Oracle SQL Server MongoDB ER Studio SQL Pl/SQL NoSQL TOAD ETL/ELT Snowflake JIRA Rally Confluence Python R Tableau Power BI C/C++ JAVA API Kafka VB.net XML Oracle EBS Linux GIT HP Service Desk Cloud computing Data Engineering Microsoft Azure Cloud Services Azure Data Factory Databricks Data Lakes MS Office Suite

Professional Experience

SEI, Oaks, PA Aug 2014 – Oct 2024

Product Solutions Manager/Data Architect (SEI Investment Management) (2023 – 2024)

Responsible for Agile release delivery by interacting with business stakeholders to understand, analyze, evaluate the functional data needs and provide solution to developers on the business transformation project.

Demonstrated knowledge of systems architecture best practices related to business intelligence, data virtualization, master data management, and machine learning.

As a Product Owner established partnerships between stakeholders and technical staff to improve data ownership, and information sharing, maintain product backlog and manage stakeholder relationship.

Partner with business and technical teams to effectively deliver high value work with increased efficiency through process improvement and standardization.

Responsible for the development and maintenance of the Sprint artifacts such as Release Notes, Data Bulletin and process documents in Confluence which acts as a product repository for teams’ consumption.

Work on translating business requirements to technical solutions to design modern data warehouse using Azure Data Factory and Azure Synapse to deliver data analytics and AI/ML needs.

Responsible to maintain data model, data profiling to help development teams which used Azure suite including Databricks, Azure Data Lake Gen2 (ADLS Gen2), Key Vaults.

Worked on source to target mapping when any accounting system was onboarded in data warehouse. This was necessary for ETL/ELT development in ADF (Azure Data Factory) to maintain data integration.

Developed Python script to extract portfolio accounts data from data warehouse for client consumption. Used Python libraries (numpy, pandas, sklearn) to work with data frames while processing the data.

Applied Agile principles to translate product features and requirements into epics, stories and tasks through problem decomposition, and managed project tasks status updates in Jira.

Involved in the migration of data objects from EDW to Snowflake and accounting applications to MS Azure public cloud under aggressive timelines and budget.

Performed exploratory analysis of large datasets using complex SQL and Python scripts to identify anomalies and suggest business improvements around technology, operations and asset management for our clients.

Created dashboards using PowerBI to track errors and exceptions occurring during the ETL process which in turn helped reduce the exceptions by 35%.

Data Architect – SWP (SEI Wealth Platform) (2017 – 2022)

Responsible for data modeling and development of quality code based on business case and functional requirements following Agile Methodology and support project team and DBA regarding data objects.

Enhance SWP data model using ER studio for any new requirements or enhancements, or any scalability issues with increased data volumes. Maintain data warehouse flows and retrieval for reporting needs.

Make necessary changes to business logic in Oracle PL/SQL packages to support functional gaps.

Partner with technical teams to ensure team designs and delivers code in alignment with published standards.

Develop and maintain enterprise-wide data management standards, built out Data Reference Models and related artifacts detailing table/index/partitions/logs for DBA and project teams.

As a technical lead work closely with the Enterprise architecture team to suggest and implement process improvements for estimation and development of projects, help teams to prioritize their work.

Work on Archival and Purge process for data retention of online transactional data for audit purposes.

Work with the Performance Engineering team towards continuous improvement of execution times of highly complex SQL queries having aggregate functions in various batch jobs and self-service reports.

Conducted feasibility project to evaluate the use of data bricks and data lakes for SWP data warehouse.

Understanding and familiarity with Enterprise Architecture (EA) and Cloud related (AWS, Azure, Snowflakes) data architecture technologies and solutions while working on POC.

Consultant – Technical Data Analyst (through Cap Gemini) (2014 – 2017)

As a data analyst on the Private Banking Resolution team, led the technical triage, communication and issue resolution with the goal of improving technical solution for security, scalability, and performance.

Build process to review and analyze client datasets and provide client with impact lists until the code fix was implemented. Pull out Health Check Reports from database giving data anomalies.

Provide technical problem resolution and application support, as required.

Work with data migration team on data profiling tasks to onboard private banks to SEI Wealth platform.

Ensure all appropriate problem details are captured in ‘Service Now’ tool, technical severity assessed, potential resolution implemented or communicated to the SWP Technical Support Team.

Work with the Business Analyst and Incident Manager to improve the capture and documentation of Root Cause Analysis on each Priority 1 issue and evolve issue documentation in more client-focused format and language.

Identify defect trends and help prioritize enhancement to lower the production issues. Serve as the lead on enhancements driven from the “Fix It” Team to capture requirements, technical design, performance and UAT.

Create a process to provide “read only” technical review of SWP databases, middleware and UI code. Work closely with SWP technology team to gain appropriate level of data access to test production issues for triage.

Worked on various loaders to validate data flows to Data Warehouse using data mapping tools.

The Vanguard Group, Malvern, PA Dec 2011 – June 2014

Consultant – Retail Systems (through Judge Group)

Maintain Retail Order Management (ROM) application and system interfaces to business-critical Enterprise Systems and Thompson Reuters at Vanguard.

Made necessary changes to business logic in C++/Java/Oracle data model to support the Order Manager module and to analyze new requirements for hybrid and mini options, using data profiling and analysis techniques.

Expanded use of data interface (using FIX Protocol / XML) and tested ETL processes including data mapping with the market vendors or Thompson Reuters by providing additional market necessary features.

Analyzed requirements, designed specifications and implemented conversion of the IBM Web Sphere message queues to Secure MQ to comply with Vanguard authentication and authorization for financial transactions.

Participated in Daily Scrum/Agile and Kanban meetings for quarterly releases. Helped set up Kanban virtual board to be used for production support activities.

Worked on functional enhancements using HTML, Oracle PL/SQL packages and procedures with Toad and to generate critical reports for the business with proper documentation and data mappings.

Performed Log Analysis and Batch analysis using Unix Shell scripts (csh, ksh) / PERL for performance of the system to present the findings at the PRR (Production Readiness Review) meeting for Quarterly Releases.

Resolved issues related to vanguard order routing and execution to the Market centers like Citigroup, UBS on a priority basis and provided 24/7 support to business users.

Monitored resource contention which led to enhanced system performance, reported findings to the leadership.

Coordinated system testing with performance team, business leads and vendors and documented results.

Followed Agile Methodology for all the project releases and ensured development standards were followed.

Cobham Sensor Systems, Lansdale, PA Mar 2010 – Dec 2011

Systems Analyst

Support Oracle E-Business implementation suite and interfaces to business-critical applications

Involved in gathering business requirements, preparing functional and technical specifications, participated in code and document reviews, performed and coordinated system and user acceptance testing.

Performed feasibility study and conversion of legacy systems to web interface using Java and analytics tools.

Assisted during systems audit by documenting core processes and generating critical reports.

Led Product evaluation, installation and configuration management software rollout (CVS, Subversion, and RTC)

Designed and developed the Purchase Order requisitions requirements for the Procurement User to manage manual requisition and maintain business case specific QA codes extracted from Oracle ERP.

Ikea North America, Conshohocken, PA Mar 2002 – Nov 2009

Senior Systems Engineer – IKEA Customs (2006 – 2009)

As a Business Systems Analyst and Technical Lead, delivered a project for IKEA Customs to manage customs declarations, drawbacks, and amendment functions for shipments worldwide using PL/SQL, ETL and Java / XML.

Designed and developed Interfaces between third-party software (EZ-FTZ) and IKEA data warehouse.

Worked on performance enhancements of Oracle PL/SQL stored procedures (using TOAD) and forms-based user interface. Documented all source to target mappings of the columns for software maintenance.

Investigated, rectified inventory transaction errors as 50 international suppliers were phased-in Free Trade Zone.

Supported increased cost savings, proper inventory control, and improved reporting to US and Canadian customs when IKEA imported goods using global supply chain management.

Worked with customs brokers on implementation strategies for error-free operations with minimum down time.

Senior Developer – IKEA Supply Chain (2002 – 2005)

Acted as Technical Lead for GUI development and implementation of GEMINI project to integrate Global Supply Chain processes involving on-line transaction processing of Customer and Store Orders.

Improved inbound and outbound planning against decentralized ASTRO databases. Established and maintained more than 150 functional requirements for web-based UI screens developed in VB.

Designed, developed, and tested over 100 user interfaces supporting all aspects of supply chain processes from forecasting to customer shipment. Provided feedback on design and code reviews to the team members.

Defined testing approach, devised test plans and test cases and assisted team members to write regression test scripts using SQL, Pro *C and C++; helped perform system and integration testing.

Involved in deployment of pilot at IKEA warehouse in Canada; effectively addressed low-probability errors encountered within 24 hours of go-live. Planned and negotiated production rollout at two other warehouses.

Reviewed change requests with customers, provided effort estimations, and delivered system enhancements to support key business needs and KPIs.

Worked on performance enhancements of complex PL/SQL scripts and forms-based data-entry screens. Documented all source to target mappings of data objects to ASTRO for order-processing functionality.

Education

Master of Computer Applications (MCA), University of Pune, India, Summa Cum Laude

Bachelor of Science (Bachelors - BS), Statistics, University of Pune, India, Summa Cum Laude

Honors And Awards

Recipient of the National Talent Search Award, India

Contact this candidate