JAIDEEP SARAN
*** **** ****** **, ********, Ohio, 43202
************@*****.***
Experience Summary:
Business Analyst with over 6 years of experience, analyzing business, systems and technology operations, process improvements, conservative and aggressive project plan to develop, implement and support business solution software.
Recognized by PNC Bank, JP Morgan Chase and Lambdanets Inc. for business analysis, creating unambiguous business and software requirements, release management, data modeling and mapping to build customized solution with minimal risk.
Skills:
Business / Soft Skills
Business Requirements
Software Requirement Gathering (Functional / Non-functional)
Data Mapping and Definition
Storyboarding, Prototypes and Use Cases
Project Management
Stakeholder Management
Communication
Agile / Waterfall / Iterative methodologies
Technical / Software Skills
Clarity, Concur, Office 365 and SharePoint
SAP FICO/BPC, Business Objects and Tableau
JIRA, Jenkins, Axiom, Confluence and Trello
SQL Server, TOAD, SOAP, COBOL and JSON
Java and .NET Platform
MS Office (Excel, Word, PowerPoint, Outlook, Visio, Project and Access)
Mortgage Servicing Platform (MSP), JD Edwards and Black Knight Financial Services (BKFS)
Cloud applications (WDesk, Cloudera) and Data Analytics (Hadoop Hue and Query Studio).
Employment History:
PNC Bank Dec 2016 to Present
Wiley Apr 2016 to Dec 2016
Lambdanets Inc. (JP Morgan Chase and other clients) Jun 2012 to Apr 2016
Work Experience:
PNC Bank Dec’16-Present
Business Lead/ Business Systems Analyst
Recognized by Risk, Consumer and Mortgage Line of Businesses for leading and managing reporting projects with clarity and value added services. Report directly to PNC’s Mortgage Services Director who reports to Chief Information Officer (CIO). Led Cloud, Data Analytics (Tableau, Hue) and Lending Transformation efforts.
Analyze, gather business requirements and document POC (Proof of Concept) for 3rd Party Risk Software (WDesk) for capital planning teams like CCAR (Capital Analysis and Review), AP (Analytics Performance) and AL (Asset and Liability).
Create, design and document project charter and scope, data diagrams, business requirements, functional and non-functional requirements and defect tracking in HP ALM.
Design and present project plans, performance dashboards, presentations for business go/no-go meetings and weekly project status to stakeholders and sponsors.
Diagnose and prioritize consolidation of investor/regulatory reports to establish reporting requirements and test strategy. Consolidate 131 reports to 61 while pinpointing missing reports or reports that was documented incorrectly in scope.
Developed a data definition and mapping database of 2500 fields (legacy to target: Black Knight Financial Services), data validation (SQL, TOAD and Excel) that prevented 9 process issues in future state and created API web design\ for 61 reports.
Led meetings with cross-functional teams (business, technical) from initiate to implementation phase for financial firms, performing and charge off loans (HELOCs – Home Equity Line of Credit and HEILs – Home Equity Installment Loan).
Leveraged key performance indicators (KPI), Return on Investment (ROI) initiatives by data mapping with the help of Black Knight Financial Services (BKFS), TOAD, SQL, PASSPORT and MSP (Mortgage Servicing Platform).
Wiley Apr 2016-Dec 2016
I-services (Business Consultant)
Responsible for transformation to SAP BPC (Business Planning and Consolidation) for planning, analyzing and communicating business and technical requirements for Education and Online Learning projects.
Diagnosed and prioritized gap and SWOT analysis to identify root cause of organizational challenges, business requirements, SQL queries, process flows, milestones, UAT (user acceptance testing) and red flags from legacy application to new systems.
Developed scope, business rules and requirements, functional/non-functional requirements, issue log, project milestones, data modeling, configuration and deployment plan for report generation.
Led JAD sessions and maintained a knowledge base (master of documents) for training, budgeting, development and retrospect purposes.
Develop an automation system that replaces and eliminates time-consuming manual process that increases
reporting capabilities and reduces dependence on SMEs (Subject Matter Experts).
Lambdanets Inc. Columbus, Ohio Jun 2012-Apr 2016
Business Analyst / Senior Business Systems Analyst
Recognized by senior management team for leadership and analytical ability that increased customer satisfaction by 30% and corrected missing reports and $200K revenue. Helped with Transformation of SAP FICO (Finance and Controlling) and Tableau reports. Reported directly to the leadership and executive level suite.
Also, worked with other external clients like JP Morgan, CoverMyMeds and so forth
•Spearheaded firm’s geographic expansion e-commerce initiative for banking and wealth financial clients
that required a thorough analysis of 12 cities across USA.
•Analyzed, defined and documented business needs, data mapping, system specifications, gap analysis, functional and nonfunctional requirements, use cases and evaluate risks, testing process and project communication.
•Engaged client to gather software requirements/ business rules, ran SQL queries and ensured alignment with development teams and facilitating weekly review meetings for continuous improvement for application development.
•Steered the rolled launch of retail product initiatives and managed budget ($100K-$750K) that positively
impacted client quality control, resource management and operational efficiencies.
JP Morgan Chase and Co. (Lambdanet’s Indirect Client)
Technology Analyst
Recognized by UAT Team for optimized system, testing and smooth application releases that led to zero (0) customer impact for multiple production releases of ATMs, credit cards and other child applications.
•Developed product roadmap for enterprise-wide products including business cases, usability requirements,
financial reporting and market analysis for our customers; ensuring transparent prioritization for loan payment
enhancement via ATM’s.
•Created Visio diagrams, release plans, tested XML and performed demo and business go/no-go meetings for
stakeholder’s management; and designed story and bug cards in JIRA for Functional and Non-functional
requirements, Enhancements or missed requirements for applications like VPC, DRQ, PCF etc.
•Excellent communication, problem solving, leadership and management abilities and an effective team player
for understanding the functional requirements and design of the business application.
•Managed and released financial applications ($1B and over) like ATMs and led onshore and offshore teams.
Education:
•Ohio State University, Fisher College of Business
•Bachelor of Science in Business Administration (Finance, Marketing) Columbus, Ohio 2006-2012