We provide IT Staff Augmentation Services!

Business Analysts Resume Profile

Minneapolis, MN

SUMMARY:

  • 8 years of extensive experience in the complete Software Development Life Cycle SDLC covering Requirements Management, Data Analysis, Data Modeling, System Analysis, Architecture and Design, Development, Testing and Deployment of business applications.
  • Strong Data modeling experience using ER diagram, Dimensional data modeling, Logical/Physical Design, Star Schema modeling, Snow-flake modeling using tools like Erwin, ER Studio.
  • Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
  • Extensive experience in gathering business requirements, implementing business processes, identifying risks, impact analysis and UML modeling
  • Excellent knowledge of waterfall and spiral methodologies of Software Development Life Cycle SDLC .
  • Experience in Designing the Data models for OLTP OLAP database system.
  • Exert in building Enterprise Data Warehouse or Data warehouse appliances from Scratch using both Kimball and Inmon Approach
  • Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-coordinated with DBAs' to apply the data model changes.
  • Maintaining and implementing Data Models for Enterprise Data Warehouse using ERWIN 9.0/7.1/7.2/4.1/4.2/3.5
  • Utilized RUP Rational Unified Process to configure and develop processes, standards, and procedures
  • Possess strong Conceptual and Logical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.
  • Created/maintained/modified data base design document with detailed description of logical entities and physical tables
  • Good in Normalization 1NF, 2NF, 3NF and BCNF /Denormalization techniques for effective and optimum performance in OLTP and OLAP
  • environments
  • Well versed in system analysis, ER/Dimensional Modeling, Database design and implementing RDBMS specific features.
  • Well versed with various software development methodologies SDLC, Agile Methodology, Extreme Programming, MSF
  • Experience in dealing with different data sources ranging from flat files, Excel, Oracle 11g/10g/9i, SQL Server 2008/05/03 and Informix 10/11.5
  • Created data stage jobs using IBM InfoSphere Data Stage
  • Extensively worked on Data Profiling concepts to maintain the data quality and data reliability
  • Extensively worked on Data Cleansing or Data Scrubbing concepts to validate the corrupted data
  • Excellent hands on experience in Master Data Management MDM when the organization having problems with the quality, consistent classification and identification of data
  • Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
  • Experience in backend programming including schema and table design, stored procedures, Triggers, Views, and Indexes.
  • Experienced in writing SQL and PL/SQL scripts in Data warehousing applications involved in database design and Data modeling
  • Expert in tuning the SQL queries by providing proper indexes, table partitioning and proving the optimized queries to the application team
  • Possess strong Documentation skills and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility
  • Create and maintain documentation and help information for teams utilizing core geospatial services around process, requirements, and test criteria for application development and deployment processes Communicate these changes and updates to broad range of audiences and external vendors
  • Expertise in writing business and software development processes and procedures.

Technical Skills:

RDBMS

Oracle 11g/10g/9i/8i, MS SQL SERVER 2000/2005/2008

Business Skills

Definition Requirements, Business Process Analysis, Use Case Modeling Analysis, Business Environment and Market Research Analysis, Project Management

Data Modeling

Erwin 9.0/7.1/7.2/4.1/4.2/3.5, Power Designer v16.0/v16 , ER studio and IBM Rational Data Architect v7, MS Visio 2007/2010

Defect Tracking Tools

Mercury Interactive Suite: Test Director 8.0, Quality Center 9/10

Languages

SQL, PL/SQL, HTML, XML

Operating Systems

Windows NT/2000/XP/7, UNIX

Tools

TOAD, command editor, MS Project, MS Office 2003/07/10

Professional Experience:

Confidential

Business Analysts

Confidential IT team has initiated this project as part of the Retail Next Generation RNG to replace the current FORT reports to a new platform MSBI as the current Best Buy Enterprise Data Warehouse EDW platform will run out of capacity by Holiday FY14. This FORT project is required in order to move to Parallel Data Warehousing PDW and decommission the Prod B EDW server

Responsibilities:

  • Understand and translate business needs into data models supporting long-term solutions.
  • Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
  • Involved in the analysis of the existing claims processing system, mapping phase according to functionality and data conversion procedure.
  • Translated business requirements into working logical and physical data models.
  • Designed Star and Snowflake Data Models for Enterprise Data Warehouse using power designer 16.5
  • Created fully normalized till 3rd Normalization technique using Power Designer 16
  • Created and maintained Logical Data Model LDM for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
  • Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
  • Recommend opportunities for reuse of data models in new environments.
  • Perform reverse engineering of physical data models from databases and SQL scripts.
  • Evaluate data models and physical databases for variances and discrepancies.
  • Validate business data objects for accuracy and completeness.
  • Analyze data-related system integration challenges and propose appropriate solutions.
  • Develop data models according to company standards.
  • Review modifications to existing software to improve efficiency and performance.
  • Examine new application design and recommend corrections if required.
  • Conducted User Acceptance Testing UAT
  • Understand the master test plan and/ or the project plan
  • Create or assist in creating own test plan
  • Generate test cases based on the requirements and other documents
  • Report defects/results to the stakeholders
  • Reply to returned bug reports for example, when a bug report is returned as not reproducible
  • Re-test resolved defects
  • Update test cases based on the discovered defects
  • Provide inputs to the team in order to improve the test process
  • Report work progress and any problems faced to the Test Lead or Project Manager as required
  • Support the team with testing tasks as required

Environment: Power Designer 16.5, Teradata, PL/SQL, Oracle 9i, SQL Server PDW

Confidential

Data Modeler / Data Analyst

Confidential multinational retail corporation that runs chains of large discount department stores and warehouse store. Wal-mart is the biggest private employer in the world with over two million employees, and is the largest retailer in the world. Walmart collects and analyzes an enormous amount of data on consumer's shopping habits. The big data sets are mined for use in predictive analytics which allow the company to optimize operations by predicting customer's habits

Responsibilities:

  • Gathered Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
  • Analyzed the business requirements by dividing them into subject areas and understood the data flow within the organization
  • Created conceptual logical models, logical entities and defined their attributes, and relationships between the various data objects
  • Updated existing models to integrate new functionality into an existing application.
  • Conducted one-on-one sessions with business users to gather data warehouse requirements.
  • Developed normalized Logical and Physical database models to design OLTP system
  • Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r9
  • Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-coordinated with DBAs' to apply the data model changes.
  • Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
  • Maintaining and implementing Data Models for Enterprise Data Warehouse using ERWIN r9
  • Create and maintain Metadata, including table, column definitions
  • Synched up the models by reverse engineering, compare model and merge model from database to the original models
  • Responsible for defining the naming standards for data warehouse.
  • Creating PL/SQL packages Stored Procedures, Functions and Triggers
  • Used Model Mart of Erwin r9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
  • Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
  • Developed Data Migration and Cleansing rules for the Integration Architecture OLTP, ODS, DW .
  • Verified that the correct authoritative sources were being used and that the extract, transform and load ETL routines would not compromise the integrity of the source data
  • Eliminated errors in ERwin models through the implementation of Model Mart a companion tool to ERwin that controls the versioning of models
  • Tuned the SQL Queries by breaking down the predefined queries into smaller queries for processing, Pushed Query processing up from the client to application server level
  • Possess strong Documentation skills and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility
  • Assisted the ETL Developers and Testers during the development and testing phases
  • Conducted User Acceptance Testing UAT
  • Fixed bugs, tracked defects in usage and functionality of interfaces that helped increase the code efficiency

Environment: Erwin r9, SQL Server 2008, Oracle 11g, Informix 16, MS Excel, MS Visio 2010, Rational Rose 7, Requisite Pro 7.1, TOAD, SQL, PL/SQL, Windows XP/NT/2000

Confidential

Data Modeler/Data Analyst

Confidential discovers, develops, manufactures, and markets ethical drugs those requiring a doctor's prescription for a wide variety of human ailments. It has research and production facilities in many nations, and its products are sold in 159 countries.

Responsibilities:

  • Attended and participated in information and requirements gathering sessions, Ensured that business requirements can be translated into data requirements
  • Created business requirement documents and integrated the requirements and underlying platform functionality
  • Involved in the analysis of the existing claims processing system, mapping phase according to functionality and data conversion procedure.
  • Translated business requirements into working logical and physical data models.
  • Designed Star and Snowflake Data Models for Enterprise Data Warehouse using power designer 16
  • Created fully normalized till 3rd Normalization technique using Power Designer 16
  • Created and maintained Logical Data Model LDM for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
  • Worked in Multi-User modeling environment which is Erwin Model Manager.
  • Automated use of data naming standards by creating Erwin Macros
  • Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
  • Designed the database tables created table and column level constraints using the suggested naming conventions for constraint keys.
  • Created PL/SQL packages to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
  • Used PL/SQL to developed stored procedures and triggers.
  • Resolved the revolving issues by conducting and participating in JAD sessions with the users, architects, and developers
  • Worked along with the testing team to derive test cases for efficient Data reporting

Environment: Power Designer 16/15, Erwin 7.5, SQL Server 2000/2005/2008, MS-Excel, Visio, MS-Access, Oracle 10g, SQL, PL/SQL, Windows XP, UNIX

Confidential

Data Modeler/Data Analyst

Confidential operating one of the largest railroad networks in North America. Integrating Data Modeling technology into the system, BNSF dramatically increased efficiency, productivity and savings. The goal of the project is provide More accurate and timely data better business decisions

Responsibilities:

  • Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
  • Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team.
  • Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
  • Developed logical/ physical data models using Erwin r7.0 tool across the subject areas based on the specifications and established referential integrity of the system.
  • Involved in dimensional modeling, identifying the Facts and Dimensions.
  • Implemented the Slowly changing dimension scheme Type II for most of the dimensions
  • Creating procedure for updating the data from factory systems, through Oracle PL/SQL
  • Developed the required data warehouse model using Star schema for the generalized model
  • Maintain and enhance data model with changes and furnish with definitions, notes, reference values and check lists.
  • Worked very close with Data Architectures and DBA team to implement data model changes in database in all environments. Generate DDL scripts for database modification, Teradata Macros, Views and set tables
  • Participated in User Acceptance Testing UAT of finished Reports and Dashboard and delivered the quality tested web application to the Logistics users

Environment: SQL Server 2000/ 2005, Erwin 7.0, XML, Excel 07, Access 07, Visio 2007, Windows XP

Confidential

Data Analyst/ Data Modeler

Confidential is one of the nation's largest full-service providers of consumer and commercial banking, trust, securities brokerage, mortgage and insurance products and services. Project was to develop financial analysis data warehousing for analyzing customers, their transactions, accounts, balances and their authorizations between accounts of its customers. This project is developed for research analysis of Finance Department to assist them in their business. This system provides accurate and timely information on their portfolios on a daily and monthly basis, regarding credit gains and losses for potential candidates so that they may take appropriate actions proactively.

Responsibilities:

  • Analyzed existing logical data model LDM and made appropriate changes to make it compatible with business logic.
  • Created Physical Data Model PDM for the OLTP application using ER Studio.
  • Created Data Models using IDEF1X methodology.
  • Involved in data model reviews with internal data architect, business analysts, and business users with in depth explanation of the data model to make sure it is in line with business requirements.
  • Worked at conceptual and physical using IE methodology database level to implement and build corporate enterprise information strategies.
  • Worked on analyzing source systems and their connectivity
  • Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
  • Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application.

Environment: ER Studio, Informatica Power Center 7.1.2, Sybase, Windows, Toad, PL/SQL, Oracle 9i, SQL Server 2000, SQL Loader, AIX 5.0, Windows 2000

Confidential

Sr Programmer

Member of the Analysis team and was involved in gathering System Requirement Specifications SRS for various in-house projects developed and other projects outsourced to vendors. Job included coordinating and organizing business meetings and demos between management and the Vendor Teams. Preparing business process documents, flowcharts, data-flow diagrams, use case diagrams, designing interactive screens and database architecture, coordinating with the Programming Team and evaluating the project at various stages in SDLC, testing the project and preparing error reports and feedback, helping in final implementation.

Responsibilities:

  • Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
  • Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN r4.0
  • Validated and updated the appropriate Logical Data Models to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change
  • Generated user and technical documentation for processes in all phases of the project
  • Conducted all data model reviews as appropriate during project lifecycle
  • Coordinated with project DBA to update the physical database models to incorporate design changes table de-normalization, type-code column additions, etc. as they occur
  • Involved in data profiling and cleansing to remove redundant data
  • Developed stored procedures, triggers, functions and packages in PL/SQL
  • Reviewed processes and provided input into project plan
  • Extensively used tracing methods to troubleshoot various time consuming queries.
  • Provided other data analysis services, as required
  • Provided input to resolve data limitation/constraints and issues

Environment: Erwin 4.0, SQL Server 2000, MS-Excel 2003, Visio 2010, MS-Access 2003, Oracle 9i, SQL, PL/SQL

Confidential

Software Engineer

The Confidential is a world leader in the discovery, development, manufacture, and marketing of prescription medicine. The project's goal was to build an OLTP system to compare and analyze product prices, their quantities and patient profiles. A relational database system was designed to deliver reports and information to sales and marketing management.

Responsibilities:

  • Assisted in gathering Business Process Requirements and translated them into functional and non-functional requirements of the Business Requirement Document BRD , which used as input to the functional design specifications
  • Assisted in Creating Use Case/Activity /Sequence Diagrams in MS Visio 2003
  • Worked along with the testing team to derive test cases for efficient Data reporting
  • Conducted the Unit testing and prepared the testing document
  • Worked with senior Business Analysts to create business requirements, workflow, environment details and plan phases in development
  • Created SQL statements to validate the data table

Environment: MS Excel, MS Visio 2003, MS Power Point, J2EE, SQL

Hire Now