We provide IT Staff Augmentation Services!

Sql Bi Consultant (ssis/ods). Resume

0/5 (Submit Your Rating)

Manchester, NH


  • Over 7 years of IT experience in Database Design, Development, Implementation and Administration in SQL Server 2008/2005/2000 and providing ETL/Business Intelligence solutions using Microsoft components.
  • Very good experience in Installation, configuration and maintenance of SQL Server.
  • Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
  • Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
  • Very good T - SQL Programming skills.
  • Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
  • Experience in Database backup and disaster recovery procedures.
  • Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
  • Created complex DTS Packages for Data Migration and Transformation.
  • Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0
  • Experience in MS SQL Server upgrades from 7.0 to MS SQL Server 2000 and from 2000 to MS SQL server 2005
  • Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
  • Has the ability to work in a fast paced environment, Good team player and can work independently.
  • Helped the database developers on technical issues.
  • Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005 and 2008.
  • Experience in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other tasks using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
  • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
  • Experience with handling moderate to large tables/databases, Query performance tuning, Distributed Transaction, Distributed Queries/Linked Servers.
  • Extensive experience in ETL design/development using MS DTS and SSIS including data extraction and transformation between multiple data sources (Oracle, MS Access, and MS Excel).
  • Gather Day to Day files from FTP, Secure FTP servers, decrypt them and deliver to the respective teams that require the file.
  • Experienced in creating Jobs, Alerts using SQL Mail Agent. Well versed in various high availability solutions like clustering, mirroring, log shipping.
  • Experience of Bulk Insert, BCP utilities and scripts for data transforming and loading.
  • Experience in Creating and Deployment and Administration of SSIS and SSRS packages.
  • Experienced in report generation using XML, Crystal Reports, SQL Server Reporting Services (SSRS) and Excel spreadsheet.
  • Experience in designing and developing reports using different tools such as Visual Studio and Report Builder.
  • Experience in deploying SQL Server Analysis Services Projects using MS SQL Server 2005.
  • SQL Server 2005 OLAP Database Development including KPIs, Data mining, working with changing dimensions.


Languages: SQL, T-SQL, PL/SQL,.Net(C#,ASP,VB)

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor,Database Tuning Wizard

Databases: SQL Server 2008R 2/2008/2005/2000, MS Access, oracle 8i/9i/10g

Operating Systems: Windows Server 2008/2003/2000, UNIX, Linux

ETL: SSIS, BCP, Import/Export Wizard, BI Studio

Data Modeling: Erwin Data modeler, ER Studio, Access

Web Technologies/ Tools: HTML, DHTML, XML, Visual Studio, MS Front page

OLAP Tools: SSAS, MS Excel

Reporting Tools: Visual Studio, Report Builder, SSRS, Crystal Reports

Web Servers: IIS, APACHE Tomcat


Confidential, Manchester, NH

SQL BI Consultant (SSIS/ODS).


  • Creating the packages and loading up into the ODS Server.
  • Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project
  • Implemented database standards and naming convention for the database objects.
  • Developed DTS packages to extract, transform and load into the Campaign database from OLTP database
  • Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
  • Worked with developers to tune the SQL queries using SQL Profiler.
  • Used Active-X scripting in SSIS for transformation of data into staging tables and performed multitask data pump in SSIS/ETL.
  • Transformed data from one server to other servers using tools likeBulk Copy Program (BCP)andSSIS.
  • Worked Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file System task, ftp task, send mail task, active script task, Message Queue Task, XML task.
  • Involved in Performance tuning and Query Optimization.
  • Developed export module which can directly export data to xml and text file and also integrated with E-mail, so they can get E-mail notifications.
  • Transformations of data such as adding derived column and sorting of data.
  • Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
  • Executed the specified pass-through Open Query on the specified linked server.
  • Worked on SQL Profiler and Estimated Query plan to optimize the performance of SQL queries and stored procedures.
  • Extracted data from multidimensional cube and designed parameterized reports using SQL Server Reporting Service.
  • Proficiently created drill down reports, linked reports, drill through reports and sub reports using SSRS.
  • Proficiently created and manage roles and security of reports and scheduled the Subscription of Reports using SSRS.
  • Hands on experience in tuning, mappings, and resolving performance bottlenecks.
  • Imported and Exported data from homogeneous and heterogeneous sources using SQL Server tools such as SQL Server Integration Services.
  • Used RANK and PARTITION features in SQL Server 2005.

Environment: MS SQL Server 2000/2005/2008, SSIS/SSAS/SSRS, ODS, MS Access, Windows NT, Windows XP/ 2003/2000/98, ERWIN 7.0, MS VISIO, MS SQL, SQL Profiler, SQL Query Analyzer, MS SQL Server Integration Services 2008/2005, DTS, ASP.NET, MS Visio 2003, MS Office 97/2003/2007.

Confidential, Boston

SQL BI Consultant (SSIS/SSRS)


  • Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS
  • Implemented SQL Server SSIS packages for ETL methodologies
  • Installed, configured and maintained SQL Server Integration Services (SSIS).
  • Migrated DTS packages to SSIS Packages
  • Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB etc to Access etc
  • Migrated Data from SQL server 2005 to SQL Server 2008 using SSIS.
  • Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
  • Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Deployed reports in to Report Manager.
  • Created Ad-Hoc reports using Report Builder.
  • Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
  • Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Developed reports using SSRS and published as PDF, Excel, and CSV formats.
  • Experience with the Share point 2007 to upload the SSRS reports to Web portal.
  • Developed complex stored procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Implemented SQL Server OLAP services (SSAS) for building the data cubes.
  • Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
  • Create prototype SQL Server 2005 Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM)
  • Working on Analysis services (SSAS 2005) to create multidimensional cubes to slice and dice the data.
  • Created the star schema for OLAPreporting data archiving and data marts
  • Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
  • Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.Responsible for database design, including optimizing the database schema and coding database procedures/queries.

Environment: SQL Server 2005, SSIS, SSRS,SSAS, Query Analyzer, Index Tuning Wizard-SQL MS Access, MS Excel, ERWIN, T-SQL, PL/SQL, MDX, DB2, VS2008/2005, XML, HTML

Confidential, Hartford, CT

SQL BI Consultant (SSAS/SSIS)


  • Involved in installation and configuration of SQL Server 2005 and SQL Server 2008 with latest Service Packs
  • Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
  • Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data loads and transformations.
  • Created various database objects such as tables, indexes and views based on the requirements.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
  • Developed the packages with monitoring features and logging so that information of the packages and their execution results are loaded into the designed error table.
  • Experience in integration of various data sources like SQL Server, Oracle, DB2 UDB and Flat Files.
  • Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
  • Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
  • Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries, Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
  • Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
  • Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
  • Created and worked with drill down reports and identified the report parameters.
  • Used various report items like tables, sub report and charts to develop the reports in SSRS.
  • Deployed and generated reports on to the server using the Reporting Services Report Manager.
  • Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules And integrated reports in MOSS 2007 using web parts
  • Involved in setting up Performance Point Server and creating dashboards and scorecards in the PPS.
  • Performed daily maintenance operations on the Informatica Servers (Production, QA and Development) like monitoring the size, monitoring the log files and cleaning the logs that are older than a particular period using shell commands and scripts.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, Normalizer and Union to develop robust mappings using the Informatica Designer.

Environment: MS SQL Server 2008/2005, VS2008/2005, SSRS 2008/2005, SSAS, SSIS, Business Intelligence Development Studio (BIDS), T-SQL, PL/SQL, MDX, Microsoft Office SharePoint Server (MOSS ) 2007, Performance Point Server 2007. Informatica Power Center 8.6

Confidential, NJ

Sr SQL BI Developer


  • Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SSIS.
  • Involved in business requirement gathering and created functional/technical specification documents.
  • Developed physical data models and created DDL scripts to create database schema and database objects.
  • Designed data models using Erwin and Created new tables, written stored procedures, triggers for Application Developers and some user defined functions.
  • Created SQL scripts for tuning and scheduling.
  • Involved in performing data conversions from flat files into a normalized database structure.
  • Developed functions, views and triggers for automation.
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
  • Provided disaster recovery procedures and policies for backup and recovery of Databases.
  • Performance Tuning in SQL Server 2000 using SQL Profiler and Data Loading.
  • Very extensively used SSIS Import/Export Wizard, for performing the ETL operations.
  • Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
  • Extensively worked on designing reports using SQL Server Reporting Services (SSRS). Developed Reports, Sub Reports, Data driven subscriptions, drill down reports using various features like Charts, graphs, filters etc.
  • Defined report layouts for formatting the report design as per the need.
  • Wrote queries for drill down reports to get the dataset required to build the report.
  • Identified and included report parameters for parameterized report.
  • Formatted the reports using Global variables and expressions.
  • Deployed generated reports onto the Report Server to access it through browser.
  • Maintained data integrity by performing validation checks.
  • Optimized queries, tuned and monitored server performance
  • Installing SQL Server Client side utilities and tools for all the front-end developers/programmers.
  • Involved in performance tuning to optimize SQL queries using query analyzer.

Environment: T-SQL, PL/SQL, MS SQL Server 2005/2000, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports, Oracle 9

Confidential, Minneapolis, MN

Sr SQL Developer (ETL)


  • Involved in gathering requirements from Business Users, Analysts by scheduling meeting at regular basis.
  • Followed the four step procedure for building data warehouse solution which comprised of Analyzing Business Processes, Identifying the Grain, then identify Dimensions and Facts.
  • Created SQL Server Reports using SSRS 2005.Identified the data source and defined them to build the data source views.
  • Involved in debugging Reports and deploying Reports.
  • Created Tabular Reports, Cross Tab Reports and Sub Reports.
  • Scheduled the Reports to run automatically.
  • Extract Transform Load (ETL) development using SQL Server 2005,
  • Used data modeling tool Erwin for creating Logical, Physical data models and DDL’s.
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Experience in moving the data from heterogeneous data sources like oracle, xml etc to sql using SSIS.
  • Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc using SSIS.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • 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, Column Mapping, Data dictionary and Metadata.
  • Used ANSI dynamic SQL for writing to the standard ANSI pre compilers using macro command lines.
  • Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
  • Used Performance Point Server to create interactive reports with an ability to drill down into details.
  • Experience in Performance Point Server powerful visualization tools, including the Decomposition Tree, Perspective View and Performance Map, to drill down, cross drill, pivot, chart, and investigate data.
  • Used Performance Point Server to identify KPI ‘S, build score boards, reports and dash boards
  • Created SSIS packages to migrate data from Oracle DB to SQL Server 2005.
  • Design, build, administer and production support of the BO reporting environment
  • Vendor Management i.e. to work with Business Objects customer support team to report & resolve issues/limitations/bugs in the off the shelf BO software.
  • Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
  • Developed complex T-SQL code for the application.

Environment: MS SQL Server 2005, ANSI SQL, SSAS, SSIS, BO XI, Informatica, MS SQL Server Reporting Services 2005 (SSRS), DDL, Erwin, SharePoint Moss Server,, ETL, Erwin, XML, HTML.


SQL Developer


  • Installation of SQL Server 2000 on Windows environment.
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
  • Created Database Maintenance Plan for the Performance of SQL Server this includes Database Integrity
  • Checks, Update Statistics and Re-indexing.
  • Configured and managed merge replication database articles.
  • Developed DTS packages to transfer data from heterogeneous data sources and different files like Flat Files, Spread Sheets to SQL Server.
  • Data migration (import & export - BCP) from Text files to SQL Server 2000/7.0.
  • Created Triggers to enforce data and referential integrity.
  • Designed and developed Stored Procedures, functions and DTS packages and error handling using T-SQL for SQL Server 2000.
  • Created stored procedures/Packages using Pl/SQL programming according to the business requirements.
  • Performed Query Optimization by extensive use of Index implementation and Index Tuning Wizard.
  • Responsible for Oracle/SQL Databases and Application performance tuning, physical/logical design and optimization and availability.
  • Implemented and maintained industry standards in database management.
  • Monitored SQL server performance using SQL profiler, Index tuning advisor for query tuning, stored procs.
  • Maintained the database consistency with DBCC commands at regular intervals.

Environment: SQL Server 2000/7.0, Oracle 8i, Ms-Access, Windows 2000, Linux, C++, T-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, BCP, OSQL, DTS.

We'd love your feedback!