Sumit Ghosh Email & Phone Number

Boston, Ma, Us

Woonsocket, Ri, Us

Woonsocket, Ri, Us

Deerfield, Il, Us

 Bridge the gap between the business requirements and Technical Team through Requirement Gathering and Analysis from inception phase to understand business processes for Portfolio, Real Estate Lease, Capital Projects and Operations and Maintenance for IBM TRIRIGA at Walgreens.  Implement multiple Inbound/Outbound Data Connect Integrations with TRIRIGA on Cloud environment for SAP, LDB, HRIS, GIS and other systems. Work on Merge Activities to synchronise On-Premise and Cloud TRIRIGA environments. Hands on experience in Data Modeler, Work Flows, Forms, Reports, Object Migration, Websphere, TRIRIGA Admin console for various activities. Build scripts to generate reports and data clean-up based on the logic discussed with Lease and Accounting Business teams using BIRT, SQL, Excel, VBA, Pivot Tables, Tableau, Data Visualization, Data Warehouse and Oracle.  Create and modify Functional Design Document (FDD), Integration Design Document (IDD), User Stories, Test Scenarios and Data Mapping that ensure consistency in development across the IT/Engineering organization.  Participate in the decision-making processes related to the selection of software architecture solutions, upgrade and migrate TRIRIGA Application, SAML (Single Sign-On) and Data Integrations from On-Premise to Cloud (IBM SaaS).  Serve as a technical and business-savvy resource to software development personnel on a range of software design issues and work with different vendors and effectively troubleshoot problems and roadblocks.  Conduct weekly team meetings to ensure project is on track, explore viable options to effectively troubleshoot and overcome roadblocks with respect to data system and implement FASB compliance principles and procedures. Manage, coordinate and assign support, UAT and SIT workload to offshore resources.

San Ramon, California, Us

 Manage TRIRIGA Projects from inception to closure: allocate resources, coordinate with Product Owner, Database, Architect, Application and Support Teams to implement project within scheduled time and budget.  Coordinate internal and external vendors/partners (Technical and non-Technical). Conduct Project Status Update meetings to track issues across teams, provide solutions and provide status update report to senior management. Manage project roadmap, backlog grooming and prioritize team work based on project goals/ deadlines, strategies User Acceptance Testing (UAT) and Systems Integration Testing (SIT).  Customized and enhanced business applications using Data Modeler, Form, Workflow and Query Builder. Worked on Platform/Application Upgrades, SSO (Single Sign On), BIRT Reports, Data Integration and Data Connect. Create Reports and perform Data Cleanup activities by pulling data across different data sources (MS SQL, Oracle, Hive, DB2, MS Access, Sybase, MySQL, OLAP, Excel, Flat Files) transform data as per the business requirements using JAVA/VB and Business Intelligence tools (SSRS, BIRT, Crystal Reports, SQL Developer, OBIEE, Tableau).  Worked with business users on Portfolio, Asset, People, Operations and Maintenance, RE Lease, Financial/Capital Projects, Account Payable, Account Receivable, Workplace, Lease, Sales, Human Resources data in TRIRIGA. Recognised by management- For articulating recommendations to successfully resolving SAML (Single Sign-On) issues of an outgoing premier client with IBM team coordination.  Prepared and updated documentations (Data Analysis Forms, Requirement Gathering, Feasibility Analysis, Data Mapping and Data Validation).  Managed SaaS Architecture for IBM TRIRIGA (Integrated Workplace Management Software), work with Web Server (IIS/ IHS), Middleware (JBOSS/ WebSphere/ Liberty), Database (MS SQL Server/ Oracle/ DB2).  Provide technical leadership, mentorship and offshore co-ordination.

Westborough, Ma, Us

 Determine Project Timeline and Cost based on client interaction and project scope, create a data evaluation plan to perform the ETL process for Healthcare data with respect to HIPAA data policy standards. Participate in Data Validation, Test plans, Test Design Specifications, Test Cases and UAT.  Prepare and deploy migration scripts in VB and JAVA to migrate Practice Management and Electronic Medical Records data between different databases involving single doctor practices to hospital communities using Waterfall and Agile methodologies. Create Process Flow and Integration Design documents.  Gather/ Extract data from different applications like Medisoft, Tech Pro, Intergy, Perfect Care, Mars Medical, Medics Premiere, etc. and load it in eCW software followed by User Acceptance Testing. Debugging, editing and optimizing the performance of scripts. Wrote complex SQL queries for reporting and data extraction from databases like SQL Server, Oracle and MySQL. Coordinate, distribute workload and mentor off-shore resources.

 Develop JAVA applications to place satellite TIFF (Tagged Image File Format) images based on the coordinates.

M.S., Software Engineering

Bachelor Of Engineering - Be, Information Technology