Business Intelligence/SSRS Developer Resume Miami FL - Hire IT People (2024)

SUMMARY

• Around seven Years of extensive IT experience as SQL Server and Microsoft Business Intelligence applications developer, Specialized as an ETL Developer with expertise in SQL Server Integration, Analysis and Reporting Services. (SSIS, SSRS & SSAS)
• Expertise in analyzing, designing, and developing Client/Server, Business Intelligence (BI) database applications using MS SQL Server 2012/20, SQL Server Integration, Reporting & Analysis Services.
• Strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Extensive expertise in Media, Insurance, Healthcare, Finance, Automobile sectors.
• Expertise in using T - SQL (DML, DDL).
• Involved in creating numerous database objects like tables, indexes, constrain (Checks, Primary and Foreign Key).
• Involved in designing T-SQL programming artifacts such as complex queries, stored procedures, triggers (DDL and DML), indexes, and user defined functions.
• Strong debugging skills and the ability to solve complex problems.
• Extensive experience in Tuning SQL queries& improving the performance of the Database.
• Well versed in OLTP/OLAP environment.
• Experienced in creating SSIS packages (.dtsx) involving ETL process, extracting data from various sources(flat files, excel files, legacy systems) and loading for data warehousing using SQL server integration services.
• Experience in Transforming and validating data using Control Flow item and Data Flow Transformations.
• Experience in creating SSIS package configuration, logging, jobs, scheduling, and error handling in SSIS packages.
• Experience in performance tuning in SSIS using row transformations, block and unblock transformations.
• Involved in installation, configuration, development, deployment of Reporting Services using SSRS 2012/2008/2005
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Experience in developing Ad-Hoc, drill down, drill through reports, parameterized reports, sub reports, linked reports using SQL Server Reporting Services (SSRS) and Report Builder 3.0.
• Experience in converting Crystal reports and Excel based reports to SSRS reports.
• Involved in scheduling and deploying reports and uploading files to a report server.
• Proficient in data warehouse design concepts, experienced in relational, multi-dimensional (Star) and snowflake, logical and physical data modeling and data mapping.
• Experience in creating Cube in SQL server analysis services and edit various properties, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Performance tuning in cube by creating storage modes (MOLAP, ROLAP and HOLAP), aggregations, and usage based optimization.
• Good knowledge about administrative tasks such as data loading, unloading, scheduling backup, performance tuning, optimization, recovery.
• Excellent communication, analytical and inter personal skills and ability to learn new concepts.
• Ability to work individually as well as in a team, quick learner, self-motivated, out of box thinker with excellent communication and interpersonal skill.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, C, HTML, XML

Database Application Software: MS SQL server 2012/20, MS Access 97/2000/2003

Business Intelligence Tools: DTS Import/Export, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Report Builder 3.0, Power Pivot, QlikView, Crystal Reports.

Application Software: Microsoft Office, Visual Studio, MS SharePoint, Business Intelligence Development Studio (BIDS).

Modeling Tool: FACT and Dimensions table modeling.

Operating Systems: Windows 8/7/XP/NT/2000, IOS.

PROFESSIONAL EXPERIENCE

Confidential, Miami FL

Business Intelligence/SSRS Developer

Responsibilities:

• Involved in gathering business requirements, interacting with the client and preparing detailed design document.
• Created and optimized database objects such as views, functions and stored procedures as per requirement.
• Created complex stored procedures with parameters and generated multi parameterized SSRS reports from them, where the user has a choice to select the parameters.
• Gathered data from multiple data bases across the organization and produced reports for different departments.
• Converted existing Excel based reports and crystal reports to SSRS reports.
• Created Drill Down, Drill Through, linked, matrix, Charts, lists, Sub reports using SSRS and managed their subscriptions.
• Created dashboards for Sales, Inventory, Performance and finance.
• Created OLAP cubes using SSAS and created reports from them.
• Deployedanduploaded the SSRS reportstoReport Manager &SharePoint Serverfor the end users and involved in enhancements and modifications.
• Worked in extracting transforming and loading (ETL) data across multiple databases using SSIS packages.
• Improved existing reports performance by using execution log2 and optimized the underlying procedure and queries.

Environment: MS SQL Server 2012/2008/2008 R2, Visual Studio2012/2010, SSRS, Windows 7, SharePoint 2010, Report Builder 3.0, QlikView, SQL Profiler, SQL Server Agent, Power Pivot.

Confidential, Atlanta GA

Business Intelligence /Sr.SQL Server Developer

Responsibilities:

• Involved in requirement gathering, design and development.
• Involved in creating views to display only required information and to maintain privacy.
• Created triggers to validate consistent data entry into the database.
• Wrote many complex SQL queries and created constraints to maintain data integrity.
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Created SSIS package to transfer data between heterogeneous data sources.
• Transforming and validating data using SSIS Transformations and scheduled SSIS packages.
• Extensively used various SSIS Control flow tasks like Loop Containers, FTP, Bulk insert task, Transfer job task etc. and different data flow tasks like Derived Column, Fuzzy lookup, merge join, Multicast, data conversion etc.
• Extensively used SSIS Data Profiler Task to profile target source systems (tables & views)prior to building ETL solutions, which was instrumental in cleaning data for data consistency and designing the table structures.
• Deployed SSIS packages across various Environments (Development/Test) using configuration files and variables.
• Created reports using SSRS from various sources like SQL Server and Cubes from Analysis Services.
• Worked on SSRS Reports, Sub Reports, Data Drill-Down, and Data sorting/grouping.
• Designed reports using bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager.
• Created SSAS OLAP Cubes and Partitioning Cubes, monitored and full and incremental load using cube wizard.
• Involved in performance tuning of cubes, optimization of queries, to improve performance.
• Supported team for performance testing by extending work hours and on weekends

Environment: MS SQL Server 2012/2008/2008 R2, SSIS, SSAS, SSRS, Visual Studio2012/2010, Windows 7, SQL Server Agent, Crystal Reports.

Confidential, Jacksonville, FL

Sr. SQL Server Developer/ Business Intelligence

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Developed and deployed complex SSIS packages for extracting data from different sources
• Implemented the concepts of Incremental Data Load and Slowly Changing Dimensions for updating and maintaining the history of the records.
• Designed many SSIS Configuration files that were used to pass parameters from outside the Business Intelligence Development Studio (BIDS) into the packages using XML files.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL.
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Created Huge Stored Procedures, User Defined Functions, Views and Implemented the Error handling in Stored Procedures and SQL Objects and also altered existing stored procedures, triggers, views, indexes depending on the requirement.
• Used Dynamic SQL to implement multiple processes with same code.
• Used joins and common table expressions to simplify queries involving multiple joins.
• Involved in generating SSRS reports for Forecasting Revenues based on the historical data.
• Created Ad-Hoc Reports Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements.

Environment: MS SQL Server 2008/2008 R2, SSIS, SSAS, SSRS, Visual Studio2008, Windows 7, SQL Server Agent, SQL Profiler.

Confidential, Atlanta, GA

SSIS/SSRS/SQL Server Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specifications for development.
• Involved in daily data loading using Full and Incremental load into database.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Experience in SQL joins, sub queries, tracing and performance tuning.
• Transferred data from various data sources systems including MS Excel, MS Access, Flat Files to SQL Server using SSIS using.
• Created SSIS packages and scheduled the jobs to run automatically.
• Created SSIS Configuration files and logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Event Handling, Error Handling, Alerting and Maintaining SSIS packages.
• Involved in development, integration and creating reports.
• Created reports such as drilldowns, drill through, sub-reports, Parameterized Report.
• Maintained Locks and performance of SQL Server.

Environment: MS SQL Server 2008, SSIS, SSRS, BIDS, Windows 7

Confidential

SQL Server Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, deployment.
• Creating SQL Server stored procedures for clinical databases.
• Tuning and updating stored procedures according to the requirements.
• Created tables, relationships, constraints. Wrote SQL Queries, views for preproduction and post production clinical data.
• Maintained the customer databases and tuning database instances.
• Worked with all database objects, including tables, cluster indexes, views, and procedures.
• Troubleshoot problems concerned with the databases, applications, and development tools.
• Worked on Data modeling, normalization, de-normalization, physical database design, and relational data models.
• Design and implementation of Backup & Recovery strategies.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: MS SQL Server 2005, Windows XP, MS Excel.

Confidential

SQL Server Developer

Responsibilities:

• Involved in installation and configuration of SQL server.
• Data gathering and importing into SQL Server Database.
• Created database objects like tables, user defined functions and cursors using DDL, DML statements.
• Developed stored procedures and views for managing efficient data retrieval.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Proper use of Indexes to enhance the performance of individual queries.
• Created clustered/non-clustered indexes on tables.
• Created joins and sub-queries for complex queries involving multiple tables.
• Testing and Tuning SQL query for better performance.

Environment: MS SQL Server 2005, Windows XP, MS Excel