Project Data

Neha Pandey

****.******.**@*****.***

Cell#: 630-***-****

Career Overview:

•10+ years of experience in IT end to end implementations, providing quality solutions to customers.

•Excellent skills in partnering with stakeholders to understand business strategies and objectives and channeling them to the development team to ensure quality deliverables that exceed customer expectations.

•Extensive experience in analyzing business scope, Agile & waterfall models, requirements in multi-stakeholder projects and translating them into clear concise technical requirements/user stories.

•Excellent experience in managing project schedules, business partner expectations and conflict resolution.

•Experienced in budgeting, ROI and estimating projects.

•Extensive experience in Data Analysis, Report and Dashboard development.

•Worked on multiple projects simultaneously in a fast paced environment with quick turnaround time, including Onsite – Offshore/vendor model.

•Good flair for learning new technologies and concepts, with proven track record for meeting objectives and deadlines with high quality.

•Strong development skills including the ability to work through the entire development cycle from gathering requirements through implementation. Strong communication and interpersonal skills with people of all levels and roles.

•Good team management and customer interaction skills.

•Self-motivated, organized, technically sound, team lead, like to work in a challenging environment

Technical Skills:

Languages/OS:

SQL/PLSQL, Hive, Perl, Python, C++, Windows, UNIX

Databases:

MS SQL SERVER 2005\2008, Teradata 12.0

Business Intelligence Tools:

SAP BI 4.0, Tableau, BOE XI 3.1, BO XI R2, BO 5x, SSIS, Web Intelligence, Webi Rich Client, Designer, Xcelcius, Infoview, CMC, CCM, Import Wizard, QaaWS, Live office, Crystal Reports, Qlikview. SSIS, SSRS

Others:

Business Analysis, Budgeting, Project planning, Agile & SDLC project planning, MS PROJECT, JIRA, Clear Case, Clear Quest, Sharepoint

Education:

B. Tech, Computer Science and Engineering, AKGEC India.

Work Experience:

Sears Holdings Corporation

Sr BI Analyst: May 2017 -present

Sr Analyst: July 2014 – Nov 2016

American IT Resource Group

Business Intelligence Lead: Apr 2014 – Dec 2014

Infosys Limited

Technology Analyst Nov 2007 – Apr 2014

Work Experiences:

Sears Holdings, Hoffman Estates, IL July 2014 – present

Responsibilities – Senior BI Analyst, LEAN Six Sigma Team:

•Extract data from multiple sources like Hadoop, Teradata and Tableu reports and perform analysis to determine root cause of process failures.

•Provide data points to LEAN Six Sigma team to identify sources of waste and excess cost and develop recommendations for process improvements.

•Follow DMAIC approach to review current state of processes and provide data driven efficiency recommendations.

•Analyze complex data sets and develop recommendations for process improvements.

•Create executive dashboards and Finance reporting to highlight the cost savings associated with implemented process changes.

•Conduct regular meetings with business partners and stakeholders to evaluate new and upcoming projects, requirements and their impact on business.

•Determine requirements using business analysis, interviews, surveys, business process descriptions, use cases scenarios.

•Worked with Senior Management to analyze pricing strategy effects on sale using historical sale and inventory data.

•Worked on project planning, budgeting and expense reporting for Agile and Waterfall projects.

•Worked across business units to provide refined requirements & user stories to be delivered to internal and external resources (software vendors) for application development efforts.

•Collaborated with business and teammates in requirements prioritization and requirements review meetings to ensure that the requirements are interpreted correctly.

•Used UML during requirements gathering and created Use Case Models and Use Case Diagrams in the project to help them understand the workflow of the system associated with the requirements.

•Define system attributes, external interfaces, constraints & other non-functional requirements.

•Developed thorough knowledge to understand the functional and hierarchical dependencies that affect mission-critical and production environments

•Coordinate with the Subject matter experts (SMEs) to obtain domain related information.

•Performed periodic reviews with development team for defect prevention.

•Conduct brainstorming sessions with stakeholders to analyze the benefits and shortcomings of executed projects.

•Help quality assurance team to develop an optimized Test Plan and Test Cases using JIRA to prioritize the test effort.

Infosys Nov 2007-April 2014

Project Experiences:

Client: Mondelez International, Northfield, IL (September 2013 – March 2014)

Responsibilities- Business Intelligence Lead:

•Managed a 10 member team to deliver the project before schedule with highest quality.

•Assessed business implications for each project phase and monitored progress to meet deadlines, standards and cost targets.

•Developed reports and dashboards to enable senior leadership make critical decisions.

•Analyzed, coordinated, documented and managed project requirements, project processes and procedures and its changes throughout the software development lifecycle.

•Resolved numerous project issues including staffing shortages, tactical matters, scope creep and divergent business and user needs.

•Built various standard reports using graphical components like bar charts, line charts and pie charts.

•Assisted production support team in case of any load/performance issues with the existing processes.

•Monitored Defect tracking using Rational Clear Quest for Change Management.

•Actively participated in the End-to-End User’s Acceptance Testing (UAT) process by creating UAT Test Scenarios, Test Cases and logged defects in Clear Quest.

Client: CVS Caremark, Northbrook, IL (Feb 2013 – Aug 2013)

This project involved designing a BI solution that automated the generation of Cost Savings Opportunities for members.

Business Intelligence Lead:

•Designed and built the Data Warehouse that supported data from multiple sources on real time.

•Designed fast execution scripts that loaded files significantly faster than other data load scripts.

•Developed Teradata and Oracle stored procedures to transform data from Oracle with the use of Unix Shell, Python and Perl Scripting.

•Extracted data from Oracle database transformed and loaded into Teradata database according to the specifications.

•Improved the scalability of the existing scripts.

•Wrote SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.

•Supporting daily loads and work with business users to handle rejected data.

•Developed complex universes to report on member savings data.

•Built complex Web intelligence and crystal reports based on universes and stored procedure to display daily cost savings for members.

•Developed Interfaces using UNIX Shell Scripts to automate the bulk load & update Processes.

Client - Sears Holdings, Hoffman Estates, IL (May 2012 –Jan 2013)

Data Migration for Shop Your Way Rewards Members. This project involved the migration of Shop Your Way Rewards members from an external vendor’s data warehouse to Sears’ internal Data Warehouse.

Business Intelligence Developer:

•Analyzed the member and transaction data to design the data load scripts.

•Designed and Developed ETL jobs to load data using FastLoad, BTEQ, FastExport, MultiLoad, and shell scripts.

•Involved in loading of data into Teradata from flat files using complex scripts and Fast Load.

•Involved writing BTEQ scripts for validation & testing of the sessions, data integrity between source and target databases and for report generation

Client: Anthem Blue Cross Blue Shield, Chicago, IL (June, 2011-May 2012)

This project involved the design & development of a Business Objects solution that will allow WellPoint (Anthem BlueCross\Blue Shield) to automate the claim line processing and reimbursement resulting in extensive reduction of manual intervention.

Business Intelligence Lead:

•Assisted the clients in managing project scope, risk, resources and budget. Provided solutions for the data warehouse, system engineering, management consultancy and business intelligence related solutions.

•Acted as a consultant for various Business Intelligence projects within WellPoint to propose, analyze and design Business Intelligence solutions.

•Analyzed the existing complex data mart and proposed a feasible universe technical design for efficient and effective reporting.

•Designing, developing and managing universes that could effectively handle health insurance related day to day reporting.

Client: Kraft Foods, Northfield IL (Nov, 2007 – May, 2011)

Created an easy to use reporting tool for the marketing group to analyze global consumer feedback on products by region and time periods. Led a 6 member team on development and enhancement of several universes over a complex relational database and development of over 200+ webi, deski & crystal reports.

Business Intelligence Developer:

•Created complex reports involving drill down, sections, dynamic LOVs.

•Performed tuning the reports and universes to get faster results.

•Provided project estimation and gathered requirements from clients

•Involved in business analysis sessions with users, to build new reports as per the requirements.

•Developed complex universes for Ad-hoc and standard reports using Business Objects XI 3.1 SP2 using features like aggregate awareness, prompts Index awareness, Conditions and hierarchies.

•Migrating applications using Import Wizard

•Setting up the Global level and Content level sec

Contact this candidate