SUMMARY:

• An experienced, disciplined, highly technical, versatile and innovative Business Analyst with around 9 years’ experience in gathering and analyzing complex data, supporting business solution software and analyzing business operations.
• Aiming to utilize my strong prioritization skills and analytical ability to achieve the goals of your company.

TECHNICAL SKILLS:

• Microsoft Windows
• SQL Server
• Java
• .NET
• MS Project
• Access
• Word
• Excel
• PowerPoint
• SharePoint
• WebEx Meeting
• Microsoft Dynamics CRM
• Advanced Excel Modeling (Macros
• V - lookup
• Excel- VBA
• Pivot Tables)
• SQL
• MySQL
• ETL
• Python
• Pandas
• Tableau
• Jupyter Notebook
• MatPlotLib
• GitHub
• MongoDB
• Java xml
• HTML
• Familiar with UNIX commands & shell scripting
• Enterprise Architect
• Caliber
• Innovator
• MS Visio
• Rational Requisite Pro
• Axure RP
• BluePrint
• Microsoft Power BI
• Magento Enterprise Edition
• Wiki documentation
• Agile JIRA (JQL )HP QC (ALM)
• SPIRA
• Confluence
• Microsoft TFS
• Soap UI
• XML
• RESTful API
• Slack
• Jenkins/Hudson application that monitors executions of repeated jobs such as build.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Business Analyst

Environment: Agile, Microsoft Dynamics® CRM 2015(7.0.2.53),MS - Office Suite 2013, Advanced Excel Modeling, Microsoft Visio 2013, Microsoft Visual Studio 2015, Microsoft TFS 2015, Microsoft SQL server 2012, SSIS packages,MS-Access,.NET, Documentum Administrator 6.7; PicPick version 4.0.8, SnagIt 8

• Assisted the Project Manager with various projects for Confidential from strategic planning to tactical activities, ranging from concept to closure.
• Analyze client’s business, data requirements and processes through document analysis, interviews, workshops, and workflow analysis, Document findings and decisions, prepared meeting minutes.
• Developed the Business Requirement documents (BRD), translate business requirements into functional requirements (FR). Wrote user stories in GWT (Given-When-Then) format for TO-BE process.
• Collaborate with the business and the technology teams to help define requirements for the project, identify data dependencies and/or relationships to help develop logical data models, create data flow, process flow, and system activity diagrams using MS Visio and Mock-up screens using Axure Pro.
• Creating project specific artifacts including Meeting Notes, User Stories, Business Requirement Documents, and User Story Elaboration, using Team Foundation Server (TFS).
• Used SQL and MS Excel to Map and extract Data based on the customer needs and requirements and prepared Data Mapping Documents for specific requirements of the customer.
• Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2012 environment. Created Data-Dictionaries to handle the data fields from AS-IS to TO-BE businesses.
• Hands on experience in using VBA with Advanced Excel for creating reports, macros, pivot tables.
• Worked extensively with Business and technical team to come up with a good data model considering datasets from different City Agencies.
• Participated in sprint planning, daily scrums, testing, retrospectives and sprint reviews. Led daily standup meetings.
• Facilitated "three amigos" work sessions between developers, product owners and business analysts.
• Worked extensively with DOB team members to understand the logics and conditions of the existing excel reports that they were using and reproduced it to necessary technical documents for the technical team to understand the same.
• Participated in creating logical and physical data models, their enhancement. Based on the data models, worked with business architect, to create the software solution models.
• Helped in creating of Data-Mapping best practices document including visual processes and trained team members on Data Mapping process and tool. Mapped the data from industry portal to Microsoft Dynamics CRM system.
• Facilitated UAT session on developed modules of the project to ensure a timely implementation and developed User Acceptance Test (UAT) plans, test cases, and performed UAT testing.
• Provided weekend, overnight, on-call support, production testing and support of applications, escalation coverage, when needed.

Confidential, Pennington, NJ

Sr. Agile Business Analyst

Environment: Agile, MS - Office Suite 2013, Advanced Excel Modeling, Microsoft Project, JIRA, MS-Visio, Axure Pro, Java, SQL and XML, Data Governance, Tableau, Blueprint- Requirement center tool, SharePoint, HPQC(ALM)

• Effectively elicited requirements from stake holders and facilitated communication between Business and the Technical team
• Create and manage internal and external communication initiatives across business lines and clients
• Involved in UI requirements and creating Wireframes to help developers build the application
• Assisted in analyzing the various data feeds from different sources upstream and downstream
• Manage SharePoint repository for all project deliverables and use SharePoint to ensure all team members have easy access to all documents created.
• Developed UML diagrams like Use Cases Diagram, Activity Diagram and Process Flow Diagram using MS VISIO.
• Designed Data flow diagram, managed as is process v/s to be process requirements using Blueprint Requirements center.
• Created test cases to test the liability, comprehensive, collision coverages.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Responsible for developing prototype designs, demonstrating them to project stake holders and gathering their feedback to improve and progress.
• Documented and analyzed SQL queries against various databases and generate reports as per company requirements and exporting to Excel for presentation to upper management.
• Created adhoc reports on Tableau to determine campaign spend based on impressions, ad type, publisher type, and device type.
• Played a key role in the planning, testing, and implementation of the new enhancements and conversions.

Confidential, New York, NY

Business Analyst

Environment: Agile & Waterfall, Microsoft Office Suite, Microsoft Project, SharePoint, JIRA, MS-Visio, Axure Pro, Java, SQL.

• Develop business architecture using requirements such as scope, processes, alternatives, and risks.
• Analyze client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Communicate client’s business requirements by constructing easy-to-understand data and process models.
• Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Liaise between business and technical personnel to ensure a mutual understanding of processes and applications
• Performed Data Analysis and Data validation by writing basic SQL queries on the database.
• Assisted quality assurance team in testing different releases and in designing test plans and test cases. Performed User Acceptance Testing (UAT) and System Integration Testing (SIT).

Confidential, Matawan, NJ

Agile Business Analyst / QA Lead

Environment: Agile methodology, Waterfall / Structured Systems Analysis and Design Method (SSADM) Microsoft Office Suite, Microsoft Project, SharePoint, JIRA, MS-Visio, Axure Pro, Java, XML, Soap UI, and Web services API, ETL testing, SQL, Flat Files.

Agile Business Analyst

• Identify gaps in existing processes and implement new processes for overall business efficiency using Agile Methodology.
• Consistently and successfully delivered more than 25 Talent platform projects in Web based environment, in addition to enhancements, Quarterly Maintenance Releases and third Party applications in a timely fashion.
• Collaborate with both HR Business Partners and Corporate Trainers to streamline the onboarding process and ensure a quality onboarding experience for candidates
• Defined the process methodology and evaluated processes systematically to determine the effectiveness of current operational activities and identify areas of opportunity.
• Led system integrations with third party vendors such as Tracker I-9, Job Post.
• Led requirements development sessions to ensure the delivery of verified and validated functionality.
• Responsible for ensuring quality aspects into the product with good understanding of business/end-user needs & ensuring features are built with acceptable design.
• Extensively used Microsoft Office applications for day-to-day activities business requirement documentation, user manuals, system guides, presentations, data analysis, pivot tables and prioritizing and managing individual tasks. Hands on experience in using VBA with Excel for creating reports, macros etc.
• Worked with project manager to facilitate project WBS and logic diagram, resource allocation and loading, creating and maintaining schedules, and providing key project tracking data.
• Facilitated Post Production Validation and actively participated in production call support whenever necessary.

Agile QA Analyst

• Strong experience creating concise and clear reports for distribution and presentation to senior management on a weekly basis. Experience monitoring and tracking implementation plans.
• Expertise testing the HR systems (Talent Acquisition and Talent Management) on data driven testing and routine enhancements that were used towards HR processing to test the application functionality on UI.
• Experience in loading from various data sources like, Fixed Width and Delimited Flat Files.
• Single handedly owned, operated and upgraded test environments for entire QA group for nearly forty versions of the product implemented and or upgraded to clients on a continuous basis. Responsible for migrating and mock upgrading all clients’ databases on QA test databases, to ensure clients are successfully getting upgraded to new release version.