We provide IT Staff Augmentation Services!

Ms Sql Server Developer / Bi Developer Resume

4.00 Rating

Farmville, NC

PROFESSIONAL SUMMARY:

  • 7+ years of strong MS SQL Server Developer experience in Finance, Banking, Healthcare and Insurance domains with expertise in MS SQL Server 2008/2005/2000 suite of products like SSRS, SSAS, and SSIS.
  • Expert in planning, modeling, designing, developing, implementing, administering, and maintaining Microsoft SQL Server 2008/2005/ 2000 and Access 2007 - 97 databases. Some experience with Oracle and MYSQL Databases.
  • Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models, Data integrity and SQL joins.
  • 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.
  • Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008/2005.
  • Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL 2008/2005.
  • Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.
  • Expert knowledge and experience authoring, managing and deploying reporting solutions using SSRS.
  • Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
  • Experience in writing VB scripts for user define functions in SSRS
  • Expertise in developing and extending MS SQL Server Analysis Services 2008/2005 (SSAS) cubes, data mining models, deploying and processing SSAS objects, and writing MDX queries.
  • Experienced in normalizing databases for OLTP environments and de-normalizing tables for use in OLAP environments.
  • Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
  • Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
  • Worked on administration tasks such as Data loading, Batch Jobs, Data unloading, Backup & Recovery, User and Application Table Management, upgrades, creating Databases/File groups/Files/Transaction logs.
  • Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Erwin, Microsoft Visio and SQL Server Enterprise manager.
  • Strong leadership, communication, problem-solving and multi-tasking abilities.

TECHNICAL SKILLS

Business Skill set / Technical Skill set: MS SQL Server 2008/2005/2000, SQL Server Integration Services (SSIS), SQL Server DTS, Data Stage, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Rational Rose, Oracle 9i, TOAD 6.0, VB6, Microsoft Products MS Word, MS Excel, VSS, MS Access, MS Power Point, T-SQL, PL-SQL, HTML, XML, C++, JavaScript, ODBC, MS Visio 2008, .Net

PROFESSIONAL EXPERIENCE

Confidential, Farmville, NC

MS SQL Server Developer / BI Developer

Responsibilities:

  • Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
  • Experienced in SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
  • Created user define functions in SSRS using VB script
  • Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Worked on ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
  • Developed and deployed data transfers packages to the appropriate destinations using SSIS.
  • Tune various packages for reducing their processing time by using parallel processing approach and using MS SQL Profiler in MS SQL Server 2008.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSISPackages.
  • Created SQL server dynamic configurationsforSSISpackages.
  • Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
  • Used BCP to transfer the data files to other server.
  • Scheduled the packages to run automatically for incremental data and deploy them to their destination servers
  • Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Responsible for creating reports based on the requirements using SSRS 2008.

Project Environment: MS SQL Server 2008, SQL server Reporting Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Red-Gate SQL Source Control, MS Visio 2008, SQL Profiler

Confidential, Franklin Lakes, New Jersey

MS SQL Server SSIS / SSRS Developer

Responsibilities:

  • Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
  • Created various SSIS packages to transfer data from OLTP databases to staging area and then into data warehouse. Deployed the packages to the appropriate destinations using SSIS.
  • Developed web pages and executed through asp.net that will execute SQL server SSIS packages.
  • Used various SSIS tasks for Data Scrubbing and validation checks while loading data to Staging.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSISPackages.
  • Created SQL server configurationsforSSISpackages.
  • Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
  • Responsible for creating reports based on the requirements using SSRS 2008.
  • Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
  • Defined the report layout and identified Datasets for the report generation.
  • Experienced in creating different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
  • Created numbers of complex formula in sub report.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Scheduled the monthly/weekly/daily reports to run automatically.
  • Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
  • Created Packages to group logically related column types and to transfer data.
  • Involved in Designing and deploying cubes in SSASenvironment using Snowflake and Star Schema Designs for the operational data.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
  • Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.
  • Designed both logical and physical data models in Erwin r 7.2

Project Environment: MS SQL Server 2008, SQL server Reporting Services 2008, SQL Analysis Server 2008, VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN, .NET

Confidential, Boston

MS SQL Server SSIS/SSRS Developer

Responsibilities:

  • Used the SSIS to migrate databases such as Excel files, flat files and SQL Server database to centralized IT destination.
  • Assist data modeler to create tables needed for ETL processing and develop ETL framework.
  • Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2008 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
  • Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view during extraction of data.
  • Used SSIS transformations to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
  • Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
  • Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Generated reports on account information, detailed summary reports using adhoc reporting to be used by the clients and advisors.
  • Created many complex database code objects such as Stored Procedures/ views/ Functions and used them in Reports directly to generate reports on the fly.
  • Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
  • Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
  • Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them
  • Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
  • Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008

Project Environment:MS SQL Server 2008, SSIS, SSRS, T-SQL, Visual Studio 2008, MS Office 2007, SQL Profiler, .Net

Confidential, Philadelphia, PA

MS SQL Server Developer / BI Developer

Responsibilities:

  • Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
  • Created SSIS Packages to integrate data coming from Text files and Excel files.
  • Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2005.
  • Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
  • Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
  • Worked on linked, unlinked and on-demand sub Reports.
  • Understood the various complex reporting requirements of company and created web reports using Reporting Services.
  • Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Established Inner Join, Outer Join and created Indexes whenever necessary.
  • Modified report content and exported reports in multiple formats based on user input.
  • Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
  • Experienced in creating Multidimensional cubes using SSAS and designing DW schemas.
  • Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS 2005. Create Calculate member in MOLAP cube using MDX in SSAS 2005.
  • Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
  • Created User Defined functions for sharing formulas across multiple reports.
  • Modified existing reports according to requirements of the end users.

Project Environment: MS SQL Server 2005, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL.

Confidential

MS SQL Server / SSIS/SSAS/SSRS Developer

Responsibilities:

  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
  • Worked with data analysts to identify, design and implement solutions for extraction and integration of data to and from databases and data marts for the purposes of reporting, decision support and analysis using SSRS and SSAS.
  • Created cube structure for the analysis of business condition and for creation of report using SSAS.
  • Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
  • Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
  • Designed and implemented data access stored procedures and triggers for automating tasks.
  • Managed, Monitored and Administered database and system perform-acne which included optimization and tuning of data loads, extractions and recommending appropriate procedure, query or package changes
  • Created SQL server Reports using SSRS 2005 for the manager and the brokers involved and formatted the report layout for the requirement of the end users.
  • Monitored and explained plan assessment, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer) in both 2000 and 2005 for databases.
  • Generated reports for end user requirements using SSRS.
  • Deployed developed reports on to the server for the end users.
  • Designed index, statistics and optimized queries by using execution plan for performance tuning of the database

Project Environment: MS SQL Server 2005, MS SQL Server Reporting service 2005, MS SSIS, T-SQL, Windows 2003

Confidential

MS SQL Server Developer

Responsibilities:

  • Developed physical data models and created DDL scripts to create database schema and database objects
  • Designed data models using Erwin.
  • Wrote user requirement documents based on functional specification.
  • Experienced with source to target specifications for Data Transformation Services.
  • Developed functions, views and triggers for automation
  • Wrote stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
  • Created DTS package to schedule the jobs for batch processing.
  • Performance tuning to optimize SQL queries using query analyzer.
  • Created indexes, Constraints and rules on database objects for optimization.

Project Environment:MS SQL Server 2000, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer, Oracle Hyperion EssBase

We'd love your feedback!