SUMMARY

• Over 7+ years of experience in Microsoft BI Tools (SSIS/SSRS/SSAS) and T - SQL using SQL Server 2012/2014/2016.
• Experience in developing and debugging Stored Procedures and Triggers.
• Expertise in Visualizing and Analyzing Data using Power BI with cloud-based applications.
• Experience in T- SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER2005/2008 R 2/2012/2014/2016
• Experience in working with Self Service MS BI end user tools such as Excel 2010 (Power pivot), Performance Point Server (PPS), Power BI and Power view.
• Experience in T- SQL Developer skills include stored procedures, Indexes views, User Defined Functions (UDF), Triggers, and Distributed Queries, Scheduled Tasks
• Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Used tools like MS SQL Profiler, Index Tuning Wizard, and Pervasive and Windows performance for monitoring and tuning SQL Server performance.
• Developing SSIS packages for data migration between different sources such as flat file, excel, oracle, Sybase, DB2, MS accessing SQL Server SSIS.
• Create reports in Power BI preview portal utilizing teh SSAS Tabular via Analysis connector.
• Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.
• Excellent hands on experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS.
• Experience in by using Row Transformations, Block and Unblock Transformations for Performance Tuning in SSIS packages.
• Hands on experience working with Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Creating SSIS Packages for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union
• Experience in working with Data Cleansing technique in ETL procedures.
• Experience in creating reports such as Parameterized, Cascading, Drill through/Drill down Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.
• Good experience in creating pivot tables and charts in Excel using data sources (SQL Server, SSAS cubes, and Access) and power pivot.
• Excellent knowledge of HIPAA (Health Insurance Portability and Accountability Act) transaction codes such as 270/271 (inquire/response health care benefits), 276/277 (claim status), 470 (benefit codes), 835 (payment or remittance advice), 837 (health care claim) and 834 (benefit enrollment).
• Experience developing BI/dashboard components using tools like BIDS, PerformancePoint and Power Pivot.
• Creating and Deploying SSRS Reports on teh portal for user accessibility.
• Experience in implementing surrogate key generation strategy in teh Data warehouse.
• Experience in generating On-demand and Scheduled reports for management decision and business analysis by using SSRS.
• Experience in databases like MySQL and NoSQL like Mongo DB
• Used Microsoft Azure date storage and Azure Data Factory, Data Lake
• Experience in querying Azure SQL Server and working on Microsoft Dynamic CRM
• Well versed with HIPAA, Facets, claim adjustments, claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing corresponding solutions.
• Proficient experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Experience in performance tuning, processing and deploying teh cubes
• Experience in cube partitioning for better database performance.

TECHNICAL SKILLS

SQL Server Tools: SSDT, SSMS, BIDS, Report Builder, DTS, Profiler, DTA, Upgrade Advisor

Monitoring & compliance Tools: Lite Speed, Spotlight, SCOM, SQL secure

ETL & Reporting Tools: SSIS, SSRS, SSAS, Excel 2013, Power View, Power Pivot, PPS

Databases: SQL Server 2014/2012/2008 R2/2008/2005, Oracle9i,10g, Teradata, SAP

Programming Languages: SQL, T-SQL, PL/SQL, C, C#, VB

Operating System: Windows 95/98, NT, Windows XP/2003/2000,Unix,MS-DOS

Web Technologies: Angular JS, HTML, XML, VBScript, SharePoint 2010, C#, ASP.NET, VB, .NET

Tools: Erwin, VS 2008/2005, Visio, TFS, Visual Source Safe, Sub Version

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Responsibilities:

• Responsible for gathering/refining requirements from teh business for developing dashboards.
• Worked on Software life cycle development (SDLC) involving in all stages of development.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T- SQL code and SQL joins for applications. experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, Azure Databricks, Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Services and Tableau.
• Create custom Power BI Reports and Dashboards to in Confidential and automate Dynamics CRM and Project Online reporting. Specifically, highly useful and visually pleasing reporting to be used by AccuWeather executives, department heads, Sales staff, and Project Management staff.
• Created Grouping, sorting columns and writing expressions according to teh business requirements.
• Worked on Views, cursors, CTE's, schemas, permissions and performance issues with client/server database design.
• Created T- SQL scripts, which generated tables, relationships, based on teh finalized ER-diagram
• Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Involved in creating teh external and internal tables in Azure SQL Datawarehouse and created stored procedures to move teh data from external to internal tables.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions.
• Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL taskin SSIS.
• Design and develop teh data factory pipelines to move teh data from oracle database to Azure Data Lake Data Lake Store. building reports from Dynamics 365, Practice Engine, and healthcare claims data along with integrating and embedding Power BI Reports within Microsoft Teams, Microsoft SharePoint, and client portals.
• Developing and wrote/rewrote multiple Interfaces utilizing Kronos Workforce Integration Manager (WIM).
• Created SSIS process design architecting teh flow of data from various sources to target.
• Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, troubleshooting process issues and errors (SSIS).
• Provided Production support to Tableau users and wrote custom SQL queries to support business requirements.
• Created Power BI Dashboards and integrated them to SharePoint.
• DAX operations were used to create custom calculations in Power Pivot for Microsoft Excel workbooks and Analysis Services Tabular data warehousing.
• Used Power BI Desktop to develop data analysis multiple data sources to visualize teh reports.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Designed and tested teh business intelligence reporting using Cognos Power Play and Impromptu tools.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012.
• Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI's on a cube.
• Create PBI and scorecards for business stakeholders.
• Created, Implemented, Modified teh visualizations in Power BI reports and Dashboards on client requests.
• Created Calculated Columns and Measures in Power BI and Excel depending on teh requirement using DAX queries.
• Given Power BI to Business users which halp them to create their own Reports/Dashboards in teh Front End.
• Involved in Configuring and Upgrading teh On-Premises Data gateway between various Data sources like SQL Server to Azure Analysis Services and Power BI service.
• Involving in teh production support activities for Kronos application in Time and attendance, Absence management and Accruals modules.
• Implemented history preserving using Table comparison, History Preserving and Key generation transformations in warehouse /dimension workflows.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Worked with Tableau and Alteryx Schedulers and workflows to provide end-to-end automation.
• Worked on Microsoft Azure data technologies experience in Azure SQL Data Warehouse.
• Did debugging using break points and data viewers and performance tuning of ETL data flows.
• Building, publishing customized interactive reports and dashboards, report scheduling using SSRS 2016.
• Responsible for scheduling teh subscription reports with teh subscription report wizard.
• Implemented and enhanced existing reports like Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.
• Integrated custom visuals based on teh business requirements using Power Bi desktop
• Developed Custom Calculated measures using DAX to satisfy business needs
• Deployed teh generated reports directly on teh client's workstation.
• Preparing Dashboards using calculations, parameters in Tableau.
• Created Backend validations using Insert/ Update and Delete triggers.
• Part of Relational Data Warehouse Designs and TEMPeffectively identified and created Facts and Dimensions tables.
• Creating Indexes and used Scan and Seeks for performance tuning.

Environment: MS SQL Server 2012, Tableau, MS SQL Server Reporting Services, SQL Server Analysis Services, Power BI, Windows Server 2007, Jira, Azure, Agile, ASP.NET.

Confidential, Wayne, PA

Responsibilities:

• Installed and Configured MS SQL Server successfully.
• Expertise in Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Involved in gathering requirements in conceptual data modeling phase.
• Involved in designing database using MS Visio.
• Working knowledge of CRM’s interoperability capability with MS Office, MS Office 365, SharePoint, and MS BI Stack C#/VB.net, ADO.Net, XML, T/SQL, JQuery, JavaScript, Web Services, ASP.NET, and Silverlight skills
• Created Custom Cognos report pages by modifying XML files and other Configuration files.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T- SQL.
• Involved in developing complex Azure Analysis Services tabular databases and deploying teh same in Microsoft azure and scheduling teh cube through Azure Automation Runbook.
• Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
• Worked as a developer in creating complex Stored Procedures, triggers, cursors, Indexes, tables, and views and other SQL joins for building various applications.
• As a part of optimization Used MAP operations to route UPDATE and INSERT records in warehouse workflows.
• Created and managed Clustered indexes and Non-Clustered indexes and optimized queries using execution plan.
• Worked with internal SQL developers to migrate new configuration in a mass download to Kronos application systems.
• Improved teh performance of SSIS packages by enabling Parallelism in teh Control and Data Flows, usage of synchronous transformations.
• Developed multiple dashboards with Power BI depicting differing KPIs for business analyses.
• Implemented pivot/un-pivot, transpose features of Power BI to load data into excel Power Pivot.
• Employed bar charts, bubble charts, and Power map to answer business questions with Power BI
• Created and maintained logins, roles and permissions on teh SQL instances and databases and provided required privileges according to teh user's requirements.
• Used MS Access for creating teh tables.
• Developing teh reports using POWER BI, Power Pivot and SSRS and SSIS, SSAS
• Adding teh feeds and Scheduling teh jobs
• Experience in writing complex queries and table joins using Oracle
• Implemented High availability concepts, Data base Mirroring, Replication and log shipping.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in development, enhancement, testing and performance tuning of teh application.
• Created Database Maintenance Plans for teh Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Resolved various performance issues by running DBCC command.
• 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.
• Worked on various kinds of Transformations like Import Column, Export Column, SCD and Lookup in SSIS as per teh client's Requirement.
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
• Involved in writing stored procedures and User Define Scalar Functions (UDFs) to be used in teh SSIS packages and SQL scripts.
• Used SSIS features like package event handlers, property expressions, and package configurations, transactions in packages, checkpoints and protection levels.
• Used C# and VB.Net scripting when performing SSIS packages.
• Utilized SSRS reporting services to generate several types of reports from teh database.
• Created Report Subscription using SSRS.

Environment:: MS SQL Server 2008/2012/2014 (Query Analyzer, SQL Profiler), SSRS ( SQL Server Reporting Service), SSIS ( SQL Server Integration Services), Power BI, Power View, Business Intelligent Studio, SQL Server Management Studio, ASP, Crystal Report, Erwin, T- SQL, MySQL, OLTP, Oracle 11g, Enterprise Manager, MS Excel, Windows XP Professional, TFS.

Confidential, Cary, NC

Responsibilities:

• Designed and Created SSIS packages.
• Designed SSRS and excel reports, expense analysis, and balance sheet analysis.
• Designed, reviewed, and created primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Created Power BI driven dashboards and reports
• Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS.
• Based on business requirement, developed teh Complex SQL queries with Joins and T- SQL, Stored procedure, Views, Trigger to implementing teh business rules and transformations
• Creating pipelines using Azure Data factory and Azure apps services to pull data from Web services and API's in Azure SQL.
• Used different transformation controls like Look up, Conditional split, data conversion, Unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command etc.
• Use login feature for analysis purpose
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T- SQL.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Prepared complex reports using SSRS and deployed into MS CRM.
• Processed teh data mapping for all teh migrated jobs using SSIS and Power- BI
• Set up SQL Profiler to trace various Database activities, Application Responses, and their Performance to tune them
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports
• Developed Dashboards and Reports with Excel, SQL Server, SharePoint List and Report Server data sources using Power- BI Service Desktop tool.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power- BI and SSRS reports.
• Created script to migrate SQL server object from one environment to another environment
• Used teh SQL Server profiler to capture and store teh execution plan. Created necessary indexes
• Used SQL SERVER AGENT to automate teh process of rebuilding indexes at regular interval for better performance.
• Represented reports in different forms using graphs, charts, tabular, area and pie charts as required
• Uploaded and organized reports in report manager folders. Also, providing security and roles for those reports.

Environment:: MS SQL 2008 R2/2012/2016, SSIS, SSRS XML, T- SQL, DAX, MS Access 2010, MS Word, MS Excel, MS CRM,VBA (Visual Basic for Applications), Share point, DTS, Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server, Power-BI Tool.

Confidential, Merrillville, IN

Responsibilities:

• Responsible for gathering and defining user report requirements and developing appropriate interfaces for teh reporting infrastructure environment to meet customer business needs, based on business processes and data entities between various systems.
• Designing and implementation of public and private facing websites on AWS Cloud.
• Performed fine tuning of Stored Procedures and SSIS packages.
• Generated SQL queries for teh reporting team.
• Used PL/ SQL Tables, Cursors to process huge volumes of data and used bulk collect for mass update as performance improvement process.
• Created PL/ SQL module which was used to integrate teh existing data from third parties and on to teh database.
• Identified user catalog errors that was keeping DB2 RESTORE SYSTEM from working correctly.
• Developed C# base - Oracle Database engineering utility software for teh support.
• Experience with administering Cloud Computing Products e.g. Amazon Web Services (AWS).
• Written stored procedures which are used in teh source for SSIS packages.
• Used VB.Net, VB Scripts for loading data using SSIS Packages.
• Created complex Stored Procedures, Tables, Views, SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Created SSIS package to check XML file validation and data validation to match teh requirements.
• Experienced in slowly changing dimension in SSIS packages.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Was involved in teh Design of Data Modelling and Implementation of database design.
• Created SSIS Packages to load data from sources like Excel (.xls, .xlsx), Flat Files, .csv files.
• Created Reports using Power Pivot in excel by getting teh data from SSAS data model.
• Loading teh data from Oracle DB to RDMS tabular model and running teh SSIS packages and refreshing SSAS models and teh Excel's.
• Scheduled and monitored loads and refreshes from teh transactional systems.

Environment: MS SQL Server 2008R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), C#, PL/ SQL, AWS, Business Intelligence Development Studio (BIDS), VB.Net, VB Script, SQL Server Analysis Server (SSAS), MS Excel.