Kumar Roshan Email & Phone Number

East Mckeesport, Pa, Us

Greater Pittsburgh Area

• Conducted data research and analysis to resolve healthcare Medicare/Medicaid eligibility, enrollment and billing issues.• Ensure data integrity, data security and process optimization by identifying trends and provide reports as necessary.• Created databases, tables, stored procedures, DDL/DML Triggers, views. User defined data types, functions, cursors and indexes using T-SQL• Develop all the required stored procedures, user defined functions and triggers using T-SQL and SQL•… Show more • Conducted data research and analysis to resolve healthcare Medicare/Medicaid eligibility, enrollment and billing issues.• Ensure data integrity, data security and process optimization by identifying trends and provide reports as necessary.• Created databases, tables, stored procedures, DDL/DML Triggers, views. User defined data types, functions, cursors and indexes using T-SQL• Develop all the required stored procedures, user defined functions and triggers using T-SQL and SQL• Worked on Dynamic SQL and queries• Conducts data mapping, designs, develops and implements ETL process• Extracted, Transformed and loaded data for business users to manipulate into reports• Supported management team with reports generation and analysis using ETL tools, Excel and SQL• Performed ETL repository administration including promotion of software packages to proper environment, troubleshooting and technical support• Analyzed invoice data against carrier contracts to alert of any discrepancies• Applied master data Management Standards in data conversion, mapping and migration• Produced report using SQL Server Reporting Services (SSRS) and creating various types of reports such as drill down, parameterized, cascading, conditional, table, matrix, chart and sub reports formatting them using SSRS• Developed reporting and various dashboards across all areas of the client's business to enable quick identify claims issues• Worked on preparation of Test plans, Test data and execution of test cases to check application functionality that meets user requirements• Documented and reported issues that affect claims processing or accuracy to claims leadership team. Show less

Greater Pittsburgh Area

Maintained accurate data in channel reporting tools, systems and processes and use Business Objects, Excel and Access to accomplish data clean assignments• Used SSIS workflow Manager to create workflows, database connections. Sessions and batches to run mappings• Created custom reports and pivot tables for Sales Reps that were tailored by segment, area and technology• Worked with Finance leads to investigate discrepancies between databases.• Assisted management with special… Show more Maintained accurate data in channel reporting tools, systems and processes and use Business Objects, Excel and Access to accomplish data clean assignments• Used SSIS workflow Manager to create workflows, database connections. Sessions and batches to run mappings• Created custom reports and pivot tables for Sales Reps that were tailored by segment, area and technology• Worked with Finance leads to investigate discrepancies between databases.• Assisted management with special projects such as collecting and consolidating survey data for validation• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.• Extracted data from the databases (SQL Server) using SSIS ETL tools.• Designed and Developed SSIS packages for performing ETL process using SQL Server 2008 Integration Services• Expert in extracting, transforming and loading data using SSIS Import/Export Wizard.• Created SSIS Packages to integrate data coming from Text files and Excel files• Created Stored Procedure and Views, Indexes, SQL joins and Sub queries• Worked with integration services for transferring and reviewing data from different sources like (Flat file, Excel, CSV)• Generated Daily, Weekly, Monthly reports for the analysis of managers and end users by using SQL Server Reporting Services.• Created data mapping documents from source to target systems.• Created logical and physical design of the centralized Relational Database.• Identified and processed the facts and dimension tables.• Normalization to 3NF/denormalization techniques for optimum performance in relational and dimensionaldatabase environments. Show less

Englewood, Colorado

• Demonstrable expertise in core IT processes, utilizing ETL tools to query, validate, and analyze data.• Expert business and technical requirements documentation skills employing contemporary tools for data mapping, diagramming, Use Cases, and business rules to produce concise functional specifications.• Follow and assess the business process model defining metadata rules and critical data elements.• Conduct analysis, gather requirements, develop Use Cases, data mapping, and… Show more • Demonstrable expertise in core IT processes, utilizing ETL tools to query, validate, and analyze data.• Expert business and technical requirements documentation skills employing contemporary tools for data mapping, diagramming, Use Cases, and business rules to produce concise functional specifications.• Follow and assess the business process model defining metadata rules and critical data elements.• Conduct analysis, gather requirements, develop Use Cases, data mapping, and workflow diagrams.• Develop global incident management reporting dashboard for the DQM over multiple IM platforms.• Investigate unused modules of the DQM and report viability and feasibility for implementation.• Comparative cost/benefit analysis between DQM modules and Inquiry Framework for DQ assessments.• Utilize multimedia office suite applications and conduct surveys for high level dashboard reporting.• Performing daily integration and ETL tasks by extracting, transforming and loading data to and from different RDBMS.• Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data.• Business requirement gathering and translating them into clear and concise specifications and queries.• Prepare high level analysis reports with Excel and Tableau. Provides feedback on the quality of Data including identification of billing patterns and outliers.• Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts.• Wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts).• Gather analytical data to develop functional requirements using data modeling and ETL tools.• Systems Documentation, change control/defect analysis and updates. Implementation testing.• Gathered data and documenting it for further reference and designed Database using Erwin DATA modeler. Show less

Greater New York City Area

• Data analysis and reporting using MySQL, MS Power Point, MS Access and SQL assistant. • Involved in MySQL, MS Power Point, MS Access Database design and design new database on Netezza which will have optimized outcome. • Involved in writing T-SQL, working on SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration. • Involved in writing scripts for loading data to target data Warehouse using Bteq, Fast Load, Multiload • Create ETL scripts using Regular Expressions… Show more • Data analysis and reporting using MySQL, MS Power Point, MS Access and SQL assistant. • Involved in MySQL, MS Power Point, MS Access Database design and design new database on Netezza which will have optimized outcome. • Involved in writing T-SQL, working on SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration. • Involved in writing scripts for loading data to target data Warehouse using Bteq, Fast Load, Multiload • Create ETL scripts using Regular Expressions and custom tools (Informatica, Pentaho, and Sync Sort) to ETL data. • Developed SQL Service Broker to flow and sync of data from MS-I to Microsoft's master database management (MDM). • Involved in loading data between Netezza tables using NZSQL utility. • Worked on Data modeling using Dimensional Data Modeling, Star Schema/Snow Flake schema, and Fact& Dimensional, Physical & Logical data modeling.• Generated Stats pack/AWR reports from Oracle database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth. Show less

Hyderabad Area, India

• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.• Conducted or participated in requirement gathering workshops and design sessions necessary to capture the business needs and develop models.• Interfaced with business and technology stakeholders to gather, analyze, and document business and data requirements.• Used HP Quality Center for UAT Test Case Management… Show more • Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.• Conducted or participated in requirement gathering workshops and design sessions necessary to capture the business needs and develop models.• Interfaced with business and technology stakeholders to gather, analyze, and document business and data requirements.• Used HP Quality Center for UAT Test Case Management and defect tracking and resolution.• Designed and implemented basic SQL queries for testing and report/data validation.• Ensured the compliance of the extracts to the Data Quality Center initiatives• Understood the new business requirements and plan the facilitation of data marts.• Prepared sales reports and interpreted to managers for decision making.• Extracted key information from highly unorganized data using excel and SQL.• Conducted data management and used statistical techniques to clean the data.• Tracking and reporting the issues to project team and management during test cycles.• Utilize SSIS for ETL data modeling, data migration, and analysis.• Prepare high level analysis reports with Excel and Tableau.• Analyze and Assess invalid and missing data in the All Payer Claims Data• Documenting the extent to which data fails to meet threshold reporting requirements.• Created T/SQL statements (select, insert, update, delete) and stored procedures.• Designed and implemented basic PL/SQL queries for testing and report/data validation.• Troubleshooting and performance tuning of PL/SQL scripts and stored procedures.• Define and represent Entities, Attributes and Joins between the entities.• Extensively developed PL/SQL Procedures, Functions, Triggers and Packages.• Written UNIX shell scripts to automate loading files into database using crontab.• Developing batch files to automate or schedule tasks. Show less

Hyderabad Area, India

• Created different views in workbook to visually analyze data.• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.• Used different Mark types and Mark properties in views to provide better insights into large data• Created External filter, internal filter and Context filter to improve performance.• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare… Show more • Created different views in workbook to visually analyze data.• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.• Used different Mark types and Mark properties in views to provide better insights into large data• Created External filter, internal filter and Context filter to improve performance.• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.• Created parameters and quick filters. Created sets to display top products based on their sale.• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.• Created Dashboards with interactive views, trends and drill downs.• Published Workbooks and Dashboards to the Tableau server.• Created groups and users in Tableau server• Used commands in Tabcmd and Tabadmin utility tool.• Implemented new features in Tableau 7 to the existing Workbooks and Dashboards.• Integrated Cognos and crystal reports to tableau.• Act as system administrator and is responsible for security, administration, release management, troubleshooting, performance tuning and general system maintenance.• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.• Manage the application's users, groups, licenses and integration with Active Directory.• Administer and support a multi-tier Tableau infrastructure including upgrade analysis and planning, security administration, release management, troubleshooting, performance tuning, and general systems maintenance.• Coordinated meetings with vendors to define requirements and system interaction agreement documentation between client and vendor system. Show less