SUMMARY

• A Microsoft certified Professional with 8 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.
• About 8 years of IT experience in Analysis, Design, Development, Implementation of software applications to support Reporting and Business Intelligence initiatives
• Experience in creating different types of reports such as drill down, drill through reports, linked reports, Click through reports, Snapshot reports.
• Experience in integrating SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Expert in designing and scheduling complex SSIS packages for transferring data manually from multiple data sources to SQL server
• Using Normalization and De-Normalization techniques
• Experience with Data Transformation Services(DTS) an Extract Transform Load(ETL) tool of SQL server to populate data from various data sources by creating packages for different data loading operations of each application
• Developed SSIS packages to ETL/DTS data into the Transactional Database from heterogeneous databases such as Excel, MS Access, MS SQL, Oracle, AS400
• Very proficient in working with large databases.
• Involved in Backing up databases and refreshing Data across environments.
• Excellent knowledge of using variables and expressions in packages of SSIS.
• Worked with Flat file, Excel file, and SQL server OLEDB destinations for loading data.
• Involved in Installation, Configuration, Development, Deployment and Troubleshooting Reporting services using SSRS across various environments.
• Experience in writing Queries using SQL Server Analysis Services (SSAS).
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Tuning the performance of stored procedures and large T-SQL Queries using Clustered indexes, efficient coding standards
• Excellent knowledge in RDBMS and Data warehouse concepts
• A well-organized, goal-oriented, highly motivated and effective team player with excellent analytical, troubleshooting, and problem solving Skills.
• Scheduling database backups using TWS tools.
• Excellent Verbal & Written Communication skills and strong in Documentation.
• Flexible, enthusiastic and project oriented with excellent communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

Databases: MS SQL Server 2008, 2008 R2, 2012, 2005, 2000.

Database Tools: MS SQL Server 2008R2/2005/2000, MS-Access, SSMS, BIDS, DTA, Query Analyzer

ETL Tools: SSIS 2012, SSIS 2008, SSIS 2005, Bulk insert, BCP.

Reporting Tools: SSRS 2012, 2008, 2005, Tableau, Crystal Reports, Business Objects

Languages: T-SQL, C, C++, HTML, XML, MDX, Java, VB.

Web Technologies: HTML, DHTML, XML.

Architecture: Relational DBMS, Client-Server Architecture, OLAP, ROLAP.

Operating Systems: Windows 98/NT/2000/XP/7/8/10, UNIX, Linux

Tools: Microsoft Visual Studio 2005, ProClarity ODBC, MS Office, SQL Server Management Studio (SSMS).

PROFESSIONAL EXPERIENCE

Confidential, Pittsburg, PA

BI Developer (SSIS, SSRS)

RESPONSIBILITIES:

• Involved in understanding the functional requirements, translation of technical documents, data dictionary mapping and data mappings
• Interacted with various upstream and downstream customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.
• Designed & developed ETL procedures, data mappings involving data analysis, data validations and data migrations.
• Involved in writing heavy T-SQL stored procedures, complex joins, new SQL2008 T-SQL features like Merge, Except commands
• Support Batch and Online processes involving development, enhancement and support of T-SQL procedures, views, triggers and query tuning
• Developed Complex Packages to load data into Stage, ODS and Data Ware House systems.
• Developed SSIS packages using Lookup Transformations, Merge Joins, and Derived Columns with Multiple Data Flow tasks.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages.
• Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Created Package Configurations, Error Handling using Event Handlers for On Error, On Warning, and On-Task FailedEvent Types.
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids
• Involved in automating SSIS Packages using SQL Server Agent Jobs, Window Scheduler
• Configured, Installed, Administered SSRS2005/2008.
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Reports.
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
• Developed reports using complex TSQL queries, User Defined Functions, store procedures and Views.
• Created Report Email Subscription using Data Driven and Time Driven ReportSubscriptions.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
• Generated SSRS Reports involving different features like Reports, Sub-Reports, Drilldown, Drill-Through, Charts, Filters, Multi-valued parameters and linked reports in SSRS.
• Deployed reports across Test, Developmentand Production Environments.
• Involved in Creating User Security and Roles In Reporting Services at both Parent Level and Report Level.
• Involved in Trouble Shooting Complex Reports.
• Created Large Number of Report Models for users to create their own reports.
• Involved in code reviews, change control and auditing procedures.

Environment: SQL Server 2005/2008R2, Microsoft Visual Studio, MS BIDS, SSRS, SSIS, Management Studio 2005/2008, Active Directory and Windows XP platform, DOT NET 2.0/3.5 Framework, MS Office 2007, MS Visio, MOSS 2007. Tivoli Workload Scheduler (TWS).

Confidential, Pittsburg, PA

SSIS/SSRS Developer

RESPONSIBILITIES:

• Gathered user requirements, draft specifications design and create Database objects for performance tuning.
• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages
• Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert)
• Worked on Error Handling and Logging in SSIS packages.
• Created configuration table to set the properties of the objects of SSIS package sat runtime.
• Used multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes Using MDX and ADX.
• Used SSIS 2008 to create ETL packages to validate, extract, transform and load data to data warehouse, data mart database, and process SSAS cubes.
• Implemented best practices for performance tuning of SSIS packages
• Involved in error handling of SSIS packages by evaluating error logs
• Successfully extracted transformed and load data into data warehouse.
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports and dashboards and score cards reports (SSRS) according to business requirement.
• Created reports by dragging data from cube and wrote mdx scripts.
• Improved the performance of long running views and stored procedures.
• Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.
• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• Tuned the queries using Execution plan, to get index seek from table scan and index scan.
• Improved the performance of many queries by 90%.
• Worked with Erwin data modeling tool.
• Created Database objects including Tables, Views, Stored Procedures and UDF.
• Developed User defined functions, stored procedures, and indexes.
• Extensively involved in writing database scripts.

Environment: SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), MS Excel, XML, SQL Profiler.

Confidential, Columbus, OH

SQL BI Developer (SSIS, SSRS, SSAS)

RESPONSIBILITIES:

• Created Tables, Views, Indexes, Stored Procedure and Triggers.
• Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
• Involved in full Software development life-cycle (SDLC) followed by agile methodologies to produce high quality software model.
• Utilized Integration Services (SSIS) to produce a Data Mart for reporting.
• Strong experience in working with BCP,SSIS(DTS,DTSX) packages forData Integration Services.
• Extensive knowledge of using System Variablesand creating User-Defined Variables for SSIS Packages.
• Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2008 via SQL Server Integrated Services
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
• 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)
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Extracted data from various sources like SQL Server 2012/2008, .CSV, DB2, Excel and Text file from Client servers and through FTP.
• Worked with Report Builder 2.0, Report Models and Ad Hoc Reports.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.

Environment: SQL Server 2012/2008R2 Management Studio- Enterprise Edition, T-SQL, BIDS, SSIS, SSRS, ProClarity, XML, SharePoint, Agile, Microsoft Visual Studio 2008 w/.NET Framework 3.5, Windows XP.

Confidential, Sherman Oaks, CA

SQL BI Developer (SSIS, SSRS)

RESPONSIBILITIES:

• Removed the DTS package references from stored procedures and created as SSIS packages and embedded those procedures in the SSIS package to retain the load functionality of the system.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Migrated data from MS SQL source databases to destination database in SQL Server 2008 database using SSIS.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Designed and developed OLAP Cubes in SSAS.
• Used DDL and DML for writing triggers, stored procedures and data manipulation.
• Writing SSIS packages for loading the data (100 million records) from source to target as per the requirement.
• Developed and maintained enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modified existing reports as needed.
• Successfully implemented and monitored Transactional replication with update subscribers, snapshot replication on production environment with publisher, distributor and subscriber topology.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008.
• Created weekly, monthly and quarterly based financial reports using SQL Server 2005 Reporting services.
• Used the Default logging as well as Custom Log to keep track of the package
• Performed data backup, recovery, and transfer operations.
• Used DTS to extract, transform and consolidate data from different sources into Data Warehouse.
• Created report templates for ad hoc reports using SSRS.
• Worked on Cube structure optimization for MDX query performance in Analysis Services 2005(SSAS).
• Configured Log shipping from one production server to the reporting server.
• Performance tuning ofSQLqueries and stored procedures usingSQLProfiler and Index Tuning Wizard in SSIS
• Performance Monitoring with SQL Profiler and Windows System Monitor.

Environment: MS SQL Server 2008R2/2012, SQL Server Integration Services (SSIS 2008R2/2012), SQL Server Reporting Services (SSRS/2008/2012), Business Intelligence Development Studio (BIDS),Team Foundation Server (TFS 2010),VBScript, .Net (Asp .Net, C# .Net)

Confidential

Jr. SQL Server Database Administrator

Responsibilities:

• Involved as part of a team for gathering and analyzing the end User Requirements.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Defined relationship between tables and enforced the referential integrity constraints.
• Created Clustered and Non-Clustered Indexes.
• Responsible for General Database Administration, Query Performance tuning.
• Worked with DTS packages to load the data into Data warehousing system.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Trouble shooting Problems by using SQL server profiler.
• Used DBCC commands for maintaining the databases.
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Export & Import data from Flat file, CSV file to/from SQL Server Database using SSIS
• Export & Import data from/to databases like Oracle, MySQL, and Access to/from SQL Server
• Responsible for capacity planning and disaster recovery
• Scheduled jobs to automate different database related activities including backup,
• Monitoring database health, disk space, backup verification
• Developed Different Maintenance Plans for database monitoring
• Monitored Server Activity, and solved problem as needed

Environment: Microsoft SQL Server 2000/2005, DTS, Windows 2000, XP