We provide IT Staff Augmentation Services!

Ms Sql - Ssis/ssrs Developer Resume

0/5 (Submit Your Rating)

Sfo, CA

SUMMARY

  • 7+ years of experience in Data modeling, database design, Programming, Development and Implementation of Client - Server Applications & Database systems using MS SQL Server 2012/2008/2005.
  • Extensive experience in Using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading
  • Expert in data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles
  • Using Normalization and De-Normalization techniques
  • Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using the stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs)
  • Writing heavy stored procedures, Audit triggers views, creating SQL scripts for data loads and Upgrades for data migrations and data validations
  • Proficient in Performance Tuning/Query optimization using indexes
  • Assisted with automation of manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.
  • Tuning the performance of stored procedures and large T-SQL Queries using Clustered indexes, efficient coding standards
  • Involved in Backing up databases and refreshing Data across environments
  • Huge Data transfers from & to SQL Server Databases using utilities/ tools like DTS, SSIS, BCP, Bulk Insert
  • Experienced with aggregation using OLAP analysis services cube.
  • Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Trouble shooting, and Database Objects authorization.
  • Extensively experienced in database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.
  • Extensive knowledge in design of logical and physical data modeling using Erwin tool and consistency check using DBCC utilities.
  • Proficient in implementing surrogate key generation strategy in the Data warehouse.
  • Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
  • Organized professional with excellent oral and written communication skills, excellent presentation, interpersonal skills, problem solving skills, fast learner and also adept quickly new technology with ability to take new roles in minimum time and little training.

TECHNICAL SKILLS

RDBMS: MSSQL Server 2000/2005/2008/2012 , MS ACCESS.

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development Studio, Visual Studio, Configuration Manager, SQL Server Profiler SQL Query Analyzer, SQL Refractor, SQL Server Agent.

ETL Tools: Data Transformation Services (DTS), SSIS, Pervasive Data Integrator, Import/ export wizard, Bulk Insert, BCP

BI Tools: SSIS, SSRS, SSAS, Crystal Reports, BIRT, Plateau Report Designer.

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook

Management Tools: SharePoint, Team Foundation Suite (TFS), Microsoft Office Communicator.

Languages: T-SQL, MS SQL, MDX, C/C++, VB, VBA, HTML, XML.

Web Technologies: HTML, DHTML, XML.

O/S: Windows 2008/2007/2003/2000/ NT Servers, XP, Vista, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, SFO, CA

MS SQL - SSIS/SSRS Developer

Responsibilities:

  • Gathered and analyzed reporting requirements for the sales and marketing departments.
  • Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS packages.
  • DevelopedSSIS 2012 Packagesto migrate data from Oracle, Access, flat files and Excel into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations.
  • Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.
  • Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
  • Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.
  • Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS.
  • Formatted reports using Global Variables, Expressions and Functions for the reports.
  • Designed and developeddifferent type of reports including:Tabular forms, Matrix (crossTab report) form, Conditional, List items, Charts and Sub reports, Drill down reports..
  • Createdcomplex expressions, calculations, sorting, filteringto enhance data presentationin reports.
  • Createdinsert, update and deletetriggers on some tables in order to capture anyDML activitieshappening on somecrucial and confidential data.
  • Created dashboards using Performance Point Server, combining scorecards and reports generated inSSRS, PPS,andExcel Services.
  • Developed Power Pivot Reports inExcel by publishing them toSharePoint for providing ad-hocreports according to client need.
  • Developed Charts and othervisualization using Power View.
  • Filter and Sorting Data usingPower View in Excel.
  • Developed Power Maps using Excelfor Reporting.
  • Configured Report Model for developing ad-hoc reports by the end-users.
  • Uploaded reports on to the report manager and organized them into folders.
  • Created score cards with executive summary dashboards using MS Office Performance Point Server Dashboard Designer that display performance monitoring measures for sales, sales trends.
  • Created score cards with advanced set of dashboards using MS Office Performance Point Server Dashboard Designer that feature executive summary measures for revenue and profitability trends.
  • Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.
  • Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.

Environment: MS SQL Server 2008 and 2012, Windows Server 2008, SSIS, SSRS, PPS, SharePoint, T-SQL, ETL, MS Access, XML, Excel, Visual Studio 2008, Visual Studio 2012, MS office 2007,outlook

Confidential, Austin, TX

SQL Server /SSIS/SSRS Developer

Responsibilities:

  • Creating Schema Database diagrams, Tables structures and maintain the relationships with constraints and indexes as per business logic.
  • Created Stored procedures, User Defined Functions (UDF), views, Joins and system defined functions, Temp Tables, Table Variables etc.
  • Increase the queryperformance, Handling the errors in script level and used Transactions.
  • Preparing the release/roll back scripts as per productiondeployment process.
  • Using transformations like DerivedColumn, Conditional Split, Aggregate, Row Count, Lookup, sort and Data Conversion to load data into Data Warehouse.
  • Experience in creation of validation and Ingestion packages as per the business logic
  • Extensively working in Data Extraction Transformation and loading into staging tables, validate the records on staging tables through validation process then valid records are insert into productiontables through ingestion process.
  • Developed Systemlogging and Customlogging on task and package level.
  • Implemented Package Template and Package configurations.
  • Creating Reportsubscriptions to store the reports at shared locations at schedule time.
  • Experience on rendering the Reports in the form PDF, Excel and .CSV formats
  • Building and generating reports with the help of Report Builder in the Report manager.
  • Generating subreport, drill down, drill through, Parameterized, Cascade parameters, Report Expressions and custom code.
  • Performed Unit Testing and integration testing on the completion of Development for requirement.
  • Involved with the client interaction for functional and Technical clarifications and solutions.
  • Involved in resolving the Production issues and deployment Process with DBA's while deploying to different environments.
  • Preparing Technical design documents (TDD),Code Review, Promotional and Deployment Process Documents.

Environment: Microsoft SQL Server 2008, MS SQL Server 2008, MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2008, DTS, SQL Profiler, MS Office, Windows Server 2007.

Confidential, Salt Lake City, UT

SQL Server Developer

Responsibilities:

  • Created Store Procedures to transform the data and worked extensively in T-SQL for various needs of transformations while loading the data.
  • Written complex SQL queries using joins, subqueries and correlated sub queries to retrieve data and Triggers to carry out various tasks from the database.
  • Involved in performance tuning of T-SQL Queries and focused on index tuning, query optimization and partitioning.
  • Used SQL Server Profiler to trace the slow running queries and the server activity.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Used various SSIS tasks such as Conditional Split, Derived Column, Data Conversion, Fuzzy lookup, merge, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Imported and Exported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
  • Automated the SSIS jobs and email alerts using SQL server agent job for daily, weekly and monthly loads.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008.
  • Used reporting objects like Tabular, Matrix, Sub report, Charts, Parameterized and Cascading parameterized reports using SSRS-2008.
  • Deployed and Published the Created Reports to Microsoft Share Point Server and also uploaded them to Microsoft Performance Point Server.
  • Fixed Back end issues related to the Desktop GUI Screens to help Users.
  • Running Data Scans on Production/ QA Environments as per the requests from SYSOPS.
  • Aware of working with different ticketing workflow systems like JIRA and SRS.
  • Documented the development work.

Confidential, Columbus, OH

SQL Server Developer/ SSIS/SSRS

Responsibilities:

  • Understanding the report design Requirements and Constraints.
  • Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
  • Design and implementation of Security Model, Policies and Procedures.
  • Performing query plans and making sure each and every query is using appropriate useful Indexes
  • Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
  • Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
  • Rebuilding Indexes and Tables as part of performance tuning exercise.
  • Deployed the created SSIS packages in Development and Testing environments.
  • Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
  • Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package
  • Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Created Drill-down, Parameterized and Sub-Reports using RDL.
  • Promoted RDLs to Reporting Service Server (SSRS).
  • Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.
  • Created scorecards with executive summary dashboards using MS Office Performance point server 2007 Dashboard designer that display performance monitoring measures.
  • Designed and developed Data-mart using SSAS.
  • Build Cubes on Enterprise Date Warehouse (EDW).
  • Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
  • Performed DBCC checks and fixing data corruption in Application databases.
  • Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.

Confidential

SQL server Developer/SSIS/SSRS/DBA

Responsibilities:

  • Wrote complex stored procedures, User Defined Functions, Triggers using T-SQL.
  • Created DTS packages for data transfer between the two environments.
  • Security issues related to logins, database users, and application roles and linked servers.
  • Performance tuning of SQL queries and stored procedures using SQL profiler and Index tuning advisor.
  • Administered of all SQL server database objects, logins, users and permissions in each registered server.
  • Resolved any deadlocks issues with Databases/Servers on a real-time basis.
  • Wrote scripts for generating Daily Backup Report, verifying completion of all routine backups, log space utilization monitoring etc.
  • Generated reports in SQL Server Reporting Services (SSRS) using table control, matrix control for cross tab reports.
  • Developed Tabular, Drilldown, Parameterized, Charts, Sub-Reports using SSRS.
  • Defined Report Layouts for the report design as per the need.
  • Installed SSRS, Configured the Report Server and Deployed Reports.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.

Confidential

SQL Server Developer

Responsibilities:

  • Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
  • Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
  • Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
  • Implemented Exceptional Handling
  • Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
  • Creating and automating the regular Jobs.
  • Tuned and Optimized SQL Queries using Execution Plan and Profiler
  • Rebuilding Indexes and Tables as part of Performance Tuning Exercise
  • Involved in performing database Backup and Recovery
  • Worked on Documentation using MS word

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.

We'd love your feedback!