• Gender: Male
• Age: 46
• Designation: MSBI Specialist
• Highest Education Level: Masters - Degree
• Notice Period: 30  Days
• Preferred Location: Mumbai
• Work Experience: 17.6 Year(s)

Education

Master Of Business Administration (MBA) from SMU
Bachelor of Commerce from Mumbai University

Skill Sets

Successfully completed One Year Diploma in Software Engineering from NIIT.

Work Experience

MSBI Specialist
From June 2020 –Till Now
Company profile- Digital Engineering provides information on our opportunities around the glob

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 multi dimension 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.

Project Manager
From Nov 2010 – June-2020

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 Willis Reference (SCD logic) and made available to different APIs.

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.

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

MILES SOFTWARE, LOWER PAREL 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 (Money-ware 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.

Decisive, action-oriented and result-focused professional offering 10 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.