PROFESSIONAL SUMMARY

• Over 6 years of IT experience in the field of Data/ Business analysis, Data Modeling, Change Management and Project Management.
• Experience in Data Modeling, Analytics, Visualization, Presentation & Reporting.
• Proficient in process analytics using lean Six Sigma. Lean Six Sigma green belt certified.
• Extensive experience in visualizing the design of the system by UML, Class diagrams, ER Diagrams and web page mock - ups.
• Experience in Hadoop & MapReduce framework.
• Experience in working on Performance and Optimization of the SQL Queries.
• Strong Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins
• Proficient in Social Media Data Analytics (Facebook, Twitter & You Tube) using NodeXL.
• Understanding and experience in Data Analytics I.e. Chi-square, Decision tree, Neural networks & Regression analysis using SAS E-Miner
• Extracting data from existing data source. Developing and executing departmental reports for performance and response purposes by using oracle SQL, MS Excel.
• Extensive experience in Requirement gathering, Solution provisioning, Performance tuning ofSAP solutions, Trouble shooting, SME support and Pre/Post go-live support activities.
• Experience in Natural Gas & Electric, Manufacturing and Technology industry business process.
• Extensive experience in GAP Analysis, Estimations, Team handling, Onsite Coordination and Delivery management.
• ManagedCRMoperations, including consulting, user setups, training, and technical functions.
• Enhanced the high-touch client experience by implementing and improvingCRMfunctions and features
• Strong technical and business acumen skills to easily translate and communicate with technical and business resources at all levels in an organization.
• Ability to manage risk and make informed decisions regarding schedule, resource allocation, and priorities.
• Experience working in both Waterfall & Agile project methodologies.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Coordinating project meetings and work with team, Project managers, business analysts, statisticians, and internal customer’s / end users.
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

TECHNICAL SKILLS

Data Tools: Visio, NodeXL, SAS E-Miner, Tableau, Pandas, NumPy, SciPy, Advanced MSExcel

Data Framework: Hadoop & MapReduce

Languages: SAP ABAP, BSP & BOL programming, Java, HTML basics, Base SAS, Python

Project Management: MS Office, MS Project

Operating Systems: LINUX, Windows (2000, NT, XP, VISTA, 7, 8, 10)

Other Tools: SAP GUI 7.1, Eclipse, Netbeans IDE, Jira

Database: MySQL, Oracle 11g, MongoDB

Methodologies: Agile, Scrum, Rational Unified process, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Pacifica, CA

Business Intelligence Analyst

Responsibilities:

• Downloaded & analyzed semiconductor industry market data from Twitter using NodeXL to understand the current industry trends & predict future trends.
• Worked closely with the CEO & VP of business development.
• Evaluated investment opportunities and performed due diligence, market research, and financial analysis to provide investment recommendations to management team.
• Prepared pitch to be presented to venturecapitalfirms for funding
• Prepared Business Proposal, FAD Template, Organizational & Industry Analysis Template.

Environment Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Project, MS Visio), CRM, UML, SQL, SWOT analysis, Agile, SDLC, Lean Six Sigma, Change Management, NodeXL, SAS E-Miner, Data Analytics.

Confidential, Santa Clara, CA

Data Analyst

Responsibilities:

• Performed customer data analysis for geocentric marketing by running Map-Reduce jobs using Hadoop framework.
• Built a browser based UI to display the findings on Google Maps by the use of KML and maps APIs.
• Downloaded Intel Twitter, YouTube & Facebook Data using NodeXL.
• Analyzed & visualized the data to understand the popularity, competition, customer base & sentiments towards the company.
• Presented analytical reports which further helped in developing geocentric digital marketing strategies.
• Performed Chi-square, decision tree & Regression analysis on company data using SAS E-Miner to understand the factors influencing company sales.
• Developed Project proposal & Business Requirement documents.
• Designed ER model, UML diagrams including UseCase diagram, Activity diagram & more using Visio.
• Performed Data Normalization & Database UI Integration and Developed Test Cases.
• Extracted data extensively using SQL queries.
• Involved in reviewing, mentoring, training & performance evaluations.
• Experience in the role of a Scrum Master
• Worked closely with the Project Manager
• Came up with process improvement solution using Lean Six Sigma
• Used DMAIC (Define, Measure, Analyze, Improve and Control) data-driven improvement cycle for optimizing, improving and stabilizing business processes & designs.

Environment Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Project, MS Visio), CRM, UML, SQL, SWOT analysis, Agile, SDLC, Lean Six Sigma, Change Management, NodeXL, SAS E-Miner, Data Analytics.

Confidential, San Francisco, CA

Data Analyst

Responsibilities

• Involved in gathering the requirements from Business users.
• Involved in translating the business requirements into data requirements across different systems.
• Played a key role working closely with and supporting the Project manager and associates.
• Supervised, monitored, guided & reviewed the work of subordinates.
• Involved in performance evaluations & Training.
• Scheduled & coordinated daily scrum meetings.
• Involved in modeling business processes through UML diagrams.
• Performed numerous huge data pulling requests using SQL Assistant.
• Created tables, views, database links to see the information extracted from SQL files.
• Extracted data from existing data source and performed ad-hoc queries using SQL.
• Created data source & assigned them to Business Partner (BP), created target groups based on the criteria specified by the client & created campaign (Email) to sell particular products to the target group.
• Prototyped integration of Facebook and twitter with SAP CRM WEBUI so that customer feedback data posted on these social media sites can be fetched into SAP CRM system & replied back at ease and this data could further be used by BI system to analyze customer insight.
• Developed a framework that enabled role based user authorization & usage of individual business objects using Access Control Engine. Analyzed ACE Design & Runtime Data.
• Created a project selection & prioritization model.
• Prepared a report along with 4 other team members which included the Business Case, Stakeholder analysis, Communication matrix, Scope, Schedule, Budget, Risk Register, Quality Management Plan & MS project summary.

Environment Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Visio), SAP CRM, UML, SQL, SWOT analysis, Agile, SDLC, Project Management, Change Management, CRM Service, Sales & Marketing modules.

Confidential, Fremont, CA

Business Systems Analyst

Responsibilities

• Participated in meetings with stakeholders, business managers, users to understand anddocument business requirementsandfunctional specificationsfor theWorkflow.
• Documented detailBusiness Process Designand created Use Cases.
• Extensively usedMS SharePointforversion control. Uploaded files and maintained folders in Share Point.
• Responsible to determine theGAP Analysisbetween theAs-Is / To-BeBusiness Process Flows.
• Defect coordination involved working with the Project Managers, Development, System and UAT testing teams to ensure defects are addressed, managed and closed as appropriate.
• Conducted meeting between the business, development and testing teams to resolve defects.
• Reviewing the requirements & assigning it to the team, Code review, moving to production system.
• Coordinated with team for development, tracking & updating the same to client & management.
• Assigned & Coordinated the work with Onsite Team
• Worked with corporate and field executives to manage the expectations of the project and put out fires as changes and new business requirements came up.
• Linked business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement.
• Created an OVP (Overview Page) with Assignment Blocks, displaying table data based on input given.
• Migrated Customer data along with relationships (CRM) using LSMW from legacy systems to SAP systems.

Environment Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Visio), SAP CRM, UML, SQL, GAP Analysis, CRM Service, Agile, SDLC, Change Management, Jira

Confidential, Rosemead, CA

Business Systems Analyst

Responsibilities

• Interacted with the stakeholders to get a better understanding of client business processes and gather business requirements.
• Identified Use cases from the requirements and wrote Use Case Specifications.
• Incorporated best industry practices and worked with the team on getting deliverables out under budget and ahead of schedule.
• Created business process workflow diagrams (Activity diagrams) using Visio.
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
• Created test plan and test cases for user acceptance testing.
• Conducted user interviews and tracked client expectations.
• Uploaded customer data using BAPI

Environment Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Visio), SAP CRM, UML, SQL, CRM Sales, Agile, Jira

Confidential, San Diego, CA

Analyst

Responsibilities

• Developed smart forms to collect customer data & reports to read customer data from the database using SQL queries.
• Responsible for Analyzing, Designing & developing complexCRMDevelopments.
• Developed custom UI requirements based on Client inputs.
• Analyzed the Functional Specifications documents and Prepared the Technical Specification Documents for the client requirement
• Coding and Development as per coding standards, Code review & Unit testing
• Displayed data in various languages using ALV
• Inserted data into the database table using Classes

Environment Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Visio), SAP CRM, SQL, Waterfall, CRM Sales