Sql Server Data

SUMMARY:

Over *+ years of IT experience in Database Design, Development and Business Intelligence using primarily Microsoft Technologies to provide services for various domains like Banking, Health care and Insurance.

Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.

Extensive experience in Data Modeling, Design, Development, Implementation & Administration of Database systems using MSSQL 2005/2008/2012/2014 for both OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS,SSIS, SSAS)

Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, Bulk Copy Program(BCP).

Experience in error handling and event handling: Precedence constraints, break points, check points and logging towards SSIS package execution in SSIS 2012/208R2/2008/2005.

Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional Modeling principles in SSAS.

Designed and developed MOLAP and ROLAP cubes with SSAS

Expert in creating various types of reports such as Complex Drill down & Drill through Reports, Matrix reports, Sub reports and Charts usingSQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

Experience in Normalization and building Referential Integrity Constraints, Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).

Experience in database programming in writing Stored procedures, User Defined Data Types,Triggers, Constraints, Indexes, CTEs and Batch Scripts using T-SQL

Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins. Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.

Experience on setting up SQL Server – Replication, Mirroring, Log Shipping, Performance Tuning, Users & Security and Backup Strategies and Issue trouble shooting

Experience in Performance Tuning, Query Optimization, Execution Plan, Client/Server Connectivity, Database consistency checks using DBCC Utilities

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio,

Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools

Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools

SQL Server Reporting Services (2005/2008 R2,2012,2014), MS Access, MS Excel

Database

MS SQL Server 2014/2012/2008/2005/2000, MS Access

Programming

T-SQL, PL-SQL, C#

Web Technologies

HTML, DHTML, XML, XSL, Java Script (Validation), CSS, PERL, VB Script,Power Pivot, Power view

Operating Systems

Windows (95/98/2000), Windows 2003/2008 Server, Windows XP, Unix/Linux.

Other Tools

MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.

PROFESSIONAL WORK EXPERIENCE:

NIH(National Institutes of Health)

Bethesda, Maryland Aug 2014 – Till date

SQL Server Developer / BI Developer

Responsibilities:

Developed stored procedures and triggers in T-SQL.

Planned, defined and designed data based on the business requirement.

Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.

Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Created SSIS process design architecting the flow of data from various sources to target.

Created various Weekly and Monthly reports showing detailed information of the claims filed, Dealers information, Warranty Information.

Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.

Reviewed and fine-tuned stored procedures and triggers before production migration.

Created various Database Objects - Tables, Indexes, Views, and Roles.

Fine-tuned database objects and server to ensure efficient data retrieval.

Assisted the front end application developers with their queries.

Writing complex SQL queries using table joins (inner and outer), temporary tables, and table variables.

Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.

Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Involved in designing reports and delivering them by any of the delivery methods like standard subscriptions, data-driven subscription, URL access etc.

Environment: MS SQL Server 2008/2012, MS Access 2000, MS SQL Analysis Services 2008, MS Excel, Visual Studio 2008, Windows Server 2003, ERWIN

Bank of America,

Charlotte, NC Oct 2012 – July2014

MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

Working on SCRUM AGILE methodology with two week iteration.

Supporting Business team for creating User story & Acceptance Criteria in JIRA

Designed and Implemented the SSIS Process to load data from FLAT FILES, EXCEL, XML Files and other Databases

Designed the ETL packages to support the incremental, historical data loads and using SSIS.

Created complex Stored Procedures, functions, triggers, views for Application using T-SQL.

Responsible for Scheduling and Maintains the Jobs in SQLAgent.

Created Multidimensional cube using SSAS and used it for SSRS reports.

Created Parameterized reports, Drill Down and Sub reports

Identifying the risks and timely communication of the risks and suggesting the solution without impacting the project timelines.

Develop and maintain the daily/weekly status report and provide the same to Higher Management

Working with QA team on the Defects assigned and Test Case review.

Monitor Job Scheduling activities and create Implementation and back out plan documents for the deployment

Design SSIS packages and setup scheduled jobs to automatically update database tables on daily basis. Perform DBA task to install SQL server, restore database, Data backup recovery and maintain database security.

Work with DBA on Batch Performance TestingProduction Support and coordinating with different teams across organizations during post implementation validations.

Participate in UAT with end users to provide them technical guidance and data set up needs.

Environment: AGILE, SQL Server 2008/2012,SSIS /20082012, SSRS, SSAS, Visual Studio, Windows 7

Sun Pharmaceuticals, Cranbury, NJ Aug 2010 – Sep 2012

SSIS/SSRS Developer\DBA

Responsibilities:

Conducted detailed analysis of each Legacy source system interface with Aegis Data warehouse (ADW) including all existing Mainframe Files and Data elements to be converted from Source system to Target Pre-staging.

Wrote Technical Design Specifications, SSIS workflows and Source to Target Mapping (STTM) spreadsheets for each legacy system interface with ADW.

Designed, developed and deployed complex SSIS packages based on STTM conversion rules for the transformation of Pre-staging data from AS400 systems to subsequent target layers in MS SQL Server 2005.

Developed Stored Procedures in T-SQL that were invoked to load Dimensions and Fact tables and also for Error handling during the SSIS process.

Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional Modeling principles in SSAS.

Designed and developed MOLAP and ROLAP cubes with SSAS.

Developed and implemented partitioning and security in cubes based on user roles.

Implemented Member properties, virtual Dimensions, Dimension custom rollups, write back, action and drill through.

Designed MDX expressions/queries for accessing cubes; involved in query structuring and performance optimization.

Implemented VB.Net script and performed testing.

Developed role based Dashboards to monitor KPIs and Ad hoc reports for Accounting and Claims using SSRS.

Developed complex canned reports using SSRS 2005 from multiple data providers in Underwriting and Claims systems, User defined objects, Aggregate Aware Objects, Charts and synchronized queries.

Conversion of Crystal Reports to Reporting Services and also existing SAS reports to Reporting Services 2005.

Optimized queries and did performance tuning using various MS SQL Server tools such as SQL Profiler, SQL Performance Monitor and Execution Plan and Index Tuning wizard.

Validated reports to ensure quality of data and conducted Meetings with business users to review reports and obtain continuous feedback.

Environment: Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS) 2005, SQL Server Integration Services (SSIS) 2005, SQL Server Analysis Services (SSAS) 2005, Query Analyzer, Microsoft SharePoint, Microsoft Visio Professional 2005, SAS, Crystal Reports.

UTL technologies, Bangalore May-2008 to Aug-2010

SQL ETL Developer

Responsibilities:

Created Data model as per User requirements and studied the source system using Star Schema and Erwin.

Transformed data for adding derived column, sorting of data, merging of data done while pulling data from SQL Server 2000 to Server 2005.

Migrated data from SQL Server 2000 to Server 2005 using Data Transformation Services (DTS)

Created Databases, Tables and triggers to validate the data to meet the specifications.

Created views and indexed views as required by front end developer for easier implementation.

Created stored procedures and functions to support data storage and manipulation.

Used linked / replicated servers and high-volume data storage.

Converted the DTS Packages into SSIS using Migration Wizards.

Involved in Testing and Debugging the Stored Procedures and T-SQL.

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer Server.

Designed models in Framework Manager and worked with parameter maps.

Involved in query tuning for increasing the query performance.

Optimized the performance of various stored procedures by redesigning T-SQL queries and changing connection and server level settings.

Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Built test scenarios and test cases (negative/positive) to validate expected outcome.

Environment: Windows Server 2003, SQL Server 2005, Visual Studio 2005, T- SQL, DTS.

Contact this candidate