Data Developer

Sheela Ponnusamy

*** *** **** **** #**, Hopkins-*5343

*********@*******.***, ******.***********@*****.***. Mobile: 612-***-**** EXPERIENCE:

• Good experience as Data Quality Analyst and played lead to handle offshore team. Applying sound, systematic methodologies in identifying, prioritizing and communicating project goals and progress.

• Experience as Business Operation Analyst to work with clients and customers, analyzing data and reporting for future analysis using Tableau.

• 2 Years of experience with Well-versed in creating new data collection systems Excel SQL (oracle), MySQL, PHP that optimize data management, capturing, delivery and quality. PROFESSIONAL EXPERIENCE:

Data Quality Analyst: Boston Scientific (April’18-Present) Data Management Project/Tableau developer

• Analyzing data for 2018 based on supplier feedback and change control for eCert, SCAR, SCIA, VIP, Lot acceptance rate, FA, PIR to increase the supplier management metrics efficiency by ETL process say extracting data from SAP, Windchill and transforming in to required way using Python and loading to SSMS database finally analytics improvements for 2019 using Tableau.

• Creating report for 9 panel and to show the site progress, problem using receipts for eCert, customer service, SQE work activities both in department and management level for all different sites.

• Handled both Tableau Desktop/Server real time some data with weekly and some on twice a week to create interactive workbooks and dashboards. Using SSMS created and published multiple view for the 9 panel in position hierarchy.

• Ad hoc reports for analyzing the business strategy to find for the material and risk level when there is location change in material and business unit.

Environments: SQL, Tableau, Excel.

Metrics and Calibration Project/ Tableau developer

• Metrics tool is designed for ETL process to fetch data from various system like CATSweb, SAP, Windchill, eCrib to generate CAPA, eCert, SCAR, SCIA, Spent, Lot and used Python codes for cleansing the data with Null, empty and not relevant information in file finally injected in the SSMS database.

• Tableau server connected with SSMS database and used all the required data to create reports, workbooks, views for 9 panel to show the SQ hierarchy.

• Redesigned metrics for supplier quality organization and created predictive model for evaluating supplier risk to proactively mitigate quality issues. Worked with SAP, SQL, Web Scraping, Tableau, Data Analysis. Environments: Python, Windchill, CATSWeb, SAP, Tableau. Quality Control Projects

• Working as lead to handle offshore team to coordinate commercial region for creating all the supplier’s details in Windchill for harmonizing data in global analysis.

• Creating AML, AVL and linking the appropriate assessments, parts of materials for the vendor in Windchill. Checking the risk factor and category to make proper CAPA for the suppliers.

• Creating metrics for the QUAL documents to show some comparison table for multiple worksheets for each month and to created reports using pivot chart for future use.

• Creating CNs and Problem reports for the documents to make the corrective action in the future.

• In upgrading Windchill 11 doing Bash, informal and formal UAT testing, writing scripts for testing. Environments: Windchill, CATSWeb, SAP, Excel, Visio. Order Analyst: ReSound US (February ’18-April’18)

• Processed and analyzed large data files containing customers, pricing, and Group Purchasing Organization (GPO) membership information using MS Access and SQL Extensively used VLOOKUP, Index- Match, other functions, and pivot tables to analyze data in MS Excel.

• Maintained customer and chargeback information within ReSound systems, including chargeback agreement set-up, customer eligibility maintenance, tiers, and pricing. Environments: Navision, Excel, Salesforce.

Quality Engineer II: Boston Scientific (November’17-December’17)

• Prepare conflict minerals smelter data for loading into eCRIB software system based on existing conflict minerals reporting templates (CMRT)s from BSC suppliers. Smelter details and manufacturing materials both in local and international are imported from Catsweb in Excel.

• Create Change Notices to set new Approved Manufacturer List objects to release status. Update existing AML objects with correct address fields. Create new assessments linked to AML objects with AVL which is the parent document.

• Based on the scope of use, primary sub process and the type of document created the table using VLOOKUP that gives all the counting’s to show a comparison table for multiple worksheets for each month and to create reports using pivot chart for future use.

• Documenting the scope of work required to execute on a multi-site, quality impacting Project for supplier management.

• Identifying and processing Change Notices for appropriate updates to parts, vendors and Inspection plans in Winchill.

• Disposition (revise/obsolete) documents that have not been modified in Windchill since 2013. Contact doc owners to confirm if document can be obsoleted. Ensure that the document is structured to the correct parent in Windchill in the hierarchy. Obsolete document or ID objects to be revise document content. If obsoleting, create Problem report to remove references. Environments: Excel, Windchill, eCRIB, SAP.

Business Operation Analyst/Tableau reporter: Voya Financial (September’16-April’17)

• It deals with the policies with customer services for their future requirements in financial aids like accident, critical illness, hospital indemnity and life insurance.

• Evaluated and prepared documents for all client requirement processes. SharePoint and sales force is used to update the information stored in workbook regarding the policy, sale, and vendor. Data is imported from SharePoint for the analysis in Excel and to generate report both Excel and Tableau.

• Analyzed and proposed modifications for requirements and designs, all functional requirements for systems and prepares all planning documents.

• Coordinated with all clients and vendors through email or phone communication to develop and execute all package system solutions.

• Gathered all information from end users through sterling credentials and prepared documents for all functional and data requirements and ensure compliance to all product development standards and performed tests.

• Assisted with UAT testing and manual testing during the testing phase of the system implementation.

• Collaborated with Consultants to meet the Go-live deadline requirement for the project, with production phase in place, also finish post production needs for the client, which included some end user training.

• Working with different file formats like csv, excel, 834 files etc., and extracting data into excel.

• Created and updated documentation within SharePoint to provide common practice among team.

• RTF testing is to check the validate customers data.

• Extracting data from SharePoint, Transferring and analyzing the report created by loading the files from CDM in to Tableau.

• Played around salesforces to gather information about the policies sold and the vendor information for communication and to create the workbook for future use.

• Little experience with workday to gather information about the employee’s details working in Voya. Environments: Excel, MAX, CDM, Tableau, Salesforces. Data Assistance I: Accounts Payable Specialist University of Saint Thomas (May’16-August’16)

• Specialist in working UST Banner admin. This system contains the university's "system of record" for alumni, employee, financial, and student information.

• Analyzing and assisting data from the faculty using wells-one card and entering the report in the Wells Fargo website.

• Cognos is a suite of tools used to create and run detailed reports and analyze data to assist the St. Thomas community in making informed business decisions.

• Finalized documents are entered in Optix which is the enterprise document management system that supports the academic and administrative document imaging and workflow needs. It is used to store, retrieve, annotate, and manage digital documents from their desktops or via the Optix-web application. Data Analyst- Teknocord India Pvt Ltd. January’13-July’13

• Assisted the business in judging the possibility of entering an agreement, undertaking a project, purchasing or advertising assets or planning growth etc. Help the business take sound decision.

• Maintained the research database, renew and improve it from time to time and make sure safe Storage of data.

• Arranged analysis reports and be accountable to answer any queries, complaints or proposal.

• Assisted the association in performing data compiling, mining and psychoanalysis required to assess the given data.

Environments: PL/SQL, SQL Server 2008 using SQL management studio. C Developer- Teknocord India Pvt Ltd BSNL, India February’12-December’12

• Project: C-DOT Interactive Voice Response System

• C-DOT IVRS is an Interactive Voice Response System wherein the subscriber's calls are answered automatically, and the required information is fetched from the database, and conveyed to the subscriber in the form of announcements. The IVRS can also dial the subscribers and convey suitable messages. It can be integrated in the present telecom network through normal copper wire or PCM/E1 digital trunk interface.

• Developed an IVR application to automate billing enquiry and fault reporting system using C, RS232 interface. Coded functions to handle voice path connections and disconnections for switches like Alcatel E10B, C-DOT MAX and RAX.

• Developed auditing reports using Oracle. Fixed customer reported problems and assisted tech support engineers on maintenance.

Environments: C, Oracle, Windows XP.

Developer- Teknocord India Pvt Ltd. June’11-January’12

• Project: Wireless HART Interface Redesign

The Wireless HART Component is an XML interface to the 1420 Gateway using socket communication. This interface will be used by test cases in the Wireless Test Suite when sending wireless HART commands to a wireless device. The scope of the project is to understand the existing software design and to develop a component using the OOAD concepts.

• Effectively interacting with customer to gather customer requirements. Analyze and translate customer requirements (business/functional requirements) into formal requirements (system requirements).

• Created Entity classes, relationships between entity classes using LINQ (Language Integrated Query) to SQL to manage relational data as objects with Entity Framework 4.0.

• Used LINQ objects to query/update/modify the XML document. This saved writing lengthy XML Queries and made access to XML document in an efficient manner. This also fastened the development process.

• Used Microsoft Team Foundation Server for version Control and source code maintenance needs.

• Used LINQ objects to query/update/modify the database. This saved writing lengthy SQL Queries and made access.

Environments: .NET Framework 4.0, C#, LINQ, Visual Studio 2010, TFS, XML, SQL Server 2008 using SQL management studio.

Student Project in University of Saint Thomas with UHG: Minne MUDAC Data Challenge Competition 2018 Responsibilities:

• This project is to find who is having highest risk of getting Type II diabetics with 5M of data set. Used various algorithm like Logistic, Random forest, Neural network in R studio to find the percentage of risk level in getting change of diabetics Type II.

• Reports are created using Tableau for analyzing in different view. Based on gender, area, health care facility, food, age etc.

Environment: R studio, Weka, Tableau, SQL, Scala, SSIS. Website Designed:

• http://www.minnesotatamilcatholics.org/

• http://www.indiamissionjoy.org/

• http://linux2.gps.stthomas.edu/~ponn1171/project/ Environments: HTML, PHP, CSS, Visual Studio 2010, jQuery, Bootstrap, JavaScript. EDUCATION:

• MS in Data Science 2015- December 2017 University Saint Thomas, Saint Paul, MN.

• ME in Control and Instrumentation 2003-2005 Anna University, Tamilnadu, India.

• BE in Electronics and Instrumentation 1998-2002 MK University, Tamilnadu, India.

• Graduate Certificate in Big Data 2015-2017 University Saint Thomas, Saint Paul, MN.

• Graduate Certificate in Healthcare Analytics 2015-2017 University Saint Thomas, Saint Paul, MN. COMPUTER EXPERTISE:

• Advanced in MS Office, SQL (oracle), MySQL, PHP, PL /SQL.

• Programming: Python, R Studio, SSIS, SAS Studio, HTML.

• BI Tool: Tableau Desktop/Server, SAS.

Contact this candidate