SUMMARY:

• 8 Years of experience in analyzing, designing and developing client/server, Business Intelligence (BI) database applications, Requirement Elicitation, Data visualization, Analytics, Data Integration and related database Platforms in Clinical, Healthcare and service sectors.
• Experience in Gathering, Assimilation, Organization, Categorization and Analysis of Business Requirements to create corresponding designs of Logical and Physical Data Models - ERstudio such as Client interview and conducting Joint Application Development (JAD) Sessions.
• Strong background in Software Development Life Cycle (SDLC) Process and agile methodology with excellent analytical, programming and problem solving skills.
• Experience in Data warehousing ETL experience of using Informatica power center Client tool - Mapping designer, Repository Manager, and Business objects.
• Possess a strong background in database management and data analytics, in database tools such as Oracle sql developer.
• Extensive experience in Tableau Desktop 9.x, 10, 10.3, server and Tableau Reader of 6.x/7.x.
• Strong experience with Tableau data visualization, dashboard, guided analytics, story presentation and Cognos Connection - Developing Reports in Cognos Connection 8 and 10.
• Strong skills in connecting forms in VB to SQL by analyzing the dependencies of the Tables.
• Extensive knowledge in various reporting objects in the Oracle SQl database by analyzing, views, M views and Stored Procedures.
• Expertise in installing and upgrading the database server and application tools.
• Extensive experience in reporting objects like facts, attributes, hierarchies, Transformations, filters, prompts, Calculated fields, sets, Groups, Parameters in Tableau.

TECHNICAL SKILLS:

Databases: Oracle 9i/10G/11G; SQL server 2000/2005/2008 R2/2012. Ms Access,CMR Excel, LIMS, PDSM, RT.

Programming Languages: Transact - SQL, SQL, PL/SQL, Teradata, Visual Basics (vb) and HTML.

Operating Systems & Testing Tools: Windows NT/98/ 2000/XP/Vista/2003, MS - DOS. HP ALM.

OLAP/Reporting Tools: SSAS, (SSRS), MDX, Crystal Reports, Tableau Versions. Oracle coherence Cache.

Data Modeling: Star Schema Modeling, FACT, Dimension Tables, Erwin,Physical and logical data modelling, Kimball

PROFESSIONAL EXPERIENCE:

Confidential

TECHNICAL ANALYST

Responsibilities:

• Gather and analyze data in support of business requests, proposed projects, business requirements and their conversions to Functional and System Requirements.Analyze business workflows, technical requirements to create and refine user stories for the project, using confluence and visio for the workflows. Understanding the CMR work flows internally with various other service teams and that with external trading systems - such as Opics, Fenics, Calypso & VFX. and coordinating the dependencies accordingly by using Oracle SQL Developer.Analyze data gathered and design potential solutions for integration, collaborate with business partners to ensure Client data standardization.Identify, collect and communicate information on issues related to the system, reports, or procedures, and manage resolution to the issues for all the environments from UAT, SIT, PFIX and PROD.Understanding the usage of Mviews and views in the cmr database and removal of data in accordance with the view dependency.Involved in UI modifications, and making its corresponding database changes, ensuring the corresponding Cache changes for external systems followed by its testing in the CMR application.
• Created various Fsd for the stored procedure modifications, and its associated triggering Autosys Jobs which are scheduled on daily and weekly basis.
• Align data, analysis, review stored procedures, sort dependencies of the tables for the functional documents followed by support in Coding and Testing.Develop reports, dashboards, and advanced visualizations. Works closely with the product owners, business analysts, and IT to understand the needs / requirements and develop visualization as needed using Tableau.Accurately assess the risks associated with each solution design in CDM and Geode project by Using CMR and Oracle database applications.Support user acceptance testing efforts by analyzing the defects assigned to me using HP ALM.Involved in modelling the Game plan, scheduling calls for the game plan till testing by product team and ensuring game plan sucess for the deployment of R4.2017, R1.2018 and patch release of R2.18 from PFIX to PROD.

Confidential, MEM, TN

DATA ANALYST/PROJECT LEAD

Responsibilities:

• Working as a Subject Matter Expert (SME) on PDSM project (Process Driven System Management) identified and interviewed business users to collect requirement and drive the DPI team from RT to PDSM migration.
• Envisaged and worked as a System Analyst in deploying Performance Guard application by drafting project deployment and Reporting the FedEx Standard PC, functions of the MCD.
• Engaging in Performance Guard project to automate it and built consensus with IT partners to provide necessary automated downloads from the server.
• Coordinating with the application Owners, in tuning the tool matching the business needs, this in turned helped the ticket resolution time by 40%, network enhancement by 15%.
• Designed Dashboards and created interactive Data Analytics solution using Technology aided tools like Tableau to analyze incoming data in Request Tracker and PDSM.
• Designing of multi-layer forms using designs and layouts in VB.
• Ability to maintain and manage Tableau driven dashboards, working on large amounts of data aggregation and a proactive approach to support various reporting initiatives in Tableau.
• Worked on building queries to retrieve data into Tableau from SQL Server 2008 and Teradata SQL Developer, and developed statements for loading data into Target Database.
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the BRD.
• Profiling, cleansing data from various sources, using Teradata studio express and producedthestandardmonthlyreportstocoverkeyareas using Tableau dashboard.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Participated in refinement and technical documentation of database by working with Technical Analyst, Development Team for SQL reporting requirements in PDSM.
• Monitoring the workstations PCI Compliance, .com Data - with organization network using BI Tool - Tableau.
• Generated the dashboards with Quick filters, parameters and sets to handle views more efficiently.
• Created Performance Metrics using Quantitative Analyst and Benchmark Scorecard evaluating the team performance using MS Excel, SQL, Access and Tableau, which helped executives gain actionable insights.

Confidential, FL

DATA ANALYST

Responsibilities:

• Design, create and validate studies in Oracle, Clinical data extract views, view templates and annotate CRFs
• Implemented Quality control procedures to ensure efficient database operations.
• Converted various Business logics into rules via SQL which essentially used as a Validation queries.
• Worked with reporting professionals for creating SQL views and altering some of the dimensional tables to satisfy their reporting needs.
• Developed and optimized database structures, stored procedures, Materialized views, DDL triggers and user-defined functions.
• Optimize the performance of the queries with modifications in Pl-Sql queries with Tables, joins, Indexes.
• Used Visual studio and SQL server for the analysis and development of online systems.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• End to end experience in designing and deploying reports/data visualizations using Tableau.
• Handled large sets of data on various reports by analyzing and tuning SQL Queries. Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Loaded data from various sources like Access database, medical files (like Patient Medical Records, Blood tests, Urine test results, X-ray results etc.; ) into ORACLE staging area and developing workbooks from multiple data sources using Tableau

Confidential, PA

BUSINESS ANALYST

Responsibilities:

• Worked with BA’s, other developers to understand the existing system and Created ER diagrams using Microsoft Visio 2010 and developing OLAP cubes.
• Improved the clinical data warehouse model through sound detailed analysis of business requirements and analyzing its impact across the warehouse systems.
• Created and maintained the data model repository as per company standards - Implemented ER models and Dimensional models
• Performing statistical analyses to determine effectiveness of clinical programs (e.g., pre-post analysis, clinical trial results), followed by Performance tuning in the context of dimensional design by creating Mini Dimensions thus providing smaller entries in to the Fact table. (Inpatient /Therapist data marts).
• Used Joins and subqueries for complex queries involving multiple tables from different databases and helped report developers in designing OLAP models for report applications.
• Applied data cleansing / data scrubbing techniques to ensure consistency among data sets.
• Developed reports for disease specific Indexes such as Foot and Ankle Disability Index ( FADI), Activities of Daily Living Scale (ADLS), and the Disabilities of the Arm, Shoulder, and Hand (DASH) using Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server and defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.

Confidential, NY

BUSINESS ANALYST

Responsibilities:

• Extracted data from Oracle and SQL Server Using Oracle Sql Developer data modeler to load into a single data warehouse repository.
• Requirement gathering of claims product, clinical data for logical data modelling design.
• Design and develop SQL database scripts, develop process to manage database DDL & DML changes, managing interactions between dataware house and Data Mart.
• Used VB scripting along with excel, access to extract the data.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Design and deploying database structures, forms, reports and queries, produce ad hoc queries and developing reports to support business needs.
• Analyzed the Data sent by the Vendor Caremark, designed and developed data models for operational data source (ODS).
• Constructed the reports page for internal strategy group with standardized custom right and left side sections within Tableau
• End-to-end ETL (T-SQL) development of the Data Mart. Designed and developed SQL for data loads.
• Extracting the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input to Tableau.
• Generated data extracts in Tableau by connecting to the view using Tableau MySQL connector.

Confidential

DATA ANALYST

Responsibilities:

• Designing and implementing new requirements in the DWH system, ensuring data movement schedule and quality.
• Used Model mart of Erwin for effective model management of sharing, dividing and reusing model information and design for improving productivity
• Developed various SQLs to analyses data in application systems and extensively used LIMS to extract data and convert into the required format for Reporting purpose on routine schedule.
• Assisted in development of data formatting and cleaning criteria from various data sources.
• Efficiently managed care data for various clients, following the DCR - change request to programmers and Testers.
• Maintaining database authentication modes, got on RDBMS Concepts and models.
• Responsible for the complete data management life cycle from pre-phase till protocol lock.
• Ability to prepare test data by executing SQL queries and Joins.

Confidential, NJ

SQL DATA ANALYST INTERN

Responsibilities:

• Working within a growing knowledge of X12 4010 HIPAA 837I, P, D, 835, 834, 820, 270, 271, 276, 278, EDI, Privacy, Security, and Medicaid.
• Installed and configured Cognos for creating multiple dashboard reports, created list reports and cross tab reports using Cognos.
• Developed plan for data feeds and data mappings for integration between various systems, including XML, to follow ICD 10 Code set and ANSI X12 5010 formats and predicatative SPSS analysis.
• Consulted with healthcare third-party Administrator Company to develop conversion specifications for member, enrollment, and authorizations.
• Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims.
• Effectively used Clinical coding systems like ICD-9, Procedure (CPT) and Diagnostics (DRG) Codes. Involved in monthly extraction and cleaning of utilization data from EPIC (Electronic Medical Record Source System) for use in Medical Cost Application.
• Creating Business Requirements specification using MS Visio, participating in Daily Scrum meetings and documenting the progress of the Project.