Chittaranjan Dass Gandhi

Name : Chittaranjan Dass Gandhi E-mail : -Contact : - CAREER SUMMARY: Business Intelligence and Analytics, Quality Champion, Process re-engineering, US Healthcare To navigate in line with the growing firm which can unravel the latest technologies and which can utilize my potential to the maximum and keep me sound in my professional career. Went On-Site to United states of America for Product activation and Client support, obtained B1 visa for 10 years (2020). Went On-Site to South Australia (South Australia Health - Adelaide) & Singapore (Parkway Hospital) for giving knowledge transfer and trained Clients regarding the Products and Reports. Professional Experience Summary : Around 8+ years of extensive experience in Data warehousing and Business Intelligence technologies along with strong experience of data visualization using Tableau and close to 11+ years of overall IT experience. EXPERIENCE AND QUALIFICATIONS: “Business Systems Advisor” in NTT Data Services (formerly Dell Services), Bangalore, since Feb, 2016. TECHNICAL SUMMARY: Tableau 10,SQL Server 2008R2, SQL Profiler,SSRS,SSIS, Crystal reports 2008, Info view scheduler, MYSQL,Automate BPA, MS Office Suite and Data Archival. HEALTHCARE APPLICATIONS:Allscripts Touchworks, Allscripts PM, NextGen,Mckesson Paragon and Sunquest lab. Experience in designing and development of Tableau visualization solutions. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server. Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality. Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps. Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server. Created Workbooks and dashboards for analyzing statistical billing data using Tableau. Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's. Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives. Performing reporting and analytics (Clinical and financial) for a number of multi hierarchical US hospitals. Gather and understand business requirements and sourcing of new information including reporting dimensions, measures, key performance indicators, metrics etc Develop healthcare reports, presentation, reports and dashboards. Worked on Data Archival Project for Allscripts Touchworks and PM applications with various vendors like Informatica, Mediquant and defined Mapping documents as per the data model. Propose efficient solutions and advise on the BI aspect to cater to the hospital needs. Performing multiple merger and new hospitals implementations for new and existing reports. Creating interactive and data workflows using Automate BPA. To work with the Team to proactively identify business needs and draft the roadmap/trends for long term solutions. Analysis and resolution of data quality issues and to mitigate all the customer related concerns, developed several solutions, research and verification procedures. To mitigate all the customer related concerns, provide solutions and invent best practices/process improvements to constantly improve quality of service Documenting project processes, preparing learning plans and Tracking various KPI’s trends and movements (from delivery to utilization). “Expert Report Consultant” in Allscripts Healthcare Solutions, Inc, Pune, Sep 2008-Feb 2016 TECHNICAL SUMMARY: SQL Server 2008R2, SQL Profiler,SSRS,SSIS, Crystal reports 2008 HEALTHCARE APPLICATIONS: Hands on Experience with Allscripts Sunrise Acute care 5.0 / Sumrise Enterprise Gateway 5.5 / Sunrise Enterprise Gateway 5.5 FP1/ Sunrise Enterprise Gateway 6.0 . Acute Care , Ambulaory Care , Emergency , Pharmacy ,Clinical Analytics /Allscripts Home Care , Allscripts Touchworks, Allscripts PM applications Assisted Various Clients like [ included but not limited to ] South Australia Health – Adelaide, Hospital for Sick Kids , Hospital for Special Surgery , Cooley Dickinson Hospital , Holy Spirit, El Camino Hospital , Abington Memorila Hospital , North Missisipi Medical Centre , NewYork Queens Hospital ,HOAG Memorial Hospital ,St Clair Hospital ,Roswell Park , Aria Health , Robinson Memorial Hospital , Sound Shore Medical Centre [ Mount Vernon Hospital ] , NewYork Down Town Hospital , UHS , URHC , NYPH . in following areas specified below : Migrated Cusotm Crystal reports to SSRS 2005 / 2008 /2008R2, Developed New Reports based on Custom Report Specifications in RS 2005 / RS 2008 /RS 2008 R2 for (SCM , Touch Works) . Developed Custom SSIS Packages transferring data over to third party financial billing systems on a routine , and generate reports via third party tools , Desinging DataWare house from OLTP engines . Developed Object Plus – (CDV) for multiple Clients. Designing , Developing [ different types of Tabular Reports , Matrix Cross Tab Reports. Free form layout Reports , Graphs ] Testing and deployment of SSRS Reports to Report Server WebCatalog using Reporting Services 2005,SSRS 2008 , SSRS 2008 R2 . Parameterized Reports and Report Models using SSRS – 2005 , SSRS 2008/R2 . Experience in using global and group variables , expressions and functions for the reports . Expertise in defining queries for generating drill down reports in SSRS 2005 and SSRS 2008/R2 . Roll out SSRS Reports [ E-Mailing Reports ] to users [ Push Subscriptions ] using data driven Subscriptions and to Network File Share , Null Delivery Subscription pre loading reports into Cache . Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated . Excellent skills in implementing ETL Packages using SSIS 2008/ 2005. Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, XML).. Modified the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically. Experienced in creating and using Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers. Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables. Created Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization using execution plan. Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and developer database code as well as T-SQL code from developers and QA. Expert Knowledge of Reporting Services (SSRS), Crystal Report and Integration Services (SSIS) Excellent Report creation skills in developing reports like Tabular Reports, Matrix Report, Charts, Custom Reports, using Report Designer as well as Report Builder in SQL Server Reporting Services (SSRS) in Business Intelligent Development Studio (BIDS). Experience in creating snapshots of reports to reduce the load on the server. Managed subscriptions to provide timely reports to the clients. Developed Drill Down, Cascading, and Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users. Involved in understanding and transmitting the business requirements for the project, and translating these into functional specifications. Profound knowledge and ability to design database , writing stored procedures , using temporary tables [ CTE ‘ S ] views indexes triggers when required and complex queries with complex joins and aggregate functions , UDF functions [ Scalar and table valued functions ] Extensive knowledge in tuning T-SQL (DDL , DML ) queires to improve database performance and availability ,Broad experience in Query Optimization and performance tuning of stored procedures functions ect.. Optimized Existing T-SQL Code , Analyzed Execution plans to troubleshoot potential performance issues and using SQL Profiler , Tuned and optimized queries by analyzing different query options and indexing strategies . “Sr. Software Engineer” in RV Matrix Techonologies, Chennai, Oct-2005-Sep 2008. TECHNICAL SUMMARY: Visual Basics 6 and SQL Server 2000 ERP APPLICATIONS: ERP package consists of Marketing. Purchase, Storage, Production, Planning, Maintenance, Quality, Central Excise and Payroll. Involve in all stages of SDLC during the course of project Involved in Requirement gathering and Design phase. Executed the test cases-Functional testing and Bug fixing Coordinate with QA team in analyzing the test case modifications. EDUCATION: MBA in Marketing (2008) - First Class from Pondicherry University. B.Tech (IT) -) - First class in Sri Manakula Vinayagar Engineering College, Pondicherry University Higher Secondary School -) – First class with distinction , Amalorpavam Hr. Sec. School, Pondicherry Secondary School - (1999) –First class ,Vailankanni Matriculation Hr. Sec. School.Pondicherry CERTIFICATIONS: Allscripts Sunrise Acute Care,Touch works and PM Certified Professional Successfully completed product certification. Certified With SCM 5.0 SP3 ,5.5 SP1, 5.5 FP1 ,6.0 and 6.1. And also Touch works product Version 10,11 and above. ITIL v3 Certification in DELL SABA learning center. Pursuing certification in SAS.