SUMMARY

• Data Analyst/Business Intelligence Analyst with zeal of excel into the field of R, SAS, Tableau, Power BI, Incorta; the technological revolution which a driving factor in today’s competitive market.
• Expertise in preparation of dashboards and stories to help in decision making with Tableau software and Power BI.
• Knowledge base on working with the dataset in SAP HANA, Amazon Redshift and Salesforce. Integration of datasets and performing detailed analysis on KPI’s and preparing the reports and dashboards as per the business requirement.
• Expertise in Data understanding and data modeling techniques. Well conversant with statistical concepts and preparing statistical reports using IBM SPSS and SAS.
• Knowledge on Anti - Money Laundering, brand management, strategy development, marketing mix optimization, e-commerce and social commerce to grow the sales, and visual merchandising.

TECHNICAL SKILLS

Platforms: Windows 2000/XP/NT/Vista/7, Mac OS, DOS

Methodologies: Agile, JAD, SDLC, Waterfall

Modeling & Analysis tools: Tableau, UML (Unified Modeling Language), Microsoft Visio, Draw.io.

Languages: SAS, C, PASCAL, FOXPRO, HTML

Databases: SQL, Putty.exe, MS Access

Software Tools/Utilities: MS Project, MS Outlook, MS PowerPoint, MS Visio, MS Excel, Notepad ++,Primal Script, Code blocks, Balsamiq Mockups, IBM Lotus Notes, Rational Tools.

CRM tool: Salesforce

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Analyst

Responsibilities:

• Design strategies to ensure total guest satisfaction.
• Develop an annual business plan and reports, dashboards and ad-hoc analysis for better decision making.
• Implementing the new property hub software for the hotel industry. As it was a pilot project, Confidential was the 3rd hotel in the United States for this pilot project. With the consultation with Business Owner/Property Manager, we were able to implement the new software. And was responsible to report the issues related to software so that when Wyndham implements the new software in the hotels in United States all across, they have a bug free, User friendly software.
• Ensure highest standards of professional services to customers.
• Initiate cost-effective controls and revenue management techniques.
• Well-versed with Property Hub as well as Synixspm software.
• Effective Rate management and group pricing.

Environment: SynixsPm, PropertyHub, Tableau, Talend, R programming for data visualization and manipulation, draw.io, Microsoft Visio, IBM SPSS for statistical analysis to conduct the feasibility study.

Confidential, Columbus, OH

Scrum Master / Tableau Developer

Responsibilities:

• Project was about the discovery documentation of the current application in Safelite.
• Understanding the Business Process Flow of each application and documenting the same.
• Had brainstorming sessions to understand and gather the information for documenting the current application. Business meetings every day for 5 hours and 3 hours for requirement documentation. Business meetings with SMEs, Product Owner, Scrum Master, Scrum Team meetings with Managing Director of Confidential and updating on the project progress.
• Dashboard and report preparation with the integration of SAP HANA and Amazon RedShift Datasets.
• Conducted meetings with SMEs and Product owners to understand the requirements.
• Identified the APIs.
• Documentation of the requirements as well as mapping out the business process flow diagrams, activity diagrams and use case diagrams.
• Used Salesforce for CRM and providing more insights to the sales and marketing team on the customer trend and the lead generation.

Environment: Tableau, Salesforce Admin, AWS, Power BI, Microsoft Visio, Draw.io, Balsamiq Mockup, SCRUM methodology, SAS

Confidential, Schaumburg, IL

Business Intelligence Analyst

Responsibilities:

• Performed Scrum Master Duties and see to it the team for self-organizing and working towards the successful completion of the sprint. Removing impediments for the Development Team if any and providing assistance to the PO in product backlog refinement.
• Conduct JAD sessions to gather requirements from client.
• Gather and document functional and nonfunctional requirements, Business Requirements (BR), User Requirements.
• Documentation of requirements and created BRDs.
• Domain knowledge of insurance industry with very challenging and demanding work environment. Broad experience in creating an ecommerce website (Web Development) for Property and Casualty Insurance including Auto, Home, and Marine Life insurance/Annuities.
• Develop and update functional use cases and conducted business process modeling (UML) diagrams and DFD diagrams to explain business requirements for development and QA teams.
• Perform requirements elicitation through Use Cases, conducted JAD session, JRD sessions and RAD (Rapid Application Development) sessions with stakeholders.
• Expertise in writing SQL commands and creating databases.
• Work on to develop claims processing applications for Life, Health, Property and Casualty Insurance.
• Worked on with Enterprise Content Management (ECM) in order to save the data electronically.
• Work with Team Foundation Server (TFS).
• Work with project team on: planning, analysis, requirements, design and testing and training for production development.
• Involve in manual, functional, system and regression testing in an agile development environment. Mainly focused on UAT and Unit Testing.
• Gather requirements and manage requirements through IBM Rational Doors tool.
• Involve in generating test plans, test cases and test specifications as per Business requirements.
• Use Scrum Framework for managing product development with various teams.

Environment: SQL, Tableau, TFS, ECM, IBM Rational Doors, Microsoft Visio, Draw.io, Balsamiq Mockup, Selenium, SCRUM Methodology

Confidential, Antioch, IL

Manager/Data Analyst

Responsibilities:

• Managed 5 stores. 4 stores in Illinois, i.e. Lindenhurst, Zion, Wadsworth, Antioch, IL and opened a new store in Alexandria, Missouri.
• Was responsible for the compliances of the store and making sure that store is run under the guidelines of the concerned village.
• Performed Data Understanding and identified the sales trends using different reporting techniques.
• Expertise in creation of different charts for better decision making.
• Was responsible for generating more revenue via marketing and promotions for each store.
• Was responsible for making sure that we have satisfied customer base. For us as a small business chain, we had to make sure that customers are retained and the store generates more revenue from it.
• Was responsible for making decisions on visual merchandising as well as maintaining contracts with the vendor companies.
• Achieved financial objectives by preparing an annual budget; scheduling expenditures; analyzing variances; initiating corrective actions.
• Identified current and future customer requirements by establishing rapport with potential and actual customers and other persons in a position to understand service requirements.
• Formulated pricing policies by reviewing merchandising activities; determining additional needed sales promotion; authorizing clearance sales; studying trends.
• Market merchandise by studying advertising, sales promotion, and display plans; analyzing operating and financial statements for profitability ratios.
• Maintained the stability and reputation of the store by complying with legal requirements.
• Determined marketing strategy changes by reviewing operating and financial statements and departmental sales records.

Environment: Tableau, SAS, DataStage, Draw.io, Visio, Advance Excel for analytics, IBM SPSS, Documentation