Sr. Data Analyst Resume
San Francisco, CaliforniA
SUMMARY:
- Over 8+ years experiences as Data Analyst Healthcare, Insurance domain with expertise in Data Warehousing, Data Integration, Business Intelligence(BI) Data Warehousing.
- Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
- Experience in Data Migration, Data conversion, Data Integration.
- Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
- Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing, DataMarts and ODS using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
- Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
- Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
- Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
- An excellent experience in generating ad - hoc reports using Crystal Reports 9 and T-SQL.
- Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects.
- Strong knowledge of Unified Modeling Language (UML), System Development Life Cycle (SDLC) methodologies like Waterfall, Rational Unified Process (RUP) andAgile/SCRUM.
- Experience inDataMining,Datamapping andDatamodeling and good understanding of the ETL tools like AB Initio, SSIS and Informatica Power Center.
- Experience with working in UNIX/Linux operating systems.
- Extensive experience in writing Complex SQL Queries, inline queries, Sub queries, Co-related sub queries, Dynamic SQL queries, T-SQL queries, and PL/SQL stored procedures etc.
TECHNICAL SKILLS:
ETL Tools: Informatica Power Center Informatica Power Exchange, SSIS, SSRS
Database Tools: SQL Plus, SQL Loader, SQL Developer, Python, TOAD, Teradata, ETL,Data Stage/Quality Stage, Cognos BI SAS
Operating System: Windows Server, Windows Server, Windows NT / XP and Windows Linux, UNIX
Tools: Java, MS Office, MS Project, TOAD, MS Visio, Rational Rose, Rational Requisite Pro, Clearquest, Clearcase.
Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, Visual Paradigm, Doors Erwin Data Modeller, Business Object (Crystal Reports)
Data Tools: Agile Project Manager, UML, Visio, RUP, SME,Waterfall
PROJECT EXPERIENCE:
Confidential, San Francisco, California
Sr. Data Analyst
Responsibilities:
- Deployed intensive use of Erwin data modeler and SQL-Developer data modeler in the creation of conceptual, logical, and physical data models, database schema for both operational databases and data warehouse systems; partnered with business analysts, business users and other stakeholders to define, capture, and communicate requirements.
- Performed data profiling, data cleansing, data validation and quality assurance, including intensive ETL process and the creating, executing, and documenting of test cases in ETL processes using SSIS and Informatica power center to bring data from diverse sources.
- Designed and developed various SQL scripts as part of automation of manual monthly reporting to third party consumer.
- Worked on data profiling, data analysis and validating the reports sent to third party.
- Designed and developed Ad-hoc reports as per business analyst, operation analyst, and project manager data requests.
- Worked as ETL Tester responsible for the requirements / ETLAnalysis, ETLTesting and designing of the flow and the logic for the Data warehouse project.Involved in extensive DATA validation using SQL queries and back-end testing
- Experience in Unix Environment developing shell scripts and perl scripts.
- Responsible in generating Reports using SSRS, and also load data from various sources like flat-file, Excel, MS Access, Oracle etc. using SSIS.
- Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
- Responsible for providing business requirements within an AGILE software development SCRUM environment.
- Worked closely with the Enterprise Data Warehouse team and Business Intelligence.
- Business rules were implemented using rules engine. Rules were easily handled, modified and quick checks of possible scenarios were done. Easily understandable by development team also.
- Performed data analysis and data profiling using complex SQL queries on various sources systems including Oracle and SQL Server.
- Created the rules engine for identifying the golden copy of the master data and manually profiled the data to make sure the rejects were handled correctly.
- Extensively used Agile Methodology in the process of the project Data Quality Managementt based on SDLC.
- Installed and configured Cognos BI and worked with Cognos BI modeling, Report Studio.
- Configured SSIS packages to in corporate slowly changing dimensions for tracking historical data.
- Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
- Tested the application by writingSQLQueries and creating pivot views as to perform back-endtesting.
- Involved in performing a gap analysis on the existing data model of the staging layer versus the requirement on Data Data Quality Management
Environment: RUP, Rational Requisite Pro, Java, Visio, MS Project, MS Office, Python, SQL Server, SSIS, SSRS, Crystal Reports, Shell Scripting Linux, UNIX
Confidential, Rochester, NY
Data Analyst
Responsibilities:
- Gathered and translated business requirements, worked with the Business Analyst and DBA for requirements gathering, business analysis, and testing and project coordination.
- Performed Reverse Engineering of the legacy application using DDL scripts in ERwin, and developed Logical and Physical data models for Central Model consolidation.
- Using Agile promoted Adaptive Planning, Evolutionary Development and delivery atime-boxediterative approach, and encourages rapid and flexible response to change.
- Implemented business intelligence dashboards and developed detailed and summary reports, line and pie charts, trend analysis reports and subreports according to business requirements using tableau and SSRS.
- Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.
- Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
- Contributing to software process-reengineering efforts aimed at evolving current software development practices to adopt Lean/Agile and Scrum practices.
- Responsible forDatamapping testing by writing complex SQL Queries using WINSQL.
- Came up with ETL mapping document for the SQL Server Integration Services (SSIS).
- Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems.
- Creating of the XML data model for the Express PA project for the Rules engine and providing the model in .XSD format for the services team.
- Broad Understanding of Cognos BI tools and ability to translate user requirements into Framework Manager Models and reports.
- Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.
- Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.
Environment: Python, PERL, Shell Scripting Linux, Java, UNIX SQL Server, Crystal Reports, SSIS, SSRS, Rational tools like Rational Rose and Requisite pro, Rational Clear Quest, Agile/Scrum, Cognos BI Business Objects, Test Director
Confidential, Dayton, OH
Data Analyst
Responsibilities:
- Performed extensive task which include DataQuality Analysis,Datalineage andDataStandardizationdatastructures,database design,data warehouses, business intelligence/analytic tools, SQL, ETL tools, anddataintegration methods
- Highly experienced in developing decision support applications with Cognos and other Business Intelligence, ETL and database tool suites
- Designed and Developed Adhoc reports by extracting data from Oracle PCARD Data warehouse using SQL Plus.
- Worked with Waterfall methodology during the beginning of the project then transitioned to Agile methodology
- Handled Source to TargetDataMapping, Technical Specs documentation, and ETL documentations such as EarlyDataInventory DesignedSSIS Packages to transferdatabetween servers, loaddatainto database on SQL Server 2005 environment and deploy the data.
- UsedDatawarehousing forDataProfiling to examine thedataavailable in an existing database.
- Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
- Used TOAD, PL/SQL developer tools for faster application design and developments
- Participate in the scrum meeting and also represented the teamduring the meeting
- Working through the phases of SDLC using the Agile methodology
- Reviewed ETL and Business Objects defects and proposed fix for defects as per the scheduled timeframe
- Configured SSIS packages to in corporate slowly changing dimensions for tracking historical data.
Environment: Windows XP Toad for Oracle Version, SQL Server, SSIS, SSRS, Agile, Waterfall, Oracle, MS Office tools, Windows, SharePoint, MS Visio. PERL, Shell Scripting Linux, UNIX
Confidential, Tampa, FL
Business Data Analyst
Responsibilities:
- Supported full traceability among all artifacts throughout the software development life cycle
- Extracted the Business Requirements during various sessions with business leads and tagged all requirements in Requisite Pro, tracing them all the way to the stakeholder requirements.
- Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
- Extensively worked on Patient, provider, claims, and encounters data sets.
- Knowledge of various healthcare systems like Cerner, Epic, Star etc.
- Worked with several tools to access and perform several operations on database.
- Build and maintain SQL scripts to validate and profile healthcare data.
- Involved in requirements gathering, Analysis, Design and Develop and maintenance Phases.
- Wrote advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
- Played a key role in planning UAT and implementation of system enhancements and data migration and conversions.
- Involved in extensiveDATAvalidation by writing several complex SQL queries and Involved in back-end testing and worked withdataquality issues.
- Worked with Waterfall methodology during the beginning of the project then transitioned to Agile methodology
Environment: Oracle SQL, MS Access, MS Excel MS Word MS Outlook SSIS, SSRS, PowerPoint SharePoint
Confidential, Harleysville, PA
Business/ Data Analyst
Responsibilities:
- Participated in meetings with stakeholders, business managers, users to understand and document business requirements and functional specifications for the work flow.
- Documented detailed business process designs and created use cases.
- Extensively used MS SharePoint for version control. Uploaded files and maintained folders in Share Point.
- Created Business Rules Spreadsheet (BRS) as needed and Requirement Traceability Matrix (RTM) to track the requirements, and link it to the test cases.
- Determined the GAP Analysis between the As-Is and To-Be Business Process Flows.
- Collaborated with the project managers, developers, system, and UAT testing teams to ensure defects are addressed, managed, and closed appropriately.
- Conducted meeting amongthe business, development, and testing teams to resolve defects in Triage.
Environment: Windows, MS Visio, Clear Quest, Requisite Pro, SharePoint SQL, HTML, XML