Objective

Seeking a senior position where my experience, leadership, concise ideas and ability to execute on them will be complimented by an inspiring environment with opportunities for further career growth.

Background

Diverse background with 16+ years of accumulated experience providing solutions in various Technical and Business areas. Effectively performed various leadership roles such as Technical Lead, Data Analyst and Business Systems Analyst and Product Owner.

Working experience as onshore techno-functional Project Lead and Product Owner responsible for:

orequirement gathering

ooutlining issues and suggesting work arounds for projects by performing analysis on datasets

odefining business requirements by conducting meetings with stakeholders

ocreating Business Requirement Document (BRD), Business Impact Analysis (BIA), Source to Target Mapping (STM) documents.

oconstructing workflow charts and use case diagrams to support the requirement evaluation.

Agile Methodologies followed with all the Agile ceremonies like Sprint Planning, Estimations, Daily Scrum, Sprint Review, Sprint Retrospectives.

Creating Product Backlog, writing detailed User Stories for engineering team in JIRA

Structured walkthrough meetings, brainstorming sessions conducted to make engineering trade-off decisions to adhere to timelines.

Strong experience in managing International projects with Database development and administration having experience with Snowflake, PostgreSQL, SQL Server 2012/2016, MSBI solutions – SSIS, SSRS, Power BI, and Data warehousing being the key fortes.

Extensive experience with SQL Server and building complex T-SQL queries, performance tuning, and maintenance of SQL code with outstanding troubleshooting capabilities.

Expertise

Product Management

Business Analysis

Requirement Gathering

Cross functional Team Management

Agile Methodologies

Business Intelligence

Data Analysis and Development

Domains

Healthcare

Insurance

Energy Services

Banking

Assurance

Programming Languages / Software / Databases

Snowflake

Microsoft SQL Server 2016/2018

Microsoft BI (SSIS/SSRS)

PostgreSQL

Azure SQL

Atlassian JIRA

Power BI/Power View

MS Excel

Team Foundation Server

Education

Master of Sciences (M. S.) in Software Engineering – BITS Pilani, Rajasthan, India. 2009.

Bachelor of Science (B. Sc) in Computer Science - Mumbai University, India 2005.

Strengths

High level of self-motivation, attention towards detail and readiness to learn and grasp new technologies quickly.

A self-learner with fine grasping skills.

Exceptional verbal and written communication skills with ability to make people understand and convince them.

Ability in meeting deadlines and deliverables while achieving excellence and quality of work.

Ability to lead group of people efficiently.

Professional Experience

CitiusTech Healthcare Technology Pvt Ltd (December 2019-Till Date)

January 2022- Till Date. Onshore Business Systems Analyst for Health Solutions Company

Technologies: Snowflake, Atlassian JIRA, MS Excel, Team Foundation Server

Onshore Business System Analyst responsible for gathering technical requirements, production implementation, status reporting, managing offshore team, providing work estimates and regular time tracking, managing business vendor communications etc.

Deliver technical design documents for Snowflake-based data architecture.

Analysis of data systems that involve solving complex business problems in an agile environment.

Provide consulting support for IT and Business Partners by researching, identifying and solving technical problems.

Build data lineage between multiple internal and external data systems.

Data modelling to ensure that the platform supports evolving data structures for future business needs.

Implement optimized queries to reduce data warehousing operational cost.

Responsible for deliverables related to requirement analysis, system analysis, source code documentation, test case development, testing and other documents.

Meet established deadlines while maintaining high level of quality of deliverables.

June2021-December2021. Solution Architect for FHIR Repository on Snowflake

Technologies: Snowflake, FHIR r4, Team Foundation Server

Design and develop FHIR Repository structure on Snowflake DB.

Develop complex stored procedure in Snowflake to convert relational data into FHIR compliant JSON format.

Flatten the FHIR compliant JSON into desired relational format for report ingestion.

Led diverse teams to collaborate to achieve the project success.

May2021-June2021. Data Analyst for FHIR API Migration

Technologies: Oracle 20.4.1.407, FHIR r4, Team Foundation Server

Extend FHIR r3 mappings in the API to FHIR r4

Gathered the data mapping requirements from existing API and converted them in standardized FHIR attributes.

Finalized the data mapping for pulling data from source/partner database into FHIR Repository.

Provided suggestions for FHIR extensions to accommodate the client data as per requirement.

Designed the sample JSON documents as per FHIR standard to aid requirement interpretation.

Participated in all phases including requirement analysis, client interaction, design, coding, testing, support, and documentation.

July2020 – April2021. Data Analyst and Designer for FAST+ Consent Management System

Technologies: SQL Server 2017, PostgreSQL 9.0, GitLab, Visual Studio 2017, SSDT, SSIS

Customized and deployed the FAST+ framework to align with client business requirements, data sources, and device needs

Used WSO2 API Manager to manage API life cycle

Designed the Adapter pattern module to access DB data from API

Designed and developed SQL SSIS Packages to extract data from various data sources such as ODS, EDW into PostgreSQL for further Data Analysis and Reporting

Finalized the data mapping for pulling data from source/partner database into FHIR Repository

Analysed and provided suggestions for implementation of security labelling in FHIR resources

Implemented ETL optimization technique by applying advanced Database and SSIS concepts to achieve high performance in data ingestion process.

Involved in the end-to-end installation of FAST+ solution and validation

Provided technical solutions for various integrations projects across existing applications.

March2020 – June2020. Data Analyst for Medical Records Review

Technologies: Azure SQL, SQL Server 2017, SQL Profiler, GitLab

Developed the SQL queries to incorporate the business logic to extract data.

Worked on performance tuning of long running stored procedures.

Hexaware Technologies Pvt Ltd (April 2010 -December 2019)

May2016 – November2019. Technical Architect/ Team Lead for Assurance Application development.

Technologies: Microsoft BI Technologies (SSIS / SSRS), Power BI, SQL Server 2016, SQL Azure, Team Foundation Server

Gather requirements and create Business Requirement Document, Business Impact Analysis document for the project.

Performing the role of Team Lead for the current assignment and handling the project from offshore singlehandedly.

Involved in the complete life cycle of the new engagement right from Project kick off, Project Planning, and Resourcing up until set up of the offshore development centre.

Worked closely with the client stakeholders including the IT teams, Business Analysts, Project Managers to get the knowledge transfer of the existing systems.

Involved in Database modelling and Architecture up gradation activities.

Design normalized database from scratch for a new application. Create/Modify and maintain SQL stored procedures, jobs, indexes etc.

Lead a development team to create reporting solutions using SQL Server Reporting Services, Power BI and Power View in Excel.

Performing hands on development in setting up ETL processes using MSBI technologies of SSIS and SQL jobs.

Controlling project scope and Quality control activities.

Manage Release delivery, Timesheet Management, Weekly status updates from team members.

January2016 – April2016. System Analyst for Insurance Application support.

Technologies: Microsoft BI Technologies (SSIS / SSRS), Dot Net, SQL Server 2012, Team Foundation Server.

Performing the role of System Analyst for the application.

Involved in designing and creating ETL and report templates for development, creation of custom components for financial calculations.

Automation of quarterly monotonous job of uploading data in database by using Excel VBA for ease of use.

Designed various utility SSIS solutions catering to the automation needs of the client.

Provided technical solutions for various integrations projects across existing applications.

January2013 – September2015. System Analyst for Art Insurance Management Application.

Technologies: SQL Server 2005/2000, Microsoft BI Technologies (SSIS / SSRS), Visual Basic, Visual Source Safe

Maintenance of ARTIST application that was a metadata driven application based on Client-Server architecture.

The application was being widely used across 5 countries but the client had minimum knowledge on the technical and functional front owing to lack of documentation.

Carried out the re-engineering of the code and documented the key functionalities of the application.

Create, modify and maintain SQL stored procedures, triggers, indexes, jobs.

Designed an automated reporting solution using SSIS and SSRS which was capable to upload data to run business processes required for around 100 business users across 5 locations across the globe.

Suggested various value additions for the client and was successful in implementing most of them.

April2010 – June2012. Sr. Software Engineer for Energy Services Application.

Technologies: SQL Server 2005, Microsoft BI Technologies (SSRS), Atlassian JIRA Issue and Project Tracking, Visual Source Safe

To Interact with the Client and understand and formulate their requirement definitions.

Deployment of application, database deliverables on Test as well as production environments.

To perform Analysis, Code Development, peer code review and testing.

Involved in writing Complex SQL queries and developed procedures, functions, cursors and triggers. Also involved in trouble shooting activities pertaining to databases.

To design SSRS reports to accommodate the customization requirements of the client.

Creation of migration scripts required by Client during Project Closure.

Responsible for Project Closure activities like documenting migration of application, DB Scripts for transition, taking DB and VSS back up.

Security and Back up coordinator for the project and responsible for audit related activities pertaining to the project.

Wipro Technologies Ltd. (September 2005 to March 2010)

January2009 – March2010. Software Engineer for Securities Web Application

Technologies: SQL Server 2005, ASP .Net, AJAX, SVN Tortoise

Analysis and maintenance of client web application.

Unit Testing and fixing of errors/bugs by replicating scenarios in Development Environment.

Managed application and client side Oracle interface singlehandedly with effective communication with Client.

Contributed in development of automated in-house tool for maintaining Test Data for unit testing.

September2007 – November2009. Software Developer for Insurance Application

Technologies: SQL Server 2000, Microsoft Access 2003, Visual Basic 6.0, Visual Source Safe

Development and Maintenance of the MS Access 2003 application used by clients for managing trusts, quality control.

Involved in the application development and support related activities as an individual contributor.

Responsible for documentation of the project and introduced the low-level design document for each change request.

December2005 – July2008. Software Developer for Banc Assurance Business Application

Technologies: SQL Server 2000, Data Transformation Services, Visual Basic 6.0, Mercury Quality Centre, Visual Source Safe

Development and Maintenance of the VB and SQL applications used by clients for compliance monitoring, commission calculation.

Maintenance and enhancement of database objects like DTS, SSIS, stored procedures, user defined functions, cursors, views and indexes

To customize modules and develop new templates in the module as per client requirements along with Bug-Fixing.

Preparing Lower Level Design Documents, preparing bi-traceable matrix and handover documents for Support team for new enhancements.

Document the Impact analysis study for the various bug fixes and enhancements.

Supporting the System Integration Testing and User Acceptance Testing phases.

Contact this candidate