Preethi Subramanian Email & Phone Number

Philadelphia, PA, US

Philadelphia, Pennsylvania, United States

Greater Atlanta Area

Washington D.C. Metro Area

• Clients: Child Welfare (SACWIS - DFPS, TX, USA), WMATA (DC, USA), MTO (Ontario, CN).Technology and Tools: Tableau, HP QC, JIRA
• Participate in Joint Application Development (JAD) sessions. with business unit and end-user; document end-user requirements for data capture, program functions, data quality, reports and analysis, and training.
• Performed gap analysis on missing requirements and enhancements needed to attract new clients to the Monster Onboarding application.
• Designed the TO-BE and AS-IS functionalities that included High level business process flows, Use Case narratives & “Hand offs” to other business processes outside the functional areas.
• Analyzed Root cause of several defects and provided inputs on finding solution.
• Migrated legacy system data into Oracle Database that DFPS Staff and Supervisors could access for wide range of services.

Mclean, Virginia

• Client: USAJOBS.gov
• Collaborated with business partners and IT team to develop comprehensive and concise user stories and business requirements to help drive USAJOBS application solutions, in a complex and high volume processing.
• Documented requirements in Business/Functional Requirement Documents (BRDs/FRDs) and created many Test Plans and Test Scripts for UAT/System/Integration/Regression Testing
• Executed Test Scripts in HP ALM.
• Designed and effected enhancements to the Monster’s Onboarding application for a new client, capitalizing on Monster’s current software platform.
• Created a new Onboarding workflow for a new client and held weekly workshops to expand and explain the new workflow process through the use of WebEx, with process flow diagrams and mockups of the proposed workflow.

STK 303, 2000 H Street, NW Washington DC, 20052

• Handled two different courses – Management Information Systems (undergraduate) and Data warehousing/OLAP (Graduate) that involved tableau classes to transform large data in Excel to interactive Tableau dashboards.
• Labs included teaching MS office applications, process design, structure using MS Visio, databases on MS Access and web programming.

India

• Supported the development of DFS Bank's Credit Risk solution by streamlining implementation of Risk AnalyticsTM (RAY) platform supported by Qlikview (QV) Reporting that covers Credit Risk for bank's 11 business lines.
• Documented requirements that adheres to RWA and Non-RWA reporting for Mortgage & Non Mortgage LoBs that gets reported through Historical, MI and RWA reports in accordance with PRA guidelines.
• Designed checks, validations, mappings, calculations, data reconciliations and implement changes relevant to regulatory reporting.
• Queried source data using Oracle SQL and calculated monthly, quarterly and adhoc periods to provide decisioning information to internal customers
• Support Program management with weekly statuses on planned activities, deviations, issues, queries, milestones and escalations along with mitigation plans to senior management.
• Act as Analytics Subject Matter Expert (SME) to the client and helped them formulate an Analytics Road Map.

Master'S Degree, Management Information Systems

Bachelor Of Technology (Btech), Information Technology

Activities and Societies: Technical Paper Presentation on SQL Injection Attack and its recovery. Attended Business Seminar at the Sri.

12Th Grade

Activities and Societies: Badminton Tournament and Classical Singing.