Sql Server Data

Vishal Reddy Katta *************@*****.*** Mobile: 413-***-****

PROFESSIONAL SUMMARY

* ***** ** ** ********** on Application Development and Business Intelligence Analytics in various domains like Pharmaceutical, Transportation, Energy Solutions etc. 3 years of experience in Designing and Development of Business intelligence application with QlikView 11.x, 12.x as BI tool.

Experience in IT Software Development Life cycle involving Business Requirement Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing and Database Business Systems.

Strong knowledge in using sheet objects of QlikView like List Boxes, Multi Boxes, Tables, Charts, Current Selection Boxes, Buttons and experience in editing scripts for creating variables, fields, and calculated expressions, basic and aggregated functions.

Extensive knowledge on QlikView Enterprise Management Console (QEMC), QlikView Publisher, QlikView Web Server, QlikView Extensions.

Expertise on database such as creation of data models, Star schema, snowflake schema, users and their security access levels.

Design of QlikView applications using QlikView Data (QVD) files, different Databases and creating reusable variables.

Trained the end users effectively to use the reporting tool (QlikView), to build and customize their ad-hoc reports.

Having proven abilities in development, design, testing and production support for successful execution of projects on Qlikview.

Extensively worked with SQL Queries, and capable of handling Oracle, SQL Server, MS Access databases.

Strong in SQL and PL/SQL Database programming - development of stored procedures, cursors, triggers & Views.

Expertise in OLTP/OLAP System Study, Slowly Changing Dimensions types (SCD'S) Analysis and E-R modeling, developing Database Schemas like Star flake schema and Snowflake schema used in relational, dimensional and multidimensional modeling.

Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in-group as well as independently.

Knowledge of industry best practices in both business management and technology domains.

Expertise in designing, developing and executing Tests Cases based on business requirements.

Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back-end testing.

Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in-group as well as independently.

Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports.

Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services.

Excellent communication, presentation and interpersonal skills.

Designing and Developing Web forms using C#, ASP.Net 3.5, HTML, XML, LINQ, WCF, java script, Ajax Tool kit, and silver light.

TECHNICAL SKILLS

Operating Systems:

Windows 2000/03/08 Server, Windows 98/XP/NT/Vista/7

Databases:

MS SQL Server 10.0/7.0/2000/05/08/12

Languages:

T-SQL, PL/SQL, C, C#, VS 2005/08, ASP.net 3.5.

SQL Server Tools:

Management Studio, Business Intelligence Development Studio, Visual Studio 2005/08/10, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DTS, Log Shipping, SSIS, SSRS

Report Tools:

MS Reporting Services, Report Builder

Data Migration:

MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard

Database Modeling & Other Tools:

SQL Compare, SQL Trace

Dash boarding/Analytics:

QlikView 10.x/11.x,12.x QMC/QEMC

PROFESSIONAL EXPERIENCE

Client: Rackspace Hosting March 2016- Till Date

Location: San Antonio, Texas

Role: Sr. QlikView Administrator

Knowledge of industry best practices in both business management and technology domains.

Adept at solving complex problems through a systematic approach that uses innovation and partnering, combined with project management principles to maximize return on investment.

Experienced in QlikView Server and Publisher maintenance – Creating scheduled jobs for QVD extracts and report reloads.

Good presentation, summarization, structuring and refinement skills. Proven track record of execution capabilities for strategic as well as tactical plans, both within and through functional boundaries.

Worked as a QlikView Technical Consultant for a wide variety of business applications.

Experience in complete project life cycle including documentation, analysis, and development and testing.

Installed QlickView 12.0 SR5 in both publisher and server.

Extensive experience in handling Internet Information Server (IIS), Creating and configuring the virtual directories, map them to physical folders and configuration of the applications for domain authentication.

Worked closing with windows team by troubleshooting the IIS Configuration and worked with the server manger logs. In addition, Implemented New technique for restarting the Qlikview server service when it generates an error with event ID-0.

Got good experience handling both onsite and offshore teams by assigning them with the To-Do list and organizing the team with daily scheduled call on the progress of the tasks assigned.

Always worked in close association with customers and a single point of contact for many major implementation projects.

IT industry experience in Insurance, Internet Security, Manufacturing, Supply-Chain Management

Worked with 40 core processors with two 1TB RAM server and two 512GB RAM servers, having monthly refresh.

Was actively in the Server migration and the Fresh QlikView Installation process.

Multiple tier of QVD architecture is implemented depending upon the complexity of the application and the final application reload duration was 4 Hours.

The application is used by 66 Named CALs and 30 Document CALs and 120 session CALs licensed users with additional session licensed users as needed.

Task set up are done using QEMC and created architecture for the interdependent applications and execute in proper order.

Ad-hoc excel reports are created based on the business user requirements.

Forecasting model is created by using booking, revenue applications, created 4-year Forecast model, and successfully implemented in QlikView.

Worked with QlikView 10.x, 11.x,12.x SQL Server, TeraData, Excel, CSV files.

Worked with Nprinting Reports/Tasks/Schedules in 16.3.03x and 17.0.0

Client: CSL Behring Aug 2014 to March 2016

Location: King of Prussia, Pennsylvania

Role: Sr. QlikView Consultant

Responsibilities:

Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.

This Project is related to marketing analytics, concern about the marketing of various products and accepted pattern of the customers.

Leading team of 4 Member, which includes two offshore Qlikview developers, one Database Admin.

Providing executives and operational users with powerful analytic capabilities and detailed information on their operational and marketing performance.

The Process was Agile and strict time line oriented. Worked closely with Project manager and scrum master.

Created PDF push reports based on ‘loop and reduce’. Alternatively, wrote VB scripts to perform the same (based on requirement of user). Monthly distributed to specific user group via email, through publisher.

Extracted data from multiple complex hierarchies from cross table flat files and websites.

Created Heat map with alert mechanism. Various KPI graphs were drawn. Kept eye on Qlikview best practices.

Worked with 32-core processor with 200GB RAM server, having daily refresh.

The application is used by 20 CAL licensed user, with additional session licensed users.

Document event trigger and field event triggers is created. Incremental reloading is implemented

Four dashboards were created, along with helping other team to create Qlikview reports.

Successfully passed through the QA Environment and implemented on Production and currently working as post production support.

Worked with QlikView 10.x and 11.x, SQL Server, Oracle, Excel, CSV files.

Environment: SQL Server 2005/08/12, IBM DB2, Windows 2003/08/08R2 Servers, T-SQL, PL/SQL Developer Tool. Qlikview10, 11.x, MS Office 2010/2013, QV NPrinting 16.0

Client: AstraZeneca Jan 2013 - Jul 2014

Location: New York

Role: QlikView Consultant

Responsibilities:

Analyzed the reporting requirements with the business users and came up with the technical specifications.

Extracted data from different systems transformed and integrated in the QlikView.

Developed a standard/optimized theme which is further used across the system.

Extensively used set analysis to calculate/aggregate the fact data as per the requirements.

Developed QlikView Dashboards using Charts (Straight table, pivot table, Line, combo Chart etc.), List Boxes, Multi Box, Input Field, Table Box, Statistics Box etc.

Resolved synthetic keys using various techniques such as aliasing, join, concatenation, dropping fields, etc.

Done metadata management by implementing the governance Dashboard.

Extensively done business user support, resolved various issues for accessing dashboard and enhanced the dashboard as per user needs.

Conducted various meetings and conferences with application teams to meet corporate milestones for dashboard design, planning issues met as well as testing and training.

Designed and implemented the Incremental Load using QVDs.

Implemented the 3-tier architecture, Data Extract, Data transform and Data model & Application. Data Extract would load the Data from the data sources into the QVDs. Data transform will transform the data and Application layer is User Interface Design layer where we layout all our Charts, Tables and List Boxes.

Extensively implemented section access for row, object, column and sheet level security.

Developed Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.

Extensively worked on performance (DB, Design and UI level) for fast response of the application/dashboard based on the end user selection.

Participating in pre-sales activity working with prospective client and assisting with technical contributions to help my employer win new business.

Self-starter & Team Player with pleasing personality

Ad hoc excel reports are created based on the business user requirements.

Worked with Qlikview 11.x, SQL Server, Oracle, Excel, CSV, Qvd, Qvw files.

Environment: SQL Server 2005/08/12, Windows 2003/08/08R2 Servers, T-SQL, PL/SQL Developer Tool Qlikview 11.x, MS Office 2010, QMC.

Client: GE Transportation Jan 2011 - Dec 2012

Location: Philadelphia

Role: SQL Developer/QlikView

Responsibilities:

Involved in Data Migration from legacy to master using DTS-import and Export wizard.

Created views to facilitate easy user interface implementation, and triggers to enforce Data and referential integrity.

Created indexed views in T-SQL to increase the query performance.

Develop Backup & Restore scripts for SQL server as needed.

Created reports using SQL Server Reporting services.

Has done DBCC checks to ensure the physical consistency of the database and objects.

Checking Space monitoring, Index Defrag, Update Statistics, Log Shipping between Primary production servers and Standby

Created static reports using straight tables and pivot tables with spark lines and mini charts.

Created Variables and to enhance the functionality of Qlikview.

Develop and test BI Dashboards for utilization by key decision makers

Performed different tasks such as repeat tasks, reload tasks and distribution tasks using the Qlikview publisher.

Environment: Windows 2003 server, VB6.0, XML, SQL Server 2005, T-SQL, SQL Server Reporting services, QlikView 11.x

Client: GE- Digital Energy Jan 2010 - Sep 2010

Location: Hyderabad, India

Role: SQL Developer/DBA

Responsibilities:

Installation and configuration of SQL Server 2008.

Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.

Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.

Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Experience in developing Database Schemas / Stored Procedures / Data Dictionary.

Experience and knowledge in designing and developing data visualization strategies.

Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.

Demonstrated experience in utilizing design tools, development tools, code management, regression testing and performance tuning.

Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Production.

Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.

Experience in using XMLA protocol for SQL Server Analysis Services2005 for interaction between client application and instance of Analysis Services.

Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub Reports using Sql Server Reporting Services 2008.

Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.

Involved in Migration of SSRS 2005 to SSRS 2008.

Environment: MS SQL Server 2000/2005/2008, MS Access, Oracle 9i, Windows 2000/2003, VB.NET, XML, SQL Profiler, UNIX and Crystal reports.

CERTIFICATIONS

Pursuing QlikView Certification

EDUCATION

Bachelor of Engineering (Computer Science) from Jawaharlal Nehru Technological University, India – 2010

Contact this candidate