We provide IT Staff Augmentation Services!

Sql Server Tsql/ssis Resume

Roseland, NJ

PROFESSIONAL SUMMARY:

  • Highly motivated, Result - driven IT Professional with over 8 years of experience in Database Development, Design, System Analysis and Support of MS SQL Server 2012/2008R 2/2008/2005/2000 , and Oracle i8/i9/10g and Data Warehousing, Business Intelligence applications design, development and Maintenance of DTS/SSIS,SSRS and SSAS
  • Expert in all areas of SQL Server development including T-SQL Queries, Stored Procedures, User-defined Functions, Views, Triggers, Case expressions, Cursors, T-SQL relational database models and data integrity
  • Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes using DDL, DML, DCL commands
  • Deep knowledge of different Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools
  • Hands on in error handling and debugging coding issues and troubleshooting of production problems
  • Highly qualified in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE, Table Variables and strong knowledge of SDLC principles
  • Skilled in performing data transfers between different heterogeneous systems (Excel, MS Access, Flat Files, XML file & Oracle) and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks
  • Professional in usage of SSIS Control Flow items(for each Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Union all)
  • Expertise in creating and managing Package Configurations, Logging system, Package deployment and User-defined Variables for SSIS 2012/2008R2/2008/2005
  • Working experience with front end and back end products.
  • High-skilled in writing Parametrized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2012/2008R2/2008/2005
  • Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS) 2012/2008R2/2008/2005
  • Advanced Excel skills, using formulas as index, match, lookup, pivot, creating pivot report, using VBA and Macros.
  • Proficient in performing DBA tasks including installing and configuring SQL servers and backups/restore and recovery of databases
  • Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
  • Good knowledge in ASP.NET, C#, Biz-Talk integration features, WebFocus BI tools, MS Share point 2010, Micro-Strategy Reporting Services
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and quick learner.

BUSINESS SKILLS / TECHNICAL SKILLS: MS SQL Server 2012/2008R 2/2008/2005/2000 , Visual studio 2010/2008 (SSAS/SSIS/SSRS), RDBMS, Oracle, DB2, Microsoft Access 2007/2003,, Windows Server 2003, Windows Server 2008/2005, ASP.Net Frame Work 2.0, C#, Microsoft Excel, Outlook, MS SQL Profiler, SQL server Query Analyzer, Index Tuning Wizard, SQL Log Explorer, Crystal reports, Cognos, Biz Talk, Erwin8/7.3/3.5,Windows 2007/2005 Advanced Server/Professional, TFC, HTML, ISS, XML, Share Point, My SQL.

PROJECTS SUMMARY:

Confidential, Roseland, NJ

SQL Server TSQL/SSIS

Responsibilities:

  • Worked with Business architect to determine logic for the new data warehouse, and for integration process.
  • Created model for data warehouse created and wrote DDL scripts for different database objects as tables, stored procedures, triggers and user defined functions.
  • Designed SSIS packages for transient and persistent staging area, to extract data from SAP and different applications, from excel files and flat files using for each loop container, sequence container, and tasks such as execute SQL task, look up, merge, merge join, unpivot etc.
  • Designed and implemented logic for loading data to the dimension and fact tables.
  • Wrote complex TSQL/PL SQL queries to get data from different sources and test results with expected results.
  • Implemented performance tuning for slow running packages, using execution plan and SQL Server Profiler. Implemented parallelism in SSIS.
  • Generated and optimized already existing views to enhance performance for creating reports and SSAS cubes.
  • Used different data transformations such as Derived column, Conditional split, Multicast, Slowly changed dimension etc.
  • Implemented special logic for late arriving dimension records.
  • Created parameter tables and inserted parameters for each package which is used to retrieve information about package on run time enabling packages work dynamically.
  • Utilized SQL Server table configurations and environment variables to dynamically run packages.
  • Executed event handler and error handler mechanisms in SSIS and wrote C# code to retrieve customized information about error if package fails and insert useful information to the audit log tables.
  • Worked with SQL Server Job Agent to schedule packages, run and monitor them.
  • Used Team Foundation Server to keep track of new crated SSIS packages, and to modify and update existing packages when it is necessary.

Tools &Technologies: MS SQL Server 2012, T-SQL, SQL server Integration service 2012, SQL Server Reporting Service 2012, Erwin7.3, SQL Profiler, C#, SSAS.

Confidential, Charlotte NC

SQL Server TSQL/SSIS/SSRS

Responsibilities:

  • Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
  • Involved in work with data modeler in order to improve existing data model, developing logical model and implementing requirements on SQL Server 2012
  • Developed various T-SQL stored procedures, triggers, views and adding/changing tables to perform data load, transformation and extraction.
  • Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries, fix bugs, and tuning the performance during assurance tests and fix defects raised during testing.
  • Accountable for Backup and Recovery Strategy and Planning.
  • Created SSIS packages with different data sources (SQL Server, CSV, SAP, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.
  • Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
  • Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
  • Use Packages by testing and Cleaning the Standardized Data by using tools in Data
  • Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing and new packages.
  • Involved in scheduling SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
  • Logged various packages as well as individual tasks using SQL server log providers like text file, SQL server database, trace file, xml file.
  • Used Team Foundation Server 2010 in order to manage version difference of SSIS packages.
  • Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
  • Created parameterized, drill down, dashboard and aggregation reports in MS SQL environment using SSRS 2012.
  • Generated daily, weekly and monthly reports for the managers.
  • Used sub reports functionality for complex report calculations.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
  • Responsible for database performance using normalization and application tuning.
  • Documentation for all kinds of reports and SSIS packages.

Tools &Technologies: MS SQL Server 2012, T-SQL, SQL server Integration service 2012, SQL server reporting service 2012, Erwin7.3,Query Analyzer, Index Tuning wizard, SQL Profiler Windows server 2003.

Confidential, Los Angeles, CA

SQL Server TSQL/SSIS Developer

Responsibilities:

  • Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
  • Occupied in Logical, Physical design and Development of the DSR (Data Staging Repository) for the Database and AMS (Asset Management Reporting System) using Erwin.
  • Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
  • Transformed complex business logic into Database design and maintaining it by using schema objects like Tables, Views, Stored Procedures, and User Defined Functions.
  • Successfully implemented indexes on tables for optimum performance.
  • Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases.
  • Migrated data from SAS environment to SQL Server 2008R2 with SQL Server Integrated Services (SSIS).
  • Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
  • Applied ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
  • Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, CSV, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.
  • Experienced in creating package dynamics by using SSIS expressions and variables.
  • Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
  • Performed Documentation for all kind of SSIS packages.
  • Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS.

Tools &Technologies: T-SQL, MS SQL Server Integration Services 2008R2, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio, Erwin, Windows XP, MS Office 2007/2010, MS Access.

Confidential, Louis, MO

SQL Server T-SQL Developer /SSRS/DBA

Responsibilities:

  • Extensively used SQL server reporting services to generate reports on a weekly basis for a particular sales type in a given period.
  • Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
  • Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
  • Created reports using Global Variables, Expressions and Functions using SSRS 2008.
  • Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
  • Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
  • Wrote T-SQL queries, created dynamic Stored Procedures by using input values.
  • Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
  • Applied monthly patches and hot fixes.
  • Created Alerts for successful and unsuccessful completion of Scheduled Jobs.
  • Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008..
  • Designed and implemented Stored Procedures and Triggers for automating tasks.
  • Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.
  • Scripting entire DB using PowerShell, and RedGate tools.
  • Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
  • Ensured best practices are applied and integrity of data is maintained through security and documentation.
  • Using ETL to build the required data mart.
  • Generated Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.

Project Environment: MS SQL server 2008, SSRS, SQL Profiler and T-SQL, Windows 2003 server, and Visual Studio 2008, Microsoft Office, Index Tuning Wizard, Query Analyzer, SQL profiler.

PNC Financial Services Group Pittsburg, PA

MS SQL Developer/ SSRS, SSIS, SSAS Developer

Responsibilities:

  • Gathered user requirements to develop the business logic and analyzed and designed database solutions.
  • Identified data source and data views for building the OLAP cube in SSAS.
  • Defined measures, dimensions and attributes for building the cube in SSAS.
  • Identified and defined Fact relationships, calculated members while designing OLAP cubes in SSAS.
  • Created OLAP cubes using SSAS to analyze the business condition of the sales.
  • Wrote complex queries for the drill down reports and used conditional formatting using SSRS.
  • Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
  • Created Parameterized, matrix and drill down reports using SSRS 2005.
  • Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS 2005.
  • Formatted reports for various Output formats as requested by the management using SSRS.
  • Actively supported business users for changes in reports as and when required using SSRS.
  • Analyzed reports and fixed bugs in stored procedures using SSRS.
  • Used complex expressions to group data, filter and parameterize reports.
  • Created linked reports and managed snapshots using SSRS.
  • Performed various calculations using complex expressions in the reports and created report models.
  • Designed and optimized indexes, views, stored procedures and functions using T-SQL
  • Helped designing and implementing processes for deploying, upgrading, managing, archiving and extracting data for reporting.
  • Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
  • Deployed the generated reports created using SSRS 2005 on to the server.
  • Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
  • Created Alerts for successful and unsuccessful completion of Scheduled Jobs.

Environment: MS SQL Server 2005, MS Analysis Services 2005,MS SQL Reporting Services, T- SQL, Crystal Reports, Windows XP, Query analyzer, SQL Profiler, MS Excel.

Confidential, Chantilly, VA

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

  • Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model using ERwin Data Modeler.
  • Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
  • Worked Extensively with MS SQL Server Integration Services (SSIS) to import, export and transform the data between the linked servers.
  • Created packages using MS SQL Server Integration Services (SSIS) for data extraction from Flat Files, Excel files, OLEDB source to data warehouse.
  • Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in SQL Server Reporting Services 2005.
  • Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
  • Used BCP utility and Bulk Insert to load data from different data sources to SQL Server.
  • Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
  • Managed users including creation/alteration, grant of system/database roles and permission on various database objects.
  • Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them.

Tools and Technologies: MS SQL Server 2005, Windows Server, Windows NT, Erwin, Crystal Reports

Confidential

SQL Server Developer/ SSIS Developer

Responsibilities:

  • Interacted with business users and analysts and gathered and documented the technical and business metadata.
  • Designed database, tables and views structure for the new data mart.
  • Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2005 using SSIS Packages.
  • Generated ETL packages with different data sources (SQL Server, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.
  • Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
  • Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
  • Created complex stored procedures and functions for integrity checks of transferred data.
  • Performed unit testing and SQL performance tuning.
  • Helped provide end users with the ability to access and utilize the data stored in the data mart.
  • Tuned SQL statements Using Indexes and stored procedures.
  • Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
  • Involved in implementation and maintenance of disaster recovery solutions such as replication and log shipping.

Tools & Technologies: SQL Server 2005,SSIS, Windows 2003 server, MS Access, Excel

Hire Now