Data Sql Server

Supriya Biswas

** ******* ******, *********, ** *1803.

Phone: 516-***-**** (cell)

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

DATA ARCHITECT

CAREER OBJECTIVE

Seeking Data Architect role with expertise in BI/DW projects on Microsoft SQL Server and Sybase for an

organization focused on enterprise-scale business applications backed by massive warehouse data.

SKILLS

SDLC experience including both waterfall and agile methodologies.

Business knowledge in Database Security and various compliances, Market Research, Telecommunications,

Financial Services and Manufacturing industries.

Strong ability to articulate and apply knowledge of data warehousing and modeling concepts to transform

complex business logic into dimensional design.

Experience in data extraction, transformation and loading from various data sources into the warehouse and

maintaining data quality at various levels to help clients in their dynamic decision making process using Star,

Snowflake, Ralph Kimball's dimensional model.

Extensive knowledge of developing complex Transact SQL queries, stored procedures, functions, triggers,

views for SQL Server 2005/2008R2/2012 and Sybase ASE.

Experience in both operational and warehouse database performance tuning, data integrity and statistical

analysis.

Ab Initio and alend ETL tools and IBM-Cognos reporting tool.

Autosys, Control-M, Syncsort, JIRA, MS Visio, ERwin, SVN 3 rd party tools.

Extensive knowledge in UNIX shell Scripting. Knowledge C, C++, VC++, Java, PERL and Hadoop.

Experience in software sizing and capacity planning for various productions across the globe.

Great aptitude for learning, and have excellent communication skills, highly motivated, and organized. Work

very well in a team and have ability to lead onsite and offshore tea m.

EXPERIENCE

4/2013 - present

Nielsen, Syosset, NY

Role: Data Architect

Nielsen is the leading Market Research Company provides essential information and consumer insight for better

marketing decisions. Consumer and Shopper Explorer (C&SE) is state of the art statistical Decision Support System

that generates various facts based information for retailers and manufacturer to analyze consumer and shopper

behavior.

Responsible for development and promoting the enterprise data architecture strategy and services so to build

the enterprise information structure across BI, applications, and processe s.

Redesigning and implementing ETL job management for better response and enhanced security .

Design the data integration architecture with high reusability and traceability, high performance, high

consistency, high reliability ETL and subscription based data marts.

Develop strategies and enhance application development process for seamless product migration and

adoption of new market analysis models.

11/2007 – 3/2013

Application Security Inc., New York, NY

Role: Data Architect

Application Security Inc. is the #1 provider of cross-platform database security, risk and compliance solutions for

the enterprise. AppSecInc's products – DbProtect for Enterprise, AppDetectivePro for Auditors, and IT Advisor,

deliver the industry's most comprehensive database security solution.

Supriya Biswas Page 1

Designed, implemented and maintained warehouse dimensional schema and ETL for both User

Rights Review (URR) and Vulnerability scan data

DbProtect scans target databases and generates valuable URR and Vulnerability data. Worked with product

management in developing and reviewing user stories to address current and future customer requirements .

Data warehouse was designed using Kimball’s dimensional model and bus architectures to optimize

performance and user experience. This model is open and flexible to support agility of the product to

address customer needs in the future. Documentation for data model is automatically generated for internal

and external use to ensure appropriate usages of data.

Designed and verified Warehouse automated test cases to ensure data quality

Researched off-the-selves tools for data quality and finally developed in-house automated tool to support

extensive test cases. Data quality and consistency were tested at various levels - starting from raw data

collection to presentation of roll-up data.

Developed awareness for peer groups and clients to improve understanding of BI/DW dimensional

model

Purpose- and structure-wise, DW dimensional model is vastly different from operational normalized data

model. Discussion and blogs are developed to help cross-functional teams and the clients to understand the

data and its authenticity.

Provide customer support to external clients and internal Reporting team

Provide development support for DbProtect during Beta and production deployment. Guided Cognos report

developers to understand the schema and data, provid e prototype SQL queries to guide them in developing

Cognos import views and business views. Reviewed Cognos queries and identified areas for improvements.

Developed SQL based schema and data verification tool for seamless product upgrade and

maintenance

This minimized the involvement of support team and critical production down -time. These tools compare

the base schema against the target schema using schema signature and also validate the data. It produces

summary and detailed reports on the differ ences and steps to eliminate those differences.

Enhanced and maintained operational schema and Knowledgebase for DbProtect and

AppDetectivePro

Developed organization-level best practice for schema design and templates for developing programmable

objects. Responsible for reviewing and maintain the standards for both products.

Responsible as a DBA to maintain in-house test databases

Involved in regular maintenance of in house SQL Server databases of various capacities. These databases

used for scaling the application and understand the behavior of the product during upgrade. Research work

was focused on providing better understanding of warehouse data, database data and log growth etc. based

on extensive study of real data.

3/1998 - 11/2007

ACNielsen, Syosset, NY

Role: Project Lead

ACNielsen is the leading Market Research Company provides essential information and consumer insight for better

marketing decisions.

Consumer and Shopper Explorer (C&SE) is state of the art statistical Decision Support System that generates various

facts based information for retailers and manufacturer to analyze consumer and shopper behavior.

Data Warehouse Performance Improvement

Led a team to identify areas that require improvements. Worked with smaller group of people to do high

level sizing, define criticality, find resources and the time frame for implementation; Responsibilities

include:

Supriya Biswas Page 2

Analyzing SYBASE DB object to find possible improvement.

Developing and enhancing SYBASE SQL code to improve performance and maintain application

components integrity.

Developed awareness among the team to develop efficient SQL query.

Master Data Management – Item Master (UPC) Update

Responsible for developing Ab Initio graphs and UNIX shell scripts along with few team members to

extract update and load active UPC for five regions ( US, Canada, Brazil, Mexico and Columbia).

Global Productions lead for 20+ productions

Some of the responsibilities are:

Problem acknowledgement, initial analysis, priority negotiation and work assignment

Work with the team to resolve critical production data warehouse / data -mart issues.

Planning and execution of new version roll out to all productions

Active contributor in the development and support improvement processes.

Developed day to day production warehouse database change process and periodic database

migration process

Developed and enhanced various Autosys based UNIX Shell and PERL utilities

These utilities were used to monitor and measure production load, manage Autosys queues and slots,

monitoring progress of batch jobs for a given item, helping local and international countries to resolve their

Autosys related problem.

Development of various features for C&SE Decision Support System – Designed and developed codes

for various complex ETL functions of C&SE by using C, C++ and VC++.

4/1994 - 2/1998

Tata Consultancy Services, India

Role: Lead Developer

Worked on financial and telecom projects.

7/1990 - 6/1992

Steel Authority of India Ltd., India

Role: Software Engineer

Developed programs / components for Pay roll and Store and Inventory System of Steel Authority of

India Ltd.

AWARDS & CERTIFICATES

2010 Q2 Presidential Award from Application Security Inc.

2008 DB2 Developer Certificate.

2005 PMP Certification from Project Management Institute.

2004 Arthur C. Nielsen Jr. Global Award from ACNielsen.

EDUCATION

12/1993 - MS in Computer Science and Information Technology from Indian Institute of Technology,

Kharagpur, India

06/1990 - BS in Computer Science and Engineering from Jadavpur University, Calcutta, India

PUBLICATION

Algorithms for Convex Visibility Problems

Source Lecture Notes in Computer Science; Vol. 880 archive; Publisher: Springer -Verlag London, UK.

Supriya Biswas Page 3

Contact this candidate