We provide IT Staff Augmentation Services!

Ssis/ssrs Technical Lead Developer Resume

Long Island, NY

SUMMARY:

  • Over 8 years of extensive work experience as a SQL Server Developer and in depth proficient experience in OLTP, Operational Data Source (ODS), and Dimension Modeling, Performance Tuning, Data warehouse, OLAP and Database technologies.
  • Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS in BIDS.
  • Experience in installation, upgrade and configuration of Microsoft SQL Server databases.
  • Over 5 years of extensive experience in T - SQL Programming in developing Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) XML and Complex Queries on SQL Server 2005/2008/2012.
  • Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
  • Over 3 year’s Strong experience in SSRS development skills, experience including tablix, Matrix, chart, graphic score card reports, sub-reports.
  • Over 4 year’s experience in utilizing ETL tools, including SSIS, DTS and ETL Package design.
  • Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
  • Over 3 year’s experience in SSAS (SQL Server Analysis Services) 2005/2008/2012.
  • Experience in some basic development of coding in VB.NET, C# while working with SSIS.

TECHNICAL SKILLS:

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS

Database: MS SQL Server 2012, 2008R2, 2008, 2005, Oracle, SAP, Siebel, Microsoft Office 2007/2003, MS-Access.

Language: C, C++, XML,TSQL,VB.NET,C#

Operating System: Windows XP/NT/ 2000/2003/2008 , DOS

Tools: Erwin Data Modeler, MS Visio, Business Objects, Crystal Reports 10,Microsoft office 2003/2007, LANDesk

Architecture: Relational DBMS, Client-Server Architecture, OLAP, MOLAP, ROLAP, HOLAP,OLTP

PROFESSIONAL EXPERIENCE:

Confidential, Long Island, NY

SSIS/SSRS Technical Lead Developer

Responsibilities:

  • Assisted with the design, implementation & support a multi-terabyte point-of-sale Data warehouse, performing Database design, implementation, creation & tuning of Data Aggregation mechanisms.
  • Knowledge in designing and developing Data Warehouses, Data marts and Business
  • Intelligence using multi-dimensional models such as Star Schemas and Snow FlakeSchema
  • Leading & working with the offshore Team in designing & building Data warehouse as part of ODS project.
  • Created ETL Extraction Strategy architecture as part of Development plan to extract & load data from source systems to operational staging and to CDW.
  • Worked on implementing Client Onboarding process steps as part of ETL from Confidential Pro & touch works source systems to our Centralized Data warehouse using SSIS.
  • Designed and developed ETL (SSIS) processes & implemented Logging strategies when loading data into data warehouses and data marts.
  • Worked on creating both Tabular & Matrix report Layouts to develop reports based on the requirements using SSRS.
  • Created Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.
  • Used complex expressions to calculate, group, filter, parameterize, and format the contents of a reports in SSRS.
  • Created StoredProceduresfor commonly used complex queries involving join and union of multiple tables.
  • Worked on Data modeling as part of building databases using Database Diagrams in SQL Server management studio

Confidential, Palm Beach Gardens, FL

SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Created reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
  • Created Report Snapshots to improve the performance of SSRS.
  • Evaluated and documented ETL designs, process flows and mapping specifications.
  • Worked with data analysts to understand and analyze business requirements and logic that needs to be implemented in the warehouse day to day load.
  • Generated Parameterized/dropdown SSRSReports.
  • Developed different account level and security level reports using SSRS.
  • Created shared Data sources and developed data models to create Ad hoc Reports.
  • As an ETL/Report Writer Tech lead, lead the Offshore Philippines team in designing and developing ETL structures,SSIS packages & SSRS reports for enhancements in Data warehouse.
  • Worked on providing the SQL Report access for the users through incidents and service requests using LANDesk as part of PROD Support.
  • Worked on the Existing (legacy) SSIS packages and modified the same packages to match it for different sources for integration & migrated them to SQL Server 2012.
  • Implemented Control flow, data flow, logging, event handling and package configurations using SSIS
  • Analyzed the data to implement incremental load.
  • Used Configuration files to deploy and install a package from one environment to another .
  • Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data
  • Implemented Complex Logging in SSIS Packages.
  • Created & designed Data Source & Data Source Views using SQL Server Analysis Services(SSAS)
  • Involved in developing SSAS cubes using Star Schema to precalculate & store complex aggregations.
  • Worked on data warehouse concepts by creating KPI’s, Actions & Perspectives as part of cube development using SSAS.
  • Worked on existing Tabular SSAS models& provided the operational support to satisfy new business requirements
  • Worked on the multi-Threaded query processing for the faster accessing to tabular modeling and data through reporting client applications such as Microsoft Excel.
  • Used agile methods to promote a disciplined project management process that encourages frequent inspection and adaptation.

Confidential, Fairfax, VA

SQL Server Developer /SSIS Developer

Responsibilities:

  • Worked on different types of Source systems like SAP, Clarity, Siebel, eFrontOffice and matched with the measures of EDW and stored it in SQL Server Database Using SSIS.
  • Prepared technical documentation for every stored procedure and updated those stored procedures with new data elements.
  • Designed & Developed Type 2 Slowly Changing Dimensions inorder to maintain the historical changes for the business purposes.
  • Worked on the Existing (legacy) SSIS packages and modified the same packages to match it for different sources for integration.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
  • Used 3rd party tools like Upsert task and modified & replaced the complex legacy system package structure with newer elements.
  • Used OnPostExecute and On Error event handlers to update the each task logging in SSIS log table.
  • Used Script task component and established iterative load for faster retrieval & to improve performance.
  • Used different transformations like lookup, condition split, and row count Transformation, Derived Column, Data Conversion etc.
  • Created Stored Procedures for package Initialization and end package information to update the package log table.
  • Created Package Configuration file with connection information source, staging and destination databases and send mail task connection information and log directory path value.

Confidential, Alpharetta, GA

SQL Server Developer/SSIS/SSRS

Responsibilities:

  • Used SSIS 2008 to create ETL packages (.dtsx files) to validate, extract, transform and load data to Data warehouse databases, data mart databases.
  • Worked on Creating SSIS packages to store the Summary level values of different measures for Premium, Claims & Cash templates.
  • Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
  • Worked with SQL Views to improve the enhanced security of the given templates for various measures.
  • Created Clustered, Non Clustered & Covered Indexes to improve the performances of queries based on the business requirements.
  • Work with the off shore developers, DBA, and systems support personnel in elevating and automating successful code to production.
  • Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
  • Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.
  • Migrated the financial data from CBDM to SQL server.
  • Design the database schema based on the structure of different templates, Legal Entities and Source Systems.
  • Created and migrated the reporting data to the landing zone from different source systems like UC, IRIS, SICS, EDW etc. using SSIS.
  • Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.
  • Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count Transformations.
  • Created the Pop-Spec documents for different projects based on the spec conventions.
  • Created SSIS packages to load data from Oracle to sql Server using various transformations in SSIS.

Confidential, Chicago, IL

SSIS /SSRS/SSAS/TSQL Developer

Responsibilities:
  • Designed and developed SSIS Packages to extract data from various data sources such as Accessdatabase, SAS database and flat files into SQL server 2008 R2 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Expert in designing Multi-dimensional models called Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes in SSAS.
  • Designed Dimensional Modeling using SSAS for End-User. Created Hierarchies in Dimensional Modeling.
  • Worked on ROLAP /MOLAP storage type to a partition containing rarely queried, historical data and thus leave the storage burden largely to the underlying relational database.
  • Worked on creating master and child packages, package configurations and logging Using SSIS.
  • Excellent knowledge of using variables and expressions in packages of SSIS.
  • Worked on creating dynamic SSIS packages to load the data based on the file definition of a particular file.
  • Created batch jobs to automate the SSIS packages.
  • Used N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C# .
  • Experience in query optimization & performance tuning using SQL Profiler, Execution Plan, Performance Monitoring and DBCC Commands.
  • Identified the database tables and data marts for defining the queries for the reports.
  • Created multiple views & Stored Procedures to apply the customizations on data as per User’s requirement.
  • Created Non-Clustered indexes to improve query performance and query optimization.
  • Created stored procedures to disable and rebuild indexes to minimize the data loading process time, taking advantage of cursors, CTE’s, dynamic management views as well as temporary tables.
  • Used SQL Profiler to check the slow running queries and tasks in SSIS packages and improved the performance by including temporary tables, eliminating sub queries depend on the I/O usage.
  • Created Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.
  • Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.

Confidential, Chicago, IL

SSIS /SSAS/TSQL Developer

Responsibilities:

  • Worked on designing the database by calculating the size of the database.
  • Created Data model using Microsoft Visio based on the design specifications.
  • Worked on the documentation of General Technical Design (GTD) and Detailed Technical Design Documents (DTD).
  • Created the architectural Diagram of the entire project life cycle with the help of Business Requirement Document.
  • Migrated from Old Sybase database to New Sql Server Database by transferring all the logins, objects etc.
  • Worked on the conversion Process by loading the respective data from old system in Excel format to their respective objects and columns in the database.
  • Created stored procedures to bulk load S&P 400, S&P 500, S&P 600 data in daily basis from the shared drive.
  • Worked on User Defined functions (UDF) to return different dates for which the Business Object Reports Uses.
  • Migrated database from SQL server 2005 to SQL server 2008 using utilities i.e. exp/imp and
  • Attach/detach for SQL servers 2005 futures
  • Worked on Creating ETL Packages Using SSIS to extract the data from Thomson Reuters FTP to our local FTP.
  • Worked on extracting the zipped XML files and loaded into the SQL Server Database using SSIS.
  • Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations; scheduled the same SSIS packages by creating the corresponding job tasks.
  • Analyzed the existing tool and participated in meetings with the business users to gather
  • Requirements and design goals of data warehouse.
  • Identified the dimension, fact tables and designed the data warehouse using star schema.
  • Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
  • Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
  • Created Perspectives of the cube to simplify the process of browsing for the end users.
  • Used MDX to create calculated members in the cube.

Confidential

SQL Server Developer / SSRS Developer

Responsibilities:

  • Checked database upgrade advisor for compatibility check for databases before updates. Performed in place and side by side migration of existing SQL server 2000 user’s client critical databases.
  • Involved in Normalization of the database and bringing it to 3NF.
  • Implemented disaster recovery for solving different kinds of issues and also prevented the loss of data.
  • Responsible for developing GUI screens.
  • Wrote SQL queries and stored procedures to generate data for reports.
  • Integrated Database Maintenance jobs to perform Full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler.
  • Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
  • Used SQL profiler to view indexes performance to mostly eliminate table scan.
  • Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks And indexes configurations, administering SQL Server security, SQL Server automatic email Notification and SQL Server backup strategy and automation.
  • Worked with Flat Files Data source connections, ODBC data source connections (to SQL server sources) and DB2 data source connections.
  • Created Ad hoc Reports using SSRS.
  • Created report snapshots to improve the performance of SSRS.
  • Created views consisting of computed columns to facilitate easy user interface.
  • Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
  • Created Non-Clustered indexes to improve query performance and query optimization.
  • Migration from Oracle to SQL Server through DTS Packages.

Confidential

SQL Server Developer/DBA

Responsibilities:

  • Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
  • Involved in Normalization of the database and bringing it to 3NF.
  • Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
  • Created ER diagrams using Visio.
  • Created Views to enforce security and data customization.
  • Created Non-Clustered indexes to improve query performance and query optimization.
  • Involved in the performance tuning and optimization of T-SQL queries.
  • Responsible for Data migration from SQL Server 2000 to SQL Server 2005 Databases.
  • Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
  • Developed user requested reports using Crystal Reports and Excel.
  • Created Drill down and Drill through reports using Crystal Reports

Hire Now