SUMMARY

• Over 8 years of progressive experience in software design and development with an earned reputation for meeting deadlines and delivering mission critical solutions.
• Experienced in SSIS (SQL Server Integration Services), SSRS (Reporting Services) and SSAS (Analysis Services).
• Excellent understanding of Relational Database Systems, Normalization, Logical/Physical Data Modeling and Data Warehousing.
• Extensive knowledge of Electronic Medical Record system and web based applications software for health care system.
• Good understanding of Database Architecture concepts related to Pages, Extents, Files, File - Groups, Transaction Logs, Tables and Indexes.
• T-SQL Programming using DDL, DML commands for various business applications.
• Efficient in creating joins and sub-queries for complex queries involving multiple tables.
• Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
• Hands on experience in creating indexed views, complex Stored Procedures, effective functions, and appropriate Triggers to assist efficient data manipulation and data consistency.
• Hands on experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production.
• Extensive experience in Extraction, Transformation and Loading tasks in SSIS while transferring the data to target destinations from various sources like Excel, CSV, Oracle, Access, Flat File, Raw File and XML File.
• Experience in building Data Integration and Workflow Solutions for Extracting, Transforming and Loading data with SSIS packages, DTS and BCP utility.
• Gathered and formalized requirements for EHR/EMR data capture and reporting.
• Experienced in implementing Incremental Data Load from an OLTP to a staging database for further Analysis.
• Excellent in High Level Design of ETL DTS Packages& SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Expert in designing reports using SQL Server Reporting Services (SSRS2008/2012), operating and troubleshooting with data sources.
• Expertise in designing complex reports like Drill-Down, Drill-Through, Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Developed various management information reports by using crystal report 2011
• Experienced in creating reports and dashboard using Tableau
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Major strengths are familiarity with multiple software systems, tools and the ability to learn new technologies quickly and adapt to new environments.
• Excellent client relation skills and the drive to complete tasks effectively and efficiently as well as the ability to communicate effectively with all levels of management and the client.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g, MySQL, SQL Server 2012

ETL Tools: SQL Server Integration services (SSIS) 2008 and 20012, Data Transformation Services (DTS), VBA, Data Junction

J2EE Technologies: JSP, Servlets, JDBC, JNDI, Spring, Hibernate

Languages: SQL, PL/SQL, TSQL, Java, C, C++, PHP, Python

Operating Systems: Windows NT/2000/XP/7, UNIX/LINUX

Web/Application Servers: Apache Tomcat, JBoss

Web Technologies: HTML, CSS, Java Script, AJAX

Version Control: Clear Case, CVS, SVN

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

SQL Server Developer/BI Developer

Responsibilities:

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Extensively worked on stored procedures, triggers, Views, cursors, CTE’s, T-SQL scripts, schemas, permissions and performance issues with client/server database design.
• Experience in collecting the user requirements and documenting by creating the use case and flow activity diagrams
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Uploaded reports on to the report manager and organized them into folders.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
• Developed Query for generating drill down, drill through and parameterized reports in SSRS 05/08.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational, drill-through and drill-down reports using SSRS.
• Involved in the Data modeling, Physical Design of Database using tools like Erwin.
• Used DBCC Statements to perform maintenance tasks on the database. Executed DBCC commands like CHECKDB before backing up the databases.
• Performing Replication (snapshot and transactional).
• Configured replication servers and transactional replication between production & standby server for disaster recovery
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.

Environment: s: SQL Server 2012/2008, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, Index Analyzer DTS, MS SQL SERVER, T-SQL, MDX, Windows NT/2000/2003, XML, MS Excel and MS Access, visual studio 2008,visual studio 2012.

Confidential, Torrance, CA

SQL Server/ETL/BI Developer

Responsibilities:

• Involved in XML Development and XML File Parsing in SSIS and SSRS.
• Developed EMR data transformations to process client medical transactions for data accuracy.
• Created stored procedures, triggers, Views, CTE’s, T-SQL scripts, schemas, permissions and performance issues with client/server database design.
• Involved in performance tuning and optimization on Business objects Universes by creating Aggregate tables.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with Incremental load.
• Used SSIS 2012 to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Database.
• Developed the PL/SQL programs and Involved in optimizing stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Demonstrated architecture, design and delivery experience in the full lifecycle of data.
• Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard in SSIS.
• Worked with Electronice medical records (EMR)
• Created automated stored procedures for day end operations using SQL Server agent.
• Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling).
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.

Environment: s: SQL Server 2008, Oracle, MS Access, Excel, Windows Server 2008, Unix, Linux, VSS, ERWIN, Microsoft Visual Studio 2008/ 2010, MS Visio, MS Integration, Analysis and Reporting Services, Management Studio.

Confidential, San Francisco, CA

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Developed T-SQL programs and was involved in optimizing stored procedures and queries for faster retrieval and Server efficiency SSIS.
• Created automated stored procedures for day end operations using SQL Server agent.
• Generated several reports that were used by various departments for the day-to-day business operations of the company.
• Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling).
• Gathered business requirements and obtained knowledge regarding the daily business operations, which were required for the development of the reports.
• Automated the generation of several reports that was being created manually before to ensure faster and accurate reporting.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• The generated reports were placed in a SharePoint site for the convenience of various business users.

Environment: s: SQL Server 2008 R2, MS Access, Excel, Windows Server 2008, Microsoft Visual Studio, MS Visio, MS Integration, Analysis and Reporting Services, Management Studio, SharePoint Serve.

Confidential, West Des Moines, IA

SSIS/SSRS Developer

Responsibilities:

• Prepared the Technical and Function specifications based on the project requirements.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Redesigning the ETL process from the existing legacy DTS packages into SSIS Packages.
• The SSIS Packages include, a Master Package, which executes a number of Child Packages.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Modified stored procedures to meet current design and used them in SQL Server.
• Developed queries in Data Warehouse in OLTP/OLAP environment.
• Created complex Stored Procedures, Datasets, Object Data Sources, and SQL Data Sources.
• Modified web pages to do database inserts, deletes, modify.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Responsible for creating Summary reports, Sub reports, Drill Down reports, Matrix reports.
• Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).
• Created report models from OLTP & OLAP.
• Trained 10 business users so that they can create reports from the report model I created.
• Troubleshooting Database performance issues and implementing necessary database changes.
• Involved in Development, Review and testing of the new system by implementing business rules and transformations.

Environment: MSSQL Server 2008/2005, Visual Studio 2005, Reporting Services (SSRS 2008/2005/2000 ), Business Intelligence Development Studio (BIDS), MS Office 2007, MS Access, ETL, Performance Point Server 2007, MS Excel.

Confidential, Bloomington, IL

SQL Developer

Responsibilities:

• Installation and configuration of SQL Server Reporting Services (SSRS) 2008.
• Developed T-SQL programs and was involved in optimizing stored procedures and queries for faster retrieval and Server efficiency SSIS.
• Created Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports. (SSRS)(2005/2008).
• Involved in creating report models and applying row level security filters for report model.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml to MS-SQL Server using SSIS.

Environment: SQL Server 2005 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS), ProClarity Server, XML, MS PowerPoint, MS Access 2003 & UNIX, Shell Scripting, Oracle.