PROFESSIONAL SUMMARY:

• 6 years of IT experience as a MS SQL Server Developer 2016/ 2014/2012/2008/2005 in various Industry verticals like Health Care, Finance and Insurance.
• Experience in developing and managing reports and Dashboard using Power BI.
• Extensive experience in MS SQL Server 2014/2012/2008/2005 BI tools (SSDT) like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL server Analysis Services (SSAS).
• Experience on Performance Tuning, Client/Server Connectivity, Query Optimization, running database consistency check with DBCC Commands.
• Extensive experience in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, and User Defined Functions.
• Hands-on working experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks.
• Highly experienced in complete cycle of SQL Server Integration Services (2012/2008/2005 ), Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
• Excellent in using all kinds of SQL Server Constraints and Dynamic-queries.
• Highly proficient in the dealing with Complex Stored Procedures, Views, Data Import/Export, System Views and functions.
• Experience in Extraction and Migration of data from various data sources like Excel, MS Access and Oracle to MS SQL Server by using import/export Wizard, DTS/SSIS, BCP and Bulk Insert utilities.
• Strong Experience in writing, debugging, fine-tuning and optimizing complex Stored Procedures, Cursors and Triggers in SQL Server by analyzing the Query Execution Plan and using the Profiler.
• Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
• Strong knowledge on Row Transformations, Partial Block and Block Transformations.
• Hand on Experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.
• Experience in creating Ad-hoc reports and data driven subscription reports by using Report Builder.
• Experience in creating complex drill down reports, parameterized reports, dropdowns and images, charts using SSRS 2012/2008/ 2005 , Crystal Reports and MS Excel for the analyzing data at an enterprise level.
• Experience in creating Cubes with dimensions and Facts Tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Experience in data architecture design and used data modeling tools like Erwin for designing the logical and physical data models.
• Excellent Communication skills, excelling as a team player and equally excelled when worked individually to achieve all project deliverables successfully.
• Proven ability to approach and solve problems effectively and independently.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2005/2008/R 2/2012/2014/2016 , Oracle

Database Tools: BIDS 2005/2008, SSDT 2012, Management Studio, Analysis Services (SSAS), Visual Studio, Query Analyzer, SQL Profiler, TFS.

Reporting Tools: SSRS, Report Builder, Business Objects, Crystal Reports.

Data Modeling Tools: ERWIN 7.3, Power Designer 12.5, ER Studio 8.0.1, MS Visio 6.0.

SQL, T: SQL, PL/SQL, VB.NET, C#.NET, ASP.NET, C, C++.

Applications: Microsoft Office 2000/2003/2007.

Operating systems: Windows 2000/XP/2003/2008.

EXPERIENCE:

Confidential, Pryor, OK

MSBI Developer

Responsibilities:

• Analyze utilization data to identify patterns and trends that may impact overall performance.
• Work closely with PM and Development teams to create and test the mappings to heterogeneous sources to the data ware house.
• Created Database Objects like Stored Procedures, Triggers and User Defined Functions (UDF) for this project.
• Created Views to maintain security of customer data.
• Created Indexes to get the high level performance.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SSIS packages.
• Designed SSIS packages for synchronizing the data between two different servers.
• Created and Scheduled jobs for various tasks and also was responsible for maintaining jobs.
• Extensively used Control Flow and Data Flow transformations like Execute SQL Task, FTP Task, Send Mail Task, Conditional Split and Fuzzy Lookup.
• Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions for better performance during package execution.
• Created SSIS Packages to migrate slowly changing dimensions.
• Create Power View reports using Power Pivot Data models.
• Import data from SQL Server databases and Analysis services into power pivot data model.
• Create calculated columns and calculated measures using DAX functions and format with appropriate data types.
• Designed, coded and implemented ad hoc reports in SSRS.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Heavily worked on SSRS report performance, stored procedure tuning, table partitions.
• Design and develop Tabular Data model (SSAS) and deploy that on to the Share Point server.
• Create Daily/Weekly/Monthly power view reports using Power View Reports and schedule them on the SharePoint for the refresh.
• Develop reports using Power BI Desktop App and Power BI Service.
• Create Dashboard from Power BI reports and share the same with the business users.
• Create Enterprise Gateway for the data sources and provided necessary permission to the report publishers.
• Involved in the design, development and maintenance of different cubes using SSAS.
• Developed and Scheduled SSIS Packages for loading Facts and Dimensions.
• Created Partition table for very large database for good performance.
• Configured mail profile for sending automatic mails to respective people when job is failed or succeed.
• Created partition function, schema and file groups for fact tables.
• Implemented Unit Tests and Integration Tests.

Environment: MS SQL Server 2016, Power BI, SSIS, SSRS, C#,TFS, Query Analyzer, Windows 2008, SSAS, Excel, SQL, Windows.

Confidential, Austin, TX

SQL Server BI Developer

Responsibilities:

• Analyzing and understanding the existing reporting environment.
• Worked closely with the Business analysts for requirements gathering, designing the database and creating workflow for report.
• Implementing the new reporting requirements for the business by making use of the new database and schema changes.
• Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse
• Created one central SSIS Master Package to execute multiple child packages with Control Flow and Data Flow. Utilized Parent Package and XML Configuration to dynamically pass variable values on runtime.
• Developed dashboards using Power BI.
• Participated in identifying data migration issues and resolved them.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities. Created and scheduling maintenance jobs in new environment using SQL Server Mailing Agent in SQL Server.
• Extensively used variables, break point, check point, logging, package configuration and event handler in SSIS packages to meet the business needs.
• Involved in performance tuning to optimize queries and enhance the performance of databases, SQL queries, and stored procedures using SQL Profiler, Execution Plan and Index Tuning Wizard.
• Created Complex SSAS Cubes with multiple fact measure groups, and multiple hierarchies based on the OLAP reporting needs.
• Built MDX queries for Analysis Services & Reporting Services.
• Designed, developed, created and tested PivotTable/PivotChart reports based on OLAP cubes and offline cubes.
• Created multiple partitions and aggregations for the different measure groups for improving performance of the cubes.
• Resolving the SSAS cube connectivity and data issues as and when needed.
• Interacted with Business Users to help them understand to generate reports/look at the business data with various drill down options with Excel via connecting to SQL Server Analysis Services (SSAS).
• Supported the production environment for any Data or Logic Related Issues, Test and Debug the use case scenarios and migrate the code as needed by coordinating with the DBA Team.

Environment: SQL Server 2012, SQL Server 2008 R2, SQL Server Integration Services (SSIS), Reporting Services(SSRS), TFS, Power BI, PowerShell, Pivot Tables, MS Visual Studio.Net, C#, SQL Profiler, MS Office Suite 2010, Windows 2003/2007 Server OS.

Confidential

SQL Server BI Developer

Responsibilities:

• Analyzing the transactional data in DB2 and other source systems using Data Profiler.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like (Progress Database, Excel, CSV, flat file, Text Format Data).
• Initially loaded data into staging tables using different transformations, control flow tasks, loop containers and data flow tasks, then moved the data into dimension and fact tables.
• Wrote complex Stored Procedures, functions and triggers as and when needed and to convert data logically as per the business requirements to improve the productivity of the claims processing system.
• Connected to the FTP Server and pull the group of Excel sheets into the SSIS from the folder located on FTP Server.
• Set up different kinds of transformations like Derived Column, Conditional Split, Lookup, Merge, Row Count, Data Conversion etc., in all the SSIS Packages.
• Set up ETL Jobs to run on a nightly basis into the Data marts by Scheduling SSIS Packages via SQL Server Agent.
• Coordinating the production deployment activities.
• Responsible for Performance Tuning of SQL commands and trouble shooting of Technical problems in SQL Server using SQL Profiler and the Database Engine Tuning Advisor.
• Documented all kinds of Reports and SSIS ETL Packages.
• Testing the new SSRS reports developed based on different filters and validating the outcome with the database.
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.
• Experienced in creating Ad-hoc reports, data driven subscription reports by using parameters, queries and reports in SSRS Report Builder, Developed data-driven subscription to end-users.
• Ensure all code and versions are properly maintained in TFS while migration is in progress.

Environment: MS SQL Server 2008 R2, TFS, T-SQL, SSIS, SSRS, Excel, Visual Studio 2008/2010, Windows Server 2008

Confidential

SQL BI Developer

Responsibilities:

• Perform ETL operations to support the data loads and transformations using SSIS.
• Created distributed partitioned views, debugging / troubleshooting stored procedures, upgrading existing ones according to new requirements.
• Perform Ad-hoc analysis as and when required by the higher management.
• Change existing stored procedures upon request to implement new business logic.
• Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task and different data flow tasks using T- SQL and VB scripts.
• Update SSIS packages to populate new dimensions and facts.
• Design SSIS packages for synchronizing the data between two different servers.
• Develop tabular, drill down, cascade and sub-reports using SSRS.
• Deploy reports onto the Reporting server and provide the data connections accordingly.
• Create roles and maintain the security by assigning users to appropriate permissions.
• Generated dynamic reports from the Multi-Dimensional databases.
• Involved in dimensional modeling with Star schema and created the data source views (DSV) and cubes using the identified fact and dimension tables.

Environment: MS SQL Server 2008, Reporting Services, SSRS, SSIS, Enterprise Manager, Query Analyzer, Report Builder, ERStudio.