Resume

Sign in

Data Sql Server

Location:
Fremont, California, 94536, United States
Posted:
April 17, 2019

Contact this candidate

Resume:

Sumit

ac84on@r.postjobfree.com

925-***-****

No W* Calls

Available immediately for bay area locations on C2C

Professional Summary:

Over 11 years of Software/BI Developer and Data Analyst experience in MS SQL Server (T-SQL), SSIS, SSAS, SSRS, Power BI, QlikView, Looker with an emphasis on analyzing, designing, developing, installing, configuring, deploying and tuning for both OLTP and OLAP systems.

Extensive knowledge in T-SQL queries (DDL and DML) and expert in developing stored procedures, triggers, user defined functions, joins, sub-queries, CTE’s, temp-tables, transactions and indexes.

Experience in testing and validating data, performance tuning by using execution plans, database engine tuning advisor, and SQL server profiler.

Extensively worked on Change Data Capture including slowly changing dimensions (SCD).

Experienced in using SSIS for extracting, transforming the data using CDC, Lookup, Task Factory, execute SQL task, sort, merge, conditional split, derived column and union all transformations, and load it into OLEDB/ODBC/File destinations.

Integrated and transformed data from different data sources like Excel, FTP Server, XML and Flat Files to SQL Server database by creating various SSIS packages. Experience in deploying the SSIS packages both project and package level across Dev, Test and Production servers.

Experience in providing Logging, Error handling using Event Handlers for SSIS Packages.

Experienced in developing various SSRS reports including Conditional, Drill-down, Sub reports and parameterized reports.

Fair knowledge on other ETL tool like Informatica.

Experience in developing and analyzing dashboards in QlikView, Looker and Power BI.

Experience in analyzing the data in CRM applications like Salesforce and Siebel.

Experienced in Relational and Dimensional Modeling.

Good understanding in Data Marts and Data Warehouse concepts (OLTP & OLAP).

Experienced in logical and physical data modeling, designing Star Schema and Snowflake Schema with Facts, Dimensions, Measures and Cubes.

Worked in both Waterfall and Agile Methodology throughout the software development lifecycle (SDLC).

Highly motivated and a conceptually strong individual with exceptional analytical and design skills. Flexible, enthusiastic and project-oriented team player with good communication and leadership skills to develop creative solution for challenging client needs

Education Qualification:

Bachelor’s in Engineering (Electronics and Communication) – RGPV, Bhopal (India)

Technical Skills:

Tools, Packages & Databases

MS SQL Server (T-SQL), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Power BI, Azure, Erwin 4.1, Team Foundation server (TFS), MS Excel, Visio, SQL Server Agent, SQL Profiler, MS Access, Visual Studio, JIRA, Informatica, QlikView, Looker, Salesforce, Siebel, PLSQL, SOQL, Redshift

Operating Systems

Windows 2000/XP/7/8/10

Professional Experience:

Backroads – Berkeley, CA June 2018 to Present

Senior Data Developer (SQL, SSMS, SSRS, Power BI, SSIS, Informatica)

Backroads is worldwide active travel company focusing on bike tours, family vacations, walking and hiking tours.

The project involved data migration from existing Backroads applications to Salesforce CRM and travel industry ERP (Softrip).

Responsibilities:

Meet with business users to understand the requirements.

Analyze requirements to come up with Data Mapping and write SQL scripts for data transfer/migration.

Creating ETL packages to validate, extract, transform and load data to data warehouse database.

Design and develop T-SQL stored procedures, functions, views etc. to provide application functionality and improve performance.

Performance tuning of ETL packages and SQL stored procedures.

Build SSRS and Power BI reports and dashboards for business users.

Created and execute unit and integration tests cases.

Data modeling, designing star and snow flake schemas, identifying facts and dimension attributes.

Responsible for scheduled job maintenance and trouble shooting.

Created SQL jobs and monitored them often and updated business with the successful migrations.

Worked as a secondary DBA and took care of SQL server maintenance activities. Login creation, new users set up etc.

Create technical documentation for the future maintenance purpose.

Environment: SQL Server 2016, T-SQL, SSRS, Power BI, SSIS, Informatica, ETL, MS Office, JIRA

Autodesk – San Rafael, CA October 2016 to May 2018

Senior BI Developer/Data Analyst (SQL, SSMS, SSIS, Informatica, Salesforce, Power BI, Looker, QlikView)

Autodesk, Inc. is an American multinational software corporation that makes software for the architecture, engineering, construction, manufacturing, media, and entertainment industries. The main objective of the project is to develop and maintain BI dashboards to track subscription and renewal activities.

Responsibilities:

Develop and communicate a deep understanding of subscription lifecycle, perform analytical deep-dives to identify problems, opportunities and specific actions required.

Develop and implement data mining solutions to fit business problems

Perform ad hoc statistical and data mining analysis

Handling customer retention, churn and renewals.

Extract actionable insights through analyzing large, complex, multi-dimensional partner/customer data sets

Working independently with the biz stakeholders with minimal direction and proactively engage with them

Analyze large datasets from different platforms to troubleshoot and investigate data relationship.

Build SQL queries to extract data from different datasets for analysis and troubleshooting.

Developed T-SQL stored procedures, functions, views etc.

Analyze data and relationship in CRM applications like Salesforce and Siebel.

Involved in database modeling and data warehousing principles.

Creation of documents that include solution diagrams and data models and source to destination mapping.

Analyzing different BI tools like QlikView, SSRS, Power BI, Looker etc. to deliver best solution to the problem.

Develop dashboard and reports using QlikView, SSRS and Looker.

Develop ETL packages using Informatica Power Center and SSIS to extract data from different sources like SQL Database, Salesforce, Flat file etc. and transforming data to load into target tables.

Environment: SQL Server 2012, PLSQL, T-SQL, SOQL, Salesforce, Siebel, QlikView, Looker, SSRS, Power BI, SSIS, Informatica, OLAP, OLTP, Excel, MS Office, JIRA

KinderCare Learning Centers – Portland, OR May 2016 to September 2016

MSBI Technical Lead (SQL, SSIS, SSMS, SSAS)

KinderCare Learning Centers is an American operator of for-profit child care and early childhood education. The main objective of the project is to identify dimensions and facts from the organizational reports and build data warehouse combining data from various source systems.

Responsibilities:

Involved in the enterprise data warehouse (EDW) designing process depending on the requirements from the business users.

Involved in data modeling, designing star and snow flake schemas, identifying facts and dimension attributes.

Created several ETL packages using SSIS for loading the data from different OLTP databases to staging area and finally transfer into data warehouse using CDC and Lookup transformations for change data capture.

Used various transformations like conditional split, derived column, multicast, union all etc. for transforming data and storing them in the final database tables.

Created ETL packages for Type-1 and Type-2 slowly changing dimension (SCD).

Created several stored procedures, constraints, views etc to implement different business logic.

Created SQL Agent Jobs to execute the SSIS packages.

Used staging tables to store the data for transformation before loading them into the main tables.

Used the execution plans, SQL profiler, and database engine tuning to improve the performance of the queries used in the packages.

Created Tabular Model using SSAS to analyze the data and used DAX expressions to create custom calculations and measures.

Involved in the meetings with the business users to understand the requirements.

Worked with the testing team to resolve the issues rose during testing process.

Involved in deployment activities of SSIS packages.

Created technical documentation for the future maintenance purpose.

Followed Agile Methodology to provide update on the day to day processes.

Lead the development team of 4 members.

Environment: SQL Server 2016, SQL Profiler, SSIS, SSAS, OLAP, OLTP, Visual Source Team Foundation (VSTF), Excel, Windows 8/10, MS Office

Microsoft, Redmond, WA August 2013 to May 2016

Senior MSBI Developer / Data Analyst (SQL, SSIS, SSRS, SSMS)

Microsoft Corporation is an American multinational technology company with headquarters in Redmond, Washington. It develops, manufactures, licenses, supports and sells computer software, consumer electronics, personal computers, and services.

The main objective of the project is to build and maintain revenue reporting tool. Primary user groups are Sales & Marketing, Finance and Operations.

Responsibilities:

Collaborate with clients and vendors to conduct in depth analysis and deliver solutions.

Work with key stakeholders to convert business requirements into Functional Requirements Document (FRD), and develop use cases

Understanding the relevant applications impacted, infrastructure and business implications of the developed solution.

Work as engineering PM-Analyst with business to gather requirements to be implemented as system solutions.

Involved in the analysis, planning, and defining of the business requirements and provided technical documentation.

Work closely with Developer/Test teams both on-shore and off-shore during all phases of the project life cycle (SDLC).

Help drive development projects through the software development phases

Involved in the data warehouse designing process depending on the requirements from the business users.

Created several ETL packages using SSIS for loading the data from different sources like Flat file, Excel and OLTP databases and to staging area and finally transfer into data warehouse.

Used Event Handlers for logging and Exception Handling in SSIS packages.

Used various transformations like lookup, aggregations, derived column, etc. for transforming data and storing them in the final database tables.

Created several stored procedures, triggers, functions, views etc to implement different business logic.

Used the execution plans, SQL profiler, and database engine tuning to improve the performance of the queries used in the packages.

Worked with the testing team to resolve the issues rose during testing process.

Involved in deployment activities of SSIS packages.

Created new jobs in SQL server Agent to schedule the packages.

Developed SSRS reports.

Created technical specification document for the future maintenance purpose.

Environment: SQL Server 2012, SQL Profiler, SSIS, SSRS, Visual Source Team Foundation (VSTF), Excel, Windows 8/10, Microsoft Outlook, MS Office

Microsoft, Reno, NV March 2012 to July 2013

Senior MSBI Developer (SSMS, SSIS, SSRS, SSAS)

Microsoft Corporation is an American multinational technology company with headquarters in Redmond, Washington. It develops, manufactures, licenses, supports and sells computer software, consumer electronics, personal computers, and services.

The main objective of the project is to extract data and build Open SA Reports, which are used to track expirations against the expiring customers for the complete fiscal years in Expirations Reports and to track the renewals for those expiring customers in Booking Reports. Expiration and Booking Reports are SSRS based reports.

Responsibilities:

Creating ETL packages using SSIS to validate, extract, transform and load data to a data warehouse database.

Developed SSAS cubes to store data for analysis and wrote MDX queries to retrieve data from the cube.

Wrote and edited several T-SQL stored procedures to provide application functionality, preserve referential integrity and improve performance.

Worked on enhancing the application specific data sources and added new fields per the requirement

Monitored and modified Performance using execution plans and Index tuning.

Designed several parameterized reports, linked reports, sub reports, drill through reports using SSRS.

Used various data flow tasks derived columns, lookups, merges, OLE DB command, union all, pivots, and transferring error rows to text file.

Experienced in using Execute SQL task to run the database side operations on the database to improve the performance of the SSIS package.

Created SSIS packages to lookup data from Client files and the database tables and update the changes accordingly in the database.

Created various packages to insert the data into the database from the text files and move the files to a backup location.

Developed SSIS packages with script task to inform if the task failed on our end.

Developed the SSIS packages with XML configuration files and variables for connection managers for the flexibility of changing the database names and for the ease of deployment.

Configured SQL mail agent to send automatic mails to users on errors.

Actively supported business users for change requests.

Participated in deployment activities of the SSIS packages.

Involved in the database upgrading activities to SQL server 2012.

Environment: MS SQL Server 2008/2005, MS SQL Server Integration Services (SSIS) 2005/2008, MS SQL Reporting Services (SSRS) 2005/2008, SSAS, VB, MS Excel, TFS, Windows XP/7.

Microsoft, Hyderabad, India May 2007 to Feb 2012

MSBI Developer (SSMS, SSIS, SSAS)

Microsoft Corporation is an American multinational technology company with headquarters in Redmond, Washington. It develops, manufactures, licenses, supports and sells computer software, consumer electronics, personal computers, and services.

The main objective of the project is to build and maintain the License Information Repository (LIR), is a data warehouse reporting and ad-hoc querying environment. LIR consists of one Factory server that consolidates and transforms data from multiple sources and distributes that data to multiple Repository servers that make data available to end customers, channel partners, and internal stakeholders.

Responsibilities:

Extracting data from different databases and comparing the data rows.

Creating ETL packages using SSIS to validate, extract, transform and load the data and process SSAS cubes to store data for analysis.

Wrote and edited several T-SQL stored procedures to provide application functionality, preserve referential integrity and improve performance.

Used various data flow tasks derived columns, lookups, merges, OLE DB command, union all, pivots, and transferring error rows to text file.

Created new SQL jobs using SQL Server Agent to schedule the SSIS packages.

Created several clustered, non-clustered indexes to tune the performance of the queries.

Experienced in using SQL profiler to trace the procedure or query which has performance issue.

Configured SQL mail agent to send automatic mails to users on errors.

Creating, monitoring, regressing and scheduling Jobs

Developed and edited several stored procedures and user defined functions to implement functionality.

Created several technical documentations before the development process to attain the approval from manager.

Actively supported business users for change requests.

Fixing bugs raised during DUT, DIT, SIT and UAT phases.

Environment: Microsoft SQL Server 2008/2012, SSIS, Visual Source Team Foundation (VSTF), Microsoft Office, Microsoft Project, Erwin.



Contact this candidate