SUMMARY

• Around 10 years of experience in MS SQL Server 2008/2008R 2/2012/2014/2016 and Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2008/2008R 2/2012/2014.
• Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experience in extracting and transforming (ETL process) data using DTS/SSIS Import Export Data from various sources, Bulk Insert, Log Shipping, BCP and DTS/SSIS Packages.
• Microsoft SQL Server by using SSIS and DTS utility of SQL server 2005/2008/2008 R 2/2014/2016/2017.
• Experience with all phases of software development life cycle (SDLC) and project methodologies.
• Created and Designed a Multi-Dimensional Analysis (Configured OLAP Cubes, Dimensions, Measures, MDX Queries, Data mining, Data Source and Data Source Views and Star and Snow Flake schema) using SQL Server Analysis Services (SSAS).
• Knowledge in query optimization & performance tuning, using SQL Server Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Good SQL Server Administration skills using various backup recovery, replication, restoration and DTS servers, Model (simple, Bulk and full), database maintenance plan.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tool.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like MS SQL Server, Oracle Database, Excel and Flat file to Microsoft SQL Server by using SSIS and DTS utility of SQL server 2008/2008R 2/2012/2014/2016 .
• Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries
• Experience in building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Excellent Experience in .NET Platform Technologies in both Web Forms and Win Forms using ASP.NET, C#, Web Services, XML/XSLT.
• Excellent knowledge in Object Oriented Concepts/Methodologies.
• Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling.
• Experience in working with report development in MS-Office Access, MS Excel and Crystal Reports.
• Experience in Performance Tuning, Query Optimization, Execution Plan, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Experience working in a clustered OLTP environment with Very Large Databases (VLDB) and having version control (Visual SourceSafe and Team Foundation Server).
• Experience in maintaining SQL Server security by assigning logins, server, database roles and server permissions.
• Experienced in manual, automation, integration and performance testing
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio (SSMS), Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine, Shell Scripting, Data Warehousing, Business Intelligence Development Studio, SSIS, SSAS, Data Transformation Services.

Reporting tools: SSRS, Power-BI, Crystal Reports, Tableau.

Databases: SQL Server 2016/2014/2012/2008 R2/2008/2005, MS-Access, PL/SQL.

Programming Languages: C, C#, T-SQL,HTML,XML

Version Control: Team Foundation Server (TFS), Visual Studio Team System (VSTS).

Data Modeling: MS Office Visio 2003/2007.

Operating System: Windows 10 Enterprise, Windows 2000, Windows Server 2003, Windows NT, Windows 95/98/2000 XP/Vista/7/8, Unix.

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

Confidential, Cordova, CA

SQL BI Developer

Responsibilities:

• Working on Professional claims and Institutional claims of VA data.
• Working on Invoices to Recoupment Reconciliation and Recoupment to Invoices Reconciliation Reports.
• Worked on 837 claims to get amount of the claims to be received from VA.
• Working on recouping the amounts from VA to providers.
• Participate in all aspects of the software development process including, requirements, designing, coding, unit testing, quality assurance, and deployment
• Created and Modified T-SQL stored procedures/triggers to validate integrity of the data.
• Developing custom web parts and component for SharePoint.
• Worked on developing source to target specifications for Data Transformation Services.
• Performance Tuning in SQL Server 2014/2016 using SQL Profiler and Data Loading.
• Have experience in creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server and DB2 Database.
• Created SQL Jobs to schedule SSIS Packages and Finance reports using SSRS reports.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Experience using Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Developed functions, views and triggers for automation.
• Created Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping and various dynamic reports using SSRS.
• Created subscriptions in SSRS to deliver reports to a shared file.
• Created report snapshots to improve the performance of SSRS.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Evaluated data models to design Tableau solutions.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Maintained Test log and Wrote test Evaluation, and Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Create relevant processes for request in-take, assignment, delivery and support.
• Responsible for SharePoint site management support activities for a federal contract.
• Worked on improving the accuracy of the source data by implementing data validation on the source Data for reporting.

Environment: SQL Server 2014, SQL Server 2016, Share point, Excel, SSIS,SSRS, Visual Studio 2015, Visual Studio 2013, Tableau.

Confidential, Rochester, NY

SQL Developer

Responsibilities:

• Involved in planning, Defining and Designing data based on business requirements and provided documentation.
• Created Tabular Model cube end to end with Measures, KPI’s using SQL Server Data tool/Visual studio.
• Expert in implementing the snapshot isolation and DDL triggers.
• Having experience in complete end to end ETL creation of SQL Server Integration Services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring).
• Migration of the SQL server procedures to the Oracle procedures and make sure the data Matches between 2 environments (SQL server DB and Oracle DB) followed by Unit and User acceptance testing.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data.
• Shared responsibility and was involved in Data migration from SQL Server 2014 to SQL Server 2016 Databases.
• Provide High-level disaster recovery plan during the production phase.
• Actively involved in Normalization & De-normalization of database.
• Wrote Views, Stored Procedures, and Triggers to transform data from different sources.
• Worked on sending out subscription emails for SSRS reports.
• Migrated crystal reports to SQL Server Reporting Services (SSRS).
• Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Created report snapshots to improve the performance of SSRS.
• Worked on Connecting Tableau server with share-point portal and setup auto refresh feature.
• Build advanced SharePoint workflows and workflow-based solutions.
• Build reports using tools such as MS SQL Reporting Services or Excel.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Additional responsibilities included process development/implementation using VSTF (Visual Studio Team Foundation), VSTS (Visual Studio Team System) and Product Studio.
• Also, evaluated and trained test and development teams on the early adoption of Microsoft's TFS/ VSTS to enhance workflow and productivity.

Environment: SQL Server 2016, Enterprise Edition’s Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSAS), TSQL, VSTS, MS Visual Studio, MS Access, Tableau.

Confidential, Rochester, NY

SQL BI Developer

Responsibilities:

• Worked in Payroll Projects to get employees pay information weekly and biweekly and their benefits by refreshing the data weekly.
• Great ability to create and manage various database objects like tables, and views.
• Partner with our IS Team to provide support, maintenance, plan for future growth and development, and manage the SharePoint environment.
• Import data from sources (Excel, .csv) to SQL Server using SSIS Packages.
• Worked Extensively on ETL process using SSIS package.
• Gather all aspects of City Government and develop scripts or load data to the tables and technology focus includes enterprise system application selection and deployment and technologies used are MSSQL, SSIS, SSRS and SSAS.
• Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Implemented database standards and naming convention for the database objects.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database.
• Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Worked with Star Schema, Cubes and Analytical services.
• Worked on developing Active Directory information of the Active Employees using C# in SSIS.
• Involved to develop the VB Script, C#, and .Net framework in SSIS.
• Source data from the city and perform to develop SSIS Package to load data into server table based on the requirements from the Business analysts.
• Support and execute the steps for creating massive data sets that would be used for statistical modelling and predictions.
• Experience in data integrity, including data backup and storage standards.
• Experience in working for payroll projects and integrations.
• Created reports with SQL Server Reporting Services (SSRS) on departmental information of the active employees.
• Assist in developing standards and policies for the use of SharePoint in the business.
• Fine-tuned SQL queries to improve query performance and to reduce runtime.
• Responsible for defining the key identifiers for each mapping/interface.
• Designed and developed an automated process which runs after batch cycle and send alert if there is any discrepancy.

Environment: SQL Server 2008R2, SQL Server 2012, MS Access, Excel, Windows Server 2008, Visual Source Safe, Visual Studio 2010, Visual Studio 2008r2.

Confidential

SQL Developer

Responsibilities:

• Design and develop SSIS packages, store procedures, configuration files, Tables, Views, Indexes
• Used SSIS to extract data from MDM Staging Database and MCDMDM Database.
• Used FTP to transfer large volumes of data to different servers.
• Created SSIS jobs for monitoring the jobs that depend on daily loads and loading DB2 Database Tables using SQL Server Agent.
• Automate tasks using active x script (similar to VB script). Be able to implement failure alerts using email in SSIS.
• Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling).
• Involved to develop the VB Script, C#, and .Net framework creation in SSAS and SSIS.
• Developed Transact-SQL (T-SQL) Queries, Stored Procedures, Triggers, User Defined Functions (UDF), Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default.
• Created Windows Logins and privileges to User Accounts/Groups and objects
• Developed CTE’s, Constraints, and Complex queries to fetch the data from different servers.
• Developing Micro strategy reports for business reporting needs.
• Responsible for creating Metrics, Filters and Prompts to enable decision-makers create customized reports.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Defined relationship between tables and enforced the referential integrity constraints.
• Created Clustered and Non-Clustered Indexes.
• Responsible for General Database Administration and Performance tuning.
• Experienced in resolving deadlock and blocking issues for concurrent users
• Worked with DTS packages to load the massaged data into Data warehousing system.
• Data Migration from legacy to master tables using DTS-Import and Export wizard.
• Developed Database Backup Scripts and automated this process
• Experienced in support, applications and software development.
• Fine-tuned SQL queries to improve query performance and to reduce runtime
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Created SSIS packages for loading Fact Tables, Dimension Tables from Excel, Oracle, and DB2 Databases.
• Created a number of fact tables, dimensions, measure groups using SQL Server Analysis Services representing aggregations in several different ways.
• Created partitions and designed various storage modes to increase the performance of cubes using SSAS.
• Administering the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Developed a thorough knowledge by working on Full Life Cycle of the Software Development Life Cycle (SDLC) phases namely Analysis, Design, Coding and Testing.
• Used Team Foundation Server (TFS) for version control.

Environment: Microsoft SQL Server 2014, Oracle, MS Access, Excel, Teradata, Windows Server 2008, IIS, Visual Source Safe, Net Frame Work, XML Parsing, VB6, VB Script, and TFS.

Confidential, Jacksonville, FL

SQL Developer

Responsibilities:

• Design and develop SSIS packages, store procedures, configuration files, Tables, Views, Indexes
• Used SSIS to extract data from Enterprise data warehouse, Oracle added multiple transformations to transform the data and finally loading into the DB2 Data base.
• Used FTP to transfer large volumes of data to different servers.
• Used Table Difference, Upsert’s, Look Up’s, and Conditional Splits for finding Deltas.
• Used SQL BI-xPress for Managing, Auditing and Notification Frameworks.
• Created SSIS jobs for monitoring the jobs that depend on daily loads and loading DB2 Database Tables using SQL Server Agent.
• Automate tasks using active x script (similar to VB script). Be able to implement failure alerts using email in SSIS.
• Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling).
• Involved to develop the VB Script, C#, and ASP.Net, VB.Net and .Net framework creation IN SSAS and SSIS.
• Developed Transact-SQL (T-SQL) Queries, Stored Procedures, Triggers, User Defined Functions (UDF), Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default
• Based on Windows Script Host manipulated the files using VB Script.
• Created Windows Logins and privileges to User Accounts/Groups and objects
• Developed CTE’s, Constraints, and Complex queries to fetch the data from different servers.
• Developing Micro strategy reports for business reporting needs.
• Responsible for creating Metrics, Filters and Prompts to enable decision-makers create customized reports.
• Designed interactive and visually stunning Dynamic Dashboards using Report Services objects like Waterfall, Graph Matrix, Gauges, Micro charts Widgets and Grid/Graph combinations
• Generating parameterized reports, drill down and drill through reports.
• Fine-tuned SQL queries to improve query performance and to reduce runtime.
• Worked on creating visualization for logistics calculation and department spend analysis.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Created SSIS packages for loading Fact Tables, Dimension Tables from Excel, Oracle, and DB2 Databases.
• Created a number of fact tables, dimensions, measure groups using SQL Server Analysis Services representing aggregations in several different ways.
• Created partitions and designed various storage modes to increase the performance of cubes using SSAS.
• Administering the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Developed a thorough knowledge by working on Full Life Cycle of the Software Development Life Cycle (SDLC) phases namely Analysis, Design, Coding and Testing
• Used Team Foundation Server (TFS) for version control.

Environment: SQL Server 2008, Oracle, MS Access, Excel, Teradata, Micro strategy 8.1, Windows Server 2008, IIS, Visual Source Safe, Net Frame Work, ADO.Net, VB.Net, ASP.Net, XML Parsing, VB6, VB Script, and C#.