We provide IT Staff Augmentation Services!

Ms Sql Server Bi Developer Resume

3.00 Rating

Philadelphia, PA

SUMMARY

  • Over 7 years of IT experience in the analysis, design, Development, Implementation and Testing Client/Server applications using MS SQL Server 2005/2008/2008 R2/2012 and Business Intelligence in SQL Server Integration Service (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
  • Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User - defined Variables for SSIS Packages
  • Experienced in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2012/2008R2/2008/2005
  • Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data
  • Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors
  • Experienced in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool
  • Experienced in data warehouse design with both Kimball Model and Inmon Model
  • Involved in ER diagrams (Physical and Logical using Erwin) and data mapping the data into database objects
  • High expertise in creating Reports of all types in SSRS like ad hoc Reports, Drill-Down Reports, Drill-Through Reports, parameterized Reports, Pivot and Tabular Reports based on client requirement
  • Responsible for writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012/2008R2/2008
  • Expertise in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects
  • Adept in defining referenced relationships and calculated members in SSAS and used MDX queries
  • Strong experience in Stored Procedure, Formulated Stored Procedure/TSQL coding, Performance Tuning and Query Optimization
  • Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins
  • Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS)
  • Extensive knowledge in developing and implementing Disaster Recovery Model, and Replication Models
  • Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance
  • Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies

TECHNICAL SKILLS

  • MS SQL Server 2012/2008R2/2008/2005
  • SQL Server Integration Services (SSIS)
  • SQL Server Analysis Services (SSAS)
  • SQL Server Reporting Services (SSRS)
  • BIDS
  • Import/Export Data
  • Bulk Insert
  • BCP
  • SQL Profiler
  • SQL Query Analyzer
  • Enterprise Manager
  • Management Studio
  • Replication
  • SQL Agent
  • Oracle 10g/11g
  • SQL Developer
  • MS Visual Source Safe
  • Visual Basic
  • T-SQL
  • PL/SQL
  • HTML
  • CSS
  • XML
  • VB.Net
  • Erwin

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

MS SQL Server BI Developer

Responsibilities:

  • Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis
  • Designed SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and MS Access to SQL Data Tools
  • Transferred data from Mainframe/DB2 to SQL Server database using SSIS
  • Optimized queries using Database Engine Tuning Advisor and SQL Profiler
  • Worked with different control flow items like Execute Package, Execute SQL, Send mail and Bulk Insert tasks.
  • Extensively used derived column, union all, conditional split, audit, script, lookup, SCD, row count, fuzzy lookup and fuzzy grouping transformations in SSIS packages
  • Responsible for creating SSIS packages to load data to dimension and fact tables in SQL Server data warehouse.
  • Created configuration files and enabling logging and error handling in SSIS, and using user defined variables to dynamically configure packages during runtime in SSIS
  • Responsible for scheduling SSIS jobs using SQL Server Agent, and created alerts for successful and unsuccessful completion of Scheduled Jobs
  • Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity
  • Built packages and handled slowly changing dimensions to maintain the historic data
  • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS and built ad hoc reports using Report Builder
  • Created different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports
  • Used cascaded parameters to generate a report from two different Data Sets in SSRS 2012
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and representatives for various business needs using Subscription in SQL Server Reporting services (SSRS)
  • Built the Dimensions, cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS)
  • Launched and designed Excel pivot table to browse the deployed cube

Confidential, Newark, NJ

MS SQL Server Developer/SSRS/SSIS

Responsibilities:

  • Designed high level ETL architecture for overall data transfer from the OLTP to EDW using SSIS
  • Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc. to migrate the old Bills information, Customer Information, Contracts Information and other important data
  • Developed and modified parameterized, drill down, drill through, cascading parameterized and sub reports in SQL Server Reporting Services and exported them to Excel format for managers and Quality Analyst team for easy validation
  • Developed various SSRS graphical reports like bar charts, line charts, pie charts by using chart experts for Business Intelligence needs in SQL Reporting Services (SSRS)
  • Made various report parameters and query parameters to create parameterized reports using SSRS 2012
  • Created reports having actions like URL and bookmarks which helped to easily navigate through the report using SSRS 2008
  • Implemented caching of reports and managed the report history in the Report Manager
  • Created ad hoc reports using Report Builder based on the report models
  • Performed complex Expressions to create calculated fields and used Global Variables in SSRS 2012
  • Use ETL/SSIS to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse
  • Used various SSRS expressions in reporting properties to enhance the layout up to the users’ requirements. Deployed reports on the reporting server and manage the subscriptions
  • Optimized the Views, Queries and Stored Procedures to enhance the complex reports. Created clustered and non-clustered indexes wherever possible to speed up the queries which in turn enhance the performance of the reports
  • Created and modified the existing stored procedures, functions, views and queries to have effective reporting. Wrote sub queries in the stored procedures to minimize the logic in the Reporting Services
  • Optimized the query performance by using Query optimizer, execution plan, SQL Server Profiler and optimizing techniques

Confidential, Mt Laurel, NJ

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

  • Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results by using T-SQL
  • Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks
  • Experience in Error handling and debugging coding issues and troubleshoot production problems
  • Involved in Performance tuning of ETL transformations, data validations and stored procedures
  • Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS)
  • Designed and developed reports using SQL Server Reporting Services
  • Developed Stored Procedures and Views used to supply the Data to the Reports
  • Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot) Reports, Chart and Graphs, Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Drill-down reports and ad-hoc reports using SSRS 2008 R2
  • Used Oracle, SQL, T-SQL and PL/SQL in test environment
  • Configured, built, deployed different reports in PDF, Excel, TFI formats according to the business requirement using SSRS 2008 R2
  • Designing Cubes, Star Schema and Data models for Data Warehousing Applications
  • Built different types of chart reports using SSRS for the business requirement like Designed and deployed reports with Drill Down, Drill Through, Drop down menu options, Sub-reports in SSRS using BIDS
  • Report parameters included single valued parameters, empid, mgrid that also consisted of different parameter types like hidden, internal, default (queried and non queried parameters)
  • Created complex stored procedures to use as the datasets for the Report Design, to generate Ad hoc reports using SSRS
  • Developed Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs, Bar charts, Column charts and Pie charts)

Confidential, Portland, OR

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Generated database SQL scripts and deployed databases including installation and configuration
  • Design and Build Extract Transform Load procedures in SQL Server 2008 to import/export data feeds to/from data warehouse
  • Worked with SSIS to import, export and transform the data between the linked servers
  • Created and developed database objects such as tables, indexes, views, procedures, functions, triggers and T-SQL code with proper grants to all the users and roles using SSMS 2008
  • Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures using T-SQL
  • Wrote various T-SQL stored procedures and Triggers to carry out various tasks
  • Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures
  • Troubleshooted, monitored, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures
  • Used Microsoft Source Safe for version control and configuration management

Confidential, Hartford, CT

MS SQL Server Developer

Responsibilities:

  • Gathered functional requirements and Business requirements and written the technical specifications.
  • Created logical and physical data models for new requirements after discussion with technical team and application users as per agile methodology
  • Wrote T-SQL, designed and modified database objects such as tables, views, triggers, indexes, Stored Procedures, defaults, function to meet the business and audit specifications
  • Developed T-SQL stored procedures and views for managing efficient data retrieval
  • Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers
  • Reviewed and fine-tuned T-SQL stored procedures and triggers before production
  • Created, insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data
  • Designed index, statistics and optimized queries by using execution plan for performance tuning of the database

We'd love your feedback!