SUMMARY:

• Qualified professional with more than 7 years of extensive experience in the field of. Data Analysis working with the technical staff to implement management and staff's business requirements into the software application in Healthcare Industry. Analyst in Data warehousing, Business Intelligence (BI) Solutions design & development. Business Intelligence area dealing with data analysis, solution design metadata management and MDM.
• Strong experience with demonstrated success in the Database Design, development of SQL Server 2005/2008R2/2012.
• Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms.
• Adequate knowledge in Health Administration - Claims processing (auto adjudication), COB, EOB/Drafts, Claims pricing and testing, HIPAA, enrollment, EDI, Medicare, Medicaid, CDHP (consumer driven health plans).
• Specialized in Business Intelligence, involving Planning, Analysis, Designing, Implementations and Maintaining Spotfire Solutions as per company standards.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Skilled inTableauDesktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot table, scatter plots, pie charts and packed bubbles and also use multiple measures for comparison such as Individual Axes, Blended Axes, and Dual Axes
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Strong proficiency in all phases of SDLC (Software Development Life Cycle).
• Experience working with different Databases like Oracle 11, Oracle10g, Oracle 9i/8i, SQL Server 2005/2008, Teradata, Netezza, Vertica and MS Access.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Designed schemas. Built tables, FKs, PKs, etc. by providing a structure that meets the business needs.
• Extensive experience in administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems
• Excellent understanding of data mining algorithms, high performance and optimal algorithms.
• Experience in Teradata Enterprise Data Warehouse (EDW) and Data Mart.
• Excellent Knowledge in Electronic Medical Record (EMR) / Electronic Health Records (EHR) modules and process flow.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Creating SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Strong knowledge on HL7 standards (v 2.5 through 2.7), HIPAA (Health information portability and accountability act), ICD-10 - International Statistical Classification of Diseases and Related Health Problems.
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Drill-through, Top N, Summary, Form, Lists, Sub reports, Matrix Reports and formatting them.
• Experienced in working with Star Schema modeling to develop ROLAP/MOLAP Cubes using SQL Server 2005/2008/2012 Analysis Services.
• Good knowledge on Tableau, Qlikview, Informatica, Data Stage, Power BI and Teradata.

TECHNICAL SKILLS:

SDLC Methodologies: Agile Scrum, Waterfall

Modeling Techniques/Tools: Flow Charts, Use case diagrams, Data Modeling, ER Diagrams; MS Visio, TFS,SVN

Languages: TSQL,UML, C#, .NET

MS Office Suite: Word, Excel, PowerPoint, Access, Outlook, Project

Reporting Tools: SQL Server Reporting Services (SSRS), MS Excel, MS Access, Power pivots, Power View, Tableau, Share Point, Power BI.

ETL and Analysis Tools: SQL Server Integration Services (SSIS),Informatica, Data Stage, DTS 2000, SQL Server Analysis Services (SSAS) Multidimensional Cube, Tabular Cube, MDX, DAX

Project Management/Others: MS Visual Studio, MS Project, MS SharePoint, Snipping Tool, WebXtender DMS, Igrafx

RDBMS: MS Access, SQL server 2000/2005/2008/2012, 2014, Oracle, MS Visual Studio 2008/2010, SQL Server Profiler.

WORK EXPERIENCE:

Sr. Data Analyst/Modeler

Confidential, Boston, MA

Responsibilities:

• Gathering and documenting the requirements in Requisite Pro those are critical to the business mission and using those requirements to design application software using a Use Case approach.
• Created EDI documents for EDI maps to generate requirement documents and Project Charter, and logical design documents for EDI transactions and code sets.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Worked on changes for HIPAA Transaction from version .Documented the detailed business as well as technical requirements to upgrade the current system to 5010 transactions.
• Experienced with HIPAA - 4010/5010 standards. Propose strategies to implement HIPAA 4010 in the new MMIS system & eventually move to HIPAA 5010.
• Experience with AGILE Tool and methodology. Responsible for the full HIPAA compliance lifecycle from gap analysis, mapping, implementation and testing for Medicaid Claims.
• Implemented a MDM process to take strategy to roadmap and design development activities. Delivered MDM roadmap & MDM Architecture.
• Involved in Database Normalization, Optimization and Tuning, Data Import/Export, Troubleshooting, Database Objects authorization, DTS, ETL using DTS (SSIS), Objects Creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures.
• Built various packages in SSIS to load the data and used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Created EDI documents for EDI maps to generate requirement documents and Project Charter, and logical design documents for EDI transactions and code sets.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Implemented a MDM process to take strategy to roadmap and design development activities. Delivered MDM roadmap & MDM Architecture.
• Involved in troubleshooting of existing SSIS Packages by reviewing Data Source/Destination Configurations, transformations and data type conversions.
• Worked on designing and building data load procedures, using MS SQL Server SSIS.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Upgrade collateral around specific investment management products through deep understanding of data visualization usingTableau.
• Providetableauvisualizations to monitor the timing of launches to meet client expectations for product offerings.
• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Developed various kinds of interactive reports like Drill Down reports, Aggregate reports, reports containing parameters and groups. Also, developed Matrix, Chart and Graph reports.
• Developed ad-hoc reports using Report Builder.
• Developed Report Model so that the end users can create their own reports using Report Builder.
• Published reports in PDF, Excel, CSV formats.
• Deployed SSRS reports into SharePoint Server.
• Scheduled reports to be generated on predetermined time.
• Involved in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Created and monitored the jobs to perform tasks such as Database cleansing, backups, data loading.
• Played the vital role in the team.

Environment: SQL Server 2014/2012,SSIS,SSAS,MDX, Power Pivots, SSRS, Windows Server 2012, IIS, .NET, Enterprise Manager, SQL Query Analyzer, ASP.NET,TFS.

Sr. Data Analyst

Confidential, St. Louis, MO

Responsibilities:

• Interacted with the client as part of the Requirements engineering team to understand the reporting requirements and finalize the project scope.
• Performed In-Death analysis of systems and business processes of Medicare Part D as per CMS rules and procedures.
• Migrated SQL Server 2000 DTS packages to SQL Server 2005 SSIS by running upgrade advisor tool against DTS packages, troubleshooting issues and converting into SSIS through DTS migration wizard.
• Involved in creating dashboards and reports inTableauand Maintaining server activities, user activity, and customized views on Server Analysis.
• Designing and building data load procedures, using MS SQL Server SSIS
• Extracted data from various sources like DB2, Oracle, Flat files, and XML files and loaded them into Fact and Dimension tables of data warehouse
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Developed Stored Procedures, Functions and Database Triggers.
• Developed various reports using SQL Server Reporting Services (SSRS) and Landscape reports.
• Extensively developed Oracle PL/SQL stored procedures using TOAD to implement different business logics and perform backend testing (Oracle 9i) to verify the transactions and business logic.
• Developed Complex reports using SSRS and created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created datasets using stored procedures and reports using multi value parameters.
• Created sub reports, bar charts and matrix reports.
• Developing a Report as per user requirement using MS Reporting Services
• Published reports in PDF, Word and Excel formats.

Environment: SQL Server 2008 R2, Windows 2008, C# 3.0, .NET 3.5, Excel, TSQL, MS Visual Studio 2005/2008, SSIS, SSRS.

Data Analyst

Confidential

Responsibilities:

• Performed In-Death analysis of systems and business processes of Medicare Part D as per CMS rules and procedures
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements
• Wrote Test Cases in MS Excel for user registration, access to material, and activity log-in, reviewed the test cases and finalized.
• Involvement in Development, design and implementation of Intranet based web portal system for handling all the necessary database requirements.
• Creating Stored Procedures that helped speed up the application, as front-end programming was eliminated.
• Used XML extensively in the Stored Procedures.
• Designed DDL and DML for MS SQL Server 7.0.
• Created and managed schema objects such as Tables, Views, and Indexes.
• Involved in writing SQL batch scripts.
• Created Stored Procedures and functions.
• Involved in writing Stored Procedures, Functions, Triggers, Views and Indexes in SQL Server 2000.
• Extensively used SQL Server Reporting Services to generate the reports.
• DTS was used to bring information from other data sources into their database on a nightly basis. The other sources consisted of Excel spreadsheets and text files.

Environment: MS SQL Server 2005, MS Word, Power point, TSQL, IIS 5.0/4.0, VB.NET, XML, DTS, SSRS

Data Analyst

Confidential

Responsibilities:

• Worked according to the software development life cycle.
• Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users (who are also Fifth-third employees).
• Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder
• Wrote the test cases and technical requirements and got them electronically signed off.
• Created new reports based on requirements.
• Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders.
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
• Interacted with teams in AFS, ACBS and infolease to extract the information for the reports.
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Created Report-Models for ad-hoc reporting and analysis.
• Created Logical/physical Data Model in ERwin and have worked on loading the tables in the Data Warehouse
• Worked extensively with the ERwin Model Mart for version control
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Provide 24 x 7 problem management support to the development team.
• Document various Data Quality mapping document.
• Perform small enhancements (data cleansing/data quality).
• Performed data analysis on the existing data warehouse's of AFS, ACBS and infolease.
• Worked on daily basis with the main frame team and lead data warehouse developers to evaluate impact on current implementation.
• Communicated with the third party vendor to do the programming.
• Upgraded the present application by adding new functionalities and adding new reports.
• Wrote regression test cases, did smoke testing with users.
• Coordinated (with business users, data base administrator, mainframe team and testing team) in mirror to production testing.
• Collected useful requirements to design the model calculating return on investment on the life settlement policies and presented it through Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio to the next level of teams.
• Conducted User Acceptance testing (UAT) and worked with users and vendor who build the system.

Environment: MS Office 2007, MS Visio 2003, Windows XP, AFS, MS Excel, SharePoint, PowerPoint, MS Project, UML, SQL Server, Erwin, Business Objects, MS Outlook