Professional Summary

• 8 years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications Database systems using MSSQL 2000/2005/2008/2012/2014for both OLTP Batch Processing, Online Processing Data warehousing SSIS, SSAS, SSRS applications.
• Experience in database programming in writing T-SQL Stored procedures, Triggers, Constraints Primary Key, Foreign Key, and Unique Indexes and Batch Scripts using various DDL and DML commands.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Experience with software development life cycle SDLC and project management methodologies.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV's, DMFs and Query Execution Plans.
• Used Erwin Data modeling tool and Microsoft Visio for designing the logical and physical data models.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, Tableau and MS Excel spreadsheets.
• Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS2000/2005/2008 across various environments.
• Expert in designing Enterprise reports using SQL Server Reporting Services SSRS 2000/2005/2008 , use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting services.
• Expert in generating drill down reports, parameterized reports, linked reports, sub reports and filters, charts in SSRS 2005/2008.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services DTS , and SSIS, Bulk Copy Program BCP and Bulk Insert.
• Experience in conversion of packages from legacy systems DTS to SSIS and migrating, deploying the packages across Dev/UAT/Prod environments.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store ODS , OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Hands on experience with Performance Point Server, ProClarity, Business Scorecard Manager BSM .
• Integration of SSRS Reports using various web parts into SharePoint and various delivery mechanisms.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS SharePoint , Business Scorecard Manager, Dashboards, Performance Point Server.
• Experience with working on Performance Point Server to identify KPI 'S, build score boards, reports and dash boards
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them using both SSRS 2005/2008
• Experience in deploying created reports in various sources like Web browser, XML and PDF.

Technical Skills

Languages:

T-SQL, PL/SQL, Dynamic SQL, MDX, C, C , C .NET , ASP .NET, VB.NET, XML, HTML, DHTML, HTTP, Shell Scripting

RDBMS:

SQL Server 2015/2014/2012/2010/2008/2005/2000, Oracle 10g/9i/8i, MS Access 2007/2003/2000/97

Database Design Tools and Data Modeling:

MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT Dimensions tables, Physical logical data modeling and De-normalization techniques

Operating Systems:

Windows Vista/XP/2003/2000, NT Windows 9x, MS-DOS and UNIX

DWH / BI Tools:

SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS , Business Intelligence Development Studio BIDS , Visual Studio, Crystal Reports, Hyperion

Packages:

MS Office, Microsoft Office Suite, Microsoft Office SharePoint Server MOSS 2007, Microsoft Performance Point Server 2007

Tools and Utilities:

SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import Export Wizard, Visual Studio .Net, Microsoft Management Console, DTS, Business Intelligence Development Studio BIDS ,Crystal Reports, Business Objects, Tableau

Version Control and Configurations:

Visual SourceSafe 6.0/2005, Visual Studio Team Foundation Server VSTS , Remedy Change Management

Professional Experience

Confidential

Database Developer

Roles and Responsibilities

• Merge Scripts for incremental Data loading
• Database Incremental Publish using Visual Studio
• Create Stored Procedure to generate Insert Scripts for the tables that had data in them
• Create SP to run all the Table SPs to load them in the order of loading
• Create SP to remove all data - Disable FKs and Enable them
• Split Function to convert Rows into Columns
• BCP - Bulk copy to load tables that were large and taking lot of time
• Insert scripts using XML data Insert 10x faster rather than basic single line inserts
• Schema Comparison using Visual Studio
• Data comparison using Visual Studio
• Generated tableau dashboards with forecast and reference lines.
• Installed SQL server 2014 services like SSRS, SSAS Multidimensional and Tabular SSIS.
• Created SSIS DB Catalog and Deployed SSIS 2014 packages to catalog using Project deployment model
• Dacpac comparison between different branches
• Creating database publish profiles in the Visual Studio
• Database execution time for each of the stored procedures to load the whole database
• Used Powershell to publish and seed data from Visual Studio
• Used RedGate SQL compare to compare Schema
• Handled Tableau admin activities like granting access, managing extracts
• CreatedSSIS packages to load data using - lookup, fuzzy lookup, merge, ForEach container, Seq Container,

Script Task

• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler.
• Created and maintained issue logs for bug tracking.
• Used fluent migrator for data and schema migrations
• Automated the RedGate SQL compare report

Environment - SQl Server 2014/2015,SSIS 2014/2015, SSRS, Visual Studio 2014, TFS 2014, Powershell, Git, ReSharper, Fluent Migrator, RedGate, Tableau

Confidential

Sr SQL BI Developer

Responsibilities:

• Involved in Logical Physical Data modeling
• Involved in writing stored procedures, Triggers, User-defined Functions, Views
• Created SSIS packages to load the Enterprise Data Warehouse
• Created 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 different kinds of transformations using SSIS/DTS packages
• Created indexes and proper re-indexing for intensive OLTP system to ensure best performance
• Worked with SQL 2005 Advanced features like CTE's, Except, Intersect, Pivot and Unpivot
• Performed ongoing monitoring and refinement of database queries and ETL programs.
• Used various Control Flow tasks such as Execute SQL Task, Script Task and Data Flow tasks such as Lookup, Derived column, Script Component etc.
• Developed packages using containers such as sequence containers, For Each Loop and For Loop containers.
• Performed Error Handling using Event Handlers and also used in built Error Description to capture redirected errors.
• Designed the packages by limiting the use of blocking transformations such as aggregate and sort which affect the package performance.
• Experienced in working with SQL 2005/2008/2012, SSIS, Reporting and Analysis Services.
• Supported the Director of Business Information in their interactions with key stakeholders to define, design and develop critical reporting needs using SQL Server Reporting Services 2005/2008/2012
• Created critical planning, forecasting, and financial reporting using Performance Point Server 2007
• Experience with Key performance Indicators KPIs , design of star schema and snowflake schema in MS Analysis Services SSAS .
• Developed Complex Packages to load data into Stage, ODS and Data Ware House systems
• Experience in Event Logging, Resource management, Log files, File and File Groups, Security, Backup and Recovery
• Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.
• Experience in development of extracting, transforming and loading ETL , maintain and support the enterprise data warehouse system and corresponding marts
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler.
• Created and maintained issue logs for bug tracking.
• Provided documentation about database/data warehouse structures and Updated functional specification and technical design documents.
• Integrated Excel Services and SSRS Reports to SharePoint for BI reporting.

Environment: MS SQL Server 2012/2008/2005, VS2012/2008/2005,SQL Server Reporting Services SSRS 2008/2005 , SQL Server Integration Services SSIS , Business Intelligence Development Studio BIDS , T-SQL, PL/SQL, Microsoft Office SharePoint Server MOSS 2010, Performance Point Server 2010, Visual Source Team Foundation Server VSTS 2012

Confidential

Reporting Analyst SQL/SSIS/SSRS

Responsibilities:

• Gathered and documented business requirements, detailed functional design specifications and system documentation
• Performed GAP analysis to derive requirements for existing systems enhancements
• Involved in Requirement Gathering including, brainstorming and meetings with stakeholders and created requirement specification
• Worked in converting Business Requirements into Functional Requirements
• Maintained and kept track of stakeholders requests for enhancements and changes
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic VB scripts.
• Responsible for the designing, development and maintenance of the tracking tools by utilizing .net, C JavaScript.
• Expertise in generating reports using linked reports, sub reports and filters in SQL server reporting services.
• Back end Experience in MS SQL Server development, writing complex queries, stored procedures, views, triggers, cursors, UDFs.
• Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
• Communicate with system end users to gather system feedback and conducted User Acceptance Testing UAT
• Used various Control Flow tasks such as Execute SQL Task, Script Task and Data Flow tasks such as Lookup, Derived column, Script Component etc.
• Developed packages using containers such as sequence containers, For Each Loop and For Loop containers.
• Provided End-User training and assisted in User Manual
• Created and maintained issue logs for bug tracking.
• Involved in the creation and maintenance of the reports on SSRS

Environment: MS SQL Server 2008/2005/2000, VS2008/2005,SQL Server Reporting Services SSRS 2008/2005 , SQL Server Integration Services SSIS , Business Intelligence Development Studio BIDS , T-SQL, PL/SQL, Microsoft Office SharePoint Server MOSS 2007, Performance Point Server 2007, Visual Source Team Foundation Server VSTS