PROFESSIONAL SUMMARY:

• 7 years of experience as MS SQL Developer in administration and development of Database Design and Development in SQL Server 2008R2/2008/2005 system in OLTP and OLAP environment.
• Excellent experience in SSIS, SSAS and SSRS of MS SQL Server.
• Highly expert in translating Business System Design document into technical design document
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• In-depth experience of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
• Hands on experience in Installing, configuring, managing, monitoring and troubleshooting SQL Server 2008R2/2008/2005.
• Experienced with Rapid application development RAD to emphasize the necessity of requirement as the project progresses.
• Experience in scheduling SSIS packages using SQL Server Agent.
• Strong knowledge of using variables and expressions in packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Excellent skills in implementing ETL Packages using DTS and SSIS 2008R2/2008/ 2005.
• Proficient in implementing all transformations available in the SSIS toolbox.
• Expert in resolving the performance issue of SSIS packages.
• Experience in Data Extraction, Transforming and Loading ETL between Homogenous and Heterogeneous System using SQL tools SSIS, DTS, Bulk Insert, and XML .
• Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert DTS utility.
• Extensive knowledge in SSAS storage, partitions and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Good Knowledge in analyzing, designing, building , testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Expert in designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Proficient in creating business critical KPIs using SQL Server Analysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Strong experiences to design, deploy, and maintain various SSRS reports in SQL Server 2008R2/2008.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2/2008/
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for Data Warehouse.
• Effective communication and interpersonal skills with the ability to focus on multiple tasks in a high pressure environment.

TECHNICAL EXPERIENCE:

MS-SQL Server 2008R2/2008/2005 SQL Server BI Development Studio BIDS , MS Visual Studio 2008/2005, SQL Server Integration Services SSIS 2008/2005, SQL server Analysis Services SSAS 2008/2005, Oracle/10g/9i/8i, MS Access, rapid application development RAD , T-SQL, C , HTML, XML, ASP, .NET, VB6.NET, Crystal Reports, Erwin 7.2/4.5/4.,MS Visio 2007/2003, ClearQuest, Autosys, DTS, Windows 7/Vista/NT/XP/2003/2009/98, Rational Clear Case Windows 2000 Advanced Server

PROFESSIONAL EXPERIENCE:

Confidential

Confidential

Role: SQL Server/SSIS/SSRS/SSAS Developer,

The Progressive Corporation is one of the largest providers of car insurance in the United States. The company also insures motorcycles, boats, RVs and commercial vehicles, and provides home insurance through select companies. The project was to create ETL processes SSIS to populate summary data structures and analysis cubes and development and performance tuning of stored procedure queries to investigate data issues and to create new reports structures for business units.

Responsibilities:

• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully extracted transformed and load data into data warehouse.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS 2012.
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
• Experienced with Rapid application development RAD to emphasize the necessity of requirement as the project progresses
• Involved in enhancing and deploying the SSIS Packages from development server to production server.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Defined report layouts including report parameters and wrote queries for drill down reports 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 2008.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

Tools Technologies:

SQL Server 2012,SQL Server BI Development Studio BIDS 2008, RAD, Oracle 9i/10g,Clear Case, Clear Quest, SQL Lite speed, Visual Source Safe, T-SQL, ASP.NET, Autosys, MS Access, Windows XP/2007 Server

Confidential

Role: SQL Server/SSIS/SSRS/SSAS Developer,

Chico's is a retail women's clothing chain founded in 1983 by a three-person operation on Sanibel Island, Florida. The company currently operates 1,084 women's clothing stores, including stores in 48 states, Washington D.C., the U.S. Virgin Islands, and Puerto Rico, operating under the Chico's, White House Black Market, and Soma Intimates brands. This project was done by building an online transaction processing system OLTP based on MS SQL Server 2008R2 and its reporting services which would provide space for growth and standardizing its forms and templates.

Responsibilities:

• Installed SQL Server 2008R2 with the latest service packs.
• Migrated Database from SQL Server 2008 to 2008R2 by using side by side migration.
• Created tables, indexes and designing constraints.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• 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.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Developed and designed cubes with calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI.
• Enhanced and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2008R2.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression MDX to access them.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Created Sub-Reports, Drill down-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Created and Maintained Database Maintenance Plans.
• Developed BizTalk to integrate the BGE HOME website to Microsoft CRM and ultimately back to constellation's corporate mainframe system, used Microsoft's eConnect as the middleware adapter between Microsoft CRM and Microsoft Great Plains. Debugged and tested complex maps, and participated in architecture group for engineering improvement to build and deployments.

Tools Technologies:

SQL server 2008R2, Windows 7. BIDS 2008R2, Windows 2000 Advanced Server, Microsoft Share Point Portal Server, Litigant Log Explorer, BizTalk Server 2009, VSS, SQL Diagnostic Manager, SQL Lite Speed, Dell Power Edge 2650, 1750, 2600.

Confidential

Role: SQL/SSIS/SSAS/SSRS Developer,

Wells Fargo Company is an American multinational banking and financial services holding company throughout the country. It is the fourth largest bank in the U.S. by assets and the largest bank by market capitalization. Our products span three distinct markets, including: content security, networking and application delivery, as well as data storage, protection and disaster recovery. As a part of development team, my role was to populate data warehouse using SQL Server Integration Service SSIS , to design, create analyze and test cubes using SQL Server Analysis Service SSAS and to create reports according to the business requirement using SQL Server Reporting Service SSRS .

Responsibilities:

• Responsible for creating logical and physical model using ERWIN.
• Built a package to transfer data between OLTP and DW databases.
• Created Views to reduce database complexities for the end users.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2.
• Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Experienced with Rapid application development RAD to emphasize the necessity of requirement as the project progresses
• Created a table to save dirty records.
• Performed 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.
• Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Set up Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Involved in Analyzing, designing, building , testing of OLAP cubes with SSAS 200R2 and in adding calculations using MDX.
• 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 Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Generated Sub-Reports, Drill down-Reports, Summary Reports, and Parameterized Reports in SSRS.

Tools Technologies:

SQL Server 2005, BIDS 2005, Integration Services 2005, RAD, Oracle 9i, Visual SourceSafe, TSQL, Autosys, Rational Clear Case, ASP.NET, Clear Quest, MS Access, Windows XP/2003 Server.

Confidential

Role: SQL Server/SSIS/SSRS/SSAS Developer,

• Jefferson Capital is an industry-leading provider of traditional and unique recovery services for consumer charged
• -off accounts. As a part of the team, the goal of the project was development of Billing and Customer Relation-
• -ship Management system CRMS as well as online multi-carrier enrollment through the enrollment program
• For the company. The project also involved creating SSIS packages for transferring the data from different systems
• and also creating the reports using SSRS 2008.

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

Role: SQL BI Developer,

JetBlue Airlines is one of the largest airline company in USA, it provides domestics as well international flight services. The project goal was to design and develop ODS Operational data store and to develop a daily basis feed for the Customer Loyalty using SSIS. Reports have been generated using SSRS BO.

Responsibilities:

• Works with Project Manager and Business Analyst to understand business requirement and created FDM for business intelligent purpose from heterogenous sources of data
• For FDM purpose was migrated data from SQL server 2008 to 2012
• Designs, develops SSIS ETL packages to load data from OLTP system, DSR Staging Database to DW
• Develops Package Configuration by using SQL Server type for making Package dynamic
• Modifies the existing SSIS packages and adds audits and alerts in case of package failure
• Writes documentation for each package with definitions, tables, and logic behind the packages
• Schedules job using SQL Server Agent for SSIS Packages and Store Procedure as per requirement
• Successfully tests all tasks in staging and stores all versions of data using team foundation server TFS
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008
• Used SSRS to generate sub-reports, drill down-, drill through-, tabular-, and parameterized reports
• Generates on-demand and scheduled reports for business analysis or management decisions using SQL Server Reporting Services
• Generates SSRS Report through SSIS Package using script component as per business requirement
• Schedules and deploys reports and uploads files to a report server catalog from the report manager
• Creates database objects like Table, Store Procedure, Triggers, Functions using T-SQL to provide structure to store data and to maintain database efficiently
• Performance monitors and tunes TSQL queries using SQL Profiler and database engine tuning advisor
• Creates Index to optimize performance of TSQL queries
• Develops and creates documents for Stored Procedures, SSIS Packages and SSRS Reports

Technical Environment:

MS SQL Server 2012/2008,2008r2, T-SQL, SSIS 2008r2, SSRS 2008r2, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2010, ER Studio 9.5, Netezza,Windows XP, MS Office 2003/2007/2010, MS Access, Business Objects