Sushma Kanugo Email & Phone Number

Pittsburgh, Pa, Us

Pittsburgh, Pennsylvania, United States

Dallas-Fort Worth Metroplex

Proposed business process development to strengthen the data management process in Risk Department. Key areas of focus: • Data Stewardship: Proposed & created and maintained Azure DevOps Wiki blog which contained business KPI definitions with sample queries for each definition, important business process flows, vendor data information, table location for each vendor & data warehouse with sample queries for each. The wiki also contained code sharing blog where I worked with various… Show more Proposed business process development to strengthen the data management process in Risk Department. Key areas of focus: • Data Stewardship: Proposed & created and maintained Azure DevOps Wiki blog which contained business KPI definitions with sample queries for each definition, important business process flows, vendor data information, table location for each vendor & data warehouse with sample queries for each. The wiki also contained code sharing blog where I worked with various analysts & data engineers to validate the codes and maintain.• Data Custodian: Proposed and created an intake process which gathered data requirements to implement a Risk strategy or model on our underwriting platform in production environment. Worked on ensuring that we had all the right contracts from data vendors, gathered all technical requirements that was needed to setup for deployment.• Onboarding New Data Vendor: Post contractual agreements, the on boarding process starting from gathering technical requirements to deployment on the big data platform was overseed under my guidance along with vendor management team. Post deployment I conducted lunch and learn training sessions to provide insight into the new vendor to all our power users.• Data Cost & Invoice Processing: Worked on managing and maintain the data cost. Created a monthly report on Tableau that showed monthly accrued cost for every data vendor. This helped us validate the actual amounts received. I was involved in approving all the invoices received by various data vendors for Risk that got paid out every month.• Received incentives for establishing a new data governance process where onboarding of data or deploying strategies became easier with minimal to no mistakes. Show less

United States

The MOSAIC Multicultural Network works with various individuals in and outside of the organization from all backgrounds and faiths to learn more about each other, cooperate on meaningful projects and build stronger bond. The goal is to help connect communities, raise broader awareness and enable us to leverage differences.

Dallas/Fort Worth Area

• Assisted in developing, maintaining and monitoring both operational & enterprise metrics. Presented the findings to the appropriate stakeholders.● Worked with key stakeholders to improve process efficiencies and improve overall satisfaction of power users.● Manage business priorities while driving process improvements and data quality enhancements.● Assess and communicate release changes on Data warehouse to the user community. Evaluated all business results and provided… Show more • Assisted in developing, maintaining and monitoring both operational & enterprise metrics. Presented the findings to the appropriate stakeholders.● Worked with key stakeholders to improve process efficiencies and improve overall satisfaction of power users.● Manage business priorities while driving process improvements and data quality enhancements.● Assess and communicate release changes on Data warehouse to the user community. Evaluated all business results and provided information to team members.● Created, deployed and maintain data steward blog on SharePoint site, which is extensively used to communicate information about various new features and definitions that were recently released by our Enterprise Data Analytics Team as well as Risk Vendor Management Team.● Built velocity testing to ensure underwriting is working as expected with little to no anomaly.● Conducted various training sessions to all power users on usage and features of Data warehouse & Big Data.● Support the Enterprise Data Analytics team in delivery of new products/ initiatives data.● Got Nominated for company’s SMART Award – Think Big for establishing a forum to educate and train power users to use big data efficiently. Show less

Dallas/Fort Worth Area

● Managed and maintained SQL server reporting service. ● Built tables and views using SSIS. ● Built and maintained SSRS reports. Monitored various ad hoc data management activities.● Document, Consolidate, Centralize and Automate portfolio reports. Create Data Dictionary, Data logics and DFD diagrams for all the new data marts created from new data warehouse.● Report every quarterly on Underwriting Testing to ensure compliance to government policies.● Worked with various… Show more ● Managed and maintained SQL server reporting service. ● Built tables and views using SSIS. ● Built and maintained SSRS reports. Monitored various ad hoc data management activities.● Document, Consolidate, Centralize and Automate portfolio reports. Create Data Dictionary, Data logics and DFD diagrams for all the new data marts created from new data warehouse.● Report every quarterly on Underwriting Testing to ensure compliance to government policies.● Worked with various teams to help migrate from SQL SSIS views to using Hadoop and Teradata platforms. Show less

Fort Worth, Texas

VP of Education ...of TEAM Toasters Club - Toastmaster International

Fort Worth, Texas

Active Club Member of Toastmasters club T.E.A.M

Fort Worth, Texas, United States

Dallas/Fort Worth Area

10 years Alumni Database creation under the bounding conditions of complete and correct information of 15000 Students. My profile included selection of appropriate databases (various websites), search in regards to data trueness, inconsistencies elimination from the existing database and the final formulation of collected data that included 10,000 data registers of data.

Mumbai

To meet the strategic goals of the Organization, under the guidance of SDLC cycle norms catered for the proper software structure, IT application development, software solutions proposal and final deployment. • My Proposal of self-deployment and testing brought refinement in the software with a cost saving of approx. 5000$ per project. Work manual creation, usage rules, identification of loop holes for every project was completed. • Award recipient for the successful deployment of the… Show more To meet the strategic goals of the Organization, under the guidance of SDLC cycle norms catered for the proper software structure, IT application development, software solutions proposal and final deployment. • My Proposal of self-deployment and testing brought refinement in the software with a cost saving of approx. 5000$ per project. Work manual creation, usage rules, identification of loop holes for every project was completed. • Award recipient for the successful deployment of the project worth 75,000$.• Management of the Critical database of financial investments by provision of User access controls, security, refinement and possible foresight of the Future problems or needs.• Designed ROLAP data ware house and developed visualization charts to represent business process gaps. Provided solutions for CRM process improvements for better customer experience. Show less

Hyderabad Area, India

Defense related project for the development of an algorithm to capture bad electronic frequencies and inappropriate vocal speeches with the use of electronic control devices and Jammers. Developed database and designed network program using UNIX shell script to establish connection with Jammers.

Hyderabad Area, India

Involved in the development of a college information management portal, based on MICROSOFT DOTNET (C#) and SQL 2005 for providing information about various institutions to prospective students and information seekers.

Master'S Degree, Information Technology And Management, 3.5

Activities and Societies: Member of Project Management Club and Toastmasters Club Learnt various tools and techniques to manage.

Bachelor Of Technology (Btech), Computer Science And Engineering, 3.55

Activities and Societies: Committee member for organizing "AAGAMA2K10"​ Technical Festival. Won 3rd place in Indian Carnatic Classical.

10+2, Mathematcis, Physics And Chemistry, 85.6%

Studied at Narayana Jr. College affiliated to Board Of Intermediate education , Govt. of A.P, India

10Th Grade, High School, 80%

Activities and Societies: 1. Participated in inaugural and closing ceremony of the Afro-Asian games. 2. Won 2nd place in inter- school.