SUMMARY

• Over 7 years of IT experience as a MS SQL Server Developer 2008/2012/2014/2017 in various Industry verticals like Finance, Insurance and Retail.
• Experienced with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Experienced in Database Modelling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs.
• Experience in MS SQL Server 2008/2012/2014/2017 , Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS).
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase and MS Access.
• Expertise in designing complex reports using Cascading parameters, Drill - Through Reports, Parameterized Reports, Sub reports and AdHoc reports using SQL Server Reporting Services (SSRS).
• Manually converted Crystal reports to SSRS. By rewriting the stored procedures, enhanced some of the T-SQL statements to retrieve the data very quickly from the storage engine.
• Good at Data source setup on the development server machine to make all sources available for the reporting purpose.
• Creating custom Power BI reports for end users which are retrieved from Microsoft Azure SQL Datawarehouse.
• Expert in Creating and Deploying SSRS Reports and report models on the report manager for user accessibility.
• Experienced in writing Parameterized Queries for generating reports, Formatting report layout, reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2013/2015.
• Used Report Manager to assign roles, permission, created report schedules and subscriptions.
• Build data visualizations and reports from Data Warehouse and OLAP cubes using Microsoft Power BI and SSRS.
• Experience using Tibco Automation Services in conjunction with Spotfire for automation of analyses generation and deployment
• Created role based KPIs, scorecards, dashboards available in Web and mobile applications.
• Build data visualizations and reports from DW and OLAP cubes using Power BI, SSRS, and possibly Tableau.
• Experience in writing complex DAX functions in Power BI and Power Pivot.
• Imported data from SQL Server DB, Azure SQL DB to Microsoft Power BI to generate reports.
• Experienced in designing and developing large amounts of enterprise reports (SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Data Cleansing, Relational Database models and Data integrity, and Joins.
• Used calculated columns, Custom expressions, Action controls, Property controls in the Spotfire Reporting to provide the best solution to the business.
• Experienced in using tools like MS SQL Profiler, Query execution plan, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Created Stored Procedures, triggers, views, temporary tables using T-SQL for data manipulation & reporting.
• Gathered and documented requirements and translate them into technical specifications for Data Modelling for ETL (Extraction, Transformation, and loading)
• Designed the data models in SSMS, Constructed the design models in Object Oriented Design using UML Diagrams.
• Involved in SSRS migration from 2008R2 to 2014.

TECHNICAL SKILLS

BI Tools: Microsoft Azure SQL Data warehouse, MS SQL Server 2008/2012/2014/2017 , Azure 2016, Microsoft Access 2016, Microsoft Power BI, Power BI Report Builder, SQL Server Management Studio (SSMS), MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server, MS SQL Profiler, Database Engine Tuning Advisor, Performance Monitor, SQL Query Analyzer, SQL Server Agent, T-SQL, Visual Studio (VS) 2010/2012/2014/2016/2017 .

Web Technologies: CSS, C# .NET Framework, HTML 5, ASP.NET, VB.NET, JavaScript, IIS.

Programming Languages: T-SQL, C#.Net, Java Script, VB Script, XML, HTML

Operating Systems: Windows 10/ 8/7/Vista/XP, Windows Server 2012.

PROFESSIONAL EXPERIENCE

Confidential

MS SQL BI Developer / Power BI Developer

Responsibilities:

• Communicating with users to guarantee BI expectations are giving Business Esteem.
• Work with End Users, IT, Information Management, Information Management teams to determine operational issues & relieve chances.
• Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting Spotfire and Business Objects.
• Work with venture groups to archive business prerequisites definitions, including business opportunity, vision of arrangement and expected advantages.
• Help End clients use the suitable BI systems & Tools.
• Build associations with business ranges, comprehend their responsibilities, set up confide in exchange on the most proficient method to help those duties.
• Composing SQL scripts and creating custom Reports for End clients according to their requirements.
• Design and develop reports using SQL Server Reporting Services (SSRS).
• Must have built out complex business logic, worked in an environment with disparate data sources and implemented the convergence of various data sources for use in Spotfire
• Implemented SSRS reports like Invoice, Forms, and Custom Letters for both Internal & External clients.
• Create various types of SSRS reports like Table, Matrix, Drill Down, Drill Through and Cascaded reports.
• Designed and developed Custom reports and different types of Chat Reports, Tabular Reports, Matrix Reports and distributed reports in multiple formats using SQL Server 2012/2014.
• Used Dynamic SQL for internal reporting.
• Creating custom Power BI reports for end users which are retrieved from Microsoft Azure SQL Data warehouse.
• Imported data from SQL Server DB, Azure SQL DB to Microsoft Power BI to generate reports.
• Created role based KPIs, scorecards, dashboards available in Web and mobile applications.
• Build data visualizations and reports from DW and OLAP cubes using Power BI, SSRS, and possibly Tableau.
• Experience in writing complex DAX functions in Power BI and Power Pivot.
• Explore data in a Variety of ways and across multiple visualizations using Microsoft Power BI.
• Build data visualizations and reports from Data Warehouse and OLAP cubes using Microsoft Power BI and SSRS.
• Published reports and dashboards using Power BI.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Manually converted Crystal reports to SSRS.
• Developed SSIS packages with Custom error handling, Logging using event handlers, Send Email Task and Used Checkpoints to rerun Packages from Point of Failure.
• Designed SSIS packages with Dynamic tasks, Connections using variables, expressions, Package configurations and followed best practises to maintain optimized performance.
• Experienced in working with different data sources like OLE-DB, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
• By rewriting the stored procedures, enhanced some of the T-SQL statements to retrieve the data very quickly from the storage engine.
• Imported Data using T-SQL commands like Open Query & Linked servers.
• Tuning T-SQL Queries and improving query performance.
• Creating Jobs, Alerts and scheduled SSIS Packages.
• Created SSIS package in which records were loaded daily, also from other data resources such as Excel, Access, flat file and XML.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Optimized long running Stored Procedures and SQL queries and reducing the downtime for effective data retrieval.
• Composing Stored procedures, functions and triggers in Microsoft Azure SQL Database.
• Migrated SSRS reports from 2008 to 2014.
• Involved in production support for internal ETL applications.
• Engaged with dialogs with Business Analysts to identify business necessities and worked closely with system analysts to recognize the technical requirements.
• Investigating the issues for missing information independent of technologies.
• Automation of Custom reports running them on every day, week by week, month to month, year premise in view of the client's necessity.
• Review task achievement criteria guaranteeing deliverable and partner arrangement.

Environment: MS SQL Server 2017/2014/2012 , SQL Server Management Studio (SSMS), Azure 2016, Microsoft Access 2016, Microsoft Power BI, Power BI Report Builder, Visual Studio (VS) 2010/2012/2014/2016/2017 , MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), T-SQL, ETL applications, MS SQL Profiler, Database Engine Tuning Advisor, Performance Monitor.

Confidential, ST. Louis, MO

SSIS/SSRS Developer

Responsibilities:

• Created SSIS packages records were imported from other data resources such as Excel, flat file, EssBase, ODS, JDE in order to create and maintain a centralized data warehouse
• Retrieved and migrated the data from EssBase to SQL Server 2014 using SSIS Packages.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Generated Summary Reports using T-SQL from scratch.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Hands-on development using Tibco Spotfire to create dashboards & reports and use as standard templates
• Migrated the data from EssBase to SQL Server, retrieved the Records from EssBase and generated summary reports.
• Scheduled these packages automatically by using SQL server agent on a Daily /Weekly /Monthly basis.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2013.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using T-SQL statements in Visual studio 2013.
• Created the Management Report template outlook and worked on the changes as per the business requirements.
• Developed Test Plan, Test Cases, Test Data & Test Summary reports using T-SQL.
• Exported the summary reports to FTP and SFTP.
• Worked on tools like MS SQL Profiler, Query execution plan, Index Tuning Wizard, Windows performance for monitoring and SQL Server performance tuning.
• Participated in Daily meetings with the User and generated the Reports accordingly

Environment: Visual Studio 2013, MS SQL Server 2012/2014, T-SQL, SSIS, SSRS, Essbase, MS Excel, MS Access.

Confidential, Providence, RI

MS SQL Developer

Responsibilities:

• Upgraded database from SQL Server 2005 to SQL Server 2008 using In-Place and Side-by-Side strategies.
• Generated different reports using VB scripts.
• Design database models and ER diagrams integrating existing and new tables, based on business requirements and corporate database development standards. Create data mapping of the new fields to existing or new data sources using SQL Server Analysis Services (SSAS).
• Created, deployed, and scheduled SSIS packages to run SQL tasks and enable data transfer from several sources including Oracle, Excel, Access and flat files.
• Participated in many internal and client-engaged discussions about best-practices concerning SQL Server especially relating to High Availability and shared storage optimization.
• Experience with TIBCO Spotfire or other reporting systems a plus
• Designed and developed dynamic SSIS packages to process dynamic queries and dynamically produce flat files at runtime.
• Migrated data to transfer database objects among servers using different SSIS packages in Business Intelligence Development Studio (BIDS).
• Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports.
• Generated different reports such as parameterized reports, drill through reports, matrix reports, linked reports using T-SQL.
• Deployed reports on Microsoft reporting and created different report models for the users to generate and customize ad-hoc reports.
• Defined granularity within a measure group and drill through actions using SSRS 2015 professional.
• Used of T-SQL for developing complex Stored Procedures to retrieve clean data according to client requirements. Created triggers for the updating of required fields accordingly.
• Developed complex User defined functions (UDF), Cursors, Tables, Views, Indexes and other T-SQL joins and statements for applications.
• Monitored locking issues and high availability issues.
• Monitored user queries and stored procedures by database tracing using SQL Server profiler.

Environment: SQL Server 2008R2/ 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL, MS Excel, Excel VBA.

Confidential

MS SQL BI Developer

Responsibilities:

• Identified data source and define data source Views.
• Design ETL packages from different sources and load data to the target destination by performing transformation using SSIS.
• Developed store procedures to transform data from data warehouse to SQL and load data to fact table.
• Created Logical and physical design of data for projects on basis of user requirement.
• Implemented and maintained database performance and tuning.
• Involved in Migration of SQL 2008r2 to 2012.
• Wrote triggers and stored procedures to capture the updated and deleted data from OLAP systems.
• Create the correct reports in Spotfire, using the Advanced Data Services tool
• Created Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports in SSRS using T-SQL.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
• Using T-SQL, developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Created SSIS package in which records were loaded daily, also from other data resources such as Excel, Access, flat file and XML in order to create and maintain a centralized data warehouse.
• Created cube structure for the analysis of business conditions and for creation of reports using SSAS.
• Created drill down and sub reports from SSAS cubes that can be browsed on the web.
• Worked on with Report Manager, Report Builder, and Reporting Security and Reporting Services Configuration manager.

Environment: MS SQL Server 2008R2, SSRS, SSIS ETL applications, T-SQL, MS-Excel, XML, SharePoint Server 2010.