Data Project

Abhishek Buddhiwant

Email: ****.*****@*****.*** Cellphone: 630- 812-0589

CORE COMPETENCY

Business Intelligence

Data Analysis

Data Warehouse Development

Business Analysis

Advanced SQL Data Mining

Requirement Elicitation & Documentation

BI Dashboard Reporting

Machine Learning

Functional & Technical Documentation

PROFESSIONAL SUMMARY

7 years of experience as aData Analyst, Business Intelligence& Data Warehousing- Developer, possessing strong analytical, problem- solving and communication skills with particular emphasis on clear, detailed business requirements documentation and functional specifications documentation, as well as reports for management, research and analysis in various domains like Insurance,Energy, and Finance.

Extensive experience with business intelligence reporting suites such as OBIEE, SAP Business Objects, Tableau, Cognos BI, MSBI (SSRS).

Analysis and development of ETL solutions across platforms such as Informatica and Ab Initio.

Innovative and knowledgeable professional in all facets of database management, database mining and analysis.

Hands-on experience in all phases of Software Development Lifecycle (SDLC) using waterfall, iterative, agile, RUP (Rational Unified Process), and other internal SDLCs and technology delivery frameworks.

Excellent skills in Data Warehouse Development, Data Analysis, Requirement Analysis, Business Modeling and Use Case development using UML methodology.

Created reports with complex formulas and to query the database for business intelligence.

Highly proficient in creating Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams, Class Diagrams etc.

Extensive experience in gathering Business and Functional Requirements, developing Use Cases, conducting Gap Analysis and Impact Analysis, SWOT Analysis, modeling businesses processes, preparingtraining manuals and knowledge transfer manuals.

Worked extensively on business requirements elicitation, process modeling, risk analysis, SWOT analysis and development of functional specifications.

Expertise in broad range of technology platforms, including business process tools such as MS Project, MS Excel, MS Access, MS PowerPoint, MS Share point, MS Visio and Rational Suite.

Strong experience in the creation of Test Plan and Test Cases from the Requirements document. Documentation of Test Plans, Test Cases, Test Scripts, Test Procedures, and Test Data for various applications.

Creating efficient and effective Test Scripts to implement and execute the Test Procedures. Execution of Test cases manually using Test Director and Automating Tests using Win Runner, Quick Test Pro.

Effective communicator with excellent skills in making Business Presentations, Documentation, writing and developing Business Reports using crystal reports and Outlook Soft, and Technical Specifications.

Strong analytical and problem solving skills, multi-tasking abilities, with proven experience in utilizing people and process knowledge to assist enterprises in making critical decisions.

Excellent oral and written communication with impeccable interviewing and presentation skills

TECHNICAL SKILLS

Business modeling

Microsoft Visio, IBM Rational Rose.

Documentation

Microsoft Word, Rational Requisite Pro

Testing

Mercury Quick Test Pro, Win Runner

Reporting tools

OBIEE, Tableau, SAP BO, Crystal Reports, Cognos, Microstrategy

ETL Tools

Informatica Powercenter, Ab Initio

Languages

SQL, PL / SQL, R, Python, HTML

Databases

Oracle 10g/11g, MS Access, MS SQL Server, DB2

Operating Systems

Windows, UNIX,Linux(SSL,VPN)

ERP

SAP, Oracle

PROFESSIONAL EXPERIENCE

Client:First Niagara Bank, Pittsburgh, PA October’14 - Present

Role: Data Analyst

Project: Enterprise Data Warehouse Management

This project entailed the design and implementation of data warehousing, and dashboard reporting solutions using an iterative SDLC model for the HR department at First Niagara. Developed SQL based reports, ad-hoc reports, dashboards, business requirement documents, functional design documents for the reporting needs of various stakeholders within the client department.

Responsibilities:

Worked with business teams includingvarious stakeholders within HR, to understand the reporting information requirements.

Partnered with different teams to identify the stakeholders, understand the business and functional requirements, acted as an IT liaison for the business units.

Managed project backlogs for business technology solutions delivery group, helped senior leadership team in prioritizing projects.

Assisted program manager in execution of various bank wide projects; identified and communicated various dependencies, risks, action logs and communicated to stakeholders throughout the project.

Gathered business requirements by conducting detailed interviews, JAD sessions with business stakeholders and SME’s.

Helped manage risk analysis and mitigation plans, status reports, and client presentations; prepared business process models defined milestone deliverables and established critical success factors

Worked with QA team to design test strategy, test cases for UAT testing.

Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.

Prepared project progress reports, status reports, risk/action log and submitted to PMO and senior management on an ongoing basis.

Performed impact analysis and documented various downstream impacts through various business process flows, Data flow diagrams. Created As is and To Be business process flows and document various gaps.

Prepared the Functional Specifications Documents for the Data Modelers and the ETL Teams.

Collaborated with analysts to decide the ETL methods and overall data flow architecture.

Assured that all Artifacts are in compliance with corporate SDLC policies and guidelines.

Environment: SQL Server 2008, Windows XP Professional, Java, Doors, MS Office 2007, MS Visio 2007, MS Project 2007, Rational Requisite Pro, Informatica Power Center 8, UML, XML, PHP

Client: Travelers Insurance - Hartford, CT April’12 - September’14

Role: Business Intelligence / BusinessAnalyst

Project: Enterprise Data Warehouse Management and Migration

The project involved migrating the Enterprise Data Warehouse, data flow processes and dashboard reporting applicationsto a standardized environment for enabling better compatibility between various departments’ data and BI operations.

Responsibilities:

Worked with diff business areas such as Claims, Policy, and CRM to understand the business processes and associated ETL data flow requirements.

Defining the scope of the project and identifying the major actors, using various elicitation techniques to gather requirements

Extensively done GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.

Facilitated numerous Joint Application Development (JAD) sessions utilized for the creation of design documents and system specifications for applications.

Responsible for decomposing High Level Business requirement into functional specifications.

Executing complex SQL statements and performed data analysis on Oracle data Base.

Responsible for creating Use Case diagrams, Activity Diagrams and Wireframes diagrams using MS VISIO.

Designed the conceptual data and business process models.

Developed Data Mapping documents describing source, target, and rules; created Meta Data documents

Performed multiple SQL queries using Query Analyzer / TOAD for Data Analysis; created database driven reports with output to MS Excel and custom reports such as SQL file count, Ad-Hoc reports, and monthly migration reports.

Extensively involved in Data mining, Data mapping and Data modeling.

Involved in identifying the ADHOC scenarios.

Responsible for identifying the hierarchy for drill down process.

Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose

Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.

Responsible for writing training manuals and training of the end users.

Client: Capital One Finance (Credit Cards) - Richmond VA January’11 - March’12

Role: Business Intelligence / Business Analyst

Project: Campaign Management Reporting

The scope of the project was to improve and increase the contactability channels for Capital one Collections Department. It involved providing better treatment strategies and other tools/offers to the existing customers. The primary goal of the project was to increase the contactability channels and try to maximize the reach to customers. It also involved buying a COTS application and making enhancements according to ever evolving requirements from the business for different strategies.

Responsibilities

Collaborated with analysts to decide the ETL methods and overall data flow architecture for and translate the business rules. Created data flow diagram, physical and logical data models for a new request.

Interacted with various SME's to understand the scope of central build and have created business requirements, system requirements and design documents for 2 major Collections Applications.

Prepared the system requirements and Functional Specifications Documents for the Data Modelers and the ETL Teams for Card Data Warehouse.

Created Wire-Frames/Screen Mockups using Ms Office for the new GUI – dashboard to ensure all requirements are captured correctly.

Interviewed various SME’s for detailed business processes and to understand the Collections and Recoveries side of the business segments. Interacted with the Business Team through JAD sessions, to gather requirements and develop complex business maps.

Managed various levels of Projects in accordance to SDLC standards, worked as a project lead/PM for various central build and regional build projects.

Acted as project manager/lead with creating detailed project plans and assisted in developing, scheduling and tracking project timelines using MS Project. Have been a primary POC and IT liaison for 2 Major Collections Applications.

Responsible for various configuration/parameter changes on Queue Management System and Online channel.

Worked in agile/scrum methodology for better and rapid delivery of the business solutions. Suggested planning features one sprint ahead of the implementation in the Sprint Retrospective in order to achieve maximum utilization of resources and comfortable and thoroughly tested deliveries.

Worked with the Business Analysts/Data Analysts in conducting Data Discovery sessions to obtain the business names and descriptions of the data elements across the lines of business. Helped in creating data mapping and data dictionary document.

Involved in system interactive testing and helped testers in understanding the business and the design specifications.

Managed business approval process, risk governance process and change management process for all the releases in Collections COAT team.

Client: Scottish & Southern Energy – UK September’09 - December’10

Role: Business Intelligence / Business Analyst

Project: Campaign Management Reporting

The project involved deployment of a BI Reporting and Dashboard system formarketing campaign management, and supporting business intelligence solutions for the Energy client. Worked on facilitating the data integration between different systems to deliver a reporting solution for the client’s sales and marketing teams, using iterative SDLC methodology. It also involved the continuous improvement efforts, in accordance with the client’s updating needs.

Responsibilities

Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.

Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).

Worked with ETL team during the upload process.

Helped with Data Mapping between the data mart and the Source Systems.

Interact with the stakeholders to get a better understanding of client business processes and gather business requirements.

Identify Use cases from the requirements and write Use Case Specifications

Create business process workflow diagrams (Activity diagrams) in Rational Rose

Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement

Create Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.

Create test plan and test cases for user acceptance testing.

Conduct informal Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests

Used the Unified Change Management to track changes to multiple artifacts by versioning artifacts, associating requirements to specific change request/defects to streamline the defect/change tracking process.

Perform Feasibility Analysis and Risk Analysis on vendor/third party tools.

Coordinate and prioritize outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.

Monitor client expectations and conduct user interviews.

EDUCATION SUMMARY

Bachelor of Engineering

Rajiv Gandhi Technical University

Contact this candidate