SUMMARY

• 7 years of professional experience as a Business/Data Analyst in IT Industries
• Extensive experience of Data were housing projects wif Data Migration, & DQ
• Work wif 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 wif 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 principals and Experience of Large & complex data sets including ETL Power Center Informatica
• Skilled in Object Oriented Analysis and Design wif 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 wif teams, Project managers, team members / associates, business analysts, statisticians, and internal customers/ end users, working wif multiple tasks
• Experience in understanding different business process, functionality requirements, and data requirements in relation to process and come up wif scenarios to validate teh flow
• Designed and developed weekly, monthly reports related to teh 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 teh Unit Testing, verifying and validating Web based e-commerce applications, Integration Testing, System Testing
• Worked wif teh users and testing teams to implement teh 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 wif minimum supervision, innovative & efficient, good in debugging and strong desire to keep pace wif latest technologies

TECHNICAL SKILLS

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 teh quality of data and maintain teh relationship between teh entities
• Analyzed existing system logic difficulties and revised teh 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 wif people from different disciplines wif 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 wif 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 wif extensive Data Manipulation and presentation skill
• Experience wif 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 Principals for PI and Non PI DEs
• Created test cases for reports requirements and UAT, executed all teh test cases
• Created teh test data for teh flat files and verified teh error logs worked on data matrix
• Involved in testing of teh 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 wif screenshots
• Participation in kick-off, review, release readiness meetings and involved in multiple projects

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

Confidential, Richmond, VA

Sr.Business/Quality/Data Analyst

Responsibilities:

• Acted as a liaison between teh developers and management staff and was instrumental in resolving conflicts between teh management and technical teams
• Work wif 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 wif stakeholders to collect business requirements. dis information along wif teh 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 teh development of business rules
• Actively involved in gathering and preparation of technical and business documentation for teh application in design, which could serve as future reference to teh 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 wif 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 teh 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 teh new system through questionnaires and interviews wif 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 teh close of Business day
• Root cause analysis of data discrepancies between different business system looking at Business rules, data model and provide teh analysis to development/bug fix team
• Lead teh data Correction and validation process by using data utilities to fix teh mismatches between different shared business operating systems
• Worked on mapping and modeling of teh data
• Modified teh existing mapping template to a more clear and easy to understand template
• Verifying data quality after every deployment and perform extensive analysis for teh data variance pre and post implementation
• Created Reports using all teh 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 wif respective teams in teh event of production failures and get in touch teh respective teams to get teh issues fixed as earliest as possible

Environment: Remedy, 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, Clear Case, UNIX, Windows.

Confidential, Rochester, MN

Business/Data Analyst

Responsibilities:

• Gathered analyzed, validated, Managed and documented Business requirements
• Interacted wif users to verify teh application, managing change control process, updating teh 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 effect teh necessary data and application architecture
• Facets data tables used to integrate all lines of business on single platform
• Defined teh priority of business requirements, determine which business subject areas to provide teh most relevant information, priorities and sequence of project implementation in accordance wif it
• Provide relevant test scenarios for testing mostly
• Work wif 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 teh Tech Guide & Company standards. Set up and coordinate teh 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 wif 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 wif 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 teh Teradata loader connection, writing Teradata utilities scripts (Fast load, Multiload) and working wif 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 teh ad-hoc business analysis requirements of client
• Identified and researched data issues and anomalies for data consistencies and improvement
• Analyzed data wif SAS. Manipulated multiple datasets, aggregating data and merging datasets for analysis
• Used teh 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 wif new data
• Extracted and imported data from SQL and Excel formats to SAS datasets
• Involved in analyzing teh 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 teh changes and verifying teh 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 teh Project management Office, Understanding teh design plan and teh 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 wif 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 teh interaction between teh analyst reports and reporting systems
• Analyzed user requirements, attend meetings of teh Change Request document changes and implemented procedures to test teh changes
• Participated in defect review meetings wif team members
• Worked closely wif project managers to record, track, prioritize and close bugs
• Generated weekly, bi weekly, monthly reports wif halp Oracle, SQL, MS Access, MS Excel

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