SUMMARY:

• 15+ years IT experience including master data management, business intelligence and business analysis experience to deliver a strategic innovative information data architecture solution that consists of conceptual, information and logical modeling, integration development and reporting based on transforming business domain expert interviews, assembling and documenting business domain data requirements, use cases and user stories.
• Good technical experience with Microsoft tool stack (SQL Server, SSIS, SSAS, SSRS, Power View, Power Pivot, Power BI and Qlikview). Experience specializing in transforming XML, Flat files, or other delimited formats into RDBMS/or ROLAP.
• Experienced in three complete life cycle of EDW/BI implementations
• Expert in user interviews and create conceptual model based on the user interviews and source system analysis and convert conceptual model to physical model
• Experienced in documenting the end - to-end design of projects, working on multiple projects concurrently and will drive them through implementation, serve as a mentor to other resources and establish and drive the build out of the initial (EDW/BI) environments and data management projects
• Review business requirements, define parameters of the project
• Worked with both internal and external business partners like TPAs, MGAs and MGUs, to define customer data and analysis needs and determine deliverables based upon customer’s requirements.
• Experienced in creating ETL framework to assist tracking every ETL package execution throughout the enterprise, maintain all the configurations and audit, balance controls(ABC) in a single consolidated database.
• 12+ years of insurance industry experience and good knowledge on compliance rules like HIPAA and medical coding systems like ICD-9/10. My major strengths are Health Insurance domain.
• Thorough understanding of budgeting, forecasting
• Currently managing a team of three direct reports (data mart engineer, .net developer and Business analyst)

TECHNICAL SKILLS:

Database: SQL Server 2008/2012/2014 , SAS, Sybase ASE 12.5, SAP HANA, SAP BW 7.3, Oracle 8i/9i/10g, DB2, UDB, IMS, Teradata

ETL/Business Intelligence Tools/OLAP:: SQL Server Integration Services (SSIS), SQL Server Analysis Service OLAP(SSAS), Power Pivot, Power View, Power BI, Qlikview, SQL Server Reporting Services(SSRS), Informatica Power Center, COGNOS 7.1, COGNOS 10.1 and Talend Open Studio for Data Integration and siperian MDM, SAP BW, SribeSoft(an ETL solution to extract data from cloud based systems.

Programming Tools: Visual Studio 2005/2008, SQL data tools, .NET Framework, MFC, ADO.Net, Windows APIs, Visual Basic, PowerBuilder, Infomaker, and WebSpere Studio 3.0/5.0

Languages: SAS, SAS 9.1/ 9.2, Visual Basic, VB.Net, ASP.NET, JCL, CICS, C, C++, C#, T-SQL, PowerBuilder, SAS, PL/SQL

Other Microsoft Technologies: Expert in MS Excel 2013, MS office 2013, VISIO, MS ProjectMS SharePoint Server 2013, Microsoft Windows SharePoint Services (WSS 3.0)SharePoint designer 2007, InfoPath forms 2007, SharePoint Object Model

PROFESSIONAL EXPERIENCE:

Confidential

Risk Management Systems Manager

Responsibilities:

• Build a central repository of data (IDS) by gathering data from disparate source systems like Policy Admin System, Thirty Party data Feeds and data from data providers to facilitate reporting and Analytics
• Written business requirements to develop ETL packages to load the data in to the IDS and create numerous SSRS reports to support all lines of business in A & H
• Major undertaking was to create a Health Risk Model (HRM) using the member eligibility, coverages and paid claims. This model is to assist underwriters and actuarial staff to derive the ratings and reserve requirements. The solution was built using SSAS cube with four measure groups (Fact tables) and 12 dimensions.
• Business staff including the underwriters and actuarial use excel as front end to connect to the cube and slice and dice the data also created many reports that can assist to understand the demographics of the Policyholder and risk exposure. The same cube also help medical risk management (Nurses) to assess the potential risk and should be able to provide guidance to underwrites and actuarial.
• I have built another SSAS cube to assist Finance, Account Management and Marketing staff to assist premium tracking, receivables and marketing to assist and understand the Prospect lists/quotes and quote ratios, hit ratio and many other measures to support sales team
• I created visualizations using Power BI couple of dashboards with drilldown functionality one for each BI solution

Technical Toolset used:MS SQL server Integration Services, MS SQL Server Reporting Services, Power Pivot, Power Query, Power View, Power BI, Analysis Services, SQL Server Management studio and MS SQL server database engine 2014. Moderately used MS Master Data Services, Performance Point and ScribeSoft to extract data from Sales force cloud, ER Studio Data Architect, Visio, PowerPoint are extensively used to create Data Model, Presentations and Architecture diagrams of the solutions, MS Office was extensively used

Confidential, Princeton, NJ

Business Intelligence (DataMart) Development Lead

Responsibilities:

• Reviewed Industry standard models such as IBM and Teradata
• Worked closely with senior business executives (Actuaries & Underwriters) to understand their needs for decision support system.
• Reviewed Confidential internal and external TPA, MGA/MGU files(Excels, Flat files etc) source systems that need to be integrated for A&H reporting needs and came up with a conceptual data model that captured key elements of Confidential A&H business at a high level.
• Converted the conceptual model in to physical data model containing three major parts to it. Organizational Data - Entity Data (Party Data) - Transactional Data.
• Created Architecture Diagram which was the 'guiding force' for the delivery of project throughout the project life cycle.
• ETL Framework was created to make sure we capture Meta Data and ABC (audit, balance Control) informational. ETL Framework objective is to help reduce the package development time and maintain consistency in how developers are developing these packages.
• Wrote ETL packages to extract and load all the data from both internal & external source systems (TPA, MGA, Brokers) into an A&H central repository database.
• Communication with the executives, business domain experts and technical team to determine the business needs and architectural technical solution.
• Assisted the business analyst to assemble business domain requirements through domain expert interviews use case development, document user stories and develop sequence process flows.
• Designed conceptual, logical and physical data model for Integrated Data Store (IDS) and A&H Data Mart. Reviewed the model with all the stakeholders and got the approval to proceed. Establish and drive the build out of the initial BI environment
• Deployed SSIS Packages on to SQL server/MSDB and created SQL agent job. Daily monitoring success and failure of automated jobs, monitor system availability. Involved in the database sizing, data storage (file groups) and created the database for storing A&H Data (IDS database).
• Designed & Developed prototype solution for both Reports & SSAS cubes and reviewed the prototype with BU group. Deployed the Reports on to report server and deployed the SSAS cube on to Analysis Server and SSIS packages on to MSDB folder.
• Wrote test plans and worked with QA team to complete the QA/UAT process and signoff. Prepared the Deployment document and worked with DBA group to deploy the BI solution in to Production environment.
• Interviewed and hired the couple of BI developers in to the team. Mentored the team members on BI tools as well as the proposed architecture and BI solution approach.

Technical Toolset used: MS SQL Server Reporting Services, Analysis Services, SQL Server Management studio and MS SQL server database engine 2008 R2. Moderately used MS Master Data Services, Performance Point and SribeSoft to extract data from Sales force cloud, ER Studio Data Architect, Visio, PowerPoint are extensively used to create Data Model, Presentations and Architecture diagrams of the A&H solution.

Confidential, Newark, NJ

Delivery Lead

Responsibilities:

• Reviewed all the existing artifacts in the EDW area and lead the discovery sessions with EDW SMEs or domain experts and created an EDW Current State Architecture Document.
• Reviewed all the existing artifacts in the MOM area and lead the discovery sessions with MOM SMEs or domain experts and created a MOM Current State Architecture Document. MOM consists of 100+ web services used by internal and external client applications in Confidential .
• Based on the inventory collected during current state assessment and also based on the domain experts/SMEs lead the ICD-10 impact assessment and identified the entire program and object inventory that is impacted by ICD-10 federal mandate.
• Provided the solution options available for Confidential to remediate their EDW and MOM systems for ICD-10 compliance and also documented the strategy on remediating the ICD-10 impacted objects inventory. Strategy was aligned with downstream and upstream systems solutions.
• Worked with onshore and offshore team to review the impacted programs and created the Class D estimates for both EDW and MOM remediation efforts.
• Simultaneously worked on three projects ( ICD-10 remediation project, Master Data Management and Confidential Data Analytical Platform)
• Played key roll all three projects in the data analysis, data modeling, data profiling and also worked very closely with enterprise data architect team to review the data architecture to make sure the architecture is in compliance with requirements and meet the business expectations for the next 3 years.
• Participated on advisory role in selecting the new hardware platform for both EDW and MOM database.
• Lead the team as Technical Lead - including the PBA (project business analyst) to complete the business requirements and technical requirement documents for the remediation of both EDW and MOM systems
• Closely worked with QMO office and EPMO office to complete the BRDs/TRDs and RTM(Requirement Traceability matrix)
• Business Driven Assessment - Top down Methodology combined with all information gathered. Strategic Direction linked to Key Business Challenges.
• Data and Analytic Requirements, Source System Mapping. Major Corporate Business Goals & Objectives Identified During the Assessment
• Documented Key Business and Information Process Challenges. A consensus of the Top Key Information Related Challenges mentioned by the business executives, KPI’s and Metrics mentioned by the business executives
• Future State Architecture recommended with 3 year road map.

Technical Toolset used: MS SQL server SSIS packages, SSRS reports, SSAS cubes, SQL Server Management studio and MS SQL server database engine 2008 R2, SAS proc SQL, SAS data mart, DB2 on IBM midrange AIX box, COGNOS 10.1 framework manager and reports. Informatica ETL, MS Office Suite was extensively used for project planning, Visio diagrams, Architecture diagram and Power Point & MS Excel was for presentation.

Confidential, New York, NY

Sr BI Developer/BI Architect

Responsibilities:

• Acquired & Implemented: SQL Server 2008 and 2008 SSIS as ETL tool for Extracting Data from SAS DW, Excel Files, and Text files from external vendors.
• SSIS was extensively used for Data Cleansing, Change Data Capture and Load the Data into Staging area of the SQL server and then to BI Data Mart (Facts & Dimensions).
• Participated in discovery session with business to obtain, understand and document Business Requirements for the user analytics.
• Translated the business requirements in to technical specifications, and detailed design, Lead the sessions with both business and IT to review the BRD/TRDs and obtain the approvals
• Designed & Developed prototype solution for both Reports & SSAS cubes and reviewed the prototype with BU group.
• Wrote test plans and worked with QA/UAT team to complete the QA/UAT process prepared the Deployment document and worked with DBA group to deploy the BI solution in to Production environment.
• MS SQL server SSIS packages, SSRS reports, SSAS cubes, SQL Server Management studio and MS SQL server database engine 2008 R2. Also moderately used the following tools: MS PerformancePoint, Master Data Services
• ER Studio Data Architect, MS Visio, Excel, PowerPoint and MS Project

Confidential, Philadelphia, PA

Sr Business Systems Analyst

Responsibilities:

• Built RMS - revenue cycle management system
• To review & perform retroactive adjustment submissions to CMS retroactive adjuster to maintain & validate vendor cash flow, to load providers charts & conduct survey’s
• Load monthly MMRs using SQL server packages (SSIS)
• Load monthly govt files on monthly basis using automated job ( SSIS)
• Extract RAPS data and prepare the extracts for CMS submissions
• Process the return file from CMS and populate various tables in RAPS database.
• Receive electronic files from vendors (Claims files) and process against our RAPS database.
• Validate vendor monthly cash flow statements using the Medicare Risk Adjustment Model.
• SSIS packages and SSRS reports are extensively used for loading files in to central database and creating and automating monthly finance reports.
• Created a Process using CMS Risk Adjustment Model to validate CMS Risk Scores for our Medicare Members and also calculated projected monthly payments, Interim & Final Payments.
• Created and updated User manuals, Tip-sheets, Instruction documents, Installation steps, operational procedures, change request document, Impact analysis documents, version control procedures and lesson-learnt documents.
• Wrote & Modified SAS programs to calculate Medicare Member Risk Score to validate against the CMS risk score also to validate vendor monthly cash flows.

Technical Tools/Software Programs: VB.NET 3.5, .NET Framework 3.5, SAS, VS2005,2008, MOSS 2007, SharePoint Designer 2007, Business intelligence Studio, SQL Server management Studio, SQL Server Reporting Services (SSRS), MS SQL server SSIS packages, SSRS reports, SSAS cubes, SQL Server Management studio and MS SQL server database engine 2008 R2.

Sr.Systems Analyst

Confidential

Responsibilities:

• Work with Business team to better understand business requirements, complex change requests and Production issues.
• Participates in developing application scope and objectives and preparing functional and/or technical specifications.
• Coding as per BRs, PCRs & Production issues
• Coordinate with Test team, Defect tracking using HP Quality Center, resolve or respond to defects posted in HP Quality Center.
• Work with Production Support and management for scheduled Production deployments
• Source code maintenance using PVCS for source control
• In addition Medicare Enrollment application I was also responsible for maintenance and support of couple of other existing PowerBuilder applications
• Medicaid Application > Is used to outreach members to verify whether the member’s dual eligible, Outreach, re-determination, Income source, program limit, in addition to COB survey and reporting.

Software: PowerBuilder is used for the front end application and Oracle PL/SQL is used for supporting back end database. PVCS, HP Quality Center is used for Defect Logging & Tracking