SUMMARY:

• Result - oriented and dedicated professional with strong background in evaluating and defining Business Requirements for complex enterprise-wide applications.
• Skilled in interacting with stakeholders/clients, supporting a variety of projects spanning entire Software Development Life Cycle (SDLC).
• Demonstrated expertise in utilizing advanced analysis and testing skills to implement new development methodologies, partnering with high-performance teams in executing project plans.
• Keen ability to collaborate with partners to interpret and translate needs into solutions.
• Adept at overcoming obstacles, identifying resources to meet client-specific demands.
• Proficient at establishing business relationships, working effectively with individuals and groups.
• Worked as liaison between the company, its internal departments, external vendors and clientele.

TECHNOLOGY SUMMARY:

Languages: JavaScript, XML, SQL, PL/SQL, UML, HTML

Database: AWS S3, RedShift, Oracle, MySQL, MS SQL Server, MS Access, File Maker Pro.

Operating Systems: UNIX, Linux, Microsoft Windows, iOS

SDLC Methodology: Agile, Waterfall, RAD

Tools: Crystal Reports, MS Visio, MS Project, MS Office Suite, MS Access, Toad, Requisite Pro, Viper, Erwin, Quip, Trello, JIRA

Testing Types: Installation/configuration, benchmark/load/performance/stress, Functional, Regression, integration, system, acceptance, writing cases/ procedures/scripts.

EXPERIENCE:

Technology project lead

Confidential, Monterey Park, California

Responsibilities:

• Create and track key project deliverables and milestones.
• Coordinate meetings between technology teams to resolve outstanding issues.
• Provide status report to Executive Management.
• Coordinate with multiple tech leads on Enterprise Information Security requirements to ensure projects are getting delivered within the boundaries set by Risk and Compliance management.
• Maintain Resource plans for multiple projects.
• Requirement Management and Bug tracking in JIRA
• Create new SOWs for potential and existing resources to ensure seamless resource availability.
• Use Agile methodology to deploy changes to QA and Production.
• Capture using Visio the new infrastructure and related workflows.
• Coordinate release on call activities along with pre-release documentation and approvals.

Environment: Windows, MS Visio, MS Office, MS Project, SQL Server, Oracle.

Sr. BUSINESS systems ANALYST

Confidential, Playa Vista, California

Responsibilities:

• Requirement gathering from Finance Group to automate key financial reports.
• Extensive Data Sourcing and Data Mapping between the manually created and maintained reports in Excel and data maintained in SQL Server
• Identify KPI, Metrics and Dimensions for the reports.
• Requirement Management using JIRA
• Coordinate with development team to create Financial charts and reports in Tableau.
• Conduct JAD sessions with Dev and QA to discuss the solution and implement changes.
• Use Agile methodology to develop the reports and deploy them to QA and Production.
• Create high level test cases and participate in testing key functionalities.
• Used Visio to capture the new infrastructure and related workflows
• Worked closely with data engineers to create data lineage in excel by using advanced excel functions (vlookup, trim, substr, pivot tables)
• Conduct User Acceptance Testing and resolve critical issues prior to production roll out.
• Vendor interviews and selection to procure Data Catalog software for the AWS environment.
• Create Statement of Work, POC Success Criteria document, Quote Summary and draft Contractual Agreement between Vendor and Fox.
• Co-ordinate with multiple inter-departmental teams to test the Data Catalog software in internal environment, capture the results and communicate issues, enhancements, bugs to the vendor.
• Provide status update and progress report to Senior management.

Environment: Windows, MS Visio, MS Office, Tableau, SQL Server, AWS S3, AWS Redshift, Quip, Zoom, Slack.

Sr. systems ANALYST

Confidential, Moorpark, California

Responsibilities:

• As part of Retail division worked on Encompass 360 software from Ellie Mae to originate loans.
• Followed Agile methodology to deliver various changes into the system to facilitate origination.
• Requirement management using Trello software.
• Conducted JAD sessions with Dev and QA to discuss the solution and implement changes as per the plan.
• Wrote Functional Specification, Use Cases and created Business workflows as part of the responsibility.
• Used Visio to capture existing and future workflows, perform swim lane analysis.
• Data Sourcing and Data mapping document for various fields within the system.
• Thorough analysis of the requirement and recommendation of optimal solution
• Created high level test cases and participated in testing key functionalities.
• Provide status update and progress report to the team management.

Environment: Windows, MS Visio, MS Office, MS Project, Gmail, Trello, Google Hangouts, Encompass 360, Bugzilla.

Sr. BUSINESS SYSTEMS ANALYST

Confidential, Agoura Hills, California

Responsibilities:

• Requirement gathering for the new third-party Wholesale, Retail (Encompass 360) and Correspondent Lending systems.
• Extensive gap analysis between current state and third-party application’s functionality to customize and configure future state using SQL
• Write Business Requirement Document (BRD) and Functional Requirement Specification (FRS) for the new systems
• Meet with users to understand and document AS-IS and TO-BE workflows in Microsoft Visio
• Conduct JAD sessions with Development and QA team to discuss and finalize solution
• Daily meeting with the third-party vendors to discuss open issues and schedule upcoming releases
• Coordinate with IT Infrastructure team for deploying system changes onto various environments.
• Provide Functional specification walkthrough to Developers and QA teams.
• Create high level test cases for QA and validate changes deployed in the lower environment.
• Requirement Management using Microsoft TFS for internal requirements and Microsoft SharePoint for external requirements from third-party.
• Perform data analysis and data modeling to identify key business workflow and impacted data elements
• Create an end to end Data Flow Diagram to provide a bird’s-eye view of various business process flows
• Develop mapping spreadsheets for (ETL) team with source to target data mapping and physical naming.
• Establish and maintain comprehensive data model documentation including detailed descriptions of business entities, attributes and data relationships.
• Execute SQL queries to generate daily reports for line of business using SQL and MS Access.
• Provide status update and progress report to PM and senior execs.

Environment: Windows, MS Visio, MS Project, TFS, SharePoint, MS SQL Server, MS Access, WebEx, MS Office, Encompass 360.

sr. it project manager

Confidential, Oaks, California

Responsibilities:

• Manage projects for Correspondent Lending business to purchase closed loans from Correspondent Clients.
• Create and track the Master Project Plan for key milestones in the SDLC process
• Develop Strategic Plan documents, Project Management Policies, Standard Engineering process and Metrics Implementation guide.
• Organize weekly status update calls with the entire assigned team members to gather updates, compile them and report to Senior Management.
• Provide strategic direction during implementation stages.
• Coordinate discussions around Application Architecture to embrace the new solution into the legacy environment.
• Escalate issues for prompt resolution to ensure minimal impact to Operations.
• Monitor staff and team performance.

Environment: Windows, MS Visio, MS Project, TFS, SharePoint, Encompass 360, Goto Meeting, MS SQL Server, MS Access, WebEx, MS Office, Lotus Notes.

AVP; TEAM MANAGER - SYSTEM ANALYSIS

Confidential, Agoura Hills, California

Responsibilities:

• Manage a suite of modules used by Correspondent Lending Business to process and fund loans.
• Requirement management using proprietary tool called Viper.
• Respond to the assigned Maximo help desk tickets opened by the users for issues in production, escalating them and having the issues resolved as a high priority deliverable.
• Train and mentor the team on various modules by conducting Webinars using Interwise/WebEx client and Microsoft Live Meeting.
• Assist in projects involving Application and data migration
• Evaluate resource need and complete Resource Allocations for assigned projects.
• Monitor Burn-Rate, provide Forecast and Timelines on all assigned projects.
• Conduct status calls across the team, provide progress and status update to Senior Management on a periodic basis.

SENIOR business ANALYST

Confidential, Agoura Hills, California

Responsibilities:

• Coordinate key development projects, serving as primary point of contact in collaborating with business partners to evaluate end-to-end design requirements and implement Technical/Functional infrastructure improvements to support client’s business needs.
• Gather and prioritize business requirements on a monthly basis.
• Write Functional, Technical and Business Specifications.
• Create Use cases, Workflow and Data Flow Diagrams.
• Hands on experience in projects involving Application and Data migration
• Conduct Walkthroughs and JAD sessions with the Developers and QA to give them an insight of upcoming changes.
• Test the delivered code and report bugs.
• Requirement Management using custom tool named Viper
• Conduct User Acceptance Tests, write release notes and provide an overview of the modified system functionality to the users.
• Monitor and resolve any production issues within strict timelines.
• Maintain System Documentation.

Environment: Windows, MS Visio, MS Project, MS Live Meeting, Viper, VB.NET, C#, Remedy, PL/SQL, MS SQL Server, MS Access, HP AML, SharePoint, XML, WebEx, Documentum doc management, Captiva, IBML, MS Office, Lotus Notes.