PROFESSIONAL SUMMARY:

• Accomplished as a Sr. Data Analyst & BI Developer with 7+ years of experience in Healthcare and IT Industry.
• Evaluated, Reviewed and Processed Healthcare reports from various sources in compliance with the regulations without compromising the quality of work.
• Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (XML, Java script, or ETL frameworks).
• Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS etc).
• Accomplished with Data manipulation to uncover trends and insights i.e. sub setting, pivoting, summarization and sorting.
• Experience in Log Shipping for Automated Process for backing up, restoring, copying the transaction logs and synchronizing the database for distributed database server application which can improve the application performance and availability of database.
• Portfolio of achievements includes huge number of case processing’s, highly proficient in Global Safety Databases like DB2, MAPS, ISG, NUMEn, WEM and Argus.
• Demonstrated competence in Triaging (Completeness, Accuracy, Legibility and validity) to determine seriousness, Expectedness & Priority, Case processing’s that include duplicate searches.
• Experienced in Data Documentation, Case processing, Case merges & inactivation, quality review and follow - up in accordance with HIPAA and HITECH guidelines.
• Acquired excellent command on medical terminology and expertise in the utilization of MedDRA for coding patient’s medical history, adverse events, Therapeutic indications & device issue terms; products with company product dictionaries (CPD).
• Acquired Working Knowledge on Good Case Management practices.
• Ensured consistency in assessing, coding and recording of healthcare events by coordinating with clinical project team.
• Mentored & assisted staff performing in the Data Interpretation, Data Analysis and Data Integration by using Databases like MySQL and DB2.
• Interpreting data, analyzing results using statistical techniques and providing ongoing reports Acquiring data from primary or secondary data sources and maintaining databases/data systems.
• Involved in writing scripts to check for duplicate records, delete/modify them depending on the business rule .
• Rigorously tested and debugged all the scripts to test the validity of the data after the export/import/delete were done. Performed optimization of query, triggers and stored procedures, their testing focusing on stability and execution plan which has resulted up to 45% increase in performance of numerous modules.

TECHNICAL SKILLS:

Programming Languages: C, C++ and Java

Web Technologies: XML, HTML.

MySQL, DB2, MS: SQL Server, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), ODBC, OLAP, MOLAP, ROLAP, OLTP, DBCC, BCP, DB2 and Argus.

Monitoring & Reporting: SSAS, SSRS and Excel.

ER: Win, Visio 5.0 and PowerBI

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services(SSIS)

WORK EXPERIENCE:

Confidential, Columbus, OH

Sr. Data Analyst/ SSRS Developer

Responsibilities:

• Created ad-hoc reports using SQL server 2014 Reporting Services (SSRS).
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Before doing any migration, by using the various functions of log shipping backup, copy and restore the database to different kind of servers.
• Migration is also done using Bulk Insert and dynamically created queries in the job steps.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Designed and implemented Dimensions and Measures according to business requirement.
• Created Linked Server using the dedicated LAN for load balancing and increased the performance of the Data Warehouse.
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes.

Environment: SQL Server 2014, DTS Designer, SSIS, SSAS, SSRS, Query Analyzer, Enterprise Manager, SQL Profiler and Index Tuning Wizard.

Confidential, Norfolk, VA

Sr. Data Analyst

Responsibilities:

• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Using Erwin and Visio 5.0 design different kind of Data Models for various kind of databases as per the requirement.
• By using Log Shipping Mechanism extensive knowledge of backing, copying and restoring the transaction database to primary server, secondary server and monitor server.
• Created SSIS package to load data from Flat File (2GB -- 4GB) to Flat File and Flat File to SQL Server 2005 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, Slowly Changing Dimension.
• Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts, Table.
• Creating and managing scheme objects such as tables, views, clusters, Indexes, Procedures, triggers and maintained Referential Integrity.
• Expert in planning and implementing MS SQL Server Security and database permissions.

Environment: Microsoft Business Intelligence Studio, SQL Server 2012, SSAS, SSIS, SSRS, Crystal Reports, MS Excel, MS PowerPoint and PowerBI.

Confidential, NY

SS RS Developer

Responsibilities:

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Developed SSIS Templates that can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev., Test and Production Environments.
• Worked on development, implementation, administration and support of ETL processes for large-scaleData Warehouses using SSIS and DTS.
• Created SSIS process design architecting the flow of data from various sources to target and Involved in extracting the data using SSIS from OLTP to OLAP.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Using Dtsx Change tool converted DTS packages to SQL Server 2005 SSIS packages.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.
• Involved in conversion interfaces on QNXT Member, Provider, Claims Processing, Utilization Management, Accumulators, Contracts and Benefits.
• Used techniques like backups, restore, replication, and standby databases to ensure higher availability Production Environment.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Responsible for maintaining cubes using SSAS and populate the cubes with the data
• Created Tabular Matrix reports, Charts and graphs as per customer requirements Using SSRS.
• Good understanding of SSRS with Report authoring, Report management, Report delivery and Report security and Created reports with Analysis Services Cube as the data source using SSRS 2005/2008.
• Involved in designing the physical database models on SQL Server 2005 RDBMS using DML/DDL implementing constraints and triggers for data integrity.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Involved in projectstatus report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server.
• Worked with development teams in the design of physical databases and in modification.
• Involved in migration from SQLServer 2005 to SQL Server 2008

Environment: MS SQL Server 2008/2005, SSRS, SSAS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle10g, 11g, Enterprise Manager, ERWIN Data Modeler, Windows Server 2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2005, MS Access, Crystal Reports, MS Excel 2007.

Confidential

Sr. Data Analyst

Responsibilities:

• Created ad-hoc reports using SQL server 2008 Reporting Services (SSRS).
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Before doing any migration, by using the various functions of log shipping backup, copy and restore the database to different kind of servers.
• Migration is also done using Bulk Insert and dynamically created queries in the job steps.
• Designed and implemented Dimensions and Measures according to business requirement.
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Created several valuable reports (i.e. Sales Summary, Auditing Reports, Matrix Style Sales Trending Report by Customers/Time/Region using Tabular data and Charts etc.) for Business users using SQL Reporting Services.

Environment: SQL Server 2008 and 2008R2, DTS Designer, SSIS, SSAS, SSRS, Query Analyzer, Enterprise Manager, SQL Profiler and Index Tuning Wizard.