NITISH SREEPATHY
Livingston
Summary
Dynamic Lead Data Analyst with over 15 years of comprehensive IT experience across Wealth Management, Corporate Banking, Life Insurance and Annuities, Property and Casualty, Reinsurance, and Specialty Insurance sectors. Proven expertise in product management, data governance, and business intelligence analytics, complemented by a strong background in gap, impact, and risk analysis. Skilled in end-to-end data warehouse technologies and adept at facilitating functional and technical design meetings while producing extensive documentation. Proficient in Unified Modeling Language, change management, data quality techniques, as well as manual and automation testing, ensuring successful project implementation and mentoring team members.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Lead Data Analyst
New York Life Insurance
09.2022 - Current
- Led various data initiatives supporting Client Prospecting Value stream (Marketing) supporting Adobe Campaign, Fusion92, dashboards, Qualtrics and NYL.com platforms
- Created glossary/attributes/data sets, established data/system lineage using Informatica Axon data governance platform by working with data stewards and technology partners
- Performed extensive data analysis, worked with various business groups, built business logic and reconciled output with existing sources for 100 key data elements for building a new tableau dashboard (called 'One Foundational Business')
- Worked end-to-end with various stakeholders as part of Data quality management process framework covering the business need, discovery & curation, data management, issue management and compliance
- Designed data quality rules for critical data elements (Life Insurance) by measuring validity, accuracy, completeness, consistency and timeliness using Informatica Data Quality engine
- Supported regulatory/compliance division through data discovery and data mining for identification of data elements to adhere with CPPA (California Privacy Protection Agency) privacy rules, creating new client web form for customers requesting for information or request to delete
- Continuous engagement with data stewards by each data domain and business function for enterprise definitions, data quality rules/thresholds, business rules, establish key data elements, remove data silos and ensure compliance with data privacy laws and regulations
- Brainstorm and assist in creating/updating conceptual and logical data models for Underwriting (New Business) and Party/Producer/Product subject areas
- Provided inputs for the new 'Data Literacy' program - a centralized location to learn enterprise data business users, data governance officers and data tokenization process
- Extensive experience working with enterprise business systems landscape and architecture for Life and Annuity lines of business
Senior Product Manager (Consultant)
SE2 Life& Annuities (Employer: Siri Infosolutions)
11.2020 - 09.2022
- Worked end to end project on implementation of "Straight-thru processing" involving admin systems, document management system, Optical character recognition and business rules engine
- Researched, analyzed and documented various Enterprise Reporting BI tools features comparison list for decision making and vendor finalization for implementing new Enterprise BI tool
- Created roadmaps and conducted walk-thru sessions with Senior Leadership for product improvements, on-boarding of new innovative technologies and automation
Senior Business Systems Analyst (Consultant)
Everest Re (Employer: Siri Info Solutions Inc)
06.2019 - 11.2020
- Created user stories in JIRA for Certificates, Binders and Endorsements, integration with UWS, EZFLOW and DocuSign
- Assisted development team for creating new API's and housing the hyperlink in source system via IBM API Connect (https)
- Designed detailed future state flow diagram using MS Visio to show the user interaction with various integrated systems and end to end sequence of steps for generating reinsurance certificates
- Performed complex data analysis to migrate existing DB2 data to new MS SQL database
- Created and managed projects, features, epics and user stories for Withdrawal's end to end process and for introduction of new systems integration
Senior Business Analyst (Consultant)
Morgan Stanley (Employer: Siri Infosolutions Inc.)
03.2018 - 06.2019
- Performed complex statistical computation between Advisory Portfolio historical risk, historical return and Forecast data based on asset class weightings for Portfolio models/accounts analysis
- Documented Advisory business, functional and technical specification requirements including data flow, business rules, technical use cases, application programming interface details and other subject matter expert meetings
Senior Business Analyst (Consultant)
Barclays (Employer: Siri Infosolutions Inc.)
05.2017 - 03.2018
- Worked on full life cycle upgrade project - from Oracle MANTAS Anti-Money Laundering application version 5.8 to 8.0 Oracle OFSAA
- Expertise in Alerts/Case Management life cycle with scenarios, risk assignment, watch list monitoring and alert/case consolidation
- Worked on SAR (Suspicious Activity Reporting) filing, Bank Secrecy Act and other FINCEN regulations
- Validated new upgraded version of Oracle OBIEE business reports for all three regions i.e. US, Asia-Pacific and European markets
Data Quality Analyst
Sun Life Financial
09.2012 - 05.2017
- Built Data requirements document and Data Load Specification documents for adding new fields for New Underwriting application
- Worked as 'Data Domain Owner' under Data Governance team, lead initiatives for International Life & Annuities business, by defining standard business data, business rules and business use cases
- Performed all the Data Quality Processes like Data mining, Data mapping, Data profiling, Data reconciliation and Data Validation
- Led Foreign Account Tax Compliance Act (FATCA) IRS facing project, designed to prevent U.S. persons and entities from evading tax by investing directly and indirectly (through foreign entities) offshore
Business Analyst (Consultant)
American Safety Insurance/The Hanover Insurance (Employer: Geeksoft LLC)
01.2012 - 09.2012
- Managed a new system for Underwriters in Property&Casualty business
- Designed screen mock-ups/ Wire frames using Axure Pro 6.5 for Underwriting application
- Assisted Data services team with ACORD standards
Business Analyst (Consultant)
Prudential Financial (Employer: UTIS Inc.)
06.2011 - 12.2011
- Added new Rating fields to their existing source system and also enhancing some of the existing data elements in source system for Small Business Reporting purposes used by Underwriting, Actuarial and Sales
- Designed Universe(Data marts) using SAP Business Objects for Actuarial and Underwriting business reporting needs
Business Analyst Intern
VForce Infotech
05.2010 - 06.2011
- Analyzed business requirements and documented functional specifications for software development projects.
- Collaborated with cross-functional teams to identify process improvements and streamline operations.
- Leveraged SQL queries to extract relevant data from databases for further analysis and reporting purposes.
Education
Master of Science - Industrial Engineering
POLYTECHNIC INSTITUTE OF NEW YORK UNIVERSITY
Brooklyn, NY05-2010
Bachelor of Science - Mechatronics
MAHATMA GANDHI INSTITUTE OF TECHNOLOGY
Hyderabad, India05-2008
Skills
- Data Governance - Informatica Axon, Informatica Data Quality, Informatica Enterprise Data Catalog
- Reporting - Tableau,SAP Business Objects Enterprise and Infoview, IBM Cognos, SSRS, PowerBI
- Database - Oracle DB, MS SQL Server, IBM DB2, Oracle MySQL, Toad for SQL
- Testing - HP ALM, BugZero, Serena Team Track, PVCS Tracker, qTest
- Wireframes/Prototyping - MS Visio, SnagIT, Axure RP, Power BI, Sketch, Adobe XD, Balsamiq
- Dashboard - LogiXML, MS Dynamics CRM Dashboard, Power BI, MS Sharepoint
- Project Management - Rational Requisite, Atlassian JIRA Products Suite, MS Project, Trello
- Business Process Management: Camunda BPMN/DMN
- Optical Character/Image Recognition: SS&C Vidado
Accomplishments
- CEO Award of Excellence 2016 - Sun Life Financial
- Certified Scrum Master; Certification ID: 13625114411581
- LOMA FLMI Level 1 Insurance Certification
- Impact Award for Strong Contribution - Sun Life/Delaware Deactivation
Certification
- Certified SCRUM Master; Certification ID: 13625114411581
- CEO Award of Excellence 2016 - Sun Life Financial
- LOMA FLMI Level 1 Insurance Certification
- Impact Award for Strong Contribution - Sun Life/Delaware Deactivation
Timeline
Lead Data Analyst
New York Life Insurance
09.2022 - Current
Senior Product Manager (Consultant)
SE2 Life& Annuities (Employer: Siri Infosolutions)
11.2020 - 09.2022
Senior Business Systems Analyst (Consultant)
Everest Re (Employer: Siri Info Solutions Inc)
06.2019 - 11.2020
Senior Business Analyst (Consultant)
Morgan Stanley (Employer: Siri Infosolutions Inc.)
03.2018 - 06.2019
Senior Business Analyst (Consultant)
Barclays (Employer: Siri Infosolutions Inc.)
05.2017 - 03.2018
Data Quality Analyst
Sun Life Financial
09.2012 - 05.2017
Business Analyst (Consultant)
American Safety Insurance/The Hanover Insurance (Employer: Geeksoft LLC)
01.2012 - 09.2012
Business Analyst (Consultant)
Prudential Financial (Employer: UTIS Inc.)
06.2011 - 12.2011
Business Analyst Intern
VForce Infotech
05.2010 - 06.2011
Master of Science - Industrial Engineering
POLYTECHNIC INSTITUTE OF NEW YORK UNIVERSITY
Bachelor of Science - Mechatronics
MAHATMA GANDHI INSTITUTE OF TECHNOLOGY