SUMMARY

• Over Seven years of experience in development of Extract Transform and Load programs primarily using Microsoft SQL Server technology.
• Expert in SQL, T - SQL, DTS, SSIS, SSRS. Experienced in SQL 2000, SQL 2005, SQL 2008 R2 and Access databases.
• Expert in creating indexed Views, complex Stored Procedures, appropriate functions, and effective Triggers to facilitate efficient data manipulation and data consistency.
• Good understanding of logical and physical data modeling Techniques.
• Developed SSIS packages with various tasks like - FTP, File System, E-mail, For-each-loop, Execute Package, Data Flow task, Execute SQL task, Custom Script Task, Analysis Services Task, Data Mining Task.
• Sourced data from various types of relational databases, flat files, excel files.
• Developed Transformations using Data Conversion, Audit, Derived Columns, Lookups, Merge, Merge Joins, Slowly Changing Dimension transformation.
• High analytical skills and ability to identify data patterns, data issues within multistep ETL process.
• Quick at isolating the system issues and locating problems and reporting issues and progress in effective manner to the management.
• Extensive experience with data modeling, dimensional modeling.
• Experienced in job scheduling and managing packages on SSIS server.
• Ability to work till late to meet deadlines.
• Excellent interpersonal and communication skills. Quick learner, self motivated and a good team player.
• Strong hands on Experience in working with T-SQL (Transact) Statements.
• Experience in migrating SQL Server 2005 to SQL Server 2005.
• Good knowledge on Finance applications like trade finance, cash management, securities services, foreign exchange, risk management, capital raising and corporate finance solutions.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

Databases: MS SQL SERVER 2000/2005/2008 , MS Access

ETL: T-SQL, DTS packages, SSIS 2005, 2008 R2

Languages: SQL, T-SQL

Reporting: SSRS 2005, 2008 R2

Tools: Management Studio, Business Intelligence Development Studio.

Operating System: Windows 7, Vista, XP, 2000, 2003 Server, 2008 R2 Server

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SQL Server Developer

Responsibilities:

• Designed and developed Data Warehouse processes.
• Designed and developed stage data model and dimensional data model for data warehouse.
• Mapped disparate data sources - relational DBs and text files onto target schema.
• Designed Extraction Transformation and Loading (ETL) process to source from Oracle applications as well as legacy data sources.
• Developed ETL processes to source data from flat files using SSIS 2008.
• Designed ETL processes to load fact and dimension tables in data warehouse.
• Developed T-SQL functions and stored procedures.
• Developed SSIS complex and multistage SSIS packages using For-each-loop, Execute Package, Data Flow task, Execute SQL task, Custom Script Task, Analysis Services Task, Data Mining Task.
• Developed Transformations using Data Conversion, Audit, Derived Columns, Lookups, Merge, Merge Joins, Slowly Changing Dimension transformation.
• Scheduled the ETL processes on SSIS server and managed integration server.
• Designed indexes to tune the ETL process performance.
• Developed, modified, and optimized complex queries and stored procedures to data retrieval and modification.
• Developed ETL auditing system using SSIS Event Handler and Custom Scripts.
• Developed analytical and transactional reports using SSRS 2008.
• Developed reports based on OLAP cubes.
• Developed ETL process monitoring reports. Used Report Builder 2.0, 3.0 to develop ad-hoc reporting for ETL QA as well as for DW UAT process.
• Worked hand in hand with System Analysts, Business Analysts and Project manager. Worked in a team of database and front end developers.
• Communicating with BA team and making sure the reference table data is up to date.
• Designed SQL SSIS Packages to extract data from various data sources such as Oracle database, Excel spreadsheet, and flat files into SQL Server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, T-SQL.

Confidential, Salisbury, NC

SQL Server Developer

Responsibilities:

• Developed ETL processes to read files from FTP site and load the data into data warehouse.
• Developed Extraction Transformation and Loading (ETL) process to source from the OLTP database of marketing application and load into data warehouse.
• Developed ETL process to source data from flat files and parse them to build analytical data.
• Designed ETL processes to load fact and dimension tables in data warehouse. Developed T-SQL functions and stored procedures.
• Normalized and De-normalized the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Created DTS packages to migrate data from various sources like C.S.V (COMMA, SEPRATEDD, VALUES) to the SQL Server 2000
• Modified database structures including tables, dictionary, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements.
• Planned and co-coordinated database security measures.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Developed reports using SSRS 2005.
• Used table control, matrix control for cross tab reports.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designed and created Report templates, bar graphs and pie charts. Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
• SSIS Modules: Distributor, Distributor Center, Supplier, Supplier Facility, Items, Invoice and Inventory, Franchise Groups.

Environment: MS SQL Server 2005/2000, T-SQL, SSIS, SSRS.

Confidential, Parsippany, NJ

SQL Server Developer

Responsibilities:

• Involved in writing views and triggers.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Created DTS Package to transfer data from the Oracle source database.
• Modified DTS to SSIS packages to accomplish critical business logic.
• Reduced the overall ETL Time by SQL Query Performance Tuning.
• Created Backups for databases and automated the process.
• Executed DBCC commands like CHECKDB before backing up the databases. Logical Data Modeling using ER-Win to fit business requirement.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Developed the T-SQL Statements while loading the data into Target Database.
• Data migration (import & export/BCP) from Text to SQL Server.
• Configured Replication Server.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery. Generating ad-hoc reports using MS-Excel and Crystal Reports.
• Coordinating post-implementation events such as testing.

Environment: MS SQL Server, T-SQL, DTS, SSIS, SSRS Windows 2003 Server, ERWin.

Confidential

SQL Server Developer

Responsibilities:

• Involved in configuring and converting MS SQL Server 6.5 database to MS SQL Server 7.0. Partially involved in Database design and Database objects.
• Created backups for databases.
• Partly Involved in Performance tuning.
• Responsible for Developing GUI Screens.
• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.
• Responsible for creating COM Components using Active X DLLs and for creating database and database objects like Tables, Stored Procedures, Views, Triggers, Rules and functions.
• Developed various management reports using Crystal reports.
• Maintain the application as per the user requirement.
• Gathered requirements from business users.
• Wrote user requirement documents based on functional specification.
• Designed physical data models.
• Created functions, views and triggers.
• Developed source to target specifications.
• Created DTS package and schedule the jobs for batch processing.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Greatly involved in Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it.

Environment: SQL Server 2000, Crystal Reports, Access, Excel.