SUMMARY

• 7.5 years’ of experience in the field of DatabaseDesign, Implementation and Support.
• Knowledge in Configuring and creating databases in a LAB environment on Windows environment.
• Knowledge in setting up Oracle Enterprise Manager 10g and Grid control 11g for database monitoring and performance.
• Expert in Data warehousing concepts and OLAP technology.
• Expertize in Banking, Insurance, Finance, Retail, Healthcare sectors.
• Working extensively in Power BI report, creating tabular cube, creating data model forPower BI Report, Validating data quality of the report.
• Comprehensive knowledge in generalaccountingprinciples,businessfunctions of general ledger, treasuryaccounting, accounts payable, asset management, billing, cash flow statements and receivables.
• Developed & supported various mission critical Client Server applications by handling Database requests for various application development teams involving complex business logic, functionality.
• Extensive experience with SQL Server and T - SQL in constructing tables, triggers, user defined functions, relational database models and data integrity.
• Good knowledge in creating, modifying, using and debugging Stored Procedures, Views, indexed views.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Experience in Implementing Change Data Capture (CDC) on databases.
• Involved in addressing Batch process issues, Job scheduling, Code Debugging, Maintenance and Bug Fixes.
• Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Test & Deploy code across various SDLC Environments like DEV, TEST and Production.
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Skilled 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, Synchronous and Asynchronous Transformations.
• Extensive knowledge of Designing, Developing and deploying different kinds of reports using SSRS 2000/ 2005/2008/2012 utilizing relational and multidimensional data in different environments.
• Experience in developing data driven subscription reports and Ad-hoc reports using Report Builder in SSRS.
• Expertise in creating various SSRS Reports - Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Expertise in building Star schema and Snow Flake schema depending on business requirements.
• Experienced in Designing, Building the Dimensions, Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
• Used Various third party tools to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.

TECHNICAL SKILLS

RDBM/Databases: MSSQL Server 2000/ 2005/2008/2012 , Oracle 8i & 9i, Sybase, MS Access 97/2000/2003/2007 , MYSQL.

Programming Languages: T-SQL, PL/SQL, Dynamic SQL,C, JAVA, MDX, XML, HTML, DHTML, Shell Scripting, JavaScript, Visual Basic 6.0, ASP .NET.

Data Modeling: MS Visio, ERWIN 4.5/4.0, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-normalization Techniques, MS- Access.

ETL-Tools: DTS, SQL Server Integration Services (SSIS), Informatica.

BI Tools: SQL, SQL Server Integration Services (SSIS 2005/2008/2012 ), SQL Server Reporting Services (SSRS 2005/2008/2012 ) SQL Server Analytical Services (SSAS 2005/2008/2012 ), Data Transformation Services (DTS), Visual Studio, BIDS, Tableau, Power BI.

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Toad, IIS 6.0/7.0,Business Objects, Crystal Reports 9.0, Web Services, XML, SOAP, WSDL, UDDI, Clear Case, Clear Quest, Visual Source Safe 6.0/2005, Visual Studio Team Foundation Server (TFS), ERWIN 7.3/7.2.

Application Packages: MS Office, Microsoft SharePoint Server (MOSS) 2007/2010

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket, RI

SQL Developer

Responsibilities:

• Gathered user requirements. Responsible for Analysis and implementation for DB changes requested by users. Developing reports using efficient data retrieval techniques.
• Updated functional specification and technical design documents. Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Specifying the named sets for calculations using named queries. Responsible for creating reports based on the requirements using SSRS 2012.
• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
• Exported and imported data from text files and Excel to SQLServer database using BULK insert and BCP utility.
• Involved inPerformance Tuningof Code using execution plan and SQL profiler and addedIndexesto improve performance on tables.
• Worked onPerformance tuningbyusing Explain Plan and various Hints.
• Worked on performance tuning of the ETL process and SQL optimization on a large database.
• Analyze and monitor tables, indexes based on performance, table spaces and data file utilization regularly
• Perform various performance /goal oriented database tuning, instance tuning, memory tuning, SQL query tuning.
• Perform bulk load of data using SQL Loader, and conduct standard and fine grain database auditing.
• Assisted in the development of new database products by providing guidance on performing SQL queries and provided guidance on tracking client web based training and portal inquires.

Environment: SQL Server 2012/2008, T-SQL, SSRS, Management Studio 2012, Visual Studio 2012, Team Foundation Server (TFS).

Confidential, Renton, WA

SQL Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan and defined Check constraints, Business Rules, Indexes, and Views.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Created User Defined Functions (UDF’s) to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Created and maintained databases, tables, views, users, logins, indexes, check constraint, and business rules using T-SQL.
• Worked with Claims, Members, Providers and Authorizations for loading the data into SQL server using SSIS packages.
• Worked onPerformance tuningbyusing Explain Plan and various Hints.
• Worked on Performance tuning of the ETL process and SQL optimization on a large database.
• Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets or Internet portals.
• Provided healthcare provider problem resolution. Work as a medical coding SME, including ICD-9, HCPCS; Procedures and diagnosis testing.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created and tuned Event Handlers, Checkpoints and logging to maintain active packages.
• MS SQL Server Configuration,Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.

Environment: SQL Server 2008, T-SQL, Management Studio 2008, Query Analyzer, Team Foundation Server (TFS), SharePoint, PL/SQL, Power BI.

Confidential, Houston, TX

SQL Developer

Responsibilities:

• Developed the end-user documentation and performed periodic updates of the design documents.
• Actively involved in creation of database, modified tables, triggers, and store procedures to clean and validate the data to meet the company specifications.
• Extensively used Joins, Functions and Correlated Sub-Queries to simplify complex queries involving multiple tables.
• Involved inPerformance Tuningof Code using execution plan and SQL profiler and addedIndexesto improve performance on tables.
• Worked on Data Transformation Activities using SSIS Import/ Export for transferring data between Oracle to SQL Server. Moved Data from flat files and Excel sheets using SSIS.
• Imported data from text files and excel spreadsheets into SQL Server 2008 database using SSIS package.
• Created packages using Error Handling mechanism and used variables to handle package dynamically.
• Analyzing Business requirements, gathering information from business users and develop reports accordingly.
• Designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema.
• Created and processed cubes that support new organization structure.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: Microsoft SQL Server 2008 R2, Visual Studio 2008, T-SQL, SQL Server Analysis Services, SQL Server Integration Services, Business Intelligence Development Studio (BIDS), SQL server profiler, Team Foundation Server.

Confidential, Dallas, Tx

SQL Server Developer

Responsibilities:

• Gathering Requirements from the Business Users and developing the work flows.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Defined constraints, rules, indexes, views and triggers to enforce data and referential integrity based on architect requirements. Used Execution Plan,SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Wrote the complex queries using joins, Sub-queries, common table expressions (CTE) in T-SQL.
• Performed Column Mapping, Data Mapping and Maintained Data Models and Data Dictionaries.
• Involved in retrieving multi-million records for data loads using SSIS and by querying against Heterogeneous Data Sources like SQL Server, Oracle, Text files and some Legacy systems.
• Expertise in using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc.
• Worked on Huge Data Transfers from and to SQL Server Databases using SSIS, and used Configuration Files and Environment Variables for production deployment.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Involved in optimization of queries and refining the performance using Data Purging, Index Optimization, Execution Plans, DMV’s and DMF’s.

Environment: MS SQL Server 2005/2008, Oracle, PL/SQL, T-SQL Microsoft Excel, Visual Studio 2008, SQL Server Management Studio (SSMS), Team Foundation Server (TFS).

Confidential

SQL Server Developer

Responsibilities:

• Created T-SQL (DDL, DML) queries, complex Stored Procedures, User-defined Functions, designing and implementing Database Triggers, designing and implementing Views, designing and implementing Indexes.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Worked with Exception handling with @@error and with Try/catch.
• Used multiple join statements to retrieve data from multiple several tables.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.

Environment: MS SQL Server 2005/2008, MS Access,Windows XP Professional/2008 Server, MS-Access, Oracle 9i, T-SQL, PL/SQL, Team Foundation Server (TFS).

Confidential

SQL Server Developer

Responsibilities:

• Installed and Configured SQL Server 2008 successfully.
• Created other database objects like tables, views, Stored Procedures, User Defined Functions, Triggers and indexes.
• Error handling using Try-Catch Block.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and Worked on Index tuning, stored Procedure tuning.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
• Assisted the front end application developers with their queries.
• Taking Databasefull Backup, Transaction log backup & differential backups.
• Configured Snapshot replication for reporting, user acceptance test and development servers.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Prepared the detailed project layout, analyzed existing technology involved, and documented work performed and stored in Visual Source Safe (VSS).

Environment: MS SQL Server 2000/2005, T-SQL, Data Transformation Services (DTS), MS Excel, XML, Microsoft Visual Source Safe, MS Visio 2007, SQL Server Management Studio (SSMS), SQL Profiler.

Confidential

Jr. SQL Developer

Responsibilities:

• Complete analysis, requirement gathering and function design document creation.
• Written various T-SQL Statements for the purpose of application development.
• Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts.
• Developed many T-SQL stored procedures, views, indexed views, UDF for business reporting.
• Collaborated with the application developers in data modeling and E-R design of the systems.
• Also created, modified, maintained and optimized SQL server database.
• Maintained the documents and create reports for the business analysts and end-users.
• Coordinating user acceptance testing amongst business users.
• Responsible for the management of the database performance, backup, replication, capacity and security.

Environment: MS SQL Server 2000/2005, T-SQL, Data Transformation Services (DTS), MS Excel, XML, Microsoft Visual Source Safe, MS Visio 2007, SQL Server Management Studio (SSMS), SQL Profiler.