SUMMARY

• Around 7 years of experience in Database Designing, Data modeling, Developing, Implementing, configuring, managing and troubleshooting of MS SQL Server 2000/2005/2008 R2/2012/2014 and Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services.
• Hands on experience in all phases of Software Development Life Cycle (SDLC) which includes gathering requirements, analysis, design, development and testing.
• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T - SQL, relational database models, data dictionaries, and data integrity.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• 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.
• Experience in providing Logging, Debugging and Error handling by using Event Handlers, and Custom Logging, break point, data viewers, check points for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block & Unblock Transformations.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column and developed packages in SSIS with error handling.
• Created Package Configurations to deploy packages from development to production server.
• Experienced in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Participating to create 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 DMX.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Experienced in writing expressions and fine tuning reports and created much Drill through, Sub, Parameterized and Drill Down reports using SSRS.
• Proficiency in creating different types of reports such as Table Reports, Cross-Tab, List Reports, Conditional, Pie Chart Reports, Drill-down, Drill through reports, Group reports, sub-group reports, Adjacent group reports, Total Reports, Sub-total Reports, Grand Total Reports
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Experience in developing ad-hoc reports using Report Builder.
• Implemented Report server configuration, Deployed reports, created data driven subscriptions in Development, Test and production environments.
• Experience with .NET framework using ASP.NET, C#.
• Experienced in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling SQL Server Agent Jobs.
• Expertise in Debugging, Optimizing and Performance Tuning of MS SQL SERVER 2005/2008/2012 Dashboards / Reports.
• Used SCRUM agile methodologies, test driven development and automated & slip-stream builds.

TECHNICAL SKILLS

Operating Systems: Windows 10/8/7/Vista/XP/2003/2000,UNIX and Linux.

Languages: T-SQL, PL/SQL, MDX, C, C++, C#, ASP.Net, XML, HTML, Java Script

Tools: /Utilities: Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, BI Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio, Power pivot, Import & Export Wizard.

Databases: MS SQL Server 2000/2005/2008 /2008R2/2012, Oracle 11g/10g/9i, MS Access.

Data Modeling Tools: Microsoft Visio, UML, Erwin4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies

Software: MS Office, Adobe Dreamweaver, Adobe Photoshop, Ms Excel, MS-Project 2000

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

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

PROFESSIONAL EXPERIENCE

Senior SQL Server Business Intelligence (BI) Developer

Confidential, Minneapolis, MN

Responsibilities:

• Involved in requirements gathering, analysis, design, development and implementation of various applications on MS SQL Server.
• Designed Facts and Dimensions that supports the business requirements and reporting needs.
• Involved in designing, developing and testing of the ETL strategy to populate the data from various source systems using SSIS
• Designed SSIS packages to load the medical information of the patients enrolled in the program.
• Implemented Master/Child Packages, so only the Master Package must be scheduled which will in turn fire the other packages
• Worked on sending the Demographics, Medical, pharmacy and Hospital visits of the patients to an application which is accessible by patients.
• Implemented Data Warehousing Concepts of SCD's Type 1 and Type 2 on Dimensions.
• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Worked on building SSRS reports to represent the present health state of the patients by counties in North Carolina.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2016.
• Created various types of SSRS reports (table, chart, list, Matrix Tablix reports).
• Upgraded Excel reports to SSRS reports. Configured and deployed SSRS reports onto Report Server.
• Used report builder to edit reports on the SSRS server
• Worked on Creating, Modifying and updating the Views and Functions.
• Generated Multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drill downs, drill through, sub reports, navigation reports (Hyperlink) etc.
• Worked on creating Power BI Dashboards using tabular model.

Environment: SQL Server 2016/17, SSIS, SSRS, Visual Studio 2017/2015, TFS (2015), Power BI.

Senior SQL Developer

Confidential, Miami, FL

Responsibilities:

• Involved in Full Development Life Cycle starting from requirements gathering & impact analysis to proper functional and technical testing of the reports and user sign offs and maintaining technical design documents, traceability Matrix and assisting users in developing new reports.
• Involved in Data Analysis in consideration with Business Logic.
• Created and scheduled reports / dashboards.
• Involving in Developing 35+ Enterprise SSRS reports for various Business functionalities.
• Configuration and Deployment of all the Reports (RDL) across various SDLC environments.
• Created tables, stored procedures, views, User defined functions, cursors, and ddl and dml commands, triggers.
• Involved in collecting requirements from the User Community, Scope out work and Timelines and development of Reports accordingly.
• Involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Created Cubes on SQL Server Analysis Services as an alternative prototype to an existing relational data mart.
• Created SSIS Packages to perform cube processing from staging area to Analysis Services cubes.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Thorough understanding of Data Warehousing / Multi-Dimensional Analysis concepts like Star Schema, Snow Flake Schema, OLAP.
• Worked with various Reports involving Data driven Subscriptions, Scorecards, KPIs and Dashboards.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Involved in writing Huge and complex Database Stored Procedures that are called in Reports /Sub reports.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Involved in developing/Deploying SSIS packages using BIDS for Data loads required for Reports.
• Involved in various Transformations in SSIS Dataflow, Control Flow using For Loop Containers etc.
• Implemented Event Handlers & Error Handling in SSIS packages & notified process results to various user communities.

Environment: Windows Server 2012, MSSQLServer2012/2008, SQL Server Analysis Services (SSAS), Reporting Services (SSRS 2012/2008), Microsoft Visual Studio 2010, SQL Server Integration Services (SSIS), Data Transformation Services (DTS), .Net, Visual Source Safe (VSS), Web Services, WSDL, MDX

MSBI Consultant

Confidential, Denver, CO

Responsibilities:

• Participated in the discovery sessions with client and vendors to create the design and mapping documents and submit the same for sign off.
• Contributed in creating tables, views, indexes based on the requirements in MS SQL Management Studio
• Created database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server
• Wrote complex SQL queries to retrieve information from the databases to match to the requirements
• Developed and deployed SSIS packages for Extracting, Transacting and Loading from OLTP and various sources
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity
• Developed SQL Queries by using Inner, Left, and Right Joins, database links to fetch complex data from different tables in remote database and formatted the corresponding results into reports and kept logs
• Utilized SQL Server Integration Services to developed, monitored and deployed SSIS packages as well as to produce Data Mart
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS
• Contributed in developing complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS
• Monitored performance and optimized SQL queries for maximum efficiency and defined best practices for report development
• Write and reviewed basic SQL queries and complex Join (Inner, Left, and Right) queries as per the requirements
• Developed reports that monitor different trends and patterns at city and state level which helps in identifying underperform assets

Environment: SQL Server 2008R2/2014, T-SQL, SSRS, MS Excel, Visual studio 2015, SQL Server Agent, Agile

MS SQL Server / SSIS/ETL Developer

Confidential, Providence, RI

Responsibilities:

• Installed and Upgraded from SQL Server 2008 to SQL server 2012 on Various Servers.
• Migrating Databases from SQL Server 2008 to SQL Server 2012.
• Planned, defined and designed data based on the business requirement. Creating dashboard, scorecards using performance point server according to client requirements.
• Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and prepared ETL/SSIS mapping processes and maintained the mapping documents.
• Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Designed logical/physical data models using Erwin tool 8.0. Uses of power pivot.
• Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server.

Environment: MS SQL Server 2012/2008, Enterprise Edition, Bamboo, Performance point server, MS SSRS 2012, MS SSIS 2012, T-SQL, VB Script, Windows Server 2007 and Erwin 8.0

MS SQL Developer

Confidential

Responsibilities:

• Perform all SDLC phases related to extract, transform, and load (ETL) processes using SSIS and stored procedures within SQL Server environment.
• Developed various objects such as Functions, Tables, Views, Triggers, Indexes and Constraints.
• Developed User Defined Functions for giving Scores and views for the application.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• MS SQL server 2012 installation and configuration, mirroring of Data Tier Server, TFS database backup and restoration.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Created Clustered and Non-Clustered Indexes for Query Optimization and involved in Database Tuning.
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Involved in DBA activities such as backups, restores, replication etc. Performs database tuning and troubleshooting. Install and troubleshoot replication, performs production migrations, backups, and database recovery.
• Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Create SSIS package to export and import data from SQL Server to Access, Text and Excel files and configured database mail agent for sending automatic mails.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Environment: MS SQL Server 2008R2, Visual Studio, Windows 2008, T-SQL, MS Excel, Microsoft SQL Server Integration Services (SSIS) 2008, Tfs