7 years of versatile experience as a Business Data Analyst specializing in Business Requirement Gathering, Business Intelligence, Data Analysis, Data Mapping, Data Governance, Change Management, Vendor Management and Project Coordination

SUMMARY

• Possess strong program management skills, having coordinated a multi-million dollar data mapping initiative, effectively managing IT, vendors and business aspects between various cross functional teams
• Extensive experience in business process development with expertise in analysis, design, development and implementation of applications
• Deep knowledge of data mapping programs and the know-how to setup a governance model
• Ability to work effectively in a global team setting, having coordinated regularly with stakeholders and team members from 6 continents
• Extensive knowledge of data mapping technologies, including the Duns and Bradstreet (DnB) system
• Ability to glean requirements from business users by asking the right questions and translating it into IT speak efficiently
• Strong experience in the documentation of test plans, test cases, BRDs, FSDs, user acceptance test scripts, support plans and training documents
• Adept with Business Objects, Oracle Business Intelligence (Seibel Analytics), SQL and ER diagrams
• Proficient in creating excel spreadsheets and in making pivot tables so as to discover patterns and trends in large data sets
• Excellent in providing customer support and customer training in various applications and ensuring high adoption rate
• Experience in testing methodologies, QA strategy, data analysis, data modeling, development, maintenance and documentation
• Excellent analytical, problem solving, communication and interpersonal skills
• Well versed with the channel organization structure and their needs
• Ability to juggle multiple roles effectively and can seamlessly transition between program manager, data analyst, business analyst, vendor coordinator and quality assurance analyst with ease
• Adept at creating project plans and ensuring on time delivery while maintaining the quality of the deliverables with in house teams as well as vendors
• Experience in the full life cycle of the software development process including requirements definition, prototyping, and proof of concept, design, implementation, testing and maintenance
• Extensive database experience using Oracle, SQL Server 2000, MySQL and Access
• Experienced in end to end ETL process consisting of data transformation, dimension modeling and data mapping from multiple sources over various business rules
• Ability to deal efficiently with third party vendors, performing QBRs and ensuring delivery on time, inline with the SLAs
• Diligently maintain updated documentation on shared drive and sharepoint to ensure easy access to project documentation for all stakeholders

TOOLS & TECHNOLOGIES:

Methodologies

SDLC, RUP, UML

BI / Reporting tools

Business Objects, Siebel Analytics (Oracle Business Intelligence), Excel

Data Warehousing/ ETL

Informatica

Microsoft Project, Microsoft Office, Visio, SharePoint

C, C++, SQL, PL /SQL, SQL*PLUS

Databases and Tools

Oracle, MS SQL Server, MS-Access, MySQL, Toad, Raptor

Windows Vista/ XP/ 2000/ NT/ 98/ 95

SalesForce, Siebel (Oracle)

Remedy, Bugzilla, VMWare, Wise Package Studio, InstallShield, SharePoint

WORK EXPERIENCE:

Confidential, Cupertino CA Nov 07 - Present
Business Data Analyst
Confidential, is a software and service provider. I was responsible for the sustenance and smooth operation of a multi-million dollar global channel data mapping initiative. I also performed partner operation activities for Sales Force PRM and acted as a SME for partner data for customer data hub and B2B ecommerce programs
Responsibilities:

• Gathered business requirements, met with client groups to determine user requirements and goals, and analyzed business needs to prepare project specifications
• Acted as the global coordinator for the data mapping project, ensuring issues were resolved and data processing completed in a timely fashion
• Worked with finance, IT and the business teams to determine data dependency & data consistency
• Setup data governance touch points with key teams to ensure data issues were addressed promptly
• Held weekly touch points with the stakeholders which included the regional partner program managers, global channel teams, sales teams, various IT teams, finance and vendors
• Created support documents for various data initiatives
• Created the project plan to track progress and drive deliverables to closure
• Drove change in revamping the data mapping process to accommodate new finance rules and data changes
• Acted as a SME for other partner data related projects and helped identify pain points when data mapping was being brought in house with a customer data hub (CDH) project
• Performed gap analysis to ensure the hub took care of all the business needs
• Assisted the change management team in identifying success metrics and quantifiable adoption rates
• Involved in the B2B ecommerce initiative and represented the partner component of the project that aimed to enhance customer experience while recapturing lost renewal opportunities
• Helped create a test plan for the launch of the B2B program with key metal partners
• Supported stakeholders by providing necessary report training and provision of reports, as needed
• Performed data audit to ensure data quality of the mapping performed by the vendors
• Reviewed service level agreement (SLA) documents to ensure key pain points were addressed in the legal documents
• Hosted quarterly business review (QBR) sessions with the vendor and compiled metrics on the vendor performance for review
• Reviewed the statement of work (SOW) to ensure vendor was providing agreed upon services
• Complied and sent the weekly data rematch files for incorrect mappings
• Facilitated IT and vendor engagement to tackle system issues
• Managed issue log in Remedy and created weekly tracking reports on vendor performance
• Performed data analysis on DnB matching system to ensure set threshold met business data quality needs
• Created ad hoc BO reports for business users on partner revenue data and scheduled or mailed them the reports, based on user\'s BO skills
• Created training documents for file share servers, SFDC case tool and report usage
• Hosted training sessions on the data being provided and BO reports for easy access
• Performed SFDC operations by coordinating global requests and proactively getting BRDs created to ensure critical cases were delivered on time
• Reviewed SFDC functionality and customization feasibility with global sales stakeholders
• Held weekly calls with SFDC IT to ensure there was traction on all the issues
• Managed the SFDC monthly maintenance releases with IT

Environment: Business Objects, SQL, Excel, MS Access, MS Visio, MS Project, Windows, Remedy, Sharepoint

Confidential, Thousand Oaks CA Apr 06 - Oct 07
Data Analyst
Confidential, is a diversified financial services company with mortgage banking at its core. I was involved in creating a data warehouse to enrich the customer and market analysis reports and providing design and development recommendations for process improvement
Responsibilities:

• Involved in the business intelligence, data warehouse development/ maintenance and enterprise reporting administration and delivery
• Gathered business requirements, met with client groups to determine user requirements and goals, and analyzed business needs to prepare project specifications
• Reviewed existing business procedures and conducted feasibility analysis
• Prepared detailed statistical reports in Excel to track various KPIs
• Developed numerous reports utilizing Business Objects and Excel and was responsible for scheduled reports plus ad hoc requests, querying from multiple data sources from Oracle, MS Access, Excel to flat files
• Created report and dashboard mockups for easy visualization and to ensure meets were being met
• Executed SQL queries using TOAD to retrieve data from multiple tables and to check database values
• Analyzed corporate database information to resolve data accuracy and integrity problems
• Performed gap analysis to identify the deficiencies of the current system and to check the compatibility of the existing system infrastructure with the new business requirements
• Involved in training the end user in basic, scheduled and advanced ad hoc reports as well as generate queries, format results, and share them with other users using Web Intelligence
• Assisted the project managers with the preparation of project plan using MS Project
• Documented process flows, policies and procedures using Microsoft Visio
• Involved in the designing and building of universes, classes and objects for financial accounting users
• Prepared specification for migrating data from the old systems into the new data warehouse
• Adept in data warehousing methodologies, schemas and best practices
• Prepared test cases and coordinated with QA team and UAT team in validating the system and coordinated with the development team in bug tracking and bug resolution
• Was instrumental in preparing all documentation related to the project
• Provided Adhoc financial reports and analysis to executive staff on revenue data and sales team targets

Environment: Business Objects, Oracle 10g, SQL, TOAD, Excel, MS Access, MS Visio, MS Project, Informatica, Windows

Confidential, Denver COFeb 05 - Feb 06
Business Analyst
Confidential, is a service provider with products spanning from telecom to internet. I was part of the IT BA group that catered to in-house cross functional IT projects that spanned the company
Responsibilities:

• Gathered business feedback through personal interviews with various departments, response surveys, prototyping and from shadowing account managers, financial analysts, and other users
• Ensured that communication was clear while working as the primary liaison between the business users and the developers during the project cycle
• Created and managed the use cases, sequence diagrams, collaboration diagrams, activity diagrams and class diagrams
• Created functional specification documents and IT/ QA and UAT test scripts
• Assisted QA analysts in debugging issues and issue resolution
• Assessed project status and tracked defects for quality control
• Developed various reports (ad hoc and scheduled), dashboards using Siebel Analytics for user verification and exported reports into formats like PDF, HTML, Excel and Word
• Participated in joint application development (JAD) sessions for requirement gathering, communicating and managing expectations
• Aided in the creation of documentation including user manuals and similar training materials
• Monitored project schedules, mitigated risks, and managed customer expectations
• Repackaged in-house and third party applications for company wide deployment that would work on multiple platforms
• Customized the instillation package to adhere to company policies
• Published packaged applications using active directory

Environment: Oracle 9i, Siebel Analytics, SQL, MS Office, MS-Project, Windows, Wise Package Studio, Active Directory, VMWare

Confidential, Hyderabad, India July 02 - Dec 04
Asst Quality Assurance Analyst
Confidential, is a major full service international bank. I was involved in testing the applications developed for various products being launched in India.
Responsibilities:

• Interacted with the subject matter experts, stakeholders and business teams to get a better understanding of client business processes and needs
• Supported design efforts by lead architects by defining data models and use case analysis models
• Utilized UML\'s structured methodology to gather, create, and document business process flows, activity diagrams, and sequence diagrams
• Performed end to end testing via black box, white box, load, stress and regression testing
• Supported post production testing to ensure production validation passed
• Assisted with user acceptance testing when user interface was not available to ensure easy testing of back end capabilities for business users
• Scheduled meetings with developers, system analysts and testers to ensure optimum resource allocation and meet projected project completion dates
• Wrote SQL queries to validate test results
• Tested on various browsers and systems to ensure compatibility
• Created process work flows, functional specifications, and was involved in preparing software requirement specifications, functional specification document and final design document
• Utilized the RUP methodology to implement products from inception through solution implementation
• Played a key role in the planning, user acceptance testing and implementation of system enhancements and conversions
• Created product documentation, including online help and user manuals
• Involved in all phases of testing, including user training during user acceptance testing

Environment: Windows, MS Office, Oracle 8i, RUP, UML, SQL.

EDUCATION:
BS in Electronics & Communications, Jawaharlal Nehru Technological University, India