Terence

PROFESSIONAL SUMMARY:

•

• Dynamic IT Professional with more than 8 years of experience in SDLC and possess experience

in Database technologies like SQL Server 2005/2008 R2/2012.

• 6+ years of experience as a Business Intelligence Developer.

• Expertise in writing T-SQL Queries, sub-queries and complex joins for generating Complex Stored

Procedures, Triggers, User-defined Functions, Views and Cursors.

• Experience using Data warehouse and BI Reporting to analyze and manage related Data.

• Expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and

Cubes.

• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and

calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005).

• Package Software: Expertise in Informatica ETL and reporting tools. Deep understanding of the

Data Warehousing SDLC and architecture of ETL, reporting and BI tools.

• Excellent hands on experience in creating and configuring Data Source & Data Source Views,

Dimensions, Cubes, Measures, using SQL Server Analysis Services (SSAS) 2008.

• Expert in calculating measures and dimension members using multi-dimensional expression

(MDX), mathematical formulas, and user-defined functions.

• Analyzed existing tool and participated in meetings with the business users to gather

Requirements and design goals of data warehouse.

• ETL: 5years of Data Warehousing experience using Informatica PowerCenter 8.6/8.4/7.1.4.

Excellent skills in implementing ETL Packages using DTS and SSIS 2008/ 2005.

• Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL

Server Reporting Services, and MS SQL Server Analysis Services.

• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow

Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.

• Extensive working experience in Normalization and De-Normalization techniques for both OLTP

and OLAP systems in creating Database Objects like tables, Constraints and Indexes.

• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process

for Data Integration and Migration services

• Used incremental approach in the Work Flows and Data Flows to integrate source data into

warehouse tables using required transformations

• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.

• Expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and

Cubes.

• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and

calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005).

• Excellent hands on experience in creating and configuring Data Source & Data Source Views,

Dimensions, Cubes, Measures, using SQL Server Analysis Services (SSAS) 2008.

• Expert in calculating measures and dimension members using multi-dimensional expression

(MDX), mathematical formulas, and user-defined functions.

• Conducted Performance Tuning, Query Optimization and Database Engine tuning.

• Involved in creation/review of functional requirement specifications and supporting documents for

business systems, experience in database design process and data modeling process.

• Expert in Integrating SSRS Reports and SSAS Cubes in web sites.

• Involved in Schedule the reports and checking the security for reports.

• Expert in designing SQL Server SSIS packages to import and transform data between databases

and external data sources.

• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012)

generated drill down reports, parameterized reports, linked reports, sub-reports, matrix dynamics and

filters, charts in SSRS 2008/2012.

• Flexible team player who thrives in environments requiring ability to effectively prioritize and

juggle multiple concurrent.

• Highly analytical thinking with demonstrated talent for identifying, scrutinizing and improving

complex work process.

• Excellent hands on experience Online transnational processing (OLTP) & Online Analytic

processing (OLAP).

TECHNICAL SKILLS:

MS SQL Server 2012/2008R2/2008/2005/2000/7.0, MS SQL Server 2008/2005 Analysis Services (SSAS), MS

SQL Server Integration Service (SSIS), MS SQL Server Reporting Services (SSRS), Business Intelligence

Development Studio (BIDS), BCP, SQL Profiler, Enterprise manager, Management studio, Microsoft Access 2000,

ERWIN 4.0/4.1/4.2/7.2, Microsoft Visio 10.0/11.0, T-SQL, ASP.NET, C#, VB.Net, HTML, XML, XSL, Oracle

11g/10g, Crystal Reports 8.5/9/10/11,TFS, Visual source safe 2005, MS office 2007/2003, Windows

2008/2003/2000 Advanced Server/Professional, Windows NT 4.0 Server/Workstation, UNIX, Perl, VBScript,

JavaScript, Dream Weaver CS4, Web Updater II, SSH Tactic, Web Ex.

PROFESSIONAL EXPERIENCE:

Client: UHG/XL Health, Baltimore MD Dec 13 to Present

Role: MS SQL Server/ BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

● Developed and deployed SSIS packages for ETL from various sources to staging and from staging to production

using Data Conversion, Derive Column, Script Task, Condition Split, for each loop container, and more. Performed

ETL mappings using SSIS and MS SQL Server

● Worked in the Agile methodology using Scrum which has its primary focus on the management part of the

software development, dividing the whole development period into small iterations (of thirty days) called "sprints."

● Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables to

check metadata entries in test and prod databases.

● Created SSIS Package configurations for executing in different environments.

● Applied Conversion strategy to modify the data from different sources (Mainframe and Oracle Database) into the

required SQL database format.

● OLAP design (SSAS 2008R2) for different cloud services and service items. Implemented OLAP cube and

connecting using Excel PowerPivot.

● Developed complex T-SQL code such as Stored Procedures, Indexes for the application.

● Enhancing the existing SSIS packages to meet the changes specified by the users.

● Created C# and VB.Net Script for Data Flow using Script component in SSIS.

● Created/Updated database objects like tables, Indexes, and Pk’s to avoid duplicate entries in the table.

● Developed Unit Test Plans for SSIS packages for checking the functionality of each component.

● Create scripts for SSIS Jobs in test and production to deploy and schedule automated SSIS jobs on off -peak

hours.

● OLAP design (SSAS 2008R2) for different cloud services and service items. Implemented OLAP cube and

connecting using Excel PowerPivot.

● Involved in the creation of DLP’s to guide current and future developers for the organization.

● Worked with application developers and production teams across functional units to identify business needs and

discuss solution options.

● Create Scripts for Data Validation in Production after the process has been deployed.

● Documented the development work and production release for future reference.

Tools & Technologies:

MS SQL Server 2008/2012, MS SQL Server Reporting Services, MS SQL Integration services, T- SQL, Share

point 2010, Visual Source Safe 2005, MS Excel, MS word, Visual Studio 2008, Visual Studio 2012

Client: METLIFE, NYC, NY Jan 13 to Nov 13

Role: MS SQL Server/ BI Developer (SSIS/SSRS/SSAS)

MetLife, Inc. is a leading global provider of insurance, annuities and employee benefit programs. The Project is to

extract data from various sources like DB2, Oracle, SQL Server and load into SQL Server 2012 using various

transformations in SSIS. Also, it includes creation of Analysis cubes on Enrollment and Premium data marts.

Responsibilities:

● Translated business needs into data analysis, business intelligence data sources and reporting solutions for

different types of information consumers.

● Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided

documentation.

● Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the

application.

● Enhanced and built different reports using SSRS 2008R2 by discounts, service items, cloud node, usage, invoice

etc. Extensively used Joins and sub-queries for complex queries involving multiple tables from different

databases.

● Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables &

calculations from different databases.

● Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other

applications in most efficient manner.

● Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on

the fly.

● Created and implemented a plan for the daily incrementals to bring the data from the Oracle server to the SQL

Server.

● Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2012 by using Lookup,

Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly

Changing Dimension.

● Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data

Mart Databases.

● Developed Unit Test Plans for SSIS packages for checking the functionality of each component.

● Modified the existing SSIS packages to meet the changes specified by the users.

● Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily

basis using SQL Server Agent.

● Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.

● Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized

reports using SSRS 2012.

● Created reports to retrieve data using Stored Procedures that accept parameters.

● Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard

● Responsible for Monitoring and Tuning Report performance.

● Created various database objects like stored procedures, functions, tables, views.

● Configured the report viewing security for various users at various levels using Report Manager.

Tools & Technologies:

MS SQL Server 2012, T-SQL, SSIS 2012, SSRS 2012, TFS 2010, Advanced Server, SSMS, Erwin v7.2,

ASP.Net, C#.

Client: RBS CITIZEN, Philadelphia, PA Apr 11 to Dec 12

Role: MS SQL Developer

RBS Citizens, N.A. provides commercial banking services. The company offers personal and small business

banking services, such as checking accounts, savings and money markets, card products, student loans, and

online banking. It provides deposits, cash management, borrowing options, and personal and business investing

services. This project was about database administration, database architecture, and database installation,

software application tier, reporting services, database modification and enhancement.

Responsibilities:

● Worked with business stakeholders, application developers, production teams and across functional units to

identify business needs and discuss solution options.

● Worked in the Agile methodology using Scrum which has its primary focus on the management part of the

software development, dividing the whole development period into small iterations (of thirty days) called "sprints."

● Used Visual Intercept Manager, the premiere bug tracking system for the Microsoft development environment,

which is project oriented, scalable and optimized.

● Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data

warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing

Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.

● Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.

● Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the

database. Worked on different cloud services, such as Infrastructure as a Service (IaaS), Platform as a Service

(PaaS), Software as a Service (Saas), Cloud Backup Services, Disaster as a Service (DraaS).

● Created/Updated database objects like tables, views, stored procedures, function, packages.

● Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data

entry into the database.

● Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).

● Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in

several different ways - hierarchically and using custom groupings that the company will use to analyze

performance.

● Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.

● Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including

current status.

● Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).

● Involved in monitoring and tuning report performance by analyzing the execution plan of the report.

● Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using SSRS.

● Designed and developed monthly, quarterly and yearly reports at branch and bank level.

● Involved in table and index partitioning for performance and Manageability.

● Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database

optimization.

● Monitored the overall performance of the database to recommend and initiate actions to improve/optimize

Performance.

● Used SQL Server Profiler to trace the slow running queries and the server activity.

● Automated and enhanced daily administrative tasks including database backup and recovery.

● Helped create process logging and new monitoring tools, integrity reports, and mapping tools.

● Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance

plans and recovery.

Tools & Technologies:

SQL Server 2008R2, SSRS, SSIS, SSAS, Oracle, DB2, MS Access 2003, MS Excel 2007, MS BIDS, Windows

2008 Server, Visual Studio 2008, VB. Net, C#.net, Performance Point Server.

Client: UNION BANK, San Diego, CA June 10 to Mar 11

Role: MS SQL Developer

Union Bank, N.A., is a full-service commercial bank, providing a broad mix of financial services to businesses and

individuals. The project was about analyzing market potential, generating various reports and analyzing the

performances of branches in loans sector

Responsibilities:

● Worked with application developers and production teams across functional units to identify business needs and

discuss solution options.

● Successfully installed and configured MS SQL Server2008R2 on the development server.

● Automated the migration of data from Flat file to MS SQL Server 2008R2 DB using Microsoft SQL Server

Migration Assistant (SSMA).

● Generated assessment reports to analyze the scope and complexity of the migration projects.

● Designed a new schema design for the data warehouse using dimensional modeling and developed it using the

Erwin tool.

● Migrated the entire schema as well as data into MS SQL Server 2008R2 and also validated the migration process

to ensure that it has been successfully migrated.

● Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.

● Performed various transformations like conditional split, sorting and included data about the environment using

the audit transformation.

● Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets

of data and used Multi-Dimensional expression (MDX) to access them.

● Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.

● Defined referential relationships with the measure groups and fact tables.

● Generated automatically grouping attribute members and implemented the calculations to aggregate physical

measures.

● Defined granularity within measure group and drill through actions.

● Created cube reports that can be browsed at summary level and can be drilled down to the detail level.

● Defined the browsing perspectives and browsing translations since most transactions were online.

● Documented the development work and production release for future reference.

Tools & Technologies:

MS SQL Server 2008R2, SSIS 2008R2, SSAS 2008R2, MDX, T-SQL, MS Access 2007, Windows Server 2008,

Erwin v7.1.

Client: AUTO INSURANCE GROUP, Lansing, MI Nov 08 to May10

Role: MS SQL Developer

Auto insurance group is comprised of five property and casualty companies and one life/health/annuity insurer,

the group is recognized for exceptional financial strength and stability among the nation's largest insurers. The

project involved designing of data Warehouse Developing and monitoring the SSIS packages to upload data from

the staging to DW and generating Reports using SSRS

Responsibilities:

● Involved in all the phases of SDLC.

● Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of

Constraints and Triggers for Data Consistency.

● Used Stored Procedures for updating Servers.

● Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before

calling them.

● Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware

House.

● Developed, deployed and monitored SSIS Packages. Involved in creating log files for SSIS packages.

● Created SSIS Package configurations for executing in different environments.

● Enabled Check points in SSIS package. Created break points in order to view the status of data, variables and

over all status of SSIS package.

● Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.

● Enhancing and deploying the SSIS Packages from development server to production server.

● Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.

● Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill

through and drop down menu option using SSRS.

● Created/ Maintained clustered/ non clustered Indexes for fast and efficient reporting process.

● Used SSRS to create interactive reports with an ability to drill down into details.

● Create OLAP cubes with SSAS based on multidimensional database with star schema or snow flake schema

● Created named set and named calculations to create derived data and calculated field and calculations in the KPI.

● Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX,

developing reports using MDX and T-SQL.

● Created MDX script for representing Cube Calculation using SSAS.

Tools & Technologies:

MS SQL Server 2005, SSIS, SSRS, T-SQL, Crystal Reports 10,Visual Studio 2005, MS Office 2003, SQL Profiler,

Windows 2000/2003.

FIDELITY NATIONAL INFORMATION SERVICES, Jacksonville, FL Nov 07 to Oct 08

Role: MS SQL Developer

FIS™ is the world’s largest global provider dedicated to banking, payments technologies and leadership positions

in payment processing and banking solutions, providing software, services and outsourcing of the technology that

drives financial institutions.

Responsibilities:

● Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis,

working in conjunction with the data warehouse architect used (Kimball’s approach)on the development of logical

data models.

● Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.

● Created logical and physical data models using Erwin for new requirements after discussion with technical team

and application users.

● Designed and implemented complex SSIS package to migrate data from multiple data sources (Teradata) for data

analyzing, deploying and dynamic configuring of SSIS packages.

● Designed high level ETL architecture for overall data transfer from the OLTP to CDW with the help of SSIS.

● Created OLAP cubes and dimensions for the analysis of student’s registrations in specific areas using SSAS.

● Developed and maintained a combined data store for reporting purposes.

● Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services

2005.

● Identified the database tables for defining the queries and defined datasets for report generation.

● Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.

● Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005.

● Generated daily, weekly and monthly reports for the managers.

● Administered interface to organize reports and data sources, schedule report execution and delivery, and track

reporting history using SSRS 2005.

● Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.

● Tested the reports and fixed bugs in the stored procedures.

● Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems

in MS SQL Server 2005 with the use of the Query Analyzer and Database Engine Tuning Wizard.

● Established backup and recovery of MS SQL server 2005 by using SQL Server Agent Jobs for periodic Backups

with backup devices, database maintenance plans and recovery.

● Used Visual Source Safe (VSS) for version control.

Tools & Technologies:

MS SQL server 2005, MS Server Integration services, SSIS, DTS, SSRS, Profiler and Windows Server 2003.

Client: AFLAC, Columbus, GA Nov-05 to Sep-07

Role: MS SQL Developer

Aflac provide financial assistance when an illness or serious accident occurs. The scope of the project was to

create reports on different plans, customers that enabled the business users to analyze the company sales and

insurance patterns.

Responsibilities:

● Defined and designed the data sourcing and data flows, data quality analysis.

● Identified the data source and defined them to build the data source views.

● Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on

database objects.

● Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.

● Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the

data into target data destination by performing different kinds of transformations using SQL Server Integration

Services (SSIS).

● Used SQL Server Agent to automate the SSIS 2005 package execution.

● Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data

to fact tables.

● Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2005 and then

created reports using this data using SSRS.

● Configured and maintained Report Manager and Report Server for SSRS.

● Identified and added the report parameters and created the reports based on the requirements using SSRS 2005.

● Tested and managed the SSIS 2005 and SSIS 2005 packages and was responsible for its security.

● Created business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several

different ways - hierarchically and using custom groupings that the company will use to analyze performance.

● Developed and designed cubes with dimensions, Measures and calculated members.

● Developed reports using efficient data retrieval techniques and tested the reports.

● Created Cross-Tab, Drill-down and Sub-Report using SSRS 2005.

Tools & Technologies:

MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Integration services, T- SQL, Erwin, MS

Excel, MS word, Visual Studio 2005.

EDUCATION:

Bachelors

Contact this candidate