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