SUMMARY

• Over 5 Years of experience in Data Analysis, Business Analysis and Business Intelligence reporting tools.
• Looking to secure a Business Intelligence Analyst position with the company that will enable the use of exceptional problem - solving, analytical and technical skills.
• A dedicated, detail-oriented individual with almost two years of experience as a data analyst with outstanding analytical and communication skills.
• Skillful in gathering data through a number of ways, from mining a company's computer data through software, looking at competitor data and industry trends to help develop a picture of where the company stands in the industry, where they can improve and where they can reduce costs.
• Clear and precise in communicating the findings to the company or their managers.
• Prowess in Project management including customer interaction, scope definition, project planning, change control and integration.
• Creating Work Breakdown Structures (WBS), Project Schedules and Project Timelines.
• Well versed in documentation of Product Definition Document (PDD), Business Requirements Documentation and System Requirement Specification (SRS).
• Skilled in project management tools like MS-Project for status reporting and project planning.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Misanalysis Services.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Involved in design of logical and physical data modeling using Erwin data modeling tool.
• Worked with Business Analysts, Web development team, and users on database solutions.
• Expertise in SQL Server 2005/2008 R2 Reporting Services (SSRS), SQL Server 2005/2008 R2 Integration Services (SSIS) and in SQL Server 2005/2008 R2 Analysis Services (SSAS) in Business Intelligence (BI).
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Good analytical and communication skills and ability to work independently with minimal supervision and also a great team player.
• Organized weekly Project Status and Task Review meetings.
• Created PowerPoint presentations and project updates using MS Project for management review.

TECHNICAL SKILLS

Operating System: Windows NT 4.0, Windows 2000/2003/2008 R2 Enterprise/Datacenter Server, XP Professional, UNIX.

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

Programming Languages: T-SQL, C, C++, Shell Scripting, SQL, XML, C#, VB.NET, MDX

Business Tools: Word, Excel, PowerPoint, Access, Visio, Outlook.

Database Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS, SSAS, Index Analyzer, SQL Client Utility.

Reporting Tools: Reporting Service (SSRS) 2000/2005/2008 R2/2012

ETL Tools: DTS, SSIS.

MS Tools: Management Studio, Visual Studio. Share Point, TFS 2012.

Internet Tools: Internet Information Server (IIS 5.0 / 6.0), FTP, TCP/IP

Other Tools: Source Depot, Octopus, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Data Analyst and SQL Server

Responsibilities:

• Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2005/2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• I Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Worked with development teams in the design of physical databases and in modification.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
• Deployed designed PPS dashboards & reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Created ETL SSIS packages both design and code to process data to target databases.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Constructed OLTP and OLAP Databases.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: Windows 2003/2008 R2 Server, MS SQL Server 2005/2008 R2, BIDS, ASP .NET, XML, SSIS, SSRS, SSAS, Source Depot, JIRA.

Confidential, Milwaukee

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2005/2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• I Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Worked with development teams in the design of physical databases and in modification.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
• Deployed designed PPS dashboards & reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.
• Created ETL SSIS packages both design and code to process data to target databases.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Constructed OLTP and OLAP Databases.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: Windows 2003/2008 R2 Server, MS SQL Server 2005/2008 R2, BIDS, ASP .NET, XML, SSIS, SSRS, SSAS, Source Depot, JIRA

Confidential

SQL Server/BI Developer

Responsibilities:

• Installation of MS SQL enterprise servers on test and development boxes.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assigning access privileges to users.
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Monitored and scheduled existing/new jobs on production environment.
• Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers.
• Worked to tune the SQL queries using SQL Profiler.
• Tested backup and recovery strategies in a test environment before and after moved to production environment.
• Extensive use of Stored Procedures. Created new stored procedures and modifying existing ones.
• Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
• Created ETL process using SSIS to transfer data from heterogeneous data sources..
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Designed SSAS cube to hold summary data for Target dashboards.
• Developed Cube with Star Schema.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2005, MS SQL Server 2000, Windows 2003 Server, T-SQL, SSIS, SSRS,SSAS, ASP .Net, VB.net