Sql Ssrs/ssis Developer Resume
Birmingham, AL
PROFESSIONAL SUMMARY:
- Skilled software professional around Seven (7) years of IT industry experience with Microsoft SQL Server, Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS) environments.
- Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server.
- Experienced using T - SQL in SQL Server platform.
- Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, effective functions, Cursors and Indexes using T-SQL.
- Efficient in using Inner, Outer and Cross Joins, sub-queries for complex queries involving multiple tables.
- Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
- Well versed in Normalization/ De-Normalization techniques for optimum performance in relational and dimensional database environments and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
- Hands on experience in performance tuning, query optimization, and database optimization.
- Expertise in solving dead Locks/Long running queries using Performance Monitor and SQL Profiler.
- Experience in using Try Catch block introduced in SQL Server 2005.
- Good knowledge in using system tables such as sys indexes, sys processes, and sys objects and sys comment in various queries and using Database Console Commands (DBCC).
- Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
- Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
- Experience in data migration from Oracle/Access/Excel Sheets/Flat Files to SQL Server databases.
- Migration experience with DTS to SSIS 2005.
- Well-versed in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, Send mail task, For loop container, For each loop container, Sequence container) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Merge, Multi cast, Derived column, Character map, Union all, Sort, Row count, OLEDB command).
- VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package.
- Experience in enhancing and deploying SSIS Packages from development server to production server.
- Experience in creating SSIS packages using Active X scripts and with Error Handling.
- Created Crystal Reports on daily, weekly and monthly basis for manager’s review.
- Strong experience in developing parameterized, drill down, click through, chart, matrix, Ad-Hoc, sub reports using SSRS 2005/2008 using data from a variety of sources.
- Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008.
- Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
- Experience in Designing and Building the Dimensions and cubes with star and Snowflake schemas using SQL Server Analysis Services (SSAS).
- Experience in creating the MDX queries to access cubes and dimensions (SSAS).
- Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
- Worked on OLAP Data warehouse, Model, Design, and Implementation.
- Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users, App Dev and Information architects to make sure all the requirements are fully covered
TECHNICAL SKILLS:
Databases: MS SQL Server 2008/2005/2000/7.0, Oracle, MS-Access 2000/2003
Programming Languages: T-SQL, C, C++, C#, PL/SQL, XML, HTML, VB .NET, Visual Basic 6.0
Operating Systems: Windows Server 2003, Windows XP/ 2000/ 95/ NT, Linux, UNIX
SQL Server Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Server Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, Import & Export, Visual Studio Net
ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services(DTS)
OLAP/ Reporting Tools: SQL Server Analysis Services (SSAS), SQL Server Reporting services (SSRS), Crystal Reports
PROFESSIONAL EXPERIENCE:
Confidential, Birmingham, AL
SQL SSRS/SSIS Developer
Responsibilities:
- Regularly communicating with business users and managers to gather the requirements for business needs.
- Analyzed the functional specs provided by the business users and created technical specification documents.
- Developed Dynamic Packages Using Variables and Configuration Files.
- Loaded data from multiples sources like Excel, oracle, flat files into SQL server.
- Loaded data from SQL server to flat and excel files.
- Worked on Dataflow Transformation like derived column, data transformation, character map and other data flow transformations.
- Used expressions in SSIS packages passing variables dynamically and getting data.
- Experienced in slowly changing dimension in SSIS packages.
- Created and tuned Event Handlers, Checkpoints and logging to maintain active SSIS packages.
- Deployed packages into SQL Server
- Created SSIS Packages by using advanced tools (i.e. Lookup, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
- Created jobs and scheduled jobs for SSIS packages and Stored procedures.
- Developed stored procedures for loading data with open queries into SQL Server.
- Involved in the data conversion process from legacy systems into SQL server.
- Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
- Created/modified Tables, Stored Procedures for Application Developers and some User Defined Functions.
- Created Cross-Tab, Drill-down, Drill-thru and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
- Involved in testing the process how the data is loaded and how the reports are representing data accurately.
- Involved in clearing the issues in the production.
ENVIRONMENT: SQL Server 2008,2008 R2,2012, T-SQL, MS Excel, MS Access, Visual Studio 2008, 2012, VB.net, ASP. Net, MS SSIS, MS Reporting Services (SSRS), Windows 2008 Server.
Confidential, Warsaw, IN
SQL SSRS/SSIS Developer
Responsibilities:
- Involved in creating functional and technical specification documents after gathering requirements from business users.
- Created database objects like tables, views, stored procedures, functions, joins, indexes and triggers in T-SQL based upon the functional specifications.
- Reviewed the existing stored procedures and improved efficiency by critically evaluating the code and optimized.
- Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex Business rules.
- Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, and flat files and load it to the destination database after using multiple transformations.
- Involved in Data Integration by identifying the information needs within and across functional areas worked various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task, For each loop container.
- Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
- Deployed SSIS package on the server and scheduled the packages using SQL Server Agent Services.
- Involved in populating data on various systems, generating data reports using Reporting Services (SSRS) and deploying them on the server.
- Designed and developed different reports like Matrix and Tabular reports with Top N, Cascaded, Parameterized, and pie chart reports using SSRS.
- Expertise in developing Ad-Hoc, Drill-down, Drill through reports using Local and Global Variables, Expressions and Filters in SQL Server Reporting Services (SSRS).
- Involved in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
- Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
- Design and development of Business Intelligence Solutions using Informatica, Business Objects, Cognos and Erwin.
Environment: MS SQL Server 2005/2008, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Windows 2003, MS Access, Report builder3.0, EXCEL, SQL Server Profiler, DTS, ASP.NET.
Confidential, Phoenix, AZ
SQL SSRS/SSIS Developer
Responsibilities:
- Regularly communicating with business users and managers to gather the requirements for business needs.
- Analyzed the functional specs provided by the business users and created technical specification documents.
- Developed Dynamic Packages Using Variables and Configuration Files.
- Loaded data from multiples sources like Excel, oracle, flat files into SQL server.
- Loaded data from SQL server to flat and excel files.
- Worked on Dataflow Transformation like derived column, data transformation, character map and other data flow transformations.
- Used expressions in SSIS packages passing variables dynamically and getting data.
- Experienced in slowly changing dimension in SSIS packages.
- Created and tuned Event Handlers, Checkpoints and logging to maintain active SSIS packages.
- Deployed packages into SQL server.
- Created SSIS Packages by using advanced tools (i.e. Lookup, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
- Created jobs and Scheduled jobs for SSIS packages and Stored procedures.
- Developed store procedures for loading data with open queries into SQL Server.
- Involved in the data conversion process from legacy systems into SQL server.
- Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
- Created/modified Tables, Stored Procedures for Application Developers and some User Defined Functions.
- Created Cross-Tab, Drill-down, Drill-thru and Sub-Report using SSRS
- Involved in testing the process how the data is loaded and how the reports are representing data accurately.
- Involved in clearing the issues in the production.
Environment: SQL Server 2008,2008 R2,2012, T-SQL, MS Excel, MS Access, Visual Studio 2008, 2012, MS SSIS, MS Reporting Services (SSRS), Windows 2008 Server.
Confidential, Tempe - AZ
SQL Server Developer/SSIS/SSRS/SSAS
Responsibilities:
- Created Database objects like Stored Procedures, Triggers, Cursors, Indexes, functions, views.
- Performed Index tuning for tables and used Scan and Seeks for performance tuning.
- Designed SSIS Package for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
- Created dataflow and its relational models in MS Visio.
- Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, guided team for the transformations.
- Performed data cleansing techniques using look ups, conditional splits, did data profiling.
- Migrated DTS packages of SQL Server 2000 to SQL Server 2005 to make them reused in new environment.
- Created SSIS package to fulfill the SQL Server maintenance tasks including rebuilding index, backing up database and updating statistics.
- Created packages with several Transformations in each Package making sure that the data is cleaned and confirmed before being sent to the Staging Area.
- Created event handlers on every executable in an SSIS package.
- Documented Processing times for each Module, developed Test Cases and used them to run through each Process.
- Database Design (Relational and Dimensional models) using Erwin .
- Updated existing and created new reports using SQL Server Reporting Services.
- Built SSRS project to generate reports with desired formats (Word, PDF, Excel and etc) to present statistics information according to business requirement.
- Generated various reporting services RDL’S using reporting services for Account Aggregation reports. Identified and defined Fact relationships in SSAS for OLAP cubes.
- Created ad-hoc reports using Report Builder to provide a template for end-users for creating reports by themselves with preselected group of relational tables.
- Involved in full life cycle development of data mart and supported the existing BI platform for populating the data warehouse.
- Created perspectives, partitions, drill through actions and KPIs to enhance Cube’s utilization.
Evironment: MS SQL Server 2000/2005/2008, SSIS/SSAS/SSRS, MS Access, Windows NT, Windows XP/ 2003/2000/98, MS SQL, ERWIN 7.0X, SQL Profiler, SQL Query Analyzer, T-SQL, MS SQL Server Integration Services 2008/2005, MS Office.
Confidential, New Jersey
SQL ETL Developer/SSIS/SSRS/SSAS
Responsibilities:
- Created various Table and Views, wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for application.
- Transformed the complex business logic and calculations into coding. Created and updated clustered and non-clustered indexes to keep up the SQL Server performance.
- Implemented T-SQL features like Error handling through TRY-CATCH statement, Common Table Expression (CTE).
- Transformed data from various data sources like MS Access, MS Excel, and Oracle using OLE DB connection by creating various ETL packages.
- Created packages in SSIS with error handling as well as created complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
- Involved in extracting the data using SSIS from OLTP to OLAP.
- Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
- Experienced with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
- Created List reports, Standardized Reports, On-Demand Reports, Cross tabs Reports, Drill-down Reports, Ad hoc Reports, Charts, Functions and Formulas.
Environment: SQL Server 2008/2005, Enterprise Edition, SSAS, SSIS, SSRS, T-SQL, MS Office 2003/2007, Share point Server 2007 (MOSS), T-SQL.
Confidential
MS SQL Server Developer
Responsibilities:
- Installed and configured SQL Server7.0 Servers and clients.
- Designed and developed the databases.
- Created a logical design and physical design of the data warehouse using star schema.
- Configured the DTS packages to run in periodic intervals.
- Extensively worked with DTS to load the data from source systems.
- Writing stored procedures and triggers extensively and working very closely with developers, Business
- Analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
- Created FTP connections, database connections for the sources and targets.
- Maintained security and data integrity of the database.
- Creating Logins and Roles with appropriate permissions.
- Prepared and documented Backup & Restore Plans.
Environment: Windows XP, SQL Server Business Intelligence, SSRS, T-SQL, MS Visual Studio 2005, Report builder.