Sr. Data Analyst Resume
Cincinnati, OH
SUMMARY
- 6+ year’s Professional experience as Data/Business Analyst in ETL process, business process analysis/modeling, database design and development of Web Based, and Client/Server applications.
- Expertise in transferring business requirements into data requirements.
- Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose & MS Visio.
- Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used the Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).
- Experience creating documents like Technical Design Document (TDD), Source to Target Mapping Document (STM), Data Requirement \ Data Gathering Document.
- Experienced in conducting Requirement Analysis, Designing Model, Designing Test Plans and developed database schemas based on the logical models.
- Experienced in creating\developing Logical & Physical Model for data structure.
- Experience working with the databases or tools like Teradata and Netezza.
- Experience with designing and verifying databases on Oracle and SQL Server RDBMS using Entity - Relationship Diagrams (ERD).
- Experience defining schemas and functional mappings for application integrations through EAI.
- Experience with ETL tools and ETL mapping functionalities.
- Good Experience with Data Transformation and Data Modulation process.
- Proficient in PL/SQL, as involved in writing complex SQL quires and Stored Procedures.
- Experienced in writing Test Plan and Test Cases and aggressively involved in Regression Testing and Performance Testing using automation tools like Win Runner, LoadRunner, Test Director, Quick Test Pro, Silk Test and Oracle table manipulation using SQL.
- Experienced Performing Profiling over large databases with multiple data sources.
- Experienced performing DA testing.
- Ability to gather business and Technical Requirements from both formal and informal sessions utilizing a variety of software methodologies including, Use Cases and the Rational Unified Process.
- Experience working as Joint Application Development (JAD) facilitator and meetings coordinator with excellent interpersonal skills.
- Experienced working on tools like Informatica and DataStagefor ETL operation.
- Experience using Informatica Data Quality tool for data cleaning and monitoring for other users and applications, and provide high quality data to business.
- Experienced using Informatica Data Quality components like Informatica Analyst and Informatica Developer for Analyzing and Profiling of data and providing different Transformation as required.
- Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
- Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
- Expertise and complete understanding of QA Life Cycle, which includes Designing, Developing, Execution and Documentation of the Test Cases, Automated Test Scripts and Test Plans.
- Expertise in data driven testing and setting parameters with the Performance Session Scripts.
- Expertise in Database Administration of Test Environment Databases, Data Pools and identifying the performance issues due to inefficient Database Administration.
TECHNICAL SKILLS
Programming Languages: C, C++, C#, VC++, C#.NET, ASP.NET, Java, SQL, PLSQL
Operating Systems: UNIX, Windows 95/98/NT/2000/XP, Linux.
Databases: MS-Access, MySQL, MS SQL Server, Oracle, Teradata, DB2, Sybase, Netezza
Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.
Automation Tools: MS Visio, Rational Rose, Rational ClearCase, RationalRequisitePro, Documentum, SAS Packages
Bug Tracking Tools: MercuryTestDirector, Rational ClearQuest
Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop
Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)
Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin, DataStage
Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunner
PROFESSIONAL EXPERIENCE
Confidential, Cincinnati, OH
Sr. Data Analyst
Responsibilities:
- Analyze incoming feeds, conduct data profiling and map the relevant fields to the target repository incorporating business validation rules to integrate the data.
- Worked on OLTP and OLAP processes.
- Extensively involved in writing Data Definition Language or Data Manipulation Language SQL queries for data transformation and creating tables and views.
- Extensively involved in providing manually reports to Business.
- Worked on creating some automation process for few manually reports.
- Interacted with the business users and gathered requirements and business definition for various data fields \ data measures.
- Performed Data Analysis and Verification on OLAP data to assure Data Quality and Accuracy.
- Acted as a Subject Matter Expert (SME) on many occasions to explain in brief to the business users about the data flow and reports.
- Performing some ETL operations. Creating ETL Jobs and validating data flow through various ETL stages.
- Design complex reports like aging analysis, invoices generation, profit/loss, and balance sheet using SSRS and Business Object.
- Moving existing SSIS packages to DataStage.
- Experience in Data Profiling for analyzing data over different kind of descriptive statistics
- Identified extra data variables needed for the project
- Used different Data Profiling techniques to provide accurate data for different purposes
- Coordinated closely with Architecture team and Developer team to get data from different sources and manipulate it as per requirements.
- Assisted development team in creating Data Schema and Data Mapping / Manipulation of the current data extract for relevant data
- Created Data requirement document and other technical documents likeSource-to-Target mapping document, Physical \ Logical Model diagrams, Data Flow Charts to define business rules for data transformation.
- Worked extensivelyon DB2, Advance Query Tool (AQT) and DataStage.
- Worked with ETL developersto provide mapping / data conversion from OLTP to OLAP.
- Performed data validation and massaging to ensure accuracy and quality of data.
Environment: MS Office Suite 2007, SQL, DB2, Advance Query Tool(AQT), Data Stage, Microsoft SQL Server, SSIS, Data Warehouse, Business Object, OLTP database, OLAP database,SharePoint.
Confidential, Englewood, CO
Data Analyst
Responsibilities:
- Analyze incoming feeds, conduct data profiling and map the relevant fields to the target repository incorporating business validation rules to integrate the data.
- Interacted with the business users and gathered requirements for the business definition.
- Performed data validation and massaging to ensure accuracy and quality of data.
- Acted as a Subject Matter Expert (SME) on many occasions to explain in brief to the business users about the data flow and reports.
- Experience in Data Profiling for analyzing data over different kind of descriptive statistics
- Identified extra data variables needed for the project
- Used different Data Profiling techniques to provide accurate data for different purposes
- Performed Data Migration from legacy SQL and Netezza tables to Teradata, and Data Mapping for easy and faster access to information
- Worked on OLTP and OLAP processes.
- Creating Charts and Graphs result based on Statistical Analysis of data.
- Coordinated closely with Architecture team and Developer team to get data from different sources and manipulate it as per requirements.
- Assisted development team in creating Data Schema and Data Mapping / Manipulation of the current data extract for relevant data
- Generated reports using Business Object to ensure the database to function properly.
- Created Source-to-Target mapping documents to define business rules for data transformation.
- Worked extensively with the tools like Teradata and Netezza.
- Worked with ETL tool (Informatica) to provide mapping / data conversion from Netezza to Teradata.
- Provided manually created Ad-Hoc reports to Business users on request.
- Wrote Data Definition Language or Data Manipulation Language SQL commands for data transformation and creating tables and views.
- Created test scenarios to test and validate incoming data.
Environment: MS Office Suite 2007, Oracle, SQL, Teradata, Netezza, Informatica, Data Warehouse, OBIEE, Hyperion, HP Quality Center, OLTP database, OLAP database.
Confidential, Bellevue, WA
Data / System Analyst
Responsibilities:
- Interacted with the business users and gathered requirements for the business definition.
- Created Functional Requirements Document (FRDs), Functional Specifications Document (FSDs) and Traceability Matrices for application development.
- Involved in the stack sessions, and met with all stake holders to understand, articulate, and document the requirements.
- Worked on projects which used RUP and Waterfall methodologies.
- Acted as a Subject Matter Expert (SME) on many occasions to explain in brief to the business users about the internal systems.
- Facilitated JAD sessions with the management, developers and analysts from all the dependant systems/applications and business users to refine functional requirements and to perform the Impact Analysis.
- Created mock up diagrams using MS VISIO and provided the screenshots replicating the changes to the User Interface (UI) as per the requirements.
- Created spreadsheets using MS EXCEL in data gathering stages for requirements mapping.
- Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the specifications for the product.
- Performed GAP Analysis, designed new business process flows, and documented various business scenarios.
- Helped with data modeling and defining the conceptual and logical model of the data warehouse.
- Conducted informal Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues and change requests.
- Experience in Data Profiling for analyzing data over different kind of descriptive statistics
- Used different Data Profiling techniques to provide accurate data for different purposes
- Conducted Cross-functional meetings to discuss the impacts from cross functional systems.
- Helped the Business Users while performing the UAT testing and helping them resolve the defects in the environment.
- Created Testing Requirements Document (TRDs) and Test Case Scenarios to test functional changes to the system/application as per the project requirements.
- Used XML to look up for the specific attributes and parameters needed for testing the web application in the QAT environment.
- Interacted with the testing team while developing the functional test cases and regression test cases.
- Kept a track of all QAT and UAT bugs/defects and helped the testers to resolve the issues and made a report of all the defects which were resolved and which were not using MS EXCEL.
- Created test scripts for all the test cases in PL/SQL.
- Designed Informatica ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts
- Defined XML schemas through EAI
- Facilitated Partner integration testing through triaging and routing the defects on a daily basis.
- Coordinated with the testing team while Smoke Testing at the time of deployment.
Environment: MS Office Suite 2007, MS Visio 2007, PL/SQL, SQL, Informatica, Netezza, SharePoint, MS SQL, SSIS, HTML, XML, Mercury Quality Center 9.0, RUP, Erwin, UML, Excel.
Confidential, NJ
Business / Data Analyst
Responsibilities:
- Interacting with the stakeholders to get a better understanding of client business processes and gather business requirements.
- Identified Use cases from the requirements and wrote Use Case Specifications
- Created business process workflow diagrams (Activity diagrams) in Rational Rose
- Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement
- Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes
- Integrated RequisitePro with ClearQuest and Rose to provide all teams visibility and maintain tractability among requirements, use cases and change requests
- Managed all the requirements in RequisitePro, making requirements available to all team members.
- Experience with ETL and EDI.
- Experience with EAI mappings.
- Assisted developer to write EAI schemas and map functionalities with TIBCO.
- Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using modeling tools.
- Performed Data Analysis of existing data through Data Profiling.
- Created test plan and test cases for user acceptance testing. Used Rational testing tools.
- Conducted informal Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests
- Used the Unified Change Management from Rational to track changes to multiple artifacts by versioning artifacts, associating requirements to specific change request/defects to streamline the defect/change tracking process.
- Performed Feasibility Analysis and Risk Analysis on vendor/third party tools.
- Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
- Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.
- Monitored client expectations and conducted user interviews.
Environment: Rational Rose, Rational RequisitePro, DB2, Informatica, JMP, Rational manager, SharePoint, Rational Administrator, SQABasic, DOORS, SQL, VB.Net, Oracle, IBM Business Modeler, UML.
Confidential
Business Analyst /Data Analyst
Responsibilities:
- Worked as an Interface between the Users and the different teams involved in the application development for better understanding of the business and IT processes.
- Met with clients & Stake Holders groups to determine User Requirements and goals.
- Utilized Rational Unified Process (RUP) to configure and develop process, standards procedures.
- Involved in writing Stored Procedures and views using PL/SQL
- Created Data structure and Data model diagrams associating myself with Data modeler.
- Created User Requirement Specifications (URS) and Functional Requirement Specifications (FRS) documents.
- Assisted in implementation of QA Processes to ensure correctness of data flowing through each stage of Informatica ETL
- Provided management with metrics, reports and schedules as necessary and participated in the design walkthroughs meeting using MS Project
- Participated in entering, tracking system defects in Rational Clear Quest
- Authored progress and completion reports, which were then submitted to project management on a weekly basis.
- Collaborated with Quality Assurance Analyst in Rational Clear Quest to track defects and used Rational Clear Case to maintain consistency in the builds.
Environment: Windows NT/2000,Business Objects 6.0, Rational RequisitePro, Data Stage, Data Warehouse, Rational Clear Quest, Visio, Oracle, SQL Server, PL/SQL, Test Director, Win Runner, Java, XML