EXECUTIVE SUMMARY

• More than 10 Years of professional experience as Business Systems Analyst with strong knowledge of Banking & Financial Services, Asset Management, Wealth Management, Institutional Retirement & 401(k), Mortgage, Mortgage Servicing, Mortgage Lending and Mortgage Backed Securities, Real Estate Owned & Property Preservation, Bankruptcy & Foreclosure Systems.
• Extensive experience in requirements elicitation, requirements analysis, developing and evaluating business process models with Use Cases, writing system functional & technical specifications design.
• Self - starter ability to work with limited direction, collaborative problem-solver, strong critical thinking and analytical skills.
• Proven success as a business systems analyst through the years providing a well-balanced understanding of business relationships, business requirements, and technical knowhow for in-house, custom off-the-shelf and third party system solutions.
• Industry standard enterprise level experience in business analysis, operations management, development, design, documentation and testing leveraging AGILE, SCRUM, KANBAN, Waterfall and Iterative SDLC methodologies.
• Expertise in UML - Class Diagrams, Object Diagrams, GAP Analysis, Use Case Diagrams, State Diagrams, Sequence Diagrams, Activity Diagrams, Collaboration Diagrams and visualizations as a business analysis methodology for application functionality designs using Microsoft Visio.
• Solid understanding of Business Process definition, Risk Analysis, modeling and developing complex business processes from current state to future state.
• Design, development and review of documents including but not limited to Business Requirements Document (BRD), Use Case Specifications, Functional Specifications ( FSD ), Software Requirement Specifications ( SRS ), Requirement Traceability Matrix ( RTM ), Master Test Plan and Test Scripts.
• Extensive knowledge in data manipulation and reporting using SSIS, SSAS, SSRS in the ETL (Extraction, Transformation and Loading) of data into a Data Warehouse/DataMart using Business Intelligence (BI) tools like Microsoft SQL Server 2008 and Business Objects Modules.
• Experienced as a Business Analyst and Designer with JAVA J2EE technologies in various sectors of business, and proficiency in object oriented analysis/design using JAVA and application servers such as Apache, WebLogic and WebSphere.
• Experience in working with Quality Assurance Team to define and develop Test Scenarios, Test Cases and documentation of Test Scripts and Test Plans.
• Tested applications developed in UNIX, .NET, JAVA, and VB. Performed various types of testing that include Smoke or BETA Testing, System Integration or Functional Testing, Performance Testing and User Acceptance Testing. Documented and tracked issues by logging defects into HP Quality Center Application Lifecycle Management tool, assigned to Development Team for remediation and retested rectified defect.
• Sound knowledge and experience in the identification, control and management of risk for the creation, development and application of Enterprise Risk Management (ERM) systems
• Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.
• Avid user of tools such as Clarity PPM to track and prioritize market and customer requirements to make effective decisions on resource investment, enterprise, IT, Service and product portfolio management for quality delivery of initiatives on time and on budget.
• Creating SQL reports and queries, operational management and reporting using Collibra
• Good experience with Collibra BI Tool, Data Governance and Data Mapping requirements
• Knowledge and vast experience of PMBOK and BABOK.
• Demonstrated exceptional attention to detail and organization skills. Work independently and effectively with staff at all levels and from multiple divisions and ability to manage multiple priorities and deadlines. Independently determining and developing approach to solutions. Evaluate work upon completion for adequacy in satisfying objectives.
• Effective in executing multiple tasks and assignments ahead of schedule, advised management on improvement strategies, Competitive & Profitability Analysis and proficient in Business Proposal Risk Assessment.
• Highly effective management and organizational skills with ability to prioritize. Kept big picture in mind while immersed in the details which includes connecting the dots across the analytics that are performed within the team.
• Strong interpersonal and communication skills with the ability to build effective working relationships with business areas and corporate partners.

EXPERIENCE & EMPLOYMENT 

Confidential, Reston VA 

Senior Business Systems Analyst

Responsibilities:

• Delivered Release Vision Statement and Release Planning documentation to the PMO and Confidential Release Management.
• Worked closely with the Product Owner to collaborate with Business Owners and SMEs in driving the elicitation and categorization of security, client-communication, governance and compliance functional and non-functional requirements to define User Stories for the Confidential Product Backlog.
• Worked closely with Application Support and Infrastructure Support teams to document current state of infrastructure assets and application support processes and procedures for multiple LOB's that leverage legacy wealth reconciliation applications systems.
• Extracted business requirements from project stakeholders and Wealth Reconciliation Application SME's outlining key migration and integration points documented in Atlassian Confluence and the user stories created and tracked in Atlassian JIRA.
• Constantly maintained and reworked Product Backlog with oversight from Product Owner, to include feature themes while performing User Story categorization, grooming and prioritization for inclusion into Sprint Backlog for feature delivery, using JIRA.
• Closely collaborated with LOB SME's to map out Order to Cash processes for the current Customer front end application in order to define requirements for future state Order To Cash mobile application solution leveraging UML visualizations.
• Meticulously groomed User Stories and defined Acceptance Criteria for Data communications and transmission, Data Governance and Data Mapping requirements of Confidential Integrated Product platform.
• Logged, tracked and updated User Stories into Product Backlog in Atlassian JIRA tool as JIRA Issues. Maintained Agile Scrum board while working with the Scrum Master for alignment of User Stories in the Product and Sprint Backlogs to coincide with JIRA.
• Identified, evaluated, prioritized managed and remediated risk via brainstorming work sessions involving key team members and stakeholders from across the business, operations and technology to create a comprehensive list of risks in their respective classifications and performed risk mapping as either Market, Credit, Insurance, Technology or Operational risk.
• Collaborated with the System Architect, Development Lead and assigned DBA resource for identifying and elaborating solution design specification for system enhancement leveraging MS Azure PaaS as the cloud solution of choice.
• Clearly defined System Context diagram depicting impacted systems, their associated inbound/outbound interfaces, communication and data transmission of a given application and its components & databases.
• Leveraged Clarity PPM as the tool of choice for all project and portfolio management activities concerning project decision making, project and funding requests time tracking and reporting.
• Lead all project management portfolio management activities for the project from inception to deployment leveraging Clarity PPM as the prescribed tool
• Worked closely with solution engineer to create current state and future state architectural specification diagrams for enhancement to MDM solution (Master Data management)
• Worked with business stakeholders and the PMO to create and update project budgets, forecasts and make constraint based scenarios to be presented to the business using Clarity PPM tool
• Created Dashboard and reporting of Confidential Platform access provisioning and de-provisioning metrics, Access Owner and Entitlement Manager Certifications, Approval & Access Requests, custom communication of targeted client-end applications and issue trackers using the Confidential Proprietary dashboard management tool.
• Performed Data Analysis on large data sets for data validation and mapping using SQL, leveraging Putty as the IDE, of inbound/outbound access and entitlement transaction traffic from interfacing platforms and applications utilizing manual and automated provision/de-provision processes.
• Reconciled database entries with inbound/outbound file transactions and web service calls into Active Directory, LDAP, UNIX Oracle etc. and other platforms for accurate tracking of metrics to define data quality requirements and KPIs leveraging Linux Command Prompt, JXplorer and Win SCP as tools of choice.
• Created data catalog to understand and extract meaningful information by identifying context, location and lineage of the data leveraging Collibra as the preferred Data Governance and analytics tool.
• Worked closely with the Data Steward and solution architect using Collibra to identify and build key metrics to define Data Requirements for data ownership, data source/target destinations and associated business rules and policy non functional requirements.
• Collaborated with third party vendor development teams and primary stakeholders of interfacing COTS products leveraged by Confidential to be integrated into the Confidential platform for manufacturing the system road map of Identity Access and Governance.
• Developed test plans, test scenarios, test cases into HP Application Life Cycle Management. Verified test environment and test data staging and setup to be used for both Manual and Automation testing for System Integration Testing, User Acceptance Testing and Upstream/Downstream Testing based on enhancements to impacted applications and functionality and logged/tracked defects in HP Application Life Cycle Management Quality Center.

Confidential, Frederick MD

Senior Business Systems Consultant

Responsibilities:

• Created partnerships with confidential team which include confidential’s, System Analysts, Wells Fargo Project Management Office (PMO), WF Development team, Integration Functional Testing (IFT) team following Iterative feature development process for enhancements and fixes to internal Wells Fargo application suite - Premier Asset Services applications (Client Portal, Team Member Portal (TMP) and MSP Updater) and established relationships with third party vendors; Aspen Grove Solutions that provide the iFamily application suite (iProperty, iVendor, iAgent, COSS (Cash Operating Support System)), and a COTS invoicing solution by Black Knight Financial Services (BKFS); LoanSphere, used by Real Estate Owned (REO) and Property Preservation LOB’s for Asset Management and Preservation.
• Conducted knowledge gathering/user story gathering sessions with stakeholders from the Wealth Management and Cash Operations LOB's to elicit business requirements by collaborating with SME's of impacted applications and 3rd party COTS applications.
• Planned, conducted, and directed the analysis of complex business problems solved with third party vendor automated systems through close collaboration in development and refinement of Outline Solutions Definition (OSD) document.
• Provided technical assistance in identifying, evaluating, and developing systems, procedures and workflows that are efficient, cost effective and meet business requirements.
• Created Risk Maps outlining technology and process gaps within the business unit and its respective applications of use and allotted risk scores for each finding.
• Worked on multiple projects in iterative and off-cycle releases following Agile methodology of SDLC for system enhancements to Black Knight Financial Services (BKFS) LoanSphere, Mortgage Service Provider (MSP) and Invoice Manager (IM) applications, Aspen Grove; Cash Operational Support System (COSS), Client Consolidation Loan Conversion, Infrastructure acquisition and decommissioning, Migration to Microsoft SharePoint, Valuations Decoupling from Aspen Grove Client Portal, Omnicate electronic communications application and Aspen Grove iFamily application suite break fix tickets and Business-As-Usual (BAU) items.
• Closely collaborated with vendor development lead to outline modular customization of MDM (Master data management) solution and generated System Architecture Specification and UML visualizations
• Engaged with the Line of Business User Groups, Business Analysts and SME (Subject Matter Experts) to resolve questions, assess user needs, and recommend system enhancements, automation and integration points.
• Maintained Product Backlog with the Product Owner and Scrum Master for feature categorization and prioritization into Sprint Backlogs for feature delivery using VersionOne.
• Conducted Requirements Gathering sessions and Side-by-Sides with Product Owner, Customer Services Representatives and (Subject Matter Experts) SME from the Business to identify and re-engineer workflow processes, build Business Process Model future state and gather key knowledge points to be captured in User Stories.
• Collaborated with the Product Owner, Scrum Master and Scrum team for User Stories refinement and backlog grooming sessions. Estimate relative User Story size by allotting Story Points through Poker Planning sessions.
• Prepared Use Cases to document current state of Lotus Notes used by Property Preservation and Real Estate Owned (REO) servicing operations as repository and workflow tool, documenting actor and system interactions for the migration to Microsoft SharePoint and for developing future state workflows for system-to-system and user-to-system interactions.
• Closely worked with DBA and Lead Architect to document migration schema, data constraints, data conversion and storage from Lotus Notes to MS SharePoint.
• Worked closely with Solution Engineer to create current and future state architectural diagrams for customization of COTS solution.
• Worked with the DBA to identify current data requirements by writing SQL queries to run on Database and document data mapping of new columns and fields built to satisfy technical design specifications.
• Created Functional System Design (FSD) documents to outline system requirements, data mapping, Database table structures and visually depict system design and system interaction through System Architecture Specification (SAS) diagrams, Activity diagrams and Class diagrams for BKFS Invoice Manager as the Invoicing solution, using MS Visio tool.
• Closely collaborated with the Integration Functional Testing team (IFT) to develop and review test plans, test scenarios, test cases, test environment and verified test data staging and setup to be used for both Manual and Automation testing for System Integration Testing, User Acceptance Testing and End-to-End Testing based on the requirements from the Business and product knowledge. Logged and tracked defects in HP Application Life Cycle Management Quality Center.
• Worked with the Line of Business User Groups, Business Analysts and SME (Subject Matter Experts) to resolve questions, assess user needs, and recommend system enhancements, automation and integration points.
• Provided oversight for User Acceptance Testing (UAT) with assigned Business Unit testers for final round trip and performance testing while providing support for defect logging and issue resolution.
• Status reporting on Iteration feature development and testing progress, issue reporting for SA Manager, PM Manager & QA Defect reporting to IFT QA Manager. Also updated and maintained project SharePoint site for the same. Updated weekly, the project and Iteration SharePoint sites with most recent Business Requirements documents, Outline Solutions Definition documents, Requirements Traceability Matrix documents and iteration calendars.
• Attended daily Scrum calls summarizing work performed from previous day, outlining any issues/roadblocks and describing activities to be done for the day ahead.

Confidential, Rockville MD 

Senior Business Systems Consultant

Responsibilities:

• Documented business operations that leveraged MS Access databases and MS Excel spreadsheets as the workflow tools used by the business for Migration to MS SharePoint by capturing current state using UML methodology of documentation with Business Process modeling, Activity flow and Data flow diagrams.
• Worked closely with Application Support and Infrastructure support teams to document current state of infrastructure assets, platform communications and application support processes and procedures for LOB support that leverage the legacy systems.
• Created System Architecture Specification to re-engineer system processes, interface communications for application platform and infrastructure future state design. Also created System Support procedures outlining capabilities of future state implementation to be leveraged by Support team.
• Facilitated elicitation workshops with legal and compliance stakeholders to identify and vet through SLA’s and develop KPI metrics and outline non functional requirements.
• Prepared Business Process Models that included modeling of activities in Day-in-a-Life of the business at the procedural level.
• Responsible for performing back-end analysis and testing using open source SQL tool; TOAD.
• Extracted business requirements from project stakeholders outlining key migration and integration points with MS SharePoint documenting using Atlassian Confluence and linked to tasks with Atlassian JIRA.
• Drove the design and development plan for a migration of in-house proprietary data to a cloud based PaaS migration Azure solution incorporating legacy systems cross-application data interfacing and transmission dependencies
• Performed database validation in the Mainframe to ensure seamless data flow from front end to the database. Exclusively used SQL, T-SQL for designing modifying and maintaining the SQL Server Tables, Views and Stored Procedures accordingly.
• Defined and documented dynamic on-demand architecture for real-time inter-application inbound/outbound communications.
• Logged, researched and resolved potential design/business issues identified in TFS and HP QC.
• Analyzed Test Cases, Scripts and Scenarios and ensured compliance for regression testing, bug fixes and user acceptance.
• Propose process improvements to documentation and technical writing procedures.
• Created class diagrams, ER diagrams, data mapping and logical data models by querying Oracle database to filter data using SQL.
• Implemented the entire Agile methodology of application development with its various workflows, artifacts and activities.
• Used JIRA as the single source of truth for Scope estimation, Sprint Planning, Epic, Backlog and User Story development project, defect logging and tracking with the SA, QA and UAT teams.
• Assisted with user testing of systems (User Acceptance Testing), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Analyzed Business Requirements performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams/State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Ability to work with all members of the project team, following the project through the Systems Development Life Cycle and ensuring business objectives are met (extensive project life cycle experience).
• Interacted with database developers for formulating the ER diagrams and data flow diagrams.
• Created cross-functional flow chart using MS Visio.

Confidential, Rockville MD 

Senior Technical Business Analyst 

Responsibilities:

• Initiated project planning, budget management, resource governance and allocation for project initiation and strategic planning according to the release schedule with Executive project management Office and Information Technology teams.
• Acted as liaison with project stakeholders with cross-functional business partners, lines of business and business users across a non-centric, geographically distributed enterprise environment.
• Conducted knowledge gathering/User story gathering sessions with stakeholders to understand business need by collaborating with Subject Matter Expert s ( SME ) of impacted Business Units and third party vendors.
• Understood and analysed the Business need vs. nice-to-haves so as to extract business requirements by conducting daily Joint Application Development ( JAD ) sessions and User workshops to draft Business Requirements Document (BRD).
• Translated business requirements into functional design specifications and drafted Functional System Design document (FSD).
• Created, updated and tracked requirements specifications by leveraging Rally BluePrint requirements documentation/tracking tool.
• Created Requirements Traceability Matrix for tracking Business Requirements linking them to Functional Specifications and Technical Specifications and tallying them QA test scripts.
• Articulated system requirements into Wire Frames with Use Cases, Use Case Scenarios and Use Case Narratives using UML (Unified Modeling Language) methodologies.
• Interacted with Data Modeller and DBA for Data Analysis to understand Data/table Relationships and for Integration.
• Queried the Sybase database using Toad to filter data, parse database tables and leverage current database architecture using SQL.
• Worked closely with User Interface team to model Web Screens, which met User defined requirements and company standards.
• Held regular meetings with Product Stakeholders, Product Owners, Project Managers, Product Architects, Developer Leads, Database Architects, QA Leads during the entire project life cycle to insure critical as well as the minute details of the project were thoroughly analysed and issues identified/handled by Change Control process for resolution.
• Authored the Product Backlog for the complete project, derived User Stories for individual iterations, created child backlogs with assigned tasks and allocated appropriate resources for completion and acceptance of individual stories using VersionOne requirements management and tracking tool.
• Created project Traceability Matrix linking each business requirement to functional specification to technical requirement.
• Conducted demonstrations, mock up sessions and walkthroughs for Development and QA teams for transparency and seamless transition from design documentation to development and system integration testing.
• Closely collaborated with 3 rd party vendor and solution architect to outline roadmap for modular customization of COTS solution and generated documentation in form of System Architecture Specification document and UML visualizations.
• Mapped key data integration points and documented requirements for data transmission and storage architecture, worked with business SME ’s to re-engineer current state BAU processes and created future state business process model outlining detailed role based process mappings.
• Facilitated regular meetings with 3rd party vendors for acquisition of infrastructure to support creation of data warehouse, configure dynamic data transmission via web service calls between COTS and in-house applications for real-time data sync and Comm-On-Demand data sharing.
• Closely collaborated with the Quality Assurance Tester to develop and review test plans, test scenarios, test cases and test data to be used for both Manual and Automation testing based on the requirements from the Business and product knowledge.
• Worked closely with QA tester for smoke testing, system integration testing and end-to-end testing of designed functionality.
• Leveraged UNIX commands for testing of the CSV file, data validation and manipulation and verifying file source and target destinations while testing file transmission via Data Transmission Services (DTS).
• Created complex SQL queries to extract, transform and analyse data from distributed databases across internal and 3 rd party platforms for data modelling and report generation utilizing SQL Server 2008.
• Oversaw User Acceptance Testing (UAT) with assigned Business Unit tester for final round trip testing.
• Opened and tracked software defects in HP Quality Center discovered during system integration and regression testing.
• Worked with the Business, Development and QA to track and resolve defects discovered during the QA’ing process by adhering to the Enterprise Project Change Control protocols and Compliance throughout the project lifecycle.
• Responsible as backup for Scrum Master to facilitate standup ceremonies while maintaining the Product, Release and Sprint backlogs for reporting and sprint burn down.
• Prepared weekly action reports, corporate and divisional team reporting with Confidential Manager & QA defect reporting to QA Manager.
• Worked on multiple projects simultaneously as assigned Confidential while handling PM responsibilities on small projects, SharePoint site management and coordination, production issues and Change Controls assigned by product owner.
• Managed documentation repository Lotus Notes: ProTrack for all project documentation, reporting and analysis.
• Appointed as Subject Matter Expert ( SME ) for all Systems and Interfaces between Wells Fargo Advisors and Charles Schwab Brokerages with Wells Fargo Retirement Services.
• Supported the business in all enhancements made to the system from assigned projects by holding training workshops.
• Appointed Brokerage SME for complex interface platforms between Wells Fargo Institutional Retirement & Trust and Charles Schwab Brokerage, Wells Fargo Advisors (WFA) Brokerage, Thompson Reuters BETA Systems (WFA Brokerage Record keeper) and SEI Trust (Trust for Wells Fargo Confidential ) by holding daily meeting with the business pertaining to reconciliation issues of Participant Self Directed Brokerage accounts, tracking and researching production tickets, supporting open issues, monitoring file transmission systems and money movement vehicles between brokerages, tending to ad hoc business analysis requests.
• Worked closely with Project Managers using Microsoft Project and Planview to schedule, track project historical spend and forecast Software Development Lifecycle (SDLC) executive deliverables to meet release deadlines.
• Attended biweekly Project planning, Project Sizing, Release planning and daily Scrum planning meetings to track progress and update the Business and Management on progress and goals set based on the given timeline and deliverable expectations.
• Coordinated Scrum of All Scrums cross-team meetings on large projects that span multiple workgroups and Lines of Business.
• Followed an iterative approach to design and development using Agile Methodology as the preferred SDLC process prescribed by Wells Fargo Confidential IT.

Confidential, Old Tappan NJ 

Business Analyst 

Responsibilities:

• Involved in Project Inception Phase, prepared Vision Statement and Initial Data Models for Business Requirement Document and supporting documents that contain the essential business elements and detailed definitions.
• Assigned the front end digital media design project in the Custom Publishing Group to develop customized programming and user interface for specific colleges.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Gathered User Story, Business Requirements through open-ended discussions, brainstorming sessions and role-playing.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Documented, analyzed and prioritized User Requirements and converted them to system design specifications in DOORS.
• Developed UML Use Cases using Paradigm UML Tool and developed a detailed project plan with emphasis on deliverables.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Planned and defined Use Case Scenarios, created Use Case diagrams and Use Case Narratives using the UML methodologies.
• Created Business Requirement Document (BRD), Functional Specification Design (FSD) document and Change Request (CR) document and requirements tracking with Requirements Traceability Matrix (RTM) for system application development.
• Conducted workshops with the business SME's to perform gap analysis and Risk evaluation and Risk mapping of current system state with proposed process model.
• Worked with Product Implementation team on a weekly basis to identify and translate investor needs into functional and technical specifications.
• Created Mock-ups in MS word and Visio for better visualization and understanding of the proposed software solution.
• Lead multiple project teams, tracked Change Requests and monitored workload and schedule through all phases of the SDLC.
• Utilized Agile/ SCRUM methodology to monitor steer and develop project objectives and deliverables.
• Created class diagrams, ER diagrams, data mapping and logical data models by querying Oracle database to filter data using SQL.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Involved in setting up different configuration environment for Compatibility Testing, Smoke Testing and Unit Testing.
• Upgraded the existing Test Scripts and created new scripts for client application to be able to work for new versions and patches, which improved product quality.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
• Worked on Change requests which involved getting business approval before deployment, making sure that all the test results have been reviewed and getting same implemented in live environment after roll back plan & processes are in place.
• Followed a sequential approach to design and development using Waterfall Methodology as the preferred SDLC process prescribed by Pearson Education EPM.

Confidential, Piscataway NJ

Business Analyst - Internet Team

Responsibilities:

• Gathered requirements, organized team meetings requirements from business users such as insurance policy managers, generated business process models, & use-case models, and created system requirements.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• Constructed Business Requirement Document for phase II of IEEE website redesign and Stage-I implementation.
• Conducted Joint Application Design (JAD) sessions with the participation of the users and the stakeholders to gather functional specifications and designs. Tracked and documented detailed requirements in IBM DOORS.
• Performed IT Architecture data share drives cleanup, redesign, nomenclature setup, best practices and scheduled maintenance.
• Migrated databases into IBM Lotus Quickr application following procedures and steps outlined in the Scope of Conversion document with architect and lead developer for newly acquired infrastructure by cleanup of legacy data storage systems.
• Worked with IT Lead architect to create and develop wireframes and mock-up screens for the defining UI specifications.
• Introduced Oracle MDM product for IEEE Customer Hub data migration, conducted daily meetings with Oracle personnel for product orientation for stage-wise integration of the Oracle MDM into Customer Hub database with extension into Product Hub.
• Created customized SQL reports and queries for management decision-making, operational management and reporting using Collibra BI reporting tool.
• Worked closely with QA testing team for debugging and tracking of issues in test environment before code deployment.
• Facilitated UAT and worked with Mercury Quality Center for pre-implementation bug and defect tracking and resolution.
• Worked effectively with representatives of diverse departments to convey and implement project updates, action plans, tasks and deadlines.

Confidential, NJ 

Business Analyst

Responsibilities:

• Designed new reporting procedures with thorough documentation of scheduled and ad hoc reporting, Business As Usual items, backlogs and weekly status updates.
• Provided technical & Network support to the business by producing thorough documentation of application capabilities and reporting procedures.
• Maintained daily news casts/Campus-Wide-Announcement database, macros to track customer and participant network.
• Created the Technical Requirements Specification document for proposed enhancements to applications that supported tier-2 through tier-5 customer support lines by facilitating workshops with Business Stakeholders and Subject Matter Experts.
• Created the Product Backlog Items (PBI) User Stories; lead PBI Grooming sessions for backlog prioritization and sprint planning for RIB, SIB, Web, Mobile and Tablet application platform projects.
• Created mockups and wireframes using wire framing tool Balsamiq Mockups.
• Performed data analysis by writing complex SQL queries to analyze, consolidate, migrate and reconcile data following business rules from legacy systems to next gen systems utilizing Toad.
• Created Activity Diagrams, Process Flows and Sequence diagrams, Swim Lane Diagrams with UML standards in MS Visio.
• Elucidated requirements for Architecture, Development and Testing in Use Case Specifications and Functional Requirements.
• Reviewed code from Legacy System ASP.NET based application to extract and document business rules.
• Conducted SRS requirements reviews with Business and Development teams.
• Maintained the Requirements Traceability Matrix (RTM) to uniquely trace business requirements to design specifications, to test cases; as proof that requirements have been developed into a solution design that is complete as per the business request and thoroughly tested.
• Maintained continuous telephonic contact with reporting agencies and paper media companies about campus wide events and high level personnel visits.

Confidential, NJ 

IT Support Analyst

Responsibilities:

• Involved in all phases of software development life cycle and created the Business Requirements Definition Document (BRD).
• Contributed in defining the Scope of the project and defined functional specifications following the Waterfall Method.
• Linked requirements to test cases, business rules, design items to maintain traceability.
• Facilitated requirements gathering and BRD development utilizing Use Case narratives and Use Case diagrams using MS Visio.
• Conducted Joint Application Development sessions to finalize system design by locking in specifications for infrastructure reorganization, trading application relocation and performed node optimization analysis adhering to compliance guidelines.
• Wrote User Training manuals to document workstation configurations and reports as part of the future state of the system.
• Used SQL to query the Asset Management database and performed data analysis for documenting data flow via file transmission.
• Extensively used MS SharePoint sites for Technology deliverable archival and collaborative work streams.
• Facilitated project plans including staffing, analysis, development, testing and implementation.
• Worked closely with QA and Development teams to clarify functionality, resolve issues and provided feedback for defect resolution and bugs tracking.
• Responsible for Knowledge Transfer (KT) sessions with Production Support team for systems enhancements and break fixes.

TECHNICAL SKILLS

Reporting Tools & Office Apps: Advanced user of MS Excel, Word and Power Point,:

Visio, Share point, VersionOne, Cognos,:

Collibra, Lotus Notes ProTrac(k), BKFS Applications: (MSP, LoanSphere & Invoice Manager), WySUITE applications (WySTAR, WyGroup, WySecure, WyConnect, NowTrac(k)), Aspen Grove applications (

COSS, TMP, AgentPortal, ClientPortal, iProperty, iVendor, iAgent):

Programming languages and Tools:

Java, C/C++, JavaScript, Angular JS, Ruby, HTML, CSS, JQuery, Raphael, XML, Eclipse, NetBeans, MS SQL, SQL Server Reports,, Unix, .NET, Rails, Git, HP Quality Center, IBM Rational Toolset (ClearQuest, ClearCase, Rational Rose, DOORS, SharePoint, Atlassian JIRA, Atlassian Confluence, Rally BluePrint, PeopleSoft HCM, PuTTy, TOAD, VersionOne, Relational-Databases i.e. Sybase, Oracle DB2 and Apache Cassandra.:

Mathematical & Engineering Simulation Tools:

MATLAB, Maple 7, Electronic Work Bench, OrCAD PSpice:

Data Analysis & Motor Controller Tools:

MATHCAD, Macromedia Flash, Adobe Photoshop, Planview:

SDLC Methodologies:

Agile, Scrum, RUP, Waterfall, mixed iterative approaches: