SUMMARY

• 7 years of professional experience as a SQL Developer in Health Care Industry. 7 years of experience in Agile with the entire project life cycle of Business, Design, Development, Testing, Implementation and Enhancement of Applications in Healthcare Industry.
• Quick learner, highly adaptive and possess very good inter personal skills and work ethics. Experienced in designing, modeling, developing & integrating with Microsoft SQL Server SSIS/SSRS.
• Created stored procedures for generating reports using SQL Server Reporting Services.
• Experience in working with multiple cross functional teams under strict deadlines. Efficient in creating joins and sub - queries for complex queries involving multiple tables.
• Demonstrated experience in writing complex T-SQL queries as per requirements.
• Experienced in optimizing SQL code by understanding execution plans, using SQL Profiler, DMVs, Index tuning wizard and other tools.
• Incorporated complex business logic into functions and stored procedures for reusability. Experienced in creating database objects such as tables, views, indexes, triggers etc. as needed.
• Good knowledge of Data Marts, OLAP, Dimensional Data Modeling, Star Schema and Snow-Flake schema for FACTs and Dimensions.
• Knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys.
• Experienced in Extracting, Transforming and Loading data from various data sources like excel, flat file and Oracle to SQL Server databases using SSIS SQL Server Integration services.
• Experience in working with partially / full blocking transformations and expertise in performance tuning of SSIS packages.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Proficient in SSIS package designing/development/deployment/documentation.
• Skilled in Designing, Development and Deployment of Reports in Business Intelligence Development Studio (BIDS).
• Strong experience in assigning permissions to the valid users for executing the reports & deploying reports to report servers.

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows XP/Vista/7/8/10

RDBMS: SQLServer and MS-Excel

LANGUAGES: SQL, PL/SQL, TransactSQL, VB.NET

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, MO

SQL Developer

Responsibilities:

• Installation, configuration and maintenance of MS SQL Server.
• Performing Database maintenance activities like Backups, Restoring, and indexing etc.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using Sybase T-SQL.
• Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Designed and developed different type of reports including: Drill through reports, Sub reports, Drill down reports based on business requirement using SSRS.
• Rewrote the existing code for long running queries by replacing cursors with various joins, common table expression (CTE).
• Created SSIS Packages using Pivot Transformation, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data to Excel Spreadsheets.
• Created SSIS packages to get data from various sources (DB2, Oracle).
• Worked with Team foundation server (TFS) offering source control, data collection, reporting, and project tracking.
• Populating a database with new information or transfer existing data into it.
• Creating backup copies of data.
• Daily maintenance of firewall protection and file security.
• Development of web based interfaces for Oracle databases and web applications.
• Responsible for database security and also preventing data loss
• Perform quality assurance and testing of SQL server environment.
• Provided support by troubleshooting and solving the issues.
• Performance Tuning of SQL Server Databases.
• Managing SQL Server security and logins.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures applying to complex business scenarios.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), T-SQL, C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003.

Confidential, Auburn Hills MI

SQL Developer

Responsibilities:

• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more.
• Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.
• Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Developed queries or stored procedures using T-SQL to be used by reports to retrieve information from relational database and data warehouse
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images and Maps.
• Create Common Table expressions (CTE) and temp tables to facilitate the complex the queries
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Developed Query for generating drill down and drill through reports in SSRS.
• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard.
• Developed SQL queries or stored procedures used by reports to retrieve information from relational database and data warehouse.

Environment: Microsoft SQL Server 2012, T-SQL, SQL SSIS, SSAS, SSRS, SQL Profiler, Visual Studio 2008, Visual Intercept Enterprise Edition, Oracle 10g, VB.Net

Confidential, Scottsdale, Arizona

SQL Developer

Responsibilities:

• Developed PL/SQL triggers and procedures, functions, packages to provide backend security and data consistency.
• Involved in documenting user requirements, technical specifications and Reporting manuals.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Developing functional, technical documents, advanced coding and bug fixation.
• Developed back-end PL/SQL packages, UNIX shell scripts for data migration and batch processing.
• Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Partitioned the fact tables and materialized views to enhance the performance.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Implemented using Forms, Reports, PL/SQL, Flex fields and Workflow.
• Customized, created and documented Forms and Reports in Oracle Projects module using Oracle Forms, Reports and PL/SQL.
• Analyzed, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Designed and developed custom database security in PL/SQL for Oracle versions 9i, and 10g.
• Provided Oracle back end programming including PL/SQL, Oracle Stored Procedure.

Environment: Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, Crystal Reports, TOAD.