TECHNICAL SKILLS

Operating Systems: MS - DOS, Windows XP, Windows Vista, Windows 7.

Network: Basic knowledge of TCP/IP, Wireless, Routers, DHCP, DNS and Security.

Applications: Microsoft Word 2010, Microsoft Excel 2010, Microsoft Access 2010, Microsoft Power Point, Microsoft Publisher and Microsoft outlook, Microsoft Visio, MS Project, Project Libre, Outsystem Application UI UI MockUp

Programming Languages: MATLAB, R, SQL, Python, VBA, Vb.net, C#

PROFESSIONAL EXPERIENCE

Confidential, NY

Business System Analyst/Data analyst

Responsibilities:

• Followed the AGILE methodology for the entire “SDLC” in Scrum Environment.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Forecasted budgets based on Insurance policies
• Migrated the data from old billing system to new billing system
• Migrated the Data from Dev Environment to Production Environment
• Created user guides for the business and implement the Procedures
• Created budget and plan it for the upcoming projects
• Write XML and JSON file for verifications of data input and output
• Created project plans and timelines and estimates for the upcoming projects in pipeline
• Prepared detailed Functional and Technical Design Specifications for the Reports
• Loaded data from flat files and numerous relational database systems using SQL and ODBC for data load performance gains optimized data load rules by sorting and arranging sparse dimension columns.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules
• Explore data on SSMS for SQL for Reporting
• Created reports using Power BI and Created Dashboard with incoming ticketing data

Confidential

Business System Analyst/Data analyst

Responsibilities:

• Followed the AGILE methodology for the entire “SDLC” in Scrum Environment.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Prepared detailed Functional and Technical Design Specifications for the Reports
• Loaded data from flat files and numerous relational database systems using SQL and ODBC for data load performance gains optimized data load rules by sorting and arranging sparse dimension columns.
• Develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules
• Created reports using Power BI and Created Dashboard with incoming ticketing data

Confidential

Business Analyst

Responsibilities:

• Automated the Manual Business policies and processes with agile methodology
• Implementation of the new Customer Information system (CIS) and billing system
• Create pivot tables and modify spreadsheets to achieve analytical goals.
• Create and Designed, recorded, and executed VBA macros to automate manual task
• Thoroughly studied the requirements for the process re - engineering
• Write queries to find missing or Bad for data cleansing to Implement for new CIS system
• Created reports using Tableau 10 with clean data
• Explore data on SSMS for SQL for Reporting
• Conducted and documented ROI and ROM for various contract management systems implementations
• Conducted extensive requirement analysis
• Facilitated research into the existing issue
• Expertise of UML in visualizing and documenting the artifacts using Use Cases, Use Case Diagrams, Activity diagrams, Class diagrams, Data Flow Diagrams, Business Flow Diagrams, Sequence Diagrams using MS Visio
• Helped the team to evaluate various IT products
• Understood and documented the requirements for the integration with the intranet portal.
• Designed and managed specific modules of the solution
• Used MS project for resource allocation and time management
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Sparx and Balsamiq
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents in confluence.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Confidential

Business Analyst /Report Developer

Responsibilities:

• Worked closely with the Business to clearly articulate and define the end to end Reporting Requirements for the Webi Reports,
• Prepared detailed Functional and Technical Design Specifications for the Reports
• Loaded data from flat files and numerous relational database systems using SQL and ODBC for data load performance gains optimized data load rules by sorting and arranging sparse dimension columns.
• Provide technical support to resolve Production issues involving Web Intelligence Reports. Interaction with the Business Analysts, users and business leads to understand Business needs.
• Creation and testing of complex reports and documentation of test cases and report specifications. Drill down the Analytics to the detail level data by a Web Intelligence Report.
• Involved in the extensive standards & guidelines documentation. Created Derived tables in the Designer to enhance performance of the universe.
• Loaded data from flat files and numerous relational database systems using SQL and ODBC for data load performance gains optimized data load rules by sorting and arranging sparse dimension columns.
• Resolved issues related to RDBMS flaws such as Fan Trap, Chasm Trap using BO multi parse SQL functionality. Created new stored procedures in SQL server 2012, MS SQL 2014.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements
• Created programs based on reports with python and C#
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.

Confidential

Technical Support/Customer Support

Responsibilities:

• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Interaction with Primary markets, Secondary markets and mortgage backed securities and asset backed securities for requirement gathering.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Used SQL Server Management Tool to check the data in the database as compared to the requirement given
• Responsible for performing Functional, Regression and User Acceptance testing on enhancements made to the Empower loan origination system
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Followed the AGILE methodology for the entire “SDLC”.
• Process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution.
• Competent in using business intelligence tools of enterprise resource planning, online analytical processing, data mining, etc
• Maintain JIRA application Backlog; Prioritize issues & highlight stakeholder risk
• Analyzed and translated systems requirements into system specifications utilizing UML and RUP methodology