PROFESSIONAL SUMMARY:

• 7+ years experience as MS - SQL Server Developer, involved in Design, Development and Support of MS SQL Server 7.0/ 2000/2005/2008 for both OLTP and OLAP Systems.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS. Configured report subscriptions both data driven and time driven.
• Experience in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using different transformations.
• Experience in developing the applications usingT-SQL Programming (DDL, DML, and DCL). Thorough Software Development life cycle (SDLC) experience including development, designing, analysis, coding, testing and implementation.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Views, Indexes, User profiles query writing and SQL joins.
• Strong experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with T-SQL.
• Worked with T-SQL, DDL, and DML Scripts and established Relationships between Tables using Primary Keys and Foreign Keys.
• Proven ability in Performance Tuning, Query Optimization and Running Database.
• Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduled SSIS Packages. Experienced in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.
• Knowledge of Unix and shell scripting is highly preferred.
• Expertise in using different transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, merge, union all, slowly changing dimension and many more to transform the data before loading into the destination.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Adhoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• In-depth knowledge of Transact-SQL (DDL, DML, DCL) and design and normalization of the database tables.
• Knowledge on other Database like DB2, Oracle & Sybase.
• Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.
• Experienced in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Expertise in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.
• Worked in collaborative team environment with other developers, business analysts, and a project management team.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2000/20 R2, Access 2000/2003

Languages: T-SQL, PL-SQL, MDX, VB Script

Operating Systems: Windows NT/ 98/2000/2003 Server XP/Vista, UNIX, Linux

Developer Tools: SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, Visual Source Safe6.0, Index Analyzer, Visual Studio 2005/2008, BCP, TFS, Enterprise Manager, Microsoft Office SharePoint Server

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal reports

Analysis Tools: SQL Server Analysis Services (SSAS)

Data Modeling: MS Visio 2000/2007/2010, ERWIN 7.1, ERWIN 4.1

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

Sr. SQL BI (SSIS/SSRS) Developer

Responsibilities:

• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future .
• Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2005/2008.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Worked with Exception handling with error and with Try/catch.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Design databases and apply normalization to minimize data redundancy.
• Actively participate in SDLC
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
• Implemented mechanisms to accelerate query performance, including aggregations, caching, and indexed data retrieval and optimizing the design of dimension attributes, cubes, and multidimensional expression (MDX) queries.
• Built MOLAP cubes for fast data retrieval and complex calculations.
• Designed SSAS Cube and developed MDX queries for Analysis.
• Modified complex chart reports to meet Business requirements using MDX query.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
• Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL to generate multiple reports on regular basis.
• Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided, followed the change management process.

Environment: SQL Server 2008R2/2012 Enterprise Edition, SQL, T-SQL, Business Intelligent technologies SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Unix, Visual Studio 2008, MS Access, MS Excel, & Windows 2003 server.

Confidential, Richfield, MN

Sr. SQL BI Developer

Responsibilities:

• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs and deployed the cubes to the production server.
• Involved in complete life cycle of database including designing of database, populating look up data, creating stored procedure as per the front end requirement and commercial transitions, writing triggers, creating user defined functions, and creating views to simplify the complexity of data structure.
• Created complex T-SQL queries and stored procedures for the migration purpose and worked on optimization of the queries for better performance
• Used SSIS jobs and packages using the complex queries and stored procedures to do file operation and to apply business rules.
• Involved in Installation of SQL Server on Development and Production Servers, by setting up databases, users, roles and permissions.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Involved in migration from Oracle to SQL Server 2005 using SSIS while performing the ETL operations to support the data loads and transformations.
• Generated reports by passing parameters through URL Developed reports using SQL Server Reporting Services.
• Developed and Extended SSAS Cubes, Dimensions and data source viewing SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Maintained databases, performed software installations and upgrades, monitored Database Performance by implementing automated backup and database maintenance / cleanup jobs.
• Involved in running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.

Environment: SQL Server 2000/2005, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), MS SQL Analysis Services (SSAS), Windows 2000, Oracle 7.0.

Confidential, San Antonio, TX

SQL BI Developer

Responsibilities:

• Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions
• This involved index creation, index removal, index modification, file group Modifications and updating statistics in databases.
• Developed complex programs in VB Script, which connects to SFTP server to get the initial data, which is in CSV Format, with best execution plan.
• Performed data conversions from flat files into a normalized database structure.
• Optimizing Stored Procedures and Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Key role in SDLC, start from requirement gathering to implement of the application.
• Created packages to convert flat file to XML file.
• Created cubes and dimensions (SSAS) for the analysis of sales in specific areas.
• Used the SSIS Import/Export, migrated the Database such as Oracle and Access database, flat files to SQL server 2008.Used all the transformations to import and export data.
• Configured mail tasks to know the job status of SSIS packages.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
• Good understanding of SSRS with Report authoring created various weekly and monthly reports as per the requirement using Reporting Services.
• Developed Report Models for building Adhoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.

Environment: SQL server 2000/2005/2008, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle 9i,Enterprise Manager, ERWIN Data Modeler, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, SQL Server Data Tools 2010,Visual Studio 2008, MS Access, Crystal Reports.

Confidential, Hartford, CT

SQL Developer/ETL Developer

Responsibilities:

• Designing and Developing the Data SQL server integration Services packages to populate data from various data source.
• Experience in Error and Event Handling, Precedence Constraints, Break Points, Check Points, Logging.
• Designing, creation of tables, stored procedures with E-R diagrams with extensive use of Erwin.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
• Data Transfers between various servers using BCP.
• Defining and creating indexes for query optimization and revising scripts for optimal performance.
• Testing the stored procedures performance and its path of execution by using SQL Profiler.
• Created new database objects like Procedures, Functions, Packages, Indexes, Views using T-SQL.
• Creation of user Databases and installation of MS SQL Server 2005.
• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams, phasing from development to QA and to Production environment.

Environment: SQL Server 2005/2000, T-SQL, SSIS, SSRS, SSAS, Windows2003, Query Analyzer, SQL Profiler.

Confidential

MS SQL Developer

Responsibilities:

• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management, implementation of version control with Visual Source Safe.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Involved in project planning with project managers and developed technical specifications.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Defined attribute properties in a Parent Child Dimensions.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Configured Snapshot replication for reporting, user acceptance test and development servers.
• Managed Windows NT Server logins, folder permissions, and Share permissions.
• Supported front-end development team to resolve SQL related issues in Active Server Pages during server migration.

Environment: SQL Server 2000, T-SQL, ER-Win v4.0, Windows 2000, Crystal Report 8.5.