SUMMARY

• More than 9 years of professional experience 8 years in USA as a Business Analyst in various domains. Expert in Requirements gathering, Product development & release, KPIs, Data Mining, DB queries, Ad - hoc reporting via different reporting tools, Data Lineage, Dashboard Design,Testing etc.Experience Domain-Business Analyst
• Expert in eliciting, analyzing and documenting requirements for business process and information systems. Have created Business Requirement Document (BRD), Functional Requirement Document (FRD), UML, Use Cases, Activity and Class Diagrams, Software Requirement Specification Document (SRS), Data Flow Models, Entity Relationship Diagrams using EA (Enterprise Architect) and MS Visio. Worked on OSS and BSS platforms with telecommunication.
• Created Traceability Matrix for Test Cases & Functional Requirements and performed User Acceptance Testing (UAT) to ensure standard and proper functionality implementation.
• Performed GAP analysis to compare AS IS and TO BE Process Models using tools like Enterprise Architect (EA), Visio. Performed analytical comparison of legacy and revamped reporting systems.
• Experience in preparation of Functional Specification Document based on the Business Requirements. Story Boards, Proposed Functionality Documentation, Wireframes, Functional Testing.
• Have extensive noledge of SDLC (Software Development Life Cycle) and experience in managing requirements using agile methodologies
• Experience with Data Analytics, Data Reporting, Ad-hoc Reporting, Graphs, Scales, Pivot Tables and KPI reporting. Expert in data flow between primary DB and various reporting tools, Expert in finding Trends and Patterns within Datasets and providing recommendations accordingly.
• Involved in gathering, analyzing, and documenting Reporting requirements from business/Stake holders and applying reporting requirements rules to the datasets within SQL DB, developing ad-hoc reports via reporting tools such as SSRS, Crystal Reports and Tableau and automate the delivery.
• Experience in implementing KPI’s under different domains and environments depending on data analytics patterns. Expert in creating ROI and Savings reports based on the real time data.
• Worked on creating Star and Snowflake DB schemas, DB normalization and mappings during ETL.
• Worked on Fact and Dimension tables, foreign and primary key constraints, SCDs (slowly changing dimensions) and its types, referential integrity enforcement etc.
• Worked on Supply Chain Management data analytics concepts like Future Forecasting, Back Orders, Percent Sales, Regional Sales, Net Profit/Loss, Dead Stock, Inventory Status etc. studied the pattern & provided recommendations to Sales, Marketing teams & higher management.
• Expert in automating excel reporting and macros via T-SQL queries, Stored Procedures, Triggers, Views and reporting tools like SSRS BIDS, Tableau, Qlik-View, Crystal Reports, Power Pivot etc.
• Worked on Inventory Reports, Savings Reports, Retail Reports, Usage Reports and designed interactive dashboards with KPIs, sub-reports, Graphs,Scales, Top/bottom usage categories etc.
• Worked on advanced features of MS Excel like Vlookups, Macros, Pivot Tables, Data Validation
• Familiar with Hadoop big data framework, HDFS, Mapreduce, Hive SQL and databases like Hbase.
• Worked on Google Analytics to measure web traffic, popular areas, session time, web chats etc..
• Worked on SharePoint upgrade projects. Being SP power user actively involved in creating workflows, search scopes, views, list crawls, calendar sync, blogs, RSS feeds, infopath forms, third party Web Parts etc along with regular features like Lists, Libraries, Work spaces etc.
• Experience with MS projects, handling various projects simultaneously, managing tight deadlines, managing budget, tasks management with local and remote teams, QA processes.
• Performed Smoke testing, Unit testing, Regression testing, Functional testing & UAT.
• Led a cross-functional project team to breakdown the integration projects in each service area.
• Always been part of CCB Change control Board to determine potential impact of change

TECHNICAL SKILLS:

Business Skills: Business Requirements, Business Process Analysis & Design, Financial Analysis, Risk Analysis, Requirement Gathering, Use Case Modeling, JAD/JRP Sessions, GAP Analysis & Impact analysis, OSS, BSS.

Languages: T-SQL, PL SQL,UML, HTML, XML, VB 5.0/6.0, GuiXT, Java scripts

Packages: Rational Rose, Enterprise Architect EA, MS Visio, MS Project, MS Share point.

Databases: MS SQL Server 2008 R2/2012, MS Access, Amazon Redshift

Operating Systems: UNIX, Linux, Windows NT/server/xp/Seven, MS-DOS.

Office Tools: MS office 2003/2007, MS Visio, MS Project.

ERP: SAP SD-MM-PP-CRM-BI, PeopleSoft 8.0

Portals: SAP NetWeaver Portal, SharePoint 2007, 2010, 2013.

Reporting tools: Business Objects, Tableau 9.0, Crystal Reports, Xcelsius, SSRS & PowerPivot.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Retail Lead Business Analyst

Responsibilities:

• Gather reporting requirements from stakeholders, understand underlying data from BI team.
• Work on marketing campaigns & sales success measure reports with KPIs and dashboards.
• Write complex T-SQL queries to retrieve the data, create datasets, connect them with reporting tool like Tableau, SSRS. Arrange the data in meaningful format, find trend and patterns within.
• Create and automate reports for Daily Store Sales, Daily Product Sales, Daily Associate Sales, Omnicart fitting room trending reports. Create Inventory and quantity sold reports.
• Create reports like, marketing campaign & Promo codes performance, Inventory Days of Supply analysis, Zip codes online vs retail sales analysis, Top trending products analysis etc.
• Perform data validation on different reports and dashboards with backend database numbers.

Environment: Tableau, SSRS, SQL server, SharePoint, JIRA, Confluence, Stash, R Analytics

Confidential, CA

Sr. Business Lead Analyst

Responsibilities:

• Gather project requirements from stakeholders, document legacy business processes, perform GAP Analysis. Work on OSS/BSS responsibilities while supporting networks like Verizon, AT&T
• Work on creating reporting templates with parameters and automate the report delivery.
• Document Business Rules, Assumptions, Constraints, and Facts and suggest best possible ways for report automation and optimization. Create BRD, FRD, RTM for automation project.
• Write T-SQL scripts for reports automation, transform legacy static excel reports into dynamic and interactive reports. Share such reports via SharePoint portal.
• Work towards finding trends and patterns within the reports by analyzing SQL datasets and accordingly suggest best possible modification on carrier plan which leads towards cost optimization. Create meaningful summarized behavioural data trend presentations.
• Create Ad-hoc reports and dashboards for Sales, Inventory & Billing department via SSRS,SSAS.
• Analyzed the possible Hadoop Big data framework implementation for unstructured data.
• Design SharePoint 2010 web portal as reports repository and share them on request.

Environment: Tableau 9.0, SSRS, SSAS, Crystal Reports, Power Pivot, Advanced Excel, SharePoint 2010, ProtoShare, Visio, Qlik view, Google Analytics, Hadoop,Hbase, PL-SQL, salesforce, OSS, BSS

Confidential, Thousand Oaks,CA

Business Analyst-Expert/Lead

Responsibilities:

• Partner with the business to translate high-level business requirements into functional specifications for system implementation and configuration.
• Perform data analysis on user sharepoint sites contents via Microsoft BI and create status reports reflecting the risk factors. Perform AS IS and TO BE Analysis.
• Understand business requirements and current process and help find ways to improve and provide value using OOTB SharePoint functionality. Balance finding solutions with maintaining client’s ability to understand and support going forward.
• Work on creating workflows, search scopes, views, list crawls, calendar sync, blogs, RSS feeds, infopath forms, Third party Web Parts Nintex and Bamboo along with regular tasks like creating and maintaining Lists, Libraries, Work Spaces, Announcements, Workflows for approvals.
• Handled the sharepoint training labs, created the training materials for users and hosted the live user training sessions.

Environment: SharePoint-2010, MS SQL Server, SSRS, Tableau, Crystal Reports, HP Quality Center, QTP load runner, MS Projects, Nintex Workflows.

Confidential Los Angeles/Seattle

BI/Data Analyst

Responsibilities:

• Performed GAP analysis to compare AS IS Traditional reporting and TO BE Multi channel attribution Process models. Created BRD, FRD and Project Charter.
• Worked on different combination of pairs for Solicit, Responses and Attribution Events and incorporated that within database to identify sales and KPIs. Created cost analysis reports.
• Developed T-SQL queries associated with report and accomplished reports automation.
• Established linkage between reports developed via SSRS/Tableau/PowerPivot with SQL.
• Worked on huge marketing data to find trends and patterns by slicing and dicing operations
• Worked on weekly, monthly, quarterly, yearly pipeline reports which would reflect performance of different marketing and Sales campaigns like mail, phone, Television, web clips etc.

Environment:SQL Server, SharePoint-2013, BIDS,Visio, MS Excel, Tableu, Google Analytics.

Confidential, Greater Los Angeles, CA

Business-Data Analyst

Responsibilities:

• Worked on Agile SDLC methodology while developing DBF to SQL ‘Data Reporting transformation’ project. Created BRD, FRD and requirements metrics .
• Worked with Sales and Marketing teams to gather Reporting/Dashboard requirements.
• Managed supply chain management processes, future forecasting, back orders, percent sales, KPI, net profit/loss, dead stock, inventory status etc. for Stores in US, Canada and Mexico.
• Designed BI Sales and Inventory Ad-hoc reports for retail stores like Home Depot, Lowe’s, True Value, Wal-Mart, Kohl’s, Target, Groupon and Amazon.com for Exhart products to analyze Trends and Patterns.
• Worked on Crystal Reports, MS BIDS, Tableau to generate ad-hoc multi-dimensional and Cross functional reports based on daily, weekly and monthly sale. Incorporated savings and inventory reports. Automated whole report generation process.
• Created training material for non-technical users for SharePoint and BI reporting tools.

Environment: MS SQL Server, SSIS, SSRS, Crystal Reports, SharePoint, BIDS, MS Visio, MS Access, MS Excel etc,MS Projects, IBM Cognos, Tableau, salesforce