Contact no: 086*******
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.
. 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
Application tools MS Visual Studio 2012, Visual Source Safe, Cognos
Other development MS Office, MS SharePoint 2010, MS Project, MSMQ,
ARCServe2000, PCAnywhere, VNC Viewer, Beyond
Systems Windows Server R2, 2008, 2003 IRIX, and LINUX
. B.Sc (Mathematics) From Utkal University, State of Orissa, India.
. M.Sc in Applied Computing for Technologists from DIT, Dublin(Part
. Advanced Post Graduate Diploma in Computer Application from Academy of
Computer Education. Bhubaneswar, State of Orissa, India.
* 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
. 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
. 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
. 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
. 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
. 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
. 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
. 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
. 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-
. 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
. 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
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
. Used various methods of reporting such as Crystal Reports, Access, and
MS Excel and compile queries to create statistical reports for
. Proactively monitored and alert on SQL Server table space, locks,
performance, memory management, fragmentation, overall system
8. Cendris Ltd/EDS, Dublin, London, SQL Analyst,Permanent(March 2002 -
December 2004), Project: Document Imaging System of ILR (Irish Land
* 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
* 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
* Analyses of SQL server database performance to reduce network load and
increase client response for speedier problem correction, and better
* Involved in daily management and maintenance of database backups +
media pool management of tapes using ArcServe 2000.
* Reported directly to Production Manager, & Shift Manager.