Business Intelligence (BI) Resume

SUMMARY

Highly Proficient with over 10 Years of experience in analyzing, designing, tuning and developing Client/Server, Business Intelligence (BI).
Experience with MS SQL Server 2012/2008/2008R2/2005/2000 and worked on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
Expert in creating SQL objects like Tables, Complex Stored Procedures, Triggers, Views, Indexes, and User Defined Functions to facilitate efficient data manipulation and consistent data storage.
Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
Strong technical knowledge in MS SQL Server development including Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
Experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
Experience in providing Logging,Errorhandling by using Event Handler, and Custom Logging for SSIS Packages.
Experience in data Extraction, Transformation and Loading (ETL) processes. Worked extensively on data extraction, cleansing and data integration, and loading from different data sources using SSIS.
Excellent experience in creating reports using Microsoft SQL Reporting Services (SSRS).
Experience in developing deploying and managing various reports like ad-hoc reports, crystal reports, simple and parameterized reports using SQL Server reporting services (SSRS).
Experience in developing reports like Tabular, Matrix, List, and Sub Reports using SSRS.
Experienced in creating Cascading, Linked, Drill-Through and Drill-Down reports.
Knowledge of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
Expertise in Relational Database Management Systems and different schemas like Star Schema and Snow Flake Schema and also Data Modeling, and Cubes.
Experience in developing scripts usingT-SQLfor querying against databases.
Knowledge of compiling strategic analysis for moving typical data from one source system to another source system and to warehouse and implemented ETL operations.
Experience in creating loaders and relational writes to load data from SSIS.
Knowledge of creating reports for the end user delivery purpose by identifying obstacles in sources, targets and packages.
Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities, DMV’s, Backup and Recovery.
Experience in developing and deploying SSRS Reports from SSAS cubes and various data sources on the portal for the user accessibility.
Proficient in using templates for Multi-DimensionExpressions(MDX) to calculate Key Performance Indicator (KPI) in SSAS.
Experience in SQL server services 2005 and 2008 for creating client reports and custom reports.
Knowledge of designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
Knowledge of writing queries for generating drill-down reports and designing report layout from XML, SQL server, MS Excel as data sources using MS SQL server reporting services (SSRS).
Exposure to various software testing methodologies like Waterfall, Agile.
Proficient in debug, maintenance of ETL packages and ETL optimization using SQL Server best practices.
Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduling DTS Packages.
Ability to work effectively and efficiently in a team and individually
Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills.

TECHNICAL SKILLS

Databases: MS-SQL Server 2012/2008R2/2008/2005/2000, Oracle 11g/10g/9i Microsoft Access, SharePoint 2010/2007Oracle SQL Server 9i/10g/11g.

Programming Languages: T-SQL, PL/SQL, HTML, DHTML, XML, VB.NET, C#.NetC++, JavaScript, Unix ODBC

IDE Tools: Visual Studio .Net 2010/2008/2005

Framework: Microsoft .Net Framework 4.0/3.5/3.0

Data Modeling: Erwin, MS Visio2010.2007/2005.

ETL Tools: SQL Server Integration Services (SSIS)Data Transformation Services (DTS).

Reporting Tools: SQL Server Reporting Services (SSRS) 2008R2\2008\2005Crystal Reports, Business Objects.

SQL Server Tools: SQL Server Management StudioSQL Server Business Intelligence Development studioEnterprise Manager, SQL Profiler, Query AnalyzerImport & Export (DTS), and performance point server 2007.

Configuration Management Tools: JIRA, Team Foundation Server (TFS) 2010/2008/2005.

Operating System: Windows Server 2003, Windows 2000 Advanced Server/Professional, Windows NT, Windows XP Professional /Standard

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship