| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateUS Citizen(Previously Held Public Trust)Creve Coeur, St Louis, MO Street Address
PHONE NUMBER AVAILABLEEMAIL AVAILABLEhttps://LINKEDIN LINK AVAILABLESUMMARYWith 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.SKILLSProject ManagementProject Planning & TrackingAgile MethodologyCross-functional team leadershipProcesses and proceduresMicrosoft Office Suite expertResource ManagementSQL DevelopmentData ModelingDatabase DevelopmentPerformance TuningData MigrationData WarehousingBusiness IntelligenceReport DevelopmentDot Net DevelopmentObject-Oriented ProgrammingMicrosoft ASP.NETDatabases: Oracle, SQL ServerSource and Version Control: Git, GitHub, TFSProgramming Languages: C#, .NetCode reviewsTesting and deploymentPerformance Tuning and OptimizationUsha Nandhini RanganathanEXPERIENCESeptember 2018 - August 2023Project Manager HCL TechnologiesNovartis: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 2018Project Manager Aspire SystemsAssigned 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 2017Principal Consultant Mackson Consulting IncDeveloped DB scripts for Data migration from legacy system using SQL developer tool and resolved data issues during UAT phaseContributed 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 2016Senior Consultant CGI Federal IncCMS 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 requestsCoordinated 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 releasesFacilitated team meetings to address issues and coordinate upcoming releases between development and testing teamsPerformed load testing with the load runner tool.Addressed and resolved production issues utilizing the New Relic tool.September 2001 - March 2004Programmer Analyst Information Sciences CorpSupported the design, development, and maintenance of multiple subsystems by utilizing VBScript and Access.Client Intake, Client Medical, Provider Agency, Client ServicesSecurity Administration - Allows agency administrators to give relevant access rights to individual provider users.CARE Act Data ReportsAugust 1998 - September 2000Systems Engineer Wipro TechnologiesSupport 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.EDUCATIONNovember 1999M.C.A. Master of Computer ApplicationsBharathidasan University, IndiaApril 1992B.Sc. Bachelor of ScienceBharathiar University, IndiaTRAININGDot Net Training Course at Learning TreeData Warehousing Concepts Online Training Course at EdurekaScrum internally trained in HCLAzure DevOps internally trained in HCL. |
