We provide IT Staff Augmentation Services!

Sql Bi Developer Ssis & Ssrs Resume

4.00/5 (Submit Your Rating)

Profile Summary:

  • 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008/2005/2000 in Development, Test and Production Environments with various business domains like Financial, Statistical, Pharmaceutical and manufacturing.
  • Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2008/2005/2000.
  • In-depth Experience in Transact-SQL (DDL, DML, DCL), and in Design and normalization of the database tables.
  • Proficient in writing, modifying and implementing Stored Procedures, Functions, Views, Triggers and SSIS Export & Import.
  • In-depth knowledge of T-SQL, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
  • Good hands on experience in RDBMS concepts, data models.
  • ETL implementation using SQL Server Integration Services (SSIS). 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.
  • Experience in designing SSIS Packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, union all etc..
  • Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
  • Experience in writing Distributed Queries between SQL Servers.
  • Very good Experience in scheduling and deploying reports on report manger.
  • Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.
  • Experience with high level of accountability, demonstrated initiative and innovation and ability to manage competing priorities, varying workload yet still achieve results.

Education:
Bachelor of Science with a Minor in Economics

Technical Expertise:

Platforms:

Windows 98/Me/XP/NT/2000 server/XP/2003 server/Vista/7, Linux (Red Hat, Slackware)

Languages:

T-SQL, PL/SQL, C, C++ , SAS, Mathamatica, Mathstatica, Minitab, SATA, VB, ASP.NET, PHP.NET, Java

RDBMS:

Microsoft SQL Server 2000/2005/2008, MS Access, Oracle

IDE:

Microsoft Visual Studio 2005/2008

SQL Server Tools:

SSMS, Enterprise Manager, Query Analyzer Profiler, Export & Import (DTS), SSIS, SSRS, Database Tuning Advisor

Web Technologies:

HTML, JavaScript

Other Tools:

MS Office suite, MS Visio

Professional Experience:


Role:

SQL BI Developer SSIS & SSRS

Company:

Confidential,NY

Duration:

Apr-2011 to till Date

Responsibilities:

  • Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
  • Developed logical and physical data models for schemas using MS Visio.
  • Installed SQL Server 2008 R2 and Management tools using SQL Server Setup Program.
  • Developed and maintained many SSRS reports in BIDS for users by gathering and analyzing the requirements, validating the accuracy of the report’s output and deploying it on SharePoint 2007 and in .net intranet applications for internal Investment clients.
  • Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges.
  • Involved in Unit testing in SSIS Packages, Query verification in SSRS, Stored Procedure
  • Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS 2008).
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
  • Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS and integrated in SharePoint environment.
  • Designed SSIS Packages to extract, transfer and load (ETL) data from flat files to SQL Server using Business Intelligence Development Studio.
  • Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc to extract, transfer and load (ETL) data from OLTP to OLAP databases
  • Using SSRS delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources..
  • Wrote T-SQL queries, Store Procedures and used them to build packages.
  • Developed all the required Stored Procedures, user defined functions, triggers, views using T-SQL as per business logic which were used to support .net Investment application for customers.
  • Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
  • Worked with stored procedures for data set results for use in Reporting Services to reduce report complexity and to optimize the run time. Exported reports into various formats (PDF, Excel) and resolved formatting issues.
  • Optimized the performance of queries with modifications in T-SQL queries, Normalized Tables, established Joins and created Indexes whenever necessary.
  • Created reports to retrieve data using Stored Procedures that accept parameters.
  • Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
  • Performed daily tasks including backup and restore by using SQL Server 2008 R2 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Generated testcases to meet the functionalities deliverables in the project documentation and specifications.
  • Provided support to the application developers on the application databases.

Environment: MS SQL Server 2008 R2, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), BIDS, Visual Studio 2005, VSS 2005, MS Visio 11.0, Windows NT/2003, Microsoft .NET framework 3.5.

Role:

SQL Server Developer SSRS/SSIS

Company:

Confidential,Medford, MA

Duration:

Mar-2010 to Mar 2011

Responsibilities:

  • Interacted with users to gather business requirements.
  • Designing the logical and physical architecture for database.
  • Installed and Configured SQL Server 2005/2008. Upgraded the existing database to SQL Server 2005/2008.
  • Data conversion from SQL 2000 to SQL 2005/2008.
  • Involved in creation of database objects like schemas, logins, tables, clustered and non-clustered indexes, views, functions and stored procedures. Created SQL scripts for tuning and scheduling.
  • Performed data conversion from flat file into a normalized database structure.
  • Working with development team to optimize application specific database operations and implement security restrictions.
  • Designed, Developed and Deployed reports in MS SQL Server using Microsoft SQL Server Reporting Services (SSRS).
  • Developed single value and multi valued parameterized reports for Business Users using Microsoft SQL Server Reporting Services (SSRS).
  • Worked on report viewer control to embed the reports on to the applications using Visual Studio.
  • Worked on Drill through Report links and Hyperlinks to jump to other reports and web pages using Microsoft SQL Server Reporting Services (SSRS).
  • Involved in usage of various SSIS components like for loop, Foreachloop, Derived column, Sql execution task, Variables, and Error Handling etc.
  • Designed ETL packages for extracting the data and load into the appropriate tables in the database using SQL Server Integration Services (SSIS).
  • Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
  • Involved in taking backups of SSAS database and restoring them when needed.
  • Worked on SQL Server Analysis Service and participated in creation of Dimensions, Cubes and Partitions on Cubes, Develop KPIs and Calculations for various Measures.
  • Helped in creating new component in SSIS called Partition Tasks that creates partitions for the Cubes and drops partitions based on some criteria.
  • Created the automated processes for the activities such as database backup processes using the Integration Services.
  • Scheduled jobs to run the SSIS packages on daily basis using SQL Server Agent.
  • Respond to and resolve database access and performance issues.
  • Setting up alerting system by using performance counters for monitoring system performance.

Environment: MS SQL Server 2005/2008, T-SQL, SSIS, SSAS, SSRS, Business Intelligence Development studio, VB.Net, .Net Framework, MS Visio ,Windows 2003

Role:

SQL BI Developer

Company:

Confidential,Memphis, TN

Duration:

Aug-2009 to Mar-2010

Responsibilities:

  • Analyzed the requirements and selected the appropriate fact tables/created fact tables
  • Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions
  • Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different sources using SQL Enterprise Manager/SSMS on SQL Server environment, and deploy the data; scheduled the jobs to do these tasks periodically.
  • Work on development of Data mart and different SSIS packages to load staging, fact, dimension and metric data into data mart.
  • Created Log Files so that in case of Package failures the errors could be troubleshoot.
  • Created Script tasks to check for existence of Source files for a specified amount of time.
  • Responsible for maintaining and scheduling Packages.
  • Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
  • Migrate / redevelop Data Transformation Services (DTS 2000) packages to SSIS 2005/2008 for server enhancement.
  • Designed ETL architecture for overall data transfer from source server to the enterprise services warehouse.
  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
  • Provided technical support to internal developers and external clients.
  • Worked with financial systems team members to document systems and process environments.
  • Responsible for elevating and automating successful code to production environment.

Environment: MS SQL Server 2008, MS SQL Integration Services 2008, Reporting Services (SSRS), Analysis Services (SSAS), DTS, T-SQL, PL/SQL, XML, HTML, MS Office.

Role:

SQL Server Developer SSIS/SSRS

Company:

Confidential,Bentonville, AK

Duration:

Jan-2008 to Aug-2009

Responsibilities:

  • Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2008 Integration Services (SSIS), SQL Server Reporting Service (SSRS).
  • Created multiple stored procedures, views and ad-hoc reports to generate usage reports.
  • The data was extracted, scrubbed, formatted so it could be loaded to tables of a data ware house (ETL).
  • Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS 2008).
  • Using SSRS delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
  • Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
  • Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio.
  • Designed dynamic SSIS packages to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS.
  • Involved in design and development of ETL Jobs using SQL Server Integration Services (SSIS) for data migration between different maintenance systems.
  • Worked on scheduling data loading and transformations using SQL Server Integration Services (SSIS) between different maintenance systems.

Environment: MS SQL Server 2005/2008, SSRS(Reporting Services), SSIS(Integration Services), MS SQL Server Analysis Services 2008, OLAP, DTS/SSIS, BIDS.

Role:

SQL Developer

Company:

Confidential,

Duration:

Dec-2005 to Dec-2007

Responsibilities:

  • Creation, manipulation and supporting the SQL Server databases.
  • Involved in the Data modeling, Physical and Logical Design of Database
  • Created tables, indexes, sequences, constraints, triggers and procedures.
  • Stored procedures and triggers were used to implement business rules.
  • Helped in integration of the front end with the SQL Server backend.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS)
  • Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries
  • Created documentation as required.

Environment: MS SQL Server 2000, T-SQL, DTS.

We'd love your feedback!