We provide IT Staff Augmentation Services!

Sql Server Developer / Ssrs, Ssis Resume

5.00 Rating

EXECUTIVE SUMMARY:

  • Around 6 years of IT experiencein all phases of SoftwareDevelopment Life Cycle (SDLC) such as planning, analysis, design, implementation, testing and maintenance of SQL BI in domains like Finance, Insurance, and Logistics.
  • Extensive experience in MS SQL Server 2008/2012 with Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis.
  • Extensive knowledge of Relational Database Management Systems (RDBMS).
  • Experience in installation and configuration of SQL Server 2008 and 2012.
  • Proficient inlogical and physical data modeling, Forward and Reverse engineering using ERwin, Normalization, de - normalization and building Referential Integrity Constraints.
  • Experience in creating databases, transactions, tables, indexes, constraints, writing and debugging stored procedures,triggers, views, functions and cursors using.
  • Expert in monitoring SQL Server Performance, troubleshooting using Execution Plan, SQL Profiler and IndexTuning Wizard.
  • Extensive experience in creating various reports using Reporting Services (SSRS 2008 R2/ 2012) and Deploying and managing reports on Report Server and SharePoint Server.
  • Experience in creating different kinds of subscriptions to deliver reports to users on schedule basis.
  • Experience in creating visualizations and dashboard reports using Tableau Desktop.
  • Experience in ETL process using Integration Services (SSIS) SSIS Import ExportData, Bulk Insert, BCP and DTS/SSIS Packages.
  • Experience in creating, deploying and automate SSIS Packages.
  • Automating teh Database Maintenance tasks, SSIS packages by creating Jobs using teh SQL Server Agent.
  • Experience in business intelligence/data warehousing practices and tools (including SSAS)
  • Extensive experience in creating multiple reports (SSRS) including parameterized reports, Tabular forms, Matrix forms, Drill-down reports, Drill-through reports, Charts, Sub-reports using SSRS2012/2008
  • Knowledge in developing SSAS cubes using visual studio 2008 R2/2012. Creating reports from cubes using MDX
  • Experience in implementing Partitions, Aggregations, and handling many to many relationships between tables in teh cube.
  • Knowledge of VB, C#.NET, ASP.NET, ADO.NET.
  • 24X7 on call support for Production Servers. Experience in working with offshore team.
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and teh ability to think outside teh box.
  • Excellent Written, Analytical Skills, Verbal Communication skills with a customer service oriented attitude.

TECHNICAL SKILLS:

Database Management System: MS SQL SERVER 2012/2008R 2/2008/2005/2000, MS-Access,DB2

Database Utilities: Enterprise Manager, query analyzer, SQL server, Profiler, SQL Server Management Studio.

ETL Tools: SQL Server integration services (SSIS), Data Transformation Services

Reporting Tools: MS SQL Server Reporting Services, Crystal Reports, Tableau

Programming Language: TSQL, SQL,C,C++,VB,C#.NET

Operating Systems: WindowsServer 2000/2005/2008/2008 R2/2012

Utility Tools: MS Office, Visual Source Safe 6.0

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server Developer / SSRS, SSIS

Responsibilities:

  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call teh packages and Stored Procedures.
  • As a Team Player, involved in gathering teh Business Requirements for Extraction of Data from different sources.
  • Responsible for database design and creation of tables, views and functions.
  • Developed custom reports using SSRS/SQL Server BI studio.
  • Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
  • Provide database coding support to application development team.
  • Extract Transform Load (ETL) development using SQL 2012/2008 Integration Services (SSIS).
  • Created SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, for each Loop, Multi Cast, column conversion, Fuzzy Grouping.
  • Used system stored procedures and DBCC commands.
  • Wrote some complicated stored procedures in order to meet teh requirements.
  • Successfully migrated teh data from various sources such as Oracle, Flat files, Excel files and MS Access.
  • Created new SSIS packages for Extracting data using Sequence Container, For Each Loop, Container, Execute SQL Task, Merge Transformation etc.,
  • Modified teh Existing SSIS Packages to improve teh performance of Data Load.
  • Generated Quarterly, Semi-Annual and Annual reports through Tabular and Matrix reports using SSRS Reporting tool.

Environment: MS SQL Server 2005/2008/2012, MS SQL Server Reporting Services 2005/2008/2012, T-SQL, Oracle 11g.

Confidential, Columbus, OH.

SQL BI Developer

Responsibilities:

  • Involved in gathering, understanding and validating teh project specifications.
  • Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for generating reports using SSRS.
  • Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
  • Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.
  • Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services 2012.
  • Developed complex T-SQL queries for teh ETL packages.
  • Designed packages in SSIS2012 with various complex transformations such as derived column, conditional split, lookup, aggregation, execute SQL task.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases
  • Wrote teh ETL scripts to load teh data into database from various source files. Experienced in errorhandling and troubleshooting teh scripts in failure to load teh data into database.
  • Created user variables, property expressions, script task in SSIS.
  • Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.Expert in SSIS Deploying and Scheduling packages
  • Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented teh table relationships with diagrams.
  • Designed different type of reports including: Tabularforms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
  • Designed Cascading (Collapsed), Printable, interactedreports (drill-down and sorting functionality).
  • Responsible for deploying reports to report manager and troubleshooting for any error occurs in execution.

Environment: MS SQL Server 2005/ 2008/ 2012, T-SQL, MS SQL Integration Services 2008/2012, MS SQL reporting Services2005/ 2008 R2/ 2012.

Confidential

SQL BI Developer

Responsibilities:

  • Developed T-SQL queries, stored procedures, functions and triggers for dis complex integration. Actively involved in different stages of Project Life Cycle.
  • Generated reports (using SQL Server Reporting Services) based on teh user requirements to produce detailed summary for analysis.
  • Developed complex StoredProcedures, triggers, cursors, tables, constraints, views and other SQL joins and statements for applications.
  • Scheduled Jobs on various stored procedures and packages to automate processes.
  • Created SQL serverReports using SSRS 2008. Created drill down reports, drill through reports and parameterized Reports in SSRS 2008.
  • Identified teh data source and defining them to build teh data source views. Generated Reports using global variables, expressions and functions for teh reports.
  • Responsible for deploying and managing reports on Report Server.
  • Responsible for creating various kinds of Subscriptions like Email subscriptions and File share Subscriptions.
  • Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading teh data into teh Data warehouse.
  • Used ETL to implement teh Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
  • Used Merge in development, test and production for changing teh d data.
  • Created packages in SSIS with error handling worked with different methods of logging in SSIS.
  • Experienced in critical problem solving, building tools to integrate and manage large sets of data.
  • Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Environment: SQLServer2005, 2008, 2012, SSRS 2008 R2, SSIS, SSAS .Net Frame Work, ADO.Net, VB.Net, ASP.Net, XML, VB6, VB Script, Java Script, C#

Confidential

MS SQL Server Developer

Responsibilities:

  • Actively participated in gathering business requirements and system specifications.
  • Created new databases, tables and established relationships between teh tables in teh database.
  • Created efficient stored procedures and functions to support organized data storage and manipulation.
  • Created views to display required information on user interface and trigger to validate consistent data entry into teh database.
  • Extensively involved in writing stored procedures, triggers, common table expressions and functions based on client requirement.
  • Created and administered multiple developments, production and databases.
  • Reduced system downtime risk through automatic offsite backup and recovery over network.
  • Responsible for installing and configuring SQL Server 2005 on Windows NT Operating systems.
  • Used BCP utility to publish table output to text files.
  • Identified, tested and resolved database performance issues like monitoring and tuning to ensure database optimization
  • Maintained SQL scripts for changes in database objects.
  • Involved in running trace from teh profiler to troubleshoot database and used DBCC check commands to check teh consistency of teh database.
  • Provided support for database backup/restore and database transfer activity from test environment to production environment.
  • Set up SQL mail and created jobs to automate and schedule many tasks.
  • Involved in support team and halped in 24X7 production support.
  • Involved in coordinating post-implementation events such as testing.

Environment: SQL Server 2005, T-SQL, Windows NT, MS Access, Visual Basic 6.0, Enterprise Manager.

We'd love your feedback!