SUMMARY:

• Over 8+ years of IT experience in the use and development, design, support and migrate of Microsoft SQL Server 2008r2/2012/2016 database.
• Microsoft Certified Professional: Microsoft SQL Server 2012
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Proficient in MS SQL Server suite of products like SSRS, SSIS and SSAS of MS SQL Server 2008r2/2012/2016.
• Good Understanding of SDLC and Relation Database Architectures and MS SQL Server Architecture
• Strong SQL Server 2008r2/2012/2016 Developer Skills including writing user defined functions, views, query writing
• Involved in Logical/Physical design of database and maintenance
• Experienced in Agile development life cycles
• Extensive knowledge in SQL Server 2008 r2 Developer Skills including writing user defined functions, views, query writing
• Hands on experience in installing, configuring, managing, upgrading and monitoring and troubleshooting SQL Server 2008r2.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in developing, monitoring, extracting and transforming data using SSIS, Import Export Wizard, and Bulk Insert.
• Experience in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Worked Extensively on ETL process using SSIS package.
• Experience in SQL Server SSIS (Integration Service) package design, constructing, and deployment.
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Used various formatting techniques like Interactive sorting, grouping to created user friendly reports.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Experience in creating and managing Event Handlers, Package Configurations, Logging, System and User - defined Variables for SSIS Packages.
• Experience in creating Packages using SSIS for integration services.
• Proficient in defining Query for generating drill down reports, Tabular reports, matrix reports, sub reports in SSRS 2008r 2/2012/2016.
• Proficient in using global variables, expressions and functions for the reports.
• Worked on Adhoc excel Pivot reporting for top level management on day to day analysis
• Experience designing and developing Visualizations/Dashboards in Microsoft PowerBI using DAX from various data sources like Azure SQL Server, Analysis Services AX & CRM and Excel .
• Deployments in public cloud services such as AWS and Azure
• Data modelling, manipulation, referencing, validation, cleansing, migration and mapping.
• Implement best practices in data visualization dashboards & Reports using various BI tools
• Migration from multiple systems and testing in each phase and data mapping.
• Created SSRS 2008, EXCEL 2007 reports for internal purposes on daily basis .
• Identified, explored and solved document data integrity issues
• Experience in designing and developing applications using Microsoft Technologies and .NET Framework.
• Experience in developing Microservices using ASP .NET core
• Experience working with VB.net , and C# programming language.
• Experience in working with various ADO.NET Components : developing Business Reports using SQL Server Reporting Services (SSRS)

TECHNICAL SKILLS:

Languages: SQL, XML, ASP.NET 4.5, C++, C#, JAVA,PYTHON, SAP,SAS HTML, CSS

Database: MS SQL Server 2014/2012/2008 R2, Oracle, Microsoft Office, MS-Access.

SQLCMDSQL-Server Tools: Visual Studio, SQL Server Management Studio, SSIS, SSRS, SSAS

Operating Systems: Windows XP, Windows7, Windows NT/2000

Tools: Microsoft office

PROFESSIONAL EXPERIENCE:

Confidential -Merrillville, IN

Sr. SQL BI Developer

• Researched new developments and uses of current systems and applications, as well as upgraded systems and applications to meet HIPAA standards
• Identified requirements on existing/proposed systems analyzing applications, programming, and operations
• Used PowerApps for Forms Development
• Implemented System Development Life Cycle to ensure all necessary steps for planning, creating, testing and launching of the system
• Performed database design, modelling, performance tuning & optimization
• Maintained historical data using different approaches
• Knowledge about Facets (TriZetto Claims processing system) which helps the organizations to perform their day to day operational work by utilizing any or all of the application groups
• Proposed & demonstrated new solutions, modifications to architecture & design
• Developed new forms using PowerApps and integrate to SharePoint Online
• Integrated PowerApps, MS Flow and SharePoint together to create more intuitive and high-performance Reports
• Created SSIS packages for importing the Excel layouts into the database using SSIS
• Used BIDS to design SSIS packages to transfer data between servers, load data into database, archived data file from different DBMS, and scheduled the job to do this task periodically
• Worked in OLTP/OLAP technologies with data warehouse
• Loaded data from ODS to Data Warehouse using SSIS packages
• Proficient is writing complex T-SQL code, stored procedures, functions, and SQL statements that involved dynamic SQL i.e. writing SQL codes dynamically
• Created Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors, Temp tables and Dynamic SQL queries
• Creating T-SQL statements of various complexities involving triggers, stored procedures, views and dynamic SQL to automate business functions and providing ad-hoc data requests
• Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS) 2014
• Experience in SSIS script tasks, look up transformations and Data flow tasks using T- SQL, C# and Visual Basic scripts
• Developed integration of Power BI reports into PowerApps and interacting the data by visuals through PowerApps and modifying the existing records in real time accordingly
• Configured systems and automated administrative tasks
• Identified requirements on existing/proposed systems analyzing applications, workflow, and operations
• Developed stored procedures, views and User Defined Functions using T-SQL statements
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts
• Back end Experience in Microsoft SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs
• Worked with complex Stored Procedures, DTS packages, cursors, views, table partitioning, indexing, collations, SQL Injection
• Customized SP list using PowerApps and develop flows
• Using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Designed and Developed matrix, tabular and parametric Reports using SSRS 2014
• Designed and developed Drill down and Drill Through reports with Drop down menu using SSRS
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server
• Developed packages using various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2014
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Maintain and optimize the existing databases; monitor database performance and growth, performance tuning, generate reports per the business requirements using SQL Server Reporting Service (SSRS) and populate data warehouse using SQL Server Integration Service (SSIS)
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status
• Designed SSRS reports with sub reports, expressions and queries, and prepared Ad-Hoc reports through report builders
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server
• Created Interactive dashboards on Healthcare and Insurance data using Power BI
• Created Roles and implemented Row level security for user Authentication in POWER BI
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources
• Utilized Power Query to Pivot and Un-pivot the data model for data cleansing and data massaging
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas
• Created Power View Reports using the Tabular SSAS models in Excel 2010 and 2012
• Configuring Power BI Gateway for SSAS Live connection and Direct Query
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management
• Write Stored Procedures to populate various dimensional tables and fact tables for the Data Warehouse
• Monitored applications and systems on daily basis for optimal performance and issues
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas
• Designed, implemented, and supported Tableau to enable tracking and trending of production and other Business Analytics (BA) / Business Intelligence (BI)
• Developed reports in Tableau, Crystal and converted Crystal reports in to SSRS reports
• Extensive use of DAX (Data Analysis Expressions) functions for the Reports and Tabular Models
• Migrated managed cloud service to Azure and replicated Database with real-time/production data
• Managed and supported User Acceptance Testing (UAT)
• Build efficient back-end features in C#
• Involved with SQL Query Optimization and VBA Scripts
• Built high performance reports and queries for claims, billing, payment and eligibility teams and maintained operational controls to meet service level agreements
• Knowledge of HIPAA rules and regulations, health care payer claims and payment operations
• Worked with Health care provider billing and payment operations, Member eligibility operations, Claims, Encounters, and Eligibility EDI operations
• Generated technical design documents, deployment scripts and participated in production deployments
• Generated Data Analytics reports for large volume of data
• Automated flow of work and process to streamline delivery of services using ERP system
• Planned and organized Agile Scrum project developments to achieve high level of performance
• Delivered agile projects that provide exceptional business value to users
• Integrated ASP.Net MVC 4.5 with Entity Framework to create web application for current project
• Worked with UNIX to install applications and troubleshoot as required
• Provided support for critical production systems and End User Query Support
• Performed scheduled maintenance and support release deployment activities after hours
• Trained Providers, Administrator, Staffs on implementation as well as use of reports and dashboards

Environment: SQL Server 2014/2012, SSIS, SSRS, SSAS, MS Excel 2007, C#, VB.Net, Windows Server 2010, Microsoft SQL Server 2005 Reporting Services(SSRS), Team Foundation Server (TFS)

Confidential -Minneapolis, MN

Sr. SQL Developer

• Involved in optimization of queries (SQL Query Optimization), improving the performance by using various approaches from execution plans, Index optimization, and DMV’s
• Created Complex SQL Queries using Views, Indexes, Triggers, Stored procedures, cursors and UDF’s
• Normalization and De-Normalization of tables
• Created partition table for very large database for good performance
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, and Send Mail task etc.
• Maintained records in Excel Spread Sheet and imported data into SQL Server Database using SSIS.
• Used different Transformation in SSIS as per design specifications
• Applied various data transformations like Slowly Changing Dimension, Change Data Capture Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Created jobs using SQL Server Agent and scheduled them to execute the SSIS Packages on a predefined time interval by the business
• Based on the OLAP reporting needs, developed complex SSAS cubes with multiple fact measure groups, and multiple dimension hierarchies
• Build the OLAP cubes with Dimension and Fact Tables using SQL Server Analysis service .
• Created MDX queries to extract data from the data mart
• Responsible for monitoring and tuning SSRS Report Performance
• Involved in Logical/Physical design of database and maintenance
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server ( SSAS )
• Created SSIS packages using Data transformations like conditional splitting, For Each Loop, For loop
• Worked on T-SQL in constructing User Defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity
• Extensively consumed Object-Oriented Principles in C#
• Developed .NET core functionality with the ASP.NET MVC Framework
• Designed and developed a Presentation layer, Business logic and Data layer for employee, Provider and Validation List Item Lookup details using ASP.NET, C# and SQL Server database
• Performed systems analysis, design, development, quality assurance and integration
• Experience with document analysis, data requirements workshops, data process descriptions, use cases, data analysis, task and workflow analysis
• Developed design and functional specifications as well as produced deliverables on time
• Assisted in implementation and production support along with system enhancements for multiple applications to ensure end-user needs
• Worked with TFS for Source Control
• Performed different testing techniques such as Unit testing

Environment: SQL server 2012, Windows 2008R2 Standard Edition, SSIS, SSAS, SSRS, VS, SQL Diagnostic Manager, ETL, Team Foundation Server (TFS), Microsoft Out Look, .NET

Confidential - Rochester, MN

SQL Developer

• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema
• Involved in developing applications in C# to meet business requirements using Visual Studio.NET 2012
• Involved in database design process and data modeling process
• Developed stored procedures, complex queries, triggers and functions by using PL/SQL
• Used all kinds of SQL Constraints (Primary Keys, Foreign Keys, Defaults, Check and Unique)
• Designed ETL SSIS packages to process data to target databases
• Used various ETL tools like SSIS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping
• Migrated data from Heterogeneous Data Sources and legacy system (Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints
• Used Data Conversion task in multiple ways while creating packages using SSIS
• Worked on performance tuning in SSIS to meet performance requirement using different concepts like Parallelism and lookup Transformations
• Generated Reports using Global Variables, Expressions and Functions for the reports
• Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 & type 2 changes
• Worked on ADO.NET components SQL Connection Object, SQL Command Object, Data Reader, Data Adapter, Data Set and Data View to provide communication to the database
• Worked on Database Security including creating Logins and Roles for users to access the database
• Managed security logins and worked with Windows authentication and SQL server authentication
• Generated Reports using Global Variables, Expressions and Functions for the reports
• Experience working with TFS Check in, check out, assigning tasks and updating tasks
• Scheduled delivery of several reports to multiple users using Subscriptions in different formats Environment: MS SQL Server 2008r2/2008 r2/2012, MS SQL Server Reporting Services 2008R2/2008/2012 R2, T-SQL, SSIS 2008r2/2008/2012 R2, TFS

Confidential -Strongsville, OH

MS BI Developer

• Implemented ETL process to download files by email attachments and import data into Data warehouse system through SSIS packages
• Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes
• Designed and developed databases for OLTP and OLAP Applications
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications
• Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures
• Designed and developed SSIS ETL processes (SSIS 2008/2012)
• Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services (SSRS)
• Developed reports in Tableau, Crystal and converted Crystal reports in to SSRS reports
• Implementing SSRS solutions, used dashboards and gauges to enhance for the business users
• Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
• Merged different queries in query editor to cross reference data between them
• Appended related queries to single query to analysis the data
• Scheduled the Jobs according to frequency of files so that data is loaded into database in a timely manner
• Generated matrix, drill down, drill through, sub-reports, chart, and multi parameterized reports
• Designed SSRS reports with sub reports, expressions, queries, Ad-Hoc reports through report builders
• Implementing SSRS solutions, used dashboards and gauges to enhance for the business users

Environment: SQL Server 2005/2008/2012 , SSRS 2012,2008/2005, SSIS 2005,2008,2012 SSAS, T-SQL, Crystal Reports, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP