SUMMARY:

• MIS Professional with 10 plus years of experience in the IT industry as a Sr. Business Analyst in the Project Management Office (PMO) in Agile and Waterfall environment spanning multiple web based projects across different Industry Verticals (Mortgage, Finance, Telecom, Sales).
• Certified in UML and OO concepts and Business Process Notation Modeling at an advanced masters level. On track for PMP Certification.
• Experience with Mortgage Industry standards, Mortgage underwriting process and Securities management business processes.
• Experience in SOX controls for IT remediation and audit procedures implementation.
• Experience in data validation, data upgrade and data conversion and working on business data using SQL queries in TOAD and Oracle SQL developer.
• Experience in Business Intelligence, data mining and data analysis in projects involving cross function and cross businesses processes.
• Experience in Business Use Case models, Activity Diagrams, UML Business Analysis Model, Rational Unified Process (RUP), Joint Application Design (JAD)
• Project Life Cycle experience using different development methodologies, UML, OO, Waterfall, Iterative, JAD.
• Familiarity with SDLC Methodologies, eRoadMap, RUP, Waterfall, Iterative models.
• Experience in large Data Conversion projects for EDW (Enterprise Data Warehouse) involving cross function and cross businesses processes.
• Advanced knowledge in generating Top Management reports using Excel Pivot Tables and creating reports using MS - Excel ODBC to connect to external data sources.
• Experience in Salesforce administration and creating page layouts, dashboards, visualizations
• Advanced knowledge of MS-Word, MS-Excel, SQL and Office productivity tools.

TECHNICAL SKILLS:

Verticals: Financial Services, Federal, Mortgage Industry, Telecommunications, Sales and Marketing.

CRM Technologies: Siebel 7, PeopleSoft 8, Salesforce administration

Operating Systems: WindowsNT/2000, UNIX based OS.

DBMS: Oracle, SQL Server, ER mapping, Workflows & Swimlanes for Process Mapping

Methodologies & Tools: UML, DOORS, SDLC, TOAD, Oracle Sql Developer, JAD sessions, Business Process Modeling, Data Modeling, Business Objects.

Office productivity: MS-Word, MS-Excel, Access (MS-Office Suite), Visio 2003, MS-Project, MS-Outlook

Open Source & Programming: GitHub, Selenium, Cucumber, JavaScript, Java, Ruby, Python, Shell scripting, Continuous Integration, DevOps, Glassfish, MongoDB, Hadoop HIVE-QL, JMeter.

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Sr. Business Analyst

• Define business requirements and functional specifications in Agile and SDLC environments
• Gathered, Analyzed and Documented stakeholder requirements for data analytics solution
• Support data warehouse requirements by creating technical solution concepts
• Provided presentations to top management on the functional and business requirements as needed
• Created and worked with JIRA, Confluence and SharePoint for Content Management
• Created data models to collect, define and generate performance metric dashboards
• Developed system use cases for Software as Service based authentication models
• Integrated with external vendor systems to enable cross function analysis as part of compute cluster
• Created Business process flow documentation to capture as-is and to-be process in order to re-engineer the existing manual data entry process
• Cross functional collaboration with Product team, PMO team, Development, Operations and Support team to deliver time critical project deliverables on-time and within budget.
• Delivered documentation on NIST standards and policies implementation as well as FISMA for audit and compliance regulatory framework
• Worked with Linux based OS to perform backend API testing using shell scripts
• Contributed as a scrum master in an Agile environment to generate and analyze user stories and track progress
• Worked closely with Project Managers, QA and Developers to facilitate deployments at end of sprint milestones
• Extensive use of SQL queries to test and verify data migration after a legacy to enterprise data migration activity to validate data
• Automated tests using Selenium Webdriver for UI automation, utilized JIRA for defect tracking
• RestFul API documentation and testing for API using JMeter as part of P&S testing.
• Assisted in SOX and Compliance audit controls for the project from data access and retention policies.
• Worked with Tableau and OBIEE using Data from HADOOP cluster and other multiple data sources for Data Analytics and analysis on Forecasting key business metrics.
• Worked on DW Analytics and Data Intelligence for generating business forecasting models and reporting using a combination of internal data and social media content from Facebook, Twitter, Bitly data sources.
• Worked with HADOOP and Big Data infrastructure to provide algorithms for MapReduce and generated analytical reporting.
• Worked on projects for C-level management reporting and delivered analysis reports within the timelines.
• Created technical specifications documentation and solution design documentation for Data Analytics. Utilized Business objects, Excel Pivot tables to create management reports
• Conducted data modeling and mapping exercise for ~150 plus data points and validated with Python scripting

Confidential, Reston, VA

Sr. Systems Analyst

• Engaged in requirements gathering session with business users and program sponsors
• Developed prototypes for User Interface in order to obtain buy-in from stakeholders
• Created and managed functional specifications documentation
• Key presenter at stakeholder meetings to provide demos and review of prototypes
• Created systems specification document and high level design documentation
• Created SQL queries to measure progress and validate the data points for HAMP treasury reporting
• Created system use cases, activity diagrams and sequence diagrams as part of UML documentation
• Created mapping spreadsheets for Reports, Error Messages and Business Rules in Loan Delivery application
• Utilized DOORS, Requisite Pro and Visio including MS-Office as primary office productivity tools to generate high quality project deliverables.

Confidential, Herndon, VA

Sr. Business Analyst (Lead)

• Prototyped, conceptualized and assisted in electronic implementation for data collection and data analysis for ARRA (American Recovery and Reinvestment Act) - 2009 Federal Program
• Acted as lead for a team of three junior level business analysts in a mentoring role and providing guidance
• Created requirements documentation and functional specifications for business users and development team
• Created system implementation specific artifacts to communicate the business and design decisions to team
• Developed a unique methodology for extracting functional and non functional requirements from business process
• Mentored junior and associate business analysts to accomplish their project analysis work.
• Acted as the SME (Subject Matter Expert) for four major subsystems by providing functional support to the business team and technical design level support to the development team
• Created executive management level reports from the existing data within the application using basic SQL
• Created Excel pivot tables and complicated reports as part of top management dashboard reports from a large multi-sheet spreadsheet
• Generated and maintained SQL server queries to validate application generated reports against actual expected values.

Confidential, Reston, VA

Sr. Business Analyst

• Analyzed existing system functionality and documented Use Cases for the business functionality.
• Conducted requirements and design meetings to discuss and finalize the object interfaces and components
• Created and executed ad-hoc queries to extract reports for project manager and the team.
• Performed GAP Analysis to identify items of conformance with existing Business Processes
• Created and maintained requirements documentation within DOORS and uploaded on TWiKi.
• Provided support to QA test team in implementing and executing UAT Test scripts.
• Utilized TOAD to create and execute SQL queries as part of 1003 case file data validation testing
• Analyzed Mercury Quality Center defects, categorized defects in Quality Center tool for tracking and consolidating defects
• Created SOX IT remediation documentation for SOD and L&M procedures (Fannie’s SDLC processes).
• Communicated with Business customers and external vendors for Integration related requirements.
• Worked on Business Process Reengineering project to streamline software change management process.
• Updated XML DTD resource definitions to provide additional data elements as per Integration needs.
• Provided production support work to aid assist in new enhancements and system upgrades.

Confidential, Florida

Business Analyst (Lead)

• Full Life Cycle experience developing OO function specifications, system specifications and creation of test cases for System acceptance testing
• Engage in requirement gathering process for object oriented (OO) interfaces and object reuse from the business user community through SRS (software requirement specifications) sessions
• Performed exhaustive process mapping exercise to detail the individual business processes within the healthcare underwriting business
• Extensively worked with Visio to produce specification documents that helped the project team to create design documentation for the reporting requirements.
• Managed frequent changes to the requirements using a structured approach to analyze, evaluate and adopt changes/new requirements within the existing scope.
• Involved in performing system testing and acceptance testing for the developed reports along with change control and issue resolutions.
• Mentored junior member of development and QA team to establish standards of excellency.

Confidential, NYC

Business Analyst

• Extensive use of MS-Office and Visio for creating software architecture documentation.
• Performing Requirement analysis and creation of UML system configuration specifications as needed using DOORS.
• Performing GAP Analysis with existing vanilla functionality and new Business Processes
• Tracking requirements and tracing function specifications to workflow processes.
• Gathering requirements for Insurance Claims Processing automation system and mapping the business process to create documentation on workflows
• Conduct JAD working session and providing timely reports to top management using MS-Office based Reporting tools.
• UML Modeling and RUP process using Visio for productivity in communicating specifications to design & development team.
• Documenting business process specifications using Workflows and Swim lanes. Visio used extensively for flow-charting processes and Process Reengineering.
• Managing document repository for tracking and traceability of all software artifacts.
• Implementing best practices for Configuration Management/Change Methodology.
• Data mapping and loading sequence for integration with Insurance and Annuity Legacy Systems.

Confidential, NYC

Business Analyst

• Large Scale implementation of Sales and Servicing Modules across Financial Centers Nationwide for Credit Card division.
• Conducted GAP Analysis sessions with Credit Risk Management team to identify and freeze requirements.
• Analyzed and Clarified Risk Management System requirements for all Sales Management Use Cases to Technical teams.
• Developed UML artifacts like Activity, Sequence, and Class diagrams for each use case.
• Configured user profiles and updated financial centers data into PeopleSoft tables.
• Performed data upgrade, data validation and data scrubbing to load as part of nightly process
• Interacted and Communicated with business and design teams for process flow mapping of existing systems.
• Extensive use of Visio Diagramming tool to develop UML and Swimlanes Interaction diagrams.
• Developed detailed functional specifications for use cases.
• Worked on fine-tuning System Specifications Process and SDLC for Technology Services group.
• Contributed to Integration Design decisions in developing End-to-End design principles.
• Performed Data Mapping exercise for XML based integration with Mortgage System, and Investment & Insurance System
• Revised the Data Model to accommodate Prior Software Release Architecture for compatibility.
• Architecture enhancement to existing system in order to accommodate future use cases.
• Extensive documentation of technical and functional specifications as part of communication to the offshore and onsite development team.
• Created as-is and should-be process using Workflows & Swimlanes.
• Performed functionality testing using Mercury Test tools across environments as per code migration schedules, used ClearQuest tool for defect and change tracking.