PREETHI SUBRAMANIAN

**** ****** ***, *************, *** 1310, GA - 30043

Phone: 703-***-**** Email: ac4wsm@r.postjobfree.com

SUMMARY

Solution Driven business/management consultant with over 6.5 years of experience assisting clients in analyzing, implementing and evaluating business/functional projects to meet performance expectations utilizing varied business practices, core competencies and key skills.

Work with limited direction and supervision, usually within a complex and changing environment, to drive delivery of solutions and meet project deadlines.

Strong proficiency in the full life cycle of Business solution development with outstanding capabilities in analysis, problem definition and requirements gathering.

Result-Driven BI-developer with a proven track record in BI, Data Warehouse and Data Analytics related consulting projects. Delivered BI reporting solutions in Tableau, Power BI, Micro Strategy and Crystal Report 2008 etc.

Extensive experience in Oracle database platform, with expertise in SQL and PL/SQL standards.

Experience in SQL performance tuning using Cost-Based Optimization (CBO).

Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.

SKILLS

Key Skills: Management Consulting, Business Consulting, Process & Technology Consulting, Program Management, SDLC and Quality Assurance

Methodology: Agile, Waterfall, Scrum and other Process based methodologies

Domain: Banking & Financial Services, Transportation, Family and Protective Services

Technical: C, C++, JAVA, JavaScript

Web Programming: HTML, XML

Database Tools: Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000/2005/2008, Microsoft Access

QA & PM Tools: HP Quality Centre, Quick test pro, JIRA, Microsoft Project, SAS, Tableau

Data Analytical Tools: Tableau 6.0, 7.0, 8.0 and 8.1, Power BI, Microsoft Excel, Cognos, Crystal Report 2008

Software Packages: Microsoft Visual Studio 2008, Microsoft Visio (Professional), Microsoft Office 2013, Siebel CRM v8.1.1.3, Oracle PeopleSoft

EDUCATION

The George Washington University Washington, DC Master of Science, Information Systems Technology & Management August 2013 – May 2015

Anna University Chennai, India

Bachelor of Technology, Information Technology August 2006 – May 2010

EXPERIENCE

Company: Infosys Public Services, Role: Senior Business Analyst/Functional Lead Austin, Texas

Client: Department of Family & Protective Services Jan 2017 – Present

Project Description

In Phase 2 of IMPACT (Information Management Protecting Adults and Children of Texas) Modernization, the IMPACT system will be modernized into a modular, mobile-enabled application with automated workflows and self-service capabilities for Child Protective Services, Adult Protective Services, Child Care Licensing, and Prevention and Early Intervention program areas. This will improve efficiency and effectiveness of caseworkers, streamline operations, and reduce their administrative burden, enabling them to spend more time with their clients.

Responsible for translating BRD into functional specifications and test plans. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.

As a functional lead, 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.

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. This lead to statically significant increase in work order response and completion percentages, cost savings, budget planning, and additional business functions.

Embedded Tableau reports on DFPS portal page and also managed access of reports and data for individual users using Oracle PeopleSoft Roles and Permissions.

Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.

Migrated legacy system data into Oracle Database that DFPS Staff and Supervisors could access for wide range of services.

Authored 250 plus help documents using Adobe RoboHelp 2017 forming the basis of system-wide

Company: Infosys Public Services, Role: Senior Business Analyst/Functional Lead Ontario, Canada

Client: Ministry of Transportation May 2016 – Jan 2017

Project Description

The new Registration and Licensing System of Ontario (RLSO) is an enterprise services-based platform using a suite of Oracle software products as a foundation. The system, implemented as part of MTO's Road User Modernization Program, replaces the existing 40-year-old legacy licensing and registration system with a modern, scalable, client-friendly solution. The platform, which does away with manual and paper-based processes, automates licensing and registration and performance monitoring services for approximately one million commercial clients and provides the foundation for a 'one client/one record' integrated driver, vehicle, and carrier system.

Collaborated with business partners and IT team to develop comprehensive and concise user stories and business requirements to help drive Registration and Licensing solutions, in a complex and high volume processing environment.

Documented requirements in Business/Functional Requirement Documents (BRDs/FRDs) and created Rules Matrix tied back to use cases for Siebel CRM. Also documented all training modules for client training purpose.

Created the following use cases and functional design specs: Driver Licensing, Vehicle Registration, Commercial Vehicle Titling, Registration Renewal, Leased Vehicle Registration etc.

Developed reporting solutions for large datasets (Big Data) using SQL, SSRS and SSIS. Extensively analyzed legacy data models and provided insights for future data structures and data warehouses. Different turnaround time reports (TAT) were developed which helped the company in identifying gaps in the business process.

Created a set of dashboards for MTO’s Road User Modernization Program using MicroStrategy reporting. These dashboards integrated data from across 10 different data feeds in order to track automated licensing and registration. These dashboards provides performance monitoring services for approximately one million commercial client data and is the foundation for a ‘one-client/one-record’ integrated driver, vehicle and carrier system reporting.

Dashboards created also provides a 360 degree view of the customers.

Company: Infosys Public Services. Role: PeopleSoft BA/Functional Lead/QA Analyst Washington DC

Client – Washington Metropolitan Area Transit Sept 2015 – May 2016

Project Description

The WMATA Contract Lifecycle Management (CLM) project will produce a single source system for all procurement activities and contract documents. The system will drive process standardizations and discipline throughout the procurement lifecycle providing enhanced visibility and integration of plans, solicitations, and contracts from initiation to closeout. Additionally the system will provide automation and self-service features for internal and external transactions as well as workflows from Advance Procurement Planning through Contract Close. The system will be the single centralized repository for managing procurements and audits.

Worked closely with client to analyze Contract Management System requirements and assisted PM by planning, scheduling and estimating project activity to create an extensive Project Plan. Interacted with clients to elicit architectural and non-functional requirements like performance, scalability, and maintainability

Successfully 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. This involved creating user groups based on departments in WMATA, roles of the users, and created access levels for the groups to give the required access to various menus and pages thereby preventing unauthorized access of data.

Developed ETL by use of SQL for extract on Oracle and MS SQL Server databases, Pervasive Data Integrator for transforming data and home developed Load utility to integrate WMATA's Contract Management's application data from a relational database into their star schema data warehouses, volume of data averaging a few hundred GBs.

Developed internal reports and dashboards covering Procurement Planning and Sourcing, Contract Creation, Bid/Proposal Evaluation, Contract Awards, Contract Maintenance and management, and contract close-out using business objects in Tableau.

Worked with the Professional Services and Project Managers and lead the bug triage meetings to resolve or prioritize defects, client requests and enhancements. Effectively communicated issues, objectives, initiatives and performance plan.

Company: Monster Worldwide, Role: Lead Agile Business Analyst McLean, VA

Client – USAJobs.gov June 2014 – May 2015

Project Description

Monster Government Solutions, a wholly-owned subsidiary of Monster Worldwide is a talent acquisition technology and services company. The Talent Acquisition functionality under a Software-a-Service (SaaS) model. With Monster Hiring Management Enterprise, federal agencies will be able to: produce job announcements; seamlessly integrate with HR Connect and non-Treasury services and other sites and back end systems; allow applicants to apply online; leverage a variety of integrated assessments; rate and rank applicants; apply Federal applicant eligibilities and preferences; allow applicants to self-schedule for recruitment or assessment events; send electronic status and task notifications to applicants, HR users and hiring managers; and produce a wide variety of reports to meet federal regulatory reporting requirements and track metrics on recruiting activities.

Product Owner for a new dashboard module, while providing well-organized and effectual communication with an overseas development team.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces to extract data into dashboards/other analytical platforms and created effective analytical filters to visualize extracted data.

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.

Performed gap analysis on missing requirements and enhancements needed to attract new clients to the Monster Onboarding application.

Presented and demoed the Monster Onboarding application for multiple Product Showcases to potential customers.

Company: Infosys Limited, Role: Senior Systems Analyst Chennai, India

Client – DFS Bank & Turkish Bank, Sept 2010 – June 2013

Project Description

A comprehensive, integrated yet modular agile business solution. Addresses all the core needs of the bank, in easy-to-configure modules. Multi entity capabilities to support multiple legal entities, across various geographies, currencies and time zones on a single instance of application.

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.

PROFESSIONAL CERTIFICATION

Project Management Professional (PMP) certification in process

Qualified Associate – Tableau Server 10

PM Elite Foundation from Infosys Technologies

CIO Certificate in Federal Executive Competencies, George Washington University, Washington DC

Contact this candidate