We provide IT Staff Augmentation Services!

Ssis\ Ssrs\ Sql Developer Resume

Columbia South, CarolinA

SUMMARY:

  • An individual committed to deliver high value to the organization.
  • 12 years of extensive IT Professional experience with expertise in Database Development, Modeling, Data Warehousing, Design and Technical management.
  • Experience in developing the applications using T - SQL Programming (DDL, DML, and DCL).
  • Conversant with various phases of Software Development life cycle (SDLC) including development, designing, analysis, coding, testing and implementation.
  • Extensive experience in MS SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000, BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
  • Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database Models and Data Integrity, SQL joins and Query Writing.
  • Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
  • Expertise in creating Dashboards, Metrics, Rules and Goals, corporate/personal dashboards, Alerts.
  • Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
  • Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
  • Experience in maintaining Error Logging using Exceptional Handling in T-SQL and MS SQL Server Integration Services (SSIS).
  • Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, MS Excel, MS Access, CSV, Oracle, flat file.
  • Proficient in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
  • Strong experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various data sources.
  • Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
  • Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports and deploying SSRS reports on the portal for user accessibility.
  • Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
  • Strong experience in logical and physical database design and development using Erwin and MS Visio.
  • Worked in collaborative team environment with other developers, business analysts, and a project management team.
  • Hands on experience in debugging an application using debugging tools provided by the Visual Studio.Net IDE.
  • Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET and LINQ (Language Integrated Query) to access and update database
  • Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio

TECHNICAL SKILLS:

Operating Systems: Windows 10/ Windows 7/ Windows Vista Business / XP Pro. / 2003 / NT / 9.X

Programming: C#. Net, VB.Net, ASP, C, C++, ADO.NET

Scripting Language: Java Script, VB Script

Databases: SQL Server 2016/2014/2012/2008 R 2/20, Oracle 9i/8.x, DB2 MS Access

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Enterprise Manager, Import and Export Data wizard, SQL Server Business Development studio (BIDS).

ETL Tools: SQL Server Integration services (SSIS) 2005, 2008, 2014 and 2016, Data Transformation Services (DTS)

Analytical Tools: SQL server Analysis Service (SSAS), Performance Point Server 2007.

Reporting Tools: SQL server Reporting Services (SSRS), Crystal Reports

Data Modeling Tools: Erwin, Visio, MS Access

Web server technology: IIS

Hardware: EMC DMX & IBM Fast T 700 Storage Area Network (SAN), Compaq Proliant 8000, 6500, 6000

PROFESSIONAL EXPERIENCE:

Confidential, Columbia, South Carolina

SSIS\ SSRS\ SQL Developer

Responsibilities:

  • Extract the data from different source systems of Confidential like (Mainframe ACBS, ACL, QuickCode) and transform and Load the data into enterprise staging area order to create and maintain a centralized data warehouse. Made the package dynamic so it fit the environment.
  • Implemented automated solutions to provide data to third party vendors utilizing SSIS / 2008 R2
  • Performed all technical activities required for delivery of BI solutions including ETL, data modeling, solution deployment and maintenance.
  • Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
  • Work with business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
  • Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management
  • Work with application developers and production teams and across functional units to identify business needs and discuss solution options. Doing coding, unit testing and reviews and also providing UAT support and production roll outs
  • Performing Design and writing technical design documents, test plans and system interface documents.
  • Proficient in performance tuning / query optimization using indexes. Tuning the performance of stored procedure and large T-SQL queries using clustered indexes, efficient coding standards.
  • Expert Level experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
  • Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
  • Experience in Error handling and debugging coding issues and troubleshoot production problems.
  • Good understanding of Normalization /De-normalization and database design methodology.
  • Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team orientated, technically motivated and creative. User oriented with a desire to learn client’s business requirements.
  • Flexible and versatile to adapt any new environment and work on any project.

Environment: SQL Server 2016/ 2014/ 2012/2008 R2/2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS, SSAS), T-SQL, .Net framework, Microsoft Visual Stuidio.NET 2008, C#.NET, VB.NET, Windows Server 2008/ 2012.

Confidential

SQL BI Developer (SSIS\SSRS\SSAS)

Responsibilities:

  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into SQL Server Database
  • Applied data conversion transformation in an input column which has an unsupported data type in SQL server to a data type in the output column which is supported by SQL server (SSIS).
  • Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).
  • Experience in Microsoft Visual C# in script component of SSIS.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2008/2012).
  • Experience in creating configuration files to deploy the SSIS packages across all environments.
  • Worked in Objects creation such as Tables and Views, complex Stored Procedures, User-Defined Functions, Indexes and appropriate Triggers to facilitate efficient data manipulation and consistency
  • Closely works with Business to help them in analyzing the data and providing an expertise in designing the requests to make the system more efficient.
  • Worked on Production Support, receiving production calls , troubleshooting the application and resolving bugs
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
  • Created reports using the report builder and trained users to generate their own reports.
  • Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment
  • Enforced the referential Integrity constraints as well as Created Clustered as well as Non-Clustered Indexes in order to improve the performance
  • Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins
  • Maintained referential integrity and implemented complex business logic.
  • Generated Reports to the end users by using T-SQL queries.
  • Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
  • Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
  • Created calculated measures in a cube by using MDX scripting .
  • Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes.

Environment: SQL Server 2012/2008 R2/2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS, SSAS), T-SQL, .Net framework, Microsoft Visual Stuidio.NET 2008, C#.NET, VB.NET, Windows Server 2008

Confidential

SSRS Developer/ SQL BI Developer

Responsibilities:

  • Created various complex reports and manage those using SQL Server Reporting Services.
  • Developed complex Stored Procedures and Views to be used to supply the data to the reports. Complex formulas were used to show derived fields and to format the data based on specific conditions
  • Wrote complex expressions and calculations for SSRS reports with Conditional Formatting.
  • Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements
  • Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
  • Modified current database by adding tables, altering referential integrity and relationships to support the control system
  • Optimized SQL queries for efficiency and assisted the front-end developers with their queries and procedures.
  • Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected
  • Created indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.
  • Performed performance tuning by analyzing indexes, queries, table sizes, etc and heavy utilization of SQL Profiler and query execution plan tools.
  • Used Triggers to generate customized error messages.
  • Error handling application using SQL server profiler to trace information submitted to the server.
  • Responsible for Query optimization and Performance tuning, SQL queries using Show Plans and Execution Plans.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
  • Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
  • Created SSIS packages for Data Conversion using data conversion transformation.
  • Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
  • Deploying database objects from development/testing environment to production environment.
  • Assisted team with data validation, statistical analysis, data migration and complex reports.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers

Environment: SQL Server 2005/2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), T-SQL, SQL Profiler, .Net framework, MS Visual Source Safe, Windows Server 2008

Confidential

SSRS/ SQL Developer

Responsibilities:

  • Developed optimized stored procedures, T-SQL queries, User Defined Functions (UDF), Cursors, Views and Triggers, SQL Joins and other statements for benesmart reporting Application, maintained referential integrity and implemented complex logic.
  • Enhancing the layouts available for the reports in the BeneSmart application
  • Designed and created Report templates, Bar graphs and Pie charts based on the financial data.
  • Dealt with huge amount of data and used SSAS in order to retrieve the data
  • Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
  • Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
  • Gather requirements from business user and modify the stored procedures, codes to provide functionality as required.
  • Troubleshooting and fixing Bugs/issues in the enterprise level web application using C#.NET, ADO.NET, ASP.NET.
  • Perform including filters to the reports and make it parameter-driven
  • Perform including SQL Agent jobs to update source of data by use of SSIS package.
  • Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).
  • Deploying the reports to staging server prior to business user acceptance testing.
  • Perform including security to the reports and data in the application
  • Implement updates of reports in BeneSmart application to recognize same-day data updates/changes.
  • Doing release builds and fixing issues related to reports in staging environment of BeneSmart application.
  • Created data driven subscriptions for different users using Report Manager.
  • Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET and LINQ (Language Integrated Query) to access and update database
  • Expert in debugging an application using debugging tools provided by the Visual Studio.Net IDE.
  • Sound Knowledge in ADO.NET to communicate with database for retrieving, accessing, and updating data.
  • Proficient with Dynamic HTML, XML, CSS, for building a dynamic flexible and highly interactive Real-Time User Interface.

Environment: SQL Server 2008 Enterprise Edition, MS SQL 2008 r2, SQL Server BI Suite (SSRS, SSIS and SSAS), Microsoft Visual Stuidio.NET 2010, Microsoft Visio 2003, ASP.NET 3.5, ADO.NET, C#.NET, MS EXCEL 2007.

Confidential

SQL / Donet Developer

Responsibilities:

  • Plan, design, and implement application database code objects, such as stored procedures, views using SQL Server 2008 and Windows Server 2008.
  • Develop new processes to facilitate validation and create reports to show the business data to the users in form of reports.
  • Dealt with database of terabyte size with complex stored procedures and views having multiple embedded procedures and views.
  • Hands on experience in writing T-SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers.
  • Extensively used transformation of data between servers by creating linked servers and transforming data into table from a text file using BCP/Bulk insert method.
  • Extensive use of Query Analyzer for performance tuning
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Created package using various control flow and dataflow component for extracting data from the daily feed file and storing that information into table.
  • Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).
  • Worked intensely on the User Interface and developed Web Forms using Vb.net and ASP.NET
  • Created custom control and user control to reuse the control more than once in an application.
  • Developed Web Services exposing web method providing functionality that being used in application.
  • Extensively used Repeater, Data Grid, Grid Views with sorting and paging
  • Implemented Template Columns for Custom Nested Grid Views.
  • Created SQL agent jobs to schedule the package, stored procedure and various processes to be executed at regular time intervals.
  • Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.
  • Used HTML, JavaScript and AJAX for developing Controls and web forms
  • Work with application developers and production teams and across functional units to identify business needs and discuss solution options.
  • Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management

Environment: SQL Server 2000/2005/2008 Enterprise Edition, SQL Server Business Intelligence studio (SSIS, SSRS, SSAS), Query Analyzer, Microsoft Visual Stuidio.NET 2005, ASP.NET, ADO.NET, VB.NET, HTML, IIS, Visual Source Safe, MS Project, MS Office 2003 & Windows Server 2008.

Hire Now