Sumit Sinha Email & Phone Number

San Antonio, Texas, Us

• Using Pandas, NumPy, Seaborn, SciPy, Matplotlib, Scikit-learn, and NLTK in Python to develop various machine learning algorithms and utilize machine learning algorithms such as linear regression, multivariate regression, naive Bayes, Random Forests, K-means, & KNN for data analysis.• Building an automated NLP language topic model using the LDA algorithm to determine trends across the ideas submitted internally and externally. Also performed similar word and frequent word analysis. The result of the analysis helps USAA improve engagement with its customers and employees.• Building Product Line Scorecard and User Defined Applications (UDA) Dashboards Visualizations in Tableau.• Conducting Statistical analysis for USAA Research Labs projects such as Email Engagement Analysis, Data Quality Confidence Analysis, Line of Business Categories Text Cluster Analysis.• Leveraging advanced business/analytical knowledge to participate in and lead discussions with cross-functional teams to understand complex business objectives and influence solution strategies. Organizing and overseeing the development of requirements/resources necessary to meet objectives.• Identifying and gathering the relevant and quality data sources required to fully answer and address the problem for the recommended strategy. Integrating/transforming disparate data sources and applying the appropriate data hygiene techniques.• Determining and conducting appropriate exploratory data analysis (EDA) techniques on candidate data sets. Using appropriate sampling techniques to select data subset for EDA.

Us

• Responsible for developing and maintaining Python Scripts to read/write different types of files (JSON, CSV, Plain Text txt).• Used python libraries NumPy and Pandas for data analytics.• Provided exploratory data analysis (EDA), data manipulation, and data visualization using Python seaborn and Matplotlib libraries.• Worked with multiple stakeholders to harvest and define the enterprise-wide and application-level business rules for Membership Relationship Management (MRM) Portal. Wrote user stories and worked with the Business Rules Development teams (IBM ODM & Pega BPM) to implement these rules with acceptable user testing.• Involved in testing the data using SQL skills, data governance, carrying data stewardship skills creating data dictionaries.• Developed enterprise & conceptual object models (BOM) to support rule solutions, Rule Execution Algorithms, Rule Design Patterns, and frameworks.• Performed data analysis and data profiling using complex SQL on various source systems. Evaluated data mining request requirements and help develop the queries for the requests.

Minneapolis, Mn, Us

• Responsible for business process consulting & analysis and project requirement definition to U.S. Bank’s Wealth Management and Investment Services department. • Meet with decision makers, systems owners, and business users daily to define business, financial, and operations requirements and systems goals, and identify and resolve systems issues faced in the USBI Interaction Tracker Project.• Involved in the development of the data model for data migration from the old to new system using ETL (Extract, Transform & Load) steps – this also included data cleaning and understanding what data is critical to the business problem.• Reviewed Stored Procedures for reports and wrote test queries against source system (SQL Server) to match results with actual report against Data mart.• Work with multiple stakeholders from Contact Center teams to Back Office teams to get consensus on priority requirements.• Lead design sessions in prototyping the new BPM system for enhancing business processes, operations, and information process flow. Drive business playback sessions.• Analyze business requirements and create user stories for in scope items. Create workflow diagrams, User Interface excels, wireframes and skeletal documents for the business sessions. Create design documents, use cases, and other documentation, as and when needed, to facilitate requirements gathering.• Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems, and provide post-implementation support. Prepare business scenarios and UAT test scenarios.• Implement the project as per Agile development and Six Sigma methodologies and best practices. Work with the team during sprint planning to establish and manage the project backlog (grooming, prioritization and refinement).• Used various Python libraries to speed up development. Used Python, Jupyter, and Scientific computing stack (NumPy, SciPy, pandas, and matplotlib).

Irvine, Ca, Us

• Performed data analysis and model building using various R packages in RStudio (dplyr, ggplot2, Knitr, Caret, Plotly, Lattice, Corrplot) & Python (Scikit-Learn, Pandas, NumPy, Scipy, Matplotlib).• Analyzed existing client projects, researched and recommended scope for statistical analysis, including for a project developing a Sound Detection Machine Learning Model using Convolution Neural Network & TensorFlow to recognize the sound type. This model was trained for use in airline industry to pre-determine engine failure.• Performed exploratory data analysis like calculation of descriptive statistics, detection of outliers, assumptions testing, factor analysis, etc., in Python and R.• Used Tableau and designed various charts and tables for data analysis and creating various analytical Dashboards to showcase the data to managers• Built linear regression models in SAS to identify the top 15 items that would provide the largest incremental profit from a price investment for Walmart. One model was used to find cross-price elasticity & demand interrelations, the other was used to determine profit maximization per top item.

Atlanta, Georgia, Us

• Graduate Research Assistant to Dr. Beverly Wright, Executive Director, Business Analytics Center, Scheller College of Business, Georgia Tech.• Graduate Research Assistant to Prof. Deven Desai, Area Coordinator for Law and Ethics, Scheller College of Business, Georgia Tech.GRA ROLES AND RESPONSIBILITIES: • Explaining, analyzing and providing new actionable insights and telling the stories using various sources of data. Hence, recommending business actions to business leaders based on interpreted findings of the analyzed business reports. • Leading R&D process for analytics project, including academic paper research; algorithm development, program code writing, and final presentation.• Performing sophisticated data analytics (encompassing data mining, inferential statistical analysis, and predictive analytics, for example). • Collecting and preparing data for analysis, performs exploratory to advanced predictive and/or modeling analytics, and identifies data relationships (patterns and trends).TA ROLES AND RESPONSIBILITIES: • Managed and responded to work and research project related emails. Also managed and coordinated with the project client teams on behalf of the Business Analytics Center and the project student teams.• Developed instructional teaching materials such as syllabi, course work, answer keys, supplementary notes. Evaluated student work and graded examinations, assignments, or papers and recorded grades.• Led discussion sections, tutorials, or laboratory sections in the absence of the instructor. Taught students to use data analysis technology and tools for project works.• Conducted literature reviews as well as prepared materials for submission to granting agencies and foundations for the "Online Focus Group Analytics Framing" & "Corporate Social Media: A Typology of Consumers" research papers.

Atlanta, Ga, Us

Analyzed the high attrition rates for Atlanta Police Department. Worked with Officer Lynn Watanabe, Technology Innovation Center Coordinator, Atlanta Police Foundation. The purpose of the project was to examine the attrition trends since 2009 and to take a deeper look into the data in an attempt to identify factors that contribute to attrition.• Used k-means and centroid clustering, linear regression and logistic regression to investigate attrition trends at Atlanta Police Dept. to identify factors contributing to high churn rate.• Recommended and illustrated tools, such as ANOVA by cluster affiliation, towards determining root causes and initiating corrective steps.ROLES AND RESPONSIBILITES: 1. Understand the business problem & scoping the project. 2. Defining key metrics & measurement methods using client discussions and Literature reviews. 3. Choosing the appropriate analytical method & building the hypothetical model. 4. Doing data cleaning & understanding what data is important and related to the business problem 5. Explaining and interpreting trends, complex, difficult, and sensitive information. 6. Analyzing, validation and interpretation of analysis output. 7. Identifying and providing new actionable insights and telling the stories using various sources of data. 8. Providing consultation to business leaders and other stakeholders on how to leverage analytic insights to build actionable strategies. 9. Performing sophisticated data analytics (encompassing data mining, inferential statistical analysis, and predictive analytics, for example). 10. Collecting and preparing data for analysis, performs exploratory to advanced predictive and/or modeling analytics, and identifies data relationships (patterns and trends).Analytical Method Used:Cluster Analysis & Segmentation using K-Means Cluster & Centroid Cluster Analysis

Teaneck, New Jersey, Us

Project Title: CONTACT CENTER ACCELERATOR SOLUTIONClient: KEYBANK, U.S.A AND COGNIZANT INTERNALRole: TEAM LEAD and PROJECT TECHNICAL ARCHITECTPROJECT DESCRIPTION: The project aim to develop a reusable contact center solution that would include functionalities such as Customer Verification, CTI Integration with IVR, Case Management, Guided Script Workflow, Reports and Report Builder. It also includes migration of the application built in IBM BPM v8.5.0 to v8.5.5.0.ROLES AND RESPONSIBILITIES: • Lead a group of 7+ Programmer Analysts, Consultants & Sr. Consultants to successfully develop and deliver the application.• Set the strategy, vision & high level road map. Worked with business users to understand the vision and objectives. • Translated functional specifications into technical requirements. Collaborated with Sales, Marketing and other cross-functional teams to finalize branding and marketing plans for the product, resulting in sales with KeyBank US. Designed business use cases, performed acceptance testing and ensured the final solution met business needs and requirements.• Documented the key goals/needs of the project and converted to BRD. Analyzed business requirements and created user stories for in scope items. Created wireframes for the business sessions.• Worked in sync with teams from 4 different work locations within and outside India, working in different time zones.• Created Design Document & other project level deliverables and published it to the client.• Created Work Breakdown Structure, Work Allocation model and Build Estimation for the module.• Created Project Planning Model and tracked the project during its entirety.• Understanding the technologies and technical issues involved with the product, anticipating and identifying critical technical obstacles, and making accurate technology decisions.TECHNOLOGIES USED: IBM BPM 8.5.0/8.5.5.0, IBM ODM 8.0.1, Javascript, Dojo, JQuery, DB2, Blueworks Live

Teaneck, New Jersey, Us

Project Title: HUDSON LENDING R2 & R3 SOLUTIONClient: BARCLAYS BANK PLC, U.K.Role: TEAM LEADPROJECT DESCRIPTION: The project aims to cater to the implementation of as-is Facility, Security, Valuation and various other Lending Request types and associated processes as available in Siebel today as part of Lending (R3) Solution to-be implemented in IBM BPM 7.5.1. Further, R2 and R3 needs to be merged together for going Live as Hudson Lending.ROLES AND RESPONSIBILITIES: • Operating as leader in a project team in onsite/offshore model. Requirement Gathering and Analysis• Identified Siebel Lending processes that are in scope of R3 and dependencies on existing R1/R2 processes and the existing Work Packets/modules.• Reviewed captured scenarios with Barclays SMEs.• Understood various NFRs & clarified all assumptions and dependencies.Design• Understood as-is architecture and identified re-useable components from R1 & R2. • Built design of R3 on the existing R1 & R2 Lending framework.• Created WBS and Build Estimation for the module.• Created Design Document & data model and Published it to client.• Created the Requirement Traceability Matrix (RTM).• Oversaw the progress of a particular module from design and reporting perspective.• Gave design playback on the mock-up screens to the client.Build, Testing & Delivery• Led a team of 6 resources and oversaw the build progress of a particular module.• Participated in daily Scrum meeting with senior management.• Delivered the module to CIT, SIT, UAT and Production.• Gave Show & Tell sessions to the business users.• Handled and resolved the performance bottlenecks reported in production by Live users.Post-Production Support• Provided a month of post-production support after the Go-Live for the complete application.• Merged R2 and R3 releases of the application.TECHNOLOGIES USED: IBM BPM 7.5.1, Javascript, Dojo, jQuery and Blueworks Live

Teaneck, New Jersey, Us

Project Title: ASSURANCE – WARRANTY MANAGEMENT SOLUTIONClient: COGNIZANT INTERNALRole: TECHNICAL LEADPROJECT DESCRIPTION: Warranty Management is a H3 (reusable) application for post sales Warranty solutions. H3 solutions are those that Cognizant show-class to its clients as part of displaying its technical acumen and also as potential revenue options. The application comprised of following components:1) Claim Submission2) On Call Technical Support3) Product Repair3) Supplier Collaboration 4) Warranty ExtensionROLES AND RESPONSIBILITIES: • Lead a small team of 10 Programmer Analysts to develop the complete application.• Captured real-world business scenarios in order to come up with the application core requirement.• Built design of the complete application as per the above requirements gathered.• Built the application Database design.• Oversaw, guided and helped the team in constructing the application processes, User Interfaces, DB Model on IBM BPM & Unit Testing the application.• Supported and assisted the team with the isolation and resolution of issues.• Led root-cause analysis, communicated options for resolution and provided recommendations to team facing technology problems.• Helped the business analyst team to market the application providing its technical understanding and capabilities.• Responsible for coaching and mentoring less experienced team members. Also did conflict management and conflict resolution within the team.• Working cross-functionally with teams across design, marketing and engineering to meet the goalsTECHNOLOGIES USED: IBM BPM 7.5.1, IBM ODM 7.5, Javascript, Dojo, JQuery, DB2, HTML, XML, Java, iText, CSS, XSL

Teaneck, New Jersey, Us

Project Title: AMEX – CAMPAIGN MANAGEMENT SYSTEMClient: AMERICAN EXPRESS INDIA PVT. LTD., INDIARole: TEAM MEMBER AND DEVELOPERPROJECT DESCRIPTION: The project objective was migration of the existing Campaign Management System application from Lotus Notes to IBM BPM. The database used is SAS database. The project required extensive User Interface enhancement and customizations in order to develop as-is UIs as-in Lotus Notes.ROLES AND RESPONSIBILITIES IN THE PROJECT:Build & Unit Testing • Did screen designing for the complete process which included creating User-Interface, setting visibilities, making Business Objects and IBM BPM Data Model, client and server side validations using validation framework, displaying pop-ups, creating client-side tabs using dojo, doing variable binding and using EPVs and DB lookup tables for populating drop-downs.• Worked on BPD, creating BPD instances, sending notification mails via SFTP server and made the complete workflow of the process. • Wrote java-scripts and custom HTML wherever needed.• Developed end to end functionality of the process. • Constructed in scope processes on IBM BPM & Unit Tested the application.• Gave Knowledge Transition to Client BPM team on the Design and Build approach.• Made and integrated DB services and wrote queries for inserting, updating and fetching data from the SAS database.• Reviewed the Test Scenario and Test Conditions.TECHNOLOGIES USED IN THIS PROJECT: IBM BPM 7.5.1, Javascript, Dojo and SAS

Teaneck, New Jersey, Us

Project Title: LEAD AND POLICY MANAGEMENT SYSTEMClient: MAX BUPA HEALTH INSURANCE COMPANY LIMITED, INDIARole: TEAM LEADPROJECT DESCRIPTION: The functional scope of this system is development of an online application for creating or managing leads, converting the leads to policy and eventually managing the policies through different roles and actions until the policy is dispatched to the customer.ROLES AND RESPONSIBILITIES: • As a Team Lead my major responsibilities were overseeing and managing the work of the Junior Resources in the team and monitoring the junior team members to established standards and procedures that help in complying with the zero-defect policy of Cognizant.• Leading and mentoring a team of project members. Designing training modules for my team’s skill enhancement. • Starting group activities for team building which helps in the efficiency levels with desired results.• Working in sync with cross functional teams in a very-defined collaborative approach which helps in avoiding unnecessary conflicts. • Coordinating and Communicating with Client on daily basis to address challenging issues.• Participating in management and client meetings and attending other project-related meetings and seminars.• Setting both short-term and long-term goals and objectives for the project. This helps in streamlining the process and making the team members aware about their responsibilities and arising future opportunities.• Studying and keeping track of the latest technological development in the competency and providing update to all to keep everyone informed of the new developments.• Guiding, assisting and advising the other team members in technical challenging situations.TECHNOLOGIES USED: Pivotal-CRM 5.9 Active Access, VBScript, C# and Oracle 10g

Teaneck, New Jersey, Us

Project Title: ESOP & IPSOP APPLICATION Client: UNITED BUSINESS MEDIA INTERNATIONAL LTD (UBMi), U.K.Role: SENIOR DEVELOPERPROJECT DESCRIPTION: The project involved maintenance of the ESOP-IPSOP-EXPOCAD Pivotal system and resolving of WO (Work Orders) on priority basis as soon as they were raised. Also an important Logging feature was incorporated throughout the system. This Logging Feature would log each and every transaction done by the users of the system. This was especially helpful in tracking an incomplete or unsuccessful transaction later on and also finding a resolution to correct the issue on hand.ROLES AND RESPONSIBILITIES: • As a Senior Developer my major responsibilities were understanding the overall business process and developing, Unit & Integration testing, providing deployment and post deployment supportTrained and managed Junior Resources in the team. Managed team members by assigning tasks with defined goals.• Prepared periodic reports for client and senior management to track strategic goal accomplishment. • • • • Developed and reported weekly status to client; the report included progress of work orders, tasks completed, news tasks planned, each team member roles and responsibilities, tasks assigned to the each member, any challenging road-blocker issue, any major achievement etc. Kept the client abreast with the latest developments.• Developed and prepared the project time-estimate and resource-requirement. • Effectively and timely managed Delivery Deadlines. Was appreciated many a times by client for accomplishing work orders well before the stipulated delivery deadlines.• Worked in partnership with the Vertical Team for accomplishment of the project requirement. Transferred knowledge about the working of the system application to the Vertical Team members.TECHNOLOGIES USED: Pivotal-CRM 5.9 Windows Access, MSSQL Server, VB6, SQL Server 2005, Codebase (for dB connectivity) and Expocad 7.0

Teaneck, New Jersey, Us

Project Title: LMS/CSMS/PHP APPLICATION Client: MAX NEW YORK LIFE INSURANCE (MNYL), INDIARole: ONSITE COORDINATOR AND LEAD DEVELOPERPROJECT DESCRIPTION: This project is about performing the development (Phase 2) on their existing systems named CSMS, LMS and PHP. CSMS (Customer Service Management System) and LMS (Loan Management System) are pivotal applications while PHP (Policy Holder Portal) is eService application MNYL is using.ROLES AND RESPONSIBILITIES: • As an Onsite Coordinator and Lead Developer my major responsibilities were client coordination & Status reporting, capturing business & system requirements, defining release plan for various releases, defining solution approach and fixes, responsibility for documenting the core features of LMS and PHP, coding and problem solving of different modules of the system, unit testing and resolving issues in LMS Reports and PHP issues analysis and provide the RCA• Deputed to client side for 6 months at Max New Life Insurance (MNYL), Gurgaon, India and gained exposure to processes followed at MNYL’s Finance and Insurance business. • Defined release plan for various releases and defines solution approach and fixes.• Oversaw the implementation of the System Application. Identified opportunities for improvement and resolved any discrepancies.• Researched new software, tool and product updates. Attended meetings, conferences and seminars to maintain current knowledge of technological advances in the field. • Developed and documented the core features of LMS and PHP modules.TECHNOLOGIES USED: Pivotal-CRM 5.9 Active Access, VBScript, C#, Oracle 10g, JavaScript, XML and Web Service

Teaneck, New Jersey, Us

Project Title: ESOP-EXPOCAD INTEGRATION Client: CMP INFORMATION LTD (CMPi), U.K.Role: LEAD DEVELOPERPROJECT DESCRIPTION: The project involved integration of Pivotal System with Expocad, an off-the-shelf software package for floor plan and customers’ data management. As part of the developed system, Expocad, which held all floorplan related data, was integrated with Pivotal System, which held all Company, Contact and Contract related data. The soul of the system was removing double-keying of data and keeping all data valid and up-to-date for both Pivotal and Expocad Systems.ROLES AND RESPONSIBILITIES: • Understanding the Business Process, mapping Business Requirements, designing the new System, analyzing the Impact of the New System on the existing Functionality, creating tables and designing form, developing DCOMs in VB, creating and Modifying existing Pivotal Agents, validating the developed functionality with Quality Checks and unit testing the developed functionality.• Created implementation strategies and worked with administrative staff for proper installation, migration and training associated with new information system technologies.• Planned, developed and enhanced the business process of the project. Devised a method to integrate Pivotal-CRM with Expcoad, a CAD (Computer Aided Design or Computer Aided Drafting) software application for 2D and 3D design and drafting. This was a breakthrough after having spent 2 months on POC (Proof of Concept).• Validated the developed functionality with Quality Checks and provided Root Cause Analysis (RCA) for all the defects in the developed system. Helped the project pass the Quality Audit.TECHNOLOGIES USED: Pivotal-CRM 5.9, VB6, SQL Server 2005, Codebase (for dB connectivity) and Expocad 7.0

Teaneck, New Jersey, Us

Project Title: WaMu 1031 EXCHANGE MANAGERClient: WASHINGTON MUTUAL INC (WaMu), U.S.A.Role: TEAM MEMBER AND DEVELOPERPROJECT DESCRIPTION: 1031 Exchange Manager is an in house application which will replace some legacy application like ExchangeTrak and FileMakerPro. The application allow the facilitation of exchange tracking, documents generation, property details, settlement details as well as the process used to generate and manage 1031 exchange in the exchange manager application.Currently there are two legacy applications that are being used for tracking the Exchange details, Exchangor details, property and settlement details and various document generations. The legacy applications are ExchangeTrak and FileMakerPro. Proposed plan is to develop a single application i.e. 1031 Exchange Manager which will replace the above legacy applications also the Interface between the Funds Trac and Exchange Manager.ROLES AND RESPONSIBILITIES: • As a Team Member and Developer my major responsibilities were analysis and design of functional specification, analysis of table and form structure, creating tables and designing forms, writing Client Scripts using VB scripts, implementing AppServer Rule dll and unit testing of the codes written• Analyzed business and system requirement of the project.• Analyzed and designed the functional specifications of the project.• Designed, analyzed, customized and developed the core system. Analyzed the impact of this system on the existing functionality.• Implemented and tested for end-to-end IT solution offerings. Unit-Tested the system before Live Deployment.TECHNOLOGIES USED: Pivotal-CRM 5.9 Active Access, VBScript, Visual Basic and MS SQL Server 2005

Gurgaon, Haryana, In

Final Year Under-Grad Project on Network Switching Technology. Worked on a project titled "EWSD Description".

Master Of Business Administration - Full Time Mba, It & Business Analytics

Master Of Science In Analytics - Full-Time Msa, Machine Learning

Doctor Of Philosophy - Phd, It (More Specifically Machine Learning)

Bachelor Of Technology (B.Tech.), Electronics And Communications Engineering

High School, Science

High School, Science