We provide IT Staff Augmentation Services!

Business Intelligence Resume

NJ

SUMMARY:

Over 7+ years of IT experience in Analysis, Database Design , development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives.

  • Strong experience in MS SQL Server 2008 with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS),
  • Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005 and SQL Server 2008
  • Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility and automation with SSIS
  • Experience in SQL Server Analysis Server MDX Queries
  • Created the datasets based in MDX Queries and implemented performance and analysis reports using SSRS.
  • Worked with OLAP and Data warehouse application and worked with star schema, snowflakes schema dimensions and worked with implementing SSAS, and SSRS tosupport largeReporting needs.
  • Thorough Knowledge of Various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc.
  • Worked on creating client reports and custom reports (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc) using SQL Server Reporting Services 2005
  • Experience in creating and managing database objects like Tables, Views, Triggers, Cursors, Stored Procedures, user defined data types and functions
  • Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages
  • Experienced using in FTP and SFTP servers to upload files
  • Migrated data from SQL 2000 to 2005 and solved related issues.
  • Experience with SQL Performance tuning and transactions analysis, thorough understanding of indexes and statistics.
  • Good knowledge in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
  • Experience in Database administration activities for DB Security (creating users, roles, and assigning permission to them)
  • Excellent T-SQL Programming skills. Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities
  • Good knowledge in implementing Log Shipping, Database Mirroring
  • Created complex DTS Packages for Data Migration and Transformation
  • Experience in developing and monitoring SSIS Packages
  • Extensively worked on system analysis, design, development, testing and implementation ofprojects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
  • Collected business requirements from users and translated them as technical specs and design docs for development.
  • Identified various data sources, formulated data dictionaries, design and developed data models (physical/logical data models) based on the given specs and requirements.
  • Expertise includes FACT & Dimension Tables
  • Hands on experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 7.0/2000/2005/2008.
  • Good Knowledge in Physical and Logical Data Modeling.
  • Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and good team player

Technical Skills:

Operating Systems

Windows Server 2000/2003/2008
Windows XP/Vista

Languages

T-SQL, PL/SQL, C#.Net, VB.Net, ASP.Net, XML, HTML, Java Script

Tools/Utilities

Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008, SQL * Plus, Toad, Ervin

Databases

MS SQL Server 7.0/2000/2005/2008, Oracle10g/9i, MS Access

Data Modeling Tools

Microsoft Visio, UML

Software

MS Office, Adobe Dreamweaver, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services

Excel, SQL Server Reporting Services, Crystal Reports, Business Objects

EDUCATION

Bachelor’s in Computer Science

Professional Experience:

Confidential, NJ Oct 2009 - present
Role: Business Intelligence Developer

Responsibilities:

  • Collected business requirements from users and translated them as technical specs and design docs for development.
  • Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
  • Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
  • Bulk data migration using SSIS from flat files.
  • Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Developed, monitored and deployed SSIS packages.
  • Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
  • Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
  • Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non queried parameters).
  • Worked on all types of report types like tables, matrix, charts, sub reports etc.
  • Created Linked reports, Ad-hoc reports and etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
  • Designed models using Framework Manager and deployed packages to the Report Net Servers.
  • Created pages in the reports to display depend on Prompt values.
  • Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
  • Implemented security to restrict the access to users and to allow them to use only certain reports.
  • Involved in creating Cubes using SQL Analysis Services (SSAS)

Environment: SQL Server 2008/2005, DTS, SSIS, SSRS, SQL Server OLAP 2005, Reporting Services 2005, T-SQL, MS Access, Windows 2003 Server

Confidential, NY Sep 2008 – Sep 2009
Role: SQL Server Analyst/ BI Developer

Responsibilities:

  • Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
  • Designed ER diagrams (Physical and Logical using Erwin) and mapped the data into database objects.
  • Upgraded MS SQL Server 2005 database to MS SQL Server 2008, by using Detach/Attach, Back up & Recovery.
  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Develop and support OLAP, star schemas, cubes, and conduct data mining and analysis.
  • Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
  • Performed source/target analysis of data structures & content.
  • Converted crystal reports to SQL Server reports using Reporting Services.
  • Published reports and dashboards on WEB.
  • Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
  • Created Calculated Measures and Dimension Members using MDX, Mathematical formulas and User Defined Functions.
  • Used Merge in development, test and production for changing the referenced data.
  • Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Created SSIS package to get data from different sources consolidate and merge into one single source.
  • Used the SSIS ActiveX script task, look up, cached look up, Fuzzy group transformations and data flow tasks.
  • Created package configuration using environment variables.
  • Configured and maintained Report Manager and Report Server for SSRS.
  • Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
  • Generated ad-hoc reports using MS Reporting services and Crystal reports.
  • 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.
  • Used data compression techniques for Back Up.
  • Performed Documentation for all kinds of reports, DTS and SSIS packages.
  • Performed CDC and Change tracking on OLTP systems.
  • Created OLAP cubes & wrote MDX queries for user reports.
  • Develop and support OLAP, star schemas, cubes, and conduct data mining and analysis.
  • Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
  • Created Linked Servers for data retrieval using OLE DB data sources and providers.
  • Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: Windows 2003 Server/XP, IIS7, SQL Server 2008/2005,SQL Reporting, Business Intelligence Studio, Visual Studio 2008/2005, ADO.Net, OLE DB, DTS Package, SSIS.

Confidential, FL Apr 2007 – Aug 2008
Role: SQL BI Architect

Responsibilities:

  • Understanding Customer requirement via interaction and writing functional specification
  • Involved in the System study and Database Design using MS SQL Server 2005.
  • Created tables, fields and attributes. Defined constraints primary and referential Integrity, defined indexes etc.
  • Involved in creating Sequence Diagrams and also involved in creating dynamic models using UML.
  • Created different objects: Stored Procedures, triggers to populate data into different tables according to different parameters specified.
  • Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server to over 60 tables.
  • Developed various stored procedures used in the application using T-SQL.
  • Wrote complex T-SQL queries for data extraction.
  • Wrote DTS/SSIS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
  • Created/modified several Daily running and Month-End Jobs to meet the project specifications.
  • Bulk copy operation using BCP and Bulk Insert for transferring data to the SQL server from different database sources.
  • Developed web pages in ASP using VB and C++.
  • Transferring data between XML document and SQL server using SSIS.
  • Created indexes and proper re-indexing for intensive OLTP system to ensure best performance.
  • Worked with Analysis Services that supports OLAP to design, create, and manage multidimensional structures that contain data aggregated from other data sources.
  • Developed custom reports using Crystal.
  • Tuning SQL query for better performance.

Environment: Microsoft SQL Server 2005/2000, T-SQL, XML, Windows 2000 Server, Crystal Report 8.5/10, SQL server Integration Service(SSIS), SQL Server Reporting services(SSRS), ASP.Net, Visual Studio.Net2005

Confidential, Philadelphia
Duration: Oct 2005 – Mar 2007
Role: SQL Server Developer/BI Developer

Responsibilities:

  • Worked extensively on installation, upgrade and configuration of MS SQL Server 2005/2008 databases servers.
  • Successfully migrated old data from legacy systems (FoxPro) and external system including DB2 and excel into SQL Server 2005 using SSIS, BCP and ActiveX scripts.
  • 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.
  • Worked on Multidimensional Expressions (MDX) to query multidimensional data or to create MDX expressions for use within a cube.
  • Involved in partitioning of cubes in order to increase the performance of cubes (SSAS).
  • Excellent report creation skills using Microsoft Reporting Services (SSRS).
  • Worked with business/functional analysts to determine reports and analytical requirements.
  • Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
  • Documented Report Models and Report Templates for other Team Members.
  • Created Prototypes of some complex reports and validated from the production.
  • Developed Use Case Documents and Technical Documentation for some reports to Hand-off to the Offshore Development Team.
  • Categorized reports into batch reports and on demand reports and scheduled it according to that.
  • Developed complex queries, stored procedures, views, and constraints, triggers using inner and outer joins, unions, and SQL Statements for various applications in different environments.
  • Involved in checking various Performance issues using RS objects of the reports in SSIS, SSRS, and SSAS and in data integrity issues.
  • Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.
  • Worked on Database space management, performance monitoring and alert management.
  • Worked on SSIS script task, look up transformations and data flow tasks using T- SQL.
  • Experienced in loading data from the legacy systems into MS SQL server 2005 using SSIS packages.
  • Created user variables, property expressions, script task in SSIS.
  • Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.

Environment: SQL Server 2008/2005, Business Intelligence Tool 2005/2008, Visual Studio 2005/2008, DTS/SSIS, T-SQL, Unix, Shell scripts.

Confidential, India Oct 2004 - Sep 2005
Role: SQL Server Developer

Responsibilities:

  • Created new tables, views, indexes and user defined functions.
  • Actively designed the database to fasten certain daily jobs and some stored procedures.
  • Optimized queries to improve performance by creating indexes.
  • Involved in performance tuning of TSQL queries and Stored Procedures.
  • Wrote T-SQL statements to retrieve data.
  • Used SQL Analyzer and Profiler for analyzing the SQL statements and procedures.
  • Performed daily database backup & restoration and monitored the performance of Database Server.
  • Created joins and sub-queries for complex queries involving multiple tables.
  • Developed complex stored procedures to create various reports.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Installed and Configured SQL Server 2000 on development server for designing and testing full text search.
  • Access SQL Server using front end applications like .Net

Environment: MS SQL Server 2000, Oracle, Enterprise Manager, T-SQL, DTS, Windows2003, Query Analyzer, SQL Profiler.

Hire Now