SQL Server Architect/TSQL/SSIS Resume Example Rbscitizen Bank

SQL SERVER ARCHITECT/TSQL/SSIS

Professional Summary

Worked on SQL BI solution integration with Microsoft SharePoint Server (MOSS). Expertise in Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects. Involved in Security Administration, Managing schemas (2005), creating Credentials, creation of users, configuring permissions and assigning roles to users. Experience in developing web applications using ASP.Net, ADO.Net and Web Services Involved in 24/7 production support and also experienced in testing environment. Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

Skills

MS Access
WebLogic Oracle
MS SQL Server 2012/2008/2007/2005

BI Services

Informatica
Erwin Tool
MS Visio 7
MS Access

Code reviews
Agile
HTML and XML
Engineering standards
Operational analysis
Expert in MATLAB
ASP.NET , C#
Oracle 8i/9i/10g/11g
DataStage

Work History

SQL Server Architect/TSQL/SSIS11/2012 to Current
RBSCitizen Bank – Providence, RI

Experience in SQL Server DTS and SSIS (Integration Services) package design, development, and deployment using SQL 2008 advanced features in Control flow, data flow, Error Handling and event handling.
Expert in IBM Web Sphere Data Stage 8x/7x/6x ETL tools & Documentation.
Experience in SSIS package scripting, scheduling, monitoring, deployment and production support.
Real time Experience in Modify SSIS Package & Create SSIS Package by using different sources like XML, SSAS cube, Web-service.
Development & maintain Tools like C#, C++ related work tool.
Strong knowledge in Performance Point Server 2005/2007/2010 to designing dashboards and scorecards in highly complex scenarios with multiple KPIs, OLAP Charts and SSRS Reports.
Established standards for SQL installations, maintenance, tuning and coding Leader in the development of our OLAP Data Warehouse Reporting Initiative Provided training, mentoring, and feedback to team members to enhance communication and performance.
Developing reports on SSAS.

Database Architect/TSQL/SSIS/SSAS08/2011 to 11/2012
M&TBank / Wilmington Trust

M&T Bank has trade name in NYSE

ETL Developer01/2011 to 08/2011
Helzberg Diamond – Kansas City, MO

SQL Server/SSIS /SSAS/Data Stage Company Helzberg Diamonds Established since 1915, Helzberg Diamonds is Big name for Diamonds & Jewelry Retail Business in United States, Company have more than 300 Retail Stores in USA.
Hardware/Software MS SQL Server 2008, .NET, Data Stage 8.0/7.5.1(Ascential, IBM Web Sphere), Management Studio, SSIS, SQL Profiler, MS Excel (Documentation), Erwin Tool ,Windows XP Professional.
Responsibilities

MS SQL Server Developer/SSAS/SSIS09/2009 to 12/2010
Ceridian Health Insurance – Minneapolis, MN

Ceridian is global company Provides big services in Health Insurance services with Ceridian health coaches can then help to make positive lifestyle changes for the long term, improving health and well-being.
We all need positive reinforcement, especially when it comes to change, and our incentive programs can provide with the motivation people need to get and stay healthy with any position company always with require support to people, During Project my goal to create SSIS package, Reporting Services, Maintain Performance by SQL Profiler.
Hardware/Software

SQL Architect/ SSIS/SSRS/Data Stage07/2008 to 09/2009
Avion Systems – Atlanta, GA

Avion Systems mission is to provide the highest quality and best value in services, solutions and innovations to its clients.
Company vision is to achieve the mission by strict adherence to a set of core values like, instilling trust by always taking responsibility for actions and being accountable for all that company provide services like RF measurement and RF testing.
Hardware/Software

MS SQL Server Developer/ SSRS Lead02/2007 to 07/2008
Morgan Stanley – New York, NY

Morgan Stanley is the true way to get financial services.
The firm has continually broken new ground in advising Company clients on strategic transactions, in pioneering the global expansion of finance and Credit check, Private Equity and in providing new opportunities for individual and institutional investors.
Hardware/Software

MS SQL Server Developer/SSAS01/2006 to 02/2007
Lehman Brothers – New York, NY

Lehman Brothers Provides Services on financial, Private Equity ,Investment Banking, Investment Management as well as providing new opportunities for individual and institutional investors.
Company has Branches in major cities in USA.
Hardware/Software

Database Developer11/2004 to 12/2005
SLK Software Vision of Company – Bangalore

To be the most inspiring business group in India, Admired globally for creating sustained prosperity.
Company Provide Services like Integrity, Application Reengineering and Application Development.
Company has branches in major cities in India.
Hardware/Software

Education

Master of Science: Electrical Engineering2010University of Bridgeport- Bridgeport, CT

Bachelor of Engineering (Computer Science)2004MS University- Gujarat India

Accomplishments

Over 8+ years of experience in Data Modeling, Dimension Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2012/2008/2007/2005 for both OLTP (Batch Processing, Online Processing) & Kimball Methodology.
Experience in various business domains like financial services, Insurance & healthcare, in high transactional and multi-server production environments.
Strong T-SQL experience in creating database objects like tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes.
Involved in relational data modeling (normalization, Relations) and multi-dimensional modeling using De-normalization, Fact tables, Dimension tables, Star schema for OLTP/OLAP systems.
Involved in heavy data migration/ETL activities using BCP, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2000/2005/2008).

Certifications

Microsoft Certification in Database Developer
Microsoft Certification in BI Solution & BI Architect

Resume Overview

Companies Worked For:

RBSCitizen Bank
M&TBank / Wilmington Trust
Helzberg Diamond
Ceridian Health Insurance
Avion Systems
Morgan Stanley
Lehman Brothers
SLK Software Vision of Company

School Attended

University of Bridgeport
MS University

Job Titles Held:

SQL Server Architect/TSQL/SSIS
Database Architect/TSQL/SSIS/SSAS
ETL Developer
MS SQL Server Developer/SSAS/SSIS
SQL Architect/ SSIS/SSRS/Data Stage
MS SQL Server Developer/ SSRS Lead
MS SQL Server Developer/SSAS
Database Developer

Degrees

Master of Science : Electrical Engineering 2010
Bachelor of Engineering (Computer Science) 2004

SQL Server Architect/TSQL/SSIS Resume Example

Resume Score: 60%

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes