We provide IT Staff Augmentation Services!

Sql Bi Resume

3.00/5 (Submit Your Rating)

Chicago, IL

SUMMARY 

  • Around 7 years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite. Strong technical knowledge in MS SQL Server development and experience Microsoft BI Tools.
  • Microsoft Certified Technology Specialist in Business Intelligence and SQL Server 2008 R2.
  • Working Experience on SQL 2000/2005/2008/R2/2012 including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
  • SQL Server 2005/2008/2012 RDBMS database development including T-SQL programming.
  • SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
  • Very Good Understanding and Experience in SQL Server Integration Services(SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services(SSRS).
  • Developing reports on SSAS & SSRS on SQL Server (2005/2008/2008R2/2012). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Experienced in integrating different Microsoft BackOffice Components such as SharePoint and IIS with MS SQL Server.
  • ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse Environment.
  • Working Experience on slowly changing dimensions and creating SSIS packages using Active X scripts with Error Handling.
  • Created complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008/2012 and Transformation.
  • Experience in Designing DimensionsData Aggregation and Storage design of Cubes, measures with Star schema and Snow-flake schema using SQL Server Analysis Services (SSAS).
  • Experience in creating Gauge Reports with KPI’s, Report Model and Report Builder 1.0, 2.0.
  • Thorough understanding of Kimball’s’ theory, KPIs and Perspectives, SQL 2008/2012 Architecture.
  • Developed MDX Queries against SSAS cubes to generate reports.
  • Expert in performing ETL operations using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
  • 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.
  • Worked on Data modeling, creating star and snowflake schemas in SSAS.
  • Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports and Report Models and ad-hoc reports, Crystal Reports using SSRS.
  • Experience in defining Queries for generating drill down and drill through reports in SSRS 2008.
  • Hands on Experience in Installing, Configuring, Managing and troubleshooting SQL Server 2008/2008 R2/2005/2000/2012 and excellent communication and analytical skills, understands business requirements in various domains.
EDUCATION & CERTIFICATIONS
  • Bachelors in Computer Science and Engineering.
  • Microsoft Certified Technology Specialist in SQL Server 2008.
TECHNICAL SKILLS

SQL Server Tools

SSMS,BIDS, Enterprise Manager, DTS, Profiler, DTA, Upgrade Advisor

ETL & Reporting Tools

SSIS, SSRS, SSAS, BIDS, DTS, Business Objects, Informatica 7.1.3/6.2

Databases

SQL Server 2000/2005/2008/2008 R2/2012, MS Access, Oracle

Programming Languages

SQL,T-SQL,PL/SQL,VB

Operating System

Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0  Windows XP/98/95, MS DOS, Linux.

Scripting

HTML, XML,VBScript, JavaScript,ASP,C#,ASP.NET,VB.NET

Tools

Erwin, Visual Studio 2008/2005 and Report Builder 1.0/2.0/ 3.0

PROFESSIONAL EXPERIENCE

Client: Confidential, Chicago, IL May’11 –Till Date
SQL BI Consultant.

Confidential, is the largest American drug retailing chain in the United states, operates 8,300 stores in all 50 states. The project that I worked is a National Sale Tracking (NST) system, which uses Microsoft SQL Server 2000. Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs during the second half of 2005.
Responsibilities:

  • Involved in reviewing the Investments application and interacting with business users to understand the user requirements.
  • Involved in migration of SQL Server 2005 to 2008/2012.
  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
  • Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
  • Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
  • Developed MDX Queries against SSAS cubes to generate reports.
  • Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
  • Designed and developed matrix and tabular reports with drill downdrill through and drop down menu and used gauge reports with KPI’s in SSRS.
  • Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
  • Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS.
  • Designed, developed, tested, deployed, supported, maintained and documented (KPIs)Scorecards, Time Aware Dashboards and accompanying Analytical Grids and charts with URL actions using Performance Point Server 2007 and SQL Server Analytical Services.
  • Designed and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
  • Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
  • Used Sql Profiler for troubleshooting, monitoring, optimization of SQL server 2008/2012 and SQL code.
  • Optimized the database by creating various clustered, non-clustered indexes and indexed views.
  • Taking Database full BackupTransaction log backup & differential backup in daily Routine.

Environment: SQL Server 2005/2008 R2/2012, T-SQL, PL/SQL, SQL Profiler, Report Builder, SSIS, SSRS, SSAS, MDX, ASP.NET, C#, Agile, Visual Studio 2005/2008, XML, Crystal Reports, ER-Win, MS Visio

Client: Confidential, Dallas, TX Mar’10-Apr’11

MS SQL Server Developer/SSAS/SSRS. 
Confidential is a diversified Health and Well-being company, focused on improving people’s lives through timely innovations. As a world leader in healthcare, lifestyle and lighting Philips integrates technologies and design into people-centric solutions, based on fundamental customer insights and the brand promise of “sense and simplicity”
Responsibilities: 

  • Participated in creating reports that deliver data based on stored procedures.
  • Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
  • Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
  • Experience in creating SSIS packages using dashboard.
  • Involved in writing classes for business logic layer using C#.
  • Back end Experience in MS SQL Server development, writing T-SQL stored procedures, coding, triggers and cursors.
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
  • Developed several Web controls -- composite and standard web controls -- using VB.NET and C#.
  • ETL capabilities of SSIS were used to define imports of the data, build scheduling packages.
  • Design, develop and went live after migrating several MS Access & SQL Server databases for corporate developers, resolving typical database issues.
  • Iteration planning for new features and user stories in Agile Development methodology.
  • Configured and maintained huge OLTP databases.
  • Querying and manipulating multidimensional cube data through MDX Scripting.
  • Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment (SSAS).
  • Migrated data from Oracle to SQL Server data warehouse and to generate the reports using SSRS for different SSAS Cubes.
  • Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
  • Loading data from various sources like, flat files, to SQL Server database Using SSIS Package.
  • Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
  • Making a Report as per user requirement using MS Reporting Services 2008 (SSRS).
  • Created SSIS Packages to migrate slowly changing dimensions.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
  • Worked on improving the performance of the system.
  • Involved in the tuning of the existing Database Objects.

Environment:SQL Server 2008 , SSIS, SSAS, SSRS,, MDX, OLAP, XML, MS PowerPoint, MS SharePoint, MS Project, MS Access 2007/2003 & UNIX, .NET, C#, Agile Programming, Shell Scripting, Oracle, Crystal Reports.

Client: Confidential, Medford, MA Jan’09– Feb’10 
SQL BI Developer

Confidential, an insurance company based in Medford, MA is a high quality, comprehensive health plan for MassHealth members. The project is to collect data from the hospitals and to create reports for the number of in and out patients with the expenses. Created a series of reports which shows cost by facility and panel and cost by facility and service area. 
Responsibilities:

  • Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
  • Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Excellent hands on experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS).
  • Involved in designing cubes in SSAS environment using Snowflake/ and Star Schemas.
  • Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Installation and configuration of SQL Server 2008.
  • Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports,Subreports using Sql Server Reporting Services 2008.
  • Created SQL Server Analysis Project using MS SSAS 2008.
  • Querying and manipulating multidimensional cube data through MDX Scripting.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Created complex SSAS cubes with multiple fact measures groups.
  • Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
  • Developed the chart type, tablix, matrix reports in SSRS (Sql Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system.
  • Used performance Point Services, SSRS, excel as the reporting tools.
  • Wrote the expressions in SSRS wherever necessary.
  • Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Modifying report content and exporting reports in multiple formats based on the business requirements.
  • Designed and implemented Parameterizedand cascading reports using SSRS 2008.
  • Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.
  • Created derived columns on the final fact and dimension tables as per the business requirements.
  • Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
  • Created Analytical reports by PROCLARITY tool.
  • Played a major role in production support of SSAS (cube refresh), SSIS jobs.
  • Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle

Client: Confidential, NEWYORK, NY Nov’07 – Dec’08
SQL BI Developer

Confidential is a major American financial services company based in New York City. Confidentialgroup was formed from one of the world’s largest mergers in history by combining the banking giant Confidentialcorp and financial conglomerate Travelers Group on April 7, 1998. Confidentialgroup Inc. has the world’s largest financial services network, spanning 107 countries with approx.

Responsibilities:

  • Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS/DTS packages.
  • Migrated SQL Server 2000 DTS packages to SSIS 2005.
  • Developed SSIS 2005 Packages to migrate data from Oracle, Access, flat files and ExcelintoSQL server 2005 for further Data Analysis and Reporting by using multiple transformations.
  • Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.
  • Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
  • Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.
  • Developed, deployed and monitored SSIS Packages.
  • Developed custom reports and deployed them on server using SSRS.
  • Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
  • Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS.
  • Formatted reports using Global Variables, Expressions and Functions for the reports.
  • Created dashboards using Performance Point Server, combining scorecards and reports generated in SSRS, PPS, and Excel Services.
  • Published dashboards on an intranet site using SharePoint Server.
  • Configured Report Model for developing ad-hoc reports by the end-users.
  • Uploaded reports on to the report manager and organized them into folders.
  • Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.
  • Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
  • Assisted in the application development, debugging, configuration, and optimization from database perspective.
  • Involved in implementation of replications like Snapshot and Transactional.

Environment: - MS SQL Server 2005, Windows Server 2008,.MDX, DTS, SSIS, SSRS, PPS, SharePoint, T-SQL, ETL, MS Access, XML, Excel, Visual Studio 2008.

Client: Confidential Sep’06 – Oct’07 
SQL Programmer

Project Description: Worked on retail collection system, a GUI based client/server bill collection software, to assist brokers in carrying out their daily transactions and for managing banks property and equipment.

Responsibilities:

  • Created new tables, written stored procedures for Application Developers and some user defined functions
  • Created SQL scripts for tuning and scheduling
  • Performed data conversions from flat files into a normalized database structure
  • Created and managed users, roles and groups and handled database security
  • Created Triggers to enforce data and referential integrity
  • Defined Check constraints, Business Rules, Indexes, and Views
  • Configured Server for sending automatic mails to the respective people when a DTS process failure or success
  • Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server
  • Data migration (import & export – BCP) from Text to SQL Server
  • Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking)
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
  • Performed development support, document reviews, test plan, integration of the system
  • Creation/ Maintenance of Indexes for fast and efficient reporting process
  • Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights
  • Creation/Deletion of Linked Servers
  • Managing historical data from various heterogeneous data sources (i.e. Excel, Access)

Environment: SQL Server 2005, T-SQL, PL/SQL, TOAD, Forms 6i and reports 6i.

Client: Confidential June’05 – July’06 
SQL Developer

Confidential Technologies specializes in providing a wide array of leading edge and customized solutions & services to its clients for a range of key verticals and horizontals. Confidential has excellent domain expertise in wireless telecommunications space,project portfolio management and consultancy. As a diverse end to end IT solutions provider, Confidential offers technology services that focus on helping its global clients meet the challenges successfully.

Responsibilities:

  • Participated in the installation of SQL Server.Installed SQL Server Enterprise manger tools using SQL Server Setup Program and Interacted with Development Teams, Managers to analyze business needs and developed technicalServers.
  • Migrated access objects to SQL Server 2000.
  • Created tables, indexes and constraints.
  • Created Stored Procedures, Indexes, Views, Triggers, Stored Procedures in T-SQL and DTS Packages.
  • Wrote database triggers in T-SQL to check the referential integrity of the databases.
  • Defined stored procedures for module integrity and application.
  • Used Database Engine Tuning advisor andSQL Profilerfor Monitoring memory, processor, Disk I/O and SQL Queries.
  • Involved in performance tuning of the database and T-SQL queries using Explain Plan and scheduled Jobs weekly, monthly.
  • Designed and implemented several complex reports.
  • Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal reports.
  • Preparation of project documentation.

Environment: 
SQL server 2000/2005, Visual Basic 5.0, Win NT, Crystal Reports 8.0

We'd love your feedback!