SUMMARY

• 4 years experience Business analyst professional with strong verbal and written communication skills & solid analytical skills using Agile (scrum / Kanban) technique in an SDLC environment.
• 4 years creating Business Required Documents (BRD), writing a user story, meeting coordination & creating dashboard/graphical reports.
• 4 years experience using Jira, service now, Splunk, SharePoint, salesforce, testing (UAT), migration, Visio, AWS, troubleshooting incidents, and Office 365.
• 4 years Leading Requirement gathering Sessions, Business processes modeling - AS IS and TO BE, Gap Analysis, report delivery designs, QA/UAT, and deployment
• 4 years’ experience in SQL Bi developer + scripting and 2016 SSMS developer with core knowledge of SSIS and SSAS and SSRS. 4 years ETL/SQL in Developing, Analyzing, Designing, and Reporting using Microsoft SSMS versions and Microsoft Visual Studio (SSIS and SSRS) for designing packages, triggers, and indexes.
• Experience in handling different types of data like OLTP, OLAP, Excel, XML, CSV, and Flat file for data integration operations & 4 years of experience writing user stories.
• Frequent use of cross-tab, conditional, drill-down, drill-through, subreports, Ad hoc reports, parameterized reports, interactive reports & custom reports in SSRS.
• Experience working with SharePoint 2010, and Atlassian Jira for reporting services integration, with a focus on creating reports in Visual Studio.
• 2 years’ experience using Tableau, power bi, and SSRS & 4 years experience in Office 365 (Excel, Visio, Word, etc.) using Agile (Scrum) methodology over 4 years of overall IT experience.
• 3 years experience of marketing data collecting data on competitors marketing tactics,sales prices and product/service distribution.gather and analyze and data related to market conditions and consumer demographics .research customers, opinions,buying habits, preferences, wants and needs
• Great team player, fast learner, and self-starter. Motivated, Agile, efficient, and trainable.
• Working knowledge on DDL, DML activities on DB, and Object level.
• Experience with ETL tools (SSIS)
• Excellent planning skills and communicating product vision and goals to ensure team understanding using Jira
• Proactive creating reports to drive planning requirements to drive continuous improvement

TECHNICAL SKILLS

• MS-SQL Server . Oracle 10g DBMS Office Suite
• MS Project/MS Visio
• SharePoint
• SIX SIGMA
• SCRUM
• SQL Visual Studio
• SQL Management Studio
• Oracle RDBMS
• JIRA
• SAP Agile (scrum/Kanban) & waterfall methodologies
• Use Case/User Stories
• Requirement Gathering
• Project Methodologies
• Program/Project Planning
• Quality Assurance/UAT
• Data/Business Process Flows & regression testing.
• Great team player fast learner and self-starter.
• Agile efficient and trainable.
• Designing data/Business Process Flows using Visio
• Pay high attention to details
• Creating dashboards pivot tables & graph reports using Excel
• PowerPoint
• Word
• Splunk & tableau.
• Version one and Kanban board.
• MS-SQL Server . Oracle 10g DBMS
• SQL Server Integration Services
• Data Analysis/Transformation Services and SSRS
• MS Office Suite
• MS Project/MS Visio
• SharePoint
• SIX SIGMA
• SCRUM
• SQL Visual Studio
• SQL Management Studio
• Oracle RDBMS
• JIRA
• SAP
• Agile (scrum/Kanban) & waterfall methodologies
• Use Case/User Stories
• Requirement Gathering
• Project Methodologies
• Program/Project Planning
• Quality Assurance/UAT
• Data/Business Process Flows & regression testing.

PROFESSIONAL EXPERIENCE

Confidential

Business Data Analyst

Responsibilities:

• Performed data analysis and validation, responsible for gathering and documenting business requirements,
• Assisted with coordinating User Acceptance Testing.
• Performed business processes analysis, met business process needs, and translated functional requirements into technical specifications.
• Performed detailed design, customization, and implementation of IT solutions that meet/exceed business requirements.
• Actively participated in workshops, and meetings with process stakeholders/product owners to understand as-is processes and to design to-be processes.
• Provided operational analysis of business units by analyzing performance metrics and business results.
• Use strategic thinking and processes to determine the business needs. Partnered with internal groups to implement solutions.
• Data Collection, Event Analysis and Information Reporting.
• Handle day-to-day triage, investigation, and mitigation of security threats, as well as short-notice ad hoc work.
• Work with business analyst groups to ascertain their database reporting needs.
• Take the database reporting needs and turn them into powerful SQL queries that will extract data and compile it into meaningful reports using MS Sql 2016 as well as configuring web browser using HTML.
• Performed data loads and routine updates on an ongoing basis.
• Administrating MS SharePoint & high proficiency in CRM tools and Microsoft Excel.
• Pull data from multiple systems and sources for analysis and reporting that drives decisions, operations, and translates into revenue opportunities and growth.
• Managed multiple projects at one time, using Agile methodology and ITIL framework.
• Provided reporting solutions and respond to ad-hoc report requests across multiple business areas.
• Participated in the design and development of business intelligence reporting tools.
• Stayed updated on ticket status in Spa box (outlook), service now & Jira board.
• Served as the initial contact person for all SQL support queries.
• Performed updates to the SQL system as assigned by management.
• Collaborated with business support professionals to provide full system maintenance using ITIL framework.
• Improved the experience of software users by soliciting feedback and making software improvements.
• Supported code activations and updated business tool applications per company requirements.

Confidential

Senior Data Analyst

Responsibilities:

• Constantly determined and translated business requirements into solutions by defining comprehensive stories for system and process enhancement changes.
• Partnering with Product Management and key stakeholders to foster innovation by translating rough business requirements into tangible, easy-to-understand user stories.
• Responsible for scheduling and leading meetings to provide architectural solutions & preliminary design, analysis, planning, implementation, and operations of the application.
• Created Workflow Business Diagram using Mockup and Microsoft Visio
• Worked on Libraries, Communications, Tracking, custom list, and web pages for MS SharePoint.
• Created Business Requirement document (BRD) and Functional Requirement document and maintained the Requirement Traceability Matrix (RTM) related document.
• Integrated business solutions with organizational goals while reaching a consensus among the stakeholders.
• Analyzed quantitative and qualitative business data to develop a solution design capable of fulfilling the customer's
• Created presentations in a concise & well-researched manner on new product feature ideas & opportunities by collaborating with product owners.
• Mentored and trained a group of approximately 7 Business Analysts on the organizations evolving approach to requirements management and best practice.
• Create ad hoc reports, and coordinate backlogs grooming using JIRA & Kanban board.
• Take ownership of the product backlogs, demo & participate/organize in daily standups.
• Create weekly dashboard reports using Excel, Tableau, word, and PowerPoint compiling production issue trends (Incidents) to drive continuous improvement and drive down re-occurring incidents.
• Interviewed business clients to analyze their business requirements and recommend and design technological improvements to their business processes and operational procedures.
• Perform day to day tasks with Office 365, MS Word/Excel/Access/SharePoint, Ms SQL 2016, Data Analysis, and Data Entry, Ms Viso, Statistical Analysis using SAS and SQL Databases.
• Design, build and deploy data, financial and accounting BI solutions (e.g. reporting tools).
• Applied best Agile (Kanban) practices and modern techniques to improve existing schemas for performance and efficiency.
• Experience in ETL & Data Warehousing concepts and incremental loads.
• Experience inimporting/exportingdata between different sources usingSSIS/DTS utility.
• Transformed data from one server to other servers using tools like, and SQL Server Integration ETL Services (SSIS) (2016/2017).
• Experience in creating configuration files to deploy theSSISpackages across all environments.
• SQL Query/SSIS Package optimization, performance tuning, common table expression, Windows function.
• Maintain and support data analytics platforms, translate business needs to technical specifications, develop dashboard reports from relational databases, and create tools to store data (e.g. OLAP cubes).
• Responsible for testing, data validation, and verification.
• Maintaining and handling different type of data like OLTP, OLAP, Excel, XML, CSV, and Flat file for data integration operations & writing user story
• Evaluated and improve existing BI systems, develop and execute database queries and conduct analyses, as well as perform unit testing and troubleshooting.
• Collaborate with teams to integrate systems, create visualizations and reports for requested projects, and develop and update technical documentation.
• Analyze available data, work with business users to gather specifications for data and report requirements, identify data sources to extract business information for reporting purposes, and identify and recommend best sources for building reports.
• Identified best practices and recommend enhancements to communicate metrics through dashboards and coordinate with the business team on additional data marts to support dashboard reporting, including coordination of data validation with business users.
• Designs complex reports to validate the synchronization of the application with other applications, including the customer information system, asset management system, and mobile workforce management system.
• Designs complex reports to monitor and analyze assets, events, communications, energy, service orders, customer information, and other related data.
• Designs complex reports to validate market exceptions related to daily processes.
• Experience in data-based performance management
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Adept at queries, report writing, and presenting findings.
• Analyzed requirements, developed technical design specifications, and developed applications utilizing MS BI Stack. Experienced in engaging with end-users to discern their data consumption and reporting needs.
• Created Dashboards using power Bi and used Dax for calculations.
• Use of Jira for team sprints and projects.
• Conducting detailed risk assessments by analyzing documents, statistics, reports, and market trends.

Confidential

Business Data analyst

Responsibilities:

• Conducted business process analysis and requirements gathering sessions with developers/stakeholders.
• Developed user stories and functional requirement specifications for various web applications using JIRA.
• Managed, prioritized, and assessed the impact of all work items, such as new features, defects, etc., including providing the decision to create, fix or defer at the project level.
• Defined configuration specifications and business analysis requirements.
• Provided SharePoint support and Administration
• Perform quality assurance (UAT).
• Defined and documented reporting and alerting requirements.
• Developed a relationship with partners, working with them to optimize and enhance our integration.
• Perform day-to-day tasks with Office 365, MS Word/Excel/Access/SharePoint, Ms. SQL 2014, Data Analysis, Data Entry, Ms. Viso, and Statistical Analysis using SAS.
• Create, maintain, and support SSIS packages to move data in and out of the custom-built database.
• Write/Analyze/TroubleshootTSQL queries, stored procedures, functions, and views.
• Create, maintain, and support SSRS reporting for end users.
• Analyze and troubleshoot data issues within applications/feeds.
• Gathers, extracts, manipulates, analyzes, and models data using analytical and statistical tools.
• Identifies new sources of data and methods to improve data collection, analysis, and reporting.
• Interpret, analyze, and present the analysis of the results related to order fallout.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Filter and “clean” data by reviewing reports and performance indicators to locate and correct code problems.
• Interpret data, analyze results using statistical techniques and provide ongoing reports.
• Prepare executive-level presentations to highlight insights and opportunities.
• Acquire data from primary or secondary data sources and maintain databases/data systems.
• Work with management to prioritize business and information needs.
• Locate and define new process improvement opportunities.
• Use of Jira within the team for project sprints.
• Applied best Agile (scrum) practices and modern techniques to improve existing schemas for performance and efficiency.

Confidential

Business Analyst / Data Analyst

Responsibilities:

• Perform day-to-day tasks with Office 365, MS Word/Excel/Access/SharePoint, Ms. SQL 2014, Data Analysis, and Data Entry, Ms. Viso, Statistical Analysis using SAS. Create, maintain, and support SSIS packages to move data in and out of the custom-built database.
• Write/Analyze/TroubleshootTSQL queries, stored procedures, functions, and views.
• Create, maintain, and support SSRS reporting for end users.
• Analyze and troubleshoot data issues within applications/feeds.
• Gathers, extracts, manipulates, analyzes, and models data using analytical and statistical tools.
• Identifies new sources of data and methods to improve data collection, analysis, and reporting.
• Interpret, analyze, and present the results analysis related to order fallout.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Filter and “clean” data by reviewing reports and performance indicators to locate and correct code problems.
• Interpret data, analyze results using statistical techniques and provide ongoing reports.
• Prepare executive-level presentations to highlight insights and opportunities.
• Acquire data from primary or secondary data sources and maintain databases/data systems.
• Work with management to prioritize business and information needs.
• Locate and define new process improvement opportunities.
• Use of Jira within the team for project sprints.
• Demonstrated reporting skills in Business Objects and Excel, Created Dashboard in MS Excel, VBA, and Macro Working Knowledge.
• Pull data from multiple systems and sources for analysis and reporting that drives decisions, perations, and translates into revenue opportunities and growth.
• Managed multiple projects at one time, using Agile methodology and ITIL framework.
• Provided reporting solutions and respond to ad-hoc report requests across multiple business areas.
• Participated in the design and development of business intelligence reporting tools.
• Stayed updated on ticket status in Spa box (outlook), service now & Jira board.
• Served as the initial contact person for all SQL support queries.
• Performed updates to the SQL system as assigned by management.
• • Collaborated with business support professionals to provide full system maintenance using ITIL framework.
• Improved the experience of software users by soliciting feedback and making software improvements.
• Supported code activations and updated business tool applications per company requirements.
• Building, and publishing customized interactive reports and dashboards, and report scheduling using the Tableau server.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Experience and proficiency with various programming languages
• Understand human behavior and know what to look for in the data.
• Communicate concisely and persuasively with engineers and product marketers.
• Helps identify ways to improve data quality and analysis.
• Designs, codes, and tests all sizes of application solutions using object-oriented development, with a current focus on Python
• Independently documents own code and produce technical design documentation.
• Resolves complex software issues across multiple software applications.