We provide IT Staff Augmentation Services!

Sql Ssis/ssrs Developer Resume

Dallas, TX

SUMMARY

  • 8+ Years of Professional experience in Data Design and Development as MS SQLBI Server 2012/2008R2/2008 and 2005 database developer, design, creation, maintenance and implementation of project requirements for Data Modeling and Data Management.
  • Proficient in writing SQL queries, stored procedures, database triggers, exception handlers, SSIS Export & Import.
  • Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 20012/2008R 2/2008/2005.
  • Experience in creating and maintaining Database objects in SQL SERVER 2012/2008 in SQL Server Management Studio.
  • Worked on OLAP Data warehouse, Model, Design, and Implementation.
  • Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
  • ETL expertise in using tools like DTS/SSIS, Bulk Insert, BCP and creating
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, XML, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
  • Experience in solving Real Time issues with Index fragmentation, Query Tuning, Error and Event Handling.
  • Worked with Team Foundation Server, Perforce as the source for version control and project/issue management.
  • Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Experience in implementation and support of SQL Server Database Systems, Reporting Services (SSRS), and Integration Services (SSIS) and drill down reports, partitioned views and large data sets.
  • Experience in performing back - up/recovery, running Database Consistency Checks using DBCC, implementing security, and configuring replication.
  • Experience in creating Reports from Web Services and used MDX on Cubes to create reports in SSRS.
  • Perform unit testing Confidential various levels of the ETL.
  • Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Dashboards, Performance Point Server (2007/2008) version and WINTEL.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
  • Experience in implementing all types of Replication Models like Snapshot, Merge and Transactional and in Database Backup, Recovery and Disaster Recovery procedure.
  • Experience in planning and implementing MS SQL server security and database permissions.
  • Experience in generating reports using SQL Server Reporting Services, and MS Excel spreadsheets.
  • Experience in investigating and applying necessary SQL Server database service packs and patches.
  • Proficient knowledge of writing, modifying and implementing Stored Procedures, functions, views, & Triggers.
  • Good knowledge of System Development Life Cycle (SDLC)

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server 2008,SQL Server 2005 Management Studio, DTS, Informatica, Teradata, SSIS, SSRS, SSAS.

Database: MS SQL Server 2012, 2008, 2005, 2000, 7.0, MS-Access.

Languages: T-SQL, PLSQL, SQL, XML, Java, C, C++.

Operating System: Windows 8/7/Vista/XP/NT/2000, DOS, Windows Server 2003.

Tools: Microsoft Visual Studio 2008/2005,Share Point Server 2007, Microsoft Project Server 2007, ProClarity, QTP

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP, DBCC

Reporting Tools: SSRS (SQL Server Reporting Services)

ETL Tools: SSIS (SQL Server Integration Services), DTS

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL SSIS/SSRS Developer

Responsibilities:

  • Gathered reporting requirements from different business units, participated in weekly IT status update meetings and Facilitate Meetings.
  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Involved in dimension modeling of the data warehouse and data marts.
  • Responsible for database design and creation of tables, views and functions.
  • Developed custom reports using SSRS/SQL Server BI studio.
  • Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
  • Provide database coding support to application development team.
  • Extract Transform Load (ETL) development using SQL 2012/2008 Integration Services (SSIS).
  • Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views
  • Used Sub queries, joins, CTE’s and Analytical functions for data retrieval.
  • Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables
  • Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
  • Used Script task in SSIS to write custom code using Vb.net and C#.
  • Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily, weekly and monthly. Solved the issues associated with ETL Data Warehouse Failure.
  • Designed, Managed and published various reports using SQL Server Reporting Services 2012.
  • Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, List items, Charts and Linked reports.
  • Created new SSIS packages for Extracting data using Sequence Container, For Each loop Container, Execute SQL Task, Merge Transformation etc,.
  • Designed reports using table filters, single value parameters, multi value parameters, and Cascading Parameters.
  • Involved in complete cycle from Extraction, Transformation and Loading of data using Informatica and Teradata.
  • Created nested Grouping, sorting columns and writing expressions according to the business requirements.
  • Build different types of chart reports using SSRS like column chart and Pie charts.
  • Created sub reports and pass through parameters from main report to the sub reports.
  • Deploying and Scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
  • Involved in migration and Conversion of Reports from SSRS .
  • Extensively used Informatica to extract wide range of data from different sources like flat files, Excel spreadsheets, Oracle, Teradata into SQL server databases.
  • Involved in creating, structuring, formatting using Report Designer and Report Builder.
  • Deployed and managed reports on Share point server.
  • Responsible for smooth On shore - Offshore Coordination and managed a team of 5 offshore developers.

Environment: MS SQL Server 2012/2008/2005 , MS SQL SSRS, SSIS, T-SQL, Informatica, Teradata, Oracle 11g.

Confidential, Newark, Delaware

MS SQL Server SSIS/SSRS/BI Developer

Responsibilities:

  • Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs
  • Wxrote multiple stored procedures and other database objects handling complex business logic and effective xperformance.
  • Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources.
  • Building UAT and Test environments using Production backups.
  • Designed cubes with star schema using SQL Server Analysis Services (SSAS).
  • Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
  • Created SQL server Analysis Projects using MS SQL Server 2008.
  • Created the Cubes and Dimensions.
  • Defined relationships between Measure groups and Dimensions.
  • Defined granularity with in a measure group and drill through actions.
  • Querying and manipulating multidimensional cube data through MDX Scripting.
  • Created report models using the report model designer to support Ad hoc reporting.
  • Scheduling the SSIS packages and Jobs.
  • Created SSIS Packages to migrate slowly changing dimensions
  • Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
  • Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
  • Scheduled Reports based on a particular Day and sent them through Email in required format (Excel, PDF, etc.)
  • Created technical designs and user documentation.
  • Managed the day-to-day activities to ensure the completion of deliverables on time by providing a weekly status report on progress made.
  • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
  • Creating some scorecards and Dash Board Reports Using SSRS 2008.

Environment: SQL Server 2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, CSV, Excel, XML.

Confidential, Malvern, PA

MS SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

  • Generated database SQL scripts and deployed databases including installation and configuration.
  • Created and developed stored procedures and triggers to handle complex business rules, history data and audit analysis.
  • Filtered bad and inconsistent data using complex T-SQL statements and implemented various constraints and triggers to maintain data consistency.
  • Used SQL script to find heavily fragmented indexes and have re-organized the indexes accordingly to get desired performance from the tables.
  • Created insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
  • Used joins and sub-queries to simplify complex queries involving multiple tables.
  • Migrated data from heterogeneous data sources and legacy systems to a centralized SQL Server using SQL Server Integration Services (SSIS) to overcome transformation constraints.
  • Implemented Error handlers and Event handlers in SSIS packages.
  • Created packages to validate, extract, transform and load data to centralize SQL Server using OLEDB providers from the existing diversified data sources.
  • Maintained databases, performed software installation and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check using DBCC commands.
  • Generated daily and weekly monthly reports involving customized and on-demand reports using SSRS and also involved in analyzing multi-dimensional reports in SSRS.
  • Formatted tables with global variables and expressions in order to meet the business analyst's requirement to analyze the data.
  • Involved in applying row level security to a few confidential reports and giving permissions to a list of specified delegates to access such reports.
  • Involved in improving the performance of SQL Server by designing efficient schemas, fine-tuning of indexes and avoiding scalability pitfalls while using SQL XML.
  • Experienced in designing efficient schemas by separating OLAP and OLTP workloads and by devoting appropriate resources in building the schemas.
  • Responsible for query optimization using MS SQL tools like Query Optimizer, SQL Profiler, Index Tuning wizard.
  • Environment: MS SQL Server 2005/2008, MS SQL Server Integration Services, MS SQL Server Reporting Services, SQL Server Agent, SQL Enterprise Manager, OLAP, OLTP, XML, T-SQL.

Confidential, Boston, MA

MS SQL BI Developer

Responsibilities:

  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
  • Converted ETL from DTS to SSIS.
  • Extensively used T-SQL to manipulate and architect to produce results for users.
  • Worked with development teams in the design of physical databases and in modification.
  • Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
  • Successfully migrated SSIS packages from development to test to Production environments using SSIS Configuration files and deployment wizard.
  • Created SSIS process design architecting the flow of data from various sources to target.
  • Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
  • Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
  • Actively engaged in client meetings in requirement gathering and development updates.
  • Developed SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
  • Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
  • Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
  • Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: MS SQL Server 2005/2008, Windows 2003/2008, SSIS, SQL Server, Management Studio, SQL Server Business Intelligence studio, Microsoft Excel and Access.

Confidential

SQL BI Developer (SSIS/SSRS)

Responsibilities:

  • Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
  • Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
  • Perform unit testing Confidential various levels of the ETL.
  • Worked on Migration of packages from DTS using SQL Server Integration Service (SSRS).
  • Generating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
  • Involved in Report writing according to business requirement using SSRS.
  • Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
  • Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
  • Designed and created the table schema and stored procedures that will be used in Data QC.
  • Designed and developed the Data QC Maintenance website that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file.
  • Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
  • Responsible for documentation of system related activities.
  • Setup replication within the SQL databases.
  • Provides technical documentation of the system
  • Setup the database with suitable memory and hard disk space allocation, creating different user and security profiles for the team.

Environment: SQL Server 2005/2008, MS Access, SSRS, SSIS, T-SQL, ASP.NET2.0, C# .NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007.

Hire Now