We provide IT Staff Augmentation Services!

Sql Server /ssis/ssrs Developer Resume

Silver Spring, MD

SUMMARY

  • 5+ years of experience as MS SQL Developer in administration and development of Database Design and Development in SQL Server 2012/2008R 2/2008/2005/2000 system in OLTP and OLAP environment.
  • Excellent experience in SSIS , SSAS and SSRS of MS SQL Server.
  • Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
  • In - depth knowledge of T- SQ L, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL .
  • Hands on Experience in Installing, Configuring, and Managing, monitoring and troubleshooting SQL Server 2012/2008R 2/ 2008/2005/2000.
  • Excellent skills in implementing ETL Packages using DTS and SSIS 2012/2008R 2/2008/ 2005.
  • Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS , DTS, Bulk Insert).
  • Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility.
  • Extensive Knowledge in SSAS storage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL .
  • Expert in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012
  • Responsible for data quality testing and leading a team that performs data reconciliation to identify data anomalies.
  • Experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using SSIS and Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Repository Manger) with Strong understanding of OLAP and OLTP Concepts.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical & physical.
  • Expert in designing complex reports writing like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
  • Light Experience in supporting Microsoft Azure systems including SQL Server hosted on Azure Virtual Machine (IaaS) and Azure SQL Databases (DBaaS).
  • Expertise in developing and extending MS SQL Server Analysis Services (SSAS) cubes, data mining models, deploying and processing SSAS objects.
  • Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS).
  • Have basic knowledge on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), Microsoft Azure

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Informatica power center 9x,8x, Visual Studio 2010,2012,2013

Reporting Tools: SQL Server Reporting Services (2008 R2,2012,2014,2016), MS Access, MS Excel

Database: MS SQL Server 2014/2012/2008/2005 , MS Access, SQL, Oracle 11g,12c

Modeling Tools: Microsoft Visio, SQL Diagrams, ERWIN 4.1Programming: T-SQL, PL/SQL, VB.Net, ASP.Net, XML, HTML, C#, C

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS

Operating Systems: Windows 2012/2008 R2/2003/2000 Server (64/32 Bit), Windows 2000 Professional, Windows NT 4.0/3.5. Unix, Linux

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, TriZetto Facet, Citrix, Diagnostic Manager, IBM WebSphere (One Run, CMU), TWS, Service Now, Ultra Edit, One Note, MS Outlook, SOAP UI.

PROFESSIONAL EXPERIENCE

Confidential - Silver Spring, MD

SQL server /SSIS/SSRS Developer

Responsibilities:

  • Used T-SQL to create complex codes/programs for conversion and data testing.
  • Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
  • Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
  • Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2005/2008 and then created reports using this data using SSRS .
  • Used SQL Server Agent to automate the SSIS 2008 package execution.
  • Tested and managed the SSIS 2005 and SSIS 2008 packages and was responsible for its security.
  • Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS ).
  • Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
  • Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
  • Built and implemented high performance ELT (Extraction, Load and Transform) process flows using appropriate ODI (Oracle Data Integrator) components to load packages for data warehousing.
  • Configured and maintained Report Manager and Report Server for SSRS .
  • Identified and added the report parameters and created the reports based on the requirements using SSRS 2008.
  • Work with AWS engineering and support teams to convey partner and customer needs and feedback as input to technology roadmaps.
  • Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Tools: and Technologies: MS SQL Server 2016, Visual Studio 2015, SQL Server Integration Services (SSIS), Data Warehouse, PL/SQL, Windows 10, MS Office, MS Visio, C#, Oracle SQL Developer for Data Modeling, Team Foundation Server (TFS), ERP, CRM software, Widows server 2012, AWS.

Confidential

SQL Server/ SSIS SSRS Developer

Responsibilities:

  • Developed logical and physical database (using ER-win, Normalization, Dimension Modeling and Enterprise Manager).
  • Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
  • Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS ).
  • Used SQL Server Agent to automate the SSIS 2008 package execution.
  • Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
  • Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2005/2008 and then created reports using this data using SSRS .
  • Identified and added the report parameters and created the reports based on the requirements using SSRS 2008.
  • Tested and managed the SSIS 2005 and SSIS 2008 packages and was responsible for its security.
  • Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
  • Performed housekeeping activities of ODI (Oracle Data Integrator) platform, ODS and data flows.
  • Coordinated with Managers, Architects and Analysts to develop new Product Distribution mechanisms, encompassing client-side JavaScript and server-side Java applications development with Oracle as the back-end database.
  • Designed and Implemented the Stored Procedures and Triggers for automating tasks.
  • Maintained all records of project status and followed changes as per control procedures.
  • Worked in a development team to develop integrated ASP .NET applications.
  • Work with AWS engineering and support teams to convey partner and customer needs and feedback as input to technology roadmaps.
  • Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Tools: and Technologies: MS SQL Server 2005/2008, MS Access 2000, Erwin v7.0, AWS, T-SQL, MS-Excel, MS-Access, SQL Server Management Studio, MS SQL Profiler, Oracle 11g,12c, ASP.Net.

Confidential - Bethesda, MD

SQL Server / MSBI Developer

Responsibilities:

  • Data source/element mapping, creating load scripts, identifying and resolving conversion issues.
  • Used T-SQL to create complex codes/programs for conversion and data testing.
  • Scrambling of live data to test data, executing conversion processes.
  • Created various database object like stored procedures, functions, tables and views
  • Created SSIS package to load data from Flat Files, Excel spreadsheet and SQL Server 2008R2 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
  • Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
  • Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
  • Planned, Defined and Designed data based on business requirement and provided documentation.
  • Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
  • Converted the Oracle DB objects to MS SQL Server 2008 DB objects like Tables, Views, and Stored Procedures.
  • Designed the packages in order to extract data from SQL DB, flat files and loaded into database.
  • Designed and implemented Stored Procedures and Triggers for automating tasks.
  • Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

Tools: and Technologies: MS SQL Server 2016, Visual Studio 2015, SQL Server Integration Services (SSIS), Data Warehouse, Oracle 11g, PL/SQL, Windows 10, MS Office, MS Visio, C#, ERwin 9.2 Data Modeling, Share Point, Team Foundation Server (TFS), ERP, CRM software, Widows server 2012.

Hire Now