We provide IT Staff Augmentation Services!

Ms Sql/ssis/ssrs Developer Resume

Chandler, AZ

SUMMARY

  • 8 years of experience in analysis, design, implementation & administration of Business Intelligence solutions (SSIS/SSRS/SSAS), Oracle OWB, Informatics, Cognos And SQL with MS T - SQL (2012/2008/2005 ), Oracle 8i/9i, in development, testing & production environment.
  • Extensive experience in Requirement Analysis, Workflow analysis, Design, Development & Implementation, Testing & Deployment of complete software development life cycle (SDLC) in field of Desktop Applications, Microsoft web and client/server technologies.
  • Exceptional versatility and adaptability, extremely diligent, strong team player with an ability to take new roles.
  • Excellent communication and strong analytical skills.
  • Expert database designer and fluent in all aspects of database development including, E-R modeling, Dimensional modeling, Star/Snowflake schema normalization and optimization using Kimball methodology.
  • Strong concepts of Data Warehousing strategies for ETL, identifying metrics, dimensions, and implementing slowly changing dimension (SCD) etc.
  • Extensive experiences in developing Stored Procedures, UDF, Views, CTE, Triggers, Cursors, and Complex Queries by SQL Server 2012/2008R/2008/2005, Oracle PL/SQL.
  • Proficiency in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using SQL Profiler, Performance Monitor DBCC Utilities.
  • Good understanding in Database Backup, Recovery, investigating and applying necessary MS SQL Server Database Service packs, hotfixes and Security Patches
  • Proficient in applying and setting up SQL Server Clustering Technology, Clustering Topologies (Nodes) and Database Mirroring
  • Highly proficient in design and development of SQL Server Integration Services (SSIS) packages,
  • Experienced in dynamic integration packages weather deploying with configuration catalog or file type configuration in SSIS 2012, Oracle OWB and Informatica.
  • Successfully performed SCD transformation and deployed SSIS package with security.
  • Hands on experience in cleaning and scrubbing of data with Lookup and Fuzzy Lookup, Logging, Error handling by using Event Handler, and Custom transformations.
  • DTS applications moving data between different types of databases and legacy systems.
  • Experienced in writing Scripts using C#, VB.NET.
  • Expertise in creating various type of reports such as Complex drill down & drill through reports, parameterized reports, Matrix reports, Sub reports and Charts using SQL Reporting Services (SSRS)and Cognos based on Relational and OLAP databases.
  • Hands on experience creating Report Server Manager with highly efficient assigned security level
  • Highly proficient in scheduling Data Driven Subscription reports by e-mail delivery, file share or null value performance optimization.
  • Extensive experience to work with OLAP cube in SSRS.
  • Expert in dimensional data modeling, and cube development, partition, aggregation and optimization using SQL Server Analysis Services (SSAS).
  • Excellent command in deploying analysis projects using SQL Server Analysis services.(SSAS)
  • Guided exploration around a business workflow—analysis and action using MicroStrategy.
  • Tested and debugged BI packages using standard tools such as, Qlikview and Teradata.

TECHNICAL SKILLS

  • MS SQL Server 2012/2008R 2/2008/2005/2000
  • MS SQL Server 2008/2005 Analysis Services (SSAS)
  • MS SQL Server Integration Service (SSIS)
  • MS SQL Server Reporting Services (SSRS)
  • Microsoft Access 2000
  • ERWIN 9/8/7.2
  • Microsoft Visio 2010/2007
  • T-SQL
  • C#
  • VB.Net
  • HTML
  • XML
  • XSL
  • Oracle 11g/10g
  • Crystal Reports 8.5/9/10/11
  • TFS
  • Visual source safe 2005
  • MS office 2010/2007/2003
  • Windows 2008/2003/2000 Advanced Server/Professional
  • Windows NT 4.0 Server/Workstation
  • VBScript
  • SharePoint 2007.

PROFESSIONAL EXPERIENCE

Confidential, Chandler, AZ

MS SQL/SSIS/SSRS Developer

Responsibilities:

  • Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect
  • Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
  • Extensively worked on Design and Strategy Projects to Design and develop SSIS (ETL) packages to validate, extract, transform and load data from multiple Sources like Oracle, Excel files, flat files to the SQL Server Data warehouse using different task and transformations like Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task and Send Mail task.
  • Created Running SQL script to verify/validate data by using C#
  • Created SSIS package configuration using environment variables to make the packages dynamic.
  • Created, Scheduled and maintained routine SSIS jobs, tasks, and alerts Daily/Weekly/Monthly basis for executing SSIS packages automatically without user interruption using SQL Server Agent.
  • Implemented error handling of SSIS packages with event handler and configured Send Mail task to indicate the failure of task.
  • Worked on SSIS Packages to stream SAP files from UTF-8 encoding version to Windows default encoding Version with script task(C#,VB) to make the SAP files compatible with Windows environment.
  • Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008R2.
  • Designing and creating Screens and User Interface using Microsoft Visual Basic .NET.
  • Developed code for various screens in Visual Basic .NET.
  • Administered interface to organize reports and data sources with SQL parameters, schedule report execution and delivery in Report Server Manager, and track reporting history using SSRS
  • Worked on creating versioning of data as the data changes, to create the snapshots of the data for reporting purposes using Data Driven Subscription Reports.
  • Generated daily, weekly and monthly email reports for the managers by Scheduled Subscription Reports.
  • Used Team Foundation Server 2010 to source control, data collection,reporting, and project tracking Purpose.

Confidential, Foster City,CA

MS SQL Server/SSIS/SSRS/ BI Developer

Responsibilities:

  • Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
  • Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
  • Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
  • Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
  • Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
  • Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 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.
  • Performed Unit testing for the screens and code in Visual Basic .NET and SQL Server 2008.
  • Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
  • Modified the existing SSIS packages to meet the changes specified by the users.
  • Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
  • Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008R2.
  • Created reports to retrieve data using Stored Procedures that accept parameters.
  • Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
  • Responsible for Monitoring and Tuning Report performance.
  • Created various database objects like stored procedures, functions, tables, views.
  • Configured the report viewing security for various users at various levels using Report Manager.

Confidential, Chicago, IL

MS SQL Server/SSIS/SSRS Developer/ Data Modeler

Responsibilities:

  • Developed complex SSIS packages to import the data from Excel sheets for cleaning and scrubbing of data using Lookup, Fuzzy Lookup, conditional split, for each loop, multicast, data conversion, Derived column, fuzzy grouping, script components transformations to validate and transform the data from staging to data mart tables.
  • Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
  • Created SSIS packages to load Excel files into stage tables by using Bulk Copy Program (BCP )
  • Implemented error handling in SSIS packages using precedence constraints in control flow and different event handlers like On Error, On Package Failure etc.
  • Involved in package configuration to make the packages dynamic for successful execution of packages in development and production environment.
  • Successfully deployed SSIS packages with defined security.
  • Scheduled database jobs for automation of tasks using SQL Server Agent.
  • Worked On performance tuning of SSIS Packages and SQL queries for maximum efficiency and performance using execution plans.
  • Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
  • Responsible to monitor performance and optimize SQL queries for maximum efficiency.
  • Wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.
  • Used advanced features of T-SQL in order to design and tune T-SQL to interface with the database and SSIS applications
  • Developed and provided C# insights into streamlining the business intelligence processes. Research, define and deployed BI packages.
  • Increased query performance by 20%, which is necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler.
  • Reduced and obliterated unnecessary joins and indexes
  • Created ETL packages (.dtsx files) to validate, extract, transform and load data to Data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
  • Designed Aggregations, created groups, KPIs, and pre-calculating measures,in SSAS.
  • Involved in calculating measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions.
  • Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization.

Confidential, Paramus, NJ

SQL Developer/BI Developer/Data Analyst

Responsibilities:

  • Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Developed various T-SQL stored procedures, functions and packages.
  • Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, and Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
  • Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
  • Working knowledge in Data modeling, creating star and snowflake schemas in SSAS.
  • Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
  • Created KPI Objects in line with Requirement Docs in SSAS.
  • Analyzed existing logicaldatamodel (LDM) and made appropriate changes to make it compatible with business requirements.
  • Worked on identifying facts, dimensions and various other concepts of dimensionalmodeling, which are used for datawarehousing projects.
  • Optimized cubes for better query performance.
  • Aggregated cube with 30% performance for better performance.
  • Processed cube to perform incremental updates.
  • Created reports by dragging data from cube and wrote MDX scripts in SSRS.
  • Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
  • Designed and deployed report with Drill Down, Drill Through, Drop down menu option, Parameterized and Linked reports.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
  • Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
  • Used Database engine tuning advisor, SQL Profiler for Performance Tuning.

Confidential, Albany, NY 

Data Analyst/SSRS Developer

Responsibilities:

  • Upgraded MS SQL Server 2000 databases to 2005 using detach/attach, backup and recovery and by replication.
  • Incorporated the DTS packages into SSIS 2005 by using package migration wizard and executed DTS 2000 Package task.
  • Involved in SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and Stored Procedures.
  • Performed transformations using various SSIS tasks such as conditional split, derived column, that performed data scrubbing, including data validation checks during staging, before loading the data into the data warehouse.
  • Used ETL to implement the slowly changing transformation to maintain historical data in data warehouse.
  • Created Views to reduce database complexities for the end users.
  • Designed and implemented stored procedures and triggers for automating tasks.
  • Created Sub-reports, Drill-down reports, Summary reports, and Parameterized reports in SSRS.
  • Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.
  • Created alerts for successful or unsuccessful completion of scheduled jobs.