Sudharshan Srinath

ac75jj@r.postjobfree.com

469-***-****

Sr. MSBI Developer

PROFFESIONAL SUMMARY

Over 8+ years of Experience in Data Warehousing and Business Intelligence applications design, development, and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS).

Expert in all areas of SQL Server development including tables, user defined functions, views, indexes, Stored procedures, functions, triggers, clustering, relational database models, data dictionaries, and data integrity.

Expert in using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.

Extensive experience in Database Design, Data Modeling, T-SQL Development, Developing and Implementing ETL Packages.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).

Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.

Expertise in solving Dead Locks/Long running queries using Performance Monitor and SQL Profiler.

Expert in configuring and creating SSIS solutions for high performance Data Integration, Data Migration and Business Intelligence Process that includes Merging Data from various Heterogeneous Data Stores, Populating Data Warehouses and Data Marts, Cleaning, and Standardizing Data.

Excellent experience in developing stylish Drill Down, Cascading, Drill through, Parameterized, Sub reports and Charts using Global Variables, Expressions and Functions using SSRS.

Experienced with full life Cycle phase of SDLC involving Systems Analysis, Design, Development and Implementation.

Experience in OLTP and OLAP design, development, testing, implementation and support of enterprise data warehouse.

Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.

Experience in developing custom reports and creating various types of reports like On demand, drill down, Drill-through, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Sub Reports, Ad hoc Reports, dynamic grouping, Cross-Tab, graphical, distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) and Business Intelligence Development Studio (BIDS).

Experience in report writing using SQL Server Reporting Services (SSRS) and Created analytical reports and visualizations with Microsoft Excel 2013 Power BI tools (Power View, Power pivot and Mapping) for exploratory analysis by data analysts.

Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports, scheduling snapshots and managing snapshot history in SSRS.

Developed many cubes, used various MDX queries for measures and developed schemas.

Experience in Troubleshooting Report Processing, Subscription, Delivery, and Configuration Problems.

Expertise in creating Dashboard Reports to support end users using SSAS

Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication, Log shipping, clustering(Active/Passive) and Database Mirroring.

Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.

Developed ETL process using SSIS with various Control flow, Data flow tasks and Stored Procedures for the work order validation process.

Expert in calculating measures and dimension members using the Multidimensional Expression (MDX), mathematical formulas, and user-defined.

Familiar with work environment Agile methodology and Scrum meeting.

Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, and Snow-Flake Modeling

Experience in report writing using SQL Server Reporting Services (SSRS) and creating several types of reports like Dynamic, Linked, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Document Map and Sub-Reports.

Experience in building, deploying and managing applications on Microsoft Azure Cloud computing platform.

Very Good Communication skills, Good interpersonal skills & desire to excel, fast learner, efficient in handling multiple projects, hardworking and a versatile team player.

Technical Skills:

Languages

SQL, T- SQL, HTML, Oracle 9i/10g/11g, MySql, data warehouse, XML, PL/SQL, DB2

Databases

SQL Server 2014/2012/2008/2005/2000/7.0, MS Access

Analysis/Reporting Tools

SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS)

ETL Tools

SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Import Export Data

Web technologies

.Net, ASP.Net, Ado.Net, JavaScript

Data Modeling Tools

Erwin, Visio

Testing

Unit Testing, Performance Testing, Integration Testing, Stress Testing

Other Software

MS Office- 2013/2010/2007/2003

Operating Systems

Windows 2003/XP/Vista/8.0/8.1/10

Database Tools

SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server Query Editor, Solution Explorer, Analysis Manager, Reporting Server

Work Experience:

Triwest Health Care, Phoenix, AZ Apr 2018- Present

SQL/SSIS/SSRS Developer

Responsibilities:

Responsible for gathering and defining user report requirements and developing appropriate Interfaces for the Reporting Infrastructure Environment to meet customer business needs, based on business processes and data entities between various systems.

Supported front-end team in Designing and Developing custom web and console applications as per client requirements and specifications.

Developing complex SSIS packages using different data transformations like Aggregate Conditional Splits, Lookup, Sort, Merge Join, Data Conversions, Derived Columns, Multicasting, Slowly Changing Dimensions, Scripting, OLEDB Command with SQL etc.

Actively involved in writing SQL Stored Procedures, functions, and triggers for updating customer usage information in the database

Developing SSIS packages that upload multiple flat files using For each Loop Container and uses other control flow tasks like File System task, FTP task, Send Mail Task, Script Task etc.

Improving the database performance by creating and using both Clustered and non-Clustered Indexes and by optimizing T-SQL statements. Using Azure portal to audit and analyze the events during a particular time horizon and stored in the script.

Created ETL process using SSIS to transfer data from heterogeneous data sources by extensively using PIVOT to normalize the data also combining data from different sources using UNION ALL.

Worked with Marketing department to improve the external and internal website and posting latest updates.

Mapped millions of record over Bing maps from Excel data model and discovered actionable insights for strategic planning utilizing Power BI (Power Map).

Create and manage Reports subscriptions and schedules SSRS reports.

Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2/2012/2014/2016.

Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.

Developing and maintaining/modifying complex T-SQL queries, stored procedures and SSIS packages to load the data into warehouse.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities

Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

Designed and built up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Responsible for debug, performance checks and performed index tuning and query optimization.

Developed impactful reports using SSRS, MS Excel, Pivot tables and Tableau to solve the business requirements.

Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.

Environment: MS SQL Server 2016/2012/2008R2, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), DAX, Agile, C#.NET, T SQL, SQL Profiler, XML, Team Foundation Server (TFS), MS Excel, Excess, Windows 8.

Capco Financials, Chicago IL Jan 2017-Mar 2018

MS SQL/MSBI Developer (SSIS, SSRS)

Key Responsibilities:

Understanding the business requirement and functional specification of the client module also supporting Front-End team to improving the Application.

Developed DTS packages from SQL Legendary tasks on SQL Server Management Studio to load the data from flat files and Source tables into SQL databases.

Created and managed Schema objects such as Tables, Views, Indexes, Procedures, and Triggers in the database.

Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to the staging area and finally transfer into data marts and performed an action in XML.

Extensively worked on three stages of enterprise reporting like Authoring, management, and delivery using SSRS.

Developed a methodology for the ongoing assessment of database performance and the identification of problem areas.

Responsible to tune ETL procedures and schemas to optimize load and Query Performance.

Worked on Agile Methodology throughout the project, performed a decisive role in developing and planning as well as coordinating with assigned sprints.

Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts

Used Tableau to develop dashboards for more intuitiveness as per the user requirements also created the documentation for the team on project technical details.

Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.

Raising the change management request and following up with the customer approval, for making any changes in the production server

Involved in 24X7 On-call production support and fixing production issues. Experience working with live site production issues.

Environment: MS SQL Server 2014/2016,.Net 3.0, SQL BI Suite (SSIS), XML, MS Excel, MS Access 2014& Windows Server 2010, SQL Profiler, DTS, Data Analyzer, SQL Server Data Tools/BI (SSDT), Red Gate SQL Source Control, TFS, Remote Desktop Connection (RDC), Windows Server 2010 R2, SharePoint and Windows 10,Tableau., SQL Profiler.

Homesite Insurance, Boston, MA Feb 2015 – Dec 2016

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

Requirement gathering and analyzing data sources. Assisted in design and implementation of Database.

Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert.

Scheduling Daily, Weekly, and Monthly SSIS package execution process using SQL Server Agent jobs

Working closely with the Actuarial department on loading and analysis of Claims data on daily basis.

Automated Stored Procedures to load data into staging and production environments in a timely manner using SQL Server Agent.

Worked on Control Flow tasks like for each loop, execute process tasks, execute package tasks, script tasks, and Data Flow tasks.

Deployed SSIS packages for after working on complex enhancements.

Automated Stored Procedures to load data into staging and production environments in a timely manner using SQL Server Agent.

Involved in cube partitioning and developed various calculations using SSAS.

Designing claims reconciliation, validation and analysis reports for accounting and actuarial departments.

Taking Database Full Backup, Transaction log backup & differential backup in daily routine.

Traced long running queries and deadlocks using SQL Profiler.

Proficient in MS SQL Server suite of products like TSQL, SSRS, and SSIS of MS SQL Server.

Proficient in creating SQL Server reports, handling sub-reports and defining a query for generating drill down reports using SSRS.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Taking Database Full Backup, Transaction log backup &differential backup in daily routine.

Traced long running queries and deadlocks using SQL Profiler.

Scheduled the reports to run on daily, weekly basis in the report manager.

Developed complex calculated members, Named Sets using MDX expressions for OLAP reporting requirements.

Environment: SQL Server2014, Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, SSIS, SSRS, SSAS, Visual Studio 2013/2015,Crystal Reports 8.0, Data Analyzer, XML, ASP.Net, MS Word, Excel, SQL Profiler, Azure, Business Intelligence Development Tools, MS Visio

Hartford Life insurance, Woodbury, MN Sep 2013-Jan 2015

SQL Server SSIS/SSRS Developer

Responsibilities:

Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers

Involved in creating multiple parameterized stored procedures which were used by the reports to get the data

Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server

Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful clustered index and non-clustered indexes and Views.

Managed upgradation of DTS packages to SSIS packages and filling Dimension and Fact tables into Data Warehouse and Data Marts.

Designed and created Report templates, bar graphs, pie charts based on the financial data.

Created report models for ad-hoc reports using SSRS 2012.

Used SSRS for creating, editing and scheduling various complex reports and sub reports in various formats like MS Excel, PDF, HTML, and XML etc.

Created many Complex Queries using MDX Expressions.

Generated periodic reports based on the statistical analysis of the data using SSRS 2012.

Involved in creating user Variables, Script tasks and involved in creating dynamic SSIS packages.

Analyzed existing SSIS packages to improve performance.

Improved SSRS reports performance by creating summary reports, reducing not useful columns, caching, snapshot and schedule subscriptions.

Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Provided 24x7 on call support for various projects and ensure that all critical database problems are resolved in timely manner.

Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general troubleshooting

Environment: SQL Server 2012, XML, SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS), SQL Profiler, Visual Studio 2010, .Net Frame Work 4.0, Index Tuning Wizard, Performance Monitor, SharePoint 2010, Windows 7, Microsoft office 2010

TargetX, Conshohocken, PA Jan 2012–Aug 2013

SQL BI Developer

Responsibilities:

Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.

Analysis, Design and data modeling of Logical and Physical database using E-R diagrams.

Document internal and external data sources and data integrations and provide operating support or data integration solutions.

Created ETL packages with different Heterogeneous data sources (SQL Server, Flat Files, CSV, Excel source files, and XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.

Validated change requests and made appropriate recommendations. Standardized the implementation of data.

Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.

Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.

Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL.

Performed job scheduling in the SQL Server Environment.

Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.

Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.

Managed user access. Created and managed new security accounts.

Backup and restore databases.

Developed and implemented database and coding standards, involved in improving performance and maintainability of corporate databases.

Environment: SQL Server 2000/2005/2008, T-SQL, DTS Designer, MS-Office, Ms-Excel, VSS

Axis Bank, India Sep 2010-Dec 2011

SQL Server Developer

Responsibilities:

Worked as a developer on databases like MS SQL Server 2005, MS Access.

Installed and maintained MS SQL Server 2005.

Created Database Objects – Tables, Indexes, Views, User-defined functions, Cursors, Triggers, Stored Procedure, Constraints, and Roles.

Analyzed and prepared Statement of Work and Requirement Definition Document.

Extensively developed SQL Procedures, Functions, Triggers and Packages.

Tuned and Optimized SQL Queries using Execution Plan and SQL Profiler.

Troubleshooting performance issues and fine-tuning queries and stored procedures.

Develop SQL Server Agent jobs and packages to populate data.

The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.

Involved in performing database Backup and Recovery.

Created and manipulated many small and Complex packages to perform ETL operations.

Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

Environment: SQL Server 2008/2008R2, T-SQL, DTS, MS-Excel, Windows 2000/2003, Visual Studio 2008/2010, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Profiler, MS Visio, Data Analyzer, MS Excel, Word

Education: Bachelor’s in Computer science PES Institute of Technology, Bangalore, India - 2010

Contact this candidate