SUMMARY:

• Over 7+ years of experience in the IT industry as a MS SQL Server Developer in Health Care, Banking, Insurance and Financial Domains.
• Extensive experience in MS SQL Server 2008/2008 R2/2012 wif Business Intelligence in MS SQL Server Reporting Services(SSRS), MS SQL Server Integration Services(SSIS) and MS SQL Server Analysis Services(SSAS).
• Expert in developing T - SQL (DML, DDL) statements using dynamically generated SQL.
• Efficient in Database Upgrades and Migrations from MS SQL Server 2005 to MS SQL Server 2008/2008 R2/2012.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS utility.
• Experience in Designing and Building the Dimensions and cubes wif star schema using SQL server Analysis Services (SSAS).
• Proficient in manually transferring DTS packages to SSIS packages using SSIS 2012.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL Server.
• Extensive noledge in design of logical and physical data modeling using Erwin tool.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user defined functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Expert in designing high level ETL architecture for overall data transfer from the OLTP to OLAP wif the halp of SSIS.
• Proficient in working wif both transactional (OLTP) and analytical (OLAP) environments.
• Expert in preparing ETL mapping process and maintaining mapping documents.
• Expert in creating Dashboard Using Share Point.
• Proficient in writing parameterized Queries for generating reports, formatting report layouts, sub reports using global variables, expressions, functions, sorting the data.
• Defining data source and subtotals for the reports using SSRS 2012.
• Experienced in manual, automation, integration and performance testing.
• Expert in Data Integrity constraints, performance Tuning, Repairing dead locks, Query Optimization and Validation issues.
• Knowledge in writing MDX Queries for querying data from a Multidimensional Warehouse.
• Experience in working on administration tasks such as data loading, batch jobs, data unloading, user and application table management, upgrades, creating databases/file groups/ files/ transaction logs.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Highly motivated, team player and self-starter wif excellent communication skills.

TECHNICAL SKILLS:

• MS SQL Server 2005/2008/2008 R2/2012, MS SSRS 2005/2008/2008 R2/2012
• MS SSAS 2005/2008/2008 R2/2012, MS SSIS Server 2005/2008/2008 R2/2012(SSIS)/DTS
• ASP.Net 3.0/2.0/1.1/3.5, Microsoft Visual Studio 2012/2008, C#, .Net, VB.Net, ASP 3.0, VB 6.0, C
• C++, T-SQL. ADO.NET, ADO, ODBC, ERWIN 4.0/4.1/4.2, OLE DB
• ORACLE 10g/9i, DB2, MS Access, MS office, Windows NT/ 2000 Server/ Vista/XP.

PROFESSIONAL EXPERIENCE:

Confidential, Fremont, CA

SQL Server Developer/ BI Developer

Responsibilities:

• Requirements gathering from the business users, created technical specification documents.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Involved in data modeling to design database.
• Modify SQL queries to upgrade SQL Server performance using SQL Server 2008 R2/2012.
• Migrated reports from MS SQL Server Reporting services 2008 R2 to 2012.
• Schedule the DTS packages to keep extracting the data from OLTP at specific time intervals.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2008 R2 & 2012(SSAS).
• Supported OLAP team to provide data from SQL Servers and generating reports.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Used SQL Server Agent for scheduling jobs and alerts.
• Optimized queries using SQL Profiler and Database engine tuning advisor.
• Helped QA personnel in deploying and testing the application.

Environment: SQL Server 2008 R2/2012, SSRS 2008 R2/2012, SSIS 2008 R2/2012, SSAS 2008 R2/2012, ASP.NET, Visual Studio 2008,Windows XP, XML, MS Office, T-SQL and Oracle 10g.

Confidential, Irvine, CA

MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Requirements gathering from the business users, created technical specification documents.
• Utilized new reporting services SSRS 2008 to design and review the new report standards to ensure optimized performance.
• For data Warehouse, planned, designed and documented the optimum usage of space requirements and distribution of space.
• Migrated reports from MS SQL Server Reporting services .
• Wrote T-SQL queries, Store Procedures, User defined functions, Views and used them to build packages.
• Designed and developed packages for a data warehousing and Data Migrations projects using Integration services (SSIS) on MS SQL Server 2012.
• Extracted the data from Oracle, Flat files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehousing using SSIS (SQL Server 2012).
• Created/modified a variety of parameterized, drill down, pie charts, bar graphs, matrix, and sub reports using SSRS 2008/2012 using data from a variety of sources.
• Scheduled the reports on capacity levels of different servers to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Added/modified Users, Groups, folders and rights.
• Published and scheduled the reports in different formats (Email, Public folder etc.).
• Managed all indexing, debugging, optimization and performance tuning using T-SQL.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Created/modified SQL Joins, sub-queries and other T-SQL code to implement business rules.

Environment: MS SQL Server 2008 R2/2012, SSRS 2008 R2/2012, SSIS 2008 R2/2012, SSIS 2008 R2/2012, SSMS. Crystal reports XI, T-SQL, Oracle 10g, Access and Excel.

Confidential, Chadds ford, PA

MS SQL Server/BI Developer

Responsibilities:

• Analyzed business and technical requirements, including logical data model according to the requirements and developed scripts for the creation of the physical database schema(s), data security and protection, and archiving data.
• Participated triggers and stored procedures and enforced business rules via checks and constraints.
• Created SSIS package to migrate slowly changing dimensions.
• Incorporated business logic in SSIS while converting from MS Access and Text to SQL Server and created new database/tables to put in the extracted data and rebuilding the relationship.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL.
• Used SSIS in building high performance data integration solutions, including extraction, transformation and load (ETL) package for data warehousing.
• Used SQL server reporting services (SSRS) to deliver enterprise, Web-enabled reports that draw content from a variety of data sources.
• Used exception handling extensively to avoid circumstances leading to abnormal program termination.

Environment: SQL Server 2008, SSIS, SSRS, SSAS, .Net, ASP.NET(2.0), T-SQL, ETL,SQL Profiler, Oracle 10g, DB2, Active X, .net, MS Access, Windows 2000 Server.

Confidential, NY

MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Involved in gathering the report specifications by interacting wif the business users.
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Incremental load wif several Data flow tasks and Control Flow Tasks using SSIS.
• Expert in handling Profit & Loss and risk management issues.
• Experienced in creating jobs, Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Planned, defined and designed data based on the business requirement.
• Created parameterized reports and ado reports using Report builder for the users and management.
• Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Environment: MS SQL Server 2008, SSRS 2008, SSIS 2008, T-SQL, VB Script, MS Access, Excel, SQL Profiler, Erwin 4.0 Windows 2003.

Confidential

Junior level SQL developer

Responsibilities:

• Installation, configuration of MS SQL Server 2005 for development and testing purpose.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
• Created/Managed DTS packages for Importing and exporting the data.
• Involved in troubleshooting the dead lock scenarios.
• Planning, implementing and troubleshooting Replication.
• Responsible for developing automation of maintenance jobs, tuning SQL Server locks and indexes configurations.
• Administering SQL Server security, SQL Server automatic e-mail notification, SQL Server backup strategy and automation.
• Creating/deleting/modifying user’s login, groups, roles, checking for database consistency running DBCC consistency checks, if generated, fixing data corruption in application databases.

Environment: Windows 2000, MS SQL Server 2005, SQL Server 2005 Analysis Services, MS access HTML.