Havilah Srigiri
TX
Summary
Senior Data Analyst with extensive experience at Michigan Health and Human Services, specializing in data analytics. Proficient in ASP.NET development and SQL Server, successfully automated enrollment processes to improve efficiency and accuracy. Committed to delivering impactful solutions and promoting collaboration within teams. Strong leadership skills in team management and project execution.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Michigan Health and Human Services (MDHHS)
02.2017 - Current
- Analyzed data in CHAMP for beneficiary eligibility, enrolled beneficiaries, and automated enrollment and disenrollment processes using SSIS packages, Teradata ETL jobs, and Web APIs.
- Generated comprehensive reports for data analytics, assisting MDHHS users in decision-making.
- Conducted requirements analysis, design, build, testing, and implementation of the applications in scope.
- Participated in JAD sessions to analyze requirements and assess technical feasibility.
- Developed web screens for the intake of the requests, and the workflow of the request at different review and approval cycles.
- Developed admin screens for the maintenance of the application, such as content, emails, users, code training, etc.
- Developed functionality to track any issues related to the system, along with audit/error logging.
- Developing and integrating web applications using ASP.NET MVC, JavaScript, jQuery, Bootstrap, Entity Framework, and SQL Server 2012, and hosting on IIS 8.5.
- Developed security packaging for CC360, enabling deployment across environments to prevent security breaches.
- Developed dynamic screen package details using Telerik controls, basically for cloning the current security settings, editing them, and creating a package out of it that can be easily downloaded as a JSON file, along with package history.
- Developed a dynamic screen called package deployment using Telerik controls, deploying the JSON file that was downloaded from the above step to go live, along with deployment history.
- Executed monthly file transfers between WSA and CHAMP for enrollments.
- Environment: Microsoft SQL Server 2012, Visual Studio 2015, C#.Net, .NET Framework 4.5, ASP.Net MVC 4.0, Entity Framework, Bootstrap, jQuery.
Senior Developer
Ford Motor Company
Dearborn, MI
05.2014 - 02.2017
- Conducted requirements analysis, design, build, testing, and implementation of the applications in scope.
- Developing and integrating web applications using ASP.Net MVC, JavaScript, jQuery and oracle 11g and hosting on IIS7.
- Developed and deployed web service for submitting retrieval requests and fetching request data, enhancing data accessibility for users.
- Developed windows services for archival retrieval system, where old data is archived into zip files and retrieved based on the request.
- Created SQL reports (Range Bar) to illustrate various build phases of a program/vehicle on a timeline, including audit start and end dates for improved tracking.
- Developed scatter plot report to visualize data points for BRI vs OI, allowing users to highlight specific data points for detailed analysis.
- In addition to SSRS reports worked on classic ASP where an old application (STAMPS) has classic ASP, this is mostly enhancement or issue fixing as when they come.
- Validated Excel data based on specific conditions and formulas.
- Provided support during user acceptance testing and managed production deployment for all application releases.
- Integrating QAT and QCMT applications which are written on vb.net.
- Used manufacturing execution systems (MES) to track and document the transformation of raw materials to finished goods.
- Environment: Microsoft SQL Server 2008, Visual Studio 2008 and 2012, VB.Net, .NET Framework 4.0, ASP.Net MVC 4.0, SSRS reports, Classic ASP, VBA macros, Oracle 11g.
Senior Developer/Team lead
Chevron
Houston, Texas
05.2013 - 05.2014
- Lead a team of six, where the entire team handled thirteen applications and successfully transitioned.
- In addition to leading the team, I handled one gold (Stature) and one silver (TWS – Third Party Waste Stewardship) application.
- The Gold application is a critical application for Chevron, as it is a risk indicator in the HES (Health, Environment, Safety) stream, which has users all over the world and has been monitored by HES managers regularly.
- The Silver application is a web application where enhancements were made to the applications, interactions occurred with the business users regarding the enhancements and estimates, and the enhancements were successfully deployed to production.
- Out of the 13 applications, 7 are gold, 3 are silver, and 3 are bronze.
- The applications are support applications, and Chevron used the BMC Remedy tool for logging and tracking incidents.
- Based on the type of application—Gold, Silver, or Bronze—the SLA of the incident varies.
- I studied and analyzed the Functional Requirement Specifications, System Design Specifications, and interacted with analysts for changes in requirements, if any.
- Interacted with the client to gather business requirements.
- Implemented Agile methodology as part of project requirement changes.
- Developed custom controls for web application maintenance using CSS.
- Implemented Data Access Layer using ADO.NET to communicate with the SQL Server 2008 database.
- Wrote T-SQL queries and stored procedures using MS SQL Server for data access and reports.
- Created joins and sub-queries for complex queries involving multiple tables.
- Used DDL and DML commands for writing triggers, stored procedures, and data manipulation.
- Used SQL Server Reporting Services (SSRS) for reporting purposes.
- Working experience with SSIS, and created DTS packages.
- Managed deployment and provided post-production support for the application.
- Troubleshot and resolved application issues related to front-end and database design.
- Client-side and server-side validations for all the data entered.
- Documented technical requirements and user manuals for developed applications.
- Testing, bug tracking, and regression testing after the fix is promoted to test environments, and involved in build/release, and also using TSF for version control.
Senior Developer
Citigroup
O’Fallon, MO
10.2011 - 05.2013
- The objective of the project is to have paperless and less user intervention automated process.
- Current Kofax capture 8 is used which has custom components developed in VB6, as VB6 is end of software support and Kofax capture 10 supports VB.Net the existing custom components must be migrated to .Net and must be replaced to fit in the KC10.
- Instead of using the existing components there .net version analyzed the KC10 product to achieving same functionality using its supporting features.
- The new KC10 supports Workflow agent that can be used to replace the Auto index custom component.
- Also, KC10 supports built-in modules like Validation and Verification that can be customized to achieve the functionalities of existing QC Panels using document validation scripts.
- KC8 has custom components like Auto index and QC Panels that are developed in VB.
- Updated all legacy components to VB.Net to ensure compatibility with KC10.
- Instead of using the existing components.net version analyzed the KC10 product to achieve same functionality using its supporting features.
- The Existing Auto index functionality can be achieved using the Workflow Agent supported by KC10.
- The QC Panels functionality can be achieved using Validation/Verification modules in KC10 using the Document validation scripts written in Vb.net.
- The WFA is used to read the barcode values and assign them to index fields.
- Also used to skip the queues in between.
- The document validation scripts in vb.net provided users with an interface to input the index fields and scripts validate the fields against the database.
- All the database activities are done using the web service hosted on IIS 7.
- Ensured seamless user experience by utilizing JQuery, AJAX, and JSON for communication with ASP.NET WCF web services and handlers.
- Developed ASP.NET caching features, configuring ASP.NET optimizations, securing ASP.NET web application.
- Used CSS, HTML for achieving uniformity through all the Web pages.
- Enhanced speed, efficiency, and accuracy by modifying existing procedures and tuning database performance through indexes and query design.
- Used SQL Server Reporting Services (SSRS) for generating various invoices and cover pages of the application.
- Manipulation and auto-save/full save functionalities for user-created designs.
- Increased application reliability by working closely with QA to resolve defects.
- Successfully followed Test Driven Development (TDD)/ Agile Methodologies.
- Coordinated deployment activities to facilitate timely project implementation using the push field application for script generation.
Senior Developer
Generac
Hyderabad, India
04.2011 - 10.2011
- The basic purpose of the website is to provide an interface so that consumers can easily monitor their generator.
- Developed login flow functionality with password encryption using cryptographic hash function for ASP.NET web application.
- Performing Unit testing, Stress testing, Volume testing, Integration testing and Performance testing of application.
- Assisted in user acceptance testing and deployment of application releases.
- This is a web based remote monitoring service that allows dealers to connect directly to their customers.
- Enabled users to view generator status and generate data reports through web interface.
- Dealers are also able to utilize monitoring capability.
Senior Developer
Agility E services
Hyderabad, India
03.2010 - 04.2011
- The objective of the project is to create a global integrated order booking system, which will allow Agility GIL to create customer orders across all lines of businesses from Freight Forwarding, Chemicals, Logistics, Project Logistics and Fairs Events Logistics.
- The clients of Agility would be provided with a web-based interface to book Orders in addition to placing Orders via alternate channels such as EDI and Email.
- This will primarily be responsible for accepting orders and will be integrate with CONTROL for order execution.
- Developed parameter and save order screens using Microsoft MVC, C#, ASP.NET, SOAP, XML, ORM web forms, and MS SQL Server.
- Conducted requirements analysis, design, build, testing, and implementation of applications in scope.
- Integrated Documentum with the Asp.net MVC application, Collection note generation and Send Collection note as attachment in email.
- Performing Unit testing, Integration testing and Performance testing of application.
- Resolved software issues to ensure application functionality., build and deployment implemented.
- Evaluated change requests and estimated implementation time to ensure project timelines were met.
Developer
Tech Mahindra
Hyderabad, India
03.2008 - 09.2008
- Integrated fingerprint software into applications, enhancing user authentication through ActiveX control in VB with Asp.net windows application.
- Conducted requirements analysis, design, build, testing, and implementation of applications in scope.
- Performing Unit testing, Integration testing and Performance testing of application.
- Stored enrolled fingerprints in SQL server database for secure identification.
- Retrieving the person’s details by taking the fingerprint of the person.
- Build and deployment of all applications through all releases.
- The objective of this module is concerned with enrolling a person by his fingerprint and uniquely identifying a person with his fingerprint and retrieving his details.
Developer
Tech Mahindra
Hyderabad, India
08.2007 - 02.2008
- Developed innovative solution to collect health information from remote areas across Andhra Pradesh, enabling timely notification to authorities during epidemics/outbreaks.
- To establish a decentralized system of surveillance for communicable and non-communicable diseases, so that timely and effective public health actions can be initiated in response to health challenges in the country at the state and national level.
- Conducted requirements analysis, designed, built, tested, and implemented applications to support public health initiatives.
- Collected health data from various sources across multiple levels.
- Validating and storing the health data into the database.
- Storing, Updating the IDSP users’ information into the database.
- Analysis of the Database design.
- Analyzing health data using proprietary algorithms.
- Identified epidemics/outbreaks using customized algorithms, enhancing rapid response capabilities.
- Notified authorities of epidemics and outbreaks.
- Providing access to the IDSP data for HIHL contact center.
- Performing Unit testing, Integration testing and Performance testing of application.
- Build and deployment of all applications through all releases.
Developer
Tech Mahindra
Hyderabad, India
08.2006 - 08.2007
- Analyzed requirements, designed, built, tested, and implemented applications in scope.
- Designed and coded complaint logger screen, allowing users to register complaints and automatically notifying relevant government authorities.
- Designed and coded complaints feedback module, conducting unit testing and integration testing to ensure functionality and reliability.
- Involved in Design and Coding of Reply complaint which is a web application integrated with the web portal of Health information Help Line through which the government authority can reply to the complaint.
- Design, Coding of Information provider screen for contact center which enables any of the Information providers to view the Email, fax, SMS, chat which is sent by the caller, and it has the option of sending the reply to the caller via any media mentioned above I used technologies like Windows applications, Web Services, and Sql Server 2005.
- Developed health information service via toll-free number 104 in Andhra Pradesh, providing a centralized resource for non-emergency medical assistance.
- This Health Information Center is designed to act as a single point of contact for any non-emergency medical help, medical related information, and information on Health Care Centers to report a complaint for lapse of proper functioning in any institution and so on.
- Build and deployment of all applications through all releases.
- Preparing SRS, DDD documents.
- Analysis of the Database design.
Education
Bachelor of Engineering Studies -
Jawaharlal Nehru Technology University (JNTU)
04-2005
Skills
- Project management
- Data analytics
- Full application SDLC
- Design
- Development
- Testing and support
- Aspnet development
- Web and Windows applications
- Web APIs, web services, WCF, and Windows services
- SSRS, Crystal Reports, and SSIS packages
- Quality assurance testing
- Object-oriented and agile methodologies
- Documentation
- Build and deployment
- Microsoft NET 48, NET Core
- C# / ASPNET MVC
- SQL, SSIS, SSRS
- JavaScript, jQuery, Bootstrap, HTML, CSS, XML
- IIS 81, SOAP/OAuth
- Microsoft Office, Microsoft Visio
- TFS, GitHub, Azure DevOps
- MS SQL Server 2019
- MS Access, Oracle 11g, Teradata
Certification
- Microsoft Certified Azure fundamental (AZ-900)
- Optum certification on AI, ML
- Completed leadership training with knowledge on Six Sigma, Scrum and Agile methodologies
Accomplishments
- Got Customer appreciation (certificate) for leading team member in successful production deployment of application
- Got Bravo award for successful leading a team of 6 from TECH MAHINDRA and many appreciations from Tech Mahindra management
- Got client (Citi group) appreciation and onsite coordinator appreciation for the successful implementation of Kofax capture project
- Got client (Ford Motor Company) appreciation for the successful development and deploying a complex SSRS timeline report.
Timeline
Senior Data Analyst
Michigan Health and Human Services (MDHHS)
02.2017 - Current
Senior Developer
Ford Motor Company
05.2014 - 02.2017
Senior Developer/Team lead
Chevron
05.2013 - 05.2014
Senior Developer
Citigroup
10.2011 - 05.2013
Senior Developer
Generac
04.2011 - 10.2011
Senior Developer
Agility E services
03.2010 - 04.2011
Developer
Tech Mahindra
03.2008 - 09.2008
Developer
Tech Mahindra
08.2007 - 02.2008
Developer
Tech Mahindra
08.2006 - 08.2007
Bachelor of Engineering Studies -
Jawaharlal Nehru Technology University (JNTU)