SUMMARY

• Overall 6+ years of experience years of IT, in the use and development, design, support and migrate of Microsoft SQL Server 2000/2005/2008 R2/2012 and SQL Server Business Intelligence tools (SSIS/SSRS/SSAS).
• Extensive experience as SQL Server Developer in utilizing triggers, cursors, functions and stored procedures.
• Expertise in Database development for OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling.
• Experience in creating Views, Constraints, Triggers, joins, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation.
• Proficient in writing complex T - SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH, SQL programming, physical, logical database design and SQL Performance tuning.
• Experience in Query tuning and performance tuning using Clustered and Non-Clustered indexes on tables for faster query retrieval.
• Extensively worked on Normalized and de-normalized database design and RDBMS concepts to design Relational Database model as per Business requirement.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager, Ad-hoc reports, data driven subscription reports by using Report Builder.
• Experience in developing Dashboard, Parameterized Reports, linked reports, Sub reports, Create complex Reports (ex: drill down reports using different objects), drill through reports using SSRS.
• Experience in Migrating databases from SQL 2008 R2 to SQL 2012.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, and DB2 to MS SQL Server by using Import Export Wizard, DTS, SSIS, and Bulk Insert utilities.
• Expertise in designing SSIS packages to import and transform data between databases and external data sources.
• Involved in migration of DTS Packages (2005) to SSIS (2008) and troubleshoot migration issues.
• Worked on administration tasks such as creating logins, user mapping, batch jobs, backup and Recovery, Maintenance tasks, table management, upgrades, creating databases/File groups/files/Transaction logs.
• Experience in using Data Modeling Tools Microsoft Visio and Erwin, designing and developing periodic and on-demand reports using Crystal Reports and Report Builder.
• Strong analytical, organizational, presentation and problem solving skills, as well as excellent inter-personal and communication skills.
• Ability to quickly comprehend the unique requirements of each customer to formulate effective solutions in a deadline oriented environment.
• Excellent track record as a team player with effective communication skills.
• Strong writing and documentation skills for the management and development.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008R 2/2008/2005/2000, MS Access, oracle 8i/9i/10g

Languages: SQL, T-SQL, PL/SQL

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard

Operating Systems: Windows Server 2008/2003/2000, UNIX, Linux

ETL: SSIS, BCP, Import/Export Wizard, BI Studio

Data Modeling: Erwin Data modeler, ER Studio, MS Visio

OLAP Tools: SSAS, MS Excel

Reporting Tools: Visual Studio, Report Builder, SSRS, Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL / BI Developer

Responsibilities:

• Installed and Configured SQL Server 2012 successfully.
• Expertise in Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Successfully implemented indexes on tables for optimum performance.
• 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.
• Created SSIS packages to import data from MS Access, Excel to SQL 2008 R2.
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Developed scripts to migrate data and the database objects to/from multiple sources.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Involved in creating front end user interface to allow customers to interact with the application using C# objects and HTML.
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data.
• Proficiently created Reports based on the requirements using SSRS 2008/2012.
• Identified the database tables for defining the queries for the Reports.
• Defined parameters for parameterized Reports.
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard.
• Excelled in deployment and generation of Reports.
• Migrated data from different data sources.
• Converted few reports from crystal reports to SSRS.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Configured replication servers and transactional replication between production and standby server for high availability / disaster recovery.
• Held responsibility for database maintenance plans.
• Actively involved in gathering and analyzing stakeholders requirements.
• Created alerts, notifications, and e-mails for system errors.

Environment: SQL Server 2008 R2/2012, SSIS,SSRS, Query Analyzer, Database Engine tuning wizard, MS Access, MS Excel, ERWIN, Windows Server 2008R2/2012

Confidential, Atlanta, GA

SQL / BI Developer

Responsibilities:

• Involved in system analysis & design of the Enterprise data warehouse implementation, Requirements gathering and understanding the business flow.
• Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.
• Creating Index, Views, Complex Stored Procedures, Triggers, Cursors and appropriate User defined functions to implement the business logic.
• Creation of database tables and procedures to update and clean the old data.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS and also used BCP and Bulk Insert.
• Created PL/SQL code to validate and convert the invoice data from non-oracle data format to Oracle databases.
• Designed dashboards, including scorecards and reporting with the Dashboard Designer delivered via MOSS (Microsoft Office SharePoint Server).
• Involved in data modeling for the application and created ER diagram using Erwin.
• Created, Maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, and Master Reports & Parameterized Reports using SQL Server Reporting Services SSIS.
• Proficient on and designing Data Mart and Data Warehouse using Erwin in Star and Snowflake Schemas.
• Helped Database administrators with power shell in building robust administration scripts.
• Responsible for support of MOLAP structures using Analysis Services 2008 and reporting structures in MS EXCEL and Reporting Services 2008.
• Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to SQL Server 2008R2.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created document for Self-Service Deployment and Execution process for SSIS packages
• Modifying existing Sybase stored procedures to make them ready for Sybase IQ data warehousing use.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.

Environment: Microsoft SQL Server 2008R2/2008/2005, MS Access, SSIS, SSRS, PL/SQL, Query Analyzer,, ERWIN, Windows server 2003/2008, DTS, T-SQL, Oracle 10g, SQL Profiler, DTS

Confidential, Franklin, TN

SQL / BI Developer

Responsibilities:

• Requirements gathering, Analysis and Design of all the client requirements.
• Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SSIS.
• Involved in business requirement gathering and created functional/technical specification documents.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Worked with the Data modeler in designing the Schema using Erwin with proper relationships defined.
• Helped the BA team design the Business Analysis reports using Crystal reports
• Designed the complex views that we can use from the source to populate the warehouse with required columns.
• Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2005/2008 across various environments.
• Creating large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2005/2008.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries, Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
• Helped offshore team on daily calls to design SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Designed Reports in SSRS, with several prompts and built ad-hoc reports in Report Manager.
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Worked with Data mapping, High level design and Detailed design documents.
• Applied Security in Packages to safe guard sensitive data, and used log providers to log events.
• Performed ETL Auditing to maintain Loads report.
• Used Log providers to log error into the table and send the report to the concerned department.
• Used Configuration files to deploy and install a package from one environment to another.
• Used and set the threshold value to count for errors before failing the package.
• Worked on SSRS with expressions and designing of reports.
• Extracted data from flat files and from RDBS sources like Oracle and SQL Server.

Environment: Windows 2003/2008, SSIS, SSRS, Oracle 9i/ 10g, SQL Server 2005/2008, MS Access, T-SQL, PL/ SQL, Crystal Reports

Confidential, Pittsburgh, PA

SQL Server Developer

Responsibilities:

• Created and maintained Databases for development, testing and production environments.
• Created Database Objects Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, and Constraints.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed complex T-SQL code for the application.
• Used various transforms in SSIS to load data from flat files to the SQL databases.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Created Views, Parameterized Views, Partitioned Views and Indexed Views.
• Created and maintained logins, roles and permissions on the SQL instances and databases and provided required privileges according to the user's requirements.
• Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Constraints.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Involved in designing data marts and giving suggestions for the application needs.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
• Generated different types of SSRS reports using Visual Studio as per the requirements.
• Expertise in report modifications like sorting, grouping and adding rich content to the report as per the user needs.
• Involved in Database Migration from SQL Server 2005 to SQL Server 2008.
• Migration of Databases Using Generate Script Wizard.
• Involved in day to day activities like writing the scripts and loading into SVN.
• Created Logins and Permissions to the developers as per their requirement.
• Involved in migrating users and roles from one database to another database.

Environment: SQL Server 2005/2008, SSIS,SSRS, Query Analyzer, Database Engine tuning wizard, MS Access, MS Excel, MS Visio, Windows Server 2003.