Nitin Rajora

**+ years of diverse, progressive and extensive experience in Information Technology; with prominence on Project Management and Business, Systems and Data Analysis in multiple domains like Finance and Non-profits.

Profile:

Proficiency in Project Management involving, Project Charter, Risk Assessment, Scope Assessment, Communications Plans and Business Analysis.

Affluent in working as a liaison among business stakeholders and technical experts to understand business opportunities and technical specifications in the context of requirements and recommend solutions that enable the organization to achieve its goals.

Expertise in Business Analysis in large scale Enterprise IT Projects as well as small organizations with multiple projects.

Proficient as a Scrum Master for leading a scrum team with the user stories, product backlogs, sprints and burndowns.

Excellent knowledge and experience in working within various SDLC Methodologies like Waterfall and Agile.

Experience working with business users to analyze business requirements and functional specifications.

In-depth understanding of Database Warehousing and Reporting.

Experience with Business Modeling and Use Case Diagrams and Data Flow Diagrams.

Extensive experience on performing ‘AS IS’, ‘To BE’, and GAP analysis.

Conduct Joint Application Design (JAD) sessions and interviews.

Experience with User Acceptance Testing (UAT).

Technical Skills:

Operating Systems: Microsoft Windows (XP, Vista, 7 and 8), Mac OS, Unix (WinSCP)

Languages: C++, VBA, Java, HTML, CSS, XML, SAS, SQL

Databases: Microsoft SQL Server, ETL with Informatica, Oracle, Microsoft Access, Oracle, Tera-data

Modeling Tools: Microsoft Office, Microsoft Visio

Reporting Tools: Cognos, SAS, Business Objects, Oracle EBS, BI, Excel

Requirements Management: JIRA, Excel, Ab Initio’s MDR, ALM, Rally

General Business Tools: Microsoft Office, Microsoft Project, Microsoft SharePoint

Business Skills:

Process and Project Management

Personnel, Talent and Time Management

Detail Oriented, Organized and a team player

Skilled in Troubleshooting, Problem Solving and Solutions Provider

Education and Certifications:

CompTIA A+ Certified

E-commerce Certified, Post-graduate diploma in Webmasters

Bachelor of Science – Information Technology (Ongoing at WGU)

Professional Experience:

April 2014 – December 2015

Scrum Master / Senior Business Data Analyst / Risk Lead (Consultant)

J.P. Morgan Chase – Wilmington, DE

The BCBS (Basel Committee on Banking Supervision) Project, being executed by the biggest Financial Institute in the US, to ensure compliance with the Reporting and SOR (System of Record) requirements which has a deadline of January 2016. The Project involves a major revamp of the Reporting structure and environment along with the Data Warehouse.

Phase 1:

Comprehensive interactions with the Client’s Leads at all levels of the Project and Process Management.

Worked closely with SMEs (Subject Matter Experts) and the report owners to identify data aggregation requirements through review of reports critical to decision-making.

Led the process of Report Decomposition with the various SMEs for various reports involving the kickoff meetings with the SMEs, Project Manager(s) and the Business Analysts.

Managed a team of 5 Business Analysts to decompose and reverse-engineer the critical reporting inventory in-scope for the BCBS requirements to the SOR (System of Record) following the Waterfall model.

Finalized the BRDs and the FSDs; led the hand-off to IT.

Led the process of refining the scope while refining the original inventory required for the BCBS compliance.

Managed the Defect Resolutions call on a daily basis along with the weekly defects reporting with the PMO.

Phase 2:

Promoted as the SCRUM MASTER / RISK LEAD – Business by the client to help the Technical Team with their Design Sessions for various tables at the various layers like Migration, Integration (ETL jobs) and Symantec Layer, Data modeling, Metadata build ups.

Managed the process for integrating the Dimensions (TO BE) to ensure Report Flexibility at the run-time.

Designed an out of the box solution of RDV-SQLs process within the frameworks of Agile to match with IT’s Agile Report Build Team.

Led from the front as the Scrum Master for the RDV (Report Data Validation)-SQLs process with 10 Analysts to code the SQLs for Report Data Generation in the Current as well as the Future states to expedite the IT efforts in Report Builds in order to meet the Basel Compliance Deadline.

Established tracking, monitoring and reporting to outline progress with user stories, sprints and burn-down charts.

Coordinated with the Product Owner to keep the backlogs in check and prioritized them in a healthy fashion.

oThe process required translating the legacy SAS and BO codes into executable SQLs on Teradata.

oThe process also entailed the standardizing of several reporting metrics across the functional areas.

oLed the JAD sessions with the Business Team, Report Owners, Stakeholders and the SMEs.

oThe above RDV-SQL process helped expedite the report builds as well as the defect resolutions.

oThe Report Adoption process also benefitted due to the engagement with the legacy report owners.

Environment: Waterfall, Agile, Rally, Excel, Access, SharePoint, ALM, Oracle, Teradata, BO, Oracle EBS, SQL, SAS

August 2013 – January 2014

Director of Technology and Management (Full time)

Rambam Mesivta High School – Lawrence, NY

Technology Infrastructure Management

Vendor Management

Smartboards Tech Support

Website Management

Operations

Program Management

September 2012 – August 2013

Senior Business Systems Analyst (Consultant)

State Street Corporation, Princeton, NJ

State Street Corporation, or commonly known as State Street Bank is a US based financial services holding company. The company is headquartered in Boston, Massachusetts. State Street bank was named to be in the 29 companies of systemic importance and was made to comply with all the aspects of Basel III accord. Among the several compliance guidelines, SSFA (Simple Supervisory Formula Approach) is required by the bank to generate information to calculate RCAP. The SSFA calculation checks the delinquency of the securities based on asset classes from the (RDR) Risk Data Repository and requests the data from several third party vendors i.e. Intex, Bloomberg, ResiLoan, ABSNet, etc.

Responsibilities:

Gathered business requirements for the features needed by the users in the proposed system based on data sourcing from third party vendors automatically.

Organized knowledge transfer sessions between the development team and maintenance team to understand the reporting done by the applications TIC and RCAP.

Vision document along with BRD was produced in accordance with Basel III SSFA.

Oracle Stored Proc was used to develop the TIC SLT reports and was tested by passing SQL queries in SQL Developer.

Business models were designed with the help of MS Visio to facilitate better understanding of the work flow.

Use Cases were prepared for different asset classes based on their derivation logic in achieving the SSFA parameters.

Managed requirements over the SharePoint for other team members for SSFA system. Coordinate Sprint ceremonies – Release Planning, Sprint Planning, Sprint demo and Retrospectives

Worked with Product Owner to develop, groom and prioritize the backlog; ensured a healthy product backlog.

Removed any impediments that would prevent the delivery team to achieve its Sprint goals.

Helped achieve potentially shippable product at the end of every Sprint.

Guided and coached the team to follow Scrum framework properly.

Drove continuous improvements towards consistent delivery of working software.

Built program plans for strategic initiatives that spans multiple Agile or non-Agile teams and keep stakeholders informed on the progress.

Communicated Scrum team achievements.

Environment: Agile, MS Office Suite, MS Visio, TOAD, Oracle9I, SQL, HTML, Atlassian JIRA, Sharepoint, SQL, Oracle EBS

February 2005 – August 2012

Business Systems Analyst / Manager (Full time)

URJ – Eisner and Crane Lake Camps – Washington Township, NJ & West Stockbridge, MA

Business Analysis

Data Analysis

Financial Aid Application

Database Management

Queries (SQL) and Reports

VBA coding

Transition of Database Management Systems

Software Applications Support

Troubleshooting, Problem Solving and Solutions Provider

Training Staff

Payroll DB

Benefits MIS

Personnel Management and Time Management

Project Management

Environment: Waterfall, Agile, MS Excel, MS Access, MS Visio, SQL, HTML, Oracle E Business Suite, SQL, MS Project

September 2001 – May 2004

IT Associate (Full time)

Chakra Securities Private Limited – New Delhi, India

Interaction with software vendors for back office operations, compilation of various reports in spreadsheet for MIS and Client Reports Management.

The back office operations required installation of software and hardware along with its maintenance.

The reporting needed the use of spreadsheets, word processing and presentations in MS Office.

Client Reports Management needed Data Analysis, Database Management and the reporting tools of the Database Management System.

August 1998 – March 2001

IT Assistant (Full time)

S. Kumar Capital Services Private Limited - New Delhi, India

Database Management

Data Analysis

Reporting

Contact this candidate