Project Management Manager
Resume:
US Citizen
(Previously Held Public Trust)
Creve Coeur, St Louis, MO 63141
*************@*****.***
https://www.linkedin.com/in/usha-nandhini-ranganathan-224250131/
SUMMARY
With over 15 years of experience working on IT projects within the US Federal healthcare and insurance industry, Usha has demonstrated her skills in project management, coordination, software development and support activities with specialization in Dot NET technologies. Proficient in data modelling, SQL analytics and reports generation with project methodology experience in Agile, Kanban and Waterfall.
SKILLS
Project Management
Project Planning & Tracking
Agile Methodology
Cross-functional team leadership
Processes and procedures
Microsoft Office Suite expert
Resource Management
SQL Development
Data Modeling
Database Development
Performance Tuning
Data Migration
Data Warehousing
Business Intelligence
Report Development
Dot Net Development
Object-Oriented Programming
Microsoft ASP.NET
Databases: Oracle, SQL Server
Source and Version Control: Git, GitHub, TFS
Programming Languages: C#, .Net
Code reviews
Testing and deployment
Performance Tuning and Optimization
Usha Nandhini Ranganathan
EXPERIENCE
September 2018 - August 2023
Project Manager HCL Technologies
Novartis:
Developed a comprehensive project plan using MS Project and Excel, while monitoring project progress during daily scrum stand-up meetings.
Prepared and facilitated detailed project status reports for regular Steering-co meetings.
Updated project progress in the plan, maintained minutes and update logs using OneNote tool, and ensured timely distribution of action items to the entire team.
Assisted the development team in overcoming obstacles.
Created and submitted Project charter and user communication document for management review and approval.
Contributed to the successful implementation of test scripts and application testing post-data migration.
Collaborated with the development team to review CIA documentation and obtained approval from stakeholders.
Coordinated CR approval process with stakeholders, ensuring smooth production release.
Emergent Holdings Inc. (EHI):
Utilized Sapience work analytics tool to generate and present weekly Productivity Reports and dashboards to the management team.
Collected data from JIRA tickets, organized it in excel format to analyze SLA and KPI metrics. Utilized this information to develop a detailed SLA dashboard using Power BI tool for customer review.
Utilized JIRA tool to create Dashboards and Data plane reports that provided Sr. Management with valuable insights on Lead time, cycle time, Throughput, and open versus Closed tickets.
NOKIA EOSL Project:
Attended a week-long EOSL workshop with the NOKIA client team and HCL team where I actively participated in developing and presenting the .NET application conversion remediation approach.
Collaborated in generating a comprehensive remediation solution document for enhancing a .NET application.
GEICO Insurance Policy Conversion System:
Worked on enhancing and resolving incidents for the policy conversion system, following Agile development methodology.
Engaged in various project operational and management tasks.
Managed GEICO Open .net positions by gathering JD Descriptions as needed, conducting profile follow-ups for requirement matches, arranging interview panels, and soliciting feedback.
Managed testing activities for .net policy conversion applications in the Azure cloud platform.
March 2018 - June 2018
Project Manager Aspire Systems
Assigned development team tickets from JIRA board, prioritized bug tickets, and held clarification meetings with KPMG client.
Created production release notes in JIRA and utilized VSTS tool for deploying KPMG tax applications.
Engaged in postman tool-based API testing for KPMG applications.
October 2016 - July 2017
Principal Consultant Mackson Consulting Inc
Developed DB scripts for Data migration from legacy system using SQL developer tool and resolved data issues during UAT phase
Contributed to the resolution of identified defects in .NET applications during UAT phases.
Resolved UI issues through utilization of Bootstrap, a front-end web development tool.
January 2005 - August 2016
Senior Consultant CGI Federal Inc
CMS RAC system:
Updated transact SQL logic in ADR process related stored procedures. Handled execution of SSIS package for RAC Data warehouse export, resulting in creation of text file following CMS RACDW system format.
Executed ADR process and related stored procedures, DB jobs, and update/insert scripts in production environment.
Contributed to the execution of production data import tasks, effectively generating excel reports including ranking spreadsheets, claims lists, and letters count.
Provider Enrollment, Chain and Ownership System (PECOS):
Participated in technical design sessions and contributed to the development of data modeling and database scripts for the extracts consolidation task, a subsystem of the PECOS DataMart project.
Collaborated with Data Architect to develop DB scripts and update Erwin model within tight deadlines.
Identified efficient methods for reverse engineering database models.
Enhanced efficiency by creating and maintaining the ETL mapping document for informatica tool used in extracts consolidation task.
Health Plan management System: (HPMS)
Provided technical guidance and resolved help desk issues, supporting BA team in production support activities for Marketing Module.
Provided technical LOE for Major, Minor releases and CR tasks in CCB process. Conducted code merge and release tasks for CGI testing environment to production.
Oversaw the coordination of diverse teams in successfully managing multiple activities which included release activity, task assignment, and development.
Engaged with clients to understand their functional needs and effectively conveyed the technical implications in a clear manner during meetings.
Served as the Marketing Module's point of contact for addressing technical inquiries from the BA team and client.
Developed and performed DB scripts for client-driven CR and emergency DBAR and tiger team requests
Coordinated analysis and defect resolution with Security team and 508 compliance team.
Coordinated with DB team to setup test data, handle DB requests, and oversee DBAR releases
Facilitated team meetings to address issues and coordinate upcoming releases between development and testing teams
Performed load testing with the load runner tool.
Addressed and resolved production issues utilizing the New Relic tool.
September 2001 - March 2004
Programmer Analyst Information Sciences Corp
Supported the design, development, and maintenance of multiple subsystems by utilizing VBScript and Access.
Client Intake, Client Medical, Provider Agency, Client Services
Security Administration - Allows agency administrators to give relevant access rights to individual provider users.
CARE Act Data Reports
August 1998 - September 2000
Systems Engineer Wipro Technologies
Support the coding of PL/SQL procedures, SQL Loader scripts, testing and preparing test cases.
Development was done in ORACLE 8.0 and Crystal reports 5.2 and Visual Basic.
EDUCATION
November 1999
M.C.A. Master of Computer Applications
Bharathidasan University, India
April 1992
B.Sc. Bachelor of Science
Bharathiar University, India
TRAINING
Dot Net Training Course at Learning Tree
Data Warehousing Concepts Online Training Course at Edureka
Scrum internally trained in HCL
Azure DevOps internally trained in HCL
.
Contact this candidate