SUMMARY

• Over 8 years of Professional experience in the IT industry as a MS SQL Server Developer using Microsoft SQL server 2012/2008R 2/2008/2005/2000 in Banking, Finance, and Real Estate Domains.
• Experienced in logical and physical database design and development, Normalization and data modeling using CA Erwin and MS SQL Server Enterprise manager.
• Extensive experience in MS SQL Server 2012/2008R2/2008/2005, Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS).
• Good experience in creating pivot tables and charts in Excel using data sources (SQL Server, SSAS cubes, Access) and power pivot
• Experienced in installing, configuring, managing, monitoring, and troubleshooting SQL Server 2008/2005.
• Experienced in designing high level ETL architecture for overall data transfer from the OLTP - Online Transaction Processing to OLAP - Online Analytical Processing with the help of SSIS.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Expert in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS)
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Experienced in implementing Key Performance Indicator (KPI) Objects in SSAS 2012/2008R 2/2008/2005.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
• Developing, Designing and supporting interactive Tableau Dashboard reports
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Efficient in up gradation and migration from SQL Server 2000 to SQL Server 2008/2005.
• Excellent inter personal skills and communication skills and ready to take challenges with proven ability.

TECHNICAL SKILLS

• MS SQLServer2012/2008R 2/2008/2005/2000
• SSRS2012/2008R 2/2008/2005/2000
• SSAS2012/ 2008R 2/2008/2005/2000
• SSIS 2012/2008R 2/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
• Java script
• VB Script
• C#
• VB.Net
• HTML
• XML
• XSL
• Oracle 11g/10g
• Crystal Reports 8.5/9/10/11
• TFS
• Visual Studio 2012/2008 R 2/2008/2005/2000
• MS office
• Windows NT/ 2000 Server/ XP
• QTP 11.0/9.5/9.0
• QC 10.0/9.5

PROFESSIONAL EXPERIENCE

Confidential, Campbell, CA

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Planned, defined and designed data based on the business requirement.
• Designed logical/physical data models using Erwin tool 8.0.
• Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL/SSIS mapping processes and maintained the mapping documents.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Created VB.Net Script using Script component for Error Handling using in SSIS.
• Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server.
• Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles .Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Developing, Designing and supporting interactive Tableau Dashboard reports
• Designed and developed different types of reports including Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.
• Responsible for Deployment of the report to report server using SSRS and used Report Subscription as well Crystal Report (Data Driven and Standard) to publish reports
• Finish one GUI program by using C# along with SSIS

Environment: MS SQL Server 2012/2008, Enterprise Edition, C#, Power Pivot, MS SSRS 2012, MS SSIS 2012, T-SQL, VB Script, Windows Server 2007, Erwin 8.0, Crystal Report

Confidential, New York, NY

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed physical data models and created DDL scripts to create the database schema and database objects. Designed data models using Erwin.
• Created indexes, constraints and rules on database objects for optimization.
• Designedand developed SSIS ETL/SSIS packages to validate, extract, transform and load data from OLTP systems to the Data warehouse and Report-Data mart.
• Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart usesLookup, 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 transfer packages using SSIS, also maintained the jobs running on Servers.
• Used C# to send email in HTML Format using Script Task in SSIS.
• Created SSIS Packages to perform filtering operations and to import the data on a 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.
• Developing, Designing and supporting interactive Tableau Dashboard reports
• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008R2.
• Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through the report, Sub report, using SSRS. Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Implemented a web development by using .Net and C#
• 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 a database efficiently.

Environment: MS SQL Server 2008R2, SQL server integration services (SSIS) 2008R2, SQL server reporting services (SSRS) 2008R2, SQL server analysis services (SSAS) 2008R2, VB. Net, C#, SQL profiler, EDI, Pro clarity, TSQL. Erwin tool 7.2, Windows 2007

Confidential, New York, NY

SQL/SSIS/SSAS/SSRS Developer

Responsibilities:

• Worked as a SSRS Reports Developer/Administrator and SQL Server Developer in support of Service Management System.
• Created the basic SSIS Framework Technical documents consisting of Naming conventions for packages, transformations, connection managers, log files etc.
• Imported data from text files and excel spreadsheets into SQL Server 2008 database using SSIS package.
• Implemented various types of control flow and data flow transformations in packages to handle different logics and Created SSIS package for Market Value Process feed.
• Used C# scripts in SSIS script task to run custom scripts in package flow.
• Created command files to execute the SQL Server Integration packages using dtexec utility and passed connection and variable values to the packages.
• Used event handlers to send custom e-mail notifications to business users as well as technical teams.
• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Developed and tested complex Transact SQL database objects using MS SQL Server such as stored procedures, functions, views and triggers.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports. Performed user acceptance testing on new and modified reports.
• Displayed pie charts, bar graphs for analysis by top-level management using Analyzer in the reports.
• Developed database triggers and stored procedures using SQL tables.
• Managed all indexing, debugging, optimization and performance tuning using Profiler and SQL Server Agent.

Environment: Microsoft SQL Server 2008, Visual Studio 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

Confidential, Saint Cloud, MN

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Implemented Performance tuning to optimize SQL queries using query analyzer.
• Tested to optimize the procedures and triggers to be used in production.
• Involved in project planning, scheduling for database module with project managers.
• Created the reports based on the requirements using SSRS 2008.
• Generated Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
• Formatted the reports using the Global variables and expressions.
• Created detailed reports for the customers to help them decide which policy to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Identified and defined the Datasets for the report generation.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Developed, monitored and deployed SSIS packages.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Responsible for automation of maintenance jobs, locks and indexes configurations.
• Administered SQL Server security, SQL Server automatic e-mail notification.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handled dead lock scenarios.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Configured replication servers and transactional replication between production and standby server for disaster recovery. Examine two-way database replication using SQL server.
• Processed flat file financial market data using BizTalk to control business logic, ensuring client quote were using the latest pricing data.

Confidential, Madison, WI

SQL Server/SSIS Developer

Responsibilities:

• Involved in reverse and forward loading of the schema of a database using Erwin.
• Responsible for gathering Business Requirements and System Specification from users.
• Studied detail changes that need to be made to each business process that is performed by all the systems impacted.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
• Implemented automated backup and database maintenance / cleanup jobs.
• Generated Views for specific columns on a table to maintain privacy of a customer data.
• Created Indexes to get the high level performance.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs through SQL Server Agent.
• Designed SSIS packages for loading data from ODS to Data mart.
• Created SSIS packages for synchronizing the data between two different servers.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Involved in the implementation of Performance Point Server (PPS).

Confidential

SQL Server Developer

Responsibilities:

• Gathered functional requirements and written the technical specifications
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Created complex stored procedures, triggers and cursors in SQL Server.
• Developed source to target specifications.
• Generated stored procedures, functions, views and triggers.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created SSIS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects.