We provide IT Staff Augmentation Services!

Data Analyst/ Business System Analyst Resume

0/5 (Submit Your Rating)

Dayton, OH


  • 7+ years of experience in the Information Technology (IT) Industry serving as a Data Analyst in a Data warehousing environment.
  • Working knowledge of Bank, Health, Insurance, Retail and Finance domains.
  • Hands on experience on Full life cycle of the project using methodologies like Waterfall, RUP and hybrid methods.
  • Extensive experience on interaction with system users in gathering business requirements and involved in developing projects.
  • Chaired and conducted JAD sessions with business and technical teams.
  • Expert in analyzing/troubleshooting and providing technical support for Oracle/Unix applications and their interfaces.
  • Extensive experience on business intelligence (and BI technologies) tools such as OLAP, Data warehousing, reporting and querying tools, Data mining and Spreadsheets.
  • Worked extensively in Data consolidation and harmonization
  • Experience in Data alignment and Data cleansing.
  • Vast experience of working in the area data management including data analysis, gap analysis and data mapping.
  • Worked extensively with Dimensional Modeling and Data Migration.
  • Experience in Data Transformation, Metadata, Data dictionary, Data Loading, Modeling and Performance Tuning.
  • Experience in DBMS/RDBMS implementation using object - oriented concept and database toolkit.
  • Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
  • Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and Interface requirements documents.
  • Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes.
  • Experience with creating reports using Business Objects.
  • Created and executed Test Plan, Test Scripts, and Test Cases based on Design document and User Requirement document for testing purposes.
  • Extensive experience in the testing environment, which included User Acceptance Testing (UAT), functional testing and system testing and defect tracking using ClearQuest.
  • Coordinated and prioritized outstanding defects and system requests based on business requirements.
  • Acted as a liaison between the development team and the management team to resolve any conflicts in terms of requirements.
  • Experience with Star schema modeling and knowledge of Snowflake dimensional modeling.
  • Experience with SQL, PL/SQL objects. Involved in creating Packages, writing Procedures and Functions. Tuning using various types of Partitioning and Indexes.
  • Experience in providing Production Batch support.
  • Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators.


Languages: SQL, T-SQL, PL/SQL

Development Environment: Enterprise Manager, SQL Server Profiler, Query Analyzer, Export & Import

Database: MS SQL Server 2012/2008 R2/2008/2005, MS Access, Oracle 11g

Operating System: Windows Server 2012 R2/2008 R2/2003, Windows 8/7/Vista/XP

Reporting Tools: SQL Server Reporting services (SSRS), Crystal Reports 9/8.5

Database Tools: SSAS, DTS, Management Studio, Resource governor, Data compression, Upgrade Wizard, Replication, Database Engine Tuning Advisor, SQL Server Dashboard, Business Intelligence Development Studio (BIDS), Red Gate, Ideara Diagnostic Manager

ETL Tools: SQL Server Integration Services (SSIS), Informatica 7.1, IBM Data Stage 7.5

Designing Tools: Erwin 7.0/6.5, Rational Rose, MS Visio, SharePoint 2010


Confidential, Dayton, OH

Data Analyst/ Business System Analyst


  • Facilitated meetings with the different business lines to understand the business process.
  • Worked with business Analyst to gather the business requirements and created functional and non-functional requirements documents.
  • Analyzed the current business processes and data which is maintained in the different sources.
  • Designed Conceptual, Logical and Physical Model based on normalization standards (Second Normal Form/Third Normal Form).
  • Conducted JAD session with application developers to determine and analyze the data flow.
  • Created mapping document to load the existing data from MS Access database to the newly designed relational database.
  • Assisted testing team in developing test scenarios, test logic and test data to support unit and system integration testing and executed test plans.
  • Performed unit testing on the applications and data to ensure the correct data flow.
  • Performed Source Data Analysis on different sources like SQL Server and Oracle and also on additional informational systems
  • Develop Logical and Physical data models that capture current state/future state data elements and data flows using ERWIN / Star Schema.
  • Studied the existing OLTP system(s), analyzed and created Facts, Dimension tables Modeled the Data Warehousing data marts in Star join schema and Snow Flakes Schema
  • Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
  • Created application-specific Data Marts so that users can access personalized dashboards of information that is specific to their department and business unit.
  • Drilled out each of the data flow along with source to target mapping document for the ETL team
  • Developed and deployedSSIS packages, wrote stored procedures and functions for Data WarehouseusingLookup, Fuzzy Lookup, Derived Columns and Slowly Changing Dimension.
  • Created SSIS packages and wrote stored procedure program which include data staging like importing, Cleansing, Parsing, scrubbing by using SSIS tools.
  • Coordinate with testing team to write test scripts for testing functionality of the design.
  • Created and maintained Data Dictionary and data model supporting technical documentation for both rational schema and for both the phases.
  • Facilitated training sessions and trained business users on the reporting feature of the applications.
  • Conducted meetings with each business line and gathered reporting requirements and created reporting requirements and got the approval from the business users
  • Analyzed current reports used by the business and presented enhanced reporting structure with additional data elements.

Environment: ERwin 7.3.9, MS SQL Server 2008, Oracle 11g, Informatica Power Centre 9.0.1, SSIS, Crystal Reports 12

Confidential, Monroe, LA

Data Analyst


  • Worked with business requirements analysts/subject matter experts to identify and understand requirements. Conducted user interviews and data analysis review meetings.
  • Resolved the data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
  • Worked closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models.
  • Analyzed the source data coming from various data sources like Mainframe & Oracle.
  • Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
  • Involved working on different set of layers of Business Intelligence Infrastructure.
  • Dealt with Oracle Hyperion Financial Management tool for financial consolidation and reporting.
  • Worked extensively in Data consolidation and harmonization
  • Worked extensively on the MS-SQL environment to run out the queries and explore the Databases.
  • Defined key facts and dimensions necessary to support the business requirements.
  • Worked with OLAP tools such as ETL, Data warehousing and Modeling.
  • Made statistical analysis and reports using SAS.
  • Meeting with user groups to analyze requirements and proposed changes in design and specifications.
  • Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data.
  • Flat file conversion from the data warehouse scenario.
  • Created Fact and Dimension tables in Mart.

Environment: Windows 2008 Server, Mainframe, MS-SQL, UNIX, SAS, Mainframe, DB Visualizer, OLAP, MS Office, T-SQL Queries, Informatica Power Center 8.6.1, PL/SQL, Quality Center, and Putty

Confidential, Columbus, GA

Data Analyst


  • Extensively used Informatica Power Center 7.1.2 to extract data from various sources and load in to staging database.
  • Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
  • Extensively used ETL to load data from multiple sources to Staging area (Oracle 10g) using Informatica Power Center 7.1.2 Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
  • Tuned sources, targets, mappings and sessions to improve the performance of data load.
  • Designed Logical and Physical Modeling using Erwin Data Modeler tool.
  • Did data migration of Informatica Mappings, Sessions, and Workflows to Data Integrator.
  • Created data stores, project, jobs, and data flows using Data Integrator.
  • Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
  • Created Several Informatica Mappings to populate the data into dimensions and fact tables.
  • Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
  • Designing mapping templates to specify high level approach.
  • Involved in creating/modifying reports using Business Objects and Web Intelligence.
  • Developed PL/SQL scripts to move historical data from ERP sources to BOW.

Environment: Informatica Power Center 8.6, Oracle 10g, Business Objects XI R2, Web Intelligence 2.5, Oracle, PL/SQL, TOAD, SQL*Plus, Erwin, Windows, UNIX HP UX, Control M.

Confidential, Baltimore, MD

Data Analyst


  • Interacted with the business community and database administrators to identify the business requirements and data realties.
  • Responsible for dimensional modeling of the data warehouse to design the business process.
  • Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
  • Developed a number of Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into the data warehouse.
  • Used SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, and Database Triggers).
  • Used various transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
  • Loaded the data from IMS files into oracle tables using Informatica with any data cleansing required.
  • Worked on SQL tools like TOAD to run SQL queries and validate the data.
  • Worked on database connections, SQL Joins, views in Database level.
  • Extensively used SQL*Loader to load Data from flat files to Database tables in Oracle.
  • Used Power Center server manager/Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
  • Used UNIX shell scripting for Scheduling Informatica Workflows.
  • Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
  • Implemented procedures/functions in PL/SQL for Stored Procedure Transformations.
  • Monitored workflows and collected performance data to maximize the session performance.

Environment: Informatica Power Center 7.1.2, MS SQL Server 2005, SSIS, Oracle 9i, ERWIN 4.0, Windows 2003, DB2, PL/SQL, SQL.

Confidential, Scottsdale, AZ

Data Analyst


  • Developed Logical and physical database designs for the transaction system.
  • Extract the XML file from source transform it with multiple transformation including XML Transformation.
  • Performance tuning on sources, targets, mappings and SQL queries in the transformations.
  • Used PL/SQL Views, Triggers, Procedures and Functions.
  • Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Expression, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Router, Filter, Aggregator and Sequence Generator transformations.
  • Created reusable transformations and mapplets based on the business rules to ease the development.
  • Developed mappings to implement type 2 slowly changing dimensions.
  • Developed and implemented the UNIX shell script for the start and stop procedures of the sessions.
  • Used various Informatica Error handling technique to debug failed session.
  • Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision
  • Used various debugging techniques to debug the mappings.
  • Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
  • Created Materialized view for summary data to improve the query performance.

Environment: Informatica Power Center 7.1, Oracle9i, SQL Server 2000, SQL,PL/SQL, shell scripts, Mainframe DB2, MS Visio, ERWIN Data Modeling tool, Toad 8.0, Windows 2000, XML, UNIX.

We'd love your feedback!