Sql Server Data

Sanjeeb Barik

Dublin, Ireland

Contact no: 086*******

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

MS SQL BI Professional

Expertise and Interest include MS SQL Business Intelligence analysis,

design and development in Finance, Telecommunications, Shipping, IT domains

and experience in working various data sources to create BI solutions for

internal operations, and external clients for large (VLDB) complex

databases. Demonstrated leadership abilities and team work skills as well

as the ability to accomplish tasks under minimal direction and supervision.

Core Skills

. Experience in MS SQL Server BI Development (SSIS, SSAS, & SSRS) and

administration of SQL Server 2012/R2/2008 and 2005.

Experience in SQL Server Database design and development

. Data warehouse/Data mart, schema design

. Relational database design

. Kimball methodology

. Erwin Data modelling

. Good working knowledge of T-SQL programming skills (stored procedure,

function and trigger development)

. Experience in table creation, indexing, DB partitioning, replication

technology and DBCC commands

. Working knowledge of other BI tools: Cognos, and ETL development

knowledge using Informatica

Tools & Application

Databases MS SQL Server 2012/R2/20082005, & Teradata

Programming T-SQL, VB.net, JavaScript, XML, Cold Fusion, C#

Application tools MS Visual Studio 2012, Visual Source Safe, Cognos

v8.3, Qlikview

Other development MS Office, MS SharePoint 2010, MS Project, MSMQ,

tools SAS,

ARCServe2000, PCAnywhere, VNC Viewer, Beyond

Compare,

Visio,& SVN

Systems Windows Server R2, 2008, 2003 IRIX, and LINUX

Mandrake

Educational Qualification

. B.Sc (Mathematics) From Utkal University, State of Orissa, India.

. M.Sc in Applied Computing for Technologists from DIT, Dublin(Part

time)

Professional Qualifications

. Advanced Post Graduate Diploma in Computer Application from Academy of

Computer Education. Bhubaneswar, State of Orissa, India.

Certifications

* SQL (ANSI) Fundamentals & RDBMS Concept (Brainbench)

* MS SQL Server 2005 Programming & Administration (Brainbench)

* Management and administration of Web Applications with Microsoft SQL

server 2005, and Visual Studio .NET

Passport/Visa Status

. Irish passport(EU Citizen)

Summary of Work Experience

1. HP, Ireland. ESIT group( Finance and Sales Analytics), Data Modeller/ETL

Developer, Contract from June 2013 - Present

. MSBI data ware house solution on HP Cloud Computing Database Services.

. Work directly with the product owner, business analysts and finance

users in understanding the information needs of the business and

developing BI functionalities to meet the requirements.

. Designed dimensional data model for finance and sales group tables

using Erwin data model and merged with main data warehouse ESDW.

. Design and develop of custom ETL framework using SSIS that collect,

cleanse, apply the business rules and integrated the company's sales

forecast performance data (i.e., cash-flows, revenue sales using

various measure types, deal size and stages) from various operational

source systems.

. Architecting automation of a new financial forecasting dashboard for

the business using T-SQL, SSIS, SSRS and SSAS tool.

. Development and enhancement of existing dashboard reports using

Qlikview application.

. Ensure that unit testing is conducted successfully.

. Ensure high quality and performance in the BI architecture.

. Participate in the daily agile scrum meeting, sprint planning, spring

review, and spring retrospective.

. Currently in house training with HP Vertical tool for Analytics

(Bigdata) and data processing.

2. AEGON (Investment and Insurance), IFSC, Dublin, BI Developer. Solvency

II - Asset Information Project, Contract: March 2012 - April 2013.

AEGON Ireland businesses focus on Investment, Fixed Investment, Wealth

Management, ETF, Funds, Insurance, Reinsurance and Asset management

products. The company is also active in accident and supplemental health

insurance and general insurance, and has limited banking activities. My

role with company was to understand the business needs and setup a new

Data Warehouse.

Key responsibilities:

. Worked within an Agile development environment delivering business

software solutions to agreed standards and timelines

. Day to day Interaction/Co-ordination was with BA/PM (Scrum Master) /

Financial Actuarial team, and weekly meeting with Third party company

Morningstar, Bloomberg, Kames Capital team, Vestra,

Derivatives(Futures, & Swap)and other major Delegated Custodians(BNP

Paribas, Merrill Lynch, and Citigroup) to understand and validate end-

user requirements in accordance with business need.

. Built a new data warehouse/BI functionalities for Asset Information

data warehouse project using high level ETL architecture for overall

data transfer from the various source server to the Enterprise

Services Warehouse including FTP data from remote location, transform

it, mart it to data warehouse and provide proper error handling and

alerting process.

. Designed a new schema for the Data Mart databases.

. Created various SSIS packages for internal financial users, and

delegated custodians using data mapping, conditional split, data

conversion, data load and C#.

. Involved in physical and logical database design and objects like T-

SQL, Stored Procedure, Views, Triggers, Packages, Transaction

Management.

. Developed Tablix Reports, Tabular and Matrix Reports, and Charts using

SQL Server Reporting Services (SSRS).

. Created MDX queries to extract data from the Data Mart.

. Prepared unit test plans and executed unit testing and participate in

system and user acceptance testing tasks as assigned.

. Responsible for deploying the SSIS packages and scheduling the package

through Jobs in all Tiers including Dev, INTEG, UAT and Production

environment.

. Setup the Configuration files which is done in the specified tables to

manage SSIS packages variables.

. Optimized the performance of queries with modifications in T-SQL

queries, removed unnecessary columns, eliminated redundant and

inconsistent data,normalized tables, established joins and created

indexes whenever necessary.

. Used JIRA for tracking of project tickets/bugs.

. Other tools used are

o Subversion: Source control system for the code

o Crucible: Code Review tool.

o Visual Studio 2010 (Schema and data comparison)

o IBM Informix SQL query run, and access through Server Studio

o Altonova XML editor.

3. Certus.ie, (A former Bank of Scotland and part of Lloyds Banking Group),

Dublin, MI department, BI Developer, Contract: October 24th 2011- March

2012

. Certus has been appointed by Bank of Scotland plc to provide for any

business queries in relation to Lloyds Banking Group plc matters in

Ireland. I was hired by the company's Management Information (MI

Function) department to look into bank Credit Risk, and Portfolio

Analytics BI reporting development and management of dashboard.

. Responsibilities include working with senior management and various

business units to define metrics, gather report requirements, and

functionally design a system (data mart, and dashboard, reports.)

. Development of the data mart by collecting the data from legacy systems

and provide users with required analytics (tabular and graphical

reports, KPIs, Scorecards and dashboards) for financial, credit risk,

marketing analytics. The project used SSIS (ETL), SSAS (OLAP), SSRS, and

MOSS and Excel Services.

. Developed a data mart to populate and migrate data from other data

sources to SQL 2005 data warehouse and transactions processing of credit

risk scoring model data using ETL SSIS and produce reports using SSRS.

. Generated several detail and summary reports and sub-reports according

to business requirements using Report Builder.

4. IPSI, www.ipsi.ie (A premier policy insurance Irish company) Dublin,

SQL BI Development, Contract: April 2011 - October 21st 2011

. Worked as a BI development role to design, develop a data migration

project and integrate data from various data sources (CLOAS, EXCEL) to

SQL 2008 R2 data warehouse and process the cube for aggregation reports

using SSIS/SSRS/SSAS cube and Qlikview reporting tool.

. Daily interaction with external clients was on BI issues (design of

SSIS packages, report design using SSRS and write MDX query for SSAS

cube) and for any further new development requirement.

. Built dashboard by analyzing data from mainframe data source,

identified data rules, and implementation of ETL process task using

SSIS and load into UNIX environment.

. Worked directly with mainframe functional analysts and business users

to understand the needs of the business information and develop new

data warehouse/BI report functionalities.

. Developed policy finance reports scripts within Qlikview derived from

multiple sources: SQL Server, Excel, and text files.

. Developed intranet reports for the clients and actuarial department

using SSRS. Demonstrated the reports and T-Sql query to actuarial team

how to develop data mining models using excel and MS SQL.

RTE, www.RTE.ie, Donnybrook, Dublin, SQL Consultant, Contract: July 2010-

March 2011

. SQL development and consultancy services for RTE.ie web and mobile

application. Job responsibilities was mainly involved with development

and analysis of business flows of data and migration project using SQL

server management BI technology (SSIS, SSRS & SSAS).

. Implemented SharePoint for document management, collaboration and

automation of business processes using workflow and integrated the

reports/KPIs/dashboards etc. with MOSS.

. Developed SSIS Packages to evaluate and integrate large amounts of

client data into the old MS SQL Server 2000 to SQL 2008 databases.

. Built SSRS reports for internal management as well as Client specific

reports, using MS SQL Server 2008.

. Set up traces and Profiler to troubleshoot performance and tune

database objects to analyze deadlocks & diagnose issues on the server.

. Performance tuning of database server and bug fixing of SQL code.

. Rewrote existing cubes for better query performance.

6. Microsoft, Ireland,

Release IT (RELIT) & Business IT (BGIT), Dublin, Senior SQL Analyst,

Contract: August 2006 - July 2010

. Worked as a senior SQL analyst to solve the database issues

proactively. Daily work was involve of database analysis, reporting,

administration, and providing MSSQL server technical expertise to

troubleshoot issues for both HB/MB (High and Medium business)

application for various MS Internal groups and partner/vendor

customers.

. Responsible for technical DB architecture design includes

business/data analysis, and implementation of components in a highly

scalable n-tier transaction web based environment.

. Responsible for general database Administration, performance tuning

and data analysis work on 67 SQL servers (50 VM's, 10 Hyper-V's and 7

Physical servers) and one consolidated SQL server including setup of

SQL 2008 on newly created VM's and responsible for conversion of

physical servers to Hyper-VM. Created and update technical KB

documents as per MS DBMS policy.

. Created dashboard reporting solutions using SSRS to generate various

business statistics reports. Also well experienced with MS internal

CRS dashboard report application.

. Developed OLAP cube to extract legacy data to support and generate

internal business cost utilization analysis and report system using

SSAS, and SSRS.

. Designed SSIS packages to extract, transform and load from various

OLTP databases to the application master database.

. Designed and created database schema and business process flow using

Visio to understand the complex business process and updated the

document in team SharePoint web site and source depot.

. Track and prioritized bugs and feature requests reported by

application users and management team.

. Ensured each reported problem and task is resolved efficiently in

minimum timeframe (per SLA), tracked according to standards and

escalated as appropriate.

. Coordinated with India and Redmond team members to manage daily team

workload and ensure solutions meet business objectives and establish a

high level of user trust and confidence in IT.

. Communicated problem resolution with product groups, business customer

and IT application management groups in a high-pressure, complex team

environment.

7. Tescodiets.ie, Dublin, Database developer & administrator, Permanent,

December 2004 - July 2006

Primary role was involved in the area of database management services for

all phases of data methodology lifecycle, focusing on data analysis,

design, and database administration using Cold fusion & MS-SQL 2000.

. Participated business data migration processes and applied that

knowledge to the data requirement and business solutions from existing

Cold Fusion to ASP.NET, and SQL Server 2000 environment.

. Worked with developers in database design review, deployment and

monitor development, QA and production SQL Servers to ensure data

availability and server uptime.

. Developed T-SQL query for the members new meal plan database project

(Nutrition Totaller) and demonstrated to the business and technical

team ensuring current standards and practices are met with integration

of SDLC methodology and design patterns.

. Developed an internal XML based Web Portal Application which allowed

for a more reliable, professional meal plans using XML, SOAP, SQL and

ASP.

. Used various methods of reporting such as Crystal Reports, Access, and

MS Excel and compile queries to create statistical reports for

management.

. Proactively monitored and alert on SQL Server table space, locks,

performance, memory management, fragmentation, overall system

performance issues.

8. Cendris Ltd/EDS, Dublin, London, SQL Analyst,Permanent(March 2002 -

December 2004), Project: Document Imaging System of ILR (Irish Land

Registry)

* Supported and admin of ILR databases involving performance tuning,

writing T-SQL, Triggers, handling data and preparation of operational

stored procedures modules to ensure workability of program/system

parameters, execution and testing of database level backup and

recovery procedures.

* Assisted creation of reporting mechanisms using main system database

to generate production statistics.

* Converted old DB systems data to a master tables using DTS import and

export option.

* Analyses of SQL server database performance to reduce network load and

increase client response for speedier problem correction, and better

customer support.

* Involved in daily management and maintenance of database backups +

media pool management of tapes using ArcServe 2000.

* Reported directly to Production Manager, & Shift Manager.

Contact this candidate