We provide IT Staff Augmentation Services!

Sr. Business Intelligence Consultant Resume

3.00 Rating

Grand Rapids, MI

PROFESSIONAL SUMMARY:

  • More than eight years of experience in end - to-end implementation of Business Intelligence and Data warehousing projects as a Business Analyst, Developer and Quality Analyst using SQL server Management studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
  • Good understanding of Data Warehousing concepts and ability to create star schema and snow flake schemas according to the requirement
  • Good knowledge on installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server
  • Experience in creating Databases, Tables, Stored Procedures and functions, Triggers, Views, Cursors and Indexes on SQL server.
  • Worked on writing complex SQL queries, performance tuning and Query Optimization on SQL server
  • Created complex SSIS packages using multiple data sources, and worked on creating jobs, Alerts and scheduled them using SQL Server Agent and JAMS
  • Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages
  • Developed DTS packages for importing and exporting data from various databases like Oracle, DB2, MS Excel, Flat files.
  • Expert in data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
  • Good expertise in designing reports using SSRS and Excel PowerPivot table based on OLAP cubes
  • Experience withLDAP, handling Active Directory data using SQL Server
  • Worked on creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports using SSRS
  • Hands on experience in scheduling and deploying reports on report manger.
  • Involved in designing, deploying and processing OLAP Cubes using SSAS for the analysis of data with pre-calculated aggregations and also in summarized fashion which can be modeled into a report accordingly. Worked on creating pivot charts and pivot tables based on OLAP cubes in 2012.
  • Worked on Developing and Extending OLAP Cubes and also on writing MDX Scripts for the OLAP cubes
  • Working knowledge of installation, configuration ofTableauproducts likeTableauDesktop and Reader.
  • In-depth knowledge and experience in sharing/distributing reports through SMTP server, Windows File Share,PowerBIand Share Point.
  • Good knowledge of System Development Life Cycle (SDLC), Agile and Waterfall development environments

TECHNICAL SKILLS:

Business Intelligence Tools: Data Tools and BIDS including Enterprise Manager, DTS, Profiler, DTA, SQL Profiler, Query Analyzer, SSIS, SSRS,SSAS

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

Programming Languages: SQL,PL/SQL,C#,VB

Operating System: Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0

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

Source control tools: Tortoise SVN, TFS, Visual Source Safe

PROFESSIONAL EXPERIENCE:

Confidential - Grand Rapids, MI

Sr. Business Intelligence Consultant

Environment: SQL server 2014/2012/ 2008 R2, VS 2012/2008, Business Intelligence Development Studio(BIDS), SSIS, SSRS, SSAS, T-SQL, Tortoise SVN, C#, Power pivot, MDX, Power BI, XML,XSLT, Tableau

Responsibilities:

  • Architected in creating Data warehouse by getting data from multiple source systems
  • Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task
  • Worked on migrating DTS/SSIS packages from 2008 R2 to 2012
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
  • Involved in planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
  • Also designed interactive dashboards reports in SSRS using a new specialPowerBIfeature and shared them on Share Point for the executives
  • Developed and executed several optimized queries in SQL.
  • Developed tables, views, triggers and stored procedures using T-SQL
  • Implemented ETL using SQL Server Integration Services (SSIS).
  • Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Worked on configuring high availabilitylikeClustering,Databasemirroringand transactional replication.
  • Worked on resolving clustering,Databasemirroringand transactional replication issues
  • Use SQL Server SQL Profiler to enhance query performance improvement.
  • Enhanced and deployed the SSIS Packages from development server to production servers.
  • Loading data from various sources such as flat files to SQL Server database using SSIS Package.
  • Used temporary tables, table variables in stored procedures to simplify complex queries.
  • Used SSIS to build high performance data integration solutions, including extraction, transformation, and load (ETL) packages and also scheduled the SSIS packages and jobs.
  • Used SQL server reporting services (SSRS) delivering enterprise, web-enabled reporting to create reports that draw content from a variety of data sources.
  • Designed and created report models based on users’ requirements, explained and trained users to use report builder to generate their own personalized reports.
  • Developed various operational Drill-through and Drill-down reports using SSRS
  • Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
  • Designed, developed and deployed reports in MS SQL Server environment using SSRS.
  • Highly involved in creating, structuring, formatting usingReport Designer and Report Builder.
  • Created SSIS packages and scheduled jobs to call the packages and stored procedures.
  • Involved with modifying reports by parameterizing or including formulas for existing reports.
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
  • Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
  • Created Alerts for successful or unsuccessful completion of scheduled Jobs.
  • Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
  • Created named query in SSAS Data Source View to get appropriate hierarchical summarizedata for two dimensions.
  • Created Perspectives of the cube to simplify the process of browsing for the end users.
  • Used MDX to create calculated members in the cube.

Confidential - NC

Business Intelligence Consultant

Environment: SQL Server 2008 R2,ORACLE 11g, DB2, MSBI, SQL Server Integration Services, SQL Server Reporting services, Report Builder, SQL Profiler, C#, T-SQL,JIRA,AGILE, Power BI, XML, XSLT

Responsibilities:

  • Worked with Business Analysts in gathering business requirements and translating them to technical specifications.
  • Created tables based on business needs, created views, used stored procedures, functions and indexes
  • Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
  • Created jobs, alerts and scheduled DTS to generate reports.
  • Designed and implemented Parameterized and cascading parameterized reports using SSRS for branches.
  • UsedPowerBItools to develop interactive reports to update on Dashboard.
  • Developed ETL packages with various different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS) ETL development tool.
  • Developed ETL application to load branch into the archive database servers.
  • Involved with the loading of SSIS packages into SQL Server from flat files and excel spreadsheets.
  • Implemented Extraction, Transformation and Load (ETL), import, export activities by DTS /SSIS package
  • Created SSIS Packages for migration of data between SQL Server and other databases such as MS Access, DB2, and Oracle.
  • Extensively used SQL Server Reporting Services to generate reports such as drill down, parameters, group, cascading, chart financial reports based on business requirements.
  • Created ad-hoc reports for business users using SSRS 2005 and 2008.
  • Generated reports using SQL Reporting Services (SSRS) for customized and ad-hoc queries.
  • Involved in designing, developing, debugging and testing of reports in SQL Server 2008 Reporting Services (SSRS).
  • Generated several drill down and drill through reports using SSRS.
  • Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.
  • Generated ad-hoc, matrix, stepped, block and tabular reports using SQL Server reporting services based on customer needs and requirements.
  • Worked on creating and maintaining SSAS Databases which includes creating new Cubes, Dimensions, and Calculated Measures, Partitioning and building MDX queries
  • Work on SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Performed data analysis to generate various trend reports for commercial accounts based on branches.

Confidential - TN

SQL BI Developer

Environment: SQL Server 2008, MSBI, SQL Server Integration Services, SQL Server Reporting services, Report Builder ASP.NET, C#, T-SQL,SVN

Responsibilities:

  • Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
  • Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).Involved in creating SSIS jobs to automate the reports generation
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Created complex SSIS packages using proper control and data flow elements with error handling.
  • Installation and configuration of SQL Server 2008.
  • Involved in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using Sql Server Reporting Services 2008.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • 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)
  • 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.
  • Involved in modifying report content and exporting reports in multiple formats based on the business requirements.
  • Designed and implemented Parameterizedand cascading reports using SSRS 2008.
  • Created derived columns on the final fact and dimension tables as per the business requirements.

Confidential

MSBI Consultant

Environment: ERWIN,SQL Server 2005, SQL Server 2008, MSBI, SQL Server Integration Services, SQL Server Analytical Services, SQL Server Reporting services, Report Builder, SQL Profiler, T-SQL, Visual Source Safe, HP Quality CenterResponsibilities:

  • Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i
  • Involved in creating highly interactive score cards and Dashboards using Performance Point Server.
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes.
  • Generating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
  • Involved in designing, developing, debugging and testing of reports in SQL Server 2008 Reporting Services (SSRS).
  • Expert in creating Star schema cubes using SSAS.
  • Designed and created the table schema and stored procedures that will be used in Data QC.
  • Designed and developed the Data QC Maintenance website that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file.
  • Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
  • Responsible for documentation of system related activities.
  • Provides technical documentation of the system
  • Code reviews to move it to the production developed by developers.

Confidential

SQL server Developer

Environment: ERWIN,SQL Server 2005, SQL Server 2008,ORACLE 8i MSBI, SQL Server Integration Services, SQL Server Reporting services, Report Builder, SQL Profiler, T-SQL, Visual Source Safe, HP Quality Center, JIRA

Responsibilities:

  • Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
  • Worked on the Reports module of the project as a developer on MS SQL Server 2005(using SSRS, T-SQL, scripts, stored procedures and views).
  • Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i
  • Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
  • Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
  • Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
  • Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
  • Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
  • Involved in deployment of SSRS reports on the SharePoint Portal.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Wrote stored procedures to get the fields required for the reports.
  • Created datasets using stored procedures and reports using multi value parameters
  • Created sub reports, bar charts and matrix reports.

We'd love your feedback!