PROFESSIONAL SUMMARY:

• More than 6+ years of professional ETL Developer with in - depth understanding of Data integration, analysis and reporting on Microsoft SQL 2005, 2008, 2012 and Oracle SQL.
• Highly Experienced SQL Developer and BI development expert, talented in BI application tools; SSRS/SSAS/SSIS and SQL Server 2008/2008 R2/ 2012.
• Proven skills in implementing SQL Server 2005/2008/2012 ETL tools, OLAP, DTS, and OLTP with high level experience in T-SQL (DDL, DML) programming, coding and documentation.
• Knowledgeable in data Normalization/De-Normalization, Data Design methodology and build Referential Integrity on tables in a database.
• Expert in creating T-SQL functions, views, triggers, cursors, dictionary, stored procedures, sub queries, and joins.
• Expertise in creating and managing Conceptual, Logical, Physical Data Models, database Backup and Restore.
• Expert in Relation Database Management Systems(RDBMS) concept applicable to various databases like SQL Server 2008/2000/2005 and Oracle 11g/9i/8i
• Expertise in Extracting, Transforming and loading data from various sources (excel, csv file, notepad, Text file, OLEDB, data warehouse etc.) with the help of tools such as SSIS, DTS, Bulk Insert, BCP and XML.
• Excellent data analyzing skills from a Data Warehouse by creating cubes and subsequently the OLAP database.
• Skillful in creating matrix parameterized and drill through reports with SQL Server Reporting Service.
• Strong analytical skills with adequate knowledge of developing and supporting analysis and data integration using oracle SQL.
• Proficient in Microsoft SQL server, Oracle SQL Server and BI development tools.
• Excellent communication skills.

TECHNICAL SKILLS:

• SSAS, SSIS, SSRS, DTS
• SQL Server2008,2008 R2,2012
• Oracle9i/8i/ 11g
• T-SQL, PL/SQL, MDX
• Java, JavaScript
• HTML, XML, CSS, PHP, Asp.net
• Linux (GUI, CLI)
• Visual Studio 2010, 2012 and later

EXPERIENCE:

Confidential, NY

MS SQL Server ETL Developer

• Performed report designing based on the business needs and user requirements
• Designed and deployed reports in MS SQL 2008 using SSRS.
• Wrote simple to complex stored procedures to create reports for SSRS reports scheduling, snapshots and subscriptions.
• Applied various techniques of dimensional data modeling and created complex reports on MS SQL Server using SSRS
• Used SSIS to integrate data to and from various sources
• Created data cubes, dimensional model and hierarchies using OLAP reporting services
• Created Crystal reports and involved in maintaining connection between ODBC and OLEDB and created link between various databases.
• Documented and maintained database systems for website development
• Developed a secure web application and back-end database to automate processes
• Created web applications and performed upgrades
• Designed clean-up processes and performance improvements.
• Performed data migration from 2008 Microsoft SQL Server Database to 2012 database
• Created MDX scripts for financial team to meet the expected results

Confidential, NY

SQL Developer

• Worked with large databases and Updated codes for execution and ensured high-performance by tuning and optimization
• Edited and converted ASP.Net codes from ASP.NET version 1.0 to current version
• Extracted, Transformed and loaded Clinical data from Ingres Database to SQL 2014 Database using SSIS.
• Converted Ingres Database codes to SQL 2014 database manually editing every bit of codes
• Performed Production Operation on data integration and assisted project management team to resolve issues for automation and reporting using SQL Server Reporting Tools.
• Worked with Internal IT team to import and export data to and from various homogenous and heterogenous sources.
• Tested and Debugged SQL Codes and confirmed that each one is executable and resolved issues if any.
• Created web-based reports and applications and updated old applications on LINUX using NANO editor
• Designed, developed, and deployed reports in SQL 2014 using Advanced Query Tool (AQT)
• Created, updated, and edited stored procedures, triggers and packages and UDF functions on database
• Created Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting
• Created and generated Tabular, Sub reports, Parameterized reports, pie charts and bar charts for the Business users and created report models to support ad hoc Reporting
• Performed Drill-down, Drill-through, and Sub-Report using RDL. Promoted RDLs to Reporting Service Server

Confidential, NY

ETL Developer D T Sales & Storage

• Designed Database for business requirements Implemented structured and high-performance database codes, applied optimization techniques for large database.
• Created and designed reports using Microsoft SQL SSRS tool.
• Extracted, Transformed and Loaded data from variety of sources and designed tables using those data
• Designed and deployed SSIS Package to production server
• Developed Models for reports and created multidimensional reports
• Performed report integration, managed delivery, subscription on User interface.
• Took primary responsibilities for developing, monitoring and deploying SSIS package
• Designed and developed applications using ASP.net
• Edited and Updated applications using Linux commands.
• Worked on ETL environment that involved data structuring, cleansing, and integrating to and from various sources such as OLEDB, flat file, Excel sheet etc.

Confidential

BI Developer

• Performed Extraction, Transformation and data loading to migrate data from one database to another.
• Performed Windows 7 installation and configuration to migrate data from SQL 2008 to SQL 2012.
• Installed SQL Server 2012, TFS 2012 and Migrated all the scripts and objects from SQL 2008 to SQL 2012.
• Developed and created scripts, stored procedures, database objects (tables) and History tables to store information of every action performed on database tables for the future reference.
• Created facts and dimension tables for future extensions.
• Performed Query Optimization and performance tuning to enhance the loading time reduction to load data
• Imported SLIM data from various heterogeneous sources to a database on 2008 server and then from 2008 to SQL 2012.
• Ran Linux Commands to update applications using Nano Editor
• Worked closely with report development team to create new reports.
• Worked very closely with DBAs to give Production server support.
• Implemented data cleansing and performance tuning by using SSIS packages
• Wrote complex scripts that produced reports