We provide IT Staff Augmentation Services!

Ssrs/ssis/sql Server Resume

Ranch, CO

Summary:

  • Eight years of IT experience which includes seven plus years of experience in Development, Design, Working experience of MS SQL Servers 2005,2000 and 7.0 in Production, QA, Development environments.
  • Overall database design, such as creating normalized databases, tune queries, assigning proper indexes, creation of triggers and stored procedures.
  • Experience in working with Reporting tools like Crystal Reports, Microsoft Reporting services.
  • Flexible and versatile to adapt to any new environment and work on multiple projects.
  • Experience in creating Ad hoc reports and tuning of reports.
  • Excellent knowledge in RDBMS concepts and constructs.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages
  • Extensive knowledge of MDX and creating cubes.
  • Experience in Data cleansing or data scrubbing.
  • Experience in working with version controlling tools for managing SQL scripts and changes that are going to production.
  • Transformed data from one server to other servers using Bulk Copy Program (BCP) and Data Transformation Services (DTS).
  • Good understanding of capacity planning.
  • Experience in using SQLCMD.
  • Extensive knowledge of Relational Database Management Systems.
  • Extensive experience in installation and configuration of MS SQL Server 2000/7.0/6.5 versions.
  • Expertise in planning and implementing MS SQL server security and database permissions.
  • Experience in Database Backup, Recovery and Disaster Recovery procedures.
  • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
  • Hands on experience in trouble shooting database issues.
  • Experience in writing and debugging stored procedures and triggers.
  • Experience in Data Modeling using ERWIN tool and normalization of tables.
  • Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

Technical Skills:

Operating Systems Windows 2003/2000,Windows XP, Windows NT 4.0 Server/Workstation, Windows 98/95, Terminal Server 4.0, Windows 2000 Advance Server, MS DOS, Unix.

Languages C, C++, JAVA, XML, T-SQL, SQL Plus, ISQL, OSQL, VB Scripts, C#
RDBMSMS SQL Server 2008,2005,2000 , 7.0 and 6.5, Oracle, MS-Access
Front End MS Visual Basic, Dream Weaver
Internet Technologies ASP, Java Script, HTML, Cold Fusion
OLAP Tools MS OLAP Services Manager
Version Control Tools Rational ClearCase, Visual Source Safe
Other Tools Compaq Insight Manager, Idera Diagnostic Manager, Quest Spotlight, SQL Lightspeed, ERWIN 3.0, Toad, Crystal Reports, SQL Backup.
Hardware Compaq Proliants 6500, 6000, 5000 Servers, IBM PC AT
SQL Server Tools Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS),SSIS,Visio, SSAS

Educational Qualifications:

Master in Information Technology

Bachelor in Computer Science

Application Areas:
  • Setting up Replication On MS SQL Server 2000 and 7.0
  • DTS(Data Transformation Service)
  • SSIS(SQL Server Integration Services)
  • Data Warehouse
  • ODBC/OLEDB/Windows API's used for Data Access, Connection Pooling

Work Experience:

Confidential, Highlands Ranch, CO Jul 2010 - Till Date

Developer

  • ESM was founded in 1995 to serve as the admissions arm for Sylvan Learning Center franchises in Colorado. It has served institutions large and small, non-profit and post-secondary. In all cases, it helps develop and deliver effective solutions to attract and retain more students. Over the years, as the needs of its clients have grown, it has expanded its services to encompass every stage of the student lifecycle.
  • Developed stored procedures, views, triggers and user-defined functions using T-SQL.
  • Created email and file share subscriptions on report manager to share the reports to the clients.
  • Used monitor all subscription jobs and sends email alerts to the reporting team.
  • Developed and deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Generated the weekly, monthly, and quarterly report by using SQL Server Reporting Services.
  • Tuned of Stored Procedures and SQL Queries and created some indexes on tables.
  • Exported data from MS Access to SQL Server.
  • Created SQL Server jobs for SSIS packages and scheduled them and monitored them.
  • Created table, views and modified tables, views based on new requirement.
  • Documented the whole system and life cycle of the project.
  • Created database with multiple file systems Interacted with Business Analysts to capture the requirements, analyzed the entire system and prepared the design documents.
  • Used stored procedures with parameters and SQL queries to generate the reports.
  • Created drill down reports based on the requirement.
  • Modified stored procedures and functions based on new business rules and deployed them.
  • Created cubes and used these cubes to generate reports using SSRS.
  • Converted Crystal reports to SSRS reports.
  • Created KPI dashboards and Reports.

Environment:
SQL Server 2005/2008,SQL Server Reporting Services, SSIS, Windows Server 2003, Windows XP, C#, MS Office, VSS, Visio, SSAS,SSRS 2008R2.

Work Experience: Bloomington, MN Apr 2009 - Jun 2010

Developer

Confidential,is a diversified financial services company providing banking, insurance, investments, mortgage and consumer finance through more than 10,000 Wells Fargo and Wachovia stores. It is a largest financial institution headquartered in the western U.S. It's stock market value is about $100 billion. Forbes ranks among the world's top 50 companies based on a composite of sales, assets, profits and market value. It is in the top 20 among all U.S.

Responsibilities:

  • Created SSIS packages to export Data from Flat Files(IBM Mainframe) to SQL server.
  • Created data driven subscriptions on report manager to use single subscription to distribute different reports to different clients.
  • Created ER Diagrams for all tables which are used in SSIS packages and documented the work flow.
  • Used Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.
  • Generated Reports using SQL Server Reporting Services (SSRS).
  • Deployed the SSIS packages on different servers and tested those packages.
  • Optimized Query Performance and Reliability.
  • Created new tables and databases, normalized and indexed all the tables.
  • Written stored procedures for front end and helped the front end application developers with their queries.
  • Generated Reports using cubes.
  • Created temp tables and table variables.
  • Cleaned data and corrected corrupted data.
  • Created all types graphs in reports using SSRS.
  • Sent reports to the clients using email subscriptions and file share subscriptions.
  • Tuned of Stored Procedures and SQL Queries and created some indexes on tables.
  • Created procedures using PL-SQL.

Environment:
Windows Server 2003,VSS, MS SQL Server 2005,T-SQL,Visio, SSIS, MS Excel, MS Word, SSRS 2008 R2, C#, Oracle, ASP.NET, DB2, Unix, MS Access, SSAS, Oracle, PL-SQL.

Confidential, Montpelier,VT Jul 2008 - Mar 2009

Developer

Cabot Creamery is a 1,350 farm family dairy cooperative with members in New England and upstate New York. This company produces cheese and milk related items and sells in most of the states in USA.

Responsibilities:

  • Created SQL Server Integration packages (SSIS) to export data from flat files (AS/400) to SQL database.
  • Optimized Query Performance and Reliability.
  • Created stored procedures, tables, triggers, and views for data warehouse databases.
  • Created Data Sets and used the data sets for different Reports.
  • Created proper indexes for some tables for better performance of the queries.
  • Designed databases and tables for data warehouse.
  • Created Mapping Excel Spread Sheets for export data between two databases.
  • Created Visio diagrams for some data bases.
  • Exported data from flat files to SQL server using SSIS packages.
  • Created Reports using SQL Server Reporting Services(SSRS).
  • Wrote complex SQL queries for data retrieval.
  • Designed new data bases for Reporting perpose.
  • Created new SSIS packages in place of old DTS packages.
  • Documented the guidelines for SQL programming.
  • Created a report to notify the status of all report subscriptions.

Environment:
Windows Server 2003,Oracle,Cobol,IBM Mainframe, MS SQL Server 2005, VSS, SSIS, T-SQL, MS Excel,, MS Word, SSRS,C#, Sybase, Unix.

Confidential, Nashville,TN Mar 2008 - Jun 2008

Developer

HealthSpring - an independent, Tennessee-based managed care organization. HealthSpring provides a comprehensive portfolio of healthcare benefit plans to employers in Tennessee. HealthSpring is also a Medicare Advantage organization with a Medicare contract, providing plans for Medicare beneficiaries in 27 Tennessee counties.

Responsibilities:

  • Exported data from text file to SQL Server using SQL Server Integration Services.
  • Created Views and Extracted Data from the Views and Modified some Reports also.
  • Cleaned data in the tables and removed some inaccurate records from tables.
  • Configured SSIS packages and created jobs and scheduled jobs using SSIS package store and File System options.
  • Tuning of Stored Procedures and SQL Queries and created some indexes on tables.
  • Loaded Data to Flat Files from SQL server using Integration Services.
  • Created and Scheduling Jobs, Backups and Restore of Databases.
  • Created stored procedures, triggers, views and Functions for front end requirements.
  • Used XML data type in stored procedures.
  • Created new tables and normalized.
  • Created new ad hoc reports and tuned existing reports for best performance.
  • Deployed all the Integration Service Packages on Testing Server and successfully scheduled and run.

Environment:
Windows Server 2003, MS SQL Server 2005, T-SQL, MS Office Access 2003, VSS, SSIS, MS Excel, MS Word, C#, Sybase, DB2,Cobol.

Confidential, Nashville,TN Jul 2007 - Feb 2008

Developer

Deloitte refers to one or more ofDeloitte Touche Tohmatsu, a Swiss Verein, its member firms, and their respective subsidiaries and affiliates. Deloitte Touche Tohmatsu is an organization of member firms around the world devoted to excellence in providing professional services and advice, focused on client service through a global strategy executed locally in nearly 140 countries

Responsibilities:

  • Extracted data from legacy system using SSIS(SQL Server Integration services)
  • Wrote Store procedures to convert data logically as per the business requirement.
  • Created linked servers for multiple legacy systems using ODBC drivers and OLEDB Providers.
  • Transform the data using different components of SQL Server Integration Services.
  • Loaded data into SQL Server using Integration Services.
  • Wrote Triggers on to migrate the data from current system to legacy systems
  • Created database with multiple file systems Interacted with Business Analysts to capture the requirements, analyzed the entire system and prepared the design documents.
  • Created Jobs and scheduled them for Backups and Restore of Databases.
  • Loaded data through bulk inserts from Flat Files using Bulk Insert
  • Analyzed the current OLTP system to interface with legacy OLTP System
  • Created Mapping Spread Sheet to map columns from current OLTP System (Source SQL Server) to legacy OLAP System (Target SQL Server)
  • Converted some crystal reports to SQL Server Reports using SSRS.
  • Wrote Triggers to Invoke Jobs to Transfer real-time data to OLAP.

Environment:
Windows 2000, MS SQL Server 2005, T-SQL, MS Office Access 2003, VSS, MS Reporting Services(SSRS),SISS, MS Excel, Oracle, PL-SQL,ASP.NET.

Confidential, Lexington,KY Apr 2007 to Jun 2007

Developer

Daily Racing Forum (DRF) which is a published newspaper both prints and electronic media specifically designed for the racing industry. Registered users can purchase online products, news etc details from this.

Responsibilities:

  • Developed SSIS packages to export data from OLTP database to OLAP database.
  • DDL Scripts for generating Tables, Views, Functions etc.
  • Using Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.
  • Generated T-SQL scripts for application development.
  • Created cursors and User Defined functions.
  • Created Indexes to speed up the queries.
  • Created Views for Extracting Data.
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
  • Using Bulk Insert to move large data from Text files to SQL Server.
  • Scheduling Jobs, Backups and Restore of Databases.
  • Helped the front end application developers with their queries.
  • Generated SQL reports using MS Reporting Services.
  • Environment: MS SQL Server 2005, MS Outlook, TSQL, VSS, Visio, SQL Server Business Intelligence Development Studio, Informix, DbVisualizer 4.2.2, SSIS, MS Reporting Services(SSRS),C#,MS Access.

Confidential, Hollywood,CA Oct 2006-Mar 2007

Developer
Nielsen EDI provides up-to-the minute box office information around the globe, in real time, on an hourly basis. Nielsen EDI captures box office results from more than 50,000 movie screens across 14 countries including: USA, Canada, Mexico, Argentina, Brazil, Chile, United Kingdom, Ireland, Spain, Germany, Austria, France, Australia, and New Zealand.

Responsibilities

  • Actively involved in different stages of Project Life Cycle.
  • Actively participated in gathering of User Requirement and System Specification.
  • Created new database logical and physical design to fit new business requirement and implemented new design into SQL Server 2000.
  • Successfully migrated old data from legacy system into SQL Server2000 using DTS Packages.
  • Filtered bad data from legacy system using complex T- SQL statements, and implemented various constraint and triggers for data consistency.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
  • Created Reports using SQL Server Reporting Services (SSRS).
  • Wrote complex stored procedures to process drivers record and balanced the processing load between front end and back end.
  • Implemented batch processing for approval process using Jobs and DTS.
  • Created Users and Roles, and managed security and permission of database.
  • Documentation of all the processes involved in maintaining the database for future reference.
  • Actively participated in User Acceptance Testing, and debugging of the system.

Environment: SQL Server 2000, Active x script ,T-SQL, MS Excel, MS Access 2000, Erwin,WindowsNT.

Confidential, India Feb 2004 - Sep 2006

Developer

Aventis Pharmaceuticals is a subsidiary of European drug maker Sanofi-Aventis, develops, manufactures, and markets pharmaceutical products and is one of the largest pharmaceutical companies in the US.


Responsibilities

  • Created Logical & Physical Database modeling for in house development application.
  • Wrote complex stored procedures and cursors to implement various business logics as per the client requirements.
  • Performed Database Design, Data Modeling using Erwin.
  • Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.

Environment: Windows NT 4.0, MS SQL Server 7

Confidential, Hydarabad,India Aug 2003 to Jan 2004

Programmer

The system maintains Room Booking/Cancellation, name and address of the person booking/canceling, Conference room booking, Restaurant table booking, name of the receptionist booking the rooms and the charges for each type of booking. The system also provides information on the employees, their schedule and their job responsibility.

Responsibilities

  • Involved in System Analysis, Designing of Forms, Tables, Reports, Coding, Testing, And Implementation & User Training.
  • Created reports using Crystal Reports.
  • Documented the projects using MS Word.
  • Created tables and databases in MS Access.

Environment: VB 5.0, Crystal Reports, MS Access.

Hire Now