We provide IT Staff Augmentation Services!

Ms Sql/bi Developer Resume Profile

Adina, MinnesotA

SUMMARY:

  • 8 years of IT Experience in Database Design, Development and Business Intelligence of Microsoft SQL Server 2012/2008/2005/2000 in Development, Test and Production Environments and Web/Windows application development with extensive experience in Microsoft Visual Studio 2008/2005/2003 environment using C .NET, VB.NET, ADO.NET, ASP.NET.
  • Expertise in developing n-tier applications.
  • Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2012/2008/2005/2000.
  • Expert Knowledge of Integration Services SSIS , Analysis Services SSAS and Reporting Services SSRS
  • Developing reports on SSAS SSRS on SQL Server 2005/2008 . Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services SSAS .
  • Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
  • Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
  • Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
  • Experience in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
  • Experience in enhancing and deploying the SSIS Packages from development server to production server.
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server SSAS .
  • Experience in report writing using SQL Server Reporting Services SSRS and creating various types of reports like drill down, Parameterized, Cascading, Conditional , Table, Matrix, Chart, Ad hoc and Sub Reports.
  • Identified and added the report parameters using T-SQL according to the requirement using SSRS.
  • Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
  • Experience in migrating data from heterogeneous data sources like Flat files, MS-Access, Excel, OLE DB, XML files, BRM, SQL server to SQL Server using SQL Server Integration services SSIS .
  • Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
  • Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installation.
  • Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

TECHNICAL SKILLS:

Languages

VB.Net ,C .Net ,T-SQL

RDBMS

MS SQL Server 2012/2008/ 2005/ 2000, 7.0, MS-Access, Oracle

Web Technologies

ASP.Net, ADO.Net, HTML , XML, IBM Web sphere

SQL Server Tools

Enterprise Manager ,SQL Profiler, Query Analyzer, SQL Server Management Studio, SSIS , SSRS, SSAS

Data Modeling Tools

ERWIN, Visio

Operating System

Windows 95/98/2000/XP/Vista/7

PROFESSIONAL EXPERIENCE:

Confidential

Role: MS SQL/BI Developer

Responsibilities:

  • Worked closely with client to understand the business requirements, data analysis and identify final deliverables
  • Identified a clear set of project milestones and the required timelines.
  • Maintaining and Managing SSIS batch jobs for Development, Test and Production Environments
  • Support daily work request from different environment groups requesting Modifications and creating new stored procedures, tables, and SSIS packages.
  • Design, Development, configure and Support of new databases, tables, jobs, SSIS Packages and Other Database Objects
  • Troubleshoot and resolve issues reported by the groups
  • Developed and Optimized Stored Procedures, View, and User-Defined Functions for the Application
  • Created complex Stored Procedures for better performance to generate reports.
  • Wrote complex queries using join to extract data from different servers.
  • Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS.
  • Expert in using BCP and Bulk Insert, FTP Task.
  • Involved in the daily meetings of the project design and development using Scrum project methodology.
  • Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Involved in debugging SSIS Packages to maintain data efficiency.
  • Deployed SSIS packages in both Development and Test environments. Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Responsible for report generation using SQL Server Reporting Services SSRS based on business requirements.
  • Build ad-hoc reports using SQL Server Reporting Services SSRS , Excel.
  • Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services SSRS .

Environment:

MS SQL Server 2005, 2008, SQL Integrations Services SSIS , SQL Server reporting services SSRS , TSQL, FTP, C scripts, Control-M. TFS.

Confidential

Role: MS SQL/BI Developer

Responsibilities:

  • Involved in developing Technical Design specification documents for different interfaces.
  • Several simple, complex and Ad-hoc reports were created having Slice and Dice, Drill Down, Matrix, Master Detail and Formulae.
  • Installed and configure SQL server 2005/2008 Analysis Service and Reporting Services
  • Created physical ER drawings for different star schemas from the logical drawings in Erwin.
  • Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
  • Created, Tested and deployed SSIS Packages for data migration into Facts and dimension tables in the data mart from the source data warehouse tables.
  • Worked extensively with SSIS to import, export and transform the data between the linked servers.
  • Implemented Event Handlers on SSIS packages to handle the errors.
  • Involved in designing the report using SSRS tool and bind that report to the data source like stored procedure, table or a query to pull the data into the designed report.
  • Used SSRS for designing of reports and multi grouping of data at report level as per client requirement.
  • Used .Net code in developing SSRS reports.
  • Created reports as needed to determine scope of project.
  • Customized the Dashboards and KPIs Key Perform Indexes for better manageability of overall performance.
  • Performance tuning for efficient report generation
  • Displayed pie charts, bar graphs more understandable for top-level management.
  • Several simple, complex and Ad-hoc reports were created having Slice and Dice, Drill Down, Matrix, Master Detail and Formulae.
  • Worked extensively with complex VB expressions in formatting and styling the SSRS reports.
  • Used SQL Profiler and Query Analyzer to optimize queries and Stored Procedures.
  • Involved in production support and maintenance of existing data warehouse application like fixing bugs and making hot fixes.
  • Created and Scheduled Metrics for the Weekly Production Reviews.
  • Tuned report performance by managing SQL expressions at report level. Developed and managed reports from different databases and deployed the same.

Environment:

MS SQL Server 2005, 2008, SQL Reporting Services SSRS , SQL Server Analysis services SSAS ,TSQL, Oracle 10g, FTP, SQL.

Confidential

Role: MS SQL/BI Developer

Responsibilities:

  • Participated in gathering User Requirements and System Specifications.
  • Involved in the complete SDLC such as design and development for the cube, identified the fact and dimension tables using SSIS and SSAS and reviewed Cube with end user according to their requirement, and also documented the entire process for further reference.
  • Involved in writing complex T-SQL queries to develop complex stored procedures.
  • Migrated data from heterogeneous data sources like Flat files, MS-Access, Excel, OLE DB, XML files, BRM, SQL server to SQL Server 2008 using SQL Server Integration services SSIS .
  • Developed different ETL operations according to the client requirements using T-SQL and BIDS.
  • Created ETL SSIS packages to develop jobs for extracting, cleaning, transforming and loading data into data mart.
  • Created, modified and maintained the ETL packages to load the data from various Database tables from source tables to Map the Target table in respective databases.
  • Involved in data conversion from PL-SQL to T-SQL for migration from Oracle BRM source to Sql server destination using SSIS.
  • Enforced data consistency by adding data viewer to the transformations and created dynamic packages by using variables.
  • Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and stored procedures.
  • Applied various data transformations like Slowly Changing Dimension SCD's , Aggregate, Sort, Multicasting, Lookup, and Conditional Split and Derived columns.
  • Involved in Query optimization, performance tuning and index creations.
  • Designed, reviewed, and created primary objects views, indexes, etc. based on logical design models, user requirements and physical constraints.
  • Designed, developed and deployed reports, Sub-Reports, Drill down reports, Drill through reports and Parameterized reports in MS SQL Server environment using SSRS-2008.
  • Created reports to retrieve data using T-SQL queries and Stored Procedures that accept parameters using SQL Server Reporting Services SSRS .
  • Developed reports using SSRS and used data driven subscriptions to publish the developed to the end users as PDF, Excel, and CSV formats.
  • Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.

Environment:

MS SQL Server 2008, SQL Server Management Studio 2008, BIDS, SQL Profiler-SQL,

MS Office, T-SQL, Excel, XML, MS-Access, C , ASP.Net 3.5, VB.Net, MDX, OLAP, OLTP.

Confidential

Role: SSIS/SSRS Developer

Responsibilities:

  • Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
  • Extensively Involved in Preparing Detailed Technical Documents from the Functional Specifications.
  • Reviewed the logical and physical database design and Technical Specifications.
  • Wrote T-SQL queries, stored procedures and triggers to build specific logics as well checking constraints, preserve referential integrity, and provide additional application functionality. Optimized the performance of queries with modification in TSQL queries, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
  • Involved in designing, developing and testing of the ETL Extract, Transformation and Load strategy to populate the Data from various source systems feeds using SSIS.
  • Reused DTS packages in a SSIS wrapper, and migrated other DTS packages to SSIS.
  • Used Fuzzy group, Fuzzy lookup tasks to eliminate duplicate rows in SSIS packages.
  • Identified and worked with parameters for parameterized reports. Responsible for transferring the data using SSIS packages from OLTP to OLAP.
  • Used SQL Profiler for debugging issue, performance tuning whenever necessary
  • Experience in creating multidimensional cubes using the SQL Server Analysis Services SSAS . Using ERWIN for worked on ER diagrams and star schemas.
  • Created tables, views, indexes and relations using SQL Enterprise Manager, Query Analyzer and SQL Server Management Studio SSMS
  • Generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services SSRS .
  • Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
  • Created Stored Procedures, Triggers, Views and User Defined Functions to support the Application.
  • Identified the Data Source and defining them to build the Data Source Views. Developed Query for generating drill down reports in SSRS
  • Developed complex stored procedures to retrieve the data from the backend SQL database.
  • Performance tuning for efficient report generation.
  • Several simple, complex and Ad-hoc reports were created having Slice and Dice, Drill Down, Matrix, Master Detail and Formulae.
  • Microsoft Visual SourceSafe was used as a Source Repository.
  • Co-ordination with Offshore and onsite in assigning the tasks and time reporting to the client.
  • Involved in 24 7 production support mainly for Windows based services, SSIS jobs, monitoring SQL Server services,
  • Worked with application DBA for setting up of database backups, restores, packages and scheduling jobs.

Environment:

SQL Server 2005/2008 Enterprise, Windows Enterprise Server 2003, SSAS, SSIS, SSRS, Server 2004, Share Point Portal Server 2007 MOSS 2007 ,MDX, IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008, ASP.Net 3.5, VB.Net, MDX, OLAP, OLTP.

Confidential

Role: BI Consultant SSIS/SSRS

Responsibilities:

  • Involved in developing Technical Design specification documents for different interfaces.
  • Migrated data from different sources and built enterprise data warehouse with data stage.
  • Designed and developed ETL jobs for loading data from Operational system Database to RDBMS Database.
  • Installed and configure SQL server 2005/2008 Analysis Service and Reporting Services
  • Used MS SQL Server SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Created physical ER drawings for different star schemas from the logical drawings in Erwin.
  • Created DDL scripts, and tables, indexes, relationship constraints from the Erwin from the physical models.
  • Created, Tested and deployed SSIS Packages for data migration into Facts and dimension tables in the data mart from the source data warehouse tables.
  • Installed and configured SQL Servers in clustered environment.
  • Worked Extensively with SSIS to import, export and transform the data between the linked servers.
  • Implemented Event Handlers on SSIS packages to handle the errors.
  • Involved in designing the report using SSRS tool and bind that report to the data source like stored procedure, table or a query to pull the data into the designed report.
  • Used SSRS for designing of reports and multi grouping of data at report level as per client requirement.
  • Used .Net code in developing SSRS reports.
  • Created reports as needed to determine scope of project.
  • Customized the Dashboards and KPIs Key Perform Indexes for better manageability of overall performance.
  • Performance tuning for efficient report generation
  • Displayed pie charts, bar graphs more understandable for top-level management.
  • Several simple, complex and Ad-hoc reports were created having Slice and Dice, Drill Down, Matrix, Master Detail and Formulae.
  • Worked extensively with complex VB expressions in formatting and styling the SSRS reports.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
  • Involved in production support and maintenance of existing data warehouse application like fixing bugs and making hot fixes.
  • Created and Scheduled Metrics for the Weekly Production Reviews.
  • Tuned report performance by managing SQL expressions at report level. Developed and managed reports from different databases and deployed the same.
  • Involved in the daily meetings of the project design and development using Scrum project methodology.

Environment:

MS SQL Server 2005/2000/2008, SQL Reporting Services, SQL Server Analysis services, Oracle 10g, FTP, SQL, Toad, Erwin, Unix Shell Scripts, UDB DB2, and AIX.

Confidential

Role: SQL Data warehouse Developer SSIS, SSAS

Responsibilities:

  • Constructed Cubes based on data volumes mostly adhering to Star Schema.
  • Built MDX queries and Data Mining Expression DMX queries for Analysis Services SSAS Reporting Services SSRS with the help of some XSTL Style sheets.
  • Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
  • Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Responsible for report generation using SQL Server Reporting Services SSRS and Crystal Reports based on business requirements.
  • Build ad-hoc reports using SQL Server Reporting Services SSRS , Excel.
  • After installing the SQL server 2005, migrated the existing DTS packages into SSIS packages using SSIS services provided by SQL Server 2005 Manager studio.
  • Utilized SSIS SQL Server Integration Services to produce a Data Mart for reporting.
  • Designed ETL packages dealing with different data sources SQL Server, Flat Files, and XMLs etc and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services SSIS .
  • Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
  • Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services SSRS .
  • Created SSIS packages for File Transfer from one location to the other using FTP task and Designed SSIS packages to extract data from flat files and oracle database.
  • Integration Services SSIS -- Data sources and package connections. Control flow objects and data flow adapters. Debugging, deploying, and configuring SSIS packages. Securing and executing packages. Securing SSAS cubes. Querying cubes.
  • Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Business Intelligence Development Studio BIDS -- Using BIDS to create, edit, and deploy SSRS, SSAS, AND SSIS projects. Developed deployed and monitored SSIS packages including upgrades DTS to SSIS.
  • Skilled in Developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
  • Analysis Services SSAS -- Creating data sources and data source views DSVs , named calculations and named queries. Creating cubes, dimensions, measures, measure groups, key performance indicators KPIs , perspectives, measure group partitions, partition aggregations, data mining models. Deploying and processing SSAS objects.

Environment:

SQL Server 2005/2008, ORACLE, Windows Server 2000/2003, ASP.NET, C , VB.NET, ASP.NET, Visual Basic, ASP, MTS, EXCEL, Visio, ERWIN, WORD

Confidential

Role: MS SQL SERVER DEVELOPER

Responsibilities:

  • Involved in implementation and scheduling of the backup and maintenance strategy on the development server.
  • Created Stored Procedures and Database objects.
  • Responsible for backups/restores, designing DTS packages and maintenance.
  • Reviewed and optimized SQL queries, Stored Procedures, Views and Triggers to achieve maximum efficiency and scalability.
  • Daily Database backups and integrity checking.
  • Data Transfer using DTS from Development to Testing and to Production Servers.
  • Designed and created Stored Procedures, Tables Views and DTS packages for existing SQL Server Databases.
  • Involved in Data Migration and used DTS to import and export data into tables using SQL Server 2000/2005, creating tables, views and Stored Procedures using SQL Server.
  • Fine-tuned queries for the performance of reports which were being deployed in Crystal Reports 10 and XI.
  • Wrote Stored Procedures for Reporting purposes and developed various reports using SQL Server Reporting Services.
  • Used T-SQL to create various queries.

Environment:

SQL Server 2000/2005, Windows NT/2000 server, Crystal Reports XI/10.

Hire Now