We provide IT Staff Augmentation Services!

Business Intelligence Developer Resume

Baltimore, MD

SKILLS

Please use this table to list the skills noted in the Required/Desired section of the Peoplefluent requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

SKILL EXPERIENCE LAST USED
  • Experience working in a data warehouse environment with business intelligence applications
  • Experience with report development using Microsoft SQL Server Reporting Services (SSRS) 2008r2
  • Experience w/SSRS BI Developer Studio, Visual Studio, SSIS, and/or other (non - Microsoft) reporting platforms
  • Experience with Crystal Enterprise and migrating Crystal Reports to SSRS a plus

EMPLOYMENT HISTORY

Confidential, Baltimore, MD

SSRS/ SSAS Developer

Responsibilities:

  • Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
  • Created SQL server Reports using SSRS 2008.Identified the data source and defined them to build the data source views.
  • Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
  • Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
  • Applied conditional formatting in SSRS to highlight key areas in the report data.
  • Generated SSRS report using Oracle Database.
  • Work on projects like Healthy Blue, Medical Loss Ratio and Account Searchlight to generate the reports.
  • Creation of the various database objects - tables/views/stored procedures - in SQL Server 2008.
  • Design and monitor construction of an business intelligence in data warehouse environment.
  • Performed the optimization, Tuning of the indexes and the queries.
  • Experienced in Crystal Enterprise and migrating Crystal Reports to SSRS a plus .
  • Used the maintenance Plan for SQL databases to recreate indexes and statistics for the performance.
  • Development, Stored Procedures, Views, Triggers, Index and SQL Scripts.
  • Created reports by extracting data from cube.
  • Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
  • Improve the performance of a cube by creating aggregations and partition of EGR 3.0 project.
  • Create few workflows in Informatica to load the data into Oracle tables.
  • Experience working in HIPAA 4010 and HIPAA 5010.

Environment: T - SQL, SQL Server2005/2008, Microsoft SQL Server Management Studio, SQL Server Integration Services (SSIS), SSRS, SSAS, Informatica, Sql and PL/SQL.

Confidential, Minneapolis, MN

Sr SQL Server/Business Intelligence Developer

Responsibilities:

  • Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
  • Excellent skills in implementing ETL Packages using DTS and SSIS 2008.
  • Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
  • Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
  • Experience working with Transfer SQL Object Task which transfer Objects in SQL Server.
  • Experience working with Execute Package Task which used to call the Child package or Sub Package from Master Package.
  • Design and monitor construction of an business intelligence in data warehouse environment.
  • Worked on several transformations in Data Flow including Derived-Column, Script Data Conversion, Conditional-Split and many more.
  • Utilized several Transformations like Lookup, Fuzzy Lookup for implementing the Transformation Logic in the Packages.
  • Proficient in implementing all transformations available on the SSIS toolbox, Package Configuration and Logging.
  • Experience with Crystal Enterprise and migrating Crystal Reports to SSRS .
  • Experience in importing/exporting data between different sources like Access/Excel etc. using SSIS/DTS utility.
  • Excellent knowledge of using variables and expressions in packages.
  • Developed complex T-SQL Queries.
  • Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors and Triggers to facilitate efficient data manipulation and data consistency.
  • Created complex conceptual database designs in SQL Server 2008 using various constraints and triggers.
  • Schedules the SQL jobs in ZEKE scheduler.
  • Experience working with Batch jobs to call .Net Code.
  • Experience working as Team Lead.
  • Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
  • Experience working with applications like Bloomberg Data which contains information like tax free Municipal Bonds from different region like North and Latin America.
  • Performed Unit Testing and Prepared maintenance plans.

Environment: Visual Studio, T - SQL, SQL Server2000/2008, Microsoft SQL Server Management Studio, SQL Server Integration Services (SSIS), SSRS, SSAS, DTS.

Confidential , Cincinnati, OH

SQL Server/Business Intelligence Developer

Responsibilities:

  • Create SSIS package to clean and load data to data warehouse.
  • Create package to transfer data between OLTP and OLAP databases.
  • Create SSIS and used the task to import and export files.
  • Create, modify, schedule, test and or trouble shoot SQL Server Integration Services
  • (SSIS) packages, stored procedures, Tables and Views.
  • Experiences in designing, Creating and processing of Cubes using SSAS.
  • Scheduling cubes processing from staging Database Tables using SQL Server Agent.
  • Aggregated the cubes with 40% Performance for better performance.
  • Processed cubes to perform incremental updates. Create Reports by extracting data from cube.
  • SSRS to create, modify, run, export, print, distribute, deploy, and troubleshoot reports.
  • Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
  • Created report snapshots to improve the performance of SSRS.
  • Involved in Unit Testing and System Testing of the application.
  • Analysis and trouble shooting of defects.

Environment: T - SQL, SQL Server 2008, Microsoft SQL Server Management Studio, SQL Server Integration Services (SSIS), SSRS, SSAS.

Confidential, Newark, NJ

SQL Server Developer / SSRS Developer

Responsibilities:

  • Writing of Stored Procedures and Functions using SQL Server 2008 and T-SQL.
  • Creation of the various database objects - tables/views/stored procedures - in SQL Server 2008.
  • Performed the optimization, Tuning of the indexes and the queries
  • Used the maintenance Plan for SQL databases to recreate indexes and statistics for the performance.
  • Development, Stored Procedures, Views, Triggers, Index and SQL Scripts.
  • Created SSIS Package to transfer data from various locations using the FTP task. Then loaded the flat file data into the database.
  • Design and monitor construction of an business intelligence in data warehouse environment.
  • Experiences in designing, Creating and processing of Cubes using SSAS.
  • Scheduling cubes processing from staging Database Tables using SQL Server Agent.
  • Processed cubes to perform incremental updates.
  • Create Reports by extracting data from cube.
  • Experiences in Dimensional Modeling.
  • Experiences in Xml scripts .
  • Create, modify, test, and troubleshoot SQL Server Reporting Services (SSRS) reports.
  • Created reports by extracting data from cube.
  • Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
  • Analysis and trouble-shooting of defects.
  • Involved in Unit testing and System Testing for the application.
  • Create database backups , restore, data replication , and database security.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server Management Studio, T-SQL, SSRS, SSIS, SSAS, Erwin.

Confidential, London, UK

SQL Server/SSRS Developer

Responsibilities:

  • Gather and analyze business requirements
  • Create data models to describe data and relationships between the data
  • Create data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.)
  • Create new database objects such as Tables, Views, Indexes, Functions, and Triggers using T-SQL in Development and Production environment for SQL Server 2000/2005
  • C reate SSIS & DTS packages to import/export data to/from data-sources such as flat file , Oracle, DB2, Exce l, Access , and XML
  • Code Stored Procedures to validate, process data needed to create and update Retail warehouse
  • Construct reports using SSRS from OLTP & OLAP Databases
  • Validate change requests, prepare effort estimates and make appropriate recommendations
  • Database planning in relation to physical and logical data architecture
  • Develop and implement database and coding standards, improve performance and maintainability of SQL Server databases
  • Provide back-end support for functional testing and performance testing .

Environment: SQL Server 2005, SQL Server 2000, T-SQL, SSIS, SSRS, SSAS, DTS, VBA-Excel, Oracle 8i/9i, Visual Studio, VB.Net, VSS, Windows 2000/XP/2003, OS/390, AIX, Linux

Confidential, London, UK

SQL Developer/SSRS Developer

Responsibilities:

  • Involved in Analysis, Design, and Development and Testing phases.
  • Analyzed the business requirements from the given specifications.
  • Writing of Stored Procedures and Functions using SQL Server 2005 and T-SQL.
  • Maintenance of the various database objects - tables/views/stored procedures - in SQL Server 2005.
  • Performed the Server optimization, Tuning of the indexes and the queries and Consolidation of SQL Server environment
  • Used the maintenance Plan for SQL Server 2000 databases to recreate indexes and statistics for the performance.
  • Design and implementation of Security Model, policies and procedures.
  • Query Optimization using Query Analyzer, Profiler, Show plan, Index Tuning and Stats Time Tool.
  • Created Snapshot Replication for the Development and Testing Databases across different Servers.
  • Development of DTS Packages, stored procedures, views, triggers, index and SQL Scripts.
  • Designed and developed complex SSRS reports.
  • Create ad hoc complex management reports as required.
  • Design and develop reports using SQL server reporting services
  • Configuration of linked servers for user to be used for data exchange.
  • Created and scheduled jobs and alerts
  • Involved in version management of source code using VSS.
  • Analysis and trouble-shooting of defects.
  • Involved in designing of reports using SSRS.
  • Involved in Unit testing and System Testing for the application.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server Management Studio, T-SQL, Microsoft SQL Server Reporting Services.

Confidential, Hyderabad, India

SQL Developer

Responsibilities:

  • Involved in designing of conceptual logical model and physical model
  • Created new database objects like procedures, functions, packages, triggers, indexes and views using T-SQL in development and production environment for SQL server 2000
  • Fine-tuned the logic in procedures, functions and triggers for optimum performance.
  • Developed database triggers to enforce data integrity and additional referential integrity.
  • Wrote transact SQL utilities to generate table insert and update statements
    Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks
  • Used SQL profiler and query analyzer to optimize DTS package queries and stored procedures.
  • Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
  • Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
  • Created stored procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.
  • Involved in performance tuning using indexing (cluster index, non cluster index) tables

Environment: SQL Server 2000/2005, MS Excel 2003/2007, MS Access 2003, Enterprise Manager, Management Studio, SQL Profiler

Hire Now