RAJESH AIYNAMPUDI

MSBI Developer

Personal Details:-

Address: London E-mail: acw104@r.postjobfree.com

Mobile: 075********

Profile: -

A SQL Server BI Developer with 5.5 years of Commercial experience across multiple sectors, Predominantly Finance, Retail and Telecommunications. Experienced on Large SCALE Projects, Designing and Maintaining high-performance, High volume and high available of OLTP, ETL, Data warehouse and reporting databases in high-pressure 24*7 environments with databases.

Strong experience in SQL Development, ETL Development using Microsoft SQL Server Integration services (SISS), Business Intelligence delivery using Microsoft SQL Server Analysis (SSAS) and reporting solutions using Microsoft SQL Server Reporting Services (SSRS).

Good problem solving skills, demonstrated by the ability to break down complex business requirements logically and solve appropriately.

Seeks Contract work being Immediately available for both Interviews and starts for most of the Locations in U.K

Education and Qualifications:-

Master of Computer Systems in University of Bedfordshire (2010), UK.

Bachelor of Engineering (EEE) in Jawaharlal Nehru Technological University, India.

Technical snapshots:

Databases : MS SQL Server 2012, MS SQL Server 2014, MS SQL Server 2008 R2

ETL Tools : SQL Server Integration Services (SSIS)

BI/OLAP Tools : SQL Server Analysis Services (SSAS)

Reporting Tools : SQL Server Reporting Services (SSRS), MS Excel

Database Utilities : Enterprise Manager, Query Analyzer, SQL Server Profiler, Manual Testing

Development Tools : Visual Studio 2005/2008/2010

Languages/Scripting : T-SQL, stored procedures, MDX, DMX, XML, Java, Sales force

Operating Systems : Windows 2003 / 2008 & R2 Server.

Industry Experience : Finance, Retail, Telecommunications, Transport, Banking and Education.

Professional experience:

SQL Developer/SSRS/SSAS Developer/March 2016 – till Date Boots, UK

Description:-

The project aims that deliver and provide excellent customer experience. My role is getting involved in the development of the core customer databases, market regulator’s data and transactional customer data using SQL. This was used for analysis prior to development of financial analysis and reporting, Marketing, Sales campaigns and reporting via BI Interface and SSRS.

Roles and Responsibilities:-

Extracted data from internal data warehouse system to SSRS. Extensively worked on SSRS and delivered complex reports from different data sources such as SQL Database and Cubes.

Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.

Developed a high level Sales dashboard Reports using SSRS.

Designed and created Report templates, bar graphs and pie charts based on the financial data.

Optimizing and Performance Tuning SQL Scripts in order to make reports run smoothly and efficiently.

Experienced in writing complex SQL Queries, Stored Procedures, Views, Joins, DML, DDL and User Defined Functions to implement the business logic.

Involved in designing cubes in SSAS environment using Snowflake and Star Schemas.

Complex cubes were designed and developed with SSAS and Delivered BI reports.

Extensive knowledge in SSAS storage and Partitions, and Aggregations, Calculation of queries with MDX, developing reports using MDX and T-SQL.

Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.

Used SQL Profiler to Performance of Queries and to Index the Tables. Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.

MSBI Developer/SSIS/SSRS/SSAS/L&G June 2015–Feb 2016 Prudential finance, UK

Description: - Prudential Finance Company serves Individual and Institutional Customers worldwide. The Project involved designing a new database schema, and integrating data from SQL Server 2005 to SQL Server 2012, Performing Analysis and then generating various types of Reports.

Roles and Responsibilities:-

Extracted data from heterogeneous source like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration services (SSIS) from OLTP to OLAP. Used SSIS to create ETL Packages to validate, Extract, Transform and Load data to Data warehouse and Data Mart Databases.

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.

Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modelling process.

The Packages created included a variety of transformations, for example slowly changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversation.

Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS.

Created Data Transformations tasks like BCP, BULK Insert to Import/export data from Clients.

Implemented MS Analysis Services setup, tuning, cube partitioning, Dimension design including hierarchical and slowly changing dimensions.

Created calculated measures and Dimension members using multi dimensional expressions (MDX), mathematical formulas, and user-defined functions.

Created different type of reports including Cross – tab, Conditional, Drill-Down, Sub Reports using SQL Server Reporting Services (SSRS).

Generated Dynamic Reports from Cubes (SSAS) using SSRS – 2012/2008. Experienced in developing reports from cubes using KPI’s for decision making, also Debugging data connections, data sources and Data Source views.

Gathered user requirements, drafted specifications, designed, documented and wrote test script for testing of all the report.

Involved in writing SQL Queries, View and Stored Procedures on SQL Server 2012/2008.

Designed databases for applications with requirements for large numbers of transactions, heavy access and high availability.

Optimized T-SQL Code. Used Index Tuning wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.

Involved in database migration from server to another server using backup and Restore.

Setting up Backup for the Databases and Configured database backup’s and validate the backups.

Migration /SSIS/SSRS/L&G Technologies Dec 2014 – May 2015 Deutsche Bank, UK

Description:

Deutsche Bank is a Financial Company. The Project aims Data Migration from Oracle legacy systems to SQL Server 2012 and Generate Parameterize Reports of the Customers.

Role & Responsibilities:

Involved in Data Migration from Oracle legacy systems to SQL server 2012 redesigned database.

Performed initial data migration, subsequent data migrations and validated the data been converted.

Troubleshooting SSIS Packages, fixing the bugs/errors and Migration issues.

Understanding business logic in complex procedures and achieving same based on new data model.

Experienced in the migration of data from Excel, Flat file and XML to SQL Server 2012 by using conversions.

Identify and re-writing best possible code when migrating to newer version of SQL Server.

Extracted data from Oracle (ODBC) servers and load the data into SQL Data warehouse.

Used SQL Server Migration Assistant (SSMA) for Oracle is a tool for migrating Oracle Databases to Microsoft SQL Server 2012. Created database links between Oracle 10g and SQL Server 2012.

Involved in gathering the user requirements, analysis, design, development, and deployment.

Created SSIS packages to migrate data from Oracle DB to SQL Server 2012.

Setup backup and Restoration jobs for Development and QA Environments. Setting up Backup’s for the Databases and Configured database backup’s and validate the backups.

Created Regulatory reports, ad-hoc reports, Identified and worked with Parameters for Parameterized reports for Business users using SSRS.

Wrote complex SQL Queries and could quickly understand requirements for complex queries and Procedures.

Created Cross-Tab, Drill-down, Drill-down and Sub-Report using and linked reports using SQL Server Reporting Services.

Debugging reports and deploying reports.

Involved in SSRS report deployment and report server configuration.

Scheduled the reports to run automatically.

Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.

Sep 2011-Nov 2014 – Computech Careers UK

Computech careers is one of the leading software solutions provide for major clients in

U.S & U.K on different Business sectors like Marketing, Retail, Finance, Telecom and education.

SQL Server BI Developer May 2014 – Nov2014 Clement, UK

Description:

Clements are the leading expat insurance provider in the UK. The main aim of the project is find Various Premiums, Claim paid to the policyholder, Commission paid to the Agents and premium received from the policyholder. We can track the premium by channels, Marketing type and Location. This project will enhance the decision making capabilities of a Brand manager by various reports and graphical charts.

Role & Responsibilities:

Implemented and delivered BI platform solutions to develop and deploy ETL, analytical, reporting on SQL Server 2008 R2 using SSAS, SSIS & SSRS.

Created and managed databases for clients as well as systems to client data and reporting of finalized data.

Used T-SQL Statements write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.

Developed, deployed and monitored SSIS packages for new ETL process and upgraded to SSIS for the on-going ETL process.

Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task.

Extensively used Derived Column, Row Count, Data Conversion, Conditional Split and Aggregate.

Created of package configuration to handle data source connection information.

Designed and developed reports in BIDS environment and deployed into Web-Interface (virtual directory) in SQL Server Reporting Services SSRS.

Designed Dashboards, Ad-hoc reports, Drilldown reports, drill through reports, with various report tools (like table, matrix, chart, bar, pie chart and gauge) in SSRS.

Designed cubes in OLAP, Identified measures/ fact tables, Database dimensions and developed Data Source View (DSV).

Build, process and deployed cube in analysis services SSAS with various processing options.

Experienced in Power Pivot to Import data from an Analysis Cube.

Developed MDX queries in management studio (SSMS) to browse cube and assist finance and marketing teams.

Scheduled automated reports on a monthly/weekly basis.

Technical snapshot:

SQL Server 2005/2008&R2, Windows Server 2008R2, Analysis services, Reporting services, SQL Profiler, MS Excel, SQL Server Management Studio, Microsoft Visual Studio 2008/ 2010.

SQL Server/SSAS/SSRS Developer June 2013-Jan 2014 Exxon mobil, UK

Description: Exxon mobil is one of the leading retailers in UK & nation's largest business. The project involved in transferring data from OLTP (Online Transaction Processing) to OLAP (Online Analytical Processing) and in creating cubes using SQL Server Analysis Services to analyze the business activities.

Responsibilities:

Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.

Experienced in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.

Experienced in Power Pivot to Import data from an Analysis Cube.

Installed, configured and maintained SQL Server Integration Services (SSIS).

Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.

Experienced in requirement gathering, cube design, application design, SSAS development, training operational users.

Implemented SQL Server OLAP services (SSAS) for building the data cubes. Extensively creating complex cubes for seeing business data from different perspectives by slicing and dicing the data.

Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script. Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes. Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).

Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Designing and building data load procedures using MS SQL Server.

Designed and implemented Stored Procedures and Triggers for automating tasks.

Technical snapshot:

SQL Server 2005/2008&R2, Windows Server 2008R2, Analysis services, Reporting services, SQL Profiler, MS Excel, SQL Server Management Studio, Microsoft Visual Studio 2008/ 2010

SQL Server/SSRS/SSIS Developer Sep 2012 – Feb 2013,FidelityInvestmentscorp,Boston

Description: Fidelity Investments, one of the largest mutual fund groups in the world, is an international provider of Financial Services & investment resources. This project mainly involved in creating Databases, creating, Deploying and scheduling Reports. And also included Extract, Transfer and Loading of Data from excel sources, Flat File… etc using SSIS, writing T-SQL and creating operational, drill-through and dynamic reports using SSRS 2008 R2.

Roles & Responsibilities:

Wrote several SQL scripts such as finding tables that have Identity Columns, finding tables that don’t have Primary key.

Used joins and sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures.

Involved in report design and coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboards type metrics using SSRS.

Created Cross-Tab and Sub-Report using RDL and promoted RDL’s to Reporting Service server.

Developed complex Stored Procedures and views to generate various Drill-through reports, Parameterized reports and linked reports using SSRS.

Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and Flat files into SQL Server 2008 R2 for further Data analysis and Reporting by using multiple transformations provide by SSIS as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all… Scheduled and maintained daily and weekly loads of data by creating the corresponding job tasks.

Experienced in designed and developed the Reports in BIDS Environment and deployed into Web-Interface in SQL Server Reporting Services.

Environment: MS SQL Server 2005/2008/2008r2/2012, SQL Server Integration Services (SSIS), SSRS, SSAS, T-SQL, OLAP Services, MDX.

SQL Server Developer, Sep 2011– may 2012 Barnes & Noble’s, USA

Description: This Project aims at integrating services 2008 and generates parameterized reports of the customers.

Roles and Responsibilities:-

Created SSIS packages to migrate data from Sales force DB to SQL Server 2008.

Creating Stored Procedures for reports generation.

Involved in database backup, recovery procedures and Planned back up strategy for disaster recovery.

Analyzed the existing application programs and tuned SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor.

Proficient with SQL server agent for scheduling jobs, SQL profiler for database tuning.

Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.

Tested applications for performance, data integrity and validation issues.

Environment: MS SQL SERVER 2008 R2, SQL Server 2012, MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler.

SQL Server Developer, SSRS, India, May 2008 – Oct 2008 Meta InfoTech, Mumbai

Description:

Direct Energy is the largest competitive retailer in North America of electricity and natural gas, home services, energy efficient solutions and more. The project is to develop the TAX Data Warehouse for Direct Energy (DE). This DW is a Business Intelligence (BI) Tax and Revenue calculation system build for Mass Markets (MM) and for direct customers. The system is used to analyze billed volumes in comparison against purchased volumes.

Roles & Responsibilities:

Involving in Creation of tables, indexes, sequences, constraints and created stored procedures and triggers which were used to implement business rules.

Developing various SSIS Packages using Stored Procedures and Complex SQL Queries.

Good Knowledge on SQL Query Optimization and Stored Procedures Performance Techniques.

Implemented in Transactions and Isolation levels in SQL Server.

Creating ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.

Generating various reports with drilldowns, drill through, calculated members, and dropdowns from the connecting to server and SQL Server from SSRS.

Environment: MS SQL SERVER 2008 R2, SSRS, Microsoft Visual Studio 2008, SQL Profiler.

References will be provided upon request.

Willing to relocate anywhere in Europe.

Contact this candidate