SUMMARY

• MS SQL Server Developer 2008/2005/2000 with 7+ years of IT experience in various Industry verticals like Health Care, Finance, Insurance, and Service.
• Worked on Crystal Reports 2011 extracting data from multiple sources - Oracle, Sybase, DB2, SQL Server 2008 R2, applying several functionalities and used different data providers.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Extensive experience in MS SQL Server 2008/2005/2000 , Business Intelligence in MS SQL Server Integration Services
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from heterogeneous databases.
• Proficient in Creating, Configuring and Fine-tuning SSIS packages, Report Builder Reports, and T-SQL queries using tools like SQL Profiler, Performance Monitor, and Database Engine Tuning advisor.
• Strong experience in designing and developing enterprise reports using the data from ETL Loads and various heterogeneous data sources.
• Good knowledge in MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting data, defining data source, and subtotals for the reports.
• Experienced in Logical and Physical Database design & development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, and Windows performance monitoring and SQL Server performance tuning.
• Familiar with teradata utility.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models, Data Integrity, SQL joins, and Query Writing.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000 /7.0
• MS SQL Server 2008/2005 Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• Microsoft Access 2007/2003
• Sybase
• DB2
• Microsoft Excel
• Outlook
• MS SQL Profiler
• MDX
• MDS
• SQL Query Analyzer
• MS SQL Server Index Tuning Wizard
• Erwin Data Modeler 4.2/4.1/4.0
• Excel VBA
• SAP Crystal Reports 2011
• T-SQL
• MS Visio 2003
• Windows 2003/2000 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation
• UNIX
• Perl
• VBScript
• JavaScript
• Dream Weaver CS4
• Web Updater II
• SSH Tectia
• Web Ex
• TFS
• UC4.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

DWH Developer

Responsibilities:

• Extracted data from various sources and loaded data into fact and dimension tables of data warehouse.
• Involved in Database design including optimizing the database schema, creating database indexes and coding database procedures/queries.
• Implemented SSIS for data transformation logic process.
• Design and build data load procedures, using MS SQL Server SSIS
• Extracted Data from Various OLTP Databases to OLAP Database.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Created complex Stored Procedures, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Troubleshooting existing SSIS packages.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Responsible for creating standards and operating procedures to maintain all databases.
• Worked with development teams in the design of physical databases and in modification.

Confidential, NY

SQL Server Developer

Responsibilities:

• Involved in gather user requirements and system specifications.
• Developed stored procedures, functions and database triggers.
• Created and executed SSIS packages to populate data from the various data sources.
• Created SSIS packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel spreadsheet to SQL Server 2005.
• Designed ETL packages dealing with different data source and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Designed and implemented parameterized and cascading parameterized reports using SSRS and Crystal Reports with .NET applications.
• Worked with SQL Profiler for troubleshooting, monitoring and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA.
• Responsible for backup, restore systems and other databases as per requirements and also scheduled those backups.
• Worked with SQL Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.

Confidential, Miami, FL

Database / Report Developer

Responsibilities:

• Supported, modified and maintained Crystal reports that are currently in production.
• Created many complex parameterized and cross-tab reports from the scratch.
• Developed complex queries to gather data from various tables using join statements and group by clause.
• Created summary reports, sub reports etc: on various data sources like Oracle, Sybase, DB2, SQL Server, Excel, Ms Access etc
• Wrote formulae to calculate summaries, date manipulations etc. and used several string functions for parsing the data.
• Developed reports using running totals and used group summaries at different levels of grouping.
• Exported the reports to Excel, PDF, Word formats etc.
• Created daily, weekly, monthly, quarterly, and yearly reports.
• Generated several financial and clinical reports.
• Developed reports and tested it and validated it against legacy source systems.
• Conducted thorough data analysis and helped in fixing data discrepancies in the source database.
• Good knowledge on diagnosis codes, bill cycles, adjustments, collection rates, revenue etc.
• Wrote several stored procedures for extraction, transformation, and loading using SSIS packages.

Confidential, Miami, FL

BI Developer

Responsibilities:

• Involved in the requirement analysis and design of the new data warehouse for the claims project.
• Involved in the data analysis of the OLTP system used for building data ware house
• Modified the existing framework and rectified the bugs in the framework used for extracting data from the snapshot databases.
• Created post staging tables, dimension tables, fact tables, and analysis tables
• Developed ETL packages to Validate, Extract, Transform and Load data to Data Warehouse
• Changed the existing SSIS packages and ETL process to meet the changes specified by the users.
• Created jobs and job plans for full load and incremental load in UC4
• Scheduled Jobs for executing the SSIS packages for full load and incremental load on daily, weekly, and monthly basis.
• Created file watcher jobs in UC4 to successfully start the job schedule
• Created tables, views, and stored procedures.
• Worked in setting up logging environment to track the status of the events like error raise, task fail.
• Created parameterized reports to retrieve data using report builder.
• Tested the reports, the report queries, and did the performance tuning of report queries
• Developed Unit Test Plans for SSIS packages and for testing reports
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created auditing table to track the daily refresh.
• Did the performance tuning of SQL Queries for maximum efficiency and performance
• Monitored the transaction logs.
• Created high level design document for change control estimate
• Created the tech spec for the Claims project.

Confidential, San Jose, CA

SQL Server Developer/ SSIS Developer

Responsibilities:

• Planned, Defined, and Designed data based on business requirement and provided documentation.
• Gathered data and documented it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat Files and SQL Server 2005 to SQL Server 2008 using Lookup, Derived Columns, Conditional Split, Term Extraction etc:
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager.
• Scheduled report and exported it in PDF format.
• Fine tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Confidential, Buffalo, NY

MS SQL BI Developer

Responsibilities:

• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources. .
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Analyzed & designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
• Implemented the Data Cleansing using various transformations such as Lookup and Derived Column.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Migrated packages from development server to production server using package configuration.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter, month, week and daily reports for all domains and published through Report Server.
• Designed and developed various reports by comparing the growth of company based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of company with respect to customers.
• Used Visual Source safe for repository and maintaining versions.
• Created Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Improved Performance of the database by creating Clustered and non clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Conducted user training sections and supported the requests for enhancements, modifications and new reports.

Confidential, NY

MS SQL Server Developer/ SSIS Developer

Responsibilities:

• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Successfully installed and configured MS SQL Server 2005 on the production server.
• Automated the migration of data from Oracle DB to MS SQL Server 2005 DB using Microsoft SQL Server Migration Assistant (SSMA).
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Converted the Oracle DB objects to MS SQL Server 2005 DB objects like tables, views, and stored procedures.
• Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Migrated the entire schema as well as data into MS SQL Server 2005 and also validated the migration process to ensure that it has been successfully migrated.
• Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• Defined referential relationships with the measure groups and fact tables.
• Generated automatically grouping attribute members and implemented the calculations to aggregate physical measures.
• Defined granularity within measure group and drill through actions.
• Created cube reports that can be browsed at summary level and can be drilled down to the detail level.
• Defined the browsing perspectives and browsing translations since most transactions were online.
• Documented the development work and production release for future reference.

Confidential, Montgomery,AL

MS SQL Server SSIS Developer

Responsibilities:

• Used the SSIS to migrate databases such as Oracle and flat files to centralized IT destination.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Generated reports on wealth information, account information, research reports using adhoc reporting to be used by the clients and advisors.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Wrote Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updations to improve the query performance.
• Conducted performance tuning by using SQL Profiler and index tuning wizard.
• Involved in Creation of Crystal Reports, Created ODBC Connections and database Connections.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly
• Scheduled, maintained, and supported the distribution and access to reports through Crystal Server.

Confidential, St. Cloud, MN

MS SQL Server SSRS/SSIS Developer

Responsibilities:

• Migrated data from one standard database for loans created to diversified destinations for auto loans, student loans, and home loans using SSIS packages.
• Extensively used SQL server reporting services to generate reports on a weekly basis for a particular loan type in given period and created report models for Ad hoc reports when the end user wants to see the reports on fly.
• Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Migrated data from SQL server 2000 to SQL server 2005
• Implemented conditional formatting in reports to get a list of customers who have improper payment history.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE statements to insert the data depending on the criteria.
• Wrote T-SQL queries, created dynamic Stored Procedures that calculates the loan sanctioning details taking the customer details as input.
• Involved in creating a stored procedure to calculate loan details for existing customers applying for a second loan based on payment history and remaining amount of loan.

Confidential

MS SQL Server Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS SQL server 7
• Involved in migration of SQL server 7 to SQL server 2000 using Upgrade Advisor.
• Designed DTS (Data Transformation Service) packages to transfer data between servers, load data into database, archive data file from different DBMS using SQL Enterprise Manager/SSMS on SQL Server 2000 environment, and deploy the data, scheduled the jobs to do these tasks periodically.
• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE statements to insert the data depending on the criteria into the tables of hub.
• Wrote T-SQL queries and created dynamic Stored Procedures that calculates the loan sanctioning details taking the customer details as input.
• Tested successfully all stored procedures on SQL 2000 server Environment: SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, Windows 2000 Server, Enterprise Manager, Query Analyzer, SQL Profiler
• Involved in Performance tuning and optimizing of SQL Server Application by using performance monitor.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.