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. • Led the design and development of a reporting data module for a “Complaints against Child Abuse” integration portal of SACWIS (Statewide Automated Child Welfare Information System) Application for State of Texas DFPS.• Extensively analyzed legacy data models and provided insights for future data structures and data warehouses.• Created a set of dashboards for MTO’s Road User Modernization Program using Tableau/Power BI reporting. These dashboards integrated data from across 10 different data feeds in order to track automated licensing and registration.• Proposed and developed a new access control mechanism and implemented WMATA’s security matrix using Oracle PeopleSoft to ensure proper role based access controls (RBAC) for over 80 custom roles, 40 responsibilities and menus spanning over 1000 new users.RFP/Firm Building Activities• Provided Reporting and Technical content for several Request-For-Proposals documentations. • Presented Reports/Dashboards created on Tableau/PowerBI to client.

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 environment. • 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 application.

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 and 21 host applications. • 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. • Manage project, schedule, scope and milestones and identify financial implications due to changes and delays.• Off-site coordinator for production release and responsible for code reviews, merge conflict resolution, code migration etc.• Researched, analyzed and interpreted data to create strategic trend reports to measure KPI of developed application• Ensure interoperability of tools and software and increasing the seamlessness of the business process.

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.