SUMMARY

• Over 7+ 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 towardsSSISpackage execution inSSIS2012/208R 2/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 ServerReporting 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 writingStored 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 theSQL ServerPerformance.
• Experience on setting upSQL 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 ServerManagement StudioBusiness Intelligence Development Studio, SQL Profiler,SQL ServerAnalysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import,SQL ServerIntegration Service (SSIS)

Reporting Tools: SQL ServerReporting Services (2005/2008 R2,2012,2014), MS Access, MS Excel

Database: MSSQL 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 EXPERIENCE

Confidential, Bethesda, Maryland

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 tablejoins (inner and outer), temporary tables, and table variables.
• Created database maintenance planner for the performance ofSQLServer, 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 indesigning reportsanddeliveringthem by any of the delivery methods likestandard subscriptions,data-driven subscription,URL accessetc.

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

Confidential, Charlotte, NC

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 theSSISProcess to load data from FLAT FILES, EXCEL, XML Files and other Databases
• Designed the ETL packages to support the incremental, historical data loads and usingSSIS.
• Created complex Stored Procedures, functions, triggers, views for Application using T-SQL.
• Responsible for Scheduling and Maintains the Jobs in SQLAgent.
• Created Multidimensional cube usingSSASand used it forSSRSreports.
• 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
• DesignSSISpackages and setup scheduled jobs to automatically update database tables on daily basis. PerformDBAtask to installSQL 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 Server2008/2012, SSIS/20082012,SSRS,SSAS, Visual Studio, Windows 7

Confidential, Cranbury, NJ

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.

Confidential

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 fromSQL Server2000 to Server 2005.
• Migrated data fromSQL Server2000 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.
• Createdstored proceduresand functions to support data storage and manipulation.
• Used linked / replicated servers and high-volume data storage.
• Converted the DTS Packages intoSSISusing Migration Wizards.
• Involved in Testing and Debugging theStored Proceduresand T-SQL.
• Worked on Client/Server tools likeSQL ServerEnterprise 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 variousstored proceduresby redesigning T-SQL queries and changing connection and server level settings.
• Created Database Maintenance Planner for the Performance ofSQL 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 Server2005, Visual Studio 2005, T- SQL, DTS.