PROFESSIONAL SUMMARY:

• Over 8 years of IT experience as a MS SQL Server Developer in various Industry verticals like Finance, Banking and Health Care.
• Extensive experience in MS SQL Server 2018/2016/2014/2012/2008/2005 , Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Reporting tool tableau and JIRA, Service now ticketing system.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Proficient in all areas of SQL Server development including tables, views, indexes, Stored procedures, functions, triggers, clustering, T - SQL, relational database models, data dictionaries, and data integrity.
• Worked on Oracle database to design Database schema, created Database structure, Tables and Relationship diagrams. Experienced in working with Project tracking tool JIRA.
• Experienced in migrating Data from Excel, Flat file, Oracle, Sybase, DB2, MS access to MS SQL Server using SQL Server Integration Services (SSIS), BCP and DTS utility.
• Expert in Creating, Configuring and Fine-tuning MS SQL Server Integration Services (SSIS).
• Highly experienced in using SSIS Import / Export Wizard, SSIS designer and other package execution utilities for performing the ETL operations.
• Extensively worked in Migration for MS SQL and MS SQL 2000 to MS SQL 2008.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Expert writing SSIS Configuration, Logging, Procedural Error Handling and Data Error Handling, Master Child Load methods using Control tables.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Derived Column.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance, SQL Server Agent for monitoring and tuning SQL Server performance.
• Participated in creating Star Schema, Snow Flake Schema using the concept of data modeling with Team.
• Proficient in Dimensional Data Modeling, building Cubes, defining Referenced Relationships and creating Hierarchies, KPIs, Perspectives, Partitions, calculated members and Designed Aggregations in cubes using SSAS.
• Good knowledge in optimizing queries using MDX and implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.
• Generated ad-hoc reports using MS Reporting services, Report Builder and Crystal reports.
• Implemented Report server configuration, Deployed reports, created data driven subscriptions in Development, Test and production environments.
• Experience in customizing the BI components using ASP.NET, C#.
• Worked on Power BI and created reports and dashboards and published them on service.
• Experienced in migrating data from on-premises data servers onto Microsoft Azure cloud platform utilizing Azure data factory.
• Worked with SCRUM agile methodologies, test driven development, automated & slip-stream builds.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Extensive experience in writing Packages, Stored Procedures, Functions and Database Triggers using PL/SQL and UNIX Shell scripts. Also, handled Oracle utilities like SQL Loader, import etc.

TECHNICAL SKILLS:

Databases: SQL Server 2000/2005/2008 R2/2012/2014,2016,2018 Oracle 9i/10g,11g, MS Access, MySQL TSQL, PL/SQL, MDX, C, C++, C#, ASP.NET, XML, CSS, HTML, Java Script

Tools: Utilities: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SSIS, SSRS, SSAS, SSDT, SQL Server Profiler, SQL Query Analyzer, SQL Server Enterprise Manager, SQL Query Visual Source Safe 6.0, Data modeling, Import & Export Wizard, SQL Server Agent, MicroStrategy, SharePoint, MS PowerPoint, MS Word, Microsoft visual Studio 20052008/2010 , JIRA

Data Modelling Tools: MS Visio, Erwin 4.0, Star Schema/Snowflake Schema modelling, FACT& Dimensions tables, Physical & logical data modelling and De-normalization techniques, Kimball & Inmon Methodoligies

Reporting Services: Excel, SQL Server Reporting Services, Crystal Reports, Business Objects, Power BI, Tableau

ETL: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), T-SQL Stored Procedures, Informatica

Operating Systems: Windows 10/8/7/Vista/XP/2003, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Sr. Software Developer

Responsibilities:

• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Reporting,Testing and Implementation of BI Analytics needs.
• As a scrum master, responsible for conducting daily scrums and followed agile Processes of sprint planning and backlog grooming.
• Developed work plans and carry out complex technical duties associated with database updates ranging from upgrades between major versions, routine software updates and security updates.
• Translated business process requirements into efficient database designs and processes.
• Participated in the design, development and implementation of database structures to support new applications and system development.Performed scripting and scheduling on servers, as necessary.
• Designed, developed, and modified sql views and stored procedures in support of system and business requirements, using Microsoft SQL Server Management Studio. Prepared written documentation.
• Worked with the Database Administrator to create and execute DDL scripts.Tested all changes in multiple applications to ensure functionality.
• Involved in creating the database objects like tables, views, stored procedures, functions using MS SQL server. Designed required SQL statements and queries to access data.
• Optimized queries and conducted performance tuning of T- SQL queries and stored procedures using SQL profiler and database tuning advisor.
• Performed daily tasks including backup and restore by using SQL Server tools like SQL server Management Studio, SQL Server Profiler, SQL Server Agent.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored them in the script. Created traces using SQL Server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Developed technical specifications and participated in module design and implementation plans; writing modules for database connectivity.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually.
• Designed Dashboards with all kinds of charts (Gauges, Bar/Line charts, Maps, heat maps, Area charts). Designed ad-hoc reports, grouping and sorting using SSRS.
• Delivered dashboards and reporting solution using Tableau for DCS management.
• Tested the reports for formatting and data correctness and publishing the workbooks on the Tableau server for scheduled refreshes.
• Defer access control levels for different types of users and communicating the requirements to the Tableau Server team to apply the same to the workbooks.
• Experienced working with Tableau server as admin and maintained jobs in the server.
• Conducted peer code review and participated in research and root-cause analysis of issued reported by the testing team. Logged Application issues in project tracking tool JIRA.
• Experiend with service now ticketing system.Maintained Project sharepoint site.
• Experienced in creating diagrams using Visio.

ENVIRONMENT: MS SQL Server 2005/2008 R 2/2012/2016/2018 , T-SQL, MS SQL Integration Services 2008 R2/2012, MS Access, MS SQL Reporting Services 2008 R2/2012, Tableau, MicroStrategy, MS Excel Power Bi, IBM DB2, SQL Server Agent, SharePoint 2007/2010, Visual Studio, MS Visio, TFS

Confidential, Rochester, MN

Sr. MS SQL Server/BI Developer

Responsibilities:

• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Extensive understanding of managing and automating Control flow, Data flow, Events and Logging for SSIS packages using Microsoft .NET framework.
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2, Teradata) and SQL Server as a part of Data Migration, Data Maintenance.
• Performed tuning of SQL queries and rewriting queries to improve the performance of database.
• Have migrated data from complex databases into power pivot add on in Microsoft excel and generated reports from them and Defined best practices for Tableau report development.
• Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• 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.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually.
• Configured package logging,error logging,event handling to redirect error rows and fix the errors in SSIS
• Experience in writing Parameterized Queries for generating stylish Tabular reports, Drill down, Drill through, Cascading, Parameterized, click through, Matrix, Chart, Snap shot reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
• Generated reports using SSRS, Power Pivot, and Power BI that could be used to send information to diverse group of users, clients, and managers.
• Developed several detail summary reports including line and pie charts, trend analysis reports and pivot tables according to business requirements using Power BI, Excel and SQL Server 2014.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports and Experienced in creating and maintaining SSAS databases in both Multidimensional model and Tabular models in SSAS.
• Used third party tools like Pyramid to create Dashboards and ad hoc reports built on data from Cubes
• Designed OLAP model based on Dimension and Fact tables for efficient loads of data which were based on Star Schema structure in SSAS.
• Accomplished System Optimization, Performance Monitoring and Tuning in MicroStrategy Business Intelligence environment.
• Created statistical charts using Qlikview business intelligence software.
• Created Package Configurations to deploy the packages through DEV, TEST and PROD Environments.
• Creation of Excel/VBA tools for user input of data into Oracle tables.
• Developed the dashboards with different charts and view objects using Power View.
• Published the Reports in the Power BI.

ENVIRONMENT: MS SQL Server 2005/2008 R2/2012/2016, T-SQL, MS SQL Integration Services 2008 R2/2012, MS Access, MS SQL Reporting Services 2008 R2/2012, Tableau, MicroStrategy, SSAS Cubes, MS Excel Power Bi, IBM DB2, SQL Server Agent, SharePoint 2007/2010, Visual Studio, TFS

Confidential, Mount Laurel, NJ

Sr. SQL/ETL Developer

Responsibilities:

• Involved in all phases of System Development Life Cycle (SDLC).
• Scheduled the jobs to streamline and automate cumbersome repeated tasks using SSIS.
• Extensively wrote and edited existing Stored Procedures, metadata, entity-relationship diagrams, User Defined Functions, database schema and Triggers using T-SQL.
• Created the Best Coding Practices Document for stored procedures & functions for the Developers.
• Created new database files and database file groups in SQL Server 2005 using SSMS and T-SQL.
• Good working experience in Visual Studio.Net 2005, ASP and SQL Server 2005. Developed reports using Crystal Reports and MS SQL reporting.
• VB.Net and C# used for scripting in Script Tasking in SSIS to control the flow of SSIS package.
• Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions using SSRS.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Log Shipping with Transactional Replication Database Mirroring, Database Replication.
• Responsible for deploying reports to Report Manager Cognos Analysis and Report extract and transfer, Troubleshooting for any error occurs in execution.
• Implemented, designed, and deployed a data mart for analysis (Kimball methodology), to support managerial decisions.
• Experience in creating different visualizations and reports using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets and Highlight tables in Tableau, SSRS, Power BI.
• Developed complex custom SQL scripts to be used as Tableau data sources.
• Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing the reports.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Proficient in writing macros to create SAS data sets, tables, report and graphs from Procedure Output and automatically send to various destinations by using SAS ODS statement, as well as convert various file types to SAS Datasets.
• Designed and developed SSIS packages, MDX Scripting stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS).
• Experience in Performance Tuning of MicroStrategy Reports.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, sequence Container and conditional split, data conversion, derived column and multi casting.
• Created and rebuilt multi-dimensional cubes using SSAS to support business reporting and forecasting process, Optimized queries by getting insight from Execution Plan for better performance of the DB.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: Windows, MS SQL Server 2012, T-SQL, MicroStrategy, MS SQL Server Reporting Services, Informatica, MS SQL Server Integration Services, Tableau, Server Analysis Services, Power BI, Visual Studio 2010, MDX, .Net, Excel, Acrobat Reader

Confidential, Chicago, IL

SQL BI Developer

Responsibilities:

• ETL packages with different data sources SQL Server, Flat Files, Excel source files, XML files etc and then loaded the data into destination tables by performing various kinds of transformations using SSIS/DTS packages.
• Created data loads and Upgrade scripts for data migrations and validations.
• Worked with different methods of logging in SSIS, used error handling using TRY and CATCH blocks and performance tuning using counters in SSIS.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Worked on SSRS Created in creating complex SSIS packages using control and data flow elements.
• Analyzed massive data sets, performing ad-hoc analysis and data manipulation.
• Created Tabular reports, Matrix reports, List Chart reports, Parameterized reports, Sub reports, cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Created custom C# scripts to loop through set of files and extract the data based on the column information.
• Built enterprise wide ETL solution using Informatica.
• Designed and implemented a Kimball method data warehouse for project management and corporate financial reporting and dashboarding. Created Multi-Dimensional Cubes using SSAS for the Data Warehouse.
• Extensively involved in the SSAS storage and partitions, Aggregations, Calculation of queries with MDX, Data mining models, developed reports using MDX and SQL.
• Created Multi-Dimensional Cubes using SSAS for the Data Warehouse.
• Worked on Configuration and Deployment of all the Reports (RDL) across various SDLC environments.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Responsible to create dimensions with the cube wizard, refreshing cube to get the latest date updates, deployment of cubes to the production server.
• Used VISIO for database modeling.
• Prepared documentation related to database design, objects security and rules.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Worked on T-SQL programming such as, stored procedures, user-defined functions, cursors, views and management of linked servers to Non-SQL-Server databases.

Environment: SQL Server 2012, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows 2000/XP, SQL, Informatica, Tableau, MS Visio 2007, SSAS, XP professional

Confidential, Houston, TX

SQL BI Developer

Responsibilities:

• Worked on mission-critical parts including ETL process using SQL Server Integration Services SSIS.
• Developed the SQL Server Integration Services SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Scheduled the DTS package for migration data from old system to MS SQL 2008. Reconciled data for transformation from SQL 2005 to SQL 2008 using SSIS.
• Extracting the data from the various sources CSV files, oracle, and MS SQL 2000 and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Worked in migrating code from VSS to TFS.
• Extensively worked with Policy-Based Management i.e. Target, Facet, Condition and Policy.
• Extensive experience working with Transactional and snapshot replications.
• Involved in SSAS Cubes design by creating measure groups, dimensions, aggregations, Actions, Partitions and Perspective from huge dataset using SQL Server 2008 Analysis Services SSAS.
• Created Dimensions with the cube wizard and individually.
• Refreshing the cube to get the latest information updated.
• Deployment of Cubes to the production server.
• Designed Star schema identification of facts, measures and dimensions and Snowflake schema.
• Created partition function, schema and file groups for fact tables.
• Involved in Normalization to 3F for OLTP system and some De Normalization for OLAP system.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Up gradations of SQL server versions and applying patches and hot fixes.
• Build database queries and test cases for the testing team to test the reports.
• Deployment of databases, jobs, cubes from pre-production to production.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: MS SQL Server 2008R2, Windows Server 2008, DTS, T-SQL, SSIS, SSRS, SSAS, PPS, Erwin 4.0, ETL, Erwin, XML, Excel, Visual Studio 2010

Confidential

SQL Server Developer

Responsibilities:

• Designed Dashboards with all kinds of charts (Gauges, Bar/Line charts, Maps, heat maps, Area charts). Designed ad-hoc reports, grouping and sorting using SSRS.
• Involved in designing sub reports and linked reports depending on the user requirement and to limit the number of Data Sources.
• SSRS reports to SharePoint Server for the end users to look at them.
• Created SSIS packages to transfer data from various sources like Oracle 10g, Excel, flat files into SQL server using different SSIS components and used dynamic configuration files and variables for production deployment.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Worked on creating calculated measures that fits business logic, using MDX queries.
• Handling Initial and Delta loads and processing Cubes (Star Schema) across all environments.
• Worked on Key Performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS). Involved in designing Data Marts.
• Created and modified database objects like Table, Views, Store Procedure, Triggers and Functions using T-SQL.
• Developed Windows User Controls using Win forms controls and custom controls using c#.
• Configured application settings using the Configuration files.
• Consumed and created XML Web Services.

Environment: SQL Server 2000/2005/2008 /, SSRS 2008/, SSIS/DTS, SSAS, Visual SourceSafe, Enterprise Manager, Query Analyzer, SQL Profiler, Active Directory and Windows XP platform, Web services, Visual Studios 2005