Harsh Upadhyay ac0fh9@r.postjobfree.com 571-***-****

Summary:

Around 8+years of experience in Microsoft technologies withAnalysis, Design, Development, Administering,Implementing and Testing Microsoft SQL Server and BI suite (Development, UAT and Production Environment.

Strong technical knowledge in MS SQL Server development including SSIS, Microsoft Analysis Services, Performance tuning, Reporting, designing logical/physical databases and Troubleshooting.

Extensive experience with different phases of project life cycle (Design, Implementation, Testing, and debugging new and existing database systems).

In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.

Experience in SQL Server and SSIS (Integration Service) package design, constructing, and deployment.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services SSIS 2005/2008R2.

SQLServer 2005/2008 RDBMS database development including T-SQL programming.

SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions.

ETL implementation using SQL Server Integration Services (SSIS).

Developing reports on SSAS & SSRS on SQL Server (2005/2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture.

Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.

Deployed and maintained reports on reports server.

Thorough understanding of Kimball’s’ theory, KPIs, SQL 2005 Architecture.

Knowledge on integration of BI suite of products with Microsoft Office range of products like Business Scorecard Manager, Dashboards.

Good understanding of Software Development Life Cycle.

Worked in Data modeling, creating star and snowflake schemas in SSAS.

Supported team in resolving SQL Reporting services and MY/T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, drill through, Summary, Form, OLAP and Sub reports and formatting them.

Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.

Technical Skills:

BI Suite : SSRS, SSIS, SSAS, PPS, Hypérion

Database: SQL Server 2005/2008, Oracle10g/ 11g, TERADATA and DB2.

Database Tools: SQL Lite speed, TOAD, ORACLE and PL SQL DEVELOPER

Programming Languages: SQL, PL/SQL, C and C#.Net

ETL TOOLS: DTS, SSIS, Informatica.

VERSION CONTROL: VSS 6.0, SVN and TFS 2005

Operating Systems: Windows XP/2007/2008

Professional Experience

USA Today, McLean, VA May 2016 -Present

Sr. SQL/BI Developer

Responsibilities

Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008andSSIS in Business Intelligence Development Studio (BIDS).

Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.

Created parameterized reports, Drill downandDrill through reports using SSRS.

Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications.

Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Prepared the complete data mapping for all the migrated jobs using SSIS.

Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures andtriggers.

Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008/12

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2.

Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008/12.

Performed operations like Datareconciliation, validation and error handling after Extracting data into SQL Server.

Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.

Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.

Created reports with Analysis Services Cube as the data source using SSRS.

Environment: MS SQL Server 2014, [SSIS (SQL Server Integration service), SSRS (Reporting Services), SSAS (Analysis service)], Informatica (ETl Tool).

CareFirst (BCBS) Baltimore, MD May 2013- May2016

Special Investigations (SI) identifies, resolves, and prevents fraud and abuse (F&A) on behalf of CareFirst (CF) and its customers. To accomplish these goals, SI uses the vendor product Services Tracking Analysis Reporting System (STARS). This application assists SI in identifying F&A trends in CF claims data. The User administration function for the STARS application is provided by CF Audit & Information Services (AIS).

The current version of the STARS application is several versions behind the Vendor’s current release, requiring manual workarounds which are inefficient and reduce productivity. This impacts SI’s ability to provide timely and effective F&A detection and case work.

Responsibilities

Create new tables, views, indexes and user defined functions.

Actively designed the database to fasten certain daily jobs and some stored procedure.

Created SSRS reports for Franchise Health Reports.

Created User list first title played reports.

Created reports by retrieving the data from cube using MDX reports.

Designed reports, Graphs and deployed reports to web applications using SSRS.

Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse.

Designed MDX queries to retrieve data from SSAS cubes.

Created SSIS packages for File Transfer from one location to the other using FTP task.

Designed Cube partitioning and incremental synchronization for SSAS cubes.

Involved in performance tuning of TSQL queries and Stored Procedures.

Optimized query performance by creating indexes.

Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users and roles.

Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL

Queries and Stored Procedures.

Use the SQL Analyzer, and Profiler for studying the SQL statements and procedures

Developed complex stored procedures to create various reports.

Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

Designed Star Schema and Snow flaked schemas in the process of data modeling.

Access SQL Server using front end applications like VB.

Environment: MS SQL Server 2008 R2/2012, Oracle 10g, [SSIS (SQL Server Integration service), SSRS (Reporting Services), SSAS (Analysis service)],Informatica (ETl Tool), Crystal reporting.

Vantage System INC (NASA), Lanham, MD Sept 2012- May 2013

Sql/BI Developer

Vantage Systems, Inc. is a NASA multi-disciplinary engineering services company providing progressive solutions to spaceflight projects within the National Aeronautics and Space Administration (NASA) and the NASA prime contractor community. The project was to develop the SharePoint application which deals with generation of the new projects as the task and based on the requirements and the concert person for approving the task .it also generate the dynamic reports based on the previous and current fiscal year approved and more required budget.

Responsibilities:

Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub reports using Sql Server Reporting Services 2008 R2.

Generated the most dynamically operating SSRS reports based on the changing parameters and the values of the parameters

Created the complex store procedure and also work on the performance tuning of the store procedure.

Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2008R2/2012.

Designed and developed reports using Crystal Reports XI version.

Experience in deploying the reports and configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).

Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Created Crystal Reports using Crystal Reports formulae, Grouping, Parameters, Selection criteria.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.

Imported data from text files and excel spread sheets into SQL Server 2008 R2 database using SSIS package.

To analyze long running queries and tune the same to optimize application and system performance.

Interact with the Business Admin and gather the requirements and analyzed.

Environment: MS SQL Server 2008/2012, Reporting Services (SSRS),IIS 6.0/7.0, SQL Server Integration Services (SSIS), Crystal Report.

Associated Bank, Green Bay, WI Oct 2011 – Sept 2012

SQLDeveloper

Associated Bank provides financial services to local communities specializing in banking, home equity mortgages and retirement saving plans. The scope of the project was to enhance the company web portal by introducing new functionalities such as; online banking & payments, loan and mortgage applications etc. Apart from my involvement in creating web based ASP.Net forms, I was primarily involved as SQL developer.

Responsibilities:

Generated Logical and Physical Data Model, Normalization and building Referential Integrity Constraints.

Created database to collect data that were entered in the form, Created index, function and stored procedures DML.

Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.

Analyzed data quality, validated the data, designed and created tables, server roles, logins and users in the database.

Designed and implemented integrity constraints, written triggers and stored procedures to offload middle-tier transactions. Used database maintenance plans for backing up the database and transaction log files.

Experience in debugging and performance tuning of targets, sources, mappings and sessions.

Performed daily tasks including backup and restore by using T-SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Compressed data files by removing empty database pages and updating index statistics .and monitored scheduled jobs and alerts using SQL.

Deployed and managed reports with the aid of Crystal Management Console.

Environment: MS SQL Server 2005/2008, ASP.Net,SQL 2008 R2,Server Reporting Services (SSRS),IIS 6.0/7.0, (SSIS), (SSAS),Crystal Report and VS 2010.

Deloitte Financial Services, Washington Nov 2010 – Sep 2011

Sr. SQL Developer (SSRS/SSAS/SSIS)

The project was creating Client data analysis. The task at hand was to create business intelligence objects to analyze the data acquired from the various applications running on thousands of customer loans the project was completed to success with time to spare for observation recovering the loans

Responsibilities:

Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.

Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.

Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.

Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.

Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Levels including Dev, INT, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.

Developed Custom Reports using SSRS/SQL server.

Build the SSRS environment for both Dev. and test servers based on the individual client needs.

Worked with T-SQL(DDL/DML) to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL,SSRS,Informatica, Windows Server 2003, Oracle 10g, Visual Studio 2008.

Allstate Insurance, St. Louis, MO Sept 2009 -Oct 2010

MS SQL Server Developer

Description:Allstate Insurance is Leading Company in Auto, Financial services products and the healthcare insurancethat help customers prepare for the future and Home Insurance Industry. Allstate has a Data Warehouse that gets data from 2 systems using 2 different sets of code. The main objective of this Project is to integrate the code so that the Insurance data warehouse would handle the datafrom both systems

Responsibilities:

Analyzed the requirements and selected the appropriate fact tables/created fact tables

Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions

Created the storage type (ROLAP),Created cubes for Business Intelligence

Involved in writing MDX Scripts for the OLAP CUBES.

Creating Static Reports using MDX queries and creating MDX Base Report Definition.

Experience in building and maintaining Data marts. Created roles for using the cubes

Transferring data between XML document and SQL server

Performed activities such as database creation, database tuning, performance planning, backup planning and database administration

Actively involved in Normalization & De-normalization of database

Materialized views, dimensions and stored outlines for optimal performance

Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems

Used Performance Monitor and MY SQL Profiler to optimize queries and enhance the performance of database servers

Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence

Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Design, Coding Standards, Periodic Data refresh, database upgrades across the enterprise

Environment: SQL Server 2005 2008 R2 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Crystal Reports,XML, Windows Server 2000, Oracle.

Infinera Corporation, Sunnyvale, CA July 2008 – Aug 2009

. Net Developer

Infinera combines Photonic Integration with our unique Bandwidth Virtualization technology to create the Digital Optical Network.

Responsibilities:

Installed, authored, and managed reports using SQL Server 2005 Reporting Services

Analyzed the project environment and sub systems of the project, and prepared a high level documentation for application designing.

Interact with the clients and gather the requirements and analyzed.

Responsible for gathering business requirements, developing and reviewing of design documents

Did trouble shooting of Client connections, viewing error log and applications.

Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

Expertise in report generation using SQL Server Reporting Services (SSRS).

Outstanding knowledge in creating drill down reports, ad-hoc reports and drill through reports in SSRS.

Transferred data (ETL) to Data ware house Environment using SSIS.

Maintained the database consistency with DBCC at regular intervals.

Environment: MS SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS and Windows Server 2003, MS Access, crystal reports,informatica.

Education:

Bachelor of Computer Science

Contact this candidate