Mohit

Professional Summary: MSBI Developer

·      8+ years of professional experience in all phases of software development life cycle (SDLC) including requirement gathering, analysis, system design, development, integration, production support and maintenance of various Reporting and ETL Activities.

·      Strong Communication & Management skills with Excellent Role playing capabilities.

·      Expertise in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Development.

·      Having experience in asp.net with C#.

·      Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, SQL Server Agent Job.

·      Having good experience in MS tools like Microsoft word, Microsoft Excel and Microsoft PowerPoint.

·      Experience in using database like SQL server, ORACLE database tables, stored procedures, functions and triggers.

·      Expertise in creating TABLEAU and power BI dashboards reports.

·      Visited onsite location- Singapore from Current Organization to gather the Project Requirement and Enhancements in the Project accordingly.

·      Experience of tools like SVN, GIT, TFS etc.

·      Worked on Microsoft Azure SQL Database (Cloud) and create reports accordingly.

·      Experience of customer handling & communication during project development (Verbal and Written)

·      Experience of analyzing requirements/RFPs and providing estimations and timelines based on project scope.

·      Serious involvement with business analysis and architect in project designing.

·      Experience of creating software design specification documents.

·      Adept in end-to-end implementation of the SDLC; including finalization of specifications, design, development.

·      Proficient at grasping new technical concepts quickly and utilizing the same in a productive manner.

·      Provides training to fresher’s/juniors.

·      Have worked on 24*7 Environment and provided support to my team members accordingly.

1. Project :  SRPT (Standardization of Remittance Project)

                                             May 18 – Till Date

Description: 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)

 Responsibilities:               

·      Created various SSRS report with integration of Oracle and SQL SERVER.

·      Involved in data migration from Flat files/Excel files etc. to our local system by using ET tool.

·        Customer communication and requirement gathering.

·        Serious involvement with business analysis and architect in project designing.

·        Involved in full life cycle implementation, which includes Gap Analysis, Requirements Gathering, Development, Testing, Reporting, Go-live and Reconciliation.

·        Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.

·        Created C# custom code in asp.net application.

·        Peer code review and code merge.

·        Participating in system integration, debugging and troubleshooting of the application..

Environment: SSRS, SSIS, TFS SQL Server, JIRA, Oracle, C#, tableau

2. Project : Compare.com

Jun 15 – May 18                                                  

Description: 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.records.

Responsibilities:

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

·        Created various SSRS reports TABLEAU reports depending upon project requirement accordingly.

·        Created ad-hoc power BI for ad-hoc requirements from client.

·        Handled Performance Tuning and Optimization on SSIS / SSRS / SQLSERVER 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.

·