PROFESSIONAL SUMMARY:

• Over 8 years of professional experience on designing, development and implementation of applications related to HealthCare, Banking, Financial and Retail Domains.
• Hands on experience using MS SQL Server (2005/2008/ 2012/2014/2016 ), T - SQL and Microsoft Business Intelligence Suite (SSIS, SSAS, SSRS).
• Extensive Knowledge in developing Efficient Stored Procedures, Tables and Functions.
• Involved in various projects relating to Data Analysis, Data Modeling, System Analysis, Design and Development.
• Strong Knowledge in Normalization/De-Normalization and Data Modeling.
• Very Proficient in SQL Tuning and Optimization of Queries.
• Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.
• Experience in Creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS packages.
• Creating SSIS solutions for ETL and Business Intelligence process for Data Integration and Migration Services.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Expert in Data visualization and Data analyzation using Power BI .
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Defining Data Warehouse (Star and Snow Flake Schemes), fact table, cubes, dimensions, measures using SSAS.
• Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.
• Expert in merging Data from various complex Data sources, Populating Dimension and Fact tables in Data warehouses, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Expertise in creating Partitions, Design Aggregations, Perspectives and Cell Level Security using SSAS.
• Experience in Developing Power BI Reports and Dashboards from Multiple data sources using Data Blending.
• Expertise in MDX to create Named Sets, Named Members, Calculated Members, and other calculations.
• Extensive Knowledge on developing applications using C#, SQL Server,.NET.
• Used tools like MS SQL Profiler, Index Tuning Wizard, and Windows performance for monitoring and tuning SQL Server performance.
• Experience in Developing, Designing and Support inter active Tableau dashboards.
• Worked on the entire software development life cycle (SDLC) including analysis, design, programming, testing and documentation.
• Ability to handle Multiple Tasks, Self-Motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
• Ability to Quickly grasp and Master new concepts and technologies.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2012/2014/2016, MS Access.

Programming Languages: T-SQL, C, C#, .NET Java, Oracle.

Tools: & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, Visual Studio .NET.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), DTS, SQL Server Analysis Services (SSAS), MS Visio, Power BI

Web Technologies: XML, HTML, JavaScript.

Application Packages: MS Office Suite, MS Outlook.

PROFESSIONAL EXPERIENCE:

Confidential, Rancho Cucamonga, CA

Sr.SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing data base based on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Created SSIS package to load data from XML Files and SQL Server 2014 to SQL Server 2016 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Designed, Developed and Deployed reports in MS SQL environment using SSRS 2016 .
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS 2016 .
• Created MDX queries to retrieve data from the cube and to display SSRS reports.
• Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2016.
• Configure Power BI dashboard and reports.
• Configured the report viewing security for various users at various levels using Report Manager.
• Created the structure of the model and cube in MS Analysis Services (SSAS 2016).
• Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.
• Generated ad-hoc Tableau reports based on user requirements.
• Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.
• Generated Tableau reports with Trend lines, Reference lines and Bands and also generated several drill down and drill up reports.
• Designed Cube partitioning and incremental synchronization for SSAS cubes.
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS .
• Designed and Configured Dimensions, Attributes, Hierarchies, KPIs, Aggregations and Cube Partitions.
• Involved in Tabular Data warehouse and DAX operations for SSAS and OLAP databases.
• Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.
• Tuned the performance of SQL queries and Stored procedures using SQL Profiler. Involved in database and log backups & restoration, backup strategies, scheduling.

Environment: MS SQL server 2012/2014/2016, SSRS, SSIS, SSAS , SQL Profiler, Visual Studio 2015, Microsoft Office, Index Tuning Wizard, Power BI , Team Foundation Server (TFS).

Confidential, Dallas, TX

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Installed SQL Server 2012 with latest Service pack and established connectivity with the database created, configured and maintained database maintenance plans.
• Created T- SQL queries, stored procedures, triggers, views, Indexes, Constraints and user defined functions (UDFs) on various database objects to create, modify and/or maintain databases.
• Used SQL Profiler and Database Tuning Advisor for troubleshooting, monitoring, optimizing SQL Server and T- SQL statements.
• Migrated SQL server 2008 R2 packages to SQL Server 2014 SSIS packages using SQL Server 2016 Upgrade Advisor.
• Created packages with different Control Flow options and Data Flow Transformations such as Conditional Split, Multicast, Pivot, Union All etc.
• Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
• Configured Dynamic Checkpoints to allow rerunning a package from the point of failure.
• Implemented Event Handlers, Error Handling and Logging for the packages as per the requirements.
• Created, Tested and Deployed SSIS Packages for Data Migration into Fact and dimension tables in the data marts from the source data warehouse tables.
• Actively involved in identifying business requirements with the client.
• Designed and developed various reports containing data analytics and visualization with reporting tools such as SSRS , Excel Pivot tables, and Tableau on SSAS Cubes and data warehouses as the data sources.
• Worked in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services ( SSRS )
• Worked on dimensional modeling, creating cached reports, drill-down reports, linked reports, report snapshots, parameterized reports and report optimization.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Created SQL scripts to load the custom data into Development, Test and production Instances using Import/Export. Created scripts to create custom Tables and Views.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI .
• 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 2012.
• Designed and Built Cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs using SQL Server Analysis Services (SSAS).
• Optimized the query performance on SSAS Cube by following the recommended best practices.
• Developed ad-hoc queries using SSAS cubes, data warehouses and data marts as data sources.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• SSAS storage and partitions, aggregations, calculation of queries with MDX, data mining models, developing reports using MDX and SQL.
• Created jobs and scheduled jobs using SQL Server Agent.

Environment: MS SQL Server 2008/ 2012/2014/2016, MS SSIS, SSRS, SSAS , Tableau, Excel, MS Visio, Windows 7, MS Office, Team Foundation Server (TFS).

Confidential, Wayne, NJ

M S SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Gathered and collected process & system requirements and actively supported business users for change requests.
• Created T-SQL stored procedures, views, functions and triggers in SQL Server.
• Implemented Constraints, Rules, Defaults, User defined data types and Indexes on tables.
• Used Try catch and error for exceptional handling.
• Designed, coded, tested and debugged business logic for software applications.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Used various control flow tasks like for Loop, execute package/SQL tasks, Script task, send mail task and different data flow tasks/transformation.
• Developed SSIS solution for developing a full-fledged data warehouse solution.
• Successfully migrated SSIS packages from development to test to Production environments using SSIS Configuration files and deployment wizard.
• Identified and worked with multi-value parameters for parameterized reports in SSRS.
• Created Sub-Reports, Drilldown-Reports, Drill through, Summary Reports, and Parameterized Reports in SSRS.
• Maintained report models for ad hoc reports and deployed on report server.
• Deployed Reports, created Report schedules and subscriptions. Managing and securing reports using SSRS Report Manager.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of the over-600 users.
• Maintained data integrity by performing validation checks and Optimized queries tuned and monitored server performance.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2005/2008/2014/2016, Visual Studio 2008/2005, Reporting Services ( SSRS 2008), Business Intelligence Development Studio (BIDS), MS Office 2007, MS Access, ETL, Performance Point Server 2007, MS Excel.

Confidential, Hartford, CT

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Analyzing the Source Database servers, data profiling and generating Database ER Diagrams.
• Creating a Data model for a centralized data warehouse using ERWIN and Microsoft VISIO.
• Generating T-SQL Scripts to Create Schemas, Tables and Views for the Centralized Data Warehouse.
• Designing Tables, SSIS Packages, Stored Procedures, Functions and Views to deliver snapshots of Report data every once in month to the respective Business user's team.
• Creating a Dynamic Stored Procedure using MERGE Statements to incrementally load data from multiple database servers to the centralized data warehouse.
• Using Import/Export Wizard to generate SSIS packages that migrates data from various sources to a Staging database.
• Rationalizing the existing SSIS Packages and other ETL processes to improve performance and maintain data quality.
• Preparing SSIS Package Models to extract data from the source systems and load it into the new Data warehouse.
• Designing SSIS Packages with for Each Loop Containers, Script Tasks and Precedence Constraints for dynamic data load from various store Point of Sales Systems to a central Above-store Database.
• Developing new SSRS Reports for Back Office Users and integrating those with the company's SharePoint server.
• Preparing SSRS Reports with Report subscriptions and Email Delivery mechanisms through SQL Scripts that run on Report Server Databases.
• Developing an automated testing process that validates data between the source and target systems and generates reports on the same.
• Providing Production support to monitor SQL Agent Jobs, Report Deliveries, ETL issues and technical Change Requests.
• Cleaning up data within the other relational database systems and generating new Report Models to improve user interactivity and selectivity.

Environment: MS SQL Server 2008R2, T-SQL, SSIS, SSRS , SQL Profiler, Excel, XML, Team Foundation Server (TFS).

Confidential, Center Valley, PA

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Worked with the business analyst in translating business needs and requirements into functional design specifications.
• Designed and normalized the databases and created different objects like Tables, Views, Stored Procedures and UDF s on MS SQL Server 2008R2.
• Designed and Developed different type of reports including: Tabular forms, Matrix (Cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Defined parameters for parameterized reports and implemented cascading of the parameters.
• Created complex expressions, calculations, sorting, filtering to enhance data presentation in reports.
• Built complex multi-sectional reports with charts and drill down capabilities.
• Developed SQL queries and stored procedures to execute the backend processes using SQL management Studio.
• Verified and formatted the report layout for the various reports.
• Created report models for ad hoc reports when the user wants to see the reports on the fly.
• Created SSIS packages to create static tables for reports.
• Involved in performing Extraction, Transformation and Loading (ETL) using SSIS.

Environment: Windows 2007, MS Visio 2003, MS SQL Server 2008R2, SSRS 2008R2, SSIS, T-SQL, MS Office 2007.

Confidential

MS SQL Developer

Responsibilities:

• Installing, configuring, administering and securing production and non-production servers. Installed and configured SQL Server 2008 on the server and client machines, provide connections and manage databases.
• Created various database objects such as Stored Procedures, Functions, Tables, and Views and wrote T-SQL queries to retrieve data from various tables.
• Managed up gradation of DTS packages to SSIS packages.
• Created SSIS packages to extract data from Excel File, Flat Files, and Text Files and Comma Separated Values (CSV) files using various transformations.
• Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using SQL Server Reporting Services (SSRS).
• Fine-tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, and Execution Plan and Index Tuning wizard.
• Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore.

Environment: MS SQL Server 2005/2008, T-SQL, Windows Server, Erwin, SQL Server Profiler, Microsoft Business Intelligence Development Studio (BIDS), SSIS, SSRS , DTS, OLTP, XML, Visual Source Safe (VSS).

Confidential

Jr. SQL 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 PL/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.
• Involved in performing database Backup and Recovery.

Environment: MS SQL Server 2000/2005, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, T-SQL, PL/SQL, Oracle 9i, TOAD, Windows XP, SQL * Loader.