Data Project

Roopa A

Email: *********@*****.***

Phone: 860-***-****

SUMMARY:

5+ years of experience as a Computer Systems Analyst and Programmer including 2 years in Mortgage with strong understanding of Business Process Flows, Case Tools, and Business Analysis with strong knowledge in front-end architecture within Infrastructure and Application management to transform and accelerate business initiatives.

Good experience as Business in the implementation and integration strategies utilizing quantitative & qualitative analytical skills. ETL/BI development experience using Data Stage, PL/SQL/Tableau.

Working experience in BI tools like Tableau.

Responsibilities included project assessment, planning, sizing, timeline and issue management, analysis and creation of business process flows, test case creation, execution and creation of functional & system requirements, analysis and validation.

Possess excellent communication and interpersonal skills to co-ordinate with clients and offshore teams.

Well-rounded background in working with Agile/Scrum and Waterfall software development methodologies.

Experience working in a Scaled Agile Framework (SAFe) environment.

Experience in managing app development projects using Jira and other tracking tools.

Strong subject matter expertise in Mortgage Backed Securities (MBS)

Extensive experience in conducting JAD sessions - participated in varied roles ranging from facilitator, preparing visual aids, setting goals and objectives, providing read-ahead materials to participants, etc.

Proficient in the implementation of production change management techniques and service delivery disciplines

Written Use cases and have produced Use Case Models, creating Behavioral diagrams (use case diagram, Activity diagrams and Sequence diagrams) based on UML Methodology & Business process flow diagrams.

Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and RFP and FSD.

Utilized a combination of business knowledge, technical skills, and strategic analysis to provide solutions and creative insights to critical business problems.

Capable of forming and maintaining positive and productive working relationships in internal, external, independent and team environment.

Engaged in documenting and testing when migrating from Savvion BPM to IBM BPM.

Documented, tested and monitored the processes in UI Path Orchestrator regarding RPA(Robotic Process Automation).

KEY COMPETENCIES:

Analyzing and modeling business processes and requirements.

Building collaborative environments receptive to views of divergent stakeholders.

Conducting workshops and training sessions.

Leveraging strong oral and written communications skills

TECHNICAL SKILLS:

Operating Systems

MS Windows XP/Vista, Sun Solaris

Project Mgt Tools

MS Visio, Rational Clear Quest, MS Project

Marketing/BPM/CMS/ETL/BI

DataStage, Oracle Warehouse Builder, SQL*Loader, Business Objects, MicroStrategy, SSRS, Salesforce, IBM BPM, RPA

Bug Tracking/Testing

Quality Center, JIRA, MS Visual Studio, Rational Quality Manager, QTP

Business Modeling

MS Visio, IBM FileNet, Rational Requisite Pro, Concept Draw Pro

Project Methodologies

Software Development Life Cycle (SDLC), Agile (Scrum, XP), Waterfall

Databases/Web server

Languages

Oracle, MySQL, MS-Access

C, C++, Java

Education:

-Bachelor’s Degree from Osmania University, Hyderabad, India (2008 - 2012)

-Master’s Degree from Fairleigh Dickinson University, NJ, USA (2014 - 2016)

PROFESSIONAL EXPERIENCE:

Freedom Mortgage, Cherry Hill, NJ April 2016 to till Date

Business Analyst

Responsibilities:

Responsible for Requirement gathering, creating Business Process Flows, Business Process Modeling and Business Analysis with Document and other Business Technology Projects.

Designed Work flows and BPM Business Process Management for streamlining approval processes for Campaign Requests. Conducted walkthroughs with the different department heads to have a deeper understanding of the requirements.

Follow up with the end users and developers for user satisfaction and change management if necessary.

Involved with Mortgage LOB in the Underwriting team to re-design the business process using IBM BPM.

Functioned as the primary liaison between the business, operations, and technical groups throughout the project cycle

Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance testing (UAT).

Involved in preparing training materials for the business users and also involved in training them regarding the business process modelling.

Engaged in documenting, testing with QA and helping business users to test in UAT and Production environments.

Involved in the deconversion of the partners in phased manner, and was engaged with business, Finance and other teams in finalizing the requirements.

Involved with Marketing analytics team to development a product and also involved in the analysis of which customers should be targeted for each product.

Prepared and presented Business Requirement Document (BRD), System Requirement Specification (SRS) and Functional Requirement Document (FRD) and involved in sign-off process.

Migrated data from Oracle, SQL Server, DB and other flat file data sources using DataStage

Develop parameter driven ETL process to map source systems to target data warehouse with DataStage complete source system profiling.

Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.

Review prototypes, solution blueprints, and project scope to ensure that the needs of the business are being met.

Involved in creating detailed test plans and testing strategies and ensure these are executed extensively, which includes executing SQL queries to retrieve data and test.

Reviewed UAT (User Acceptance Testing) results, ensured results are documented in traceability matrix and checked if requirements have been successfully achieved.

Involved in RPA (Robotic Process Automation) projects which helps business users to automate their processes which used to be done manually.

RPA Process involves UI path Orchestrator where all the business processes will be scheduled and monitored. Schedule the business processes from UI path Orchestrator and monitor the processes every day if all the scheduled jobs are running smoothly.

Environment: MS Office Suite, MS-Visio, MS Project, SharePoint, IBM BPM, RPA UI Path Studio, UI Path Orchestrator, MS Visual Studio, IBM Data Stage, PL/SQL, Quality Center, Blueworks Live, Rational Rose.

Vestric Solutions, Hyderabad, India August 2011 - May 2014

Business Analyst

Responsibilities:

Analyzed requirements, participated in Design Discussions and prepared Design documents

Developed data mapping and transformation scripts to put data in the required format and context.

Performed technical data analysis, provide referential integrity checks and deliver other project tasks, as assigned, on time and communicates accordingly.

Participate in daily stand-up meetings to facilitate the understanding, clarification, and implementation of requirements in an Agile development environment

Developed user stories and tasks while participating on Agile teams

Participate in system enhancements, modifications and upgrades

Supported CPM applications

Design and development of the application Enhancements – Worked on Class Structure Design, activities, decision rules, UI rules, SQL Connectors, HTTP Services and Connectors, SOAP Services and Connectors, MQ Listeners

Migrated data from Oracle 8i, SQL Server, DB2 and other flat file data sources using DataStage6.0

Had experience in configuration of the processing system which helps in automation of the manual process.

Develop parameter driven ETL process to map source systems to target data warehouse with DataStage complete source system profiling.

Designed lookup strategies using Hash file stage for data extraction from the source systems.

Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.

Developed Shell scripts to automate file manipulation and data loading procedures.

Developed Auditing strategies for self-documentation of the ETL process.

Generated complex reports using MicroStrategy for Drill down, Slice and Dice type of reports and deployment for end-users and documented the entire project.

Worked on programs for scheduling data loading and transformations using DataStage from ready to load flat files to Oracle using SQL*Loader and PL/SQL.

Trouble-shoots and identifies root cause systems errors and recommends preliminary solutions to more senior analysts

Assists in the development of user system documentation. Perform initial investigation, evaluation and documentation of system design findings

Addressed the requirements and handled core data related to Provider Directories

Monitored Agents, Listeners and Log files

Environment: DataStage 7.1, AIX 4.3, Quality Stage, MicroStrategy 7.5, Brio, SQL, Korn Shell, PRPC v6.3 SP1, Oracle 11g, CPM, SQL

Contact this candidate