We provide IT Staff Augmentation Services!

Sr. Etl Ssis/ Data Warehouse Developer Resume

0/5 (Submit Your Rating)

New York, NY

SUMMARY

  • Over all 8+ years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2014/2012/2008.
  • Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
  • Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
  • Expert in creating and using Stored Procedures, Views, User Defined Functions.
  • Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
  • Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
  • Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
  • Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
  • Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV,flat files using connectors, tasks and transformations provided by SSIS.
  • Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.
  • Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
  • Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
  • Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
  • Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Tools: &Packages: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), DTS, Report Builder 9.0.

BI Tools: SSIS, SSAS, SSRS.

Databases: MS SQL Server 2008/2012/2014 , MS Access 2003/2005/2008.

Language: T-SQL, PL/SQL, MDX,C, VB.net, C# (.NET)

Operating Systems: Windows vista/XP/2003/2000, Windows Server 2000/2003/2008 , UNIX.

Application Packages: MS Office Suite, MS Outlook, Windows SharePoint Services.

Data Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. ETL SSIS/ Data Warehouse Developer

Responsibilities:

  • Participated in the full life-cycle development process from definition and design to production delivery.
  • Responsible for requirements gathering, status reporting, creating various metrics, project deliverables.
  • Provided functional and technical development support for comprehensive report development from various data sources.
  • Generated variety of business reports using SQL Server 2008R2 SSRS including matrix report, parameter report, dashboard with charts and drill down function; built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server and SharePoint, built Performance Points Dashboards in SharePoint.
  • Developed basic cubes, reports and dashboards (created reports from report packages with multiple data sources, used calculations and data aggregations, created list and crosstab reports, incorporated charting features, created drill-through reporting) and ensured they were tested in the development and test environments before being moved to production.
  • Produced, maintained, enhanced, and updated technical and non-technical software development program documentation.
  • Built efficient ETL packages with SSIS to fetch, cleanse and transform data from various types of sources.
  • Developed complex T-SQL stored procedure, views and user-defined functions on SQL Server (2008R2 and 2012)
  • Developed, tested, and implemented SSRS reports and dashboard with multi-parameter, chart, drill-down, drill-through, sub-report and interactive sorting capability for admin, accounting, and sales department.
  • Collaborated with other groups (business partners, developers, QAs and production support engineers) in implementation of analytical and technical solutions.
  • Schedule and manage daily / weekly / monthly sales and operational reports based on the business requirements.

Confidential, Jersey City, NJ

SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
  • Troubleshooting performance issues and fine-tuning queries and stored procedures.
  • Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
  • Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
  • Use SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
  • Extensively worked on Data Flow transformations like For each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
  • Scheduling the SSIS packages and Jobs.
  • Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
  • Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
  • Worked on Report Creation from TFS using SQL Server Reporting Services, Excel Reporting from Work Item Query and SharePoint Dashboard.
  • Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2008/2012, IIS, ASP, C#, VB.Net, T-SQL, MDX, Excel, MS access, SSIS 2008/2012, SSRS 2005/2008/2012 , SSAS 2005/2008, TFS, crystal report.

Confidential, VA

SQL/ETL/SSIS/SSRS Developer

Responsibilities:

  • Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
  • Wrote efficient stored procedures for the optimal performance of the system.
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
  • Created indexed views and appropriate indexes to reduce the running time for complex queries.
  • To keep track of data manipulations using Audit functionalities.
  • Generated custom and parameterized reports using SSRS.
  • Created reports that call sub reports in SSRS.
  • Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
  • Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
  • Created several packages in SSIS.
  • Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
  • Used various transformation tasks to create ETL packages for data conversion.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Responsible for rebuilding the indexes and tables as part of performance tuning.
  • Used SQL Server Agent for scheduling jobs and alerts.
  • Performed Query optimization & Performance Tuning.
  • Optimized queries using SQL Profiler and Database engine tuning advisor.

Environment: SQL Server 2005/2008R2 Enterprise Edition, SQL Server Agent, SSIS 2008, SSRS 2008, C#, T-SQL, Windows 2003 Server, XML, MS Excel, MS Access.

Confidential, Franklin Lakes, NJ

SQL/SSIS/SSRS Developer

Responsibilities:

  • Design/Build Extract Transform Load procedures in SQL Server Integration Services.
  • Worked on creating SSIS packages to upgrade SQL Server 2005 to SQL Server 2008.
  • Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality Test Plan which was used by testing team while doing their testing process.
  • Used Oracle, SQL, T-SQL and PL/SQL in test environment.
  • Designed the packages in order to extract data from SQL DB, flat files and loaded into Oracle database.
  • Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
  • Developed user defined financial reports to provide on demand financial data analysis using SSRS.
  • Performed data conversions from flat files into a normalized database structure
  • Developed numerous ad-hoc reports using SSRS for day to day financial reporting.
  • Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
  • Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
  • Involved in design, programming, deploy and Unit Testing of requested Reports.

Environment: SQL Server 2008 Enterprise Edition, SSIS 2008, SSRS 2008, .NET Framework, C#, ASP.NET, CSS, T-SQL, VisualStudio.NET IDE, XML, MS Excel, MS Access, Visual Studio 2008.

Confidential

ETL/ SSIS Developer

Responsibilities:

  • Involved in Migration of SSRS 2005 to SSRS 2008.
  • Created subscriptions in SSRS to deliver reports to a shared file.
  • Implemented logical and physical modeling using ERWIN data modeler
  • Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports using SQL Server Reporting Services 2008
  • Created Triggers, Views for Audit and security purposes.
  • Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
  • Applied conditional formatting in SSRS to highlight key areas in the report data.
  • Involved in migration of crystal reports to SSRS 2008.
  • Created various dynamic reports using SSRS and Crystal reports.
  • Developed T-SQL queries and stored procedures with multiple parameters to created Data Sets for Reports
  • Designed user defined hierarchies in SSAS including parent-child hierarchy.
  • Created mapping tables to find out the missing attributes for the ETL process.
  • Used the row count transformation and event handlers control flow to populate the special Log tables with high level SSIS package execution results
  • Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS)
  • Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc.
  • Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS)
  • Scheduled the SSIS packages to run at different intervals to load the data.
  • Created partitions of the Analysis Services cube to improve performance.
  • Designed reports and tuned them for optimal performance when using multiple Parameters

Environment: SQL Server 2005/2008, T-SQL, SQL Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, ETL, MDX, SQL Profiler, MS Excel 2003.

We'd love your feedback!