SEARCH

SQL Server Architect/TSQL/SSIS Resume Example

Resume Score: 60%

Love this resume?Build Your Own Now
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
Company Name – City, State
  • 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
Company Name
  • M&T Bank has trade name in NYSE
ETL Developer01/2011 to 08/2011
Company Name – City, State
  • 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
Company Name – City, State
  • 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
Company Name – City, State
  • 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
Company Name – City, State
  • 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
Company Name – City, State
  • 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
Company Name – City
  • 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- City, State
Bachelor of Engineering (Computer Science)2004MS University- City
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
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

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

Similar Resumes

View All
SQL-Architect/DBA/ETL-Architect-resume-sample

SQL Architect/DBA/ETL Architect

,