SUMMARY:

• 9 years of experience in data analytics and data mining, reporting and data analysis, Business Intelligence, Business Requirements Gathering and Translating Requirements into Specifications
• Having strong analytical, conceptual and reasoning skills, more conscious of tiny details that impact the quality
• Worked on Tableau, SQL, ILD (liquid data), Xlerate Plus, UNIX, Master data management (MDM), Oracle Unified Method, with strong experience in MS Excel like Vlookup & VBA.
• Experience in Manufacturing, Retail and Banking domains
• Responsible for designing, developing, testing, implementing, and supporting business requirement gathering, mapping functional requirements, analysis, documentation, design, testing, support to user acceptance testing and post implementation support
• Work with business clients to analyze, identify, and implement appropriate BI solutions (i.e. OLAP cubes, dashboards, reports) that deliver meaningful information for decision making.
• Expertise in broad range of technologies, includingbusinessprocess tools such as MS Excel, MS Access, MS Visio, Data Modeling and Design.
• Experienced in implementing of Standard operating procedures (SOP).
• Experience in preparing and reviewing Test Plans and Test Cases
• Act as liaison to the business group by collaborating with the application and technology teams and deliver appropriate solutions
• Demonstrates client relationship development and management skills.
• Superior problem - solving, analytical and quantitative skills.
• Self-motivated and team player.

TECHNICAL SKILLS:

• MS Office Suite (Word, Excel, PowerPoint & Outlook),
• SQL,
• Tableau,
• ILD
• UNIX
• MDM

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

• Work on Tableau dashboards and SQL to conduct issue analysis and develop hypotheses on the key client issues;
• Design and execute quantitative analyses to test and analyses hypotheses;
• Synthesize findings, develop recommendations and communicate results to clients and internal teams
• Project management responsibilities, including client communication, internal team management, scheduling and the packaging and presentation of deliverables
• Serve as the end to end single point of contact for visualization and unstructured data analysis.
• Understand functional requirements, conduct a gap analysis, and draw up recommendations and proposals.
• Exceed assigned revenue and achieve favourable data contract terms by over-delivering on insights, identifying opportunities to expand/ extend projects, and exceptionally serving the client.
• Participated in requirements meetings, writing requirements, converting requirements.
• Design, develop and deploy data visualization executive-level dashboards in Tableau based on key insights and outputs from analyses
• Create data integration, data migration and Quality Check.

Environment: Tableau, SQL, MS Excel, Vlook and H lookups, Powerpoint presentations, Pivot tables, Python

Confidential, Dallas, TX

Data Analyst

Responsibilities:

• Design, manage and deliver data analyses, including customer sentiment analyses, customer journey optimization analyses, and visual dashboards by using Tableau and ILD.
• Derive business insights and present recommendations to stakeholders and executive leadership team at Confidential . Work on National Sales meeting and board meeting decks.
• Provide analytical insights to deliver greater share of promotion, distribution and shelving.
• Work on Price elasticity and sensitivity analysis and optimization, Promotional spends analysis and optimization and Demand planning and forecasting.
• Worked on Tableau, SQL, ILD, Syndicated databases, Xlerate Plus, UNIX, Master data management (MDM), Statistics Modelling.
• Exceed assigned revenue and achieve favourable data contract terms by over-delivering on insights, identifying opportunities to expand/ extend projects, and exceptionally serving the client.
• Worked with Marketing and Brand Team on decisions from product innovation, to positioning and messaging, brand reviews and competitive market place analysis.
• Understands dynamics of retailer relationship; balances role of purchaser of data and provider of data from an economic and relationship perspective.
• Collaborate & communicate effectively with internal/partner project managers & technical liaisons, as well as customer business sponsors.
• Conduct root cause analysis on performance and make recommendations based on advanced analytics using BI Tools.
• Work in an onsite-offshore model and lead the data science development with team members at offshore.
• Help grow business by ideating analytical/data science use cases build solutions and deliver value.
• Conduct occasional review of past statistical analysis and identify additional avenues to glean knowledge from large data sets (outlier analysis, control limit analysis, regression, etc.)
• Contribute to development of Business Intelligence environment, including staging databases, Tableau reports, etc.
• Design and implement Master Data Management systems and processes.
• Work with the implementation team to design the database hierarchies and customizations.
• Manage current and future needs in data design and content.

Environment: MS Excel, Vlook and H lookups, Powerpoint presentations, Pivot tables, Tableau, Python

Confidential, New Jersey

Data Analyst

Responsibilities:

• Responsibilities entail collecting, analyzing, and interpreting data to prepare analytical reports, provide research and data analysis.
• Manage & ensuring organic growth of accounts assigned and managing projects from end-to-end by: defining project scope, developing detailed project plans and milestones; assigning task to individuals; managing and escalating project risks.
• Set up and implement new and on-going projects. Provide timely status reports, project analysis and recommendations. Proactively identify project risks and develop risk mitigation plans.
• Worked on Agile methodology environment with scrum meeting, burn down charts, and user stories in delivering the artifacts
• Analyze large business questions by manipulating data sources to create actionable analysis and/or reporting
• Work very closely with our clients to produce ad hoc reports and presentations across strategic and tactical top-line applications
• Use strong analytical skills to consult with our client’s sales, category management and brand and trade marketing groups.
• Day-to-day duties of a business conducting research and data manipulation, selecting correct methods for retrieving and analyzing data, developing reports and presentations, performing business requirements analysis and documentation, working with internal and external clients to document all data-related functions to successfully meet business needs, and ensuring reliable data is available to create reports.
• Conduct market research, monitoring and analyzing established databases, and synthesizing data into actionable information.
• Conducted weekly Quality checks on the data bases and communicate to team.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, functional & non-functional requirements.
• Analyzed Scope, captured business requirements, recommended process changes and documented the requirements for the development team.
• Import excels data into access tables and performs data analysis and queries.

Environment: MS Excel (vlook up, Pivots, VBA etc), MS PowerPoint, Tableau

Confidential

Data Analyst

Responsibilities:

• Evaluates data, prepares forecasts, analyzes trends and presents results pertaining to sales, operations, general business conditions and other areas by using MS Excel.
• Coordinate and provide oversight for application development, QC, maintenance and production support performed by different IT vendors and act as a liaison between business and technical teams.
• Demonstrate planning, leadership, communication, negotiation, interpersonal and presentation skills.
• Demonstrate expertise in translating data and analysis into relevant implications.
• Demonstrate strong understanding of client issues.
• Participate in Quarterly Business Reviews and team leadership/development meetings.
• Extracting data and interpreting it into key Business information like Category and Brand growth analysis, Key Accounts analysis, Promotional efficiency analysis etc.
• Analyzing the distribution of manufacturers in different retailers and suggesting the client to cover the gap using gap analysis.
• Follow up with business side with developer concerns with regards to requirements
• Collecting and defining business requirements in cooperation and in association with the business.
• Defining and documenting functional requirements to a low level and taking ownership of their delivery through the entire development lifecycle.
• Identifying, reporting and owning risks and issues.
• Collecting, documenting and sharing lessons learned to contribute to continual improvements to the processes supporting end-to-end TM change management and system support.
• Developing, maintaining and sharing a suite of documentation which defines the end-to-end data model, including Extraction, Transformation, Loading and use in TM scenarios.

Environment: Mainframes, Visual Basic, UNIX, MS office, MS Word, MS Excel, MS Visio

Confidential

Associate Data Analyst

Responsibilities:

• Develop and prepare reporting on key business metrics on a routine basis to monitor trends and take corrective action as needed.Assessing market, current trends in market, finding competitors, also giving suggestions for product improvement.
• Forecast marketing returns, marketing expenses and cross-company data analysis’-method linkage.
• Create quantitative models reporting business trends, automate data collection, develop and maintain analytical models, and generate reports and dashboards that measure the performance.
• Understand the current applications, enhance and support the same with the help of Production Support Methodology, Maintenance Methodology and Enhancement Methodology
• Creation and verification of insert/update queries to rectify data issues in live production environment
• Responsible for appropriate communication and feedback between the user and different levels of support maintained for fast resolution.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Extensive experience in Accounting Reporting Systems on daily, weekly, monthly, quarterly and annually together with various accounting analysis such as variances and reasons for same.