Mohit Sehgal

Contact No.: +91-987*******

Email Id: adcrt2@r.postjobfree.com

Professional Summary - MSBI Developer:

8+ years of experience as Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments

Strong Communication & Management skills with Excellent Role playing capabilities.

Expertise in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) SQL Server Development, crystal reports

Visited onsite location Singapore to gather the requirements from client.

Having knowledge on PowerBI concepts and tool as well.

Having knowledge on data warehousing concepts.

Having knowledge on asp.net with c#.

Having knowledge on SharePoint integration with ssrs as well.

Always keen to learn new technologies and ability to adjust in any environment, which is sign of good team player.

Having knowledge on tableau with working expertise in it.

Expert skills in writing complex SQL queries and designing BI/ETL (Extract, Transform and Load) solutions experience with SQL Server 2005, 2008, 2008R2 with a focus on SQL Server Integration Services (SSIS)

Having complete life cycle knowledge of SSRS and SSIS.

Developed many Tablix Reports, Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).

Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.

Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.

Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages.

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS.

Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.

Expertise in generating reports using SQL Server Reporting Services, Crystal Reports

Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.

Ability to work independently as well as work with teams having

Varying backgrounds on complex issues and have strong verbal and

Communication skills.

Experience Summary:

Working as a team lead in NEC group from May 2018 to till date.

Working as a Senior BI Engineer with Admiral Technologies (Insurance domain) from June 2015 to May 2018

Worked as a Senior BI Engineer and Analytics with Accretive health services (health care domain) from October 2014 to Jun 2015

Worked as Senior Engineer with HCL technologies from Dec 2012 to Oct 2014

Education Qualifications:

MCA from G.B.T. University (Lucknow) in 2008-2011 with 76%

BCA from B.R.A University (Agra) in 2005-2008 with 72.3%

Passed 10+2 from U.P Board(Agra) in 2005 with 68.6%

Software Exposure:

Technologies : SSIS, SSRS, SharePoint, C#, tableau, HTML, ASP.net, ADO.Net, Web Services, JavaScript, SQL Server 2012/2017, Sql Server 2008, tableau, c#, oracle, JIRA, SVN, ORACLE-12C, crystal reports

Tools Used : Visual Studio 2012, Crystal Reports, Firebug, MS SQL Server Management Studio 2012, MS SharePoint Designer 2010, MS SharePoint Central Administrator 2010, MS Product Studio, SQL Server Reporting Services(SSRS), SQL Server Integration Services (SSIS), MS InfoPath 2010, TFS, Red gate, tableau, XML, XSL, SharePoint

Project Summary:

Project Name : SRPT (Standardization of Remittance Project)

Details : This project is to standardize both overseas remittance system platform and operation workflow in APAC region. To promote Transaction Banking business as an Initiative of Asia-CFT through achieving more STP and operational efficiency promotion. To develop new centralized overseas remittance system with new functions (e.g. STP (Straight Through Processing) for outward transactions and paper-less workflow)

Environment: SSRS, SSIS, SVN SQL Server, Oracle,c#

Roles & Responsibilities:

Involved in analysis of requirements received from clients and provide input wherever it is applicable.

Created SSRS reports and wrote many pl/sql queries according to the requirements.

Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.

Managing and supporting report team for every phases of report development/deployment.

Created application on asp.net and integrate with ssrs

Project Name : Compare.com

Details : Compare.com, a car insurance comparison site, delivers multiple car insurance quotes from trusted auto insurance brands and allows drivers to find the best value according to their needs. Compare.com allows drivers to customize their auto insurance policy using a single online form guiding them through the process the entire time – and immediately returns multiple accurate, personalized quotes from licensed auto insurance companies.

Environment : SQL Server 2005 and SQL server 2008, DTS, SSIS, Import/Export tools, SQL Server Agent, MS Access, T-SQL, Red gate, SVN, JIRA,c#,asp.net, SharePoint

Roles & Responsibilities:

Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.

Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Provided support on Data Warehouse ETL design, and their development.

Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.

Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.

The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.

Worked on asp.net project and created resuable code as well

Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.

Client Name : US Clients

Team Size : 30

Project Name : Ahto-Analytics / RCM

Details : This project is a complete reporting solution project and health care domain.

Revenue cycle management service offering helps U.S. healthcare providers to more efficiently manage their revenue cycles, which encompass patient registration, insurance and benefit verification, medical treatment documentation and coding, bill preparation and collections, Patient Satisfaction.

Environment : SQL Server 2005 and SQL server 2008, DTS, SSIS, Import/Export tools, SQL Server Agent, MS Access, T-SQL, Red gate, SVN, JIRA

Roles & Responsibilities:

• Involved in gathering the user requirements.

• Created stored procedures, triggers, Joins, functions and views.

• Created SQL server Reports using SSRS 2008.

• Created Cross-Tab, Drill-down, Drill-down and Sub-Report using and linked reports using SQL SERVER Reporting Services.

• Identified the data source and defining them to build the data source views.

• Debugging reports and deploying reports.

• Involved in SSRS report deployment and report server configuration.

• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.

• Scheduled the reports to run automatically.

• Created schedules and subscriptions.

• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet

• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring during execution

• Created SSIS packages to migrate data from Oracle DB to SQL Server 2008.

• Designed and implemented stored procedures and triggers for automating tasks.

Client Name : Microsoft, Redmond (USA)

Team Size : 25

Project Name : CXPBP

Details : CXPBP is a complete reporting solution, where Microsoft’s managers view/analyze their business data Data Sources used are SharePoint, Excel, SQL Server, Access etc. Reports are hosted in SharePoint 2010 environment. Workflows and InfoPath have been extensively used in SharePoint 2010 site. Custom code has been used to provide add on functionality like On Demand Execution of SSIS Job, Auto-Complete in Search etc.

Environment : SharePoint (Web Parts, Lists and workflows), SSRS, SSIS

Roles & Responsibilities:

Creation of complex SSRS reports, complex SSIS packages (ETL). Creation of SharePoint lists, Customization of InfoPath forms.

Responsible for getting, understanding the business specs, preparing technical Specs, DTS Packages.

Responsible for creating appropriate loaders and relational writes to load the Data from SSIS. Creating jobs for scheduling the SSIS packages. Getting data from different data sources.

Using different transformations like excel source, data conversions, lookup, OLEDB command, derived columns, OLEDB destination, etc. Loading these data into data warehouse like sql server.

Client Name : Microsoft, Redmond (USA)

Team Size : 10

Project Name : Fort System

Details : This is one of Microsoft project where all online transactions related to their partners are handled and apply decision on all transactions for accept or reject the transactions.

Environment SharePoint (Web parts, Lists and workflows), SSRS, SSIS, C#, SqlServer

Roles & Responsibilities:

Analysing the requirements and design documents and

Understanding the functionality of both source and target systems.

Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Union-All, Merge, Merge Join and Derived Column. Created systems for capturing error data in flat file using flat file destination, sending the error data in flat file attached to the corresponding mail ids using Sent Mail Task, and correcting error data.

Created Jobs and implemented it, Reconciliation across various source systems. Responsible for creating appropriate loaders and relational writes to load the Data from SSIS.

Identifying the bottlenecks (in sources, targets, and packages) and tuning it. Created Complex reports for the end user delivery purpose.

Understanding the functionality of both source and target systems.

Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Union-All, Merge, Merge Join and Derived Column.

Created systems for capturing error data in flat file using flat file destination, sending the error data in flat file attached to the corresponding mail ids using Sent Mail Task, and correcting error data.

Created Jobs and implemented it, Reconciliation across various source systems. Responsible for creating appropriate loaders and relational writes to load the Data from SSIS.

Identifying the bottlenecks (in sources, targets, and packages) and tuning it. Created Complex reports for the end user delivery purpose.

Client Name : Microsoft, Redmond (USA)

Team Size : 12

Personal Profile:

Name : Mohit Sehgal

Date of Birth : 9 Jan 1988

Address : Pratap nagar, Delhi

Father’s name : Mr. Raman Sehgal

Gender : Male

Marital Status : Single

Mohit Sehgal

Contact this candidate