Sql Server Data

Sangita Das

Business Intelligence Analyst / Visualization Expert

Visualization Expert and Data Warehousing professional with 9.9 years of experience in high end programming and solution design. Through understanding of Business Intelligence and Expertise in full life cycle of BI implementations. Experienced in Business representation of Analytics and Key Performance Indicators through OBIEE and Tableau. In-depth understanding of Oracle Database and optimizing it to business needs. Prior Experience of ETL Process and Data Extraction Tools. Successful implementation of projects for the top market leaders in UK, US, rationalizing their enterprise data warehousing solution. I look towards working in Business Intelligence implementations where I could contribute my experiences and also quickly learn and adapt any new development in this area that trends in market.

Email: *************@*****.***

Sex: Female

IT Experience: 9.9 years Visualization Experience: 9 years

VISA STATUS: Valid H1B

Oracle Certified Specialist Oracle Certified Associate

Summary Of Skills

Oracle Business Intelligence:

Over Nine(9+) years of experience in design, development and implementation using OBIEE 10.1.3.4.x, 11.1.1.7.x and 12.2.1.0.x

Expertise in full life cycle of Business Intelligence and have an understanding of all its aspects of implementation using OBIEE 10.1.3.4.x, 11.1.1.7.x and 12.2.1.0.x

Experienced in Requirement gathering and analysis, Preparing of Design Documents for Reporting. Working with the users and addressing their ad hoc issues and queries.

Proficient in designing the metadata layers in the Repository - Physical, Business Model and Mapping, and Presentation layer using Oracle BI Administration Tool.

Worked on Implementing Key Performance Metrics (KPIs), facts, dimensions, hierarchies and calculated measures.

Highly skilled at configuring interactive dashboards, reports, Prompts and Agents.

Experienced in using various Reporting features in OBIEE – like different drill down techniques, guided navigation, filters, and variables.

Expert in using OBIEE Answers to create Analysis, format views, charts, add user interactivity and dynamic content to enhance usability.

Proficient in working with both Server Variables and Presentation Variables, Implementing and Maintaining Initialization Blocks.

Worked on Building Reports and forms Using BI Publisher.

Experienced in developing Dimensional Hierarchies, Level Based Measures, and adding multiple sources to business model objects.

Worked with Various Sources for OBIEE – Oracle \ SQL Server \ Teradata

Skilled at creating and scheduling Agents in OBIEE to provide personalized and actionable intelligence data to subscribers.

Architecture and Operational Aspects to understand usage patterns and address performance needs. Tuning NQS configuration parameters and others as needed for various functional and operational needs.

Configuration and set up of OBIEE Security using LDAP and External Database Tables.

Implementing object level and data level security through Repository.

Experienced in configuring Usage Tracking Reports and aligning them with the Business Hierarchy.

Have Worked on Multiuser Development Environment (MUDE).

Worked with DBA Teams towards performance tuning in OBIEE and Data Warehouse environment using caching Strategies, aggregate tables, and indexes.

Experienced with Cache Purging and Cache Seeding Strategies.

Performed Deployments of both RPD and Webcat in OBIEE.

Well Versed with the Process of Migrating all OBIEE Components through various Environments (Dev Test Pre-Prod Prod)

Experienced with activities related to Enterprise Manager / Console for OBIEE.

Tableau :

Experienced in Tableau visualizations and dashboards using Tableau Desktop 8.

Worked on Tableau workbooks from multiple data sources using Data Blending.

Designing Reports and Dashboards in Tableau according to requirements from BU.

Publishing customized interactive reports and dashboards

Report scheduling using Tableau server.

Worked with action filters, parameters and calculated measures.

Configured restricted data access for users using Row level security and User filters.

Data Modelling and ETL:

Skilled in Data Analysis, Data Modeling, Dimensional Modeling, and Data Warehousing Techniques.

Designed and Developed Star and Snow Flake schemas.

Well versed in ETL Concepts and Workflows.

Experienced in creating Procedures and Packages through PL/Sql.

Proficient in writing SQL Queries using Oracle, Teradata and SQL Server.

Working knowledge SQL Server Management Studio.

Working Knowledge of ETL Tools – ODI, Informatica

Worked with various Databases – Oracle / Teradata / SQL Server 2008 and 2012

Other Competencies:

Issue Resolution and Defect Management.

Experienced with Agile Method of Delivery.

Regular User of Rally.

Experienced with Test Driven Development Methods.

Worked on Sub Version and CVS for Version Controlling.

Worked on Automated Deployment Methods for Delivery.

Worked with Shell Scripts for Unix \ Linux Environments.

Domain Knowledge for Telecom Operations.

Domain Knowledge for Retail Operations.

Quick learner with strong communication and people skills who can work in a team or independently.

Brief of Project Work

Comcast, 2014 Apr till Date, NJ,USA

Business Intelligence Analyst

Key Responsibilities:

Gathering and Analyzing Requirements from Business Users

Mockup Preparation of Reports and Dashboards

Designing the Data Flow in the Warehouse and Fact Dimensional Modelling

Preparing Design Documents for BI Implementation

OBIEE RPD Design and Development

OBIEE Interactive Dashboards and Reports Development using variables and prompts.

Designing Agents in OBIEE

Security configuration in OBIEE

Migrating OBIEE components to QA Environment

OBIEE Development using MUDE Environment

Performing UAT with the Users.

Defining Cache Management Strategies

Developing Cache Purging Scripts in Linux.

Troubleshooting and enhancement of ETL Packages and Interfaces using ODI (Oracle Data Integrator).

Migrate Older Reports to Tableau using Tableau Desktop

Iteration Planning for Agile Method of Delivery

Interacting with Business Users for requirement gathering and Issue Resolutions

Comcast, 2014 Jan till 2014 Mar, Kolkata, INDIA

OBIEE Development Lead / Devops

Key Responsibilities:

Design and Development of RPD Objects in OBIEE.

Dashboard and Report Development in OBIEE.

Communicating with End Users for Requirement Analysis and Mock Up Preparation

Preparing Design Documents for OBIEE Development

Providing Code Fixes for prod defects in OBIEE.

Developing Reports and Forms using BI Publisher.

Cache Purging and Seeding Implementations

Maintaining Non-Prod Environments of OBIEE (Dev, QA)

Security Management of OBIEE

Scheduling Agents in OBIEE

Deployments of OBIEE Components in Non-Prod Environments

Maintenance of MUDE Set up in OBIEE Dev

Version Controlling of all OBIEE Deliveries in the Project

Troubleshooting and enhancement of Informatica mappings and Workflows.

Walmart, 2012 Jan till 2013 June, Kolkata, India

OBIEE Development Lead / ETL Designer

Key Responsibilities:

Both RPD and Webcat Development in OBIEE for New Projects

Enhancement in OBIEE for Existing Projects

Communicating with End Users for Understanding Requirements

Setting up Data Level and Object Level Security in OBIEE

Setting up Cache Management through OBIEE

Developing required Views or other DDL objects in SQL Server

Designing Star Schemas in the Data warehouse and Defining Joins

Identifying Facts and Dimensions and building Relationships between them

Creating Design Documents for both OBIEE and ETL.

Troubleshooting and enhancement of ETL Workflows using Informatica.

Performing UAT Sessions with the Users

Developing Cache Purging Scripts in Unix.

Performing Code Review in terms of Performance

Sprint Planning following Agile Method of Delivery

British Telecom, 2007 Jan till 2011 Jul, Kolkata, INDIA

OBIEE Developer

Key Responsibilities:

Development of RPD Objects in OBIEE using 10g.

Development of Webcat Objects in OBIEE using 10g.

Communicating with Data Modelers to verify correct Schema Designs in Database

Maintenance of Existing Reports in OBIEE

Deployments of OBIEE Components in Non-Prod Environments

Defect Fixing of OBIEE Reports in Prod Environment

User Management for OBIEE

Developing and scheduling iBots.

Unit Testing and Regression Testing of OBIEE Components

Code Review of Peers.

Preparing Low Level Design for OBIEE Implementation.

Deployment Plan Preparation for Prod Migrations

Implementing Security through External Tables.

ETL Developer

Key Responsibilities:

Communication with Various Source Systems to Understand the Data

Preparing HLD for various components in the Project

Preparing LLD for ETL Implementation of each Components.

Communicating with Downstream Systems for assuring correct Data Flow

Defining Relationships and Execution Precedence for Various Components

Developing Procedures and Packages through PL/sql for ETL Operations.

Other DDL and DML Operations using SQL was heavily required

ETL Development Using OWB

Attending Performance Review calls and Implementing them in codes

Performing Database Tuning Activities

Version Controlling of all Deliveries.

Developing Pl/sql Package Execution and Scheduling Scripts in Unix.

Preparation of Deployment Plans and Sanity Checking

Unit Testing and Regression Testing of Deliverables

Making sure the TTD is being followed by the Team

Preparing Scripts for Automated Deployments

Education Qualification

M.E in Software Engineering

Jadavpur University,

First Class

Year – 2009 to 2012

B.Tech in Computer Science and Engineering

West Bengal University of Technology,

7.7 - DGPA

Year – 2002 to 2006

Indian School Certificate (10+2)

Council for the Indian School Certificate Examinations

70%

Year – 2000-2002

Indian Certificate of Secondary Education

Council for the Indian School Certificate Examinations

80%

Year - 2000

Trainings in last 2 years

Tableau Desktop Training, West Chester, PA

Informatica 9.6, West Chester, PA

SQL Server 2012 Training, West Chester, PA

Agile Methodologies, West Chester, PA

Personal Details

Nationality – Indian

VISA Status – Valid H1B

Currently Residing – West Chester, PA. No Location Constraint within USA.

Age – 33

Thanks

Sangita Das

Contact this candidate