SUMMARY:

• Expert in SQL Server Database Design, Architecture, Optimization & Maintenance.
• More than 14 yr experience in SQL Data Processing, Transformation and Loading (ETL).
• Engineered ETL systems to load vendor data up to 10 million records daily.
• Delivered ETL systems that in 500% more productive than the common solutions.
• Top knowledge and experience in Transact SQL, SSIS, SSRS, SSAS, OLAP.

EXPERIENCE:

Confidential, New York, NY

Environment: SQL Server 2008/2012, Transact SQL, ETL, SSIS, SSRS, C#, DBA.

Responsibilities:

• Analyzed and designed a Data Warehouse for the Confidential payment processing.
• Developed fully automated processing for the various Client Data Imports, data Unloading and Data Distribution for the large - scale database systems using execution of SQL Server jobs, SSIS packages, Stored procedures, triggers, queries, various ETL processing, etc.
• All SSIS business processes were designed and implemented with a 100 % automation.
• Designed conceptual, logical and physical data modeling to create new data architecture as well as enhanced existing ones.
• Developed the distribution solutions to update 400 client databases on multiple SQL servers in real time.
• The distribution solutions were based on the SSIS packages system.
• The SSIS synchronization process increased the productivity of business updates by 500%.
• Created SSIS packages for the imports of Routing, Debit Bin, Zip Code data. The SSIS packages updated data for 350 databases on the twelve SQL servers with a 100% reliability.
• Developed the Network traffic data collection system using the SSIS and C# application.
• Collaborated with the business owners to ensure systems' performance and integrity.
• Diagnosed and identified the database related issues, then developed the corrective actions.
• Extensive experience in troubleshooting and solving complex technical problems.
• Communicated goals and thoughts in a clear and efficient manner.
• Performed Data mapping, data migration and data conversions, relational data modeling.
• Developed the optimization for SQL databases, queries, tables, views, indexes and carried out testing and quality assurance for the efficiency and the productivity.
• Designed System Process Flows, Data Models and User provisioning policy documents.
• Experienced in Agile development, abled to develop according to the approved schedule.
• Developed SQL Server database system for the pharmaceutical Data Warehouse.
• Designed Data Import Project as a complex SSIS application system to import The Third-Party Physician data into the Noven Pharmaceuticals SQL server production database.
• SSIS system performs the Transfer data to company file server. Unzip data files, rename excel worksheets and validate, Transform and load import data to SQL Server Database.
• Created an Audit system to trace all database changes with complete reporting statistics.
• Created Business Statistical Reports for the imported data.
• Hands-on performance tuning for tables, triggers, indexes, SSIS, SSRS, user reports.

Confidential, New York, NY

Environment: SQL Server 2005/2008, Transact SQL, ETL, VB.net, DBA, SSIS, SSRS, Oracle11

Responsibilities:

• Analyzed, designed, implemented and supported a large Data Warehouses for Confidential .
• Completely automated Public Transportation Auto Reimbursement System (PTAR). Developed new unified system instead of multiple disconnected applications. Automation helped to increase system productivity by 200%.
• Analyzed and understood the application discrepancies then developed the error free process.
• Designed multi layer validation to achieve 100% Data Quality, Consistency and Integrity.
• Built a supervision system to report defective import. in real time.
• Because of the fast user response, the Data Import stream was increased by 30%.
• Designed automatic control system to support the following application functionalities: a. enforcement for business rules and restrictions. b. ability to restart a process from any point of failure. c. monitoring the errors and immediate process status information. d. sending and distribution the business data statistical reports.
• Control system increased throughput by 25 % and removed a daily IT stress.
• Designed WeCare System in heterogeneous technology environment for multi-site delivery.
• Identified application risk areas and implemented preventative bulletproof measures.
• Performed analysis, data evaluation and data mining in a data warehouse.
• Alleviated bottlenecks in terms of data, size, query and analytics latency.
• Designed SSRS analytical and statistical reports to identify and track business issues.

Environment: SQL Server 2005/ 2008, Transact SQL, ETL, VB.net, DBA, SSIS, SSRS

Database consultant

Confidential, New York, NY

Responsibilities:

• Designed, analyzed, integrated and modified a large Daily Tracking System (DTS).
• Developed and integrated DTS system using Business Intelligence technologies.
• Implemented effective mapping of multiple sources to centralized SQL target system.
• Developed system with a full validation, cleansing, editing, transformation and auditingThe project was done on the aggressive schedule.
• Designed sophisticated SSIS solutions by combining and transforming multiple data sources.
• Designed SSIS System to reload Production data into the Test database on the Daily basis.
• Developed SSRS Data warehousing, analytics and reporting.
• Designed a special methodic to transfer un-indexed files and holding a given row order.
• Build new features and capabilities for the Training Daily Tracking System.

Environment: SQL Server 2005/ 2008, Transact SQL, VB.net, DBA, ETL, SSIS, SSAS, SSRS

Confidential, New York, NY

Responsibilities:

• Developed, maintained and tuned a Data Warehouse for insurance/reinsurance data.
• Performed extensive data modeling and analysis of database relationship and attributes.
• Designed the table-driven business rules to validate the client incoming data.
• This functionality improved data quality and reliability and resolved business problems.
• Analyzed Data Warehouse Processing using database tracking logs, traces and SQL Profiler.
• Performed analysis to find resource consuming programs and the system bottlenecks.
• Redesigned, Optimized and Tuned the queries to improve system performance up to 200%.
• Developed the stored procedures to calculate premiums, commissions and various fees.
• Designed business analysis and management statistical reports using SSRS utility.
• Designed highly productive ETL SSIS System to load the various data to SQL database.
• Developed and implemented the Data Migration from the old system to a new system.

Environment: SQL Server 2005/ 2008, Transact SQL, DBA, ETL, SSIS, SSAS, SSRSMDX, OLAP, VBScript, Crystal Reports, Access, Websphere Portal

Confidential, New York, NY

Responsibilities:

• Researched and Analyzed multi-department financial data and then using Business Intelligence methods modeled the business process to the SQL server relational database.
• Designed Data Upload SSIS System to load the various data files to SQL databases.
• Created Data Extract SSIS System to download data from SQL databases to various systems.
• Designed multichannel SSIS packages with a speed balancing element for all DB Constrains.
• All SSIS packages were completely automated and executed on the schedule basis.
• Designed Budget Data Warehouse using Dimensional modeling, OLAP, SSAS, SSIS, SSRS.
• The Budget Data Warehouse provided the Data Quality and data analysis.
• Designed a full data Audit and Report system for all existing databases. This solution helped to solve many production difficulties and security problems.

Environment: SQL Server 2000/2005, Transact SQL, DTS/SSIS, ETL, DBA, ErwinVB.net, C#, ASP.net, HTML, JavaScript, VBScript, VSS,