Bharat Motha

Contact # 469-***-****

Email id: ac9kql@r.postjobfree.com

Sr SQL/ETL Developer (SSRS, SSIS, SSAS)

SUMMARY

* ***** ** ********** ** Microsoft Database Technologies that includes experience in Database Design and Development in Healthcare, Financial, Retail Domains.

Experience and Familiarity working with Agile and Scrum methodologies.

Experience in writing Efficient T-SQL queries, Stored Procedures, User Defined Functions, Database Triggers and Exception Handlers.

Extensive knowledge in Tuning SQL queries, T/SQL queries and improving the performance of the Database using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.

Extensive experience in Database Design, Data Modeling, T-SQL Development, Developing and Implementing ETL Packages using SSIS and Complex Reports using SSRS.

Expert in configuring and creating SSIS solutions for high performance Data Integration, Data Migration and Business Intelligence Process that includes Merging Data from various Heterogeneous Data Stores, Populating Data Warehouses and Data Marts, Cleaning and Standardizing Data.

Transferred data using Informatica tool from AWS.

Expertise in EDI transactions used in healthcare industry and good knowledge of HIPAA X12.

Experience in implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.

Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.

Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.

Worked on the screenshot and prototype development for the various online screens meant for the EHR project.

Worked implementing BI Best Practices and recommendations

Worked in both SSAS Tabular and SSAS Multidimensional Cubes.

Strong knowledge of Software Development Life Cycle (SDLC) as well as Testing Methodologies and the Role of QA/ EDI Specialist.

Involved in creating Tabular Models and help build adhoc reports

Worked on Microsoft Power *(Power Pivot, Power View, Power Query, Power Maps, POWER BI)

Worked in Creating DAX Expressions and implement partitions in formulas, and user-defined functions.

Created Dashboard pages in Performance Point Server that use different types of web parts and excel services for reports.

Experience in Healthcare industry including Enrollment, Benefits, Claims, Medicare, and implementation of HIPAA key EDI (ANSI X12) transactions.

Medical Claims experience in Process Documentation, Analysis and Implementation in 835/837/834/270/271/277(X12 Standards) processes of Medical Claims Industry from the Provider/Payer side.

Worked with Claims, Members, Providers and Authorizations for loading the data into SQL server using SSIS packages.

Researched the existing client processes and guided the Vendors in aligning the HIPAA compliance output with the client systems.

Having good hands on experience in building RPM's and compiling the Linux kernel for different builds.

Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.

Experience in creating Report Models for building Ad hoc reports using SSRS.

Created reports such as Parameterized, Cascading, drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.

Experience in Administering, Managing and Troubleshooting Reporting services.

Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.

Excellent communication, interpersonal and analytical skills.

EDUCATION: BACHELORS IN ELECTRONICS AND COMMUNICATIONS ENGINEERING, JNTUH, INDIA

SKILLSET

RDBMS: MS SQL Server 2000/2005/2008/2012/2014, MS Access, Oracle 9i/10g, Postgre SQL.

Programming Languages: VB scripts, C, C# and UNIX Shell Script.

Tools & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, Visual Studio .NET.

Operating Systems: Windows Vista/XP/2003/2000, Windows Server 2000/2003/2008.

BI Tools: SQL Server Reporting Services (SSRS), Cognos 7 and 8 BI series, SQL Server Integration Services (SSIS), DTS, SQL Server Analysis Services (SSAS), SSAS Tabular, MS Visio, Erwin, Crystal Reports 9.0/XI, ProClarity, Performance Point Server.

Web Technologies: JASON, XML, HTML, XSL, IIS.

Application Packages: MS Office Suite, MS Outlook, Microsoft Office SharePoint Server (MOSS), POWER BI.

EXPERIENCE

AVANADE INC (STATE OF VIRGINA), AUSTIN, TX Oct 18 – Till date

Sr. SSRS/SQL Application Developer/ SQL BI Developer

Development and Integration of new Reporting Templates using SQL Server Reporting Services (SSRS) and MS-SQL 2017 for Researchers.

Revision and Improvement of existing Reports based on Research requirements.

Development of Stored procedures to run in the background for data population.

Work as Data analyst, by interacting with the researchers and gathering requirement for Claims data Discovery.

Expertise in creating applications and LCP Letters using XML, SQL configuration and JASON.

Participate in the deployment of updates and configuration changes to SQL Server.

Monitor scheduled jobs to ensure process stability.

Write and revise documentation for system configuration & standard operating procedures.

Develop Ad-hoc reports through SQL Server Reporting Services (SSRS) and Maintain existing reports within our SSRS environment.

Develop and execute extraction and load scripts (SSIS).

Develop/maintain automate reporting and client email delivery through SSIS.

Advanced knowledge of T-SQL (stored procedures, functions, triggers).

Design and development processes across the entire data warehouse ETL framework.

Worked on Claims, Members, Providers, Medicaid and Medicare Data.

Able to write, optimize and debug queries and stored procedures. Relational Database and SQL Language.

Design and development of SSRS reports and Dashboards including data set ingestion and transformation, Modeling, Data Analysis Expressions (DAX) using the appropriate report templates

Development of data models, technical and functional documentation with business partners.

Demonstrate and promote reporting best practices and use of data visualizations to empower data driven decision making.

Provide governance around the SSRS platform architecture and operations.

Design and develop SSRS reports, dashboards, apps, DAX scripts.

Manage concurrent projects and independently prioritizes multiple requests to meet the organizational goals.

Monitor a wide range of technical problems and make decisions and provide recommendations to the team

Participate in the deployment of updates and configuration changes to SQL Server.

Write and revise documentation for system configuration & standard operating procedures.

CENTENE CORPORATION, ST LOUIS, MO Oct 17 – Sep 18

Sr. SQL Server BI Developer / ETL Developer

Build efficient SSIS packages for processing fact and dimension tables with complex transforms.

Worked on multiple platforms SQL server and Teradata.

Created ETL process using SSIS to transfer data from Teradata Environment to SQL server and Vice-versa.

Created Efficient Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL scripts in Teradata and in SQL Server.

Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

The process of Extraction, transformation, compare and loading of the Data from DB2 into the Data warehouse is done using the Teradata Client Utilities like Fast load and Multi-load. Coding of the processes is done using Teradata SQL.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Replicating the data bases from Production to the warehouse on a live basis.

Coordinating the Releases through MRP (Master Release Plan).

Cleaning up the QA environments after every release and rebasing the environments with current data.

Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.

Involved in setting up the SQL scripting standards to the developers.

Gathered requirements for making changes to the existing Electronic Medical Records(EMR), Electronic Health Records(EHR) and Ambulatory Services for the existing Epic Interfaces.

Involved in development of the system for data exchange from EMR, EHR to Electronic Lab Reporting Systems.

Worked extensively on inbound transaction set 834 Benefit Enrollment maintenance claim, Adjudication EDI 837, Remittance 835 and Claim status 276/277.

Reviewed EDI 837 claims and flagged HIPPA non-compliant claims received from the Payer side.

Assisted EDI team with the testing of maps for HIPAA transactions 835 and 837.

Creating Data Points for use by Decision engine using T-SQL, Stored Procedures and Functions.

Worked on Teradata SQL Assistant 14.0, Teradata Assistant 15.0 and Toad Data point.

VIZIENT INC, Irving, TX Feb 15 – Sep 17

Sr SQL Server BI Developer/SSIS/SSRS/SSAS

Responsibilities:

Build efficient SSIS packages for processing fact and dimension tables with complex transforms.

Good Experience in working with RDBMS including Oracle, SQL Server and MS Access.

Expert in creating Complex Crystal Reports Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports.

Developed OLAP cubes using SSAS (SQL Server Analysis Services). and calculate the metrics that were revealed in the functional analysis

Extract Transform and Load source data into respective target tables to build the required data marts.

Created ETL process using SSIS to transfer data from heterogeneous data sources.

Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.

Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.

Created Cell Level Security in cubes using SSAS.

Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS

Created Efficient Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL scripts.

Created SSIS packages for uploading different file formats (Excel, dbf, Access) and databases (Flat files, SQL Server) into the SQL server data warehouse using SQL Server Integration Services (SSIS).

Worked with Excel Pivot table and Power Pivot for building some reports and used Slicer data.

Worked on Power BI and prepared dashboards using Tableau to make it more attractive.

Create reports in Power BI Desktop and Service utilizing the connectors and content pack.

Created different reports in Power BI Desktop and publish to Power BI online.

Deep experience with the design and development of Tableau visualization solutions.

Experienced in using Data Analysis Expressions DAX to creating custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.

Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.

Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Experience setting up and managing Tableau Server with large volumes of data.

Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.

Creating and maintaining automated jobs for database backup on a weekly basis based on the percentage used and made sure the backup is current.

Monitoring SQL server performance using SQL Profiler, Query analyzer, Index Tuning Wizard and Windows Performance Monitor.

Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.

Setting up Tableau data sources. Filters, blending, joins for optimum performance and Trouble-shooting

Issues.

Designed Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Creating Data Points for use by Decision engine using T-SQL, Stored Procedures and Functions.

Involved in Debugging Issues as a part of Production Support.

UHG, Atlanta, GA June 13 – Feb 15

Sr BI Developer

Responsibilities:

Created the Data warehouse Architecture, Data Model and setting up the Best Practices.

Built the Source to target mapping document based on Subject areas for ETL Data Integration initiative.

Created Star Schema from analyzing the underlying requirements of the data ware house.

Worked on building/modeling the Enterprise Data Model.

Extensive experience with T-SQL in constructing Triggers,Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.

Created ETL Projects using SSIS 2012 in Package Deployment Model as well as Project Deployment Model, also efficiently used SSIS catalog for ETL Monitoring.

Design Access databases for reporting and claims data analysis. Create tables, table updates and inserts to manipulate the data.

Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.

Worked with the business/functional unit to assist in the development, documentation, and analysis of functional and technical requirements within FACETS.

Create data dictionaries for claims data

Coordinated with the developers and IT architects to design the interface of the new system according to the X12 (270, 276, 278, 834, 837 (I,P,D) and 820) standards.

Created efficient ETL packages to load data from CSV, 834 Edi files, Password Protected Excel and pgp encrypted files stored in SFTP and FTP.

Generated data mapping documents from production databases to the warehouse and from the warehouse to the policy and claims marts.

Created SSIS packages to consume XML RPC Web services and SOAP web services.

Created indexed views, and appropriate indexes to cut the complex query run time.

Worked on creating Tabular Data Model Databases and created SSRS reports on top of it using both Direct Query and Cached Modes.

Modified the existing stored procedures to meet new design.

Developed SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.

Wrote efficient Stored Procedures and functions according to the business requirements for internal applications.

Designing, processing and deploying Cubes from the different fact and dimension tables based on the business requirement using SSAS.

Developed reports from these OLAP cubes using ProClarity, PPS and SSRS.

Worked with Excel Pivot table and Power Pivot for building some reports and used Slicer data

COMPASS PROFESSIONAL HEALTH SERVICES, Addison, TX April 12 – June 13

Sr SQL Server BI Developer/SSIS/SSRS/SSAS

Responsibilities:

Build efficient SSIS packages for processing fact and dimension tables with complex transforms.

Extract Transform and Load source data into respective target tables to build the required data marts.

Created ETL process using SSIS to transfer data from heterogeneous data sources.

Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.

Created Efficient Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL scripts.

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

Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Reports using RDL.

Involved in building Star schema and Snow Flake schema depending on business requirements.

Worked on Multidimensional Expressions (MDX) queries on Cubes.

Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.

Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.

Worked on the EDI 834 inbound and 834 outbound data movement with our trading partners.

Created Cell Level Security in cubes using SSAS.

Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.

Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.

Developed Report Models for building customized Ad hoc reports. Played a Content Manager role on report server.

Creating and maintaining automated jobs for database backup on a weekly basis based on the percentage used and made sure the backup is current.

Monitoring SQL server performance using SQL Profiler, Query analyzer, Index Tuning Wizard and Windows Performance Monitor.

Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.

Designed Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Creating and Maintaining various instances or environments of SQL Server for Development and Testing.

Monitoring and scheduling daily, weekly and monthly SQL Server jobs and debug any issues related with failed jobs or data discrepancy.

Replicating the data bases from Production to the warehouse on a live basis.

Coordinating the Releases through MRP (Master Release Plan).

Cleaning up the QA environments after every release and rebasing the environments with current data.

Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.

Involved in setting up the SQL scripting standards to the developers.

Creating Data Points for use by Decision engine using T-SQL, Stored Procedures and Functions.

Creating Triggers on various Data base tables to maintain business rules.

Responsible for Query optimization and Performance tuning.

Involved in Debugging Issues as a part of Production Support.

SPRINT, Overland Park, KS Jan 11 – March 12

MS SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

Gathered functional requirements and Business requirements and written the technical specifications for building the Global Enterprise Data warehouse.

Worked closely with end users in designing and creating the Global Enterprise Data warehouse.

Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.

High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).

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

Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Reports using RDL.

Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2008 that stored and maintained the data.

Implemented MS Analysis Services setup, tuning, cube partitioning, and dimension designing including hierarchical and slowly changing dimensions.

Managed Up gradation of DTS packages to SSIS packages.

Involved in the complete data warehouse development life cycle and solely responsible for the design, development and maintenance of 8 cubes.

Implemented transactional replication among different servers.

Provided technical guidance and support to end-users by developing documentations required.

Performed application and database code production pushes, following production release procedures.

Performed production SQL release final verification procedure to production.

Documented all database changes and follow and enforce change and release management processes.

Audited and enforced database security, code and procedural standards

CYIENT LTD, Hyderabad, India Jun 09 – Dec 10

SQL SSIS/SSRS/SSAS Developer

Responsibilities:

Supported Enterprise ETL Development and support for various Business Divisions interfacing Microsoft Applications.

Collected business requirements from users and translated them as technical specs and design docs for development.

Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.

Created ETL packages to load everyday transactional data into Data warehouse and BCP to built analysis services cubes and create SSRS reports on top of the cubes to provide quarterly forecast about each product to the client.

Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables

Automated ETL Data loads and established efficient ways of Error Handling in SSIS

Installing Performance Point Server and Share Point

Created Dash Boards and Score Cards and integrated them with MOSS.

Involved in Heavy MDX scripting for writing business calculations.

Implemented Slowly Changing Dimensions

Created Scattered, Bar and Chart reports using SSRS 2008

Created Score Cards and Reports and published them with MOSS 2007

Created Reports using SSRS and Created Parameterized reports Cascading reports using SSRS.

Created Charts, Gauge reports using Dundas Charts.

Established naming and documentation standards.

Created complex variables, multiple breaks, sorts in the reports using SSRS.

Diagnosing and tuning the server optimal performance using Dynamic Management Views (DMV), Profiler and Index Tuning Wizards

Monitored SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.

Created UAT documents and performed unit and system test processing.

APPLABS TECHNOLOGIES, Hyderabad, India Jan 09 – Jun 09

SQL Server Developer/SSIS developer

Responsibilities:

Designed, coded, tested and implemented user interfaces, procedures and functions for new and existing software application requirements.

Created Business Requirements, Design, Functional Specifications and Flowcharts.

Install, tune, maintain and monitor SQL Server for the Production environment

Created DTS package to get data from different sources, consolidate and merge into one single source.

Created variety of reports for business to provide them with critical information about business status.

Actively involved in Normalization & De-normalization of database.

Created complex variables, multiple breaks, sorts in the reports.

Created generic Measure class for generic measures and created separate class for conditional objects.

Involved in System testing.

Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.

Environment:

SQL Server 2005, Access 2005& Windows 2K platform ADO.NET, MS Project

Professional Summary

Contact this candidate