SUMMARY

• Over 8+ years of in - depth experience in database Design, Modeling, development, administration and maintenance of SQL Server 2012/2008R large scale databases.
• Hands on experience in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting SQL Server 2008/2005/2000.
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Extensive experience in Microsoft stack of BI solutions - SSRS, SSAS, and SSIS with MS SQL 2008/2005/.
• Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
• Assisted in development of ETL architectural standards and provided guidance and conducted s to Architects.
• Crystal Reportsdevelopment focusing on website/email tracking, database queries and accounting.
• Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Used PowerPivot when requested to display analysis result with visual.
• Used MDX (Multi-dimensional Expressions) queries for calculated members of a cube and KPIs (Key Performance Indicators).
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS).
• Designed and Build the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Knowledge in migrating DTS packages, reports and analysis services projects from SQL Server 2000 to SQL Server 2005.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.
• Good experience in creating pivot tables and charts in Excel using data sources (SQL Server, SSAS cubes, Access) and power pivot.
• Launching the report builder for adhoc reports.
• Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Performed DBA tasks using Enterprise Manager and Query Analyzer.
• Accomplished in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.
• Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures.
• Implemented different Replication Models like Snapshot, Merge, Transactional and Database Mirroring.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Joins,Constraints, DDL, DML, MDX and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Good Knowledge in designing Database Models using UML, MS Visio and Erwin.
• Ability and willingness to learn new technology and deliver results in a timely manner.
• A well-organized, goal-oriented, highly motivated effective team member.

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008 R2
• SQL Server Integration Services (SSIS)
• SQL Server DTS
• Data Stage
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• Rational Rose
• Oracle 9i
• VB6
• Microsoft Products MS Word
• MS Excel
• VSS
• MS Access
• MS Power Point
• T-SQL
• PL-SQL
• HTML
• XML
• C++
• JavaScript
• C#
• ASP.net
• Share point
• ODBC
• MS Visio 2008
• Erwin

PROFESSIONAL EXPERIENCE

Confidential, Southfield, MI

MS SQL / BI Developer

Responsibilities:

• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operationalDrill-throughandDrill-downreports usingSSRS
• Developed different kind of reports such aSub Reports,Charts,Matrix reports,Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved withQuery Optimizationto increase the performance of the Report.
• Developed Reports for business end users usingReport Builderwith updating Statistics.
• Create charts and pivot tables in Excel.
• Updated functional specification and technical design documents.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports usingSSRS.
• Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Designed an OLAP system with the help of ERWIN to visualize data structure.
• Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS) 2005.
• Generated daily, weekly and monthly reports using SSRS 2008.
• Served as aSSRS2000 Reports Developer and SQL Server Developer in support of Service Management System.
• Worked on hosting the Power BI and SSRS reports on the SharePoint sites.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Creation of Data Visualization using Power BI tools such as Power Pivot and Power View to support business decisions.
• Worked on Analysis Services for three different approaches for creating a business intelligence semantic model such as tabular, multidimensional, and PowerPivot.
• Expert on creating Score Cards, Metrics, Power View/MAP and Pivot Tables using Office 365.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS using Visual Studio 2010.
• Filter and Sorting Data using Power View in Excel 2013.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.

Environment: SSIS, SSRS, MS SQL Server 2012, 2008, R2/2005, C#, SharePoint, Power Pivot, Visual studio 2008/2010, MS Access, MS Excel, MS Office Access 2007

Confidential, Somerset, NJ

MS SQL / BI Developer

Responsibilities:

• Worked as a database developer on databases like MS SQL Server 2008R2 using T-SQL, stored procedures and views to get data from Data warehouse.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Configured Connection Manager Files and CMD files for SSIS packages to dynamically execute on QA Server and Production server
• Made Master Child package using variables and Execute package task in SSIS.
• Wrote VB.NET code for Script task to perform functions that are not available in the built-in tasks and transformations that SSIS provides.
• Deployed, Tested and Scheduled SSIS packages.
• Worked on designing reports using SSRS 2012 mainly Parameterized reports and Sub reports.
• Printed contracts and reports from Quick Reports and Crystal Reports.
• Used Crystal Reports for sales tracking, advertising renewals and billing purposes.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Maintained report models for ad hoc reports and deployed on report server.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Developed incremental loading using MERGE statement in SQL server 2008R2.
• Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
• Used Execution Plana and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.

Environment: Windows Server 2003, SQL Server 2012/2008R2, SharePoint, SQL Profiler, Microsoft Visual Studio 2008, SSIS, SSRS,VB.Net.

Confidential, NYC

MS SQL Server SSIS / SSRS Developer

Responsibilities:

• Requirements gathering, Analysis and Design of all the client requirements.
• Performed Data Modelling and Developed logical and physical model using Erwin and implementing them to sql server.
• Wrote custom T-SQL stored procedures andtriggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc. to migrate the old Bills information, Customer Information, Contracts Information and other important data.
• Used Crystal Reports to tracked logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
• Used SSIS to upload amortization schedules sent by the client in .CSV format on to the staging tables, which were used for doing all the calculation. Then the data was moved to the core tables and the staging tables were deleted.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS.
• Identified the Data Source and defined them to build the Data Source Views.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports.
• Managed Alerts for successful or unsuccessful completion of scheduled Jobs.
• Used Crystal Reports to track successful/unsuccessful sent emails, emails that were read, click-through and demographical comparisons with SQL database of customer information.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Involved in testing, bug fixing and documentation for the project.

Environment: SQL Server 2008, SQL BI Suite (SSIS, SSRS), SQL Profiler, MS Office, Erwin, Windows Server 2003.

Confidential, Los Angeles, CA

BI Developer/SSRS Developer

Responsibilities:

• Gathered requirements about the project which was used to create the SSIS 2008 packages.
• Wide knowledge of ETL architecture, data schemas and SSIS packages
• Identified the data sources and created source to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS).
• Orchestrated, developed and deployed the SSIS packages using SSIS 2008 as the ETL tool.
• Used Package configurations, Variables and Expressions while creating the SSIS packages.
• Developed complex stored procedures to be used in SSIS 2008 packages to audit the information about the data flow from one stage to other.
• Used various transformations in the ETL packages while transferring the data from OLTP source to destination using SSIS 2008.
• Used SQL server agent to automate the SSIS package execution.
• Responsible to create test cases and performed system testing for the SSIS packages using SSIS 2008.
• Made various report parameters and query parameters to create parameterized reports using SSRS 2008.
• Created reports having actions like URL and bookmarks which helped to easily navigate through the report using SSRS 2008.
• Implemented caching of reports and managed the report history in the Report Manager.
• Performed complex Expressions to create calculated fields and used Global Variables in SSRS 2008.
• Use ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Created stylish reports and implemented conditional formatting using SSRS 2008.
• Deployed and managed the reports in the Report Manager using SSRS 2008.
• Wrote complex stored procedure, views using T SQL in Management Studio
• Optimized the queries for efficient data retrieval by implementing indexes on the tables.

Environment: SQL Server 2008 Enterprise Edition, SSIS, SSRS, T-SQL, Windows NT.

Confidential, New York, NY

MS SQL Server Developer (SSRS, SSIS)

Responsibilities:

• Interacted with the users for understanding and gathering business requirements.
• Designed a complex SSIS package for data transfer from three different firm sources to a single destination like SQL Server 2005.
• Implemented data views and control tools for guarantee data transformation using SSIS.
• Extensively worked on SCD transformation in SSIS package.
• Successfully deployed SSIS packages with defined security.
• Developed logical database and converted into physical database using Erwin.
• Proficiently created Reports based on the requirements using SSRS 2005.
• Involved to write complex T-SQL queries and Stored Procedures for generating reports.
• Defined parameters for parameterized Reports using SSRS.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, fund Reports, Portfolio Report, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2005.
• Developed various Charts and Graphs like bar charts, line charts, pie charts etc by using chart experts for BI needs.
• Use ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Successfully worked with Report Server and configured into SQL Server 2005.
• Extensively worked with OLAP cubes to generate drill through reports in SSRS.
• Responsible to monitor performance and optimize SQL queries for maximum efficiency.
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard.
• Involved in the analysis, design, development, testing, deployment and user of analytical and transactional reporting system.
• Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.
• Tuned SQL queries using execution plans for better performance.
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance.
• Wrote Query for ad hoc Reports and Users design Custom Queries.
• Analyzed reports and fixed bugs in stored procedures.

Environment: MS SQL Server 2005, MS SQL Server 2005 Reporting Service, MS SQL Server Integration Services 2005, BIDS, Erwin, T-SQL, Windows XP.

Confidential, Northbrook, IL

MS SQL Server Developer

Responsibilities:

• Migrated the DTS packages into SSIS and created new SSIS packages to Extract, transform and load the data from old data warehouse to new data warehouse and OLTP to OLAP.
• Removed the DTS package s from stored procedures and created as SSIS packages and embedded those procedures in the SSIS package to retain the load functionality of the system.
• Performed regular Administration activities from Managing system resources, users and database to the fine-tuning level and implemented the project successfully.
• Designed and developed tables, and stored procedures and performed data imports and restores for successful migration.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Configured linked servers in SQL Server 2000 and modified them to work in SQL server 2005.
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.
• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) and Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Created and monitored all SQL tasks (SSIS Packages) and scheduled daily jobs using Agent Scheduler through SQL Server Management Studio. Includes, implementation of necessary batch processes for periodic updates.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Scheduled full and transactional log database backups in the production environment using the database maintenance plan wizard.
• Setup database maintenance plans and used index tuning wizard to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.

Environment: Windows XP Professional (SP 2), SQL Server 2005, SQL Profiler, SSIS, SSRS.