SUMMARY:

• Around 8+ years of IT experience as a MS SQL Server BI Developer 2014/2012/2008 R2/2008 in various Industry verticals like Banking, Finance, Health Care and Insurance.
• Very good understanding of SQL Server Architecture design and Data - Warehousing Concepts.
• Extensive experience in Data-Warehousing projects as a Business Intelligence developer worked in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) SQL Server 2014/2012/2008 R 2/2008/2005.
• Designed and developed several enterprise reports (SSRS/Crystal Reports/ Power BI) using the data from ETL Loads and heterogeneous sources.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Views, Indexes, User profiles, SQL joins, CTEs, Cursors, DDL, DML Scripts, data modeling.
• Worked in Logical modeling using the Dimensional Modeling techniques. Data modeling, creating star and snowflake schemas in SSAS.
• Experience in creating SSIS Packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) and SQL databases by using multiple transformations and containers,.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• 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.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Extensively worked with Parameterized Reports, Report Snapshots, and Linked Reports and used Report Manager for deploying reports in SSRS (2008R2/2008/2005).
• Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.
• Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor.
• Experience in developing Ad-hoc reports using Business Objects, Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, SDLC concepts.
• Experience in implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points, Transactions and Expressions for SSIS Packages.
• Proficiency in creating diverse types of reports such as Cross-Tab, Conditional, Drill-down, Top N,
• Summary and Sub reports, and formatting them.
• Experienced in creating Queries using global variables, expressions, and functions for the reports.
• Experience in using Microsoft Azure Cloud Platform.
• Worked in collaborative team environment with other developers, business analysts, and a project management team.
• Can do Attitude and ability to effectively communicate with all levels of the organization such as Management, technical and customers.

TECHNICAL SKILLS:

RDBMS: SQL Azure, MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 , Access, Excel.

Database Tools: BIDS 2012/2008 R2/2008/2005, Management Studio, Visual Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, SSIS, SSRS.

Programming languages: SQL, T: SQL, PL/SQL, VB.NET, C#, Hive

Scripts: PHP, JavaScript, CSS, VBScript, HTML and XML.

Operating systems: Windows NT/2000/XP/2003/Vista/Windows 7/8.

Reporting Tools: Business Objects, Tableau, SSRS, Power BI, Power Pivot.

Other: Microsoft Office, Visio, Dream viewer, Team Foundation Server (TFS) and Visual SourceSafe.

PROFESSIONAL EXPERIENCE:

Confidential, Ballantyne, NC

SQL BI Developer/MSBI Developer

Responsibilities:

• Successfully Completed independent solo project in migrating SSRS legacy reports to the latest 2017 version reporting services.
• Assess the current-state of the environment and project scope and refine a strategic migration plan of SSRS reports
• Provided recommendations to team leadership regarding existing SSRS target infrastructure
• Performed testing and development of necessary changes in lesser environments to bring about standard practices to SSRS reports, according to best-practices and guidelines, including and not limited to:
• Migrated/Upgrading reports from SSRS / SharePoint 2007 to SSRS 2017 versions (native mode)
• Remove imbedded data sources from reports and leverage the use shared data sources
• Utilize Active Directory accounts instead of SQL Server logins for data source authentication
• Implement data-sets if necessary.
• Build completely new server’s for dev, QA and Prod and installed all the necessary reporting services to perform the migration.
• Modified SP's and formulated coding and scripting to be utilized for reports within the organization
• Performed functional and performance QA testing
• Develop new reports and perform maintenance of existing reports
• Sql Server Data Tools installation and configuration Reporting Services
• Optimizing and Performance Tuning SQL Scripts in order to make reports run smoothly and efficiently
• Provided start to End documentation for the work performed and archived it for further reference.
• Modified SharePoint 2007 reports per business changes using report builder 2.0.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Environment: Visual Studio 2017, MS SQL Server 2016, SSRS, Power BI, 2017 sql server Server Data Tools, 2007 Share Point.

Confidential, Charlotte, NC

SQL BI Developer/MSBI Developer

Responsibilities:

• Designed ETL process using SSIS to extracted data from flat files, excel files and SQL server database
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Developed and migrated the existing store procedure from legacy database to new database.
• Writing queries to create stored procedures, User Defined Functions, Views, Triggers and CTEs (Common Table Expressions).
• Converted around 15 SSRS Pharma reports store procedure to new database along with unit testing and promoted it to production taking ownership end to end and making sure everything worked as per the requirement
• Production support, ad hoc queries meeting requirements from other development teams in a test driven agile development environment.
• Creating the Packages on SSIS by using various data Transformations like Derived Column, Lookup, Conditional Split, Script, Merge Join, Sort and Execute SQL Task.
• Worked in troubleshooting and debugging stored procedures, upgrading existing ones according to new requirements.
• Worked on Production support tickets and resolved them on timely manner and received appreciation from Business user
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Created Power BI data visualization utilizing cross tab, maps, scattered plots, pie, bar and density charts.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Environment: SQL Server 2012/2014, Windows Server 2008, Visual Studio 2012, TFS, SSRS, SSIS, Power BI, Agile, Scrums.

Confidential, Charlotte, NC

Database Developer/MSBI Developer

Responsibilities:

• Developed and modified Branch Reports, Management Reports SSRS Reports as per the requirement.
• Designed and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Reporting Services (SSRS). Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Extensively worked on Cross Tabbed and Matrix reports using SSRS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2012 and 2014.
• Developed Query for generating Drill Down and Drill Through Reports in SSRS 2012 and 2008.
• Designed and formatted SSRS Reports using Parameters and Expressions for the Reports.
• Refreshing the required Databases through SSIS packages.
• Monitoring SSIS Jobs closely and checking the Data in tables
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Involved in large migration project to migrate reports from in SSRS.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Updated Applications affected by progress Telerik UI for ASP.NET AJAX Security Vulnerability and tested all the application using Telerik.Web.UI.dll and debug the error and made the applications run successfully.
• Modified the existing ACT (Access certification Tool) SSIS package to version 15.7 in order to confirm compliance with last login Date requirement.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Working on new change requests on ssrs reports. Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages through Active Batch Job Schedule
• Created a SSIS package for BULK Copy Program exporting the tables to flat file to new NDM shared location.

Environment: SQL Server 2014,2012, SSIS, SSAS, SSRS, T-SQL, Agile, XML, MS 2010, 2012, 2015 Visual Studio, Team Foundation

Confidential, Wilmington, DE

MS SQL Business Intelligence Developer

Responsibilities:

• Gathering reporting requirements from users and business analysts and analyzing requirements.
• Generated reports using SSRS that could be used to send information to different Primary vendors, clients and managers.
• Designed and implemented stored procedures and triggers for automating tasks.
• Created SSIS Packages for Import/Export data to/from SQL Server.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Experience Microsoft Azure date storage and Azure Data Factory, Data Lake.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement. Performing query plans and making sure each and every query is using appropriate useful indexes.
• Involved in handling live site production issues. Providing a hot fix for the problem.
• Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
• Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, Grids using Sql Server Reporting Services 2008 R2, 2012 and COGNO’s.
• Involved in Dimensional Data modeling.
• Involved in developing the Azure Solution and Services like IaaS and PaaS
• Bug fixes in SSRS and stored procedures as necessary.
• Played roles in production support for SSRS jobs.
• Modified calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Optimized long running stored procedures and queries for effective data retrieval.
• Involved in Dimensional Data modeling.
• Created script tasks and components with C# and VB.NET in SSIS as part of ETL load.
• Use of SharePoint and TFS for version controlling, storing and report the same by creating Tasks in TFS.
• Developed Dashboards to analyze sales, supply chain.

Confidential, San Jose, CA

MS SQL Business Intelligence Developer

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers in the database.
• Created and Scheduled jobs for executing the stored SSIS packages, which were developed to update the database on Daily/Weekly/Monthly basis. Developing load scripts to populate data into the data ware house.
• Monitoring the jobs schedule and performance of the transform jobs.
• Taking care of some DBA tasks such as creating backup maintenance plans, restoring databases, creating and monitoring SQL jobs.
• Improving performance of the server by analyzing the long running queries and performance tuning them.
• Generated Sub-reports, Drill-Down, Drill - Through and Parameterized reports using SSRS reports according to the customer requirements.
• Creating internal Operational reports to analyze the performance of the server in terms of load duration, transformation speed of the jobs (To track the time for loading the data into the staging tables and transforming them to the data warehouse)
• Developing operational reports to monitor the load count of the records and the duration of the load.
• Created Dashboards, scoreboards to generate more usable information the form of data visualization.
• Experience in working with tabular models.
• Experience in working with Power Pivot.
• Experience with handling the adhoc issues in production environment.
• Experience with dealing the issues with OFF shore team in Israel.
• Provided on call support on rotation basis.
• Experience using C#.
• Expertise in Data Modeling using Star and Snow Flake Schemas using Ralph Kimball and Bill Inmon Methodology, ER Model, Dimensional Data Modeling, Dimensional Hierarchies, Physical & Logical Data Modeling.
• Build the OLAP cubes with Dimension and Fact Tables using SQL Server Analysis service (SSAS).
• In SSAS, created cubes on top of the data warehouse for reporting purpose
• Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Experience with Team foundation server bug tracking system.
• The team flows the agile methodology.
• Interacting with the users for requirements.
• Documenting the requirements and implementation.
• Developing the platform using Hadoop to store large data.
• Experienced in running Hadoop streaming jobs to process terabytes of xml format
• Experienced in managing and reviewing Hadoop log files
• Experienced in defining job flows
• Managing and resolving SCOM alerts.
• Monitoring the Jobs using ICM portal and fixing the issues immediately.
• Experience working with live site production issues.
• Customized Microsoft SSRS API for custom security.
• Understanding about data related to Microsoft devices Xbox, Surface.

Environment: Hadoop, Hive, SQL Azure, MS SQL Server 2014/2012, SSRS, SSIS, SSAS, T-SQL, VB Script, SCOM, TFS, Server data tools, SharePoint, SCOM.

Confidential, Pleasanton, CA

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Gathering reporting requirements from users and business analysts and analyzing requirements.
• Designed and altered database objects to support new custom applications.
• Involved in Dimensional Data modeling.
• Optimized long running stored procedures and queries for effective data retrieval.
• Created Stored Procedures, Views, and Functions in the Database.
• Reorganize database structures as needed, automate procedures at regular intervals.
• Developed Operational reports to support complex user requirements using SSRS.
• Involved in creating package to load Member Master Table in SSIS, which is helpful in tracking the history of tables.
• Worked with various transformations like Lookup, Fuzz Lookup, Merge, Sort, Multicast, Conditional Split, Script Component, Loop Containers, Execute SQL Task and lot more using SSIS.
• Involved in creating various sub reports, drill down, drill through and parameterized reports.
• Involved in creating SSRS Reports, which are, excel friendly to perform various operations like pivot.
• Developed Dashboard reports to analyze the enrollment, payment and member suspend history.
• Developed Reconciliation Reports to analyze the difference in different payment systems.
• Involved in deployment of the reports to Windows Azure.
• Involved in Unit Testing, Validating Reports and Production Support to resolve ongoing Production Problems by reviewing design changes made to production systems Involved in Performance tuning the SQL Server Queries used in SSRS Reports.
• Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Monitor and troubles shoot production issues during deployments.
• Monitor strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and development databases.

Environment: SQL Azure, MS SQL Server 2012, SSRS, SSIS, SSAS, T-SQL, VB Script, Server Data Tools, Share Point.

Confidential

MS SQL Server Developer SSIS/SSRS/SSAS Developer

Responsibilities:

• Defined Check Constraints, functions, indexes, synonyms and views.
• Created and modified complex TSQL batches/stored procedures.
• Involved in Logical/Physical design of database and maintenance.
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement. Performing query plans and making sure each query is using appropriate useful indexes.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Involved in defining referenced relationships with the measure groups and fact tables.
• Created various parameterized reports, drill through reports using SSRS.
• Generated reports using SSRS that could be used to send information to different Primary vendors, clients and managers.
• Designed and implemented stored procedures and triggers for automating tasks.
• Created SSIS Packages for Import/Export data to/from SQL Server.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SSIS packages.
• Scheduled jobs and alerts using SQL server agent.
• Implemented a well-planned backup and restore strategy that protects databases against data loss.
• Responsible for monitoring and tuning SSRS Report Performance.
• Build the OLAP cubes with Dimension and Fact Tables using SQL Server Analysis service (SSAS).
• Created MDX queries to extract data from the data mart.
• Fine-tuned SQL queries for maximum efficiency and performance.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, SSAS, Windows NT/2000/XP, Enterprise Manager, UNIX, SQL Query Analyzer, SQL Profiler, MS Access, MS Excel.