We provide IT Staff Augmentation Services!

Sql Bi Developer Resume

Cary, NC

SUMMARY

  • 8 years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2012/2008/2005/2000.
  • Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
  • Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
  • Expert in creating and using Stored Procedures, Views, User Defined Functions.
  • Expert in creating and Sub-Queries Joins for complex queries involving multiple tables and Exception Handlers.
  • Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
  • Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
  • Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
  • Excellent experience in maintaining Batch Logging, Error Logging wif Event Handlers and Configuring Connection Managers using SSIS.
  • Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, flat files using connectors, tasks and transformations provided by SSIS.
  • Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for teh business users.
  • Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
  • Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
  • Excellent verbal and written communication skills combined wif interpersonal and conflict resolution skills and possess strong analytical skills.
  • Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented wif a desire to learn client's business requirements.
  • Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Operating Systems: Windows 2008, 2003R2, 2003, 2000 Advanced Server, Windows NT, Windows 95/98/2000 XP/Unix

Databases: MYSQL Server 2000/2005/2008/2008 R2/2012, MS Excel/MSWord/MS Access

Database Tools: SQL Enterprise Manager, SQL Profiler, Power Shell, DTS Import/Export, SQL Client Configuration utility, MS OLAP Services, SSMS, SQL Server BIDS/SSDT(SQL Server 2012)

Modeling Techniques/Tools: Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modeling, ER Diagrams, MS Visio, Rational Rose

ETL Tools: Experienced working wif SSDT/BIDS-DTS, SQL Server Integration Services (SSIS), SQL Server Reporting (SSRS).

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports

Development skills: Transact SQL (T-SQL)

Languages: C, C++, HTML, XML/XSLT/.Net/C#

PROFESSIONAL EXPERIENCE

Confidential, Cary NC

SQL BI Developer

Responsibilities:

  • Deployed SSIS packages wif minimal changes using XML configuration file
  • Used MDX to query Analysis Service Databases, debugging and supported teh purpose of data analysis
  • Created various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters
  • Scheduled teh monthly Reports/weekly reports/daily reports Based on user Requirements
  • Involved in Unit testing, User Acceptance testing to check whether teh data is loading into target, which was extracted from source systems.
  • Directly interacted wif customer for achievingnormalizationand improving data retrieval bydropping and creating indexesas per their business requirement and providing queries and stored procedures for their current SQL server databases.
  • Gained good experience of writingSQL codesusingPragma autonomous transactions, required as per business rules along wifwriting complex Procedures, Functions & Packages using cursors & loops.
  • Usedexception handlingfor handling numerous common errors for displaying easy to understand messages and ease in debugging.
  • Participated actively in mapping sessions as well as indata conversionfor proper addition of legacy data into our product tables and adding appropriate required database objects.
  • Added propermonitoring stepsanderror handlingforETL jobs and Packages/Procedures
  • Created and developed complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
  • Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
  • Worked wif various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split etc. as part of ETL. Worked wif Change Data Capture Task
  • Created and managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
  • Deployed SSIS packages wif minimal changes using XML configuration file.

Environment: SQL Server 2012, SQL Server 2008R2, SSIS, SSRS, SSAS

Confidential, San Francisco, CA

SQL BI Developer

Responsibilities:

  • Created ETL packages wif different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and tan loaded teh data into destination tables by performing different kinds of transformations using SSIS packages.
  • Developed teh packages wif monitoring features and logging so that audit information of teh packages and their execution results are loaded in to teh audit table.
  • Created checkpoints and configuration files in SSIS packages
  • Implemented slowly changing dimensions in SSIS packages.
  • Performed incremental data load in BIDS using Lookup Transform, Cache Transform, and Merge Join Transform.
  • Automated execution process of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and SMTP.
  • Generated various reports wif drilldowns, calculated members, dropdowns from teh cubes by connecting to Analysis server from SSRS.
  • Created data sources, connection strings and defined teh datasets for generating teh report.
  • Designed and written teh queries in teh query builder for retrieving teh data.
  • Created and worked wif drill down reports and identified teh report parameters.
  • Used various report items like tables, sub report and charts to develop teh reports in SSRS.
  • Deployed and generated reports on to teh server using teh Reporting Services Report Manager.
  • Created subscriptions to provide a daily basis reports.
  • Created Dimensions wif teh cube wizard and also individually and Generated Named calculations and Named queries.
  • Involved in defining referenced relationships wif measure group and fact tables.

Environment: SQL Server 2012, SQL Server 2008R2, SSIS, SSRS, SSAS, BIDS, SSDT

Confidential, NY

SQL BI Developer/SSIS/SSAS/SSRS

Responsibilities:

  • Worked extensively wif SSIS to import, export and transform teh data from xml and text files
  • Extensively used Merge command as alternative to small SSIS packages in dimension and fact load
  • Used several SSIS control flow and data flow transformations as part of ETL
  • Deployed SSIS packages wif minimal changes using XML config file
  • Involved in business analysis and technical design sessions wif business and technical staff to develop dimensional models, requirements document, and ETL specifications
  • Created database objects like Procedures, Functions, Triggers, Indexes
  • Used SQL Profiler to optimize Stored Procedures
  • Modified star schema and identified teh requirement of snow flake schema in teh design
  • Loaded fact and dimension tables as part of modified data warehouse solution
  • Build an analysis services database on already existing data warehouse solution
  • Created measures, measure groups, dimensions and multi-dimensional cubes
  • Created tabular reports, list reports, parameterized reports, drill down reports according to business requirements in time restricted environment
  • Involved in creating, structuring, formatting using report designer

Environment: MS SQL Server 2005, SSIS, SSAS, T-SQL, Windows Sever 2003, SQL Server Management Studio, SQL Profiler

Confidential, Los Angeles, CA

MSBI Developer

Responsibilities:

  • Worked extensively wif SSIS to import, export and transform teh data from xml and text files
  • Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data warehouse
  • Extensively used Merge command as alternative to small SSIS packages in dimension and fact load
  • Used several SSIS control flow and data flow transformations as part of ETL
  • Deployed SSIS packages wif minimal changes using XML configure file
  • Involved in business analysis and technical design sessions wif business and technical staff to develop dimensional models, requirements document, and ETL specifications
  • Created database objects like Procedures, Functions, Triggers, Indexes
  • Used SQL Profiler to optimize Stored Procedures
  • Modified star schema and identified teh requirement of snow flake schema in teh design
  • Loaded fact and dimension tables as part of modified data warehouse solution
  • Build an analysis services database on already existing data warehouse solution
  • Created measures, measure groups, dimensions and multi-dimensional cubes
  • Created tabular reports, list reports, parameterized reports, drill down reports according to business requirements in time restricted environment
  • Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
  • Wrote efficient stored procedures for teh optimal performance of teh system.
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating teh integrity of teh data.
  • Created indexed views and appropriate indexes to reduce teh running time for complex queries.
  • To keep track of data manipulations using Audit functionalities.
  • Generated custom and parameterized reports using SSRS.
  • Created reports that call sub reports in SSRS.
  • Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.

Environment: SQL Server 2008R2, SSIS, SSRS, SSAS, BIDS, SSDT

Confidential

MS SQL Server Developer

Responsibilities:

  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted teh results into reports and kept logs.
  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
  • Identify columns for Primary Keys in all teh tables at teh design time and create them.
  • Create functions to provide custom functionality as per teh requirements.
  • Created tables, views, indexes based on teh requirements
  • Wrote complex SQL queries to retrieve information from teh databases depending on teh requirement.
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server.
  • Involved in teh complete data warehouse development life cycle. Actively supported business users for change requests.
  • Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
  • Extract Transform Load(ETL) development Using SQL server 2008,SQL 2008 Integration Services(SSIS)
  • Designed and created teh table schema and stored procedures that will be used in Data QC.
  • Used Joins and sub-queries for complex queries involving multiple tables from different databases.
  • Handling Errors and Debugging teh ETL packages.
  • Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
  • Responsible for documentation of system related activities.
  • Provides technical documentation of teh system.

Environment: SQL Server 2000, Windows NT 4.0/2000, Excel.

Hire Now