SUMMARY

• Over 8+ years of Experience in Data Warehousing and Business Intelligence applications design, development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS).
• Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2000/2005/2008.
• Expert in all areas of SQL Server development including tables, user defined functions, views, indexes, stored procedures, triggers, clustering, Facets,T - SQL, relational database models, data dictionaries, and data integrity.
• Well versed in normalization/de-normalization techniques for optimum performance in relational and dimensional database environments and building Referential Integrity Constraints.
• Efficiently used regular expressions in SQL querying.
• Leading the physical database tuning efforts involving large tables partitioning and database partitioning across multiple disks.
• Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Expertise in MS SQL Server databases with tools like IndexTuningWizard, SQLProfiler, and WindowsPerformanceMonitor for optimal Performance.
• Performed Unit Testing and debugging of SQL processes.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS).
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Expertise in Extraction, Transformation, Loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
• Experience in data migration (using tools like Bulk Insert, DTEXEC and DTEXECUI) between different homogeneous/heterogeneous systems and SQL Server.
• Expertise in creating SQL server Reports using SSRS 2005/2008.
• Expertise in creating ReportModels for building Ad hoc reports using SSRS.
• Proficiency in creating different types of reports such as Crosstabs, Conditional, Pie Chart Reports, Drill-down, Top N, Summary and Sub reports and formatting them.
• Expert in handling parameterized reports and Cascade Parameterized Reports in SSRS 2005.
• Experience converting MS Access reports to SQL Server Reporting Services.
• Knowledgeand experience in designing, developing and deploying Reports and Dashboards.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Expertise in SQL Server Analysis Services (SSAS) CUBE design, development and deploying.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Experience in Creating, Modifying Measures, DimensionsAttribute relationships and Hierarchies.
• Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes.
• Expertise in MDX to create Named Sets, Named Members, Calculated Members and other calculations.
• Experience in managing Alerts, Operators and Scheduled Jobs through SQL Server Agent.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Programming Languages: T-SQL, SQL, PL/SQL C, C++, C#

Database Application Software: MS SQL server 2012,2008/2005, Oracle 8i, 9i/10g, MS Access 97/2000

ETL Tools: SQL Server Integration Services (SSIS)

GUI: DTS Import/Export, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

Application Software: Microsoft Office, Visual Studio.

Modeling Tool: Database Designer, UML, Visio

Operating Systems: Windows Vista/XP/NT/2000.

PROFESSIONAL EXPERIENCE

Confidential, TX

Sr. SQL BI Developer

Responsibilities:

• Involved in gathering the requirements, conducted meetings with clientand documented the requirements and ITIL assessment&implementation of project.
• Created views to reduce apparent database complexity for end users and preventing sensitive columns from being selected.
• Created the indexes on columns having high selectivity and low density to speed up the execution of data retrieval queries and stored procedures.
• Modified current database by adding tables, altering referential integrity and relationships to support online system.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created Ad-hoc reports, Tabular reports, Drill down and Drill throughreports.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboardreports.
• Developed new mappings using SSISLook Up/Aggregation transformations to match the needs of the business case.
• Converted data using Derived Column, Data conversion transformation and Script task.
• Used ETL (Extraction, Transformation, Loading) from heterogeneous source systems.
• Assisted DBA in using the repository manager to give permissions to users to create new users and repositories.
• Created DTS Packages and converted DTS packages to SSIS 2012
• Created DTSX Packages to import and export data from Excel Spreadsheets, People Soft, Text files and CSV files.
• Executed the DTSX Packages by using DTExec Command.
• Designed slowly changing dimension transformations (SCD) and customized the existing mappings.
• Used SSASMDX to extract data from cubes and Created MDX script for representing Cube Calculation.
• Developed Data Mart using Star Schema. Reviewed the Current Data Mart and OLAP Cubes and Proposed Corrections and enhancements.

Environment: SQL Server 2012/2008 Enterprise Edition, Microsoft Visual Basic, Facets,VBScript, XML, Microsoft Visio, Windows 2003, IIS 5.0, MOSS, Microsoft Reporting Service, BO XI R2.

Confidential, VA

Software Engineer

Responsibilities:

• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for application.
• Analyzed the project database requirements from the user.
• Maintained Security Role and Database Users.
• Transformed the complex business logic and calculations into coding.
• Built drill down reports, and also parameterized reports using SSRS.
• Created standard Reports and Cross Tab Reports and Drill Through reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created Cross-Tab, Drill-down and Sub-Report using RDL.
• Developed SSIS project for transferring the data.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source (Oracle), Facets,Excel Spreadsheet to SQL Server 2008.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAPdatabases.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed new mappings using SSISLook Up/Aggregation transformations to match the needs of the business case.
• Created SQL Server Analysis Projects using MS SQL Server 2008.
• Created the Cubes and Dimensions.
• Defined relationships between Measure groups and Dimensions.
• Implemented the calculations to aggregate physical measures.
• Used SSASMDX to extract data from cubes and Created MDX script for representing cubecalculations.
• Identified and Defined Key Performance Indicators in SSAS 2008.

Environment: MS SQL Server 2012/2008 Enterprise Edition, MS Analysis Services 2008, MS Access, SSIS, Erwin 4.1, Windows XP Professional

Confidential, MN

SQL BI Developer

Responsibilities:

• Actively designed the database to fasten certain daily jobs and some stored procedures.
• Wrote various T-SQL stored procedures and Triggers to carry out various tasks.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Created many temporary objects like CTE’s.
• Created and executed SQL Server Integration Service(SSIS) packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Configured Server for sending automatic mails to respective people when a SSIS process failure or success.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, OLEDB to SQL Server.
• Implemented error handling and roll back process in ETL load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Responsible for performing T-SQL tuning and optimizing queries for reports which take longer time in execution with SQL Server 2008.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008.
• Generated various reports with drilldowns, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Created OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS.
• Involved in creating cubes in Business Intelligence Development Studio (BIDS), deploying them on the server and processing the OLAP cubes to generate aggregate data for faster querying.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Involved in developing logical and physical modeling of the database using Erwin.
• Provided 24/7 production support for the production database and also to the code deployed into the production environment.

Environment: SQL Server 2008/2005, DTS, SSIS, SSRS, SQL Server OLAP 2008,BCP, Reporting Services 2008, Facets, T-SQL, MS Access, Windows XP/2003 Server.

Confidential, Charlotte, NC

SQL Server Developer

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, Facets,indexes and views, user security management.
• 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.
• Managed database partitioning across multiple disks.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.
• Was Performing Administrative activities like Maintenance of a DatabasePartitioning, Indexing Large Databases, Space Management, Database Tuning, Database Backup & Recovery.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Responsible for Day-to-day activities like taking backup (or scheduling the backups daily/weekly/monthly for database or transaction log) on disk and restoring the databases and transaction log on production/development servers as per requirement.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Involved in analysis and design of disaster recovery strategies with business managers to meet the business requirements.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Written complex T-SQL queries and Database triggers.
• Created indexes and was involved in Performance Monitoring.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Scheduledreports 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).
• Created Parameterizedreports and linked reports using Bookmark links and Hyperlinks.
• Designed various packages to meet the business requirements to extract, transform and load the data into various databases using SSIS.

Environment: SQLServer 2008/2005 Enterprise Edition, MS-Access, MS Excel, XML, TSQL, Stored Procedures, Triggers, Views, Crystal Reports and Visual SourceSafe

Confidential, Atlanta, GA

SQL Server Developer/Report Developer

Responsibilities:

• Worked as a SQL developer on MS SQL Server 2000 (using T-SQL, scripts, stored procedures and views).
• Developed complex T-SQL code for the application.
• Involved in writing scripts for the client requirements for generating reports.
• Looked at the reports and fixed bugs in stored procedures.
• Developed complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Design and implementation of stored procedures and triggers for automating tasks.
• Generated reports usingSSRS.
• Documented the flow of the project.

Environment: SQL Server 2008/2005, Query Analyzer, Enterprise manager, Crystal Reports, PARIS, Windows XP

Confidential

SQL Server Developer

Responsibilities:

• Determined the MS SQL Server 2000 installation options.
• Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server and implemented different security modes.
• Created some complex queries and stored procedures in T-SQL.
• Involved in Creating Database Objects like Tables, Stored Procedures and Views.
• Created views consisting of computed columns to facilitate easy user interface.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Involved in Job scheduling and alerts.
• Designed and implemented user login and security.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.

Environment: MS SQL Server 2005 Enterprise Edition, Enterprise manager, MS Access 2000 & Windows NT platform, Reporting Services, DTS, Facets, Business Objects 4.0/6.5, Windows Active Directory.