SUMMARY

• Over 5 years of IT experience in Capital Markets Banking / Financials/ Mortgages, Healthcare and Retail sectors as a SQL server Developer that includes Database Design and Development of SQL Server 2000/2005/2008/2008 R 2/2012/2014.
• Involved in Database Design,Data modeling,Development, Implementation, ETL and Reporting in SQL Server 2000/2005/2008/2008 R 2/2012/2014.
• Extensive experience in Database development for bothOLTP (Batch Processing, Online Processing)&OLAP Systems (SSRS, SSIS, SSAS) using SQL Server 2000/2005/2008/2008 R 2/2012/2014.
• Expert in providing Enterprise Reporting solutionsusing SSRS 2000/2005/2008/2008 R2/2012/2014, Crystal Reports, Performance Point Server, ProClarity and SharePoint Services.
• Extensive ETL experience using DTS/SSIS forData Extractions, Transformations and Loads.
• Expertise in developing application using.NET, C#, SQL Server.
• Data Modeling - Hands on Data warehousing and Data Modeling tools like Erwin 4.0,Visio 5.0/ 2002.
• Expertise in Oracle 9i/10g database.
• Developed & supported various mission critical Client Server applications by handling Database requests for various application development teams involving complex business logic, functionality.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
• Experience in Diagnosing and Troubleshooting performance issues in SQL Server Databases using DMV’s and DTA.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience in monitoring MS SQL Server databases and performance tuning using IndexTuningWizard, SQLProfiler, and WindowsPerformanceMonitor for optimal Performance.
• Has very good knowledge in transactional replication, merge replication, and snapshot replication.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Test & Deploy code across various SDLC Environments like DEV, TEST, UA/UT, and Production.
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in creating ReportModels for building Ad hoc reports using SSRS.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Expertise in Report writer.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Expertise in upgrading or migrating Analysis Services.
• Proficient in building Star schema and Snow Flake schema depending on business requirements.
• Proficient in working with Multidimensional Expressions (MDX).
• Expertise in UDM and Data Mining objects.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Expertise in creating Perspectives, Partitions and DesignAggregations in cubes using SSAS.
• Excellent technical, communication and interpersonal skills with very good troubleshooting and problem solving skills.
• Ability to work on multiple tasks in a fast paced environment independently and in a team.

TECHNICAL SKILLS

Operating System: Windows NT/98/2000/XP/2003 server

Languages: Pascal, C++, Visual Basic 6.0. VB.Net, T-SQL, PL/SQL, Visual Studio 2003/2005

Tools: DTS, SSIS,SSRS,SSAS

DATABASE: MS Access, MS SQL Server 7.0/2000/ 2005/2008/2012/2014 , Oracle8i/9i

Tools: /Utility: Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler

Software: MS Office, Visio, Adobe Photoshop, MS Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services 2005/2008/2012/2014 , Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, Arlington VA

Sr SQL Server BI Developer, SSRS/ SSIS/ SSAS Developer

Responsibilities:

• Developed and optimized database structures, stored procedures, views, and user-defined functions for the Application.
• Design and create SQL Database, tables, indexes, and views.
• Responsible for Query optimization and Performance tuning. Performing query plans and making sure each and every query is using appropriate useful indexes.
• Responsible for gathering/refining requirements from the customer for developing reports.
• Developed physical data models and create DDL scripts to create database schema and database objects.
• Created SQL Server Reports using SSRS 2012.
• Developed Query for generating drill down and drill through reports in SSRS 2012.
• Uploaded reports on to the report manager and organized them in folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the SSRS reports. Designed and implemented stylish report layouts.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS process design architecting the flow of data from various sources to target.
• Configured SSIS packages using Packageconfiguration wizard to allow package run on different environments.
• Worked with Claims, Members, Providers and Authorizations for loading the data into SQL server using SSIS packages.
• Efficiently implemented Error handling in SSIS
• Created SSIS packages to load data from various data sources Oracle,DB2 and Flat files
• Consolidate the data load into ODS using SSIS
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS.
• Involved in writing MDX queries.
• Created Cubes from which data can be retrieved rapidly by enterprise information consumers
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Worked in Creating partitions and Designing various storage modes to increase the performance of a cube using SSAS.
• Provided day-to-day administration tasks like space and log management.
• Developed Backup and Recovery Strategies, and Disaster Recovery Plan.
• Configured Snapshot replication for reporting, user acceptance test and development servers.

Environment: Windows 2008 R 2/2008/2012/2014 , Integration Services, Analysis Services, Reporting Services, SQL Server Data Tools, Team Foundation Server, ASP.Net.

Confidential, Overland Park, KS

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications for building the Global Enterprise Data warehouse.
• Worked closely with end users in designing and creating the Global Enterprise Data warehouse.
• Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.
• High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Reports using RDL.
• Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2008 that stored and maintained the data.
• Implemented MS Analysis Services setup, tuning, cube partitioning, and dimension designing including hierarchical and slowly changing dimensions.
• Managed Up gradation ofDTS packages to SSIS packages.
• Involved in the complete data warehouse development life cycle and solely responsible for the design, development and maintenance of 8 cubes.
• Implemented transactional replication among different servers.
• Provided technical guidance and support to end-users by developing documentations required.
• Performed application and database code production pushes, following production release procedures.
• Performed production SQL release final verification procedure to production.
• Documented all database changes and follow and enforce change and release management processes.
• Audited and enforced database security, code and procedural standards.

Environment: MS SQL Server 2008, MS Analysis Services, SSIS,SSRS, MS-Excel, DTS, Visual Studio.Net 2003

Confidential, CA

MS SQL Server Developer

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Responsible for Day-to-day activities like taking backup (or scheduling the backups daily/weekly/monthly for database or transaction log) on disk and restoring the databases and transaction log on production/development servers as per requirement.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Involved in analysis and design of disaster recovery strategies with business managers to meet the business requirements.
• Maintained the database consistency with DBCCat regular intervals.
• Rebuilded the indexes at regular intervals for better performance.
• Designed and implemented the warehouse data model, dimension, fact and summary tables.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Involved in creating Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data using DTS.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Written complex T-SQL queries and Database triggers.
• Created indexes and was involved in PerformanceMonitoring.
• Wrote various stored procedures for the purpose of application development.
• Tuned SQL statements (e.g.: - Using Indexes) and Stored Procedures.

Environment: MS SQL Server 2008, MS Access, MS Excel, TFS, SSIS, SSRS, SSAS, ER-Win v4.0.

Confidential

SQL Developer/SSIS/SSRS/SSAS

Responsibilities:

• Involved in the life-cycle of the project, i.e., requirements gathering, design, development, testing and maintenance of the database.
• Setup new SQL Server instances.
• Developed SQL Server objects such as tables, materialized views, clustered and non-clustered indexes, stored procedures, cursors, triggers and constraints.
• Performed query optimization and tuning, debugging and maintenance of stored procedures.
• Provided database security by using role base authorization on accessing data.
• Used System tables and stored procedures to retrieve metadata.
• Administered the database using SQL Server Enterprise Manager.
• Performed troubleshooting operations on the production servers.
• Monitored SQL Server jobs, and developed queries to perform database operations.
• Developed user friendly GUI using HTML and ASP.NET 1.0/1.1 to display and access data.
• Implemented database programming by using the ADO.NET object Model.

Environment: SQL Server 2008, DTS Package, SQL Server Enterprise Manager, SQL Server Query Analyzer

Confidential

SQL Server Developer/SSIS developer

Responsibilities:

• Designed, coded, tested and implementeduser interfaces, procedures and functionsfor new and existing softwareapplication requirements.
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Install, tune, maintain and monitor SQL Serverfor the Production environment
• Created DTS package to get data from different sources, consolidate and merge into one single source.
• Created variety of reports for business to provide them with critical information about business status.
• Actively involved in Normalization & De-normalization of database.
• Created complex variables, multiple breaks, sorts in the reports.
• Created generic Measure class for generic measures, and created separate class for conditional objects.
• Involved in System testing.
• Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.

Environment: SQL Server 2005, Access 2000 & Windows 2K platform ADO.NET, MS Project