Management Data
Resume:
Namrata Mehta
Mobile: +1-980-***-**** E-mail: **.*******@*****.***
Address: **** *** ****** **, *** 912, Greer, SC 29650. Visa status: Green card holder Seeking challenging assignments in the field of IT as a Business Systems Analyst SUMMARY
An astute professional with 4.5 years of insightful experience in the field of Information Technology as a Business Systems Analyst & 6.5 years of total work experience.
Considerable experience working with Agile (Scrum) as well as Waterfall methodologies. Very well acquainted with sprint planning, maintaining product & sprint backlogs, sprint cycle & sprint review.
Considerable experience in requirement gathering (via JAD sessions/interviews/questionnaires), GAP analysis and Root Cause analysis. An expert in evaluating information gathered from multiple sources, reconciling conflicts, decomposing high-level information into details & distinguish user requests from the underlying true needs.
Well acquainted with analysis & documentation of cost-benefit analysis in preparation of business case for new development projects.
Well versed with preparing as well as keeping up-to-date Business Requirement Documents, Functional Specification for screen functionality, process flowcharts, traceability matrix, use-case diagrams, release notes and user manuals.
Highly proficient at working with developers & subject matter experts to establish the technical vision, analyze trade-offs between usability & performance needs and getting requirements implemented.
An expert at establishing test cases for UAT, performing regression tests & getting customer sign-off.
Well versed performing automated testing using Automated Testing Framework (ATF).
Well versed with training end users, testing golden nuggets and provide post GoLive support.
Highly proficient at analyzing data using SQL queries to identify patterns/trends and thereby help with root cause analysis and business process optimization.
Well acquainted with designing/working with forms, layouts, reports, workflows & screen mock-up.
Good knowledge of business processes employed in HR, Manufacturing and Auto Finance industry.
Experienced supporting continuous process improvement for assigned business domain using Kaizen methodology and by maintaining a thorough understanding of current business processes & how they functionally align with other business areas; researching competitors & industry best practices.
Experienced reporting risks, impediments & progress to project management team & stakeholders.
Experienced acting liaison between the business units, technology teams & support teams.
Experienced in helping business users to extract & cleanse legacy data for data migration.
In addition to MS Office suite and Visio, experienced using project management tools like SharePoint, Jira, Confluence, MS Project and Lotus Notes. Also, HRIS from SAP & PeopleSoft (ERP).
Thorough understanding of SQL & database management system. Expert in using SQL Server Management Studio for data validation and manipulation. EDUCATION (Mumbai, India)
2006–2008 MBA in Human Resource Management from Atharva School of Business.
2005-2006 Post Graduation in Human Resource Development from Xavier Institute of Management.
2002-2005 Bachelor in Home Science with Specialization in Communication & Extension from SNDT University.
WORK EXPERIENCE
01/2015 – Till date Global Lending Services LLC, Greenville, South Carolina. Designation: Business Systems Analyst.
11/2010 – 12/2013 Jay Bharat Group of Companies Ltd., Vapi, India. Designation: IT Business Analyst.
08/2008 – 10/2009 Glodyne Technoserve Limited, Mumbai, India. Designation: Asst. Manager – Talent Management/SAP HR IT Analyst.
09/2005 – 06/2006 Sprint Search & Selection Pvt. Ltd., Mumbai, India. Designation: Senior Recruitment Consultant.
Namrata M: Pg. 2 of 4
INTERNSHIP
05/2007 – 07/2007 Hotel Orchid - An Ecotel, Mumbai. (MBA Summer Internship)
04/2005 – 06/2005 SOS Children’s Village of India, Mumbai. (BHSc Summer Internship) ACCOMPLISHMENTS
Implemented Auto decisioning, Factor Trust & Real-time loan boarding at GLS.
Successfully delivered ASP.NET based HRIS called Empower.
Successfully handled all HR related merger activities for 250 employees. This includes payroll transfer, adjusting employee benefits, employee relocation & consolidating HR data into one system.
Worked as a Management Representative during ISO Audit of Broadllyne Technologies Ltd.
Handled a team of 15 Software Executives responsible for performing data migration at the customer site. Main responsibilities were resource planning, task assignment & tracking progress. TECHNICAL SKILLS
S/W Development Methodologies Waterfall (SDLC), Agile & RUP. Programming Languages Working knowledge of Java, ASP. NET and C#. Documentation/Change
Management Tools
MS Office Suite (Word, Excel, PowerPoint), Visio, SharePoint, MS Project, Lotus Notes, Confluence, JIRA, Magic Draw, Gliffy
& Lucid Chart.
Testing Tools Automated Testing Framework (ATF).
ERP HRIS from SAP & PeopleSoft.
Applicant Tracking System Taleo & Kenexa.
Database MS SQL Server 2014 & Management studio.
WORK EXPERIENCE IN DETAIL
Global Lending Services LLC, Greenville, South Carolina. 01/2015 – Till Date Designation: Business Systems Analyst Industry: Automotive Subprime Lending Area of exposure:
Responsible for requirement gathering, designing solution, creating use-case specification and functional business requirement document, establishing test cases for UAT, perform automated testing using ATF, prepare release notes and conduct end-user training.
Responsible for creating and updating Product Documents and Process Diagrams in Confluence
(document repository) by using tools like Gliffy, Visio and Lucid Chart.
Responsible for ensuring appropriate approvals, version control, requirements traceability and publication of requirements.
Coordinate the definition, development, and implementation of systems-based solutions with the development team.
Solely responsible for upgrades and maintenance of Defi - an Auto Loan Originations System.
Responsible for maintaining business rules in Defi.
Act as liaison between end-users, third party vendors (Defi, Equifax, DMS & Dealer Portals), and IT partners.
Responsible for preparing Mock-Ups of Callbacks for Improving Dealer Experiences.
Review and provide input to Test Plans and Support Functional Testing.
Coordinate and participate in sprint planning sessions as well as retrospectives.
Ensure compliance with architectural requirements and security/privacy policies.
Lead the daily CAB meeting, update CAB Agendas, conduct fast track prioritization meeting with business heads and provide periodic status updates to the steering committee.
Work with MS SQL Server Management Studio for data validation and manipulation. Also, create reports by fetching data from ODS and Data warehouse.
Implemented:
Auto decisioning: Automated manual underwriting processes in order to increase efficiency and thereby prepare for higher volumes of loan applications. Gathered requirements, prepared Namrata M: Pg. 3 of 4
process diagrams and did QA to ensure all the automated decisioning processes worked as expected.
FFF: Change to eliminate multiple requests to the credit bureaus.
Factor Trust: Factor Trust is an alternative provider of credit and credit-type data. This integration was done to help with better decision making on loan applications.
Funding Process Improvement: Various process related changes were implemented to improve funding efficiency. I played a lead role in this project responsible for gathering requirements, designing solution, performing UAT and timely delivery of the project.
Real Time Loan Boarding: With implementation of this project booking loans will be a much faster & result oriented process. Currently Funding Team has to wait overnight to ensure if the loan was booked successfully or not, but post implementation of this project it will be a matter of few minutes.
OnBase Integration: Integrating OnBase – Enterprise Content Management Software with loan origination system defi.
Jay Bharat Group of Companies Ltd., Vapi, India. 11/2010 – 12/2013 Designation: IT Business Analyst Industry: Manufacturing Area of exposure:
Implemented ASP.NET based HRIS called Empower and rolled out to 4 locations.
Played a key role in gathering requirement via JAD sessions/interviews/questionnaires, preparing process flow-charts & business blue-prints, presenting cost-benefit analysis, writing functional specifications, preparing use-cases, documenting test-plan and test-results, training end users at different locations with new system functionalities, data migration and post implementation support.
Act as a liaison between the business users and IT team.
Automated attendance system, monthly incentive calculation, payroll processing (with sending electronic instructions to the Bank), maintenance of personnel data, employee appraisal & leave management.
Helped PMO implement change management process for the post-implementation support.
Started gathering requirement for automating order-to-cash (Sales) process.
Developed various HR and Sales reports for use of top management to aid in decision making.
Wrote SQL queries for the purpose of data analysis and root-cause analysis.
Very well acquainted with databases MS SQL Server 2008/2010 and Oracle 10g. Used SQL Server Management Studio and Toad for writing SQL queries.
Extensively used MS Excel and Access for data analysis, data cleansing and migrating legacy data to new system. This also involved extensive use of Pivot tables and V-Lookup.
Used MS Visio for drawing process flowcharts, swim lane diagrams, use-case diagrams and screen mock- ups.
SharePoint 2010 was used as the project collaboration tool for sharing documents and maintaining various lists such as development tracking list, issue list and contact list.
Used MS project for project planning and resource planning. Glodyne Technoserve Limited, Mumbai, India. 08/2008 – 10/2009 Designation: Assistant Manager - Talent Management/SAP HR Analyst Industry: IT Area of exposure:
Responsible for all HR related activities for offices in Mumbai, Pune and Delhi.
As a SAP HR power-user responsible for coordinating HR related system requirements with IT team.
As a SAP HR analyst, solely responsible for maintaining personnel records, organization structure, payroll processing, time & attendance, post GR for issued POs, entering/validating timesheets, ESS/MSS solutions
& executing HR reports for downloading data to Excel.. Also, responsible for maintaining physical files containing documents related to an employee.
Responsible for SAP HR configuration, setting up HR master data, data upload using LSMW and ensuring data consistency.
Namrata M: Pg. 4 of 4
Responsible to perform user acceptance testing and to train other HR department end-users.
Develop, refine and fine-tune recruitment process. Hire and manage external consultants to help during the recruitment process and thereby achieve the recruitment target in time.
Responsible for drafting job descriptions, outlining required skill set and communicating the same to job portals for posting job vacancies and to internal employees for referrals.
Screen resumes and qualify appropriate candidates, schedule and conduct interviews, salary negotiations, roll out appointment letter and if required provide relocation assistance.
Ensure Corporate Branding on job portals and local advertisements.
Process payroll and prepare monthly report on salary budget. Focus on performance pay, while ensuring compliance to the approved salary budget.
Identify risks, communicate them to management and develop a mitigation plan.
Coordinate yearly appraisals ensuring adherence to corporate guidelines on salary adjustments & promotions.
Handle Statutory (Employee Provident fund) & activities related to employee’s medical insurance.
Ensure transparency and appropriate communication to all employees.
Promote Reward and Recognition, Staff Retention and Career Development programmes.
Making travel arrangements for supervisors, validate & approve travel expense reports, manage office supplies and charge various department costs to appropriate cost centers.
Maintain department KPIs, department calendar, dashboard & PowerPoint presentations and upload them on SharePoint.
Attend to employees’ grievances/complaints and provide necessary guidance. Resolve HR related inbound queries from employees raised by calling the HR hotline or via the AskHR portal.
Responsible for exit formalities and full & final settlement. Sprint Search & Selection Private Limited, Mumbai, India. 09/2005 – 06/2006 Designation: Senior Recruitment Consultant. Industry: ITeS Area of exposure:
Sourcing suitable candidates via networking, advertising and referrals.
Screen resumes, conduct preliminary round of interviews and identify appropriate candidates for Permanent/Temporary positions with customers in BPO industry.
Once customer approves the candidate, perform background checks for that potential employee.
Perform Employee Satisfaction Survey for customers in BPO industry.
Build relationships with customers & develop good understanding of customers business, industry & work culture. Keep looking for leads that will help getting new business from existing customers.
Make presentations on recruitment process & thereby help the sales team during pre-sales activities.
Responsible for handling and training a team of five junior recruitment executives. Orchid, an Ecotel, Mumbai, India. (Five Star Hotel) 05/2007 – 07/2007 Designation: Summer Intern (MBA). Industry: Hospitality Area of exposure:
Screen resumes and qualify appropriate candidates, schedule and coordinate interviews of shortlisted candidates with respective department heads.
Maintain employee records and prepare payroll reports using HRIS from PeopleSoft.
Prepare monthly reports on Manpower & Attrition and Appraisal Comparison.
Conduct Employee Satisfaction Survey.
SOS Children’s Village of India, Mumbai. 04/2005 – 06/2005 Designation: Summer Intern (BHSc). Industry: NGO
Area of exposure:
Coordinate with CSR/HR department of different organizations for sponsorship and donations.
Project planning, coordination and reporting progress to sponsors funding the project.
Contact this candidate