SUMMARY:

• Sr. Business Analyst/ Data Analyst with over 8 years of diverse experience with Gathering Business and IT Requirements, Conducting Requirement Analysis, and Creating Functional Specification Documents, Use Cases and Test Plans and data cleansing operations.
• Having pretty good experience in data cleansing using Trillium data analytics, matching, standardization, and cleansing routines.
• Expert in preparing Business Requirement Documents (BR100), design documents (MD050) and Test Scripts.
• Collaborated with the Business for creation of use cases to assist in coming with detailed Business requirements
• Experienced in data analysis, data cleansing, data enrichment, data Integration techniques using Integration/Informatica tools to meet data quality standards.
• Functional and technical expertise in development and implementation of various Interfaces and Conversion programs in Oracle Applications.
• Understand the complexities and interdependencies of Business processes, data and systems.
• Responsible for application configuration, testing, and user training.
• Experienced in onshore/offshore development model and interacting with Business Users, Cross functional teams to gather requirements, design, developing the solution and resolve the issues.
• Strong Expertise in analysis, design, development, customization and implementation of client/server and web applications in Oracle.
• Strong Analytical, Interpersonal, Communication skills and excellent team player.
• Good project management, communication and presentation skills

TECHNICAL SKILLS:

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS, MS Office Suite, Business Object (Crystal Reports).

Web Servers: Apache, BEA / Oracle Web Logic, Oracle ATG, Endeca, Apache/Tomcat

Methodologies: RUP, OOAD, AGILE, UML & Business/Data Modeling

Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, PR Tracker

Operating Systems: Windows, Mac OS X, DOS, UNIX, Linux

Databases: Oracle 10/11g, SQL, Access 2000, MS SQL Server, MySQL, DB2, RDBMS

ETL /Analysis /Reporting: SSIS, SSRS, Business Objects & Crystal Reports.

Languages: Java, HTML, XML, CSS, UNIX Shell Script, JavaScript, SQL, J2EE

Case Tools: OOAD, UML, RUP, Junit, MOCK, BPM, SCRUM, AGILE, SDLC

Operating Systems: Windows, Linux, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

Sr. Business Analyst/ Data Analyst

• Played key role in identifying and setting up various legacy systems for data clean up to help in installation of Enterprise Resource Planning using Trillium software system to ensure data quality, for maintenance and data governance.
• Analyzed the system specifications, business requirements for full understanding of the project.
• Analyzed the Functional Specs reviews, detail Design Reviews and System Requirements Verification.
• Facilitated meetings between Business Analysts, Database Administrators and QA team to resolve issues regarding the requirement updates and/or changes in the database fields.
• Analyzed requirement updates and mapped them with the respective manual Test Cases.
• Coordinated with the functional QA team to document the business process properties including the need for parameterization in script.
• Worked with clients as Technical Liaison managing relationships with airport authority and vendors during strategy and planning phases for various projects in engineering and maintenance department of Ronald Reagan National Airport.
• Ensured end - users adhere to the data quality standards set forth by the Data Quality team by reviewing and correcting data changes.
• Used HP ALM to work on defects and resolved them based on the Severity/Priority. Worked with the testers by comparing the Verizon bills to Frontier bills for the same bill cycle and resolved defects based on the discrepancies.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Coordinated technical tasks and deliverables for Oracle EBS and related technology projects
• Carried out system testing, performance testing, acceptance testing of Mobile-custodial and Travelling Management System.
• Worked on mainframe system SCDB (Single Client Database) and verified that the interface between the legacy system and the DIA application is in sync.
• Developed Microsoft Access database system to maintain employee medical test records.
• Data cleanup projects on legacy systems to help in migration to ERP systems

Environment: MS Word, MS Excel, ERP Implementation, Oracle EBS, MS Visio, MS Project, MS Power Point, Platinum Erwin, Trillium, DB2 Utilities, IBM Utilities.

Confidential, Keene, NH

Sr. Business Analyst/ Data Analyst

• Developed different data mapping and transformation rules documents between Mainframe data and Oracle EBS application
• Developed different adhoc reports based on data from Heterogeneous systems like Teradata, Oracle and Files
• Compared the item / invoice attributes in both systems and documented transform rules
• Developed different attributes comparison reports from multiples business systems like EDW and Oracle EBS.
• Worked with Data Quality tools like Trillium during data analysis including data profiling and quality assessment of potential information sources
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures
• Confirming mappings and responding to questions from ETL team during design and coding phases
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface
• Documented data quality and traceability documents for each source interface
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
• Involved in data warehouse design.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked with internal architects in the development of current and target state data architectures

Environment: Teradata, Oracle, TTU Utilities, SQL Loader, SQL, PL/SQL, Toad, Data Stage Oracle SOA, Oracle EBS, OBIEE, Unix Scripts, MS Excel, Trillium tool, Erwin, Crystal Reports, PowerPoint, DB2 SQL Server, XML, Flat Files, Cobol Copy books.

Confidential, Indianapolis, IN

Business Analyst/ Data Analyst

• Research, analysis, prototyping and validating of mobile apps for click and collect functionality.
• Mapping and analyzing of customer journey to improve the make improvements to the processes. Decomposing user stories to clear requirements with acceptance criteria.
• Eliciting, reviewing, documenting, analyzing and prioritizing stakeholder requirements.
• Responsible for gathering and writing international requirements on new development eCommerce projects to launch major international sites: full site analysts including user facing content, usability flow, shopping cart and checkout processes.
• Coordinating workflow across eCommerce, IT, UI, retail and UAT teams.
• Designing of wireframes and prototypes to check if the user requirements are rightly gathered. Engaging external stakeholders on overcoming the challenges on the vendor management project.
• Responsible for identifying the business requirements that are not supported by Oracle EBS and map it to the areas of customizations required in Order-To-Cash (OTC) area.
• Requirement gathering to improve the customer returns management process. Assisted the Dev team to build code and QA team in designing the test plan and test cases
• Performed User Acceptance Testing (UAT).
• Monitored progress through Daily Stand-Up meetings, Bi-weekly Sprint Planning/Retrospective meetings, and end of the sprint demo meeting to customer.
• Created/Managed product backlog/user stories with SME's & defined Sprint backlog for each iteration based on priority, Managed Agile Life Cycle (Iterations/Scrum) using Jira and Leankit.

Environment: Rational Enterprise Suite (Rose, ClearCase, ClearQuest), RUP, SQL, SQL Server, Oracle, SAP, ERP Implementation, C#.Net, WebLogic, PeopleSoft, MS Visio, XML, SDLC, Microsoft Office, Word, Excel, Project and Visio, SOAP,, Excel

Confidential, Columbus, OH

Business Analyst/ Data Analyst

• Performed Requirements Gathering and Analysis through interactions, meetings and periodic walkthroughs with potential users of the application along with the creation of Use Case Scenarios based on business requirements.
• Developed system process flows and User Requirements Specifications through surveys and interviews.
• Involved in ETL and data cleansing of the contacts database for successful migration of legacy contact database to new CRM application-Siebel.
• Performed UAT on the Data Marts and validated the models against the business requirements.
• Prepared the ETL mapping specifications to extract data from the existing source systems to the Data marts.
• Data analysis using SQL, data quality validation, data governance (business processes, policies).
• Prepared Data Cleansing methodologies by relating them to DQ issues.
• Assisted ETL developers with the design and development of ETL workflows for extracting, data cleansing, transforming, integrating, and loading data into different Data Marts.
• Maintained data consistency and database integrity and attended team meetings to identify requirements for data loading and reporting.
• Documented data sources and transformation rules required populating and maintaining data warehouse content.
• Conducted the Data Analysis and identified the Data quality issues using Data profiling methodologies.
• Developed strategies with Quality Assurance group to implement Test Cases in Quality Center for stress testing and UAT (User Acceptance Testing).
• Wrote Test Plan and created Test cases and scenarios for the various Reports and Dashboards in accordance with the business requirements.
• Responsible for writing and updating test plan documents for every version update to the Data Mart.
• Prepared/Reviewed weekly testing status and reports. Presented program-level testing information at meetings as requested.

Environment: Teradata, Oracle, SQL Server, MS Visio, Agile methodology, MS Power Point, Platinum Erwin, Rational Rose, Requisite Pro, Microsoft Office Suite ( Word, Excel, Power Point, Visio)

Confidential - Richardson, TX

Business Analyst/ Data Analyst

• Working for Frontier Telecommunications as a Data Mapper in the Products, Services & Equipment (S&E) team.
• Responsible for modeling and mapping data fields from the source systems (Verizon) to the target's (Frontier) existing systems
• Working with the legacy teams and the business in helping define and develop business rules, value maps, source to target data mapping documents
• Maintain traceability matrix across the project life-cycle, created source to target maps, tracking requirements status, data profiling, data quality checks, managing changes to requirements and versions of requirements document
• Developed the Data Quality Standards Policy and other technical documents as it relates to Oracle using Word Document and Visio.
• Worked on the mapping spec for CBSS (Customer Billing Services System) to map the source data to Frontier's DPI billing system.
• Assisting ETL (Informatica and RPG) development teams in development activities.
• Performed data pulls using SQL as requested by the Sr management and business for reporting and/or defect resolution purpose.
• Identify what data/information is missing from the source system tables and work with the business to default those values based on some conditions.
• Used Informatica, SQL Developer and TOAD to connect to different databases like DB2, Oracle and SQL Server.
• Analyze the defects and close the defects within the target date, working with the System Testing and UAT teams to understand and resolve critical defects.
• Worked extensively on AS/400 green screen to support DPI Billing System.

Environment: MS Visio, MS Word, MS Power Point, MS Excel, MS Visio and MS Project, SAS, Cobol, JCL, CICS