PROFESSIONAL SUMMARY:

• 7 years of professional experience as a Business/Data Analyst in IT Industries
• Extensive experience of Data were housing projects with Data Migration, & DQ
• Work with Scrum Team to plan and conduct project design sessions to identify and specify logical system design
• Worked in Agile, has good understanding of SDLC as well as UAT environments and CRM
• Extensive knowledge in Requirement Gathering Analysis through user interviews, workshops and existing systems documentation and procedures used Doors
• Extensive industry experience in business needs identification and assessment; solution delivery methodologies, tools, techniques and trends; and business case development
• Proficiency in requirements writing and documenting; business process modeling and improvement, analysis; requirements traceability; acceptance test planning and execution
• Extensive experience in data collection, data manipulation with strong presentation skills
• Extensive experience of Data Source mapping, Data Analytics & Data modeling using Informatica Power Center, and Informatica Analytics, Backend data validation and Testing data warehouse tables
• Working knowledge of project management and organizational change management concepts
• Experienced in analyzing and preparing Project Deliverables such as Project Charter, Business Requirement Document (BRD) and Functional Requirement Document (FRD) and proposed changes for process improvement using Rational Requisite Pro
• Proficiency in Microsoft Office, and diagramming tools such as MS Visio & Tableau
• Good understanding of SDLC and project management principles and Experience of Large & complex data sets including ETL Power Center Informatica
• Skilled in Object Oriented Analysis and Design with experience in creating Use Cases, Class Diagrams, Activity Diagrams, State Diagrams, Sequence Diagrams, Business Object, Unified Modeling Language (UML) using MS Visio and Rational Rose to depict process flow
• Strong Data Warehousing, Data Marts, Data Analysis, Data Organization, Metadata and Data Modeling experience in RDBMS databases
• Excellent working experience in Teradata, Ab MS Access, Oracle and SQL
• Attending project meetings and work with teams, Project managers, team members / associates, business analysts, statisticians, and internal customers/ end users, working with multiple tasks
• Experience in understanding different business process, functionality requirements, and data requirements in relation to process and come up with scenarios to validate the flow
• Designed and developed weekly, monthly reports related to the marketing and financial departments by using SQL, PL/SQL, MS Excel and MS Access
• Extensive experience in data cleansing and analysis, using pivot tables, formulas (v - lookup and others), data validation, conditional formatting, and graph and chart manipulation
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and Interface requirements documents
• Experience creating design documentation related to system specifications including user interfaces, security and control, performance requirements and data conversion
• Experience in designing Test Cases/Test Scripts/Test Conditions for the Unit Testing, verifying and validating Web based e-commerce applications, Integration Testing, System Testing
• Worked with the users and testing teams to implement the business logic as expected
• Expertise in User-Interface, Database validation backend testing as well as Common Unix commands
• Has extensive experience in Manual Testing, including QuickTestPro
• Creative to understand complex problems and finding right solutions in time
• Team Player as well as able to work independently with minimum supervision, innovative & efficient, good in debugging and strong desire to keep pace with latest technologies

SKILL:

RDBMS: Oracle (SQL, PL/SQL, Stored Procedures, Ab initio, Teradata utilities SQL SERVER, DB2, Sybase and Access

Languages: SQL, PL/SQL, HTML & CSS

Operating Systems: Windows 2000/NT, XP, UNIX, Windows 7

Reporting Tools: Qlick View, Crystal reports 2011/2008/XI BO Enterprise, InfoView

Tools: Toad, Test director, Mercury quality center, MS Office, MS Excel, MS Access

PROFESSIONAL EXPERIENCE:

Confidential, DUBLIN, OH

Business/Data Analyst

Responsibilities:

• 5 years of experience in data analysisand data mapping experience, Proven understanding of database relationships
• Extensive SQL query building experience, wrote Data validation rules and performed backend data validation and Testing data warehouse tables to validate the quality of data and maintain the relationship between the entities
• Analyzed existing system logic difficulties and revised the logic and procedures as needed
• Written Business Requirement document & Functional /Technical Specification Document
• Strong and proven listening, communication, documentation, presentation and technical skills
• Ability to work well with people from different disciplines with varying degrees of technical experience
• Worked as an Data Analyst in a Data were housing project as a DQ Analyst Performed Data Modification as per business requirements, Written DQ rules
• Created Linage, Performed Data Profiling and profiling review, validation & verification of Golden Values
• Organized JAD sessions with on site & offshore team, Presented Agenda, Procedure, and Targeted goal, timeline and Scope
• Extensively written SQL queries, created Views, Store procedures on Oracle 11g, used different SQL advanced functions, expressions & pseudo logic
• Used SAS basics on Teradata for data validation,
• Designed high and Low level data flow charts & diagrams, Use case diagram, Process flow design with extensive Data Manipulation and presentation skill
• Experience with system and transaction data collection from various systems as well as Linage creation
• Data flow initiative, Developed flow charts, Performed Source to Target Mapping
• Verified data as per requirements and used changed process for Data Modification
• Created Data quality rules for validation and to maintain DQ based on requirements
• Performed Metadata Analysis and Analysis of Data profiling, Redundancy, Golden Values & Created Profiling reports
• Extensively worked on Production System UAT environment Basic experience of alert and monitoring of production systems
• Performed Data Cleansing, Data profiling & Data Quality Analysis by using Informatica Analytics, Teradata SQL Assistant & Ab Initio
• Performed ETL process created Source and Target definition, as well as Data Source mapping using Power Center Informatica
• Performed Data research and Analysis for data certification to Validate SOR, Valid Values and Data Linage, Data Mining and Visualization
• Managed Metadata & Performed DQ Analysis using Informatica, MRDX(Excel base tool), and Meta Tracker (MS Access) tools
• Used SQL Assistant to run SQL queries on Teradata, Ab Initio, Oracle & Enterprise MDR/ EDW
• Used Jira for defect tracking and Share Point for documentation and to maintain record as per process flow
• Created Data Certification initiative for different level of Data files in Meta Tracker for Data Certification Process
• Converted flat files to CSV files and uploaded to MDR for Staging
• Performed Data Naming, Data Merging & Data definition, & Meta Data Management and Gap analysis and Helped data integration Team on integration issues using SQL joins
• Maintained and followed Professional Metadata Governance Principles for PI and Non PI DEs
• Created test cases for reports requirements and UAT, executed all the test cases
• Created the test data for the flat files and verified the error logs worked on data matrix
• Involved in testing of the Verification and Validation and Production defects
• Performed Data security and Criticality analysis to categories data as Critical or non critical data
• Extensively used MS Office (Word, Excel) in documenting & reporting errors with screenshots
• Participation in kick-off, review, release readiness meetings and involved in multiple projects

Environment: SAS, Teradata, ICDW, Meta Tracker,(MS Access based tool), MRDX(Excel based tool), SharePoint, Jira, TDSQL Assistant, SQL Plus, Windows 2000/XP, MS Office Suite, Oracle 10g/9i, Toad, Qlik View and Informatica

Confidential, Richmond, VA

Sr.Business/Quality/Data Analyst

Responsibilities:

• Acted as a liaison between the developers and management staff and was instrumental in resolving conflicts between the management and technical teams
• Work with Scrum Team to plan and conduct project design sessions to identify and specify logical system design
• Worked in Agile, has good understanding and experience of SDLC as well as UAT environments
• Used listening, communication, documentation, presentation and problem solving skills and expertise to understand elicit and document business needs, used Doors
• Conducted meetings/interviews and JAD sessions with stakeholders to collect business requirements. This information along with the vision document was used to transform business requirements into System Requirement Specifications
• Worked on Multiple Applications like ULDD (Uniform Loan Delivery Data), LD (Loan Delivery), Early Check where Different Lenders Submit Loans to Fannie Mae
• Responsible for analyzing and translating business requirements for the development of business rules
• Actively involved in gathering and preparation of technical and business documentation for the application in design, which could serve as future reference to the programmers and system developers
• Conduct workflow, process diagram and gap analysis to derive requirements for existing systems enhancements
• Worked as an Data Analyst in a Data ware house project as a Analyst Written DQ rules
• Created Linage, Performed Data Profiling and profiling review, validation of Golden Values
• Extensive experience of Data Analytics on Informatica analytics and CRM(Chanel link Platform)
• Experience with system and transaction data collection from various systems
• Facets backend data tables & front end GUI navigation of Facets 4.11, 4.31, 4.71, 4.81, & 5.01.
• Executed Unix commands proficiently as required in the project
• Used Informatica Analytics, Meta Tracker, QlikView, Google Analytics and Excel spreadsheet for Data Quality Management
• Using RUP (Rational Unified Process) methodology, gathered requirements for the new system through questionnaires and interviews with management and users
• Decomposed high-level business and user requirements into prioritized functional requirements, specified in an appropriate level of detail suitable for both business and development team
• Perform Daily validation of Business data reports by querying databases using PL/ SQL commands and rerun of missing business events before the close of Business day
• Root cause analysis of data discrepancies between different business system looking at Business rules, data model and provide the analysis to development/bug fix team
• Lead the data Correction and validation process by using data utilities to fix the mismatches between different shared business operating systems
• Worked on mapping and modeling of the data
• Modified the existing mapping template to a more clear and easy to understand template
• Verifying data quality after every deployment and perform extensive analysis for the data variance pre and post implementation
• Created Reports using all the Business Objects functions like Drill Down, Prompts, and Dimensional and Measure variables to show accurate Results
• Extensively used HP Quality Center & MS Visual Studio (TFS) for various test activities such as identification and execution of test cases, defect tracking and fixation
• Involved in various different testing roll outs such as Regression, Rolling Regression, UAT (User Acceptance Testing)
• Raise tickets/issues with respective teams in the event of production failures and get in touch the respective teams to get the issues fixed as earliest as possible

Environment: MS Office, MS Project, UML, RUP, Visio HP UNIX, Clear Case, Clear Quest, Windows XP, SAS, Excel, Toad, PL/SQL, Shell Scripts, DB2, Crystal reports 2011,, Clear Case, Clear Quest, Doors, Share Point 2010,SQL Server 2008, VB, Pivot Tables

Confidential, Rochester, MN

Business/Data Analyst

Responsibilities:

• Gathered analyzed, validated, Managed and documented Business requirements
• Interacted with users to verify the application, managing change control process, updating the existing documentation
• Created functional requirement specification documents - which include UML diagrams, use case, scenarios, activity diagrams and data mapping
• Identified business directions and goals that could affect the necessary data and application architecture
• Facets data tables used to integrate all lines of business on single platform
• Defined the priority of business requirements, determine which business subject areas to provide the most relevant information, priorities and sequence of project implementation in accordance with it
• Provide relevant test scenarios for testing mostly
• Work with test team to develop system integration test scripts and provide test results meet business expectations
• Used Test Director QTP, Load Runner test management, functional, GUI, performance, stress testing
• Perform data validation, data integration and Backend / DB testing using SQL queries manually.
• Created test input requirements and prepare test data for data driven testing
• Mentored, trained on the Tech Guide & Company standards. Set up and coordinate the onsite offshore team, conduct knowledge transfer sessions offshore team
• Involved in various different testing roll outs such as Regression, Rolling Regression, UAT (User Acceptance Testing), etc.

Environment: SQL server, SAS, MS Access, MS power point, MS Excel, VBA, MS Word, Windows XP, Crystal Reports XI/2008, Rational Clear Quest, HP Quality Centre 10.0, BMC Remedy, MS Visio, Oracle 10g, MS SQL Server 2005, Toad, MS Office, MS Visio, Facets, UNIX, Windows

Confidential, Dallas, TX

Business/Data Analyst

Responsibilities:

• Worked as a Business Analyst and managed migration project lifecycle from initiation, implementation and testing phases as per SDLC
• Analyze spatial data for geographic statistics to in corporate into documents & reports using GIS
• Design and update database, applying additional knowledge using GIS
• Gathered Requirements, Analyzed and Documented Business Requirements Document, Functional Specifications Document, SRS, FSD, Nonfunctional Specifications
• Involved in requirements Analysis, Gap Analysis, Traceability Matrix, Use Cases, Activity, Class Diagrams, UML
• Documented Business Requirements Document, BRD Functional Specifications Document, Nonfunctional Specifications
• Developed Ad hoc queries, SQL queries to fill business analyst, Operations Analysts, Financial analyst data requests
• Involved in data analysis and returned a report with charts, descriptive statistics, Cross Tabulations, Tests and conclusions
• Provide key data elements to populate Monthly Fulfillment dashboard and executive dashboard
• Successfully applied schema, change scripts to existing objects for synchronizing with changing business rules
• Performed ETL Mapping using Informatica Power Center Mapping designer, created Expression, lookup, Filter Rank, Aggregator and joiner transformations
• Loading data by using the Teradata loader connection, writing Teradata utilities scripts (Fast load, Multiload) and working with loader logs
• Wrote various SQL queries using joins and sub queries in Teradata to develop Views for reports.
• Data Mapping and data validation for data inconsistencies
• Conducted Data Analysis required for data center migration and consolidation projects, migrated applications from outsourced hosting to internal data centers, and led hardware refreshes for legacy hardware
• Developed Data reports to match the ad-hoc business analysis requirements of client
• Identified and researched data issues and anomalies for data consistencies and improvement
• Analyzed data with SAS. Manipulated multiple datasets, aggregating data and merging datasets for analysis
• Used the Import and export procedures to transfer data into different formats, several SAS functions, Arrays for manipulating data for producing descriptive statistics. Exported SAS data to Excel to produce reports and graphs
• Use SAS Macros to create reports in html format. Updated reports each month and quarter with new data
• Extracted and imported data from SQL and Excel formats to SAS datasets
• Involved in analyzing the data using SAS datasets in data libraries
• Data output presented to managers and stake holders in Power point formats after complete data analysis, statistical analysis as and when required, and provided summaries of analysis
• Ensured integrity of data in reporting systems and resolved discrepancies
• Created Presentation Material using MS power point, MS Excel and MS Publisher
• Developed multiple MS Excel spread sheets to perform reconciliation, analysis, and reporting
• Involved in Database report development utilizing Crystal Reports XI, MS Access, Excel(charts/graphs, and pivot tables), and rePortal (Crystal Report Publishing Tool)
• Documenting the changes and verifying the change requests are done as needed
• Conducted UAT and post production assistance, Change Management Process

Environment: MS Office, MS Project, UML, RUP, Visio HP UNIX, Clear Case, Clear Quest, Windows XP, SAS, Excel, Teradata 12.0, toad, PL/SQL, Shell Scripts, DB2, Crystal reports 2011, Pivot Tables

Confidential, VA

Business Analyst / Process Analyst

Responsibilities:

• Involved in gathering requirements from the Project management Office, Understanding the design plan and the budget needed based on area for water supply Project
• Created Budget utilization Reports weekly, Monthly for management purposes
• Produced functional specifications and involved in weekly meetings with developers and business units to discuss outstanding technical issues and deadlines that must be met
• Coordinated project activities between clients and internal groups and information technology, including portfolio management and project planning
• Created UML use case, activity diagrams for the interaction between the analyst reports and reporting systems
• Analyzed user requirements, attend meetings of the Change Request document changes and implemented procedures to test the changes
• Participated in defect review meetings with team members
• Worked closely with project managers to record, track, prioritize and close bugs
• Generated weekly, bi weekly, monthly reports with help Oracle, SQL, MS Access, MS Excel

Environment: SQL Developer, Excel, SQL server 2005, SQL, Quality Center