More Related Content
What's hot (20)
Viewers also liked (17)
Similar to CV of Shemil Mohan (20)
CV of Shemil Mohan
- 1. SHEMIL MOHAN Mobile: +971 50 214 9342 ♦ E-Mail: shemil85@yahoo.com /shemil85@gmail.com Address: 505, Al Amri Apts, Mankhool, Bur Dubai LinkedIn URL: https://ae.linkedin.com/pub/shemil-mohan/56/175/22b BUSINESS INTELLIGENCE DEVELOPER A qualified Technocrat and seasoned IT Professional, having over 6 years of rich and insightful experience of working in India and UAE. Proven expertise in the full BI development lifecycle – from concept through delivery of user reports and packages; skilled in advanced development methodologies, tools and processes contributing to the design and rollout of cutting-edge BI solutions. SPECIAL MENTION ~ Strong Knowledge of Microsoft Databases and Tools (Design, Development, SSRS, SSIS and Version Control) ~ ~ Delivered multiple Projects for Development/Design/and Remote Services of BI Applications with high Client Satisfaction ~ ~ Experienced with Multiple Projects, Phased Deliverables, Project Planning, Requirements gathering and testing of deliverables ~ ~ Lead teams, Design and Develop modules, Perform functional and code review and develop test strategies/procedures ~ Functional Competencies Technical Competencies  Solution/Product Development  Project Delivery Management  Remote Application Support  MS-SQL Business Intelligence  Requirement Study/Analysis  Development Life Cycle  Team & People Management  Methodologies: Object Oriented Design and Development  Operating System: Windows  Languages: C#, SQL, T-SQL, VB.Net, JavaScript, HTML  Database: MS SQL 2000/2005/2008/2008R2  Design Tool: MS Visio  BI Tools: SSRS, SSIS, SSAS (Basics), Crystal Reports XI  Version Tool: VSS, TFS QUALIFIC AT ION Education:  MCA, from Pune University, Maharashtra (2009) with 62% PERSONAL DOSSIER  Date of birth: 18-Jun-1985  Languages known: English, Hindi, Malayalam, Marathi  Location Preference: Dubai  Nationality: Indian  Passport No: L6517137 (valid till 25-Dec-2023)  UAE Visa Status: Resident Visa  Driving License: Applied for UAE driving license. EXPER IENC E SNAPSHOT NewBoy FZCO, Dubai Reports Developer (Dec 2013 till date) Deliverables:  Reporting to Senior Manager and was the sole resource for developing and providing all the reporting needs of the users for a year.  Managing, analyze & understand business requirement and develop program/functional specifications, solution Page 1 of 3
- 2. design, code review and functional review of deliverables.  Responsible for all steps of development life cycle as well as provide documentation in each step as well as technical guidance to team.  Providing reusable code library for organization productivity gain and proactive suggestions to increase productivity.  Monitoring all the restoration jobs of the databases on the production server and maintaining it to keep the server up and running all the time. Hexaware Technologies Ltd., Mumbai, India Software Engineer (Apr 2010 to Oct 2013) Deliverables:  Reported to the Project Manager and led a team of 6 resources in offshore for a client Ernst & Young.  Responsible for development & support of data integration of Cloud hosted SharePoint portal, an Auditing tool used by more than 50,000 auditors across the globe and development of Journal Entry tool for Global Analytics.  Involved in integration of CRM data from all geographies, merged with global finance and HR data and generated reports to view global sales and pipeline data.  Performed daily team administration routines as well as team development and people management activities for improvement of team productivity.  Attend client calls and meetings to discuss requirements and solutions as required by the end user.  Maintain standards of all the deliverables and do testing of all the developments done by the peers. PREVIOUS ASSIGNMENT S ∼ RAUN GROUP, MUMBAI as Web Application Developer (Nov 2009 to Apr 2010) ∼ MILLENNIUM GROUP, MUMBAI as Management Trainee (Oct 2009 to Nov 2009) ∼ ZENITH INFOTECH , MUMBAI as Associate Consultant (May 2009 to Oct 2009) PR OJECT DET AILS Client NewBoy FZCO, Dubai Role Reports Developer Environment MSBI, Crystal Report XI,SQL Server 2008 R2 Project NewBoy BI Development & Support Responsibilities• Maintenance and development of reports in SSRS and Crystal Reports • Perform DBA activities like database restoration, backup and scheduling jobs. • Requirement Gathering and Technical Analysis • Deploy reports and provide user level security to the reports. • Create SSIS packages and offline jobs for certain reporting requirements. • Code and Functional Review of Deliverables Client Ernst & Young, USA. Role Development Team Lead Environment SQL, SSRS and Crystal Reports Projects ARMS for Ernst & Young Details ARMS is an Account Resource Management System tool for Ernst & Young. It is used to manage the resources on E&Y and allocate them to different projects accordingly. The reports for this application were earlier developed in Crystal Reports and they wanted to migrate all these reports in SSRS. Responsibilities• Worked in core migration of the Crystal Reports to SSRS. • Lead a team of 6 members and review their work on daily basis. • Perform peer testing of all the developments before doing the deployment. • Review of analysis and deliverables. • Daily and weekly reporting to client. Page 2 of 3
- 3. Projects Account Team Sites for Ernst &Young Details Account Team Site is a SharePoint website. Microsoft is contracted to build this website and host on Microsoft cloud (Office365). The team was responsible for data integration. Based on client’s business requirement and Microsoft’s technical requirement we built ATS data store. This data store fetches relevant data from various systems within client premises, consolidate and expose to Microsoft cloud using WCF service. Responsibilities• Understand the requirement by discussing with Project Lead. • Create SSIS packages to create the data stores as required by Microsoft. • Providing technology guidance to team • Daily and weekly reporting to client Projects CRM Reporting Details The client is a major Financial Institute in USA. For CRM module the Client had a set of reports which was developed using SSRS as reporting tool. We had to generate reports for the products sold by the call center agents and representatives for various clients. They also had a requirement of creating SSIS packages to migrate data from Excel, Notepad to the SQL Server 2005/2008 database and vice versa. Responsibilities• Responsibilities were to analyze work orders assigned to me, design technical documents, query logs, impact analysis document and get them approved from the clients/on-site coordinator before getting into the actual development. • Design implementation plans and write Stored Procedure. • Create SSIS packages like export data to excel file from the clients/on-site coordinator before getting into the actual development. • Create SSRS reports like drill-down reports, sub-reports, linked reports and charts. • Client Communication, Meetings, Calls and mailing WSR. • Coordinating with DBA’s at the client side for all deployments and issues. Projects Proof of Concept (PoC) on Hadoop Details To understand the concept of Hadoop and its capabilities as compared to SQL Server and MySql in terms of processing data. To identify the necessary requirements that is required to setup Hadoop and its limitations. Responsibilities• Understand the concept of Hadoop and its benefits as compared to SQL Server and MySql. • To download the pre-requisites and installing them on the machines for setting up Hadoop environment. • To make MySql queries and its equivalent query in Hive (RDBMS for Hadoop) and run them to make the observations. Projects Payroll System Details To develop the Payroll System for the organization so as to streamline the payroll process of the employees within the organization. Responsibilities• Understand the requirements and create documents mentioning the same. • Develop stored procedures and queries to help retrieve the appropriate data for the payroll system. • Write HTML code for designing User Interface and create Style Sheets (CSS). Page 3 of 3