OBJECTIVE:

• Analytical and Accomplished Business Data Analyst with over 7 years of diversified experience including strong Business/Market Data Analysis experience in IT industry is seeking a business data analyst position which will utilize and in corporate my current skills and experience, as well as expand them to assist the organization in being successful.

SUMMARY

• Experience in Banking & Financial Services, Insurance, Retail, E - Commerce, and Web Application.
• Led requirements gathering effort with business partners and internal/external Stakeholders.
• Documented requirements for new as well as enhancements to existing data and reporting.
• Developed test plans, test cases, test data, and test scripts to ensure that requirements have been accurately addressed.
• Performed data analysis for the purposes of profiling new data sources, researching data issues, and responding to business partner questions.
• Executes testing, reports on results, and works with the technical team to address and resolve any identified issues.
• Excellent understanding of Business / Market Intelligence, Databases, Data Warehousing, Data Mapping, Data Modeling, Data Migration and Data Integration.
• Experience in preparing various business documents like Project Charter, Business Requirements Document, Functional Specification Document (FSD), Requirement Traceability Matrix (RTM), Process Flows, Test Plan and Test Cases.
• Experience building databases and implementation offinancial data warehouse applications.
• Extensive experience in Data Transformations, Data Loading, and Performance Tuning.
• Extensive experience in interaction with business user, understanding their requirement and delivering reports and other permission related solutions in time.
• Experience in SQL programming techniques and tuning/tracing using MS Access.
• Expert knowledge in designing storyboard, wireframesand prototype, Usability testing.
• Extensive experience working on different databases such as IBM’s DB2, Oracle, My SQL, Teradata using TOAD, SQL Developer and SQL Assistant.
• Experience in different management scenarios like Change Control, Quality Assurance, Project Schedules and Timelines.
• Have exposure working with other analysts, QA team to set priorities and schedules.
• Good knowledge of Business Process Modeling and Business Re-Engineering.
• Skilled inObject Oriented AnalysisandDesignwith experience in creatingUse Cases, Class Diagrams, Activity Diagrams, State Diagrams, Sequence Diagrams, Unified Modeling Language (UML)usingMS VisioandRational Roseto extract business process workflows.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows (2000/ME/XP/Vista/7), Linux

Business Modeling Tools: Microsoft Visio, Rational Rose, MS Office

Database and Tools: Oracle 10g/9i/8i, My SQL, TOAD, MS SQL Server, Teradata

BI Tools: Business Objects, Tableau, COGNOS, SSIS, SSMS

ETL Tool: Informatica Designer, Workflow, OBW

Methodologies: Rational Unified Process, Agile, Waterfall, RAD and Prototyping

Quality Management: HP-ALM(QC) Quick Test Professional, Win Runner, Rational Enterprise Suite

Web Development Tools: Dreamweaver, Eclipse, RAD 6, WSAD 5

Other Tools: SharePoint, Lotus Notes, XML Spy

Multimedia: Adobe Photoshop, Adobe Illustrator

Web Technologies: Web 2.0, AJAX, XML, HTML, CSS, J2EE, XSL, Dream weaver MX, MS Front Page 98.

Others: ERP, CRM

PROFESSIONAL EXPERIENCE

Confidential - New York, NY

Data Analyst

Responsibilities:

• Used Rational Rose for Use Cases, Activity Diagrams under the Agile Methodology.
• Prepared custom reports of the new product and performed SQL query, data analysis and verification on MS Access to report to the V.P. of product management.
• Designed and implemented “Managed Account Select” investment management product for high net worth (HNW) and ultra high net worth (UHNW) individuals.
• Launched new managed account product into the marketplace, increasing revenue by $50 million.
• Analyzed, mapped, transformed and transferred data between varieties of data formats.
• Utilized Metric studio feature of Congo’s to monitor, analyze and report on KPIs.
• Utilized a variety of reporting tools such as Crystal Reports and Oracle for querying underlying database tables and resolve data issues.
• Designed and implemented SQL queries for testing and reporting.
• Working with dynamic dashboards, score cards to deliver highly interactive solutions to end user, very helpful in predicting trends in the market.
• Created a universe on Business Objects to include fields related to wealth management product.
• Documented Process Flows and presentations using Visio and Power Point.
• Used SQL queries to extract data from different databases including testing and production for data validation and data analysis. Participated in testing software by conducting User Acceptance Testing (UAT).

Environment: Rational Rose, Business Object, Crystal Reports, QuickTestPro, MS Visio, J2EE, Apache Logger Utility, IBM WebSphere, ClearCase

Confidential - San Jose

Data Analyst

Responsibilities:

• Performed BI(Business Intelligence) and ETL (Extraction Transformation and Load) Analyst role interfacing with subject matter experts to understand and define the functional and information requirements supporting reporting applications by outlining data strategy and report specifications and documenting these in the Specific Data Requirements Document (SDR) and Functional Requirement Documents (FSD).
• Led requirements gathering effort with business partners and internal/external Stakeholders.
• Documented requirements for new as well as enhancements to existing data and reporting.
• Developed test plans, test cases, test data, and test scripts to ensure that requirements have been accurately addressed.
• Performed data analysis for the purposes of profiling new data sources, researching data issues, and responding to business partner questions.
• Executes testing, reports on results, and works with the technical team to address and resolve any identified issues.
• Worked on business processes to detail transformations necessary to better link strategy with operations by analyze the effectiveness of current Mapping with-in Service Supply Chain and populate Map and Gap document.
• Interpret the collected report's data by dissecting underlying SQL of the report.
• Interpret Informatica and OBW mapping data and make comparisons with the planned activities.
• Led Requirement Validation meetings with team members and developers to verify requirements, enhancements and modifications by populating FSD and getting Signoff from Stakeholders and Managers.
• Prepared detail Specific Data Requirement document with required data elements to support Logical and Physical Data modeling sessions. Participated Logical and Physical Data modeling session.
• Worked with detailed ETL design documents and target-source mapping templates based on requirements.

Environment: Oracle 10g, Teradata, SQL, Informatica Designer, TOAD, Business Objects, Tableau, MS Excel, MS Visio and MS Power Point.

Confidential - San Leandro, CA

Data Analyst

Responsibilities:

• Led requirements gathering effort with business partners and internal/external Stakeholders.
• Documented requirements for new as well as enhancements to existing data and reporting.
• Developed test plans, test cases, test data, and test scripts to ensure that requirements have been accurately addressed.
• Performed data analysis for the purposes of profiling new data sources, researching data issues, and responding to business partner questions.
• Executes testing, reports on results, and works with the technical team to address and resolve any identified issues.
• Actively provided SOR-related certification, documentation and remediation in Wholesale Data Stewardship projects, e.g. iHub, Controls and Gaps Assessment, Data Cleanup, Data Attestation
• Ensured that current SOR Service Level Agreements, Data Usage Agreements, System Interface Agreements, Data Security Agreements, Technical and Business Metadata, Business Rules, Data Models, Entity Models, Operational Risk Documentation, File Transfer Information, etc. are accessible, maintained, and certified by SOR Stewards in intervals established by Data Stewardship
• Documented flow of data from point of origin to SOR, access controls and create action plan for gaps.
• Participated in implementing data quality standards, strategies, and initiatives at the system level
• Aligned with any required data definitions and considerations of associated business process, workflow processes, and rules
• Build data quality projects into application strategic plan and LOB project funding plans
• Exerted influence and oversee input processes that feed systems to ensure consistency
• The System Data Stewards key activities for master reference data include:
• Provided inputs and reviewing requirements to ensure the completeness of detailed requirements captured
• Reviewed relevant definitions and metadata for ensuring valid values finalized have taken into account all relevant applications/ systems
• Reviewed test cases and scenarios for completeness
• Resolved and remediating issues with underlying system of record data

Environment: Oracle 10g, SQL, Informatica Analyst, Erwin, HP Quality Center, MS Excel, MS Visio and MS Power Point.

Confidential - Cupertino, CA

Functional Analyst

Responsibilities:

• Communicated well with Business and Confidential IS&T team members, including SAP Basis, SAP BW and EDW Teradata development team.
• Analyzed the problems/issues faced by business, communicate to IS&T.
• Understand the technical solution and constraints faced by IS&T, communicate to Business.
• Negotiated alternate timelines with Business and Confidential IS&T.
• Good written and verbal communication skills, including ability to create Keynote/PowerPoint presentations.
• Made updates to a business-facing wiki / intranet web site Confidential internal.
• Good understanding of data warehousing and dimensional data.
• Performed data analysis pertinent to the business problem. Expand knowledge of Confidential 's data over time.
• Proposed high-level solutions for business problems.
• Attended design reviews conducted by technical team and ensure that business requirements are being met.
• Created test plan and test scenarios, execute test cases to ensure that business requirements were met correctly.
• Understanding of the Finance and Sales Finance subject areas.
• Initiated, reviewed and uploaded Test scripts in Radar
• Developed Mapping between SAP PX4, SAP Business Warehouse, EDW Teradata Core and Semantic Layer
• Validated Data on UAT, IT and Production environment of SAP and Teradata.

Environment: SQL, Teradata, SAP, Business Objects

Confidential - San Francisco, CA

Business Data Analyst

Responsibilities:

• Successful delivery of MDM production system and business processes across 3 main business segments of Citi and to different geographic regions (Europe, North America and Asia Pacific)
• Participated in gathering business requirements and analysis of the business processes and identified process improvements
• Responsible for offering primary and timely technical support.
• Involved in data mapping of the project requirements, queried the database using SQL queries for data mining, data analysis and data modeling.
• Project scope extended to include integration of SAP Business Objects (SBO) with MDM for data transformation and migration activities.
• Involved in campaign sizing, planning direct marketing campaigns for Enterprise marketing.
• Have offered back-end, ad-hoc support in ensuring shipping of campaign files to the end users or relevant stakeholders in a timely fashion.
• Implemented data governance process for these data objects
• Analyzed business requirements and created Use Cases, Sequence diagrams, Activity diagrams using MS Visio as per UML methodology
• Participated in the system design exercise with the Application development team and utilized Rational Unified Process (RUP) methodology
• Participated in the logical and physical design sessions, assisted the DBA and application development team in database design using Oracle
• Worked closely with Operations groups to ensure accuracy of data being used to track credit portfolio
• Enhanced data structures and converted essential processes into standardized reports for Portfolio Manager
• Worked closely with other project teams such as Portfolio Management and Credit Risk management
• Collaborated with QA team for UAT and assisted in development of automated test scripts using Mercury Test Director. Created test data inputs for both positive and negative scenarios for regression testing
• Provided status updates to the Project Sponsor and Senior Management on a regular basis using MS PowerPoint presentations and project updates using MS Project for management review
• Implemented PMO measurement processes directly linking project implementation and success criteria delivery to compensation for all project stakeholders from analysts to EVP Executive Sponsors.
• Produced a variety of routine and ad-hoc financial reports, packages and pro formats for senior management using advanced MS Excel functions.

Environment: Web Logic, Java J2EE, Oracle, MS Visio, MS Project, MS PowerPoint, Mercury Test Director

Confidential - Boston, MA

Data Analyst

Responsibilities:

• Involved in gathering data requirements from Sales and Financial organizations to understand the forecasting techniques and practices. Utilized SQL queries for Data Analysis and Data Modeling
• Extracted data from different department to flat files and load the data to the target Oracle and SQL server database
• Conducted JAD sessions with various sales teams, executives and developers to finalize the requirements and created a prototype of the important pages using Dreamweaver and HTML
• Captured the business requirements around sales and forecasting techniques and created Business Requirements and Functional Design Specification documents using Rational Requisite Pro
• Conducted GAP analysis to document “AS IS” scenario to understand current forecasting techniques and practices to get an agreement from all users to come up with a proposal for the “TO BE” system
• Developed Use Case Diagrams, Activity Diagrams and Sequence Diagram using Rational Rose
• Worked closely with various interfacing development groups such as UI front-end, middleware and backend to communicate the business requirements in a concise way
• Used SQL for querying underlying database tables to analyze the forecasting data and worked with the Data Modelers to create Data model diagrams in working sessions
• Introduced web 2.0 concepts to the web platform like AJAX, Blogs and wiki
• Developed test plans and test cases for UAT testing and also helped in data scrubbing in the test environments
• Maintained Issues Log and led follow up meetings to discuss issues to come up with resolution and action items
• Conducted and participated in Peer Reviews, Walkthroughs and Project Status meetings using MS PowerPoint to communicate project updates to management and project teams
• Worked closely with the Project Manager and used MS Project to schedule and track the project activities

Environment: Rational Rose, Rational Requisite Pro, J2EE-Java, JSP, IBM DB2, WebSphere 5.1, Dreamweaver. Oracle, MS Access, MS PowerPoint, MS Project