Professional Summary:

• 8 years of Information Technology development experience on Database Design and Development in SQL server 2012/2008R2/2008/2005/2000 system in OLTP and OLAP environment in various industries like Finance, Insurance and Health Care.
• A motivated, highly organized individual and enthusiastic team player with excellent communication, analytical and problem solving skills.
• Has in-depth knowledge of Transact-SQL Data Definition Language, Data Manipulation language
• Creates tables, views, user defined functions, cursors, derived tables, common table expressions CTEs and Triggers to facilitate efficient data manipulation and data consistency
• Dealt extensively with Relational Database Management Systems, including E/R Diagrams, Normalization, Constraints, Querying, Joins, Keys, Data Import/Export
• Wrote sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statements
• Encapsulated Ad-hoc TSQL statements into Store Procedures for Optimization
• Wrote ad-hoc queries utilizing Dynamic SQL and SQLCMD command line utility
• Created and maintained Cluster Index and Non Cluster Index
• Implemented ETL Packages using DTS and SSIS 2012/2008R2/2008/2005/2000, creating SSIS,DTS packages for large data transfers between MS-SQL Servers and automating using SQL jobs
• Implemented all transformations available on the SSIS toolbox.
• Created master and child packages, package configurations and logging
• Used variables and expressions in packages
• Extracted, transformed, and loaded data ETL between Homogenous and Heterogeneous System using SQL tools SSIS, DTS, Bulk Insert, BCP, and XML
• Created Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages
• Generated reports using MS Reporting Services 2012/2008R2/2008/2005/2000
• Configured report server and report manager scheduling, gave permissions to different level of users in SQL Server Reporting Services SSRS
• Generated on-demand and scheduled reports for business analysis or management decisions using SQL Server Reporting Services
• Possesses excellent technical and analytical skills with a clear understanding of data architecture, metadata, design goals of ER modeling for OLTP and dimension modeling for OLAP
• Designed, created and processes cubes using SSAS
• Calculated measures and dimension members using multi-dimensional expression MDX , mathematical formulas, and user-defined functions
• Designed aggregations and pre-calculates using SSAS.
• Created groups and measures, KPIs
• Scheduled and deployed reports, and uploaded files to a report server catalog from the report manager
• Designed and implemented relational database model as per business needs
• Analyzed, designed, developed, tested and implemented systems following the SDLC

Business Technical skills:

MS SQL Server 2012/2008R2/2008/2005/2000, SSRS 2012/2008R2/2008/2005/2000, SSAS 2012/2008R2/2008/2005/2000, SSIS 2012/2008R2/2008/2005/2000, DB2, MS-Access 2000, MS Excel, Erwin 8.0/7.2/7.1, MS Visio 2010/2007/2005, VB 6.0, Oracle 11g/10g, T-SQL, PL/SQL, HTML, XML, XSL, Java script, VB Script, C , Visual Studio 2012/2008 R2/2008/2005/2000, ODBC, MS office, Windows NT/ 2000 Server/ XP.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server/BI Developer SSIS/SSRS

Responsibilities:

• Actively involved in discussion meetings and requirements gathering
• Designed Components, Templates and Parameters to generate reports in Tabular and graph report
• Created source and target definitions, mappings and transformation rules.
• Specified the Joins, checked the cardinalities and resolved loops by either using Alias or Contexts.
• Design and implement Extract, Transformation and Load ETL processes, programs and scripts.
• Generated Custom LOV's List of Values and Custom Hierarchies for drilling down Reports which allows the users to analyze the data.
• Scheduled Daily, Weekly, Monthly and Quarterly Reports Web Intelligence scheduling.
• Created graphical representation of reports such as Bar charts, Line Charts as per end user requirements.
• Experienced with project methodology process and application or system development lifecycle SDLC for various projects in the organization
• Requisite Pro is used to document the requirements and the document types are helped to organize the information to work with in the projects
• Developed number of Custom Reports with different types and modified standard reports as per customer/end user requirements.
• Created SQL Server Reports using SSRS 2012 and exported them to Excel format for managers and QA team for easy validation.
• Created Ad hoc reports for manager using SSRS to find all the work items open for Developers.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Environment: MS SQL SERVER 2012, SSAS, SSIS, SSRS, , Business Intelligence Studio ,DTS, SQL Profiler, C .net, Windows 2007, Microsoft Access, Microsoft Visio, MS Office 2012.
• Confidential
• SQL Server/SSIS /SSRS Developer
• Responsibilities:
• Conducted Data Analysis and performed Data Modeling and Created the ER diagrams using Logical Schema.
• Designed and developed SSIS ETL packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Data Staging to SQL server. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Configured files to deploy the SSIS packages across all environments.
• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, and Reporting tools. Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, using SSRS 2012. Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studio BIDS . Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions using T-SQL to provide structure to store data and to maintain database efficiently.
• Extensively used SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance.
• Involved in fine tuning SQL query, SQL Optimizing using SQL Profiler, Index Tuning Wizard, and Database Tuning Advisor.
• Work directly with managers and testing team in an Agile methodology of SDLC.

Project Environment:

Windows 2007-Advanced server and Enterprise Server 2003, MS SQL Server 2008, SQL server integration services SSIS 2012, SQL server reporting services SSRS 2012, TSQL. Erwin tool 8.0.

Confidential

SQL Server/ SSRS Developer/SSIS Developer

Responsibilities:

• Actively involved in creating Custom Reports by understanding the Management and senior level Management's need to support in business.
• Designed and Modified Tabular, Matrix, Drill Through, Drill Down, List, Subreport and made them dynamic using SSRS 2012/2008 R2.
• Created parameterized report as per the user role and level, Cascading parameterized report, and Multi value parameterized Report.
• Developed Report Models for creating Ad Hoc Reports using report builder.
• Developed Reports including hyperlink to SharePoint and Used JAVA Script to open report in different window for better comparison perspective.
• Responsible for deploying report directly to production server and Developer Server.
• Scheduled and Maintained Reports Job and subscription to deliver reports in various rendering format.
• Extensively created dashboard reports to track Reports Performance based on their data retrieval time, Data operational time and Data rendering time to address issue for better optimization in timely Manner.
• Organized reports folders for better convenience by linking similar reports from one folder to another, and Created user friendly report to find any reports among the all reports.
• Created and modified SSIS ETL packages to validate, extract, transform and load data into database.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Experienced in creating jobs, Alerts, and Scheduling SSIS Packages using SQL Server Agent job.
• Configured files to deploy the SSIS packages across all environments.
• Responsible for creating and modified database objects like table, Views, Store Procedure, and User Defined Functions using T-SQL to provide structure to store data and to maintain database efficiently.
• Extensively used SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance.
• Involved in fine tuning SQL query, SQL Optimizing using SQL Profiler, Index Tuning Wizard, and Database Tuning Advisor.

Project Environment:

MS SQL Server 2012, SQL server reporting services SSRS 2012/2008 R2.

SQL server integration services SSIS 2012

Confidential

SQL Server /SSIS /SSRS Developer

Responsibilities:

• Involved in gathering the report specifications by interacting with the business users
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard.
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Experienced in creating jobs, Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Increased query performance, necessary for statistical reporting by more than 25 after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Planned, defined and designed data based on the business requirement.
• Designed and developed different type of reports including: Tabular forms, Matrix cross Tab report form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Environments:

MS SQL Server 2008 , Enterprise Edition, MS SSRS 2008, MS SSIS 2008,T-SQL, VB Script, Windows Server 2003, Erwin 7.1.

Confidential

MS SQL Server Developer

Responsibilities:

• Created various Table and Views to ensure the increase performance of application.
• Gathered real time operation data to create reports.
• Analyzed operation data and provide real time operation updates.
• Extensively used Import/Export Wizard and Data Transformation Services DTS for data migration.
• Scheduled jobs to streamline and automate cumbersome repeated tasks using MS Access.
• Created SQL Server and MS Access reports for the manager and the senior manager involved and formatted the report layout for the requirement of the end users.
• Wrote user requirement documents based on functional specification.
• Developed source to target specifications for Data Transformation Services.
• Created indexes, Constraints and rules on database objects for optimization.
• Provided system maintenance and update.
• Responsible for database performance tuning.
• Involved in designing and developing various Web Forms Class Libraries in .NET C

Environment: MS Access, MS SQL Server 2005 MS Word, MS Excel, UNIX, Windows NT, Windows 2003,C .Net