I am responsible for ensuring that all the entitlements associated with their application or platform are provision through Identity Access Management tool Sailpoint. Reconciliation process has two components Initiated and Discovered, I am involved in both the process. IAG Initiated process is for access that gets provision or de-provisioned using the IAG request and approval process. Where IAG Discovered process covers access that was acquired or removed outside of the IAG request submission and approval process.

Provisioning

Ensure the timely and accurate provisioning and deprovisioning of Fannie Mae user access to various company developed and commercial off the shelf mission critical applications. Research and remedy discrepancies between approved user access and existing access to minimize risk to organizational assets. Aid in the compilation and communication of Internal Technology Registration (ITR) team performance metrics. Work collaboratively with ITR team members as well as members of various technical support groups to troubleshoot user issues with provisioned access.

Data Analyst/ Information Security, Freddie Mac May 2014 – Till date

There were various different processes I worked within Access Lifecycle Management.

.

Active Accounts Repository comparison with Platform status

I am involved in the process of Cleaning up our database of Active Accounts Repository and comparing it with its actual platform status.

I was involved in analyzing and finding all the Active accounts in our database which existed on Lotus Notes servers and then working with all the Database Administrators of different platforms as well as Information Security provisionars to come to a conclusion of whether realistically it exists on the corresponding platform or not.

In this process I was introduced to different platforms like Oracle, Sybase, MSSQL, Mainframe, Unix etc.

This project was a tedious effort as there were lots of data discrepancies in our database. I did get those discrepancies remediated to a level where it is at its 80% of accuracy.

In this process due to my vigilance I also took measures in getting all the active accounts on the platform registered in a central database approved as per Freddie Mac standards with better details of descriptions.

Transfer and termination (T&T) process

In this process I was performing analysis to get the list of all the accesses and ownership the individual had within the system before getting transferred or terminated, then I made sure we revoked all his access.

I worked with new delegated owners of the active accounts on the platforms that the T&T individual had ownership for, to get them to change passwords to avoid any compromises within the system.

I worked with other team members of the groups or accounts they had direct access to before being transferred or terminated to change the logon passwords to avoid plagiarism.

I made sure the accuracy of the password change completion by logging onto the appropriate platform to view its status and history.

Segregation of Duties (SoD) was a control monitored by Freddie Mac

Within this process lifecycle I was involved in its initial state where I started writing business requirements for the process to be detective and preventive. Then I was involved in the testing of the process for detective purposes. While in the detective process of SoD remediation I was involved in doing analysis and creating a tracker on Microsoft Access for our monthly monitoring. I wrote the script within Access to automate the analysis to ease the manual analysis of detection.

I was contacting the individual in violation and dealing with them in a professional manner to get them to either revoke their access or to remediate it b getting an exception approved by our management team to make sure the continuity of the business processes.

This process really enhanced my communication skills and drafted to being patient as well being able to meet deadlines in a timely efficient manner

My role here at Freddie Mac has been very immense as I paid attention to details and I made sure that the company’s systems stayed secure. My skills to Tableau, Microsoft Excel, Access and SQL server management have got enhanced to a level where I feel I am high at my proficiency level.

QA TESTER, Steris Corporation March 2013 – April 2014

RealView Visual Management Software is designed with the principle that your staff should never have to make a choice between documentation and patient care. Enabled by Real Time Location System (RTLS) technology and the hospital's OR scheduling system, it combines the patient's real-time location and scheduling information to create a complete view of patient workflows for physicians, staff and families throughout the preoperative environment.

.Responsibilities

Produced System Diagrams, Business Requirements, Report Specifications, Workflows and other documentation as required for Project Analysis, Planning and Design.

Prepared and Reviewed Business Requirement Documents and the Technical Specifications.

Prepare Use Case Models based on Business Requirement documentation gathered through interaction with users.

Wrote various SQL queries for data manipulations.

Managed critical paths and bottlenecks in conjunction with Project Tracking Reports for Senior Management with the help of RUP/UML.

Responsible for analyzing system requirements and developing test cases in Excel for the project based on SDLC.

Conducted Regression Testing before and after the code conversion.

Attend monthly QA meeting and may travel to group face-to-face testing meetings when needed.

Manage the Jira (defect tracking) database for all testing phase

Responsible for management of all Quality Assurance functions include planning, strategy, testing execution and tools.

Works with the Project Manager and other technical leaders to establish time tables and agree on a Quality Assurance plan for the implementation

Application analyzes and structure foreclosure alternatives loans so that reduce costs and often help borrowers become long-term homeowners. By providing required data, Application evaluates eligible borrowers for a loan modification under the Home Affordable Modification program (HAMP). If a borrower is ineligible for a HAMP modification, Application helps determine if another foreclosure alternative, such as a short sale or deed-in-lieu of foreclosure, is feasible.

Responsibilities

Conducted interviews with several business area experts (SMEs) for gathering requirements and evaluation/analysis of their data to convert the business requirements into IT specifications.

Responsible for analyzing system requirements and developing test cases in Quality Center for the project based on SDLC.

The company has services like pre-qualification and pre-approval programs. Initially the buyers need to provide their personal information and this information is stored in their database. Once the home hunting is done they need to provide the documents to the company. Then the company decides for how much amount the loan is approved. The monthly installments are calculated based on the loan amount, number of years and interest

Responsibilities

Analyzed, optimized and documented existing business processes using the conceptual modeling methods and documented the business process.

Worked with Operations, underwriting & reporting teams to understand the business flow and documented business checks where system process handshakes were performed

Conducted JAD sessions between users and development team to make them understand the project scope and project deliverables.

Utilized object-oriented techniques for creating use cases, Business process flows.

Facilitated working sessions with developers to understand the requirements and use cases; helped them to gather additional information to produce development design document.

Involved in Defining and granting roles and access to users to manage the business hierarchy in Empower application.

Worked with project team to identify and investigate data issues/problems/variances, determined appropriate resolution, and promptly communicated the resolution to all impacted parties.

Analyzed UAT Test scripts and scenarios for functional testing of new development, reports and issues resolution and created training material for users and QA group.

Used Rational Clear Quest as the defect tracking tool to Manage Defects and Clear Case for Version and Configuration Management.

Multi Access Integration (MAI) Web Application enables prospective clients get the quote for auto insurance online. Existing customers can log onto the site and view their current premium, get the next billing date, change their address, view online statements etc

Responsibilities

Responsible for Gathering Requirements from the Business Users to produce Business and Functional requirements.

Prepared and Reviewed Business Requirement Documents and the Technical Specifications.

Wrote various SQL queries in Oracle for data manipulations.

Generated RTM from DOORS.

Performed system test executing, supported UAT and Production execution and reporting status consistently to ensure that software and systems meet minimum company standards and defined en-user (functional) and system (non-functional) test scenarios.

Wrote SQL queries and used database checkpoints to verify database input through front-end application.