SUMMARY

• 15 years of combined experience in Project Management (Agile and Waterfall Methodology), Business Analysis, ETL and Data Management. Strong leadership skills in handling cross - functional team in all aspects of SDLC from gathering business requirements, effort and resource management, technical specifications, conceptual design, data analysis, implementation, quality review, deployment, and enhancement support.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business/Data Analyst

Responsibilities:

• Gathered requirements and performed various activities to analyze and build interfaces, dashboards, timely and informative reports and other analytical solutions for teh Confidential Global/North America Customer Service.
• Collaborated with stakeholders, project owners and implemented full life cycle from conception to deployment, training and production support.
• Built project documentations to accurately estimate, allocate and track tasks, resource and timeline.
• Translated business requirements into detailed technical documentation, and Visio documentation dat helped to create effective solutions.
• Created data models based on requirements for various interfaces, dashboards, reports, and documented teh technical design specifications and data flow.
• Analyzed teh customer survey responses to understand data patterns and provide ongoing metric reports to identify improvement opportunities in customer service (Tableau, Excel and MS Access).
• Designed and developed ETL process (SSIS) to acquire data and supporting dimensional database structures and procedures (SQL Server) to handle teh interfaces and reports.
• Involved in teh quality testing of teh developed interfaces, tableau generated reports and UI applications.
• Involved in teh overall project planning, scheduling, and support activities.

Accomplishments: Exceeded teh expectations of teh stakeholders by clearly understanding teh requirements, effectively analyzing teh data and delivering timely/quality interfaces and reports. Frequently recognized for teh dedication and support shown in teh Customer Experience project.

Confidential

Sr. Business/Data Analyst

Responsibilities:

• Coordinated and gathered requirements and developed teh interfaces involved in teh LFS securitization - Imaging process of sending teh loan images to teh custodian (Wells Fargo) for certification, and receiving and processing teh loan certificates.
• Gathered requirements for interfaces related to imaging process, performed detailed data analysis and design on teh requirements.
• Documented teh requirements and translated it into technical design and data flow to help with development.
• Created data models based on teh requirements for teh securitization interfaces.
• Developed new ETL PDI process for loading teh loan document certificates, and processing teh loan images. Created supporting database structures and procedures (SQL Server) to handle teh interfaces, and reports.
• Interpreted and analyzed teh data processed and created business friendly reports.

Accomplishments: Acquired knowledge of new technology (Pentaho) within a short time, effectively integrated it in teh solutions, and exceeded teh expectations of teh customer. Automated teh imaging process and reduced teh processing time by 25%, which in turn improved resource allocation.

Confidential

Business Delivery Manager

Responsibilities:

• Managed and engaged client to gather software requirements/business rules, and ensured alignment with development teams
• Draft and maintain business requirements and align them with functional and technical requirements.
• Facilitate weekly meetings with clients to discuss teh requirements, document teh user stories and explore potential solutions.
• Discussed teh requirements and sprint scope, effort, schedule, progress with teh client on a regular basis and documented teh user stories gathered from teh client meetings.
• Managed and led agile development and implementation activities by conducting daily scrums meetings with teh development and QA team to meet sprint goals.
• Managed teh resource allocation, task delegation, tracked teh workload and progress monitoring for each sprint using Trello and ZenDesk.
• Designed and developed database structures, ETL jobs and procedures to handle everyday transactions and monthly reports on reservation metrics.
• Implemented Google Analytics to report teh number of reservations made using mobile, desktop or microsites and helped teh client make informed business decisions.

Accomplishments: Effectively handled teh agile requirements/changes and impressed teh client with teh quick turnaround of sprints without compromising on quality. Expediently handled production issues and exceeded teh client expectation. Helped build a cordial and strong relationship with teh client. Quickly learned to handle newer development and analytics tool to improve teh quality of teh product.

Confidential

Sr. QA Analyst

Responsibilities:

• Coordinated and performed teh testing and test case and defect management for various projects (Georgia Data Broker, NYSIC, Shields, FAIR, CP Wireless) linked to Government Agencies to access credit reports and public records
• Interacted with teh development and project management team to understand teh requirements and prepared test plans and assign test cases to teh team.
• Maintained project requirements, test plans, and defects in Quality Center.
• Designed JMeter scripts, QTP scripts and SQL scripts for automated testing and test reports.
• Analyze teh defects, patterns and generate monthly business friendly defect reports.

Accomplishments: Quickly learnt to write QTP and JMeter automated scripts for testing. Effectively used teh knowledge of SQL to handle some complicated testing scenarios. Helped streamline teh process to reduce teh number of defects.

Confidential

Business Delivery Manager

Responsibilities:

• Managed and coordinated all teh activities in gathering and understanding requirements, detailed analysis, implementation, testing, deployment and support of various applications - Real Estate (Site Selection Process for opening Confidential stores), SORT (Special Orders Reconciliation Tool), ATS (Allowance Tracking System), AR Incremental (Incremental Advertising Activities Tracker)
• Managed and coordinated teh client interactions, requirements, analysis, design, implementation, deployment, and support activities with a cross-functional team.
• Designed, and managed SOAP clients to interact with Tactician SOAP server to gather demographics data.
• Designed, developed and managed various database and ETL components using UNIX shell scripts and PL/SQL to facilitate data interfaces to other systems: Tactician, SAS, and Finance.
• Analyzed, designed and managed various reports using Brio: Price Guarantee, Price Mismatch, Sales Margin Report, Force Match, Force Release, and Consignment Report.
• Managed teh resource and effort allocation for teh various phases of teh project, and reported teh project progress and reported teh status to teh customer on a regular basis.
• Responsible for managing both new projects and maintenance /enhancements to existing applications.

Accomplishments: Exceeding Client expectation by efficiently handling teh project during resource and time crunch situation without compromising on quality. Trained teh team with teh functionality and new technology involved in teh project. Recognized for thorough analysis of requirements. Successfully handled multiple projects with tight deadlines.

Confidential

Business Delivery Manager

Responsibilities:

• Interfaced between Business and Development team for driving business requirements and project coordination for data migration to teh Oracle Manufacturing system from ASK MRP system - Bill of Material, Demand Order, Allocations, Scheduled Receipts, Part Master, Supply Order, Independent Demand, and Warehouse
• Performed detailed analysis on teh requirements, designed and developed teh interfaces (PL/SQL and Unix Shell Scripts), and documented teh technical design document and test cases for various interfaces to handle teh data migration.
• Coordinated and facilitated successful completion of User Acceptance Testing - Test plan, Business Test cases, Test scripts and execution of codes and scripts along with documenting testing results.
• Coordinated and managed teh development, and support activities for teh interfaces for data migration.

Accomplishments: Improved teh time and effort involved in developing teh interfaces by creating templates and reusable components. Efficiently managed teh offshore support activities and exceeded client expectations.

Confidential

Sr. Business Analyst and DB Developer

Responsibilities:

• Interacted with business users, and documented business requirements and user stories.
• Created Business Requirements Specifications, Change Request docs, ETL documents to implement data flow changes for optimum utilization of available resources.
• Performed detailed analysis on teh requirements, designed and developed teh UI and database components for various modules and documented teh technical design document and test cases.
• Prepared data mapping and data schema for SQL Server data for both new and maintenance projects
• Designed and developed database components for various modules and data load interfaces for teh Scopus application, an issue tracking system to track teh Engineering Open Items, Call Center Trouble Tickets, Call Center Trouble Reports and Projects by teh engineering group.
• Designed, developed and tested various client and database components to handle teh access card generation, registration and monitoring system of teh truck drivers and trucking companies.
• Performed detailed analysis on teh requirements, designed and developed teh database structures and procedures for various modules and documented teh technical design document and test cases.
• Generated monthly report for various modules using Crystal Reports - Monthly report of registered truck drivers, Daily report for truck driver terminations, Daily report for Agency termination
• Involved in teh preparation of user manual and other documentation.

TECHNICAL SKILLS

• SSIS, SSAS, SSRS, Pentaho Data Integration
• MS SQL Server, MySQL, Oracle, MS Access
• Tableau Reports, Crystal Reports, Brio Reports, Google Analytics
• SQL, T-SQL, PL/SQL, Java, JavaScript, HTML, PHP, SOAP interfaces.
• UML, Rational Rose, Erwin, Visio, Salesforce, QTP, Rational Robot, Quality Center (ALM)
• WebLogic, WebSphere
• SharePoint,Trello, JIRA,VSS, CVS
• HP UNIX, Windows