SUMMARY

• Over Seven (7+) years of extensive experience in database development and IT Solutions dat include experience in design, development and implementation of complex data delivery systems using MSSQL Server 2012/2008 R2/2008/2005 in production, Test, Development and Cluster Server Environments.
• Hands - on experience wif Erwin, MS Visio modeling tools and strong knowledge of Relational Database modeling and Dimensional modeling concepts.
• Worked on Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Analyze business and technical requirements data warehouse data models (SSIS, SSAS SSRS), to understand teh detailed data management requirements.
• Experience in developing teh applications using T-SQL Programming (DDL, DML, and DCL).
• Experienced T-SQL programming skills like creating Stored Procedures, Functions, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, and Cursors.
• Experienced in implementing CTE, anchor Recursive CTE, SQL Server 2008 new features like row constructors, Merge Statements, HierarchyID, Date time datatypes.
• Strong experience wif SSIS ETL tool in Mapping, Transformations, Expressions, lookups and Aggregations.
• Migrating data from oracle to SQL Server using PL/SQL queries.
• Excellent in High Level Design of ETL SSIS(DTSX) Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in creating Jobs, Alerts, SQL Server Agent, and scheduled SSIS Packages.
• Designed and created cubes in SSAS. Created sophisticated calculated members using MDX queries, designed and created aggregations to speed up queries and improve performance in SSAS.
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Skillful in Creating, Managing, Delivering SQL Server Reports using SSRS 2012/2008/2005
• Experience in Migration of SSRS reports from SQL 2005 to SQL 2008 R2.
• Experience in using variables, expressions, functions for teh reports and in handling Parameterized reports in SSRS 2012/2008/2005
• Created several organization sites using SharePoint Portal Server 2007 as per client requirements.
• Experienced in developing Custom Report and different types of Chat Reports, Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server 2012/2008/2005 Reporting Services (SSRS).
• Versatile in BIDS (Business Intelligence Development Studio), Query Analyzer, Profiler, SQL Server Management Studio, SQL Server Integration/Analysis/ Reporting Services etc.
• Good knowledge on C #, ASP.NET, VB.NET, HTML, VBScript, JavaScript, XML.
• Hands on experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production.
• As a key player in teh team wif strong interpersonal and communication skills, explored and contributed teh technical expertise as and when needed by teh team.

TECHNICAL SKILLS

Languages: T-SQL, SQL, PL/SQL, Dynamic SQL, .NET Framework, C#, ASP.NET, VBScript, XML, VB.NET, HTML, DHTML, HTTP, Shell Scripting

RDBMS: SQL Server 2012/2008/2005 , Oracle 11g/10g/9i/8i, Sybase Server, IBM DB2 UDB 8.2/8.0, MS Visual Source Safe 2005, and MS Access 2003/2000/97

DB Design Tools & Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modelling, FACT & Dimensions tables, Physical & logical data modelling and De-normalization

DWH / BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio

Tools: & Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .NET, Microsoft Management Console, Visual Source Safe 6.0, DTSX, Business Intelligence Development Studio (BIDS), Crystal Reports, Web Services, SOAP

Operating Systems: UNIX, Windows NT/XP/2003/2000, Windows 9x and MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Orangeburg, NY

SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

• Working wif various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Designing Logical and Physical Data Model wif Erwin tools.
• Worked wif installing, designing and managing MS SQL Server 2012/2008 R2.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Administering teh MS SQL Server by creating user logins wif appropriate roles, monitoring teh user accounts, creation of groups, granting teh privileges to users and groups.
• Created SSIS packages to populate data from various data sources like oracle using PL/SQL queries.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Reviewed Reporting Requirements and Created Aggregated Tables and Stored Procedures for teh Dashboard for Health Management systems.
• Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Designed and developed various custom defined reports using SQL Server Reporting Services (SSRS) and deployed them on SharePoint 2007 Portal.
• Hands on report writing scripts altering teh colors and backgrounds needed.
• Running DBCC consistency checks and fixing data corruption in application databases
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Worked wif Meta-Data Driven SSIS Packages to pull teh data from different Sources and load to Data mart.
• Migrated SSIS Packages from SQL Server 2005 to SQL Server 2008 R2 and tan to 2012.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Creates custom SQL Server Reporting Services (SSRS) Reports to be displayed in a Microsoft SharePoint 2010 web application.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Used BCP command and T-SQL command to bulk copy teh data from Text files to SQL Server and vice versa
• Work wif project teams for upgrading SQL Server 2005 to SQL Server 2008.
• Involved in fine Tuning and Performance and Query optimization of teh Database as required by teh application
• Database and Transaction log backups & restoration, backing up user databases and restoring them whenever necessary.

Environment: MS SQL Server 2012/2008 R2, SQL Server Reporting Services (SSRS 2012/2008 R2 ), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), OLAP, XSLT, XML, VB.NET, C#, ASP.NET, MDX, DTS, MS Visio, Erwin

Confidential, Minneapolis, MN

SQL Server SSIS/SSRS Developer

Responsibilities:

• Developed Queries for generating drill down and drill through reports in SSRS 2008 R2
• Uploaded reports on to teh report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for teh reports. Designed and implemented stylish report layouts.
• Identified and worked wif Parameters for parameterized reports in SSRS 2008 R2
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created parameterized, drill down, drill through and aggregation type of reports, charts and dashboards in SSRS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure teh completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
• Administered teh SQL server by creating user logins, dropping and locking teh logins, monitoring teh user accounts, creating groups, granting privileges to users and groups.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Worked wif Application Developers to design databases and tables to support development activities and achieve optimal efficiency
• Designed and developed web user controls, master pages, validation controls, CSS files using C#.NET, VB.NET, XML, HTML and ASP.NET 2.0/3.5.
• Designing Logical and Physical Data Model wif Erwin tools
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc. as required
• Worked wif Installation/Management of MS Team Foundation Server and TFS Migration processes
• Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS).
• Designed and deployed reports wif Drill Down, Drill Through, Parameterized and Sub-reports using SSRS.
• Managing security roles in SQL Suite.
• Diagnosing and tuning teh server optimal performance using SQL Server 2005 SQL Profiler and Database Engine Tuning Wizards.

Environment: SQL Server 2012/2008 R2, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SSRS, Windows Server 2003, T-SQL, SQL Profiler, SQL Server Agent, Oracle, MS Excel, XSLT, Visual Studio 2010, Asp.NET, VB.NET, C# .NET

Confidential, Boca Raton, FL

MS SQL Server Developer/SSRS/SSIS

Responsibilities:

• Created SQL Server Reports using SSRS 2005 as needed.
• Identified teh Data Source and defining them to build teh Data Source Views for easy access.
• Developed query for generating drill down reports in SSRS 2005.
• Interacted wif end users to define, implement, and maintain their reporting requirements
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Identified and worked wif Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling teh subscription reports wif teh subscription report wizard.
• Created star schema in SSAS and developed SSRS reports based on teh cubes.
• Deployed teh generated reports directly on teh client’s workstation. Responsible for transferring teh data using SSIS packages.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Implemented different types of constraints on tables for consistency. Managed index, statistics and optimizing queries by using execution plan for tuning teh database.
• Maintained teh physical database by monitoring performance and integrity maximum efficiency using SQL Profiler.
• Generated Sales Ranking reports using SQL Server Reporting Services for different subjects
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2005.

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services 2005/2008, Windows 2003 Server

Confidential, Jersey City, NJ

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Involved in analysis, design and development of OLTP system.
• Installed and configured SQL Server 2005/2008.
• Relocation of databases from one server to another using attaches and detach databases.
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
• Designed and developed stored procedures, triggers and user defined functions in SQL Server for OLTP system.
• Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SQL Server Integration Services.
• DDL Scripts for generating Tables, Views, Functions.
• Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
• Scheduling Jobs, Backups and Restore database
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Extensively used T-SQL to create triggers and stored procedures used by teh enhancements modules to update teh SQL Server database.
• Performance tuning, query optimization and execution plan of queries for better performance.
• Build efficient SSIS packages for processing fact and dimension tables wif complex transforms and type 1 and type 2 changes.
• SSRS installation and report server configuration.
• Configured IIS and Deployed Reports and Analysis Project in to server.
• Extended Data to XML and Excel Spread Sheet.
• Involved in Capturing Requirements, Preparing Business Blocks, UML Use Cases, Collaboration Sequence, and Activity diagrams, defined and Managed as Part of CMM
• Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.

Environment: Visual Studio 2005, SQL Server Management Studio 2005/2008, T-SQL Stored Procedures, SQL Server reporting services (SSRS), SQL Server Integration Services (SSIS), C#, VB.NET, Office, Excel

Confidential

SQL Server Developer

Responsibilities:

• Analyzed business requirements and build logical data models dat describe all teh data and relationships between teh data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
• Validated change requests and made appropriate recommendations. Standardized teh implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules wifin development team.
• Modified database structures as directed by developers for test/develop environments and assist wif coding, design and performance tuning.
• Managed user access.
• Created and managed new security accounts. Backup and restore databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Assisted wif various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005, T-SQL, BIDS, SSRS, MS-Office, MS-Excel, VSS

Confidential

SQL Server Developer

Responsibilities:

• Interacted wif business analysts to understand teh business requirements.
• Created logical and physical database design using Erwin.
• Wrote complex T-SQL queries for data extraction.
• Migration of data from text files to SQL Server 2005 using BCP and DTSX packages.
• Created T-SQL triggers and Stored procedures encompassing business rules.
• Wrote DTS packages to move data between production, staging and QA environment.
• Programmed SQL Server 2005 Reporting Services using Microsoft Visual Studio 2003.
• Uploaded SQL Server 2005 Reporting Services RDL files to SQL Server 2005.
• Created database objects for improving teh performance.
• Fine-tuned Procedures, Functions and Triggers for optimum performance.
• Involved in creating SQL reports.
• Involved in teh SQL Query Performance Tuning.

Environment: SQL Server 2000/2005, Windows NT, Access 2000, Query Analyzer, Enterprise Manager, Erwin, Business Intelligence studio(BIDS)