Venkat Uppunuthula

E-mail: adanj5@r.postjobfree.com

SQL Server/BI Developer Contact: +1-469-***-****

PROFESSIONAL SUMMARY

Around 7 years of experience in Data modeling, database design and Programming, Development and Implementation of Client-Server Applications & Database systems using MS SQL Server 2000/2005/2008/2008R2/2012/2014/2016 and BI Tools.

Expert in data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles using Normalization and De-Normalization techniques

Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using the stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs)

Writing heavy stored procedures, Audit triggers views, creating SQL scripts for data loads and Upgrades for data migrations and data validations

Proficient in Performance Tuning/Query optimization using indexes

Tuning the performance of stored procedures and large T-SQL Queries using Clustered indexes, efficient coding standards.

Expert in EDI and HIPAA testing privacy with multiple transaction exposure such as new Member enrolment 834 inbound, claim 837 inbound or claim adjudication, response to claim 835 outbound, 276 status inquiry277response, 270 eligibility/271 benefits.

Hands on experience in Backing up, Restoring databases and refreshing Data across environments.

Huge Data transfers from & to SQL Server Databases using utilities/ tools like DTS, SSIS, BCP, Bulk Insert

Experienced with aggregation using OLAP analysis services cube.

Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Trouble shooting, and Database Objects authorization.

Extensively experienced in database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.

Extensive knowledge in design of logical and physical data modeling using Erwin tool and consistency check using DBCC utilities.

Proficient in implementing surrogate key generation strategy in the Data warehouse.

Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.

Organized professional with excellent oral and written communication skills, excellent presentation, interpersonal skills, problem solving skills, fast learner and also adept quickly new technology with ability to take new roles in minimum time and little training.

Experienced with aggregation using OLAP analysis services cube.

Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Trouble shooting, and Database Objects authorization.

Worked on EDI transactions: 270, 271, 834, 835, 837,999 and TA1 to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrollment hence analyzing and documenting related business processes.

Extensively experienced in database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.

Extensive knowledge in design of logical and physical data modeling using Erwin tool and consistency check using DBCC utilities.

Proficiency in EDI 4010 to EDI 5010. Involved in conversion and mapping HIPAA ICD9 to ICD10. Expert in COB (coordination of benefits).

Expert in Updating Medical Codes (CPT, HCPCS, NDC & DIAGNOSIS CODES) for every Quarter.

Worked extensively on Power BI and created Reports/Dashboards using different type of Slicers and different Visualizations

Have a clear understanding of Power Shell scripts.

Hands on experience in Azure cloud.

Proficient in implementing surrogate key generation strategy in the Data warehouse.

Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.

Organized professional with excellent oral and written communication skills, excellent presentation, interpersonal skills, problem solving skills, fast learner and also adept quickly new technology with ability to take new roles in minimum time and little training.

TECHNICAL SKILLS

RDBMS: MSSQL Server 2000/2005/2008/2012, Oracle PL/SQL.

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development Studio, Visual Studio, Configuration Manager, SQL Server Profiler SQL Query Analyzer, SQL Refractor, SQL Server Agent.

ETL Tools: Data Transformation Services (DTS), SSIS, Pervasive Data Integrator, Import/ export wizard, Bulk Insert, BCP

BI Tools: SSIS, SSRS, SSAS, Crystal Reports, Power BI, Plateau Report Designer, Tablue.

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook

Management Tools: SharePoint, Team Foundation Suite (TFS), EDI, Microsoft Office Communicator.

Languages: T-SQL, MS SQL, MDX, C/C++, HTML, XML.

Web Technologies: HTML, DHTML, XML.

O/S: Windows 2008/2007/2003/2000/NT Servers, XP, Vista, UNIX.

PROFESSIONAL EXPERIENCE

Equian LLC.

Louisville, KY Jul 2018 - Till Date

Role: SQL Server/ETL Developer:

Description: Equian is a leading end-to-end payment integrity organization. We manage over $500 billion in claims data annually through our innovative platform designed to assist clients by avoiding, identifying, pricing, analyzing clinical codes, and ultimately recovering inaccurate transactions in the complex environments of healthcare, workers compensation, and property & casualty markets. Equian acts on data to pay the right party, the right amount, at the right time delivering over $2.5 billion annually in actionable savings throughout the payment spectrum.

Responsibilities:

Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Downloading from CMS and Performing Medical code Quarter updates (CPT, HCPCS, NDC) and identifying flagging sensitive codes.

Performing annual Diagnosis Medical code updates (ICD9, ICD10) using SCD feature of SSIS.

Used X-Parser schema for converting EDI files to xml files.

Developing Stored Procedures for validating standard and custom Subro validation for P & C client’s data.

Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.

Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.

Installing new Clients data process from scratch to loading data into end application.

Extracted data from Oracle and migrated into SQL Server 2005 using SSIS.

Migrated Clients claims data from different sources (EDI Files, Flat files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).

Worked on different kinds of Transformations in SSIS like Slowly changing dimension (SCD's), Lookup, Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and UnPivot as per the client requirement.

Having control over Table driven process and monitoring client scheduled jobs for data loading.

Created Configuration Files for Packages and SSIS logging on XML Files.

Developed different kind of reports such a Dashboards, Sub Reports, Charts, Matrix reports, Linked Reports Using SSRS.

Participated in the design and development of the Data Warehouse using Star Schema and Snowflake Schema.

Loading data into Oracle environment from by using PL/SQL.

Involved in EDI and HIPAA testing privacy with multiple transaction exposure such as new Member enrolment 834 inbound, claim 837 inbound or claim adjudication, response to claim 835 outbound, 276 status inquiry277response, 270 eligibility/271 benefits.

Involved in conversion and mapping HIPAA ICD9 to ICD10 and in COB (coordination of benefits)

Involved in building the Synchronization process between multiple servers across different platforms like Oracle, SQL Server 2008, SQL Azure, SQL Server 2012 etc.

Processed EDI files data into SQL tables (EDI 835, 837, 276, 277, 278, 997 Claim Transactions).

Handling third party insurance claims, Private Pay, and special programs such as Work Compensation related data.

Ensures claim files are properly documented and claims coding is correct.

Designed SSIS packages in SQL BI to extract data from Salesforce.com using WSDL (web service) feed and to integrate with the report delivery system integrated with the enterprise portal.

Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.

Environment: SQL Server 2014/2012/2008 R2/2008, SharePoint 2013/2010, SQL Server Data Tools, T-SQL, SSIS, SSRS, BIDS, Excel 2013, TFS, Power pivot, PL/SQL 8.0 and Central Management Console, x-parser, Service now.

HomeBridge Financial services.

Los Angeles, CA May 2017-June 2018

Role: MS SQL Server/SSIS/SSRS Developer:

Description: HomeBridge Financial Services, Inc., a mortgage banker, specializes in facilitating and securing home mortgage financial solutions. It offers conventional, FHA and VA, reverse mortgage, and home renovation loans; and short sale assistance. This project handles all types of Loans generated right from Encompass Elli me to all respective downstream systems and including reports.

Responsibilities:

Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.

Scheduled the packages to run automatically for incremental data and deploy them to their destination servers

Writing queries to create stored procedures, User Defined Functions, Views, Triggers and CTEs (Common Table Expressions) for ever changing complex business requirements.

Writing Complex T-SQL Queries, Sub queries, Co-related sub queries and Dynamic SQL queries.

I have extensively used SSMS for creating partitions in tables, ranking tables, writing nested queries, creating indexes, and cursors.

Performance-tuned existing stored procedures with severe efficiency issues, making them more user friendly and run smother.

Understanding the OLAP processing for changing and maintaining the data warehouse, optimizing dimensions, hierarchies and adding aggregations to the cube.

Create new SSIS package to extract date from legacy Database to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.

Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.

Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.

Experience in EDI automated first-pass claim adjudication, requiring thorough understanding of claim processing, both front and backend operations

Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.

Designed and implemented Data Integration and ETL processes with SSIS packages to make data available in Data Warehouse for reporting purpose.

Involved in creating Data mappings and data models using ERWIN tool.

Performance tuning of Stored Procedures and T-SQL Queries.

Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.

Worked on performance tuning of SSIS packages using error handling, event handling, re-running of failed SSIS packages using checkpoints

Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Analyze and Identify possible solutions to EDI issues as they occur and Troubleshoot issues with EDI partners and transaction processes.

Created tabular and matrix reports in SSRS. Wrote stored procedures and functions to create SSRS reports.

Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server

Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent.

Developed SQL scripts to insert, update and delete data in MSSQL database tables in OLTP environment.

Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.

Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights

Performed changes in the schema of the proposed database as required and informed those changes to the application development team.

Wrote simple Power Shell command line scripts and Navigated file systems and other structures using Power Shell.

Responsible for EDI Testing and monitoring 999 transactions receiving from client for smooth flow of transactions.

Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.

Involved with architects and business partners to fashion out the technical vision for the Enterprise Data Warehouse, Analytical Data Marts, and other data repositories by employing SSIS, SSRS, SQL server, and other big data technologies as required.

Documented different stages of data transformation, procedures and scripts.

Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful clustered index and non-clustered indexes.

Environment: MS SQL Server 2008/2012/2014/2016, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),EDI, Tableau, Microsoft Dynamics, Power shell, SharePoint, Team Foundation Server, MS Excel, MS Visio, Windows 7.

Kaiser Permanente

Pleasanton, CA Feb 2016- Apr 2017

SQL Server Developer

Description: Kaiser Permanente is a larger Healthcare society which provides a wide range of health care services. Client reporting project is part of medical department which handles medical services for individual clients. It also involves incremental development of the systems involved in the reporting process and migration of legacy systems to data warehouse.

Responsibilities:

Created Store Procedures to transform the data and worked extensively in T-SQL for various needs of transformations while loading the data.

Written complex SQL queries using joins, subqueries and correlated sub queries to retrieve data and Triggers to carry out various tasks from the database.

Involved in performance tuning of T-SQL Queries and focused on index tuning, query optimization and partitioning.

Used SQL Server Profiler to trace the slow running queries and the server activity.

Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

Used various SSIS tasks such as Conditional Split, Derived Column, Data Conversion, Fuzzy lookup, merge, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

Imported and Exported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.

Automated the SSIS jobs and email alerts using SQL server agent job for daily, weekly and monthly loads.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008.

Querying the EDI database for troubleshooting issues efficiently and Supports EDI Application (Utilibill) for huge data fix.

Involved in EDI and HIPAA testing privacy with multiple transaction exposure such as new Member enrolment 834 inbound, claim 837 inbound or claim adjudication, response to claim 835 outbound, 276 status inquiry277response, 270 eligibility/271 benefits.

Involved in conversion and mapping HIPAA ICD9 to ICD10 and in COB (coordination of benefits)

Used reporting objects like Tabular, Matrix, Sub report, Charts, Parameterized and Cascading parameterized reports using SSRS-2008.

Used Claredi as claims certification tool for HIPPA compliance.

Developed ECGateway scripts and 276XML to 276X12, 277X12 to 277XML maps, 997 Functional Acknowledgement Report.

Deployed and Published the Created Reports to Microsoft Share Point Server and uploaded them to Microsoft Performance Point Server.

Provided customer EDI technical support and Supply Chain functional support (EDI 835, 837, 276, 277, 278, 997 Claim Transactions).

Enters data into the claims management system accurately.

Handling third party insurance claims, Private Pay, and special programs such as Work Compensation related data.

Ensures claim files are properly documented and claims coding is correct.

Fixed Back end issues related to the Desktop GUI Screens to help Users.

Running Data Scans on Production/ QA Environments as per the requests from SYSOPS.

Aware of working with different ticketing workflow systems like JIRA and SRS.

Documented the development work.

Environment: MSSQL Server Enterprise Edition 2008 R2/2012/2014, SQL Server 2005, T-SQL, SSIS Packages, EDI Agent, HIPPA, Wind0ws 2003/2008, SSRS, SQL profiler, SQL Server Query Analyzer.

AJR INFO SYSTEM Pvt. Ltd

Hyderabad, India Sept 2013 – Nov 2014

Client: Molina Health Care

Role: SQL Server Developer/SSIS/SSRS

Description: Molina Healthcare has been a leader in providing quality healthcare to those who depend on government assistance. It serves as a health plan providing a wide range of quality health care services to families and individuals who qualify for government-sponsored programs, including Medicaid and the State Children's Health Insurance Program (SCHIP).

Responsibilities:

Understanding the report design Requirements and Constraints.

Creating Database objects – Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.

Design and implementation of Security Model, Policies and Procedures.

Performing query plans and making sure each and every query is using appropriate useful Indexes

Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity

Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.

Rebuilding Indexes and Tables as part of performance tuning exercise.

Deployed the created SSIS packages in Development and Testing environments.

Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases

Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package

Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Experience in EDI automated first-pass claim adjudication, requiring thorough understanding of claim processing, both front and backend operations.

Developed HIPAA EDI Transmissions and Create EDI Testing process, documentation, and performance matrices.

Technical Specification Creation for EDI Schedule meetings with technical personnel to determine technical parameters for EDI and other related processes, including communication, security, and privacy.

Created Drill-down, Parameterized and Sub-Reports using RDL.

Promoted RDLs to Reporting Service Server (SSRS).

Involved in understanding of Power Shell scripts and Wrote simple Power Shell command line scripts.

Developed Tabular Reports, Matrix Reports, drill down Reports, Bar Graph Reports using Power BI.

Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.

Transformed and combined the data using Query Editor in the Power BI and published Power BI Desktop reports created in Report view to the Power BI service and installed on premise data gateway and scheduled daily data refresh in Power BI.

Created scorecards with executive summary dashboards using MS Office Performance point server 2007 Dashboard designer that display performance monitoring measures.

Designed and developed Data-mart using SSAS.

Build Cubes on Enterprise Date Warehouse (EDW).

Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.

Performed DBCC checks and fixing data corruption in Application databases.

Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), EDI Notepad, MS SQL Server Reporting Services (SSRS), Power BI, Microsoft Visual source Safe.

Educational Qualification:

Masters in Computer Information and Science (MCIS), Southern Arkansas University, Magnolia, AR, (3.55 GPA)

B. Tech. in Computer Science and Engineering (C.S.E), JNTU Hyderabad, (3.72GPA)

Contact this candidate