Summary

• Over 7 years of experience in writing complex SQL procedure, SISS packages for ETL processin Healthcare Patient Accounting system like Epic, McKeesonStar. Understanding of HIPAA rules and regulations
• Understanding user requirements, design test scripts with new functionalities, conduct walkthrough sessions, and set the deliverable goals
• Experience in Agile and RAD methodologies to Analysis requirement, Design, Deploy and provide support to ETL process and performing upgrade to system. Able to handle multiple projects simultaneously, set priorities and adapt to changing requirement
• Participate in database design discussions, collaborating with Data Architects and reporting specialists to ensure accuracy and performance. Identifying opportunities for improvement and ensure resolution of outstanding issues
• Understanding Business Process in detail, planning project's scope and milestones and ensure timely delivery of the system changes. Gathering requirement changes and reporting documented changes to senior management in the process
• Performing Integration, Regression, UAT, and Database testing in stimulated development environment. Preparing test cases to feature the improvement of legacy code
• Managing research resources for new functionalities to enhance current project in accordance with project standards and deadline
• Enhancing new database Models from existing legacy database for better performance in an ongoing process at new implementation and at support

Reporting Integration Services

• Knowledge of SSDT, Report Project Wizard, Server Project, Add Item of Solution Explorer and understanding the folder hierarchy at development
• Understating of Report Solution Explorer, folder hierarchy at development, data region and formatting of report
• Generating Dynamic reports from Cubes using Report Builder and SSRS. Developed Variance reports using Reporting Services SSRS
• Designing Service Management Reports, utilizing Dynamic and Cascading Prompts, fund Reports, Portfolio Report, sub-reports, charts, and parameterized reports, conditional and dynamic reports
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases
• Data Conversion and Data Migration using SSIS packages to transfer data between Oracle, DB2, MS Access and Flat Files to SQL Server using DTS/SSIS
• Validating existing databases using scripts to maintain data consistency and rectify data issues
• Ensuring issues are identified, tracked, reported and resolved in a timely manner when monitoring and troubleshooting ETL failure in data loading process
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages
• Deploying the package using connection strings or installation wizard or DTExec wizard
• Extensively involved in designing the SSIS packages to load data into Data Warehouse. Involved in creating SSIS jobs to automate the reports generation, cube refresh packages

Technical Skills

Operating System - Win-XP, Win-7, Vista, Ubuntu

Programming Languages - C, C , VB, C , Unix Scripting, PL-SQL, HTML, XML

Programming Tools - SQL Server 2014/2008/2005/2000, Oracle 9i, SSIS, SSRS, SSAS

Visual Studio 2005

Data Modeling Tools - MS Project 2010, MS Visio 2010, Visual Paradigm, SmartDraw, ERWIN

Work Summary

Confidential

Senior Database Developer/ Analyst

Responsibilities

• Testing and Implementing ETL packages in SQL Server 2014/2012 and BIDS to load and extract data, performing full data validation, changes during test phase and data analysis phase, scheduling the packages into production and provide support
• Scheduling.dtsx packages using SQL job agent, monitoring and troubleshooting failed packages. Debugging and handling error in failed stored procedure in production server.
• Automating loading of multiple data files using expressions in connection manager and for-each loop container or for loop container to perform similar functions in single go
• Analyzing the query joins, DML operations, cluster - non cluster indexes in stored procedures uniqueness of values and SQL Server Execution Plan to optimize queries and indexes for faster execution of query
• Optimizing stored procedures using Indexes, reducing complex joins to temporary orderived tables, using CTE, Partition By functions, and Merge statement
• Creating SSIS Packages in BIDS using Control flow tasks like for-loop container, execute-sql, file system, sequence container, for-each loop, script task, Data flow tasks like Derived Column, Conditional Split,Pivot/Unpivot
• Using staging tables, table variable and temporary tables to improve the query performance.Debugging and unit testing procedures and SSIS tasks using breakpoints
• Creating C scriptto parse date, time, and decimal data values in script-component. Creating and debugging C script to parse report formatted text files to generate table records
• Analyzing dataquality with respect to master codes, number of records, duplicates records, maximum-minimum values, syncing number of accounts across tables, null percentage in columns
• Reviewing and edits requirements, specifications, business processes and recommendations related to proposed solution using Agile Methodology
• Working on data and master files, performing GAP analysisand modeling database using Erwin
• Scheduling and Maintained Packages by implementing Execute SQL Server Agent Job Task, History Clean Up, Maintenance Cleanup Task, Shrink Database, Rebuild Index Tasks for Metadata and Data Quality
• Parsing report file to extract data values to generate table records using C in script component

Environment : MS SQL Server 2014/2012, BIDS 2013/2010, MS Reporting Services, MS Integration Services, SQL execution plan, C

Confidential

Database Developer

Responsibilities

• Proficiently creating SQL Server 2005 Reporting Services SSRS with proficiency in using Report Designer as well as Report Builder
• Generating matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports
• Experience working withTablix Data Regions in the Report Layout, created a stack of stepped reports using the Tablix
• Creating and designing the report layout, sorting the data, defining subtotals and generated reports like parameterized reports, drill down reports
• Designing and developed Matrix and Tabular reports with Drill Down, Drill Through, Parameterized, Sub Reports and Drop down menu option
• Developing functional and technical specifications documents such as the Business Scope Document and High Level Design Document.
• Modifying existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements.
• Creating trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts
• Using SQL server reporting services SSRS delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources
• Designing and creating report models based on users' requirements, explain and train users to use report builder to generate their own personalized reports

Environment: MS SQL Server 2008/2005, BIDS 2010, MS Reporting Services, DTS, MS Integration Services, C , Visual Paradigm

Confidential

Database Developer

Responsibilities

• Creating TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users in SQL Server2005
• Using Data Transformation Services DTS /SQL Server Integration Services SSIS and Extract Transform Loading ETL tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application
• Using multiple join, temporary table and derived table statements to retrieve data from multiple tables
• Using SQL profiler to view indexes performance to eliminate table scan
• Creating DTS packages for data transfer and migration from OLTP to OLAP
• Performing efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance
• Scheduling full and transactional log database backups in the production environment using the database maintenance plan wizard
• Creating many multi-valued parameters in the reports. Creating cascaded parameters in the reports using MDX and T-SQL. Performing unit testing to improving Report Performance
• Converting various SQL statements into Stored Procedures thereby reducing the Number of database accesses since Stored Procedures passes the whole block at one time
• Involved in Migration of data from different data sources Excel, Text file, MS Access and Oracle using DTS Packages and Bulk Insert commands
• Providing technical support to internal developers and external clients Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications
• Understanding of SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models
• Configuring and scheduled packages to be deployed out to a production environment using SQL server Table file configurations in SSIS 2005
• Using Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server

Environment: MS SQL Server 2005, BIDS, MS Reporting Services, DTS, MS Integration Services, SQL Profiler, Visual Paradigm

Confidential

SQL Developer/Analyst

Responsibilities

• Writing T-SQL statements using DML and DDL for retrieval of the data in SQL Server 2000
• Performing Data transfer Import Export using BCP
• Developing stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables
• Creating indexes, constraints and rules on database objects
• Creating detailed installation and deployment instruction documentation
• Proficient in creating SQL server report, handling sub reports and defining query for generating drill down reports
• Pulling data on a daily basis from OLTP database to OLAP or staging database using DTS
• Performing SQL health check using DBCC commands
• Troubleshooting all type of memory related issues and issues related to basic connectivity and full text search
• Resolving SQL connectivity and security issues for technical and non-technical staff
• Gathering functional requirements and written the technical specifications
• Designing logical / physical data models and defining primary key, foreign key

Environment: MS SQL Server 2000, DTS, Visual Paradigm, ERWIN