Post Job Free

Resume

Sign in

Data Sql Server

Location:
Irving, TX
Posted:
June 20, 2017

Contact this candidate

Resume:

Visa: GC EAD Kaur ac0xna@r.postjobfree.com

Location: Dallas, Texas

972-***-****

Data Analyst/Business Analyst

PROFESSIONAL SUMMARY

•Have experience in IT industry, with expertise in Data Modeling, Data Analysis and Design.

•Dimensional Data Modeling experience using ER/Studio, Erwin, Multidimensional Data Modeling Schema- Star Join Schema, Snowflake modeling, Fact & Dimension tables, Conceptual, Physical & Logical Data modeling.

•Complete knowledge of Data Warehouse Methodologies Ralph Kimball & Bill Inmon Methodologies. Experienced in building ODS, EDW, Staging and maintaining metadata repository.

•Expert in data analysis, design, development, implementation and design and code reviews for Extraction, Transformation and Loading (ETL).

•Experience in conducting Joint Application Development (JAD) sessions with SMEs, Stakeholders and other project team members for requirements gathering and analysis.

•Strongly capable of handling VLRDB (Very Large Relational Data Bases) of about 15TB with expert level working knowledge of the architecture involved.

•Expertise in Normalization/De normalization techniques for optimum performance in relational and dimensional database environments.

•Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling until 3NormalForm (3NF) and Multidimensional Data Modeling Schema (Star schema, Snow-Flake Modeling, Facts and dimensions).

•Expert at Full SDLC processes involving Requirements Gathering, Source Data Analysis, Creating Data Models, and Source to target data mapping, DDL generation, performance tuning for data models.

•Experience in using the Informatica command line utility to schedule and control sessions and batches.

•Extensive Knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Mart and Power Center.

•Experience in identifying and resolving the bottlenecks in Source, Target, Transformations, Mappings and Sessions for better performance

•Strong working knowledge and background in multiple databases such as Oracle, SQL Server, DB2, and Sybase.

•Strong experience in writing SQL and PL/SQL, Transact SQL programs for Stored Procedures, Triggers and Functions.

•Responsible for interacting with business users to identify information needs and business requirements for reports.

•Created complex and sophisticated Business Objects Reports that had multiple data providers, drilldown, slice and dice features using Business Objects.

•Experience in retrieving data from Business Objects Universes, Personal Data Files, Stored Procedures and Free Hand SQL.

•Experience in creating of Business Objects & Web Intelligence reports from various sources such as Oracle, Teradata, MS SQL Server, Access and Sybase

•Excellent team member with interpersonal and communication skills, highly motivated, result oriented with strong analytical, organizational, presentation and problem solving skills.

•Expert in developing effective working relationships with client team to understand support requirements, developed tactical and strategic plans to implement technology solutions, and effectively manage client expectation.

TECHNICAL SKILLS

Data Modeling

ER/Studio:10.0/9.0

Erwin:9.64/9.6

OBIEE 11g,10.1.3.3.1

ETL Tools

Informatica:9.6/8 SSIS, Data Services 3.2,Datastage :8.5

Databases

Teradata15.0,14.0,Oracle12c/11g,SQLServer 2016/2014/2012, DB2 UDB 9.x/8.x, Sybase 12/11

Programming Skills

SQL, PL/SQL, T-SQL, C, C++, C#, HTML, DHTML, XML,.NET

Operating Systems

Win 95/NT/98/2000/XP, Win 7,Win 8,Win 10 LINUX

Tools

Toad 8.5/7.4/7.3, MS-Office, MS-Visio, Ultra edit, SQL Developer, Microsoft Visual Studio 2013/2010

Reporting Tools

Business Objects XI R3 v 3.1/ XI R2,SSRS,Cognos, SSAS,PowerPlay,Transformer

PROFESSIONAL EXPERIENCE

Techraves,NY(Education) Jun16– till date

Data Modeler/Analyst

New York

Project Description: I worked very closely with the business team. We created the ODS and EDW in this project. We brought the sales data from different online systems and created the EDW.The main focus of this project to see how the students are doing. We created the student experience data mart which we linked to our sales mart and see which can be future golden students whom we can target in future for various other Kaplan Products. I created the dashboard for CEO. I helped the company to remove their manual data entry from survey data and created the app to remove the manual errors and save company’s time and for data entry.

Responsibilities:

•Gathered and analyzed requirements from the end users and converted functional specifications to technical specifications documents.

•Reverse-Engineered numerous existing database schemas to get an understanding of existing database architecture.

•Created Data Model from scratch which involved a complete life cycle implementation that encompassed business requirement gathering, analyzing their source systems; and then building financial data mart in order to provide functionality for their reporting purposes.

•Created conceptual, logical & physical data models with Erwin and did design review meetings with other team members in order to finalize the model.

•Implemented advance modeling concepts like Bus Matrix Architecture, Resolving Multi Valued dimensions, and Conform dimensions, Junk dimensions, Degenerate dimensions in designing multidimensional model.

•Created and developed Slowly Changing Dimensions tables SCD2, SCD3 to facilitate maintenance of history.

•To maintain the consistency and quality of the data worked with Data Governance, Data Profiling and Data Quality team that required managing the master data from all the business units as well as from IT and ensuring data quality standards across the enterprise.

•Developed and maintained enterprise data dictionary by interacting with data steward, data governance team.

•Divided model into subject areas for reflecting understandable view to business as well as data model reviewers.

•Created DDL for physical model using Erwin and handed over to the DBA team.

•Handled the incident tickets. Resolved the issue within the time frame and gave the detail report about the defect with solution.

•Played the role of SME for various data marts.

•Worked on Data Extraction, Data Transformation, Data Loading, Data conversions and Data Analysis.

•Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool informatica Power Center

•Created the INF views on HST table to retrieve latest records faster.

Environment: Orac1e 11i, Erwin 9.0, Microsoft Visual Source Safe, SSIS, SQL Server 2016, Teradata 15.0, TFS, T-SQL, PL/SQL, TOAD 8.5, OBIEE 11g, Informatica Power Centre 8.5.1, Microsoft Visual Studio 2013,Cognos 10,DB2 9.5

Data Modeler Aug 14 – June 16

Meijer, Michigan (Retail)

Project Description:

I am working on the customer, sales and marketing data. In this project my main focus is to do the customer 360 degree analysis, how customers are responding to our loyalty programs, surveys and what kind of products customer are buying. I am helping the business to target the customer according to their demographic location, there household size and there ethnicity. I am also helping the business by providing the dashboard to show the difference between today’s sales comparing with last year’s sales data and much more.

Worked with Business analysts for requirements gathering, business analysis, testing, metrics and project coordination.

Involved in gathering requirements from business users and created Multidimensional model using Erwin.

Using ErStudio for Logical and Physical database modelling by using Ralph Kimball & Bill Inmon Data Warehouse Methodologies.

Understood OLTP Source tables and build Dimension and fact tables accordingly

Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables

Created Multiple Dimensions and Fact tables. Used concepts of Degenerated dimension, sub-dimension, Fact less fact table, Aggregate fact tables in Multidimensional model, Snowflake schema.

Conducted ETL design review meetings to get approval from Cross functional teams

Organizing and managing meetings between clients, third party vendors, development teams and analysts on a scheduled basis

Gather user requirements and translate to functional requirements/technical specifications for Automation

Involved in the Extraction, Transformation and Load process (ETL) for a Data Warehouse from their legacy systems using Informatica.

Worked on multiple disparate Data sources rangingfrom flat files, XML Files, Oracle, SQL server, DB2 databases to load the data into Heterogeneous targets such as XML files and Oracle Database.

Created High Level Design & Architectural document, Detail Level Design document, Unit test plan as a part of SDLC Process.

Created Reusable Transformations, Mapplets and used them in Mappings to develop the business logic for transforming source data into target.

Extensively used transformations like lookups, update strategy, sorter, expression, aggregator

Extensively used Informatica Workflow Manager and Workflow Monitor for creating and monitoring workflows, worklets and sessions.

Created Test data and Unit test cases to ensure successful data loading process

Scheduled reports to run on a monthly, weekly, and daily basis using Cognos ConnectionScheduler.

Involved in transforming the knowledge about system to Production support team

Supported the System for a period of two months after it went live into Production and helped production support team to come up to the speed

Helped in creating Production support Manuals.

Environment: Orac1e 11i, Erwin 9.0, Microsoft Visual Source Safe, SSIS, SQL Server 2016, Teradata 15.0, TFS, T-SQL, PL/SQL, TOAD 8.5, OBIEE 11g, Informatica Power Centre 8.5.1, Microsoft Visual Studio 2013,Cognos 10

EDUCATION

Master’s Computer Science(GPA 3.4) (City University of New York)



Contact this candidate