Data Developer
Resume:
Manav Chauhan
MS SQL Server/BI Developer
***************@*****.***
* ***** ** ********* ********** in SQL Server Development with T-SQL, SQL server 2008/2012/2014/2016 Business suite of products like SSIS, SSRS and SSAS.
Knowledge of Data Analysis, RDMS, OLTP, OLAP and experience with MS SQL Server in writing T-SQL, SSIS, SSRS
Have Good experience RDBMS concepts
Experience in Constraints, rules and default setting Primary, Foreign, Unique and Default Key.
Created Clustered and Non Clustered Indexes.
Experienced in creating and maintaining database objects like tables, Views, Stored Procedures, DDL/DML Triggers, functions and Indexes using T-SQL.
Experience working with Database Backups and restoration.
Created scheduling jobs with SQL Agent.
Designed and developed ETL process using SSIS to load data from various sources like Oracle, excel, CSV files, and MS Access into SQL Server 2016, 2008 R2/ databases.
Created SSIS packages using Conditional Split, Aggregate, Merge, Multicast, Term extraction Data Conversion, Fuzzy Lookup, Pivot, Lookup.
Created SSIS packages with Error handling, notifications and package configurations.
Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
Managed Error handling, logging using Event Handlers in SSIS.
Experienced in developing Power BI reports and dashboards from various Data Sources like Cube, Databases, and Excel files.
Used Power BI to prepare dashboards to create attractive visualizations.
Experience in Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Table, Matrix, Chart and Sub Reports.
Have clear understanding of data warehousing Modelling like Star schema, Snowflake schema.
Have clear understanding of data warehousing Concepts and OLTP, OLAP system.
Very good knowledge of Informatica Power Center 9.5 such as Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer.
Excellent communication and interpersonal skills, very good team player and self-starter with ability to work independently and as part of a team, strong effort, time management, good analytical reasoning and high adaptability to new technologies and tools.
Client : Customer portfolio, Boston, MA May-2018 - Present
Role : SQL/BI Developer
Customer portfolio provides marketing and analytical services for our client. CP Builds customer data platform that helps to grow our client businesses. CP builds Data Warehouse platform using Microsoft SQL BI Technology.
Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
Created SSIS Packages to load data from sources like Flat files, excel, OLEDB, XML, and Oracle to SQL Server.
Worked with various control flow items like For-Each Loop Container, Script task, Execute SQL task, Send Mail Task as per business requirement.
Created SSIS packages using Conditional Split, Aggregate, Merge, Multicast, Term extraction Data Conversion, Fuzzy Lookup, Lookup.
Created SSIS packages with log files such as XML, Text file and SQL server Table.
Created complex SQL stored procedures using Microsoft SQL Server 2012/2014/2016.
Created/Updated database objects like tables, views, stored procedures, function, packages.
Developed and delivered dynamic reporting solutions using MS SQL Server Reporting Services (SSRS).
Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
Involved in development and deployment of the Cube.(SSAS)
Responsible for working on Facts and dimensions of the Cube.(SSAS)
Environment: SQL Server 2016, MS SQL Integration Services (SSIS), MS SQL Reporting Services (SSRS), MS SQL Analysis Services (SSAS), SQL Profiler, SQL Agent, MS Excel, Team Foundation Server (TFS)
Client : American Airlines, Tulsa, OK Jan-2017 - Apr-2018
Role : SQL/BI Developer
American Airlines, Inc. operates as a network air carrier. The company provides scheduled air transportation services for passengers and cargo. The company operates hubs in Charlotte, Chicago, Dallas/Fort Worth, London Heathrow, Los Angeles, Miami, New York, Philadelphia, and Phoenix, as well as in Washington, D.C.
Worked on SQL Server Integration Services to integrate and analyze data from multiple source file like XML, CSV, MS Excel, SQL Server.
Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling of the packages.
Troubleshoot of various SSIS packages and its performance tuning, implemented failure alerts using in SSIS.
Wrote complex SQL queries to populate data from different tables.
Created Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
Created Parameterized and cascading Parameterized reports. (Single parameter and multiple parameters)
Created Drill down, Drill through, sub report, linked reports and modified its properties as per business requirements.
Documented the developed work and production release for future reference.
Environment: SQL Server 2012/2016, MS SQL Integration Services (SSIS), and MS SQL Reporting Services (SSRS), MS Excel, And MS Access.
Client : Web Code Genie (India) May-2013 - Nov-2014
Role : Jr. SQL Developer
Web Code Genie is a leading web design company offering high quality web and eCommerce solutions that are delivered on the dot and well within your budget. Our wide range of IT services include web development, Web design, ecommerce solutions, Internet marketing, and corporate branding with dedicated professionals in each segment.
Created Database objects using SSMS graphical methods and advanced T-SQL Statements.
Created databases objects like tables, views, indexes and stored procedures.
Created views, SQL joins DTS packages and statements for applications.
Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
Responsible for Query Performance tuning and Optimization.
ETL packages are created to extract, transform and load data to data ware house using SSIS.
Created documentation as required.
Created SSIS package to get data from different sources, consolidate and merge into one single source.
Environment: SQL Server 2008, MS Excel, MS SQL Integration Services (SSIS)
Company : Concept Creator (India) May-2012 - Apr-2013
Role : Jr. SQL Developer
Maintaining SQL Database.
Created Tables, Views & SQL Join statements for various applications.
Created Stored Procedures, Functions, and Indexes.
Used DDL and DML command to write stored procedure for the different data requirement.
Created SSIS packages and applied transformation to cleanse data.
Created SSIS package to extract data from CVS and excel files.
Involved creating data warehouse with data modeling team using start schema.
Environment: SQL Server 2008, MS Excel, MS SQL Integration Services (SSIS)
EDUCATIONAL BACKGROUND
Master in Computer Science from Virginia International University- 2016 (Virginia, USA)
Bachelor of Computer Application- 2012 (India)
TECHNICAL SKILLS
ETL Tools: SQL Server Integration Service (SSIS), Visual Studio 2010, 2012, 2013, 2015
Informatica Power Center 9.5/9.6
Reporting Tools: SQL Server Reporting Services (SSRS), Power BI, MS Access, MS Excel
Databases: SQL Server 2016/14/12/08, Oracle 11g/x, MS Access 2000
Scheduling Tool: SQL Agent
Platform: Windows Server
Languages: SQL, T-SQL, C#, HTML
Contact this candidate