Vikram K Email & Phone Number

Dayton, Oh, Us

Dayton, Ohio, United States

● Created Reports with different Output formats such as Excel file, fixed width text file, PDF, tab-delimited and pipe-delimited. ● Worked on several State Reports and used SSIS to create multiple destination files from single/multiple sources. ● Exposure to Power BI concepts for creating visualized reports and publishing it within the team.● Generated reports from the cubes by connecting to Analysis server from SSRS.● Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.● Develop physical data models using ERWIN and created DDL scripts for database schema and objects.● Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc. and scheduled SSIS packages.● Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data so0urces using SSIS.● Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.● Data modeling of all Process flows to integrate multiple banking systems via acquisition using Visio 2013 and CA Erwin 9.0 Tools, NDM Data Transmission with SSIS Packages.● Develop complex SSIS packages with different data sources incorporating script task (VB scripting or C# scripting), etc. to deliver data reports to business users.● Experience in creating complex SSIS packages using proper control and data flow elements.● Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS. ● Responsible to build Reports for different Markets and ADHOC reports as per request. ● Documented Back out Implementation Plan for all the work done and also created the CMD files. ● Worked with Team foundation server version Control to maintain the different versions of Code, RDL Files, Back out Scripts, CMD files & SSIS Packages.

Hyderabad, Telangana, India

● The project is designed in two phase's data gathering and reporting, the data gathering part is done using SQL Server Integration Services (SSIS) and the reporting portion is built on SQL Server Reporting Services (SSRS) platforms● Developed Tabular Reports, Matrix Reports parameterized Reports Sub reports, Snapshot and Adhoc reports (SSRS).● Developed physical data models using ERWIN/ ER Studio and created DDL scripts for database schema and objects.● Worked on Installation and Maintenance of SQL Server 2014/2012 on Test, Development and for Production Environments worked closely with Admin teams.● Stored Procedures, User Defined Functions, Views, TSQL for complex business logic. ● Design and implementation of SSIS/ETL process for the system. ● Data conversion from mainframe system and Oracle databases to SQL server.● Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.● Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.● Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.● Designed and developed different type of reports including Tabular forms, Dashboards, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.● Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI● Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.● Modified stored procedures to meet current design and used them in SQL Server.

Hyderabad, Telangana, India

● Worked as a SSRS Reports Developer/Administrator and SQL Server Developer in support of Service Management System.● Created the basic SSIS Framework Technical documents consisting of Naming conventions for packages, transformations, connection managers, log files etc.● Implemented various types of control flow and data flow transformations in packages to handle different logics and Created SSIS package for Market Value Process feed.● Used C# scripts in SSIS script task to run custom scripts in package flow.● Creating various periodic reports for customers using SSRS, performance point server.● Developed and tested complex Transact SQL database objects using MS SQL Server such as stored procedures, functions, views and triggers.● Managed all indexing, debugging, optimization and performance tuning using Profiler and SQL Server Agent. ● Generated complex T-SQL queries, sub-queries, co-related sub queries, dynamic SQL queries etc.● Worked with several control flow tasks, data flow tasks, transformations (derived column, lookup, merge join, conditional split, slowly changing dimensions, data conversion etc.) in SSIS packages.● Involved in package logging in both standards (SQL server and file based) and custom logging using customer stored procedure and tables.● Involved in monitoring and deployment of SSIS packages across dev., uat, and production environments using dtexec utility, command prompt with .bat files etc.● Involved in installation, configuration, maintenance, deployment and troubleshooting SSRS reports.● Created complex reports like table report, matrix report, cascading report, sub reports, drill down, drill through and chart reports using complex data set queries, stored procedures, views in SSRS 2005/2008.● Performed daily DBA activities, security assignment, user setup, backup, restore and job monitoring on MS SQL Server.