SUMMARY

• Having around 7+ years of Total IT experience as Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments in MSBI tools (SQL Server 2008 R2,2012, SSIS and SSRS,SSAS)
• Core Competence in Data Warehousing and Business Intelligence Platform.
• Experience inBI DevelopmentandDeploymentofDTS,SSISpackages from MS - Access, Excel, Oracle and Share Point 2010.
• Experience in solving issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling.
• Rich Knowledge in Object Oriented Analysis and 3 - Tier Architecture.
• Designed and Implemented layers like Dashboard and Scorecard type of Reports.
• Have worked in multiple projects as BI Developer in Designing ETL Packages and reports in development and implementation stages of the project according to client requirements.
• Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms.
• In-depth Knowledge in SDLC life cycle for Design, Development and Staging Phases of projects with support of Data-flow, Process Models, E-R Diagrams.
• DesigningandDeployment of Reportsfor the End-User requests usingWeb Interface&SSRS. Involved in Normalization and RDBMS.
• Supported team in resolving SQL Reporting services and ETL related issues.
• Involved in performance tuning at different levels (Package, Source, Destination and Transformation).
• Knowledge of Data Warehousing (DW) concepts and Data warehouse applications.
• Have experience in Power Shell scripting.
• Have knowledge ofFacets Data Modelin and Billing.
• Experience in tableau.
• Very good knowledge in Informatica.
• Have good knowledge on Teradata database development.
• Working knowledge in Agile/Scrum Environment and used TFS team foundation server.
• Highly motivated with an ability to learn new systems and business processes.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills

TECHNICAL SKILLS

RDBMS: MS SQL Server 2008, MYSQL, MS Access, Oracle(Migration)

APP/WEB SERVERS: IIS 5.0/6.0,TOAD,AS400

Languages: TSQL, C#, ASP.Net 3.5, Visual Basic, LINQ.

Reporting Tools: SSRS 2005, 2008r, QlikView.

ETL&ERP Tools: SSIS 2005/2008r2/2010,2012 SSDT,SAP BI, CRM

OLAP Tools: SSAS 2005, 2008r2, 2012.

Others: BIDS, Visual Studio, .NET, Crystal Reports, SQL Server DBA.

PROFESSIONAL EXPERIENCE

Confidential, EI Segundo, CA

Metric BI Developer

Responsibilities:

• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi dimensional expression (MDX), Perspectives and Roles.
• Worked on Dimension Modeling, E-R Modeling and Schemas.SSIS:
• Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.
• Creating SSIS Packages by using different data PerformedDatabase Refreshtasks from production toDevelopmentandStagingServers.
• Lookup and Working in Blocking and Un-Blocking Transformations.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Configured performance tuning settings using indexes, SQL profiler
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Working with Performance Point Services, Pivot Tables and Tabular Model (2012) and Slowly Changing Dimensions.
• Creating database consolidating data and Loading into live database.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), worked on Performance tuning of SSAS Cubes
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Implemented KPI’s, actions, created calculated members for doing intermediate operations on Cubes in SSAS.
• Simple and Complex reports to generate reports in different formats.
• Based on the requirements develop reports on weekly, monthly and daily basis.
• Designed all most all kinds of simple and complex reports like Drill through, drill down, Matrix, Parameterized reports, and Sub reports in SSRS.
• Created Reports by using Power Pivot in Excel.
• Implemented actions in Various Levels in Reporting Services.
• Coded Business logic in C#
• Designed Web Pages using ASP.Net.
• Designed and Documented GUI by using C#
• Developed test plans and participating Code testing to ensure workability
• Created custom web parts using ASP.Net in windows workflow foundation

Confidential, Baltimore, MD

Application Support Analyst

Responsibilities:

• Performed analysis of Business requirements and interpreted transformation rules for all target data objects. Developed ETL specification based on business requirements.
• Designed and developed the Data Flows and control flows and performed data cleansing and quality using Fuzzy lookups.
• Worked with Different data transformations like Slowly Changing Dimensions, Data conversion, Union All, Sort, merge joins, look up etc.
• Analyzed the change requests (CRs) and Business Requirement Document (BRDs).
• Done the Unit testing on newly created SSIS Packages.
• Created/ Updated the ETL Technical Documentations on Clients Repository Portals.
• Involved in creating and modifying the ETL jobs and monitoring the ETL Schedule.
• Involved in performance tuning of SQL statements, Query optimization and Explain Plan utilities. Performed SQL queries extensively to test the Data Warehouse.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Handled Scheduled backups and restore operations withLiteSpeed 5.0and monitored the Tasks, Maintenance plans.
• Implemented Cube Security by Using Roles and Dimension security in the cube using Many-to-Many Dimensions for a user view of the data in the data source.
• Created different kinds of Reports like Drill down Reports, Matrix, drill through reports, Linked Reports using SQL Server 2008 Reporting Services.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Experience in designing reports using SQL Server Reporting Services (SSRS).
• According to the situation created Subscriptions, snapshot and Linked Reports.
• Coded Business logic in C#
• Designed Web Pages using ASP.Net.
• Designed and Documented GUI by using C#
• Developed test plans and participating Code testing to ensure workability
• Created custom web parts using ASP.Net in windows workflow foundation

Confidential, Ashburn, VA

SQL BI Developer

Responsibilities:

• Implemented Optimization of Stored Procedures.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and long running queries by checking appropriate changes to Transaction Isolation levels.
• Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2008R2 and 2012 OLAP databases.
• Extensively Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA.
• Development of packages according to the ETL specifications for the staging area & warehouse data loading using SQL Server Integration Services & SQL Server 2005
• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Involved in Huge data migrations, transfers using utilities likeData Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Used transformations like Derive Column, Conditional Split, Aggregate, Row Count, Lookup sort, Data Conversion and Script Task to load data into Data Warehouse.
• Implemented Package Configuration, Message Logging and Auditing.
• Created Simple and complex ad hoc reports.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Worked with chart Report, Matrix and Chart reports.
• Developed reports in the form of Matrix, Chart by using SQL server 2008 Reporting Services.

Confidential, Nashville, TN

BI Consultant

Responsibilities:

• Migrated the data (Import & Export of data) from one server to other servers using tools like Data Transformation Services (DTS).
• Transformed data from various data sources using OLE DB connection by Creating SSIS Packages.
• Cube deployed and Processed from OLAP system in SSAS
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in Attaching and Restoring the Database.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2008 Business Intelligence Development Studio.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error log
• Resolved issues for mission critical high usage of system CPU, Disk, Deadlocks and Transaction per/sec, Memory.
• Involved In Data Replication, ETL and Query Execution Plan .Configured Performance Tuning Settings using Indexes and SQL Profiler.

Confidential, Atlanta,GA

SQL BI Consultant

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
• Implemented transactions at package level and task level to meet the business requirements.
• Involved in debugging the Packages by utilizing SSIS features like breakpoints, Data-Viewers and custom loggings.
• Designed SSIS package templates as base code for package development incorporating package .
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Created SSRS reports using Report Parameters and Drop-Down Parameters
• Involved in Report generation using SSRS and Excel services, Power Pivot and deployed them on SharePoint Server.
• Generated Reports weekly and monthly to an online management interface using SSRS Post production support Critical issue resolving in given timeframe. Monitor jobs and reporting, performed code reviews, unit testing.
• Status meetings with the client, conducting reviews of the deliverables, defect tracking and analysis
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options

Environment: SQL Server 2012, T-SQL, DB Artisan, MS Integration, Analysis and Reporting Services, Management Studio, Query Analyzer, Windows 2007 Server, Oracle 11g.

Confidential

MS BI Developer

Responsibilities:

• Designed logical and physical models for staging database and data warehouse using Erwin database modeling tool.
• Created database projects for staging database and data warehouse in visual studio 2008, to store all related objects at one centralized location.
• Designed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to the business.
• Created complex ETL (SSIS) packages to pull data from DB2/Oracle, load monthly data from Excel to SQL server.
• Used master child SSIS packages for better design and ease of maintenance.
• Implemented error & failure handling in SSIS packages using event handlers, row redirects, check points and used loggings for monitoring the execution.
• Optimized packages by avoiding use of non-blocking transformation, executing tasks in parallel and optimizing code at source.
• Created alerts and mail confirmation of all packages and cube processes in SQL server Agent to get event messages such as success/failure of package, procedure.
• Deployed SSIS packages to the production server using XML and SQL server configurations.
• Created different kind of reports like parameterized reports, drill down reports, and sub reports to support business needs and involved in report deployment and report security.
• Designed the architecture for Extract, Transform, Load environment, development of mappings and process using Informatica Power Center.
• Created Ad-hoc reports using Report Models (.smdl) files and deployed it on Report Manager to create reports on the fly for the people who are less adept with technical skills.
• Configured deployment of SQL Server Reporting Services to work with deployment of Microsoft SharePoint Integrated mode
• Optimized the performance of reports by using various techniques like optimizing data-sets, making use of less number of input parameters along with caching and taking snapshot of reports.
• Implemented security on reports at Server Level, Report Level and Item Level according to the hierarchy in the organization and business requirement.
• Administered interface to organize reports and data sources, schedule report execution, delivery and track report history.