Data Entry Ssis

Sandeep Mishra ***********.******@*****.*** +91-996*******

Decisive, action-oriented and result-focused professional offering 13 year of information technology experience in:

●Strategic Planning: Formulated communicated and implemented sound disciplined strategies and focused on providing real value to internal and external customer.

●Innovation Solution Design: Empower terms of fuel ingenuity “Never give up” attitude and focus on business communication to truly understand long-terms needs and future technology uses.

●Global team leadership: Assembled and led high-energy team spanning and global culture, directing collaborative initiative, setting firm expectation and delivering on commitments.

Operating Systems : windows 10

Databases : MS SQL Server, MS Access

ETL Tools : SSIS, Azure ADF

Reporting Tools : SSRS, MS Power BI, Crystal Report

OLAP Tools : SSAS

Other : VBA Macros, VB6.0, C# ( SSIS Script), TFS, GIT, Agile, On Call

CAPGEMINI, Mumbai June 2021 –June 2022

MSBI Specialist

Project name:- TransAmerica

Project Description: TranAmerica project taking data from multiple source and generating report in Power BI & excel using SQL Agent jobs. Creating new pipeline using Azure ADF.

●Creating new SSIS,

●Creating New MS Power BI Report

●Creating New Pipeline Using Azure ADF.

●Modifying existing SSIS, SQL Script, ADF and POWER BI

●Deployment of SSIS, POWER BI in higher environment.

●Handling release management on QA, UAT and Prod environment.

NESS, Mumbai June 2020 –May 2021

MSBI Specialist

Project name:- Rovi Video

Project Description: Rovi Video project involves regionals wise collecting data from multiple source and creating CSV files, converting in zip and stored in FTP location . Each zip file size is minimum 5 GB and maximum 400 GB.

Another process where same zip file copied from FTP to servers and unzip all files in respective folder and stored data in SQL server database. System is keeping last 10 days data.

Created multidimension cubes for business to analyze data in excel and tabular cubes used in Power BI reports.

Created multiple Power BI reports helps you build different charts and graphs to visualize the data

●CO-ordination with Onsite for requirement gathering.

●Creating new SSIS,SSAS, POWER BI

●Modifying existing SSIS, and flow. SSAS, POWER BI

●Deployment of SSIS, SSAS, POWER BI in higher environment.

CAPGEMINI, Mumbai Nov 2010 – June-2020

Project Manager

Managed offshore development team of 10 for MSBI (SSIS, SSRS,SSAS) and SQL server (T-SQL, Store procedure, trigger, function), MDM, VBA

Project name:- Party Reference Data

Project Description: Party Projects involves phase wise mastering all the Organization & Individual data into newly modeled Party domain. As part of this project information is being retrieved from all the different legacy source systems into one common data store which then serves as source to Master. All the records from this data store is then send to for validation/Cleansing to third party vendor

Except from Party domain, Data from Reference Files (for various domains) placed on File Share Server are loaded at a scheduled time (Insert/Update) into staging tables using the defined business logic and eventually loaded in MDS as Master/Reference data. Data from MDS, incrementally extracted and loaded into WillisReference (SCD logic) and made available to different APIs.

Created Multidimensional Model Cubes and Tabular Cubes for business to analyze data in excel and tabular cubes used in Power BI reports.

Business user is able to see data in one place and they analysis and below advantage are given:-

Data warehouse allows business users to quickly access critical data from some sources all in one place.

Data warehouse provides consistent information on various cross-functional activities. It is also supporting ad-hoc reporting and query.

Data Warehouse helps to integrate many sources of data to reduce stress on the production system.

Data warehouse helps to reduce total turnaround time for analysis and reporting.

Created multiple Power BI reports helps you build different charts and graphs to visualize the data

●CO-ordination with Onsite for requirement gathering and offshore team.

●Creating new SSIS, SSRS, SSAS, Power BI

●Creation of New Entity, Attribute and Business rules in MDS

●Deployment of MDS, SSIS and SSRS elements in higher environment

Project name: - GBClaims

Project Description: ERL Application is used by CL&R, MetLife Sales Force and MetLife Sales Offices for Data Entry and enquiry purpose.

●CO-ordination with Onsite and offshore team.

●Successfully designed process and created templates to be followed by each team member

●Designed & modified SSIS packages and SSRS reports as per business requirements.

●Re-designed existing SSIS package & SSRS report to optimization the process.

●Writing procedures, functions, cursors, triggers.

●Creation of Technical Documentation related to the tasks.

●Gathering requirement from business.

●Successfully analyzed business requirements and created effort estimation based on the function points.

●Work distribution to team member and ensured that work completed as per requirement.

Project name: - INSPRO

Project Description: It was a conversion project. We have converted mainframe to SQL server.

●Successfully designed process and created templates to be followed by each team member.

●Designed reporting database to be used to generate reports.

●Successfully analyzed business requirements and created effort estimation based on the function points.

●Allocated tasks to team members.

●Designed SSIS packages which act as interfaces between mainframe system and INSPRO system.

●Created technical design document, unit test cases and deployment checklist.

●Performed peer and peer to peer review of the packages created.

●CO-ordination with Mainframe team.

●Technically helping to team.

MILES SOFTWARE, Mumbai Nov 2007 – Oct 2010

Senior Software Engineer

Managed 4 members technical team through all project cycle, including requirement gathering/ analysis, solution designs, development and implementation. Managed communication with business users.

Project name: - SRGELT/PAS (Moneyware Integra)

Project Description: - It's a Back office system which consist trading in modules like Equity, Derivatives (Options, Futures), Bond and SLB

●Handling entire development task single handedly, where the entire development is done in VB 6.0 using SQL server 2000 as database.

●Designing Reports using Crystal reports.

●Taking support calls from User and IT Head and providing solutions.

●Coordinating with Users, IT Head and Project manager for development of new requirements and issues encountered by users.

EDUCATION

●Master Of Business Administration (MBA) from SMU

●Bachelor of Commerce from Mumbai University

CREDENTIALS

●Successfully completed One Year Diploma in Software Engineering from NIIT.

SELECTED TECHNICAL PROFILE

Operating system : Windows Prof 2000, XP, Windows Server 2008, Windows 2007

Language : Vb 6.0. C#, Asp.net, Crystal Reports 8.5/9.0.

RDBMS: MS Access, SQL Server, SSIS, SSRS

Operating System: WINDOWS.

Tools : SQL Server, Toad

Databasees worked on : SQL Server 2000, SQL Server 2005, SQL Server 2008, Oracle,DB2 UDB

Domains or Industries : Finance (Equity, Derivatives, Mutual Fund), Insurance

PERSONAL INFORMATION

Father’s name : Mr. Ramadhar Prasad Sharma.

Date of Birth : July 1st 1979

Nationality : Indian

Sex : Male.

Marital Status : Married.

Hobbies : Listening music, playing and watching cricket, like to

Make new friends.

Languages : English, Marathi and Hindi.

Total Experience in IT : 13 Yrs +

Last Working Date : 1st July 2022

Contact this candidate