Dibinbabu Johnson George

 CAREER OBJECTIVE To acquire a challenging career with an established company utilizing the opportunity to offer proven and developing skills within the company and in turn ensuring personal growth within the organization. I believe that my technical, functional and communication skills will enable me in facing the challenging career ahead. CAREER HIGHLIGHTS Software Engineer with 5 years experience in Sql Server and Business Intelligence technologies such as SSIS, SSAS, Qlikview and Powerpivot. Expert in Front End UI implementation in technologies such as HTML5, CSS, Javascript, Jquery. Newsletter coding in HTML that is responsive across multiple devices and email clients. Proficient in MySQL and Cpanel/PhpMyAdmin Proficient in using SSIS to create ETL packages. Proficient in writing SQL Stored procedures, triggers, views and functions. Well versed in database modelling concepts. Worked on multidimensional databases. Hands on in writing MDX queries. Hands on experience in reporting using ASP.net. Proficient in all aspects of Software Development Life Cycle (SDLC) Good team player with excellent interpersonal skills. Precise in documentation of software information. SUMMARY 5 years of experience in implementing and deploying SSIS 2008, 2012 packages and implementing database solutions using SQL Server 2008, 2012. Developing SQL scripts (stored procedures, triggers, functions, database scripts) to implement business logic and assist in database maintenance. Experience in creating SSRS reports in tandem with Office Writer for Excel. Using SSIS tasks such as Execute SQL task, lookup task, data conversion task, data flow task, XML source task, merge and merge join. Expertise in forming MDX queries. Experience in creating and deploying olap cubes in Microsoft SSAS. Good experience in working on production environment. Good problem solving skills and interpersonal skills. Ability to work independently and efficiently, managing timelines and expectations. Excellent team player with good analytical, trouble shooting, and communication skills. PROFESSIONAL DETAILS Current Employer: Freelancer Previous Employers: Cybage Software, Accenture Services Pvt Ltd., Total Experience: 4.5 years TECHNICAL SKILLS SQL Server Management Studio 2008, 2012. HTML5, CSS, Javascript, Jquery PHP, MySQL Newsletter coding in HTML SQL Server Integration Services (2008,2012) SQL Server Analysis Services (2012) SQL Server Reporting Services (2008) Operating Syatems: Windows 7, Server 2008, 2000. ASP.Net reporting (Charts) IIS 7.0 PROFESSIONAL EXPERIENCE 06/2017 - Till present Employer: Freelancer Role: Handling multiple projects on PSD to HTML, Wordpress, PHP, MySQL. Description: I am curently working as a freelance IT Consultant mostly working on PSD to HTML, Wordpress and PHP/Mysql work. I prefer getting a design already done by a professional designer which I can code as web pages. I am also highly experienced in Email newsletter implementation which is responsive across multiple email clients such as Gmail, Outlook. 06/2015 - 06/2017 Employer: Accenture Services Pvt. Ltd. Role: Software Engineering Analyst Project: HR Reporting & Analytics Project description: Human Resource Reporting & Analytics is Accenture’s Internal project that deals with reporting of organization’s Employee Roster, Resource Availability, Demand/Role Details, Attrition reports, skills match/mismatch reports etc. to the Accenture HR Business. These reports enable the business to understand the trend in number of resources who are currently available or will be coming available shortly for new projects, the new demands/roles that are created accross Accenture and to match demand vs the availability. Attrition reports give the business an idea regarding the latest trend in attrition of employees and then to take corrective decisions if required. Responsibilities handled: Implementation/Maintainance of SSIS ETL packages required for business reporting across different subject areas like Employee, Attrition, Productivity, Supply Demand etc. Worked on creating the Technical design and Field mapping designs of ETL packages. Implementation/maintenance of SSRS reports that is done using Office Writer. Analyzing incidents/data issues reported by different stakeholders and working alongwith other teams inorder to take issues to closure. Impact Analysis of different upstream releases. Batch processing activities like daily ETL job monitoring, Subscriptions monitoring and daily status reporting. Worked on automation of a daily dashboard that summarizes the status of all the daily jobs that are required for the team. This is implemented by using ASP.NET. This tool has the intelligence of showing success/running/failed status dynamically using CSS properties. 05/2014 - 03/2015 Employer: Cybage Software Pvt. Ltd. SSIS, SQL Developer Project: Isobar Feeds Project Descriptions: Isobar is a global digital marketing network. Clients such as Adidas, Reebok give their product specifications to isobar, for serving ads on sites like Google. For this, import packages are designed and implemented for isobar clients such as Adidas, Apple etc. and export packages are implemented for vendors such as Google. Responsibilities: Create SSIS packages to import data from client feed to isobar database. Cleansing of data in stage table. Creating export packages in SSIS to export data according to the specifications of vendors such as Google. Creating stored procedures, functions to support business logic. Using advanced SQL scripts such as CTE, using temporary tables, table variables, cursors. 06/2013 – 04/2014 Employer: Cybage Software Pvt. Ltd. BI Developer, Asp.net UI Developer Project: Teletalk by Telecommunications Ltd. Project Description: Performance Monitoring Tool (PMT) aka TeleTalk gets performance based measures from various sources and are integrated into a single data warehouse (SQL Server) using SSIS. These data are then used for calculations that provide insights regarding the performance of various networks (NSN, Alcatel, Huawei etc.) The measures are viewed from the angle of different dimensions like BSC, BTS, BTSM etc. Dashboards are created to view all the important data at a single place. SSAS was used for the analysis of the data. Finally, asp.net was used for creating the website where users could view the different KPIs (several telecom measures). Responibilities: Creation of SSIS packages to import data from different formats to the database. Creation of cubes for Huawei modules in SSAS. Design of MDX Queries required for generation of reports. Creation of KPIs for NSN (Nokia Solutions Network), Huawei and Alcatel modules based on KPI document provided by client. Designed and implemented Formula Generator Tool for NSN, Huawei and ASB. Creation of stored procedures required for UI development. Deployement of Cube and UI (on IIS 7.0). 01/2013 – 05/2013 Employer: Cybage Software Pvt. Ltd. BI Developer Project: Mobistat By Global Wireless Solutions Inc. Project Description: Implementing OLAP approach for generating reports that earlier used Stored procedures and re-designing the UI as per the new approach. Responsibilities: Worked on SSIS packages for data import. Modifying the existing database to create dimensions and adding references in existing fact tables. Here, the aim was to move the data to a multidimensional cube. Earlier, the reports were running using stored procedures. The new approach needed all the logic in stored procedures to be re written in MDX. Creation and deployement of cubes on the development as well as production environment. Redesigning UI in asp.net 4.0 and generating charts using MDX queries. Done RCA (Root Cause Analysis) for several issues during Production support while in the maintainace period. 07/2012 – 12/2012 Employer: Cybage Software Pvt. Ltd. ETL Developer Project: Knowledge Networks Project Description: I was working for Knowledge Networks for their Data Migration process. Existing database was in Oracle which was migrated to SQL Server. Also used SQL Server Migration Assistant for data archival. Responsibilities: ETL tool (SSIS) used to design and develop mapping for extracting, cleansing, transforming, integrating and loading data into different target. Developed logic in Mappings, used fuzzy logic, lookup and other complex transformations. Detailed documentation of all packages/enhancements to assist other team members in efficiently supporting the applications. Used SQL Server Migration Assistant for archival of existing data in Oracle. ACADEMIC BACKGROUND B.Tech in Computer Science & Engineering from College Of Engineering, Trivandrum with 67% Passed 12th with 90.5% Passed 10th with 89.28% PERSONAL DETAILS: Name: Dibinbabu Johnson George Date of Birth/Age: 25th April, 1989/25 Years Father’s Name: Johnson K George Mother’s Name: Daisy Johnson Present Address: B-11, Anand Vihar Near Sardar Park, G.I.D.C, Ankleshwar, Gujarat