SUMMARY:

• Over 8 years of extensive experience in database development and IT Solutions that include experience in design, development and implementation of complex data delivery systems using MSSQL Server 2005, MS SQL Server 2008, MS SQL Server 2008r2, MS SQL Server 2012 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, SSRS), to understand the detailed data management requirements.
• Adept at SSIS package design, development and deployment.
• 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, 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, AS400 (DB2) to SQL server using SSIS Packages.
• Excellent in High Level Design of ETL DTS Packages & 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.
• Skillful in Creating, Managing, Delivering SQL Server Reports using SSRS 2005/2008/2012.
• Experience in Migration of SSRS reports from SQL 2005 to SQL 2008.
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008/2012.
• 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 Server2005/2008 Reporting Services (SSRS).
• Versatile in BIDS (Business Intelligence Development Studio), Query Analyzer, Profiler, SQLServer Management Studio, SQL Server Integration/Analysis/ Reporting Services etc.
• 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, HTML, DHTML, HTTP, Shell Scripting.

RDBMS: SQL Server 2012/2008R2/2005/2000, 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: 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 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, MO

Sr. MS SQL Server BI Developer

Roles and 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 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.
• Designed Scorecards and Dash board reports using Micro Strategy, Performance Point.
• 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 2008R2.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Created custom SQL Server Reporting Services (SSRS) Reports to be displayed in a Microsoft SharePoint 2010 web application.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).
• CreatedStored ProceduresandT-SQLcodefor complex business logic.
• Work with project teams for upgrading SQL Server 2005 to SQL Server 2008R2.
• Used BCP command and T-SQL command to bulk copy the data from Text files to SQL Server and vice versa.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Conducted data import and export operations using the DTS wizard.
• 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), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), T-SQL, OLAP, XSLT, XML, VB.Net, C#, ASP.Net, DTS, MS Visio, Erwin.

Confidential, Minneapolis, MN

MS SQL Server BI Developer

Roles and Responsibilities:

• Developed Query for generating drill down and drill through reports in SSRS 08.
• 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.
• Migrated SQL server 2000 to SQL server 2008 R2 and DTS system to SSIS.
• ConfigureSSISPackage for run time Parameters and Configuration file.
• 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.
• 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.
• 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, JQuery, 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 process.
• 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.
• Extensively used T-SQL to create triggers and stored procedures used by the enhancements modules to update the SQL Server database.
• Enhanced and deployed the SSIS packages from development server to production server.
• Diagnosing and tuning the server optimal performance using SQL Server 2005 SQL Profiler and Database Engine Tuning Wizards.

Environment: SQL Server 2008, SQL Server Integration Services (SSIS), SSRS, Windows Server 2003, DTS, T-SQL, SQL Profiler, SQL Server Agent, Oracle, MS Excel, C, C++, XSLT, Visual Studio 2008, .Net (Asp.Net, C# .Net), Data Explorer.

Confidential, NW

SSIS Developer

Roles and Responsibilities:

• Created SQL Server Reports using SSRS 2008 as needed.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc. to sql using SSIS.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, execute package task, Transfer database task, for loop & foreach loop containers.
• Hands on experience in using different transformations like fuzzy lookup, derived column, Conditional Split, Lookup, Merge, Union All, Data conversion, Pivot & UnPivot.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications.

Environment: MS SQL Server 2008, MS SQL Server Reporting Services (SSRS), T-SQL, Windows 2008 server.

Confidential, Sunnyvale, CA

MS SQL Server Developer

Roles and Responsibilities:

• Involved in analysis, design and development of OLTP system.
• Installed and configured SQL Server 2005.
• Relocation of databases from one server to another using attach 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 2008, SQL Server Management Studio, T-SQL, SQL Server reporting services (SSRS), SQL Server Integration Services (SSIS), C#, Office, Excel.

Confidential

SQL Server Developer

Roles and Responsibilities:

• Analyzed business requirements and build logical data models that 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/2008.
• 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/2008, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS.