SUMMARY

• 10+ years of experience in analysis, design, development, implementation and production support in areas of SSIS, Data Warehouse (EDW) development.
• Extensive experience in developing ETL programs, processes and architecture using Microsoft SQL Server, SSIS 2012, 2008R2, 2005)
• Experienced in all phases of Software Development Lifecycle and Software Maintenance Lifecycle.
• Extensive development experience in developing of dimensional data model, start schema and Snow Flake schema using Kimball Methodologies.
• Developed ETL programs to process Dimensions, Facts, Slowly Changing Dimensions, Conformed Dimensions, and Metadata.
• Advanced level skills in SQL, T - SQL programing
• Designed and developed multiple Data Marts from EDW and ODS
• Proficient in implementing business within Data processing and ETL processes using efficient stored procedures and functions and database triggers.
• Reviewed and created technical design specifications to ensure compliance with functional specification.
• Experienced in database performance tuning by using query optimization techniques, identifying need of indices and implementing them.
• 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 using C#, Analysis Services Task, Data Mining Task.
• Integrated numerous data sources with diverse data models and business rules into a uniform and consistent Data Warehouse.
• Sourced data from various types of relational databases, flat files, excel files, Share point List, OLAP databases, DB backup files from various types of databases
• Designed and developed automated ETL logging, audition and data quality check processes.
• Developed Transformations using Data Conversion, Audit, Derived Columns, Lookups, Merge, Merge Joins, Slowly Changing Dimension transformation.
• Expert level of skills in designing and developing reports in SQL Server 2008, 2005 Reporting Services.
• Customized and maintained SSAS cubes
• Well versed in Requirements/Change Management as well as Impact Analysis
• 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.
• Participated in Business and Functional Requirement Documentation.
• Experience in working on strict project management guidelines and time deadlines, providing estimates as well as timely project status.
• A team player as well as experienced in working independently.

TECHNICAL SKILLS

DBMS: SQL Server 2014, SQL Server 2012, 2008 R2, 2005, MS Access, Oracle 9i, 10G

ETL: SSIS 2012, SSIS 2008 R2, 2005, DTS Packages, T-SQL

Reporting: SSRS 2008 R2, 2005, Report Builder 3.0

OLAP: SSAS 2008 R2, 2005

Languages: SQL, T-SQL, MDX, VB Script, C, C++, C # .net

Data Modeling: Visio, ERWIN

Tools: Management Studio 2008R2, 2005, Enterprise Manager, Business Intelligence Development Studio 2008, 2005. Visual Studio 2008, 2005, ER Studio Data Architect 9.0, BI Express, BI Documenter, Autosys scheduling tool, Managed File Transfer, TFS, subversion

Operating Systems: Windows Server 2008, 2003, Windows XP, Vista, 7. UNIX

PROFESSIONAL EXPERIENCE

Lead Developer

Confidential, Pennington

Responsibilities:

• Worked on the backlog items and provided support for legacy systems.
• Perform system analysis on existing applications.
• Design and develop new ETL processes for existing applications
• Created HLD for SSIS process.
• Worked closely with DBAs to create new infrastructure and environments for existing applications
• Design and develop ETL processes to automate manual processes, notification framework
• Lead offshore development team in enhancement of stored procedures and modifying existing ETL processes for performance. Performed code reviews with offshore development team.
• Designed automated processes for ETL Notifications using event handlers, file transfer validations, Custom ETL logging and Auditing using SSIS 2012.
• Lead production support team for timely delivery of reports on daily basis, trouble shoot errors and reporting it to business.
• Fine tune ETL processes using advance properties of ETL task and ETL transformations.
• Performed detail analysis of Stored Procedures to enhance performance by indexing and using foglight tool to automate notifications on SQL Queries performance.

Environment: SQL 2014, SSIS 2008, SSIS 2012, SSIS 2014, AUTOSYS, TFS

Sr. SSIS and Data Warehouse Developer

Confidential

Responsibilities:

• Architected, Designed and developed Data Warehouse processes.
• Worked on the backlog items and provided support for legacy systems.
• Mapped disparate data sources - relational DBs and text files, SharePoint lists, excel files onto target schema
• Designed and developed stage data model and dimensional data model for data warehouse.
• Created technical design specifications based on business requirements.
• Designed Extraction Transformation and Loading (ETL) process to source from Sales Force, and text files from multiple vendors
• Established the managed file transfer (MFT) for INBOUND and OUTBOUND files with vendors.
• Performed a detail analysis of the infrastructure and inventory of DW and provided documentation and recommendation for changes.
• Designed automated processes for ETL Notifications using event handlers, file transfer validations, Custom ETL logging and Auditing using SSIS 2012.
• Successfully designed and enhance ETL process to handle large dataset of more than 1TB tables.
• Worked closely with offshore development team, lead and help to enhance the ETL processes by appropriately creating indexes and staging tables to boost the performance, apply best ETL practices.
• Involved in Requirement Analysis, Impact Analysis and Gap Analysis.
• Worked with Pragmatic Works to identify and improve on ETL bottlenecks and successfully installed the task factory to extract and load data to Sales force dot com.
• Built custom incremental ETL processes.
• Lead offshore development team in enhancement of stored procedures and modifying existing ETL processes for performance.
• Lead production support team for timely delivery of reports on daily basis, trouble shoot errors and reporting it to business.
• Mapped disparate data sources - relational DBs and text files, SharePoint lists, excel files onto target schema

Environment: SQL 2012, SSIS 2012, SSAS 2012, SSRS 2012, SQL, T-SQL, MDX, C#, SharePoint 2010,

Confidential, 

Sr. SSIS Developer

Jacksonville, FL

Responsibilities:

• Architected, Designed and developed Data Warehouse processes.
• Designed and developed stage data model and dimensional data model for data warehouse.
• Created technical design specifications based on business requirements.
• Mapped disparate data sources – relational DBs and text files, SharePoint lists, excel files onto target schema.
• Designed Extraction Transformation and Loading (ETL) process to source from 15 different data source which include 3 clinical and operational systems, Finance System – Great Plains, marketing, CRM, Sales, HRMS, Customer Satisfaction and several home-grown systems.
• Developed ETL processes to source data from flat files using SSIS 2008R2, 2012.
• Designed ETL processes to load fact and dimension tables in data warehouse.
• Developed T-SQL functions and stored procedures to support complex business requirements.
• 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
• Involved in Requirement Analysis, Impact Analysis and Gap Analysis.
• Scheduled the ETL processes on SSIS server and managed integration server.
• Developed incremental ETL processes using CDC (Change Data Capture)
• 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 using C#.
• Integrated EDI transactions data with Data Warehouse – EDI 837, 835
• Developed analytical and transactional reports using SSRS 2008R2
• Integrated SharePoint lists and custom web application to Data Warehouse
• Lead several projects as Technical Lead.
• Kept the track of ETL related tasks, identified issues and road blocks and provided report to management as well as provided way to resolve the issues.
• Designed and developed OLAP cubes.
• Designed and developed reporting solutions

Environment: SQL Server 2008R2, 2012, SSIS 2008 R2, SSAS 2008R2, SSRS 2008R2, SQL, T-SQL, MDX, C#, SharePoint 2007, 2010 integration, Info Path