Data Analyst

Karthi (Karthiga Kumaravelprakasam)

Sr. Business Analyst & BI Developer

Focused, analytical minded techno-functional professional with years of healthcare and Automobile industry experience as a Business Analyst, developing, modifying and analyzing program suites, reports and BI solutions. Skilled working with Onsite/Offshore teams in multiple capacities. Expert in working on large volumes of data using and enterprise software. Adept in the validation, rationalization and writing of requirements. Adept at applying tools to analyze clients, platforms and users. Proficient in overseeing multiple projects in an Agile and fast-paced, milestone-driven environment.

Core Skills

Business Analysis System Analysis Reporting Requirement Gathering Process Improvements BI Development Enterprise Software Test Plans & Scripts (Functional, Technical, UAT) Regulatory Compliance Healthcare & Pharmacy Audits Communication & Project Leadership Agile Scrum Methodology Data Processing, Collection & Extraction Quantitative & Qualitative Data Analytics Programming & Debugging Quality Assurance & Validation Development Unit, Integration, System & Testing Code Deployment Soft skills & Business Acumen

Technology

Reporting: SSIS, SQL Server Reporting, Power BI Tableau, Cognos, SAS, Qlikview, ETL and Alteryx

Operating System: Windows NT, Windows 95/98/2000/XP/Vista, MVS, OS/390

Databases: IBM UDB DB2, Oracle, IMS DB, Teradata, SQLSERVER2014, Azure SQL

Microsoft: Office Suite, Visio, Project, SharePoint

Teradata: SQL Assistant, Administrator

Mainframe: File Aid, FTP, SPUFI, INSYNC

Core Languages: SAS, SQL, COBOL, Java, JCL

ETL: Informatica, SSIS/SSAS/SSRS

SAS: SASV8, V9, SAS/BASE, SAS/ACCESS, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ODS

Data WH Tools: MS SQL Server 2000/2005/2008 R2/2012 SSIS 2005/2008/2012, SSRS 2005/2008

Career History

Fram Group (Apr 2017 – Mar 2020)

Sr.BI and Optimization Analyst/BI Developer

Collaborated with business users to gather requirements and comprehend the purpose of reports; partook in meetings to offer status updates, solutions and recommendations on all projects.

Proficient with the design & development of various dashboards, reports; utilizing Power BI Visualizations like Bar charts, pie-charts, scattered charts, geographic visualization and utilizing local/global filters according to end user requirements.

Created the Geographic Maps, Charts, Scatter Plots to display the Application Usage data by Geographical location and also created dashboards Application Usage Frequency, Usage Trend, Usage by Location, Weekly User Survey, and Usage by Org, etc.

Extensively used parameters, calculated fields, Filters for Report Development.

Validate Sales and Customer Inventory files for all customers; load the data to SQL Server database tables.

Designed, developed Informatica and SSIS programs to connect to different data source (Sharepoint, SAP, Network Drives, Remote Computers), to read and load the data to SQL Server database tables.

Developed stored procedures to create summary of data, Details reports and Alerts.

Created calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions. Developed various customized/ parameterized dynamic reports (Sales/Inventory/Shipments) and dashboards using SSRS and MDX.

Implemented reports with cascading parameters and sub reports using SSRS, and make these reports accessible to the users in SharePoint 2013.

Developed Aggregations, partitions and calculated members/Perspectives for cube as per business requirements.

CVS Caremark (Nov 2016 – Mar 2017)

Business Analyst/BI Developer

Devised gripping User Stories to offer actionable insights via Tableau dashboards.

Devised vendor transition files that include member lists that are targeted new with personal information, drug information, physician information and pharmacy information.

Implemented a structured SAS-SQL Teradata code to synthesize relational data to optimize complex member communication products across stakeholders and other key audiences.

Designed, developed Tableau Desktop BI Dashboards on Tableau 10.1 using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality. Published reports to Tableau Server.

Connect Tableau server to publish dashboard to a central location for portal integration; also connect with the SharePoint portal to setup the auto-refresh feature.

Complete quality control for vendor claims and address data as needed. Created a Vendor Transition program for data files that use provided intake forms (Drug intake forms/ Member intake forms/Pharmacy intake forms).

Performed quality checks for list pulls (The vendor file/ Address file / Drug file / Eligibility file).

Highmark Health Solutions (BCBS)

Business Systems Analyst (Sep 2012 - Oct 2016)

Collaborated with business users to gather reporting requirements and comprehend the purpose of reports; partook in meetings to offer status updates on all projects.

Also attended daily scrum meetings to both develop and update assigned stories and functions.

Automated monthly Excel reports into Power BI Dashboards, as well as produced new standard monthly reports using Power BI.

Worked in creating ETL packages (SSIS) for loading complete Data warehouse. Also created the Extraction packages to extract data from the Warehouse and send it to vendors.

Improved query response times by implementing measure group partitions and aggregation redesign.

Worked on the creating Adhoc reports, Database Imports and Exports using SSIS.

Expertise in handling ETL loads on various RDBMS and POS system like SQL Server, Oracle, DB2 and AS400.

Created SSIS packages to extract data from Excel and CSV files and Populated Sql Server Tables.

Responsible for the design, development and implementation of mappings/transformations based on source-to-target specifications, defining ETL (extract, transform, load) and ETL development.

Blue Cross Blue Shield of Delaware (Sep 2010 - Sep 2012)

Business Systems Analyst

Collaborated with stakeholders and business users to gather requirements Stored institutional and professional ITS claims data in varied SAS environment datasets; also developed various SAS reports, tables, graphs and summary analyses.

Called on SAS Base programming and the SAS Enterprise Guide to deliver reports, charts and graphs.

Ran SQL queries in the DB2 database to evaluate and manipulate data, check it for invalid/out-of-range content.

Created and manipulated data for testing purposes; developed scripts to load said data into EDW base tables using the Teradata Fast Load, Multi Load and BTEQ utilities.

Called on intricate Multi Load and Fast Load scripts to load data into Teradata from legacy systems and flat files.

Wrote SQL queries to pull required database content using Teradata SQL Assistance.

Developed JCL-DDLs to load the dataset in to Teradata tables.

Earlier Roles

Technical Lead, The Bank of New York Mellon Corporation, 2003-2010

Business Analyst – Consultant, TJMAXX, 2002-2003

Systems Analyst/Production Support – Consultant, American Express, 2001-2002

Education & Credentials

Bachelor of Engineering, Electronics and Communication Engineering, Bharathiyar University, 1996-2000

Contact this candidate