We provide IT Staff Augmentation Services!

Sql Server Bi Developer (ssis/ssrs) Resume

0/5 (Submit Your Rating)

GA

SUMMARY

  • 7 years of extensive experience as a MS SQL Server SQL Server 2005/2008/2012 Developer with major focus on T - SQL, SSIS and SSRS. 4 years of sound experience as a database developer in banking, IT and financial sectors. Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies. Possess experience in independently handling design, development, documentation and testing phases in a project environment.
  • Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, and triggers when required.
  • Expertise with DDL and DML statements.
  • Estimate, schedule and track ETL projects throughout SDLC.
  • Good knowledge in RDBMS concepts, data models, Star/Snow Flake Schemas.
  • Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
  • Exceptional hands on working knowledge with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
  • Proficient in Installing SQL Server 2005/2008/2012 and configuration of their tools.
  • Good understanding indatabaseanddata warehousing concepts (OLTP and OLAP).
  • Knowledge on integration of BI suite of products with Microsoft Office range of products likeMOSS (SharePoint) and Dashboards.
  • Good report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Good Hand on Resolving complex issues and Error Handling in SSIS.
  • Very good knowledge in scheduling and deploying reports on report manger.
  • Experience in developingUser reports and management reports using MS SQL Server Reporting Services (SSRS).
  • Experience in developingCustom Reportand different types of Tabular Reports, Matrix Reports and drill down reports in multiple formats usingSQLServerReporting Services(SSRS) in Business intelligence development studio (BIDS).
  • Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
  • Experience in enhancing and deploying the SSIS Packages from development server to production server.
  • Experience in TOAD v9.5 for developing and managing PL/SQL scripts.
  • Knowledge in C#,ASP.Net.
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Operating Systems: Windows 2008, Windows NT 4.0, Windows XP, Windows Vista.

Components/environment: MS SQL Server 2005/2008/2012 , SQL Server Management Studio, SQL Server Reporting Services, SQL Server Integration Services, Analysis Services.

Languages: C,C++, PL/SQL,T-SQL,ASP.Net

RDBMS: SQL Server 2012,2008, 2005/ 2000 /7.0 , 8.0,9.0,10.0,MySQL,MS Access, Oracle 11Gi

Application: Visual Studio

Database Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL, Toad for SQL

Database Software: TOAD,MYSQL

Systems familiarity: OLTP,OLAP, Unix/Linux, Windows

PROFESSIONAL EXPERIENCE

Confidential, GA

SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

  • Translated business requirements onto technical designs to map and load data from source systems to the data warehouse
  • Extensively used T-SQL in constructing user functions, views, indexes, user profiles, and relational database models and data integrity.
  • Transformed data from one server to other servers using SSIS.
  • Worked as a developer in creating complex Stored Procedures, SSIS packages, tables, and views and other SQL joins and statements for applications.
  • Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
  • Created packages in SSIS with error handling.
  • Experienced in creating complex SSIS packages using proper control and data flow elements.
  • Responsible for gathering Business Requirements and System Specification from users.
  • Created Various Sparkline reports, Chart and Map reports using SQL Reporting Services.
  • Created various Tabular and Matrix Reports using SSRS.
  • Created various drill down reports using SSRS.
  • Involved in the post deployment maintenance of reports
  • Experience inintegrating SharePoint Serverwith SSRS and deploying SSRS reports on toSharePoint Server.
  • Experienced in documentation of packages.
  • Designed and developed SSIS ETL processes, test, deploy and quality assure the content.
  • Worked on SSIS configuration and trouble-shooting.
  • Participated in enhancing processes for ETL design, source code control, integration testing, defect management, database standardization and tuning.

Environment: Microsoft SQL Server 2012, Microsoft SQL Server 2008(R2), SQL Server Integration Services(SSIS),SQL Server Reporting Services(SSRS), SQL Server Business intelligence Development Studio(BIDS), Report Builder,C#.Net, Share Point, T-SQL, MS Excel.

Confidential, Atlanta, GA

SQL Server BI Developer (SSRS)

Responsibilities:

  • Designed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
  • Created Indexes to get the high level performance.
  • Modified the database by removing unwanted columns and also adding proper constraints, rules and defaults to tables.
  • Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
  • Created Views for specific columns on a table to maintain privacy of a customer data.
  • Maintained databases, performed software installations and upgrades, monitored Database Performance.
  • Responsible for gathering Business Requirements and System Specification from users.
  • Designed numerous ad-hoc, crystal reports and custom reports using SQL Reporting Services.
  • Created various Tabular and Matrix Reports using SSRS.
  • Creating Dynamic Drill-down, Drill- through, toggle and filtering capabilities to provide insights into specific areas of interest .
  • Created various drill down reports using SSRS.
  • UtilizedSharePointto integrate information from various systems to one secure solution.
  • Involved in the post deployment maintenance of reports
  • Created and scheduled jobs for various tasks.

Environment: Microsoft SQL Server 2008(R2), SQL Server Reporting Services (SSRS), Management studio, SQL Server Business intelligence Development Studio(BIDS),Share Point, T-SQL, Oracle 10g,11g, MS Excel, MS Access.

Confidential, PA

SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

  • Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
  • Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
  • Created Views for specific columns on a table to maintain privacy of a customer data.
  • Created Indexes to get the high level performance.
  • Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
  • Created packages using C#.Net.
  • Designed SSIS packages for synchronizing the data between two different servers.
  • Maintained databases, performed software installations and upgrades, monitored Database Performance.
  • Responsible for gathering Business Requirements and System Specification from users.
  • Designed numerous ad-hoc, crystal reports and custom reports using SQL Reporting Services.
  • Worked on exporting data to flat files using Teradata.
  • Created various Tabular and Matrix Reports using SSRS.
  • Created various drill down reports using SSRS.
  • DeployedSSRS ReportsinSharePointSites for web based access for multiple end users.
  • Involved in the post deployment maintenance of reports.
  • Developing ETL Frame work to extract and load the data from multiple databases from SQL Server 2008 to File Server and File Server to work flow Job System SQL databases.
  • Created and scheduled jobs for various tasks.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server 2008(R2), SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), C#.Net, SQL Server Business intelligence Development Studio(BIDS),Share Point, T-SQL, MS Excel, MS Access,ASP.Net, Oracle, Teradata.

Confidential

SQL Server BI developer (SSIS/SSRS)

Responsibilities:

  • Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
  • Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
  • Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
  • Created Indexes to get the high level performance.
  • Modified the database by removing unwanted columns and also adding proper constraints, rules and defaults to tables.
  • Performing the ETL operations to support the data loads and transformations using SSIS.
  • Involved in migration from Oracle to SQL Server 2005 using SSIS.
  • Generation of reports from the cubes by connecting to Analysis server from SSRS.
  • Maintained databases, performed software installations and upgrades, monitored Database Performance.
  • Implemented automated backup and database maintenance / cleanup jobs.
  • Managing Logins, Users, Roles and User permissions.
  • Designed numerous ad-hoc, crystal reports and custom reports using SQL Reporting Services.
  • Created various Tabular and Matrix Reports using SSRS.
  • Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server 2008(R2), SQL Server Reporting Services (SSRS), Management studio, SQL Server Analysis Services 2005, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, Oracle 10g,11g, PL/SQL, TOAD v9.5, MS Excel, MS Access, ASP.Net.

Confidential

SQL Developer

Responsibilities:

  • Created Views to reduce apparent database complexity for end users and preventing sensitive columns from being displayed
  • Wrote Triggers and Stored Procedures.
  • Evaluated Database Performance and performed maintenance duties such as Tuning, Backup and Restore.
  • Scheduling Jobs and Alerting using SQL Server Agent.
  • Successfully designed and implemented SSIS packages to transfer data within servers.
  • Developed custom reports using SSRS/SQL Server BI studio.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Managing and configuring logins to SQL Server, database user accounts, permissions.
  • Created complex T-SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
  • Troubleshooting, Monitoring and Tuning the SQL Server for optimum performance.

Environment: Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, DHTML, PL/SQL, TOAD v9.5, MS Excel.

Confidential

Software Programmer

Responsibilities:

  • Technical Design and development.
  • Interacting with the client for more clarity on the requirements if required.
  • HLD/Customer Visible Documentation.
  • Creation of tables CDMAPART and DNHLRRTE.
  • Development of Customer Forms and Reports.
  • Table content monitoring during restarts.
  • Product Testing
  • Created packaged procedures, triggers validation procedures.
  • Developed validation scripts for the complex business rules using PL/SQL.
  • Designed the Test Case documents for the product.
  • Tested product Performance and Functionality.
  • Created test cases at all phases of unit and acceptance testing for all the developed forms and reports according to the client requirement.

Environment: Proprietary database, Proprietary language called PROTEL similar to JAVA, PL-SQL code browsing tool MENTOR, 2000/XP, UNIX.

We'd love your feedback!