Professional Summary:

• International experience of 9 years working with onshore and offshore diverse background of team on analyzing various aspects of business strategies, data analysis, Big Data, Analytics Marketing Analytics and tactics for better optimization and increment in revenue and/or market share in the industry
• Techno-Managerial expertise with capabilities of analysis, strategies, team management, project management, resource management, delegation of work, prioritization of work, process improvement
• Experience working with off-shore, on-shore, on-site, off-site project teams
• Extensive knowledge of Analytics Insight especially Predictive Analytics with various statistical tools such as IBM SPSS, SAS, R, R Studio, MINITAB to analyze the strategies of the company and competitive advantage in the market
• Expertise in Data Analysis, Data Visualization tools such as Tableau, MS Excel
• Expertise in communicating the analysis results in business language
• Ample knowledge of software development life cycle SDLC , methodologies spectrum like Waterfall and Agile Served as the conduit between the user and the software development team through which requirements flow
• Adept at conducting interviews, brainstorming, JAD and JAR sessions, Walkthroughs
• Excellent documentation skills demonstrated in documenting software requirement specification SRS , Business Requirement Documents BRD , and Functional Requirement Document FRD
• Experience in developing clear, Requirement Traceability Matrix RTM using task and workflow analysis, requirements workshops, business process descriptions, focus groups, and prototyping etc
• Proficient in designing UI Prototyping, and UML diagrams such as Use Cases, Sequence, Collaboration, Activity and Class diagrams using Enterprise Architect, MS Visio, IBM Rational Rose
• Experience in performing Feasibility and risk analysis to identify the business critical high risk areas for Change Management and Configuration Management
• Experience performing cost/benefit and Impact Assessment IA , to rate and analyze change magnitude
• Performed Gap analysis for AS-IS and TO-BE business processes
• Excellent skills in Performance Management to support strategic planning, goal setting, strengthen accountability, enhance decision making
• Proficient with process improvement methodology like TOC Theory of Constraints
• Comprehensive insight of Software testing life cycle, and vital involvement in UAT User Acceptance Testing of web based and database applications
• Proficient in writing Test plans, Test cases, Test design, and execution of test cases in Manual and Automation Testing modes, with excellent Bug reporting skills
• Experience in creating step-by step technical and user manuals with illustrations

Technical Skills:

• Data Analysis Tool: MS Excel VBA, Pivot Tables , IBM SPSS, SAS, R, R Studio, Hadoop, Tableau, MINITAB
• Requirement Management: IBM Rational Requisite Pro
• UML Tools: Enterprise Architect, MS Visio, Gliffy, Visible Analyst, IBM Rational Rose
• Project Management: MS Project
• Database: MS SQL, MySQL, MS-Access
• Scripting Languages: C, C , Java, VBScript
• Defect Management: HP Quality Center, IBM Rational ClearQuest, JIRA
• Testing Tools: Quick Test Professional, LoadRunner, Selenium, SoapUI
• Other: Bloomberg Terminal, Thompson Reuters

Professional Experience:

Confidential

Sr. Analyst Team Lead

Responsibilities:

• Data Analytics: Worked in TCS Nielsen relationship of Advance Analytics Consultancy AAC for Marketing Mix Modeling MMM group to analyze efficiency ROI effectiveness Volume Response of marketing strategies based on statistical approach of predictive analytics. Further, provided insights for marketing budget allocation based on market trend, consumer behavior, historic data and demand to increase revenue and market share.
• Process: Worked thoroughly on data analysis of project starting from Kick Off Call Data Requirement Data Cleansing/Scrubbing/Validating Data Visualization Data Modeling/Analysis Micro Analysis Synergy, Optimization Analysis Report Presentation Simulation
• Project: Worked on various projects of Auto Industry, FMCG Industry, Telecom Industry, and Retail Industry
• Project Management: Worked with onshore offshore team on a project maintaining project scope, budget timeline aligned with project milestones/deliverables as per the customer's expectations.
• Statistical Analysis: Worked extensively on data analysis using statistical methods such as regression analysis, Ordinary Least Square method of estimation, correlation, standard deviation, variance, hypothesis test, ANOVA, R Square, and T-test using IBM SPSS MS Excel to address client's business needs considering Industry movement, consumer requirement competition.
• Innovation Brand Equity : Introduced a purchase funnel methodology using factor analysis to gauge brand equity of a company or a product for Auto Industry. The most helpful to build, to develop to maintain brand image in the market amongst peers.
• Client Relations: Understood the business needs key performance indicators KPI of the business. Experience of conveying statistical facts figures in business language which includes return on investments ROI , market share, competition, and providing insight over the budget allocation for high return possible.
• Data Cleansing/Scrubbing: Worked extensively on the raw data and converted into modeling friendly data using MS Excel and MS Access. Conveyed the data representation using MS PowerPoint in business language.
• Process Improvement: Restructured The Simulator of Auto Projects for better representation of analysis insights to client providing an opportunity to have optimized revenue considering multi-dimensional parameters such as budget allocation, revenue, spending. Furthermore, reduced overall process cycle time by 80 of The Simulator by restructuring the process steps increasing efficiency. Replaced a MATLAB portion of Simulator with SAS MS Excel VBA programming.
• Mentoring: Developed Training material for Non-FMCG projects. Constructed templates to increase decision making activity, to reduce overall cycle time for deliverables to standardize processes aligned with the team of diverse background.

Confidential

Manager

Responsibilities:

• Measure, report, and analyze all key performance indicators across website, search, email, CRM, social and other key channels to support marketing and digital strategies
• Consult with brand and digital marketing teams to develop, analyze and interpret all channels' marketing program results against strategic goals, providing guidance on prioritization and optimization
• Analyze customer transactional, demographic, web and social data to provide predictive insights across the customer lifecycle including acquisition, engagement, retention, lifetime value and advocacy
• Define approaches to segment customers and improve targeting across all marketing communications
• Provide analytics support to cross-functional partners for all marketing analytics-related requests
• Synthesize disparate findings into cogent, action-oriented recommendations and deliver persuasive oral/written presentations to brand and marketing leaders in order to gain buy-in on execution
• Evaluate existing analysis and reporting/visualization tools, processes, and data sources to identify opportunities for enhancement and future investment
• Work with third-parties to design and gather primary research to supplement analytics with qualitative insights
• Offer thought leadership on analytical approaches for attacking complex and nebulously defined issues
• Develop internal best practices and monitor developments in web and marketing analytics industries
• Proactively drive both strategic analysis on new opportunities and tactical analysis on how to make existing product and marketing strategies better.
• Drive new understandings of the behaviors that define customer engagement and loyalty through the customer lifecycle, developing analytical infrastructure and models as needed.
• Optimize test structure and sizing for new campaigns, and inform next steps based on analysis of the results.
• Leverage site analytics to deliver leap ahead insights into customer usage and performance of all user flows and online real estate across multiple platforms web, mobile, etc.
• In partnership with the Product and Marketing teams, carry understandings into proposals for action.
• Expand decisioning tools for business owners by establishing KPI dashboards that enable ongoing optimization of marketing efforts.
• Verify accuracy of all data, results and conclusions, performing statistical analysis if necessary.

Confidential

Sr. Data Analyst

Responsibilities:

• Developed close working relationship with assigned clients to provide strategic analysis, campaign and program recommendations.
• Identified and align opportunities for improvement with business cases and data quality goals
• Raw data analysis assessing quality, cleansing, structuring for downstream processing
• Generated and communicate reports on data analysis and insights in different formats using Tableau and MS Excel
• Design and prototype of accurate and scalable prediction algorithms using R/R Studio
• Collaboration with engineering team to bring analytical prototypes to production
• Communication of results to partners and customers using dashboard constructed using Tableau
• Analyzed different types of data to derive insights about relationships between locations, statistical measurements and qualitatively assess the data using R/R Studio
• Created audiences with ranging complexities and a variety of defining data types using our custom suite of tools
• Conducted detailed audience analysis, perform database queries and reviews of test results to validate, identify issues and formulate remediation plans for improvement
• Analyzed campaign and customer data to provide conclusions, implications, and actionable recommendations designed to improve the quality of future relationship marketing communications.
• Demonstrated proficiency in the utilization of analytical tools for advertising and direct marketing including segmentation and modeling, back-end response analysis, quantitative and qualitative primary market research.
• Owned specific initiatives focusing on the development of the competency, including implementation of analytical tools, techniques, processes and frameworks.
• Participated in data management and audience initiatives involving multiple customers and provide subject matter expertise
• Acted as the final authority on day-to-day analytics deliverables for assigned clients.

Confidential

Sr. Business Analyst

Responsibilities:

• Responsible for Project planning, monitoring, resourcing and budgeting
• Gathered Business Requirements by interviewing SMEs and conducted project meetings between SMEs, project stakeholders and development team as per need
• Prepared Business Requirements Document BRD , Functional Requirements Document FRD and System Requirement Document SRD with clear and concise writing for better understanding to the Project Team
• Communicated the functionality of high level requirements Using Unified Modeling Language UML methodologies such as Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Sequence Diagram and ER Diagram using Visible Analyst
• Conducted brainstorming sessions with Developers, Architects and Project Manager to understand the complications of integration of new feature in the application
• Analyzed Business Process Model using flow chart to improve the process efficiency and quality considering an integration of the proposed Risk Analytic feature into the application
• Designed the look-n-feel or non-functional requirements of the application through Mock-up forms for better illustration for the development team
• Used IBM Rational Requisite Pro for tracking and maintaining versions of the documents during each iteration according to the received business requirement
• Used Microsoft SQL Server to organize consolidated data and executed SQL queries for validating the data stored in repository
• Responsible for continuous process improvement and for identifying and maintaining clear and understandable documents for workflow and reference materials
• Contributed in developing Test Strategy, Test Plan, Test scenarios, Test Cases
• Conducted User Acceptance Test UAT to ensure that they meet the requirements and aligned to the project scope

Confidential

Business Analyst

Responsibilities:

• Developed a high level requirement by understanding the need of the improvement via interviewing and meeting users, feedback from support team and as a silent observer in voice conference
• Participated in a brainstorming with project lead and business users to conduct GAP As is To Be Analysis and Risk Analysis of the enhancements
• Participated in project planning, monitoring and budgeting considering the resources Men-Hour management, Vender Management maintaining project scope using MS Project and MS Excel
• Prepared Project Requirements Document PRD and Functional Document FD with clear and concise writing for better understanding of the application to the Project Team
• Used Unified Modeling Language UML methodologies such as Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Sequence Diagram and ER Diagram using MS Visio
• Indulged in data mapping and data migration in order to normalize and extract data from the data server
• Optimized Business Process Model to improve the process flow and increase the quality of the application
• Introduced a Dashboard feature and developed mock-up screens considering the popularity of the charts, economic triggers and market performance
• Conducted walkthrough meetings, conference calls and JAD sessions to achieve the milestone of the project at each stage as per business requirement
• Assisted the QA Lead, Tech lead and Project Manager to develop a test strategy and test plan
• Mentored QA team to develop test script in order to test the target deliverables
• Coordinated with QA team and Account Managers to conduct User Acceptance Testing UAT
• Conducted webinar and class based training for the Bank executives, provided demonstration video of the application

Confidential

Business Analyst

Responsibilities:

• Summarize large amounts of data, communicate key insights across functions and translate data into actionable business strategy
• Use analytics tools and scientific rigor to produce real-time insights
• Formulate new and creative ways of showing data relationships in a fast paced environment with constant change
• Organize, audit, and digest the integrity of large, diverse data sets across multiple platforms
• Continually improve and automate our processes for extracting data and incorporating it into real-time models
• Perform large-scale data analysis, data modeling and develop effective statistical models to drive new strategies
• Scale our business intelligence strategy across new functions by designing and implementing functional data analytics