SUMMARY:

• 7+ years of experience as MS SQL Developer in administration and development of Database Design and Development in SQL Server 2016/2014/2012/ 2008 R2/ 2008 system in OLTP and OLAP environment.
• Excellent experience in SSIS, SSAS and SSRS of MS SQL Server
• Highly expert in translating Business System Design document into technical design document.
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• In - depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
• Hands on Experience in Installing, Configuring, Managing, Monitoring and troubleshooting SQL Server 2016/ 2014/2012/2008 R2/ 2008
• Experience in scheduling SSIS packages using SQL Server Agent.
• Strong knowledge of using variables and expressions in packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Excellent skills in implementing ETL Packages using DTS and SSIS 2014/2012/2008 R2/2008
• Proficient in implementing all transformations available on the SSIS toolbox.
• Expert in resolving the performance issue of SSIS packages.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).
• Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility.
• Extensive Knowledge in SSAS storage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Expert in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
• Proficient in Creating business critical KPIs using SQL Server Analysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server 2016/20142012.
• Extensive experience in creating enterprise reports using SSRS 2005/2008 using Report Manager, Report Builder, and BIDS.
• Created many Drill Through, Drill Down, Parameterized reports using SSRS 2005/2008.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012/2014.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Create Metadata Repository database to store metadata.
• Performed XML transformations a language for transforming XML.
• Worked on QNXT Claims Software System, to convert data from their legacy system (LRSP) and add custom applications to satisfy in-house requirements.
• The process included importing claims into QNXT that had been adjudicated and setting them in a “PAY” status so that a payment cycle could be run to create checks on QNXT
• Strong work experience in developing applications under .NET Framework using ASP.NET, C#, VB.NET, WCF , Restful Web API and SQL Server.
• Exposure in .NET Enterprise library, XML, Expression web, Web Grid Validation .
• Significant experience with data intensive visualization/analytics tools Tableau Desktop and Tableau Server, SSRS, PowerPivot, Power BI Reports .
• Explored data in a Variety of ways and across multiple visualizations using Power BI.
• Created SQL datasets for Power BI and Ad-hoc Reports.
• Created visualization reports and dashboards using Power BI desktop.
• Experience in writing reports based on the statistical analysis of the data from various time frame and division using PowerPivot, Power Query, Power View, Power BI

TECHNICAL SKILLS:

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS)

Languages: T-SQL, PL/SQL, XML, C, Visual Basic 6.0, VB.Net, C#, .NET, ASP.NET, HTML.

Operating Systems: Windows 98/2000/2003/ XP/VISTA, Windows Server 2000/2003/2008/2008 R2/2012

Databases: MS-SQL Server / 2008 R 2 / 2012/2014/2016, MS Access, MySQL, DB2

Reporting/ Analysis ools: Microsoft Excel 2007,SSRS, SSAS

Application Software: Visual Studio, Visual Source Safe, MS Office, Team Foundation Server, Sub-Version

ETL Tools: DTS, SSIS, Bulk Copy Program (BCP), Business Intelligence Development Studio (BIDS), Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, Ohio

SQL/SSIS/SSRS 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 using Erwin 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.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• 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 Server environment using SSRS 2014
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2014.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: MS SQL Server 2016, 2014, T-SQL, SSIS 2014, SSRS 2014, TFS, Business Intelligence Development Studio (BIDS), Advanced Server, SSMS.

Confidential, Boston, MA

SQL/ BI Developer

Responsibilities:

• Translated the existing Reports from Translational to Dimensional in SQL Server Management Studio.
• Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Wrote complex stored procedures to process requirement and generating records between front End and back end.
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Created New Reports by using SSRS
• Established the relationships among the tables in the database by assigning primary keys, Foreign keys and established the referential integrity.
• Involved in Planning, Defining and Designing database depending on business requirements and provided the documentation.
• Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database.
• Extensively involved in the design of SSAS storage, partitions and aggregations and developed different calculated members, KPIs, actions by using the MDX while designing the cube using SSAS

Environment: SQL Server Management Studio, SSRS 2014, T-SQL, Excel, Microsoft SQL Reporting Services 2014 (SSRS), Power BI.

Confidential, Augusta, Maine

SQL / ETL Developer/SSIS/SSRS

Responsibilities:

• Extracted data from various sources like SQL Server 2014/2016, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created Data-driven Packages in SSIS 2014 as part of the automating the process for the Referral Process.
• 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.
• Reviewed & Tested packages, fixing bugs (if any).
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved in planning and designing SSAS 2014 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in Staging Partitions and Usage Based Optimization mechanisms for SSAS and OLAP databases.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance
• Developed Drill-down/thru, sub-reports, linked and Dashboard reports using SSRS
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts
• Used calculations, sorts, filters and sections to enhance data presentation in reports. Created many Cascaded parameters in the reports using SSRS.
• Developed many Tabular Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS). Also, created many multi valued parameters in the reports.
• Used Reporting Services to consume data from SharePoint sites and display reports and dashboards on SharePoint sites.
• Identified and worked with Parameters for parameterized reports in SSRS 2014/2016.
• Generated Reports using Global Variables, Expressions and Functions for the reports
• Created Power BI Visualizations and Dashboards as per the requirements.
• Used Power BI for developing reports, data marts, KPI's and charts.
• Designed MVC design pattern for ASP.NET application development using the ASP.NET MVC framework.
• Developed ASP.NET Web API services to return JSON and XML Format.
• Involved in developing applications in C# to meet the business requirements using Visual Studio.NET

Environment: SQL Server 2014/2016, Query Analyzer, SSIS 2014, T-SQL, Excel, Microsoft SQL Reporting Services 2014 (SSRS), Windows 2000/XP, QNXT, Web Forms, SAS tools, Power BI.

Confidential, Los Angeles, CA

MS SQL BI Developer

Responsibilities:

• Maintained databases, performed software installations and monitored Database Performance.
• Involved in reverse and forward loading of the schema of a database using Erwin.
• Responsible for gathering Business Requirements and System Specification from users.
• Studied detail changes that need to be made to each business process that is performed by all the systems impacted.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
• Implemented automated backup and database maintenance / cleanup jobs.
• Generated Views for specific columns on a table to maintain privacy of a customer data.
• Created Indexes to get the high-level performance.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs through SQL Server Agent.
• Designed SSIS packages for loading data from ODS to Data mart.
• Created SSIS packages for synchronizing the data between two different servers.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Experience in the design, development and maintenance of different cubes using SSAS.
• Involved in the post deployment maintenance of canned reports and cubes.
• Experience in designing the reports in ProClarity for SSAS cubes.
• Managed Logins, Users, Roles and User permissions.
• Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services(SSAS)
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Generated Ad-hoc reports and cascading reports for historical data using SSRS.
• Worked closely with end-users to analyze, understand and gather report requirements.
• Created various reports with cascading parameters, multi-valued parameters.
• Created complex reports like grouping, drill-down, drill-thru, charts.
• Wrote complex expressions using operators like arithmetic, Comparison, Concatenation and Logical/ Bitwise and used Common functions like Aggregate, financial, Date time etc. in Development of reports.
• Involved in the implementation of Performance Point Server (PPS).
• Integrated data from many sources into SQL Server and into Tableau for specified visual analytics and reports.
• Created various parameters to achieve desired functionalities in complex filters, quick filters calculated measures and visualizations using Tableau Desktop.
• Involved in Processing QNXT Healthcare Claims
• Worked on the summary of clinical data like Demographic, Adverse Events, Serious Adverse Events, and Related Adverse Events leading to Discontinuation.
• Developed various forms of outputs like RTF, HTML, PDF files using SAS ODS facility.
• Provided reports with minimum risk and optimum result.
• Participated in project meetings, presentations and updating research findings.
• Creating, Approving and Modifying PA in both Portal and QNXT.
• Involved in Adding Contracts to the Provider in QNXT and associating Providers in Portal while creating claims

Environment: SQL Server 2012 and SQL server 2008/2008 R2, SSIS, SSAS, SSRS, Import/Export tools, SQL Server Agent, Windows Server 2008 R2/2012

Confidential, Houston, TX

MS SQL BI Developer

Responsibilities:

• Modified the existing stored procedures to get the new functionality depending on the client requirement.
• Created many tables with the clusters and non-clustered indexes on columns.
• Created various database objects such as tables, indexes and views based on requirement.
• Created daily, weekly, monthly reports for various categories and hierarchies based on business needs using SSRS.
• Create reports such as parameterized, cascading, Drill through/Drill down reports, charts and specialized in producing sub reports using relational data warehouse and OLAP cubes.
• Created many SSRS reports with lots of metrics on it using row grouping and column grouping
• Created table valued functions and used in the report stored procedures on the fly Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved in planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in Staging Partitions and Usage Based Optimization mechanisms for SSAS and OLAP databases.
• Developed Drill-down/thru, sub-reports, linked and Dashboard reports using SSRS
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Created and Maintained Database Maintenance Plans.
• Strong team player and self-motivated
• Conducted cost benefit analysis of various ETL tools and technologies.
• Created UNIX shell scripts, JCL mainframe procedures, and processes to extract data from various sources such as DB2 and Oracle.
• Implemented complex transformations by creating custom transformations in addition to using built-in ones.
• Oversaw unit and system tests and assisted users with acceptance testing.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Played role in design of scalable, reusable, and low maintenance ETL templates.
• Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently.
• Developed & Implemented Reports using Tableau Server.
• Used Power BI Pivot to develop data analysis prototype, and used Power view and power map.
• Created reports using Power BI.
• Designed and implemented Business Layer using C# to implement business logic
• Installation and Configuration and Testing of Team Foundation Server 2012/2010.
• Review and implement migration plan from Vault to TFS.

Environment: SQL server 2012, SQL server Management studio, SQL server integration services (SSIS), SQL server reporting services (SSRS), SQL server Analysis services (SSAS), SQL server profiler, Microsoft visual studio 2010, Power BI, Team Foundation server (TFS)

Confidential, Phoenix, AZ

SQL Developer/ DBA

Responsibilities:

• Administration, Maintenance of multiple SQL Server instances into Prod-Stage-DEV environment.
• Design, Setup, Implementation, upgrade and migration of SQL Server 2005/2008 to SQL Server 2012.
• Setup of jobs and alerts for Backup Restore (VLDB), integrity checks, database shrinking, transaction log growth monitoring and routine database maintenance processes
• Performance and Tuning of SQL Server using Index tuning, profiler, PerfMon, DTA, DMVs and DMFs
• Query optimization using Show Execution Plan, SQL profiler and Query analyzer.
• Development of Indexes, stored procedures, views, functions and triggers using T-SQL.
• Setup, monitoring and maintenance of SQL Server data Replication
• Design/Development and Maintenance of multi-dimensional cube using SSAS.
• Installation, configuration and maintenance of security of SSRS 2005.
• Documentation of coding standards, Technical specifications, policies and procedures
• Provide troubleshooting, Training and support to users
• Developed and modified SharePoint user privileges as directed as incompliance with all standard operating procedures
• Installed all backup procedures and records for SharePoint installations.
• Configure of Microsoft office SharePoint.
• Used VB.Net Code to create embedded functions in SSRS.

Environment: SQL Server 64 bit), SQL Server 2008, Windows Server 2008, VMWARE, .NET, Quest Diagnostic tools, SSIS, SSRS, SharePoint

Confidential

Customer-centric database SQL Developer

Responsibilities:

• Involved in Planning, Defining and Designing database depending on business requirements and provided the documentation.
• Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse with different transformations in order to get the accurate data using SSIS 2008/2005 and deployed the SSIS packages to different environments by maintaining the configuration settings in the XML files and variables.
• Extensively involved in the design of SSAS storage, partitions and aggregations and developed different calculated members, KPIs, actions by using the MDX while designing the cube using SSAS 2008/2005.
• Wrote different MDX queries using different functions to gather the data from the cube and developed the reports using the SSRS 2008/2005.
• Modified the cube structure by adding the new facts, dimensions with user defined hierarchies, calculated members, attribute relations to optimize the cube and develop the user defined reports from the cube.
• Developed many scripts while designing the SSIS package using C#, VB.NET in order to perform various transformations while getting the data from different sources and also resolved the issues with ActiveX scripts and query driven tasks while migrating the DTS packages to SSIS.
• Provided statistical information through different reports to explain business conditions and scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Created parameterized reports and ad hoc reports using Report builder and developed dashboards with different KPIs, scorecards for the users/management and deployed them using Excel, MS Share Point (MOSS).
• Used ASP.Net controls like Dropdown list, Button, Textbox controls while developing the user interface and developed complex web forms and business components.
• Extensively worked with the SQL Profiler, Database Tuning Wizard and query execution plans to identify the slow running queries and to test different application for performance.
• Used calculations, sorts, filters and sections to enhance data presentation in reports. Created many Cascaded parameters in the reports using SQL SSRS.
• Developed many Tabular Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS). Also, created many multi valued parameters in the reports.

Environment: MS SQL Server 2005/2008, SSRS 2005/2008, SSIS 2005/2008, SSAS 2005/2008, SSMS, ASP.NET, VB.NET, C#.NET, MDX, T-SQL, PL/SQL, Oracle 10g, MS Share Point, Access and Excel.

Confidential

SQL Server Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate Consistency Data entry into the database.
• Created reports from database onto excel spread sheet using DTS.
• Wrote complex stored procedures to process employee requirement and generating records between front End and back end.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Experience in Data Modeling using Erwin Design Tool
• Created Users and Roles, and managed security and permission of database.
• Managed and resolved design issues during development
• Worked to establish connectivity between VB applications and MS SQL server by using ODBC

Environment: T-SQL, MS SQL Server 2000, SSMS, DTS, Erwin, Windows NT server, VB, Visual Basic.net