SUMMARY

• Proactive professional with experience serving in multi - faceted roles of Business Intelligence / Business Data Analyst, Business System Analyst, BI Reporting Analyst, Acting Scrum Master.
• Passionate for advanced analytics and data science.
• In depth understanding of Project Management Life Cycle and Project Life Cycle Methodologies.
• Working in SDLC Methodologies like Waterfall, Scrum-Waterfall Hybrid, Agile Philosophy like Scrum, Kanban.
• Worked in cross functional teams and business unit owners with the objective of enabling the data driven decisions.
• Demonstrated excellent leadership, communication and analytical skills with team building capability;
• Proven ability to master new technologies; Conflict management, stake holder negotiations skills to handle disputes;
• Experienced in handling large and complex data sets using statistical concepts.
• Employed various kinds of analysis by partnering with data owners at different points in time.
• Experience with Azure Big Data Systems like Azure Data lake, Azure Data Analytics, HD Insights, Azure Machine Learning, U-SQL scripts.
• Visualized certain analysis trend outcomes by experimenting and evaluating the inbuilt algorithms of classification and clustering models using Azure Machine Learning.
• Proficient in report writing and data visualization tools.
• Generated different types of reports like Cascaded, Parameterized, Linked, Drill Through, Drill Downs and Roll Ups.
• Conducted numerous business analysis techniques like GAP Analysis, SWOT, Impact Analysis, Root-cause identification, Cost-Benefit analysis, KPI, Workflow analysis, Feasibility study.
• Expertize in defining and documenting the business process flows (UML) like Use case diagrams, Activity diagrams, Sequence diagrams and Data Flow Diagrams.
• Conducted assessments in the event of change request for organizational change management by performing business and technical impact analysis on the triple constraints.
• Experienced in handling requirements churn, creating stretch goals, skilful in negotiating with product owner. Good understanding and working knowledge of Scaled Agile Framework, Program Increment and Scrum of Scrum.
• Adept in handling multiple on-shore and offshore teams, coaching the team on Agile principles.
• Strong knowledge in data warehouse concepts such as data modeling, data quality, ETL process, meta data management, data warehouse implementation, Data marts, Operational Data Store (ODS); OLAP, OLTP systems;
• Proven knowledge in preparing Data warehouse requirement documents, Data Mapping Documents (Source to Target mapping), ETL Documentation, Data profiling, iteration matrix,
• Created Conceptual and Logical data models for ER and Dimensional modeling (Star & Snow Flake schema)
• Good understanding of Big Data concepts and Hadoop libraries stack. Hadoop Ecosystem consisting of HDFS architecture with MapReduce (YARN), HBase, Cassandra framework.
• Experienced in working with MySQL and using T-SQL, SQL queries, Stored Procedures and Triggers, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).

TECHNICAL SKILLS

Project Management Tools/Methodologies: MS-Project, MS SharePoint, JIRA, RALLY, AGILE- SCRUM, WATERFALL-SCRUM, WATERFALL, SAFE

REQUIREMENT MANAGEMENT: MS Office, JIRA, RALLY, TFS, SharePoint, Cucumber

REPORTING TOOLS: MS Power BI, SSRS (SQL Server Reporting System), MicroStrategy, Tableau9.1, Excel Power Query.

TOOLS: / LANGUAGES: Visio, Visual Studio 2016 / 2017, DBeaver, SQL Server management Studio 16, Altryx, XML, XPath, XLST, X-Query, JSON, T-SQL, U-SQL, R, C#, Cassandra Query Language, DAX.

DATABASES: SQL Server, MySQL, HBase, MS Access, Oracle 9i/10g/11g.

OFFICE TOOLS: MS Word, MS Excel Advance(Macro), MS PowerPoint, MS SharePoint, MS Visio

ANALYTICS TOOLS: Excel VBA, MS Access, Power BI, Tableau 9.1, R Studio

DOMAIN: Retail, Point of Sale (POS), CRM applications

CLOUD: Azure Data Lake Services, Azure Machine Learning, Azure Steam Analytics, HDInsight, Hadoop Cassandra, Azure Datawarehouse

PROFESSIONAL EXPERIENCE

Business Intelligence Analyst

Confidential

Responsibilities:

• Employed a variety of surveillance analysis for internal requests like ROI optimization, Promotional Effectiveness, First Touch and Last Touch Analysis, Contact Centre Analysis, Customer Conversion by various metrics, Sales Pipeline Analysis, Web Purchase Funnel Analytics.
• Worked with IBM Web Commerce Systems (WCS) at high level for Sales Attribution Model and integrated with Salesforce cloud for Marketing Mix Model.
• Facilitated structured and unstructured Interviews and conducted document analysis to elicit requirement from various business stakeholders.
• Analysed the source systems by heavily writing SQL queries such as triggers, functions, stored procedure, CTEs, CTAS on Azure Parallel Data warehouse.
• Collaborated with various business departments, and IT professionals through effective communication to develop business use cases associated with new project requests.
• Worked closely with executives and the development team to build and configure new workflows to minimize the clientele pain points.
• Created a conceptual model as per the requirement specifications, business process and the information needs.
• Converted the conceptual model to a logical design to detailed description of entities and dimensions.
• Created the dimensional models i.e., Star and Snowflake Schema by joining the facts and dimensions for the reporting system.
• Held review sessions to describe the data flow and data mapping from source to target systems.
• Understood and met referential data integrity and modelled aggregation layers analytics.
• Identified critical data elements across organization & defining accountability for data access and data quality.
• Conducted A/B Testing with Binomial and Poisson distribution in Web Analytics for Email Campaign to compare the Click Through Rate and Transactions per Paying User.
• Created Altyrx workflows and built several graphs, dashboards in Power BI using M Query / Power Query and advanced DAX.
• Developed the Promotional Effectiveness model by training, scoring and evaluating the Two Class Boosted Decision Tree in Azure Machine Learning.
• Analyzed the Customer Multi Touch data by classifying the data into clusters using the K-Means Clustering Model in Azure Machine Learning.

Environment: Agile Scrum, Jira, Retail, POS - Point of Sale; Confluence, Google Analytics, Google products (google sheets and excel), Power BI, Micro strategy, Salesforce, Azure Stream Analytics, U-SQL, Azure Data Lake, Azure Machine Learning, AWS, SQL, Informatica Powercenter, Altryx, TFS, MS- Visio, Visual Studio, XML, IBM WCS, Hadoop - Cassandra.

Business Reporting Analyst

Confidential, Ada, MI

Responsibilities:

• Facilitated JAD Sessions, Interviews (structured and unstructured), Survey/Questionnaire and Focus Groups to elicit requirements from various stakeholders, mostly business users and SME’s for business requirements.
• Conducted requirement walk-throughs with key stakeholders using various methods like team demos, workshops at various points of project especially during sprint planning and backlog refinement sessions.
• Acted as a point person serving as a liaison for the data management process between the business stakeholders and technical developers to ensure proper implementation of requirements within expected time.
• Involved in identifying and managing the working dependencies of Onsite and Offshore teams.
• Designed ER diagrams (Conceptual and Logical using Erwin) and mapping the data into database objects and produced Conceptual / Logical Data Models.
• Performed Data Analysis and Data Quality Assessment by Data profiling, data cleansing, data enrichment using complex SQL on various sources systems including SQL Server and Teradata.
• Responsible for data integration across line of businesses by loading it from multiple source systems, parsing it and then loading to the target system using various connectors.
• Coordinated with data stewards and data analysts in defining data ingestion activities and data quality levels.
• Used SQL stored procedures, triggers, functions and packages for extracting and validating data and generated reports per the requirements specified by the SMEs during discovery sprints.
• Created the interactive Dashboards in Tableau to address the problem and provide insight to the decision maker.
• Designed engaging data stories using story points in tableau.
• Developed unique and innovative enterprise wide, graphics based, business intelligence solutions that deliver actionable information to the business with a high degree of impact
• Utilized the business intelligence enterprise system software development suite to create, maintain and publish reports, dashboards, scorecards, and other visual information displays.
• Built several Operational, Tactical, Strategic Dashboards (balanced Scorecard) using several metrics at Departmental and Enterprise Level.

Environment: Agile Scrum, Jira 7.3, Retail, POS - Point of sale; Confluence, Advanced Excel, Excel PowerPivot, Microsoft Word, MS Access, Oracle 11g, Informatica, Sql Server, SQL, PL/SQL, Informatica Powercenter, TFS, MS- Visio, Process Improvement, Web services, Hadoop eco system, HDFS, YARN, HBASE, Hive, Pig, Apache Spark, Oozie, Zookeper.

Business Data Analyst

Confidential, San Ramon, CA

Responsibilities:

• Performed Gap Analysis to identify the deficiencies of the current business systems and to identify the requirements for the change in the system to analyse the As-Is and To-Be to generate future business requirements.
• Responsible for analyzing and translating the business requirements in Business Requirement Document (BRD).
• Identified critical path using MS project plan to create schedules in different scenarios.
• Responsible for creation of data flow diagrams, use case diagrams and documented them.
• Coordinated with system architect team in creation of logical design, to identify dependencies.
• Assisted on Administering ETL Process by creating the data mapping document and data workflow models.
• Coordinated with database developer to create star dimension modeling by identifying facts and dimensions.
• Performed PL/SQL queries using JOINS and nested queries to fetch data from MS SQL Server 2012.
• Extensively used Advanced Excel functions like vLookUps & formulae for data analysis.
• Assisted the team for slicing epics by vertical slicing and creation of user stories with INVEST criteria.

Evironment: Waterfall-scrum hybrid, UML diagrams, Rally, Oracle 11g Enterprise Edition, Oracle 12c Enterprise Edition, Visio, JIRA, MySQL DB, Adventure works, Informatica Powercenter, Confluence, Salesforce Sales, Salesforce Marketing, Oracle DB, AWS, Amazon EC2, Amazon S3, Amazon ELB, Lambda, Dynamo DB, Amazon EBS.

Business Analyst / Scrum Master

Confidential

Responsibilities:

• Decomposed the scope to user stories by conducting a story writing session with the Product owner and acceptance criteria for the PSPI (Potentially Shippable Product Increment).
• Assisted the product owner in prioritizing the product backlog as per the maximum business value, grooming User Stories in planning activities using INVEST criteria,
• Facilitated Scrum ceremonies like Sprint Planning, Sprint Execution and Daily Stand up Meeting, Sprint Review and the Retrospective;
• Coordinated in Scrum of Scrum meetings, Pre-PI planning and Post PI planning meetings
• Involved in Innovation Planning iteration to facilitate PI readiness, cadence-based planning, estimating guard band, hackathons, infrastructure improvements and systems demo.
• Recorded and maintained the artifacts like impediments list; Information radiators like Sprint Task Board, Release / sprint burn up and burn down charts; Insight Backlog.
• Worked on JIRA to record and maintain the artifacts such as Product backlogs (user stories), Sprint backlogs(tasks), defects and issue tracking; and ensuring transparency of Impediments list.
• Imported OLAP cube in OBIEE suite for Data analysis to gather insights on business processes.
• Managed OBIEE BI publisher for reports, and assisted users and departments with analysis requirements.

Environment: Agile: Scrum, SAFe, MS project, MS office Tools, MS Project, MS Visio, UML 2.x, AJAX, JAVA EE 6, Oracle 11g, HP ALM, Informatica Power Center, My SQL, OBIEE suite.

Business Systems Analyst

Confidential

Responsibilities:

• Facilitated JAD Sessions, Interviews sessions, Survey/Questionnaire and Focus Groups to Elicit Requirements for documentation of data definitions, standards, and master data processes.
• Developed artifacts by collaborating with the subject-matter-experts and converted the requirements in BRD, FSD (Functional Specification Document) and SOPs.
• Helped the team overcome a technical barrier by creating and updating use case diagrams, Activity diagrams, Sequence diagrams, workflow diagrams using MS Visio.
• Expert in Tracking and Managing the Requirements using Requirement Traceability Matrix (RTM) that controls numerous artifacts produced by the teams and I also handled requirement churn.
• Utilized Organizational Change methods to transformation organizations to accomplish project deliverables
• Perform User Acceptance Testing. Designed Test Cases, Test Plans, Test Scripts, and Test Scenarios to perform Functional Testing, and Regression Testing.
• Logged and tracked the defects using HP ALM and created an error repository along with the QA team.

Environment: Waterfall, MS Office, MS Visio, Mock-Up Screens, TFS, Sharepoint, GAP analysis, Oracle BI Publisher, UML, UAT Testing, Advanced Excel Queries.

SQL Developer

Confidential

Responsibilities:

• Developed processes for standardizing raw data coming from different sources in a variety of formats, and support team members in cleaning and improving data quality.
• Calculate fields as part of queries and turn queries into stored procedures.
• Created T-SQL triggers, tables, views and SQL joins and queries for the application.

Environment: Microsoft SQL Server 2008, Windows Server 2008, SSIS, Informatica, SSIS, T SQL, PL/SQL