BI Developer Resume Nashville, TN - Hire IT People

PROFESSIONAL SUMMARY:

Business Intelligence Developer with 5 years of work experience in developing Business Intelligence solutions in an Agile environment.
Strong experience in using the Microsoft BI Stack (SSIS, SSRS, SSAS and SQL). Worked with SQL server /2012/2014
Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency
Experienced in creating SSIS packages for ETL purposes. Data Migration from various type of sources (Excel, flat file, csv, XML, OLTP DB etc.), Data Conversions, Data Extraction/ Transformation/Loading (ETL).
Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors. Troubleshooting SSIS packages using a variety of techniques/tools.
Experience in designing and developing reports in SSRS using the data from ETL Loads, Developing Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS)
Troubleshooting and problem - solving skills, ability to prioritize multiple tasks.
Excellent communication skills, proactive, self-managing and teamwork spirits.

TECHNICAL SKILLS:

Databases: SQL Server

Operating Systems: Various Windows

IDE & BI Tools: SQL Server BI Development Studio (BIDS), SQL Server Management Studio (SSMS), SQL Profiler

Development Methodology: Agile Methodology

Reporting Tools: SQL Server Reporting Service(SSRS)

ETL: SQL Server Integration Service(SSIS)

Job Scheduler: SQL Server Agent

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

BI Developer

Responsibilities:

Designed and created an ETL solution to consolidate mortgage loan applications received from various sources. Numerous reports were also created to meet the client’s need.
Worked on all activities related to the development, implementation, administration and support of ETL processes.
Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
Used advanced SSIS tools (Derived Columns, Conditional Split, Look-up Transformation, Aggregations, Multicasting).
Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.
Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for optimized performance.
Enhanced performance using optimization techniques-normalization and indexing
Performance tuning of Queries and Stored Procedures.
Performance tuning on existing ETL packages.
Designed various SSRS reports as requested by the client.
Created and developed Sub-Reports, Drill down reports, Drill through reports and Parameterized reports, Matrix reports using SSRS.
Created Dashboards, Tabular, Matrix reports, Charts, graphs and Gauges as per customer requirements Using SSRS.
Utilized triggers,, dynamic coding and job processing.

Confidential, Nashville, TN

SQL Server SSIS/SSRS/ Developer

Responsibilities:

Involved in the complete SDLC including requirements specifications, analysis, design, development and testing of application.
Profiled data from the source, and transformed the data to meet the user’s requirement.
Designed and developed the staging database and loaded from source to staging and from staging to the destination tables applying different transformations.
Designed SSIS packages using several transformations.
Implemented incremental load, slowly changing dimension (SCD) type 2 to maintain historical data.
Designed package to do ETL auditing and designed stored procedures.
Used different sources like excel, xml, and flat files to extract data.
Extensively used SSIS transformation such as lookup, derived column, data conversions, conditional split, SQL task, script task and send mail task,
Created Dashboard reports using SSRS.
Used tabular and matrix reports layout to design reports based on the requirements.
Created parameterized reports, drill down, and drill through reports using SSRS.
Created new tables views indexes, user defined functions and stored procedures.
Used execution plan, SQL profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
Created SSIS jobs and scheduled packages using SQL server management studio for the daily load.
Extensively used joins and sub-queries to simplify complex queries involving multiple tables.