Sol Server Developer / Ssrs, Ssis Resume
DetroiT
SUMMARY
- Around 8+ years of IT experiencein all phases of Software Development 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 the Database Maintenance tasks, SSIS packages by creating Jobs using the 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 the 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 the ability to think outside the 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, Detroit
SOL Server Developer / SSRS, SSIS
Responsibilities:
- Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
- As a Team Player, involved in gathering the 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 the requirements.
- Successfully migrated the 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 the Existing SSIS Packages to improve the 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 the 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 the 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 the ETL scripts to load the data into database from various source files. Experienced in errorhandling and troubleshooting the scripts in failure to load the 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 the 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, Atlanta, GA
SQL BI Developer
Responsibilities:
- Developed T-SQL queries, stored procedures, functions and triggers for this complex integration. Actively involved in different stages of Project Life Cycle.
- Generated reports (using SQL Server Reporting Services) based on the 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 the data source and defining them to build the data source views. Generated Reports using global variables, expressions and functions for the 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 the data into the Data warehouse.
- Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
- Used Merge in development, test and production for changing the referenced 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, Louisville, KY
SQL BI Developer
Responsibilities:
- Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.
- Wrote complex queries, triggers and stored procedures, defined roles and privileges to control access to database.
- Performance Tuning, Analyze, tuning and optimizing for SQLServer Application by using performance monitor. Assist the SQLDevelopers in SQL tuning.
- Worked closely with the business users in defining and documenting reporting requirements in order to design, develop and maintain SQLServer2008 R2 Reporting Services.
- Designed and implemented reporting and business intelligence platforms across multiple applications.
- Maintained data marts of extracted data.
- Performed logical and physical data modeling.
- Designed reports with formulas, grouping/sorting and parameters (including multi-value parameters) using SQL Server 2008 R2 Reporting Services.
- Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot) Reports, Chart and Graphs, Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Drill-downreports and ad-hoc reports using SQLServer2008 R2 Reporting Services.
- Designed and created reports and distributed reports in multiple formats such as Excel, PDF, XML, HTML, TIFF and CSV using SQLServer2008R2 Reporting Services.
- Configured and Deployed different reports in the Servers using SQLServer2008 R2 Reporting Services.
- Developed different types of ad-hoc reports using Report Model and Report Builder tools of SQLServer2008 R2Reporting Services.
- Designed Custom Assemblies/Function to enhance the functionality of different reports.
- Designed Data Warehouse Database for both Start and Snow Flake Schema.
- Created and Designed Data Source and Data Source Views Using SQLServer2008 Analysis Services.
- Created and Configured Cubes using SQLServer2008 Analysis Services.
- Configured Dimensions, Measures and Measures Groups using SQLServer2008 Analysis Services.
- Created MDX queries to access cube information.
- Created logical and physical data modeling for development database using Erwin Tool
- Performed DBCC utilities and fixed data corruption in application databases.
- Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, captured long running SQL/runaway queries using SQLServer.
- Designed Data Transformation Services (DTS) packages to refresh data on Development, QA, Staging and Production.
Environment: SQLServer2005, 2008, 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 the tables in the 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 the database.
- Extensively involved in writing stored procedures, triggers, common table expressions and functions based on client requirement.
- Created and administered multiple developments, production and training 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 the profiler to troubleshoot database and used DBCC check commands to check the consistency of the 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 helped 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.