Ayush Upadhyay

817-***-****

ac6y9v@r.postjobfree.com

Sr. Business Intelligent Developer/ SQL Developer

PROFESSIONAL SUMMARY:

Over 6years of Professional experience in Information Technology and over 6 years in database design, development of MS SQL SERVER 2000/2005/2008/2008 R2/2014 with Business Intelligence tools SQL MS Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS).

Strong working knowledge of Microsoft SQL Server with skills in query writing and performance tuning.

Strong working knowledge of Data Visualization in SSRS.

Execute data mining techniques for advanced analysis of data and report generation.

Experience in Installing, Upgrading, managing, configuring, migrating and troubleshooting MS SQL Server

Worked extensively on TSQL Code, including complicated joins and cursor loops, creating indexes for fast retrieval of data, creating views, indexes, triggers, cursors, stored procedures and functions.

SQL performance tuning by modifying SQL or adding/changing indexes.

Conducted research to collect and assemble data for databases.

Hands on experience in publishing and sharing workbooks, data sources with user filter to tableau server, setting schedules.

Experience in using Python and its many useful libraries including Pandas used for data reshaping, aggregating, joining disparate sources, etc. for ETL.

Involved in different kinds of Data Model Instance and they are Conceptual Design, Logical Design and Physical Design.

Creating Exception Report after comparing Data source and destination.

Experienced with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.

Experience with large-scale relational databases

Experience in writing SQL Queries, TSQL, Stored Procedures, Views, Functions, Indexes, and database Triggers.

Experience in designing and developing SSIS packages for loading data from Oracle, text files, Excel, Flat files to SQL Server database.

Good understanding of developing Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS) on a Data Warehouse.

Expert in creating packages for migration of the data from one source to different destination using SSIS and Handling error with Event handler using SSIS

Experience in the design, development and implementation of RDBMS using MS SQL and using oracle 8i/9i as well.

Academic Qualification

Bachelor of Science in Physics

TECHNICAL SKILLS:

Operating Systems

Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, Windows 7, Windows 8, Windows 10

Databases

SQL Server 2014/2012/ 2008 R2/2008/2005/2000, MS Access, ORACLE 10g/11g, MySQL

BI Tools

SSAS, SSIS, SSRS, POWER BI, Cristal Report, Tableau

Languages

SQL, T-SQL, PL/SQL,C#, HTML, XML, Python, C, C++

Wells Fargo, Charlotte, North Carolina Jun 2016 – Present

Sr. BI Developer/SQL Developer

Project Description

Wells Fargo is an American international banking and financial company and headquartered in San Francisco,

California. It is the world second largest bank by market capitalization and the third largest bank in the U.S by assets. My project at Wells Fargo was to enhance its Loan Modification Application LMA, create several new reports and improve the existing reports. The reports were created using SSRS.

Responsibilities

Working extensively in Power BI report creating tabular cube, creating data model for Power BI Report, Validating data quality of the report.

Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.

Generated Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.

Review reporting outputs for transparency, consistency, and accuracy.

Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.

Created python data pipelines to load data dynamically from a data folder to MS SQL server using multi threading process which reduced the data loading time.

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Designed python task in SSIS with advanced data manipulation using pandas data frame.

Involved in reviewing business requirements and analyzing data sources form Excel for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.

Developed Stored Procedures for the Datasets to build the reports for the client requirements.

Created SQL Joins, sub-queries and other SQL code to implement business rules.

Performance tuning, and optimization of procedures and queries.

Worked with the use of Data Modeling Standards for all projects requiring a standard means of defining and analyzing data within an organization, to manage data as a resource, for the integration of information systems, for designing Databases/Data Warehouses.

Designed and developed SSIS Packages (.dtxsfiles) to import and export data from MS Excel, SQL Server, Oracle and Flat files.

SSIS packages to update tables with monthly data and automated it through scheduled jobs for the beginning of every month.

Created Schedules and Extracted the data into Tableau Data Engine.

Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models.

Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.

Developed packages in SSIS with error handling.

Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.

Experienced in participating meetings with business users to gather the requirements.

Involved in the analysis of existing database structures and creating the new tables and views as per the requirements.

Involved in generating Forecasting/Predictive models using R and Python.

Worked with development teams in the design of physical databases and in modification.

Involved in the process of Data Modeling which includes professional data modelers working closely with business stakeholders, as well as potential users of the information system.

Participating to create Star Schema, Snow Flake Schema using the concept of data modeling with Team.

Experienced in Dimensional Data Modeling and some of the terms commonly used are Dimension Table, Attributes, Hierarchy, Fact Table and Lookup Table.

Environment: MS SQL Server 2012, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), T-SQL, Python, ORACLE, Microsoft Office 2010, OLAP.

Health Integrated, FL Jan 2015 – May 2016

SQL Server BI Developer

Project Description:

Health Integrated works with commercial health plans and employers serving more than 5 million members. The project mainly involved in extraction of Claims and integrates them according to business requirements. Health Integrated also keeps track of customer information including contact details, insurance plans, and various claims & related information.

Responsibilities:

Created User Defined Functions, Views, stored procedures as per business requirements

Optimized the performance of queries with simplifying queries like removing unnecessary columns, eliminated redundant and inconsistence data

Created SSIS packages to integrate data from text files and excel files and file Transfer from one location to the other using FTP tasks

Performed Normalization and De-Normalization techniques from both OLTP and OLAP system in creating Database objects

Used control flow tasks like For Loop Container, For each Loop Container, Sequential Container, Execute Tasks, Email task and different Data Flow Tasks

Experienced in Dimensional Data Modeling and some of the terms commonly used are Dimension Table, Attributes, Hierarchy, Fact Table, Lookup Table.

Involved in different kinds of Data Model Instance and they are Conceptual Design, Logical Design and Physical Design.

Effectively used data blending feature in tableau. Defined best practices for Tableau report development.

Worked on Transforming and Loading data using SSIS Import/Export wizard

Developed Tabular Reports, Sub-Reports, Matrix Reports, Drill down Reports and charts using SSRS

Performed sorting, formatting and grouping to custom reports in SSRS and also published reports to the report server virtual directory

Created spark applications using python to perform ETL.

Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers

Hands on experience with developing reports using SSRS

Interacted with Developers in troubleshooting application and Report Developing

Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse

Tuned several slow running queries in Production. Implemented Indexes to achieve time performance

Environment: SQL Server 2008/2008 R2/2012, Windows 2003/XP, Enterprise Manager, SSIS, SSRS, SSMS, SQL Profiler, T-SQL

U.S. Cellular - Lincoln, RI April 2012– Nov2014

SQL Server Developer

Project Description:

US Cellular (USCC) is the fifth-largest wireless telecommunication carrier in United States with more than 5 million customers. I worked as the MS SQL Developer in the Data Warehouse team.

Responsibilities

Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.

Involved with Transact SQL (T-SQL) Coding, writing queries, functions & triggers.

Created complex SQL queries using table joins (inner and outer), temporary tables and table variables.

Developed Reports, Sub Reports, Parameterized reports, drilldown reports and various features using SQL Server Reporting Services (SSRS).

Experience in deploying and scheduling the reports based on quarter, month, and year reports.

Enhanced reports by the charts and graphs using Microsoft SQL Server Reporting Services (SSRS).

Developed, monitored and deployed SSIS packages.

Worked on Excels to upload the data from excels to database.

Responsible for implementation of data viewers, error configurations for error handling of the packages.

Optimized long running Stored Procedures and Queries for effective data retrieval.

Optimized queries by looking at Execution Plan for better tuning of the database.

Experience in developing ETL packages with the different sources as Flat Files, Excel, Text files, and XML files and migrating the data into destination using SQL Server Integration Services (SSIS).

Handlers in SSIS packages

Responsible for creating user groups and assigning permissions.

Created DTS packages to transfer objects from development server to production.

Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.

Setup and maintained Linked Servers.

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Life-Source - Minneapolis, MN Sep 2011– Mar 2012

SQL Server Developer

Project Description:

Life-Source is a nonprofit organization dedicated to saving lives through organ, eye and tissue donation in the Upper Midwest. It's our privilege to serve the 7 million people who live in communities across Minnesota, North Dakota, South Dakota and portions of western Wisconsin.

Responsibilities

Created and maintained store procedure for SSIS package and Report service to access data in the SQL Server database using T-SQL.

Created ad-hoc report using MS Excel and Power Pivot (plug-in).

Developed Microsoft SQL Server object (stored procedures, views, scalar-valued and table-valued functions) by using T-SQL.

Configured and created SSIS solutions for ETL and Business Intelligence process for data integration and migration services and managed event handlers, package configurations, logging, system and user-defined variables for SSIS Packages.

Created views based on report requirements.

Contact this candidate