SUMMARY

• Over 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 with 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 the detailed data management requirements.
• Experience in developing the 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, Sqlserver 2008 new features like row constructors, Merge Statements, HierarchyID, Datetime datatypes.
• Strong experience with 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 the 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, SQLServer 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 the team with strong interpersonal and communication skills, explored and contributed the technical expertise as and when needed by the team.

TECHNICAL SKILLS

Languages: T-SQL, SQL, PL/SQL, DynamicSQL, .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

Database Design Tools and 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: and 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 with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Designing Logical and Physical Data Model with Erwin tools.
• Worked with 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 the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the 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, 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 the 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 the 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 with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Migrated SSIS Packages from SQL Server 2005 to SQL Server 2008 R2 and then 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 the data from Text files to SQL Server and vice versa
• Work with project teams for upgrading SQL Server 2005 to SQL Server 2008.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the 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 the report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with 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 the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
• Administered the SQL server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Worked with 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 with Erwin tools
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required
• Worked with Installation/Management of MS Team Foundation Server and TFS Migration processe
• 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 with Drill Down, Drill Through, Parameterized and Sub-reports using SSRS.
• Managing security roles in SQL Suite.
• Diagnosing and tuning the 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 the Data Source and defining them to build the Data Source Views for easy access.
• Developed query for generating drill down reports in SSRS 2005.
• Interacted with end users to define, implement, and maintain their reporting requirements
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Deployed the generated reports directly on the client’s workstation. Responsible for transferring the 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 the database.
• Maintained the 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 the enhancements modules to update the 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 with 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 the data and relationships between the 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 the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with 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 with 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 with business analysts to understand the 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 the performance.
• Fine-tuned Procedures, Functions and Triggers for optimum performance.
• Involved in creating SQL reports.
• Involved in the SQL Query Performance Tuning.

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