SUMMARY:

• Experience in creating Business Requirement Document, Functional Requirement Document, User Stories, Test Cases, performing business data analysis and creating mock - ups to help finalize requirements
• Partnered with business users, analysts, project teams and key project stake holders to identify and understand functioning of different software systems within the organization to analyze the ‘As-Is’ state of the project
• Hands on knowledge of project management methodologies such as Waterfall and Agile to deliver application development and process improvement projects
• Proficient in SQL (DML, DDL, Query Tuning, Ad-hoc queries, Joins, Aggregation, Data Profiling)
• Working knowledge of Object Oriented Programming
• Extensively worked on design and generation of different Database Objects like Tables, Views, Materialized Views, Synonyms, Sequences, Stored Procedures, Functions, Database Triggers, etc.
• Excellent knowledge in Data modeling with utilities like Erwin and Visio. Worked on Dimensional (Fact, Dimension, Star Schema, Snow Flake Schema), Logical and Physical Database Designs
• Development experience on ETL tool ( Informatica and Oracle Warehouse builder), RDBMS (Oracle, Confidential and MS Sql Server 2008) and BI Tools ( SSRS, Tableau)
• Promoted agile values, coached and helped projects teams to adopt agile methodologies
• Successfully guided projects teams to deliver excellence during different phases of SDLC
• Good communication and Risk mitigation skills with experience in dealing with higher management personnel
• Highly organized and efficient to prioritize and manage multiple tasks
• Experience in conduction POC and Pilot projects to find new solutions
• Proven ability to work efficiently in both independent and team work environments
• Extensive experience in troubleshooting performance problems, identifying resource bottlenecks and process optimization.
• Piloted a LEAN process improvement project for University of Cincinnati’s Barrett Cancer Center and presented the ideas to the CEO of the center
• Completed a DMAIC project for client GE Money that resulted in annual savings of $33,000
• Experience in Finance, Banking, Healthcare, Asset Management and Manufacturing Industries/Domains

SKILL:

Expertise in: Data warehousing and Data mining, OLAP, OLTP, Requirement Gathering and Analysis, Project Management, Process Management, Scrum, LEAN, Six Sigma, Excel Analytics.

Software and Tools: MS Project, MS Office, SSMS, SSRS,PL SQL Developer, Confidential SQL assistant 7.2, Oracle Warehouse Builder, Informatica 9, AS 400, Tableau, Hive, Hadoop, Rally

RDBMS: Oracle 9i, Confidential, MS SQL Server

EXPERIENCE:

Confidential, San Jose, CA

Business System Analyst & Product Owner

Environment: Confidential, SQL, Hadoop, Hive, Rally, MS Office

Responsibilities:

• Responsible for delivery of Confidential regulatory reports for Asia, Europe and US
• Steer requirement gathering meeting to properly understand and document business requirements
• Write SQL queries to perform source data analysis for new requirements
• Liaison between the development teams, QA teams and business users
• Provide technical and functional support during Development and User Acceptance Testing
• Conduct JAD sessions with developers to finalize business requirement understanding
• Use Rally tool to document User Stories, Tasks, Acceptance criteria for a user story and other admin activities
• Facilitate daily standup, Sprint review meetings with project stake holders to track project deliverables, resolves risks and change requests
• Assist in developing use cases and product acceptance criteria
• Worked on ad-hoc reporting requests from the business users
• Onshore- Offshore team coordination

Confidential, Concord, CA IT

Business System Analyst/ Scrum Master

Environment: SQL Server 2008, TFS, IBM BPM, Sharepoint, MS Office, HTML, High Chart

Responsibilities:

• Steered requirement gathering meeting to properly understand and document business requirements
• Performed current system analysis to understand how different systems in organization interact with each other and their impact
• Wrote SQL queries to perform source data analysis
• Acted as a liaison between the development team, QA team and business users
• Developed Dimension Model ( Dimensions & Facts), Source-Target Data Mapping, Data Profiling
• Developed store procedures, functions and other database objects (DML & DDL)
• Collaborated with different IT and Business teams to create a standard development process
• Provide technical and functional support during User Acceptance Testing.
• Facilitated project review meetings with project stake holders to track project deliverables, resolves risks and change requests
• Provided support to resolve end user problems, optimize performance, resolve system defects and analyzed proposed improvements or changes to the system
• Assisted in developing Functional and Unit testing plans, Database design and Optimizing database performance
• Created Story Boards ( Information Radiators) to visualize and track project progress
• Plan and coordinate User Acceptance Test (UAT)
• Designed UI for reporting Dashboard
• Created Database schemas and Objects
• Conduct POC and Pilot projects to find new solutions
• Used ScrumXP agile methodology to deploy project deliverables
• Worked on ad-hoc reporting requests from the business users

Confidential, Cincinnati, OHt

Environment: AS 400, Sharepoint, MS Office

Project Manager (Internship)

Responsibilities:

• Involved in various phases of System Development Life Cycle (SDLC) such as analysis, design, development, testing, implementation and support
• Developed Process mapping and Optimization techniques to remove wastes and alter the work assignments queue to improve the team efficiency
• Created Story Boards ( Information Radiators) to visualize and track project progress
• Performed GAP analysis to understand the As-IS state of the system and recommend changes
• Introduced the WIP Limits queuing methodology to get orders out of the system before due date
• Managed a team of 5 associates which successfully finished the tasks within the SLA to meet the final product deadline
• Improved the Arts department throughput by 60%
• Provided technical assistance for development and maintenance of Department Management solutions.
• Initiated a project to build a Knowledge Management System for various departments of the organization
• Participated in analyzing and choosing vendors for building an ERP system for the organization
• Negotiated with different third party vendors to implement a safety standard procedure for people of shop floor

Confidential

Environment: Java, HTML, SQL Server, MS Office

Business Analyst

Responsibilities:

• Introduced the organization to e-commerce platform that helped to increase the number of orders received per month
• Coordinated with the business user to gather requirements for the new e-commerce application
• Documented the current system process flow, created BRD and FRD and design documents
• Managed the end-to-end development of the web application with a team of Java and Database resources and the testing team.
• Spearheaded the initiative to implement the ISO standards and ensured compliance to ISO specifications
• Planned out all the shop floor activities (Resources, inventory, scheduling) that enabled smooth functioning of the organization
• Negotiated with suppliers to get the required raw material inventory on time and within budget
• Managed client deliverables that were time and precision sensitive

Confidential

Technical Consultant (Data Warehousing ETL Consultant)

Environment: Informatica 8.6.1, Confidential, MDM, Linux, SQL, JIRA

Responsibilities:

• Writing SQL queries to perform data analysis for data audit and reconciliation
• Perform reverse engineering to solve user queries regarding data discrepancy
• Provide technical and functional support during User Acceptance Testing
• Create ad-hoc business reports using SQL queries on Confidential database
• Use JIRA to track and log issues regarding the application
• Load monthly sales data using SQL loader into target database
• Unit and functional testing of the developed Informatica mappings.
• Handling the Off shore team.
• Coordinating with the Onshore Team

Confidential

Environment: Informatica 8.6.1, Confidential, SQL, Linux, JIRA

Informatica ETL Developer

Responsibilities:

• Working with business state holders, SMEs and Development team to understand the Functional Requirement for developing ETL processes using Informatica Power Center
• Development of ETL data load mapping as per the data mapping document
• Unit and functional testing of Informatica mappings
• Writing SQL queries in Confidential RDBMS to perform data analysis and testing
• Coordinating with QA team for performing UAT
• Kept track of execution, Unit test cases and defects for smooth functioning
• Used JIRA for tracking requirements and logging bug tickets
• Performance tuning of the ETL mapping
• Training new resources on project to bring them up to speed for project related activities

Confidential

Asst. System Engineer (Data Warehousing- Development, Support & Testing)

Environment: Informatica 8.6.1, Confidential, SQL, Linux

Responsibilities:

• Working with the business team to understand requirements for the new system to be built
• Creating database models ( Dimensional modeling) to construct dimensions and fact tables
• Develop data mapping sheets to track source to target data lineage
• Time and effort estimation for developing new ETL and Cognos objects
• Create Informatica Power Center mappings, workflows and services to extract data from source system
• Writing SQL queries on source system to perform data analysis and testing
• Coordinating with QA team for performing system testing and UAT
• Communicate with relevant parties (i.e. User, Business, and Partner Systems) via teleconferences, emails, relevant documents to resolve issues