We provide IT Staff Augmentation Services!

Ssis, Ssrs And Ms Sql Developer Resume

Orlando, FL

SUMMARY

  • A Microsoft certified Professional with 7+ years of experience in Data modeling, database design, Programming, Development and Implementation of Client - Server Applications & Database systems using MS SQL Server 2012/2008/2005.
  • Extensive experience in Using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading
  • Expert in data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principals
  • Using Normalization and De-Normalization techniques
  • Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using the stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs)
  • Writing heavy stored procedures, Audit triggers views, creating SQL scripts for data loads and Upgrades for data migrations and data validations
  • Proficient in Performance Tuning/Query optimization using indexes
  • Assisted with automation of manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.
  • Tuning the performance of stored procedures and large T-SQL Queries using Clustered indexes, efficient coding standards
  • Involved in Backing up databases and refreshing Data across environments
  • Huge Data transfers from & to SQL Server Databases using utilities/ tools like DTS, SSIS, BCP, Bulk Insert
  • Experienced in whole cycle of DTS/SQL Server Integration services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL purposes across different servers.
  • Involved in usage of various SSIS components like for loop, For-each loop, Fuzzy lookup, Variables, and Error Handling etc.
  • Experience in creating master and child packages, package configurations and logging Using SSIS.
  • Excellent knowledge of using variables and expressions in packages of SSIS.
  • Worked with Flat file, Excel file, and SQL server OLEDB destinations for loading data.
  • Involved in handling Enterprise wide reporting needs using SQL Reporting Services, Crystal Reports.
  • Creating large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2008/2000/2005.
  • Expert in designing reports using SQL Server Reporting Services (SSRS2000/2005), operating and troubleshooting with data sources.
  • Expert in developing and deploying cascadingparameterized, Drilldown, Adhoc reports with linking sub reports in various file formats with respect to client requirement.
  • Experience in writing Queries using SQL Server Analysis Services (SSAS).
  • Created and Configured Data Source &Data Source Views, Dimensions, Cubes, Measures,Partitions.
  • Vital Knowledge in OLAP Storage modes likes Rolap/ Molap/ Holap.
  • Hands on experience in Creating Star Schema and Snow Flake Schemas.
  • Strong experience with Informatica power center (Rep Manager, Power Center Designer, Workflow Manager and Workflow Monitor)
  • Strong experience in designing/developing complex mappings from varied transformations like Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Unconnected and Connected lookup etc.
  • Proficient with Data warehousing concepts like Dimensional Data Modeling, Star Schema, SnowFlake schema, OLTP and OLAP, dimensions and facts
  • Good experience in extracting data from multiple source systems like Oracle, Sql Server, DB2, Flat Files and loading them with business transformation logic to datamarts/data warehouse
  • Expertise in using multiple Informatica transformations like Source Qualifier, Expression, Filter, Router, Rank, Sorter, Aggregator, Joiner, Look up, Update strategy, Sequence Generator etc.
  • Experience in creating mappings with SQL override in Source Qualifier, Indirect loading of multiple Flat files into same target
  • A well-organized, goal-oriented, highly motivated and TEMPeffective team player with excellent analytical, troubleshooting, and problem solving Skills.
  • Excellent Verbal & Written Communication skills and strong in Documentation.
  • Flexible, enthusiastic and project oriented with excellent communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

RDBMS: MSSQL Server 2000/2005/2008/2012, MS ACCESS, Oracle 11g/10g/9i/8i/7.x, Teradata, DB2

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development, Studio, Visual Studio, Configuration Manager, SQL Server Profiler SQL Query Analyzer, SQL Refractor, SQL Server Agent.

ETL Tools: Data Transformation Services (DTS), SSIS, Pervasive Data Integrator, Import/ export wizard, Bulk Insert, BCP, Informatica Power Center 9.5.1/9.1.0 /8. x (8.6.1/8.6.0/8.5.1/8.1.0 )

BI Tools: SSRS, SSAS, Crystal Reports, BIRT, Plateau Report Designer.

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook

Management Tools: SharePoint, Team Foundation Suite (TFS), Microsoft Office Communicator.

Languages: T-SQL, MS SQL, MDX, C/C++, Java, VB, VBA, HTML, XML.

Web Technologies: HTML, DHTML, XML.

O/S: Windows 2008/2003/2000/ NT Servers, XP, Vista, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

SSIS, SSRS and MS SQL Developer

Responsibilities:

  • Understanding the report design Requirements and Constraints.
  • Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
  • Design and implementation of Security Model, Policies and Procedures.
  • Performing query plans and making sure each and every query is using appropriate useful Indexes
  • Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
  • Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
  • Rebuilding Indexes and Tables as part of performance tuning exercise.
  • Deployed the created SSIS packages in Development and Testing environments.
  • Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
  • Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package
  • Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Created Drill-down, Parameterized and Sub-Reports using RDL.
  • Promoted RDLs to Reporting Service Server (SSRS).
  • Created Adhoc reports and data exploration using Power View.
  • Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.
  • Created scorecards with executive summary dashboards using MS Office Performance point server 2007 Dashboard designer dat display performance monitoring measures.
  • Designed and developed Datamart using SSAS.
  • Build Cubes on Enterprise Date Warehouse (EDW).
  • Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
  • Performed DBCC checks and fixing data corruption in Application databases.
  • Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.

Confidential, Ivyland,PA

MS SQL/BI Developer

Responsibilities:

  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Designed the ETL processes using Informatica to load data from Flat Files to target Data Warehouse
  • Involved in creating new table structures and modifying existing tables to fit into the existing Data Model
  • Performed data manipulations using various Transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, Connected and Unconnected Lookup
  • Written SQL overrides in Source Qualifier to push load onto the database for which the source database is same (Coming from same database)
  • Created mappings to load multiple Flat files using Indirect loading
  • Created sessions and workflow for designed mappings
  • Created session link constraints in the workflow based on the business requirements
  • Redesigned some of the existing mappings in the system to meet new functionality
  • Data management and data processing solutions using SSIS, dis includes Error Handling and Slowly Changing Dimensions.
  • Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
  • Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
  • Deploying the Packages and Reports on to the server.
  • Worked on Filtered Views, views and Base table integration between different Source systems.

Environment: SQL Server 2008R2 & 2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel,& Windows 2003 server, Business Intelligent Integration Services (SSIS 2012/2008), Business Intelligence Development Studio (BIDS), MS Office 2007, MS Access, ETL, Performance Point Server 2007, MS Excel, Informatica 9.5.1/9.1.0

Confidential, Broadway, New York

MS SQL Developer

Responsibilities:

  • Created Store Procedures to transform the data and worked extensively in T-SQL for various needs of transformations while loading the data.
  • Written complex SQL queries using joins, subqueries and correlated sub queries to retrieve data and Triggers to carry out various tasks from the database.
  • Involved in performance tuning of T-SQL Queries and focused on index tuning, query optimization and partitioning.
  • Used SQL Server Profiler to trace the slow running queries and the server activity.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Used various SSIS tasks such as Conditional Split, Derived Column, Data Conversion, Fuzzy lookup, merge, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Imported and Exported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
  • Automated the SSIS jobs and email alerts using SQL server agent job for daily, weekly and monthly loads.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008.
  • Used reporting objects like Tabular, Matrix, Sub report, Charts, Parameterized and Cascading parameterized reports using SSRS-2008.
  • Deployed and Published the Created Reports to Microsoft Share Point Server and also uploaded them to Microsoft Performance Point Server.
  • Fixed Back end issues related to the Desktop GUI Screens to help Users.
  • Running Data Scans on Production/ QA Environments as per the requests from SYSOPS.
  • Aware of working with different ticketing workflow systems like JIRA and SRS.
  • Documented the development work.

Environment: Microsoft SQL Server 2008 R2, SSIS, SSRS, SQL Server Profiler, UNIX, Perl, MS Excel, EditPlus, WordPad, PL/SQL, Oracle, CVS, JIRA, SRS

Confidential, Stamford, Connecticut

MS SQL, SSIS, SSAS and SSRS Developer

Responsibilities:

  • Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Views and Queries with best execution plan
  • Used C#.Net, Ado.Net and ASP.Net for writing code to make availability of packages in server at scheduled times.
  • Used multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes Using MDX and ADX.
  • Defined Checkconstraints, Business Rules, Indexes, and Views.
  • Created Alerts for successful or unsuccessful completion of scheduled Jobs.
  • Designed SSIS Package for extracting data from heterogeneous source systems, transform and load into the Staging Data base.
  • Created projects to transfer data from MS Excel to SQL Server in SSIS.
  • Extensively worked in ETL and data integration in developing ETLmappings and scripts.
  • Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into SQL server Database.
  • Created packages using script task, containers to logically execute the SSIS package to improve performance and execution time.
  • Worked on data cleansing techniquesusing look ups, conditional split, and fuzzylookup.
  • Handling the errors during data moving and sequencing the task as per requirements.
  • Created SSIS Packages for Incremental Loading and slowly changing dimensions.
  • Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
  • Identified and worked with Parameters for parameterized reports in SSRS 2005/2008.
  • Developed ReportModels for building Ad hoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.
  • Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration ofSharePoint with SSRS.
  • Generated SSRS Reports involving different features like Reports, Sub-Reports, Drilldown, Drill-Through, Charts, Filters, Multi-valued parameters and linked reports in SSRS.
  • Expertise in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services for analyzing purpose.
  • Running DBCC consistency checks, and fixing data corruption in application databases.

Environment: MS SQL Server 2008 R2, Windows 2003, SQL Server Management Studio, Business Intelligence Development Studio (BIDS) 2008, .Net Framework 3.5, C#, ASP.Net, VBScript, MOSS 2010, Erwin, MS Visual Source Safe, MS-Visual Studio.

Confidential, Tampa, Florida

MS SQL, SSIS, SSAS and SSRS Developer

Responsibilities:

  • Developed ETL Packages and Reports.
  • Created tables,stored procedureswhen required.
  • Worked withT-SQLtocreateTables, Views, Triggers and Stored Procedures.
  • Created complexjoinsand implementedConstraintson tables for maintainingData Integrity.
  • Frequently used to connect to the health care data marts at different locations using C#.Net and ADO.Net for scheduling jobs.
  • Designed and developed custom .NET components and user controls using ASP.NET
  • Wrote VB Scripts to create custom SSIS transformations, in addition to using built-in SSIS transformations.
  • Involved in creating high levelETLarchitecture for overall data transfer toOLTP, ODSwith the help ofSQL Server 2005, 2008Integration services.
  • Involved inrelational database modelinglike, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
  • Worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis,file-transfersfrom one location to other.
  • Created complex SSIS packages using appropriatecontrol and data flow elementswithSSIS Standards likeerror handling, loggingand working withpackage config files.
  • Exporting the database from Local server to the remote server and importing the current running database from remote server to thelocal DB Server using SSIS.
  • Created Tablix reports, Tabular/Matrix reports based on requirements.
  • Created Dashboards using SSRS.
  • Reduced the overallETL time bySQL Query performanceTuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
  • Created databases, tables, and fields for data entry,performingdatabase capacity planning.
  • Enhanced anddeployed the SSIS packagesfrom development server to production server andscheduled jobs.
  • Supported the production team when issues rose in the packages.

Environment: SQL Server 2005/2008, ORACLE 10g, MS Access, EXCEL, VBScript, HTML, XML, Visio, Windows Server 2000/2003, ASP.NET, VB.NET, BIDS 2005/2008,Visual Studio 2005/2008

Confidential 

MS SQL Server Developer

Responsibilities:

  • Created ER diagrams either Logical/Physical using Erwin.
  • Assisted in database design, creation of ER diagrams, phasing from development to QA and to production environment.
  • Created user based databases and installed MS SQL Server 2005.
  • Worked in Project planning, Designing & Implementation.
  • Involved in creating tables, views, stored procedures, triggers, and cursors and other SQL joins and statements for applications.
  • Wrote the stored procedures, checking the code for efficiency with routine backups and restoration. Data transfers between various servers using BCP.
  • Defined and created indexes for query optimization and revising scripts for optimal performance.
  • Used data transformation services (DTS) to populate data from various data sources using the concept of OLE DB.
  • Installed SQL Server service packs based on the errors and flaws dat are found in the application.
  • Tested the stored procedures performance and its path of execution by using SQL profiler.
  • Recovered the backups of SQL Server production databases in test server environment.

Environment: MS SQL Server 2000/2005, Windows 2000 Advanced Server, VB 6.0, and XML.

Hire Now