ULLAS A ULAHANNAN

BUSINESS INTELLIGENCE DEVELOPER (SQL & ETL)

Email: adz7aq@r.postjobfree.com

Ph.: 727-***-****

PROFESSIONAL SUMMARY:

Overall twelve (12+) years of experience in Software Analysis, Design, Development, Testing and Implementation of Business Intelligence/Data Warehouse Solutions using Microsoft SQL Server 2017/2012/2008 R2/2008/2005.

Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.

Experienced in all the stages of Software Development Life Cycle and in the migration and up gradation of databases.

Data warehouse design using Top-down and bottom-up and Data Mart design using Star Schema and Snow-Flake schema.

Monitored and tuned the performance of Complex T-SQL queries and stored procedures by analyzing the execution plan and also using tools like SQL Server Profiler.

Created partitions on tables, indexes and index views as well as querying and managing partitions from optimization point-of-view according to the business criteria.

Responsible for Database consistency checks using DBCC utilities, Performance Tuning and Query Optimization.

Worked on mapping documents creation as well as development for Data migration, data import, Initial and Incremental load.

Performed data cleansing using different transformations within SSIS packages to eliminate redundant data from the pre-staging database.

Designed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate and Derived Column Transformations.

Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings (SSIS or Custom Loggings).

Created package configurations to provide an easy solution to migrating packages from different business environments like development to testing or testing to production.

Planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.

Optimized cubes by assigning appropriate storage modes to partitions and created usage-based optimizations for better query performance.

Generated various reports like tabular, matrix, parameterized, sub reports, drill down and drill through reports using SSRS.

Experience with the formatting of reports for various visual representations using conditional formatting and templates.

Hands-on experience of setting up schedules for push and pull delivery methods for SSRS reports using Standard and Data Driven Subscriptions.

Deployed different types of report on Share Point 2010 and used dashboard.

Well versed in Scheduling Jobs and Alerts using SQL Server Agent to run Stored Procedures and SSIS Packages.

TECHNICAL SKILLS:

Data Modeling Tools:

Erwin, MS Visio

Databases:

MS SQL Server 2017/2012/2008R2/2008/2005

BI & Version Control Tools:

BIDS/SSDT, SSIS, SSAS, SSRS, Team Foundation Server (TFS), Bitbucket, Surround

Operating Systems:

Windows 7/Vista/XP/NT/2003, Windows Server

Language:

C, C++, VB.Net, VB 6.0

EDUCATION:

Bachelor of Engineering in Computer Science from Komarapalayam, India 2005

Diploma in Computer Technology from Coimbatore, India 2002

PROFESSIONAL EXPERIENCE

Trellance Tampa, FL Aug 2021 to Present

Business Intelligence Developer (SQL & ETL)

Project: Credit Union

Responsibilities:

Captured and documented data business rules and definitions.

Perform scheduled maintenance and support release deployment activities after hours.

Fine tuning and optimizing the existing SQL scripts for better performance enhancement

Created jobs to retrieve data from the FTP site and for download that helps in the automation of the process.

Documents ETL data mappings, data dictionaries, processes, programs and solutions as per established standards for data governance.

Assist developers with complex query tuning and schema refinement.

Deliver the products to clients in a timely manner and without errors.

Using tools like SP_WHOISACTIVE,SP_who to diagnose server reliability and performance issues.

Ensure all database servers are backed up in a way that meets the business’s recovery point objectives.

Tuning SQL queries to improve performance.

Moving data from source to DataMart through various levels.

Fixed the bugs in client server as requested by clients.

Create and monitor the SQL Jobs and ensure that no SQL Server jobs have failed.

Refine and automate regular processes, track issues and monitor changes

Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Automated the ETL process by scheduling SSIS package execution by creating and scheduling jobs. Also gave alert to the necessary stake holders when the Job fails so that the error can be fixed in a timely manner.

Developed SQL-based test and audit scripts to validate SSIS packages and data loads.

Supported production environment by creating batch files to start and stop various SQL services and installation scripts.

Created Indexes and Views on various entities of the databases.

Environment: Microsoft SQL Server 2017/2012/2008R2, BIDS/SSDT, SSIS, TFS, Bitbucket, Surround

V12Data Tampa, FL Aug 2018 to Aug 2020

Business Intelligence Developer (SQL & ETL)

Responsibilities:

Captured and documented data business rules and definitions.

Perform scheduled maintenance and support release deployment activities after hours.

Fine tuning and optimizing the existing SQL scripts for better performance enhancement

Created jobs to retrieve data from the FTP site and for download that helps in the automation of the process.

Documents ETL data mappings, data dictionaries, processes, programs and solutions as per established standards for data governance.

Assist developers with complex query tuning and schema refinement.

Deliver the products to clients in a timely manner and without errors.

Using tools like SP_WHOISACTIVE,SP_who to diagnose server reliability and performance issues.

Ensure all database servers are backed up in a way that meets the business’s recovery point objectives.

Tuning SQL queries to improve performance.

Create and monitor the SQL Jobs and ensure that no SQL Server jobs have failed.

Refine and automate regular processes, track issues and monitor changes

Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Automated the ETL process by scheduling SSIS package execution by creating and scheduling jobs. Also gave alert to the necessary stake holders when the Job fails so that the error can be fixed in a timely manner.

Developed SQL-based test and audit scripts to validate SSIS packages and data loads.

Supported production environment by creating batch files to start and stop various SQL services and installation scripts.

Created Indexes and Views on various entities of the databases.

Environment: Microsoft SQL Server 2012/2008R2, BIDS/SSDT, SSIS, TFS

Aspire Financial Services LLC Tampa FL May 2017 to Jul 2018

SQL Developer/DBA

Project: Retirement Planning Solutions

Responsibilities:

Captured and documented data business rules and definitions.

Perform scheduled maintenance and support release deployment activities after hours.

Provide 24/7 support for critical production systems.

Assist developers with complex query tuning and schema refinement.

Take part in the Migration Process. Review the migration code and make necessary changes.

Using tools like SP_WHOISACTIVE to diagnose server reliability and performance issues.

Backup the current databases in Dev/QA/UAT environments and do the copy of production databases to the Dev/QA/UAT environments after each Production release.

Ensure all database servers are backed up in a way that meets the business’s recovery point objectives.

Tuning SQL queries to improve performance.

Create and monitor the SQL Jobs and ensure that no SQL Server jobs have failed.

Refine and automate regular processes, track issues and monitor changes

Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Automated the ETL process by scheduling SSIS package execution by creating and scheduling jobs. Also gave alert to the necessary stake holders when the Job fails so that the error can be fixed in a timely manner.

Developed SQL-based test and audit scripts to validate SSIS packages and data loads, SSRS reports, and report stored procedures.

Supported production environment by creating batch files to start and stop various SQL services and installation scripts.

Created Indexes and Views on various entities of the databases.

Environment: Microsoft SQL Server 2012/2008R2, BIDS/SSDT, SSIS, SSRS, SQL Profiler, TFS

EQ Health Solutions Tampa, FL Jun 2014 to Apr 2017

Business Intelligence Developer (SQL & ETL)

Client: Cigna, Aetna, Wellcare

Project: Healthcare Insurance

Responsibilities:

Captured and documented data business rules and definitions.

Accommodated and facilitated Joint Application Development (JAD) session, documented, analyzed and synthesized the results as parts of business requirements.

Created SQL automation script for different DB objects creating, disabling and dropping with file structure including tables, functions, procedures, PKs, FKs, triggers and indexes.

Created and executed SQL queries to perform Data Integrity testing on a SQL Server Database to validate and test data using SSMS.

SSIS tasks such as Conditional Split, Derived Column, Lookup transformation, which were used for Data Cleansing, data validation checks during Staging, before loading the data into the Production Server.

Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Automated the ETL process by scheduling SSIS package execution by creating and scheduling jobs. Also gave alert to the necessary stake holders when the Job fails so that the error can be fixed in a timely manner.

Developed SQL-based test and audit scripts to validate SSIS packages and data loads, SSRS reports, and report stored procedures.

Environment: Microsoft SQL Server 2012/2008R2, BIDS/SSDT, SSIS, SSAS, SSRS, SQL Profiler, SharePoint 2010, TFS

Alere San Diego, CA Jun 2012 to Jun 2014

Business Intelligence Developer (SQL & ETL)

Responsibilities:

Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis.

Involved in the design of data marts using star schema and Kimball Methodology.

Created new database objects like Procedures, Functions, Indexes and Views using T-SQL.

Utilized Dynamic SQL for user customizable queries to be answered by the SQL Server.

Written SQL script to analyze the historical data and extracted required data to support the management decisions.

Created complex stored procedures to perform Index maintenance, data profiling, metadata search (DB2 and Oracle), critical staging procedures for loading DataMart and reporting database.

Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access and excel.

Written basic VB.Net scripts to implement Type 1 and Type 2 Slowly Changing Dimensions for Incremental load.

Incorporated Error Redirection during ETL Load in SSIS Packages.

Implemented various types of SSIS Transformations in Packages including Aggregate, Fuzzy Lookup, Conditional Split, Row Count, Derived Column etc.

Implemented the Master Child Package Technique to manage big ETL Projects efficiently.

Involved in full life cycle of Reporting starting from the Authoring phase, the Management phase all the way to the Delivery phase.

Developed SSRS Reports like drill through, drill down, linked, sub reports and parameterized reports.

Involved in creating report snapshots and cache for better performance.

Formatted the reports by applying parameters and assigned parameter defaults and data types and extended reports.

Environment: Microsoft SQL Server 2008/R2, BIDS, SSIS, SSAS, SSRS, Erwin, T-SQL, TFS, VB.Net

Pilgrim software Tampa, FL Jan 2011 to Jun 2012

Business Intelligence Developer (SQL & ETL)

Client: HCA Healthcare

Responsibilities:

Involved in creation and review of business requirement specifications and supporting documents for business systems, experience in database design process and data warehouse design and development process.

Refined the performance of various SQL scripts and stored procedures by using UDFs, CTEs and System stored procedures along with usage of tools like SQL Profiler and Database Tuning Advisor.

Created Triggers to update master tables in order to authenticate the transactions depending on business logic.

Designed and implemented complex stored procedures with proper error handling, transactions and performance tuning features.

Designed indexes and indexed views to speed up query performance and used Database engine tuning advisor for further suggestions.

Creating and executing SQL queries to perform Data Integrity testing on a SQL Server Database to validate and test data using SSMS.

Supported production environment by creating batch files to start and stop various SQL services and installation scripts.

Worked on creation of mapping documents and development of ETL strategy for Initial and incremental load.

Extracted data from various sources like SQL Server 2008/2005, Oracle, .CSV, Excel and Text file from Client servers and through FTP.

Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages.

Created several reports using SSRS like drill through reports, linked and sub reports.

Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.

Generated reports using SSRS and Excel Spreadsheets with Power pivots and deployed them in SharePoint integrated mode.

Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.

Optimized reports by optimizing the embedded queries or optimizing the stored procedures that generate them.

Environment: Microsoft SQL Server 2012/2008R2, BIDS/SSDT, SSIS, SSAS, SSRS, SQL Profiler, SharePoint 2010, TFS

Contact this candidate