SUMMARY:

• Total 10 Years of IT Experience, with 7+ years of Data Analyst/ Business System Analyst experience, Extensive experience with domains such as utilities, banking & finance.
• Proficient in Software Development Life Cycle methodologies i.e. Waterfall and Agile, Tableau, Data analysis.
• Expertise in requirement analysis, design, development and testing.
• In depth knowledge about Software Development Life Cycle (SDLC) using Agile and Waterfall
• Experienced in interacting with business users to identify their needs, gathering requirements and authoring Business Requirement Document (BRD), Functional Requirement Document (FRD) and Software Requirement Specification (SRS) across the deliverables of a project
• Conducting Gap Analysis, Business process analysis, SWOT analysis and ROI analysis
• Proficient in conducting Joint Application Development (JAD)and Rapid Application Development (RAD) sessions, Fit/Gap sessions, Brain storming sessions and peer review with IT Groups and project team members
• Experienced in working closely with user experience team to create user friendly UI, based on usability studies, business needs and efficiency
• Experience with end - to-end business process mapping, business and technical requirements analysis, business planning, modeling, verification, methodology and product development
• Competent in transforming business requirements into functional requirements and designing business models using UML diagrams - Use Case diagrams, Activity diagrams, Entity Relationship diagrams, Data flow diagrams and Sequence diagrams
• Experienced in creating Unified Modeling Language models using MS Visio and enterprise architect
• Worked with different business users eliciting business rules and various Functional & Non-Functional requirements
• Involved in development of Test Plan and test cases from functional requirements, technical specification and use cases documents.
• Good database experience using Relational Database Management Systems (RDBMS)and MS Access
• Experience in applying information systems solutions to business problems
• Experience in SQL, Business Intelligence, Data Warehousing and Business Architecture and data mining
• Knowledge of the Scaled Agile Framework (SAFe) and the Atlassian suite, including JIRA, and Confluence
• Experienced working with ETL (Extract, Transform and Load) of data into a data warehouse/data mart and Business Intelligence (BI) tools
• Experienced in designing the Burndown Charts
• Experience in report generation and creating dashboards using SAP Dashboard Designer and SAP Crystal Reports
• Worked on data visualization using Tableau and Infographics
• Experience in Data model, Data visualization, Data warehouse, Data reports
• Proficient in creating Requirements Traceability Matrix (RTM) using BRDs, FRDs and test cases
• Experienced working with project management tools like JIRA and VersionOne to create user stories, generate reports, maintain log for the system, track defects
• User training on the changes being released and conducting post production activities like getting feedback from users. In case of any issues - doing Root Cause Analysis, prioritizing tasks with business users
• Experience in Managing detailed project plans which included resources planning, tasks planning, budgeting, milestones set-up, and performed Gap Analysis, Impact Analysis, SWOT Analysis, Cost Benefit Analysis and Risk Analysis, data Source mapping
• Possess excellent written and verbal communication skills. Responsible, self-motivated
• Developed test plans and test cases according to business requirements and performed User Acceptance Testing (UAT)

SKILL:

SDLC METHODOLOGIES: DOMAIN KNOWLEDGE Agile (SCRUM), Waterfall

Banking, IT systems implementation, Utilities: Gas, Oil & Energy, Construction, Advertising and marketing

MS Office: Word, Excel, Access, PowerPoint, SharePoint MS Project, Outlook, Office 365

BUSINESS PROCESS MODELLING TOOLS: MS Visio, Lucid Chart

BI REPORTING TOOLS: Tableau, Cognos, Power BI, Business Objects

PROGRAMMING LANGUAGES: SQL, R

DOCUMENTATION: Windows, MAC

Multiple regression modelling: RFP, RFI, BRD, FRD, TSD, SOW, RACI, RTM, UAT Plan, Test Plan, Communication Plan, Risk Management Plan, Project Plan, Project Charter, Project Status Report

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Data Analyst

Responsibilities:

• Responsible for gathering User Requirements and Specifications for developing a project plans and documenting the same
• Conducted JAD sessions and Brain Storming Sessions with Stakeholders
• Performed GAP Analysis to get the exact picture of AS-IS state and TO-BE state of the existing legacy system.
• Developed RACI Matrix to create communication plan and maintained it throughout the project
• Created concise deliverables that reflect business needs and data requirements
• Extensively involved in maintaining Requirements Traceability (RTM) and communicating any changes to these requirements to different business groups and programmers
• Designed the Process modelling and Business Process flow diagrams, prepared UML and sequence diagrams using MS Visio
• Performed various analysis such as Document Analysis, Interface, Risk analysis and suggested Action Plans which helped in smooth flow of project
• Used SharePoint to store Artifacts like BRD, FRD, SRS and Test plans etc
• Facilitated Compliance Team meetings and documented the WSLA (Web Service Level Agreement)
• Efficiently handled resource scarcity to implement the Change Request
• Documented the Change Request after performing IMPACT Analysis with adherence to Triple Constraints (Scope, Budget and Duration)
• Facilitated TRIAGE calls between the Development team and QA team to resolve the issues
• Reviewed Test plans, Test cases, Test case execution using specification documents
• Performed Unit Testing for all the functionalities and performed adhoc Smoke Testing.
• Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users.
• Conducted DEMO Sessions with Business before UAT
• Interfaced with business, IT and risk management teams in implementing Archer IT system to automate vendor onboarding process; created Human-Centered design (HCD) artefacts, flow charts, vendor journey maps
• Achieved 5% savings in time using business analytics dashboard reporting on Tableau for VPs; interpreted risk and vendor data points and proposed actionable insights
• Created process flows and processes on Visio to map information flow and vendor journey for various business initiatives; reduced on-boarding time by 10% by process optimization

Environment: Archer, MS Visio, MS Project, Tableau, Windows

Confidential, Boston, MA

Tableau Developer

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Extensive experience in building dashboards using Tableau Desktop and Tableau Server
• Experience in creating and implementing interactive charts, graphs, and other user interface elements
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau Dashboards
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau
• Effectively used data blending, embed functionalities in tableau
• Administered user, user groups, and scheduled instances for reports in Tableau
• Analysed enterprise data to create dashboards, KPI metrics and identify productivity improvements; improved data visibility between various business units and plants
• Identified productivity improvements and financial opportunities for 10 manufacturing facilities in North America by defining should-cost models and conducting vendor negotiations which reduced total cost of ownership of raw materials by 2%

Environment: Tableau Desktop, Tableau Server, SQL, Windows

Confidential, Boston, MA

Data Analyst

Responsibilities:

• Increased profitability by reducing infrastructure requirements by GBP 1.5 million and increasing efficiency of decision-making process
• Developed intricate algorithms based on deep-dive statistical analysis and predictive data modelling that were used to deepen relationships, strengthen longevity and personalize interactions with customers
• Analysed and processed complex data sets using advanced querying, visualization and analytical tools to help organization to increase their sales by 10%
• Created dashboards, reports and graphs for data visualization to driven data quality and presentation
• Utilize various tools to evaluate performance and implement remedies to improve performance, including tuning database parameters and SQL statements
• Analysed customer survey data to assess customer satisfaction, identify gaps in performance and suggest recommendations

Environment: SQL, MS Visio, MS Project, Advanced Excel, Tableau, Windows

Confidential

Senior Business Analyst/Data Analyst

Responsibilities:

• Collaborated with technical teams, business units and clients in gathering business needs and ensuring alignment with development teams
• Translated clients’ requirements from 20 business units into deliverables such as functional specifications, user stories, use cases, process flows and data model diagrams
• Designed Process modelling and Business Process flow diagrams, prepared sequence diagrams
• Performed GAP Analysis to map AS-IS state and TO-BE state of the existing legacy system
• Created concise deliverables that reflect business needs and data requirements
• Identified and reconciled errors in master data to ensure data accuracy and modify data suiting finance needs
• Built and maintained Enterprise Master data from disparate sources; maintained quality by performing data deduplication for reporting and data analysis
• Prepared artifacts Business Requirement Document (BRD) and System Requirement Specification (SRS)
• Developed technical solutions to business problems, Created Vision and Use case documents
• Designed wireframes and mockups and designed the Catalog management process
• Developed Use Cases, Sequence Diagrams, Activity Diagrams, and Class Diagrams.
• Assisted project manager for project management and delivering projects
• Managed technology implementation life cycle in automating conventional financial settlements; defined scope, built models and assisted technical teams during deployment
• Involved in creating a detailed System Test Plans, Test Cases and Test Scripts for different modules of the Application according to the Business Requirements and performed automation testing
• Design robust and scalable test plans for feature components which can be easily incorporated into the overall feature test plans and meet customer requirements with little or no guidance
• Achieved 5% savings in time and $5M cost savings by introducing competitiveness in the tendering process and faster turnaround cycles
• Led internal requirement gathering efforts and aligned them with functional and technical requirements
• Designed process flows suiting different business needs; documented business requirements and resolved issues between development teams and business units
• Created detailed Test Plans from Business Requirements/Specifications for QA and User group
• Collaborate with cross functional teams and build schedules and plans, Identify and manage dependencies with other internal or external teams to align deliverables

Environment: Advanced Excel, EDMS, MS PowerPoint, MS Project, MS Visio, MS Outlook