We provide IT Staff Augmentation Services!

Data Analyst/business Analyst Resume

2.00 Rating

Atlanta, GeorgiA

SUMMARY

  • Business Data Analyst and Data modeler with 7+ years of experience in various roles in Analysis, Software Product Research, Design, Development, Delivery and Maintenance of Transactional and Data Warehouse/Analytical applications for Retail Banking, Financial Investments, Telecom, Insurance and Supply chain sector.
  • Business Data Analyst with strong experience in analysis, design, development and implementation of OLAP, OLTP, Operational Data Store, Enterprise Data Warehouse, Data Migration, Data Mart designing, Data Governance with a good understanding of business reporting and MIS
  • Efficiently carried out Agile (Scrum), Waterfall, SDLC (Software Development Life Cycle) methodologies
  • Hands on experience in gathering Business requirements by organizing and managing meetings between clients, third party vendors, development teams and analysts on a scheduled basis
  • Excellent knowledge in data analysis for business applications in Client/Server (OLTP) and Data warehouse environments (OLAP) systems
  • Competent in creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams. Expertise in implementing scrum methodology for businessanalysis including User Story creation
  • Expert Enterprise Data Modeler with a deep understanding of developing transactional enterprise data models that strictly meet normalization rules, as well as enterprise data warehouses using Kimball and Inmon data warehouse methodologies
  • Experience in creating Transformations and Mappings, and processing tasks using Workflow Manager to move data from multiple sources into targets
  • Experience in data transformation, data mapping from source to target database schemas, data cleansing procedures
  • Worked with the product owner in analyzing and collecting the data of stakeholders’ needs and gathering requirements for system reporting and customer statement generation in monitoring the source systems and the incident data
  • Expertise as Information Risk Analyst / Business Analyst in Identity and Access management domain
  • Excellent knowledge in PL/SQL, Stored Procedures, Packages, Database Triggers, Views, Functions, Packages, Triggers, performance tuning and optimization
  • Involved in Data Conversions and Gap Analysis from legacy systems to updated technologies using custom SQL scripting as well as ETL applications from Relational Solutions
  • Experienced in various databases Design of development and Production environment involving Oracle, SQL server, DB2, MS Access, Teradata
  • Good Knowledge and experienced in User Acceptance Testing (UAT), Unit testing, System testing, Integration testing, Development and Production
  • Creative, self - motivated, quick learner and excellent team player, ability to meet deadlines and work under pressure
  • Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design

TECHNICAL SKILLS

Languages: SQL, PL/SQL,T-SQL, HTML

Database Systems: MS Server 2012/2008, DB2, MS Access 2003/2000, Teradata

Design Tools: ERwin 9.6,8.5,7.2, ER/Studio 7.3/7.5/8.0/9.6, MS Visio

ETL Tools: Oracle Warehouse Builder, Informatica, Power Center 6.0/7.1/8.1.1, Power Mart 6.0, Datastage, DTS

OLAP Tools: MS SQL Analysis Services, Report Builder, MS Reporting Services, Crystal Reports, Business Objects

Business Modeling Tools: Rational Rose, MS-Visio, MS Visual studio

Other Tools: SQL Developer, Query Analyzer, SQL*Plus, Toad, XML, MS office, MS word, MS Excel

Business Analysis: Requirements engineering, business process modeling and improvement, gap analysis, cause and effect analysis, decision trees, data flow diagrams, data modeling, wire frames, UAT

Operating System: Windows, Mac OS, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

Data Analyst/Business Analyst

Responsibilities:

  • Followed Agile Methodology to implement SDLC (Software Development Life Cycle)
  • Understood the System architecture and the data flow from diverse systems
  • Experience to create Logical & Physical Data Modeling on Relational (OLTP), Dimensional Data Modeling (OLAP) on Star schema for Fact & Dimension tables using CA Erwin
  • Gathered the requirements from the Business users by conducting user interviews and then convert requirements into technical specifications Documents
  • Participated in team meetings and proposed ETL strategy based on Agile Methodology
  • Leading member in interviews (JADs) and meetings to engage business associates and subject matter experts, in business planning, business analysis, and business requirements definitions
  • Involved in Data flow analysis, Data modeling, Physical database design, forms design and development, data conversion, performance analysis and tuning
  • Responsible for extracting the data from different sources like Oracle, SQL, Flat file and XML
  • Act as a subject matter experts in requirements planning/gathering sessions
  • Lead Research and gathered information regarding a business problem/opportunity
  • Data mining and Data warehouse concepts were employed for vast applications of data mining and also transformed data into predictive model development data sets
  • Designed data model, analyzed data for online transactional processing (OLTP) and Online Analytical Processing (OLAP) systems
  • Used Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams, and Sequence Diagrams
  • Created CA ERwin reports in HTML, RTF format depending upon the requirements, published Data Model in Model Mart, co-coordinated with DBAs to apply the data model changes
  • Analyzing the incoming feeds, conduct data profiling and map the relevant fields to the target repository incorporating business validation rules to integrate the data
  • Developed data warehouse capacity planning framework and workload analysis
  • Designed and developed mappings to load data from Source systems to ODS and then to Data Warehouse
  • Analyzing and compiling the data with the source systems to ODS and to data warehouse incident data
  • Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment and developed working documents to support findings and assign specific tasks

Environment: MS Visio 2007, CA Erwin data modeler, SQL Server 2008R2/2012, T-SQL/PL-SQL, MySQL, Rally, MS office suite.

Confidential, Atlanta, GA

Business Data Analyst/Data modeler

Responsibilities:

  • Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle
  • Responsible for coordinating Joint Application Development (JAD) sessions with business users, technical team, DBAs, testing team to analyze and validate the requirements, application lifecycle, gather and define the key performance indicators, document and present the requirements specifications
  • Worked in Agile methodology, Attended Daily stand-up meetings. Developed Test Plan and Test cases based on the user stories (Functional requirements)
  • Worked with DBA to identify gaps in data modeling, data mapping in Teradata and provide Teradata performance knowledge to users
  • Developed PL/SQL scripts to validate and load data into interface tables
  • Analyzed business scenarios to track possible business outcomes for the functions which could be incorporated into more detailed test scripts
  • Performs mapping between source and target data of DB2 to Teradata
  • Designed and developed ETL jobs/workflows supporting data load and validation of data, while working with the business on error log files to ensure better data quality and integrity
  • Initiated the analysis and compiling for the monthly reports of supplier orders and inventories
  • Developed Data models and ER diagrams using Erwin
  • Coordinate with the end users in doing the UAT and developed manuals testing. Executed test scripts, co-ordinate and conducted System and UAT testing
  • Reverse Engineering the existing data marts and identified the Data Elements, Dimensions, Facts and Measures required for reports
  • Proficient in MS Excel to perform dataanalysis by collecting, reviewing, analyzing and reporting on raw datacollected from legacy systems and datawarehouse
  • Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation

Environment: CA Erwin, Teradata, DB2, PL/SQL, SQL*Plus, Designer 2000, SQL, Oracle, Excel, Access, JIRA, MS Visio.

Confidential, Greenville SC

Senior Associate/Data modeler

Responsibilities:

  • Data Analysis and Data validation by writing SQL queries
  • Strong knowledge of using Microsoft data warehouse cubes to provide end user solutions
  • Identifies and documents all requirements for both fresh and current data warehouse components and reports by working with end users
  • Designed and developed ETL jobs/workflows supporting data load and validation of data, while working with the business on error log files to ensure better data quality and integrity
  • Analyze the tables, cubes running on SQL and Designed and Developed Star Schema and created Fact and Dimension Tables for the Data Warehouse using CA Erwin tool
  • Worked with Data Architects and Data Modelers extensively sharing knowledge and ideas in designing Data Models
  • Prepared reviewed and analyzed the Business Requirements documents, Functional Specification document of the core application and developed User stories
  • Involved in the design and development/enhancements of ETL jobs using Informatica
  • Involved in understanding and translating the business requirements and to High Level and Low level design for ETL processes in Teradata
  • Having work experience in planning and carrying out of Teradata system Loading Processes, Data Warehousing, Large-Scale Database Management
  • Developed ETL to consolidate data from several business areas via the Enterprise Data Integration (EDI) Power Center tool
  • Involved in performing the SQL Query Analysis to ensure that the query used for data store and retrieval are utilizing the data base resource to the maximum and providing efficient results
  • Performed Integration, Functional and User Acceptance Testing
  • Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools
  • Worked on optimizing and tuning the Teradata SQLs to improve the performance of batch and response time of data for users
  • Proficient in MS Excel to perform dataanalysis by collecting, reviewing, analyzing and reporting on raw datacollected from legacy systems and datawarehouse

Environment: CA ER-win v8.x, MS Visio, Oracle 11g, Informatica, Teradata, Data Stage, ETL, MS SQL Server, MS Access, Excel.

Confidential - Dallas, TX

Associate Consultant

Responsibilities:

  • Developed daily and monthly reports for CVS department using SQL Server
  • Involved as the primary liaison between business and IT leading the data analysis to develop Vendor Finance application (VenFin) for using SQL Server
  • Primarily responsible for requirements analysis and legacy system data analysis to design and implement physical data model for VenFin application in SQL Server
  • Developed T-SQL stored procedures and functions to process the source data and populate in the appropriate target tables
  • Also responsible to develop DTS packages, automate jobs including file transfers and processing, and develop tuning and query optimization strategies for improving SQL Server database and application performance
  • Using SQL Server Agent and Schedule Package options within SQL Server Enterprise Manager, scheduled DTS packages to execute when the source files are made available
  • Worked with several large and complex SQL databases in addition to supporting the definition of new databases that met the team's needs
  • Extensive involvement in data mapping using Facets data model and also used Facets back end tables and front end application system for data validation purposes
  • Participated in identifying and proposing data governance solutions
  • Assisted in data governance and clean-up of large data sets to increase data integrity
  • Performed legacy application data cleansing, data anomaly resolution and developed cleansing rule sets for ongoing cleansing and data synchronization

Environment: Data Stage 8, ER-win, Data Governance, MS SQL Server, T-SQL, ETL, Facets, Microsoft Office Suite, MS Visual Studio.

Confidential

Consultant

Responsibilities:

  • Developed daily and monthly reports for Telecom network using SQL Server
  • Designed data process flows using Informatica to source data into Statements database on Oracle platform
  • Gathered requirements as a business consultant using various techniques such as JAD sessions, interviewing stakeholders and meetings
  • Identified business rules and processes and documented system use cases. Also profiling and validating data standards based upon Business requirements
  • Created SQL scripts to find data quality issues and to identify keys, data anomalies, and data validation issues
  • Developed and programmed test scripts to identify and manage data inconsistencies and testing of ETL processes
  • Conducted peer design and code reviews and also published functional specifications, high-level design documents and ETL procedures
  • Performed data mining techniques to generate new information in the database
  • Reviewed and assessed ETL tools primarily between Data Stage, Ab Initio and Informatica, for the data migration from multiple source systems (SQL Server) to an Operational Reporting Database (SQL Server)
  • Responsible for SQL server Data Mining capability including various prediction algorithms and chart creation
  • Having good communication with Telecommunication/Internet providers
  • Proficient in Data Warehousing concepts including in Data mart and Data Mining using Dimension Modeling

Environment: Data Stage 8, ER-win, Informatica, Oracle 9i/10g, MS SQL Server, ETL, Microsoft Office Suite, MS Visual Studio.

We'd love your feedback!