SUMMARY:

• Over 14 years of significant experience in various phases of software development life cycle (SDLC) and Data Management.
• Domain expertise coupled with technical expertise to perform business requirements gathering, analysis, planning, documenting, development and testing.
• Expertise in preparing the business requirements document (BRD) and workflows, business process models.
• Experienced in agile methodologies (scrum, extreme programming) as well as typical waterfall model.
• Experienced in Data migration, transfer and conversion.
• Proficient in the Business and Data process analysis, design and development.
• Experience in business process definition, risk analysis, use case analysis and process flow diagrams.
• Proficient in Unified Modeling Language (UML), Object Oriented Analysis and Design techniques and version controls to include the addendums.
• Expertise in Requirements Engineering techniques like use case diagrams, activity diagrams, process flow diagrams and sequence diagrams.
• Experience as a developer in Data Visualization using BI tools.
• Extensively worked on Tableau 7.x/8.x/ 9.2/2018.3. X (Desktop & Server), Business Objects and SSRS.
• Created Dashboards of different types for Analysis, Monitoring, Management and better understanding of the business performance metrics.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7,8,9 and Tableau 2018.3
• Extensive experience on building Dashboards using Tableau.
• Worked closely with Tableau support team during tableau server upgrades to 8.3
• Worked on data blending and increased the Dashboard performance by extracting data.
• Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Work flows, Customized Analytic s Reports.
• Worked on Informatica 9.0.1 version and has experience in data analysis, ETL techniques for loading high volumes of data and smooth structural flow of the data.
• Expertise in test process definition for all types of testing like manual testing, data migration testing and performance testing.
• Experience in integration testing, system testing, functional testing/black box testing, regression testing, GUI testing and acceptance testing (UAT).
• Proficient in SQLs to analyze the data pattern to accommodate the various business scenarios.
• Proficient in reporting the status, metrics, risks, issues and mitigation plan to various stakeholders of the project.
• Single point of contact between business users, development teams and QA teams for sign - offs and finalization of requirements.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, Linux, Z/OS and AIX.

Languages: COBOL, SQL, PL/SQL, VB, C++, C#, ASP.Net, JavaScript, HTML, XML.

Databases: Netezza,TeraData, Oracle 8i/9i, DB2, MS SQL Server and MS Access.

ETL Tools: Informatica Power Center 9.X and Datastage.

Office tools: MS Office, MS Visio, Microsoft Share Point, and MS Project.

Testing Tools: QTP 8.0, Rational Functional Tester, Rational Requisite Pro, Quality Center, Clear Quest and Bugzilla.

Business Intelligence /Reporting Tools: TABLEAU, SSRS, Crystal Reports

Version Control: BitBucket, PVCS, SVN, CVS and Clear Case.

PROFESSIONAL EXPERIENCE:

Confidential, MA

Data Migration Consultant/BI Lead

Responsibilities:

• Responsible for the Data migration from Cerner to EDW(Cloud)
• Extensively worked on Data mapping from Cerner database to EDW
• Lead and coordinated ETL development team to build the process to load data into respective target Data warehouse.
• Responsible for the data migration from Cerner databases to custom built data marts for Registry Analytics of conditions like COPD, Heart Failure and Diabetes
• Lead the BI and reporting team and developed Dashboards for various Patient Registries and reports using TABLEU
• Responsible for building Emergency Department Analytics dashboard.
• Responsible for Data Analysis comprising the Data profiling and documenting the analysis for the Data acquisition into EDW.
• Documented the Test plan and test case documentation.
• Responsible for documenting the Business Requirement/Design Document
• Responsible for creating the TRD’s/Mapping Documents.
• Performed analysis on various Pharmacy Reports and clinical reports to generate/reproduce from the EDW.
• Performed historical and incremental testing for all the data acquisition projects.
• Data Migration, transfer and conversions from CERNER to Enterprise Data Warehouses.

Environment: Netezza, Oracle, SQL, OLTP, COGNOS, TABLEAU, EDW, CERNER, CERNER INVISION,GE CENTRICITY BUSINESS, Ms Visio, Ms projects.

Confidential, WI

Responsibilities:

• Responsible for planning, design and roadmap of the data migration and integration.
• Documented the Design and Scoping Document.
• Design and document the departmental data process flows, include the IT applications, internal and external interfaces to fulfill the existing business process requirements.
• Worked on clarity tables data migration to UW EDW and create views on top of the EDW to send the vendor feeds.
• Part of delivering multiple data projects by understanding the business and technical requirements.
• Gunderson business shall be migrated from their current Payor application (Amisys) to the Quartz Payor application (Tapestry). The data team responsibility is to enhance the current downstream process to accommodate Extract and reporting requirements.
• Responsible to analyze the data need and design the data process flows, perform Data profiling, Data quality check, GAP analysis, Impact analysis and publish results with definite solution.
• Coordinate with Data Modelling team to update the Data warehouse atomic tables and provide the Mapping rules to ETL development team to enhance the current process.
• Responsible to analyze the current outbound file feeds to external vendors and update the Mapping documents to match the future needs. Coordinate with ETL development team to make the developmental changes.
• External Vendor feeds includes HRA vendors, Medical Management vendor, EOB Print vendor, PBMs, Payment Processing vendor, Dental Vendors and HEDIS data to Verscend.
• Responsible for documenting the Business Requirement/Design Document
• Responsible for updating the STT’s(Source to Target) Mapping Documents as per the new changes/modifications.
• Involved in the development of Databases to absorb the new data from another Data warehouses.
• Part of the ETL team and reporting team and responsible for development of ETL and reports using SSRS.
• Responsible for the Ad Hoc reporting from the Clarity tables of EpicCare ASAP ER module, Inpatient(ClinDoc) and Ambulatory systems.
• Responsible for updating the CMS output feed and CMS related internal Tables Mapping document and worked with the ETL team to update the column as per CMS Requirement.
• Performed Regression and incremental testing for all the changes/updates of the tables in Database.
• Data Migration, transfer and conversions across Enterprise Data Warehouses.

Environment: Epic Clarity, EpicCare Ambulatory, EpicCare Inpatient, ASAP ER Module, Netezza, Oracle,SQL, OLTP, Access DB, SSIS, SSRS, EDW, HealthLink,Tapestry, Ms Visio, Ms projects.

Confidential, PA

Data Process Analyst

Responsibilities:

• Data Migration, transfer and conversions across Enterprise Data Warehouses.
• Responsible for coordinating and initiating the project activities.
• Work on multiple IT processes in analyzing the business, technical requirements and design the future process flows.
• Responsible for facilitating JAD sessions with Work stream leads, IT leads and Enterprise Architects to define the scope.
• Responsible for documenting Vision (HLV), Blueprints and Estimates (HLE) for data extraction, reporting and rationalization process.
• Works closely with project teams and PM leadership to address IT tasks, risks and coordinate the IT project deliverable.
• Analyze the current reports. Rationalize the reports and regenerate the required reports in new platform. Developed Tableau visualizations and dashboards using Tableau Desktop.
• Analyze the outbound and inbound feeds of MSP, NMSP, Query and COBA files. Prepared mapping document for inbound/outbound feeds and CMS reports.
• Analyze the data fields required for the data cube for the business to generate reports out of the cube. Prepared the mapping document and functional specification documents.
• Analyze the application and document the current process flow and future process flow. Documented the Mapping and Functional Specifications management.
• Worked with the MDM service provider (Gaine ) which is the saas provider for all the enrollment data mastering. Documented the mapping of the data feed which is sent to Master Data Management service provider. The data is stored on the Gaine server which is accessible after the mastering of data.
• Analyzed the data and prepared the mapping documents and functional specification document to convert as per the target transfer data from an enterprise data warehouse to another.
• Analyze the data from the current source to migrate data to the new target Data Warehouses, Document and map the data fields to the new target Database.
• Created the Business and Data process modeling, Data and Business process flows of current and future states.
• Responsible for functional specification documents, mapping documents.
• Responsible for initiating, planning, executing, controlling, and delivering.
• Responsible for interacting with work stream leads in identifying the scope for file feed extraction and report generation.
• Extensively worked with TABLEAU Desktop and SSRS for various operational, client and vendor reports, was a team member in the BI Data team and involved in development of the dashboard of the company for internal reports.
• Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using SQL to provide definition, structure and to maintain data efficiently.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Created and owned the IT estimates, process documentation and traceability matrix.
• Performed requirement gathering & analysis by actively soliciting, analyzing business requirements and prepared technical Specification Document.
• Performed analysis on inbound/outbound file layouts and analyze sample data to identify the transformation rules with respect to the business logic.
• Performed data analysis and ETL techniques for loading high volumes of data and smooth structural flow of the data.
• Engaged in a series of working sessions with business and various internal /external technical teams to gather requirements for data transformation.

Environment: SQL, OLTP, Access DB, SSIS,TABLEAU, SSRS, EDW, AEDW, TeraData, MDX, HealthRules, Medical Management, Aerial,, Ms Visio, Ms projects.

Confidential, NJ

Business System Analyst

Responsibilities:

• Responsible for initiating, planning, executing, controlling, and delivering process modification projects.
• Instrumental in deriving the scope of ETL team for transforming data from source to targets as per the business users.
• Successful in managing and delivering multiple project releases.
• Build process to provide benefit booklets to new or existing members. Thunderhead system is responsible for attaching contracts to the benefit booklets before the booklets are sent to a third party Print vendor.
• Provider, member and claim files are extracted from Decare system and loaded to Dental EDW tables. Also create extracts out of Dental EDW tables as per the requirements for the use of downstream systems.
• Involved in requirement gathering & analysis by analyzing customer requirements and prepared the Technical Requirement Document (TRD) and Technical Design Document (TDD).
• Key in providing the work estimates to the business users and also documented the process and traceability matrix.
• Design and develop Tableau visualization solutions.
• Work on generating various dashboards in Tableau server using various data source
• Install upgrade Tableau server and server performance tuning for optimization.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for Tableau report development.
• Prepare Dashboards using calculations, parameters in Tableau.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing Dashboard and preparing ad-Hoc Reporting.
• Performed data analysis and ETL techniques for loading high volumes of data and smooth structural flow of the data.
• Analyzed inbound/outbound file layouts and analyze sample data to identify the transformation rules with respect to the business logic.
• Engaged in a series of working sessions with business and various internal /external technical teams to gather requirements for data transformation.
• Conducted Walkthrough sessions with Business, development team and testing teams.
• Other documents designed are data mapping documents, updating layout files and business test cases.

Environment: DB2, Oracle, SQL Server, EDW, MDM, Informatica, Power center, IDE, IDQ, SSIS, TABLEAU,OLTP, OLAP, XML, Web Services, Ms Visio, Share Point 2010, Siebel, TOAD, Thunderhead, Clear Quest, QTP and Quality Center.

Confidential

Technical System Analyst

Responsibilities:

• Responsible for initiating, planning, business requirement gathering, executing, controlling, and delivering process.
• Able to work with multiple departments in analyzing the business and technical requirements.
• Able to manage multiple mediums to moderate size Program releases.
• Responsible for interacting with the project site team and the users in Head Office in transforming data from source to target areas.
• Able to provide the work estimates to the Project owners, created and owned the process documentation and traceability matrix.
• Performed requirement gathering & analysis by actively soliciting, analyzing requirements and prepared the Technical Requirement Document (TRD) and Technical Design Document (TDD).
• Able to document XML request and response specifications. Map them to source and targets.
• Performed analysis on inbound/outbound file layouts and analyze sample data to identify the transformation rules with respect to the business logic.
• Performed data analysis and ETL techniques for loading high volumes of data and smooth structural flow of the data.
• Major responsibilities include getting requirements from the user and developing in Tableau. Maintaining proper documentation of the reports for future .
• Created complex formulas at the summary level and group level to implement the business logic.
• Extracting data from different sources connecting them and used the same to create dashboard
• Multiple data sources by joining tables and using Data Blending.
• Created Dashboards of different types for Analysis, Monitoring, Management and better understanding of the business performance metrics.
• Transformed complex data into easy-to-understand visualizations using Tableau.
• Responsible for creating the complex Tableau Reports (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Drill-down, dynamic grouping, Cross-Tab, graphical etc).
• Engaged in a series of working sessions with business and various internal /external technical teams to gather requirements for data transformation.
• Worked with the various development teams across the organisation.

Environment: Oracle, SQL, VB.Net, Informatica, Power center, IDE, IDQ, XML, Web Services, Ms Visio,TABLEAU, MSBI-SSRS, Quality Center and Jira.

Confidential, Mechanicsburg, PA

Business System Analyst

Responsibilities:

• Responsible for gaining a good understanding of user needs and accurately representing them in a well-documented software functional specifications document.
• Participated in business requirement gathering, interacted with the business users, designers and developers, project manager and QA team to get a better understanding of the business processes.
• Instrumental in creating project management documentation with to PMBOK standards.
• Involved in extensive sessions with the “End-Users” by interacting with them, by defining a questionnaire for clear understanding of end-user needs and the business process.
• Conducted JAD sessions with business and technical units to fine tune, prioritize and detail requirements and use cases.
• Implemented a hierarchical approach to classify requirements into logical groupings for, Eligibility, Providers and Claims.
• Involved in creating business process documentation. Analyzed and optimized the process, prepared business requirement document and managed requirements using Rational Requisite Pro.
• Participated in architecture analysis, UML diagrams including use case diagrams, activity diagrams, sequence diagrams, and collaboration diagrams using MS-Visio.
• Managed change of the requirements and associated requirements to other requirements for traceability.
• Involved in risk-management process whereby identified critical areas of business risk and modified the business process to reduce the same.
• Involved in drawing data flow diagrams and process flow diagrams using Enterprise Architect.
• Created Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary, Data Migration and Interface Requirements Documents. Able to update Microsoft Share Point portal with the updated project Documentation.

Environment: DB2 on Z/OS, XML, JMS, RSA (Rational Software Architect), UNIX,UML, Informatica, Cognos, Clear Case, Web Portal, Data Migration, Data Warehouse, Microsoft Share Point, HIPAA, Medicare, Rational Unified Process (RUP), Rational Requisite pro, Enterprise Architect, Rational Functional Tester and Bugzilla.

Confidential, Harrisburg, PA

Programmer Analyst

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to understand data models and requirements document
• Conducted Joint Application Development (JAD) sessions with stakeholders.
• Created mockup screens for Internet and intranet application, worked with UI team in designing of web pages of the application.
• Involved in review meetings for the changes in UI and has documented the changes.
• Updated requirement documents as per business user feedback and changes, involved in generating test plans and test specifications as per business requirements.
• Designed the architecture of the system. Setting up the development environment, VSS, database architecture.
• Team member of the business analyst and development team.
• Co ordination with users and clients for updating the project status periodically.

Environment: ASP.NET 2.0, VB.NET 2005, SQL Server 2005, MS Reporting Services 2005 Agile, Bugzilla.

Confidential

Development -Team Member

Responsibilities:

• Performed requirement gathering & analysis by actively soliciting, analyzing customer requirements and prepared the requirements specification document for the application.
• Involved in gathering reporting requirements from the business users.
• Developed information cycle diagrams, data flow diagrams, in MS Visio.
• Performed data analysis for loading high volumes of data and smooth structural flow of the data.
• Involved in coding of various modules. Updated requirement documents as per business user feedback and changes, involved in generating test plans and test specifications as per business requirements
• Involved in conducting manual and automated testing at various phases of the project development.
• Prepared test data for positive and negative test scenarios as per application specifications and application requirements and wrote test plans.
• Manually performed integration and build verification testing.
• Confidential in relational database concepts like tables, primary and foreign keys, views and referential integrity. Proficient in the data manipulation using SQL for the retrieval of data from the relational database.
• Responsible for defect tracking and reporting. Participated in the bug review meetings.

Environment: C#, .net, ASP.Net, Java Script, Crystal Reports, SQL, and MS Visio.

Confidential

Development -Team Member

Responsibilities:

• Performed requirement gathering & analysis by actively soliciting, analyzing customer requirements and prepared the requirements specification document for the application.
• Involved in Joint Application Development (JAD) sessions with various development teams for various modules.
• Created prototypes for Internet and intranet application, worked with UI team in designing of web pages and micro site for portal application.
• Involved in generating test plans and test specifications as per business requirements.
• Involved in conducting manual and automated testing at various phases of the project development.
• Prepared test data for positive and negative test scenarios as per application specifications and application requirements and wrote test plans.
• Performed integration testing, build verification testing and system testing.
• Participated in the bug review meetings. Responsible for defect tracking and reporting.
• Organized meetings to discuss outstanding issues with QA team and developers.

Environment: C#, ASP.NET, JavaScript, MS SQL and Rational Rose.