SUMMARY

• Over 9 years of IT experience on Application Development and Business Intelligence Analytics in various domains like Transportation, Aerospace, Heavy Earth movers, Energy Solutions etc. 3 years of experience in Designing and Development of Business intelligence application with QlikView 11.0/10.0 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
• Analyzed reporting requirements to usable long - term Dashboard and Reporting solutions, develop solutions as necessary.
• Strong noledge 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.
• Expertise in working with QlikView Desktop, QlikView Enterprise Management Console (QEMC), QlikView Publisher, QlikView Web Server, Qlikview Extensions.
• Expertise in Performance Tuning & Deployment of QlikView Applications.
• Extensively worked with SQL Queries, and capable of handling Oracle, SQL Server, MS Access databases and also have good experience in database tuning and performance techniques.
• Strong in SQL, T-SQL and PL/SQL Database programming - development of stored procedures, cursors, triggers & Views.
• Having proven abilities in development, design, testing and production support for successful execution of projects on Qlikview.
• Ability to work in tight schedules with high quality and efficient in meeting deadlines.
• 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.
• Excellent communication, presentation and interpersonal skills.
• Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling DTS and SSIS, SSAS, SSRS Packages.
• Design of QlikView applications using QlikView Data (QVD) files, different Databases and creating reusable variables.
• Trained teh end users effectively to use teh reporting tool (Qlikview), to build and customize their ad-hoc reports.
• Knowledge of industry best practices in both business management and technology domains.
• Expertise in designing, developing and executing Tests Cases and Test Scripts based on business requirements.
• Designing and Developing Web forms using C#, ASP.Net 3.5, HTML, XML, LINQ, WCF, java script, Ajax Tool kit, 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/2012

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, SSAS, 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

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Sr SQL Server BI\Qlikview Developer

Responsibilities:

• Analyzed teh reporting requirements with teh business users and came up with teh technical specifications.
• Actively participated in full life cycle of QlikView application implementation and was responsible for Design, Development and Delivery.
• Extracted data from different systems transformed and integrated in teh QlikView.
• Developed a standard/optimized theme which is further used across teh system.
• Extensively used set analysis to calculate/aggregate teh fact data as per teh 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 teh governance Dashboard.
• Extensively done business user support, resolved various issues for accessing dashboard and enhanced teh 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 teh Incremental Load using QVDs.
• Implemented teh 3-tier architecture, Data Extract, Data transform and Data model & Application. Data Extract would load teh Data from teh data sources into teh QVDs. Data transform will transform teh 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 teh application/dashboard based on teh end user selection.
• Migrated existing QlikView 10 dashboards to QlikView 11 environment, also added new QV11 features to teh Dashboards.
• Generated/Developed Reports based on SSRS, Report Builder, Qlikview
• Considerable Reporting and Dash Boarding (UI/UX Design) experience
• Participating in pre-sales activity working with prospective client and assisting with technical contributions to halp my employer win new business.
• Self-starter & Team Player with pleasing personality
• Ad hoc excel reports are created based on teh business user requirements.
• Having noledge of creating Extensions and generating Qar files.
• Worked with Qlikview 11.x, SQL Server, Excel, CSV, Qvd, Qvw, Qar files.

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

Confidential - Chicago, IL

Sr SQL Server BI Developer \ Qlikview Developer

Responsibilities:

• Analyzed teh reporting requirements with teh business users and came up with teh technical specifications.
• Extracted data from different systems transformed and integrated in teh QlikView.
• Designed teh Data-Model using data from various sources like Oracle 10g Database and flat files.
• Developed a standard/optimized theme which is further used across teh system.
• Extensively used set analysis to calculate/aggregate teh fact data as per teh 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.
• Done metadata management by implementing teh governance Dashboard.
• Conducted various meetings and conferences with application teams to meet corporate milestones for dashboard design, planning issues met as well as testing and training.
• Data Extract would load teh Data from teh data sources into teh QVDs. Data transform will transform teh data and Application layer is User Interface Design layer where we layout all our Charts, Tables and List Boxes.
• Developed Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Extensively worked on performance (DB, Design and UI level) for fast response of teh application/dashboard based on teh end user selection.
• Generated/Developed Reports based on SSRS, Report Builder, Qlikview
• Participating in pre-sales activity working with prospective client and assisting with technical contributions to halp my employer win new business.
• Worked with Qlikview 11.x, SQL Server, Excel, CSV files.

Environment: SQL Server 2005/08/12, T-SQL, SSIS, SSRS, Qlikview 11.x, MS Office 2010

Confidential, Jacksonville, FL

Sr SQL Server Developer/BI/SSIS/SSRS

Responsibilities:

• Work with business users, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Gather user requirements, analyze and design solutions.
• Support production operation activities with focus on integration and development of new and existing products and services.
• Write complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from teh database.
• Create/Update database objects like tables, views, stored procedures, function, and packages.
• Write T-SQL queries and Stored Procedures and Oracle and DB2 queries and use them to build SSIS packages.
• Rigorously test teh Stored Procedures, SSIS packages and SSRS reports; fix bugs.
• Involved in capacity planning, sizing and database growth projections.
• Scheduled Full and Transactional log backups for teh user created and system databases in teh production environment using teh Database Maintenance Plan Wizard.
• Setup backup and restoration jobs for development and QA environments
• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.
• Reviewed DB Scripts from teh development team before releasing them into teh Production.

Environment: Windows 2003 Server, SQL Server 2005,SSIS, SSRS,T-SQL, PL/SQL, JavaScript, MS IIS Server 5.0, SOAP, HTML/DHTML, XML

Confidential, Philadelphia, PA

SQL Server DBA/Developer

Responsibilities:

• Involved in Data Migration from legacy to master tables 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 teh query performance.
• Develop Backup & Restore scripts for SQL Server as needed.
• Created reports using SQL Server Reporting services.
• Has done DBCC checks to ensure teh physical consistency of teh database and objects.
• Checking Space monitoring, Index Defrag, Update Statistics, Log Shipping between Primary production servers and Standby.

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

Confidential, Peoria, IL

SQL Server DBA/Developer

Responsibilities:

• Creating and maintaining various databases for Production, Development and Testing use SQL Server 2005.
• Planning and scheduling backups and developing recovery procedures.
• Migration of data across different databases and different servers.
• Creating procedures, functions, and triggers, handling database performance and tuning.
• SQL Server Installation, patch application, migration of databases.
• Creation of new databases, planning teh location of data, index, and Transaction log files on disks.
• Setting up backups for teh Applications
• Providing support to teh Application developers on teh application databases.
• Handled 24/7 Production Issues.

Environment: MS Visual Studio 2005, SQL Server 2005, Windows 2003 Advance Server, Peregrine, Tortoise CVS.

Confidential - Jacksonville, FL

Responsibilities:

• Involved in creating Requirement Specification and teh architecture of teh solution
• Gathered requirements from teh business users, created technical specification documents.
• Database creation; database tuning, performance planning, backup planning and database administration.
• Transformed data from various data sources such as Excel and text files
• Designing and Developing Web forms using C#, ASP.Net 3.5, HTML, XML, LINQ, WCF, java script, Ajax Tool kit, silver light
• Designed and Developed teh .NET GUI for teh user interface using ASP.NET Web Forms.
• Used SQL Server 2005 database for data storage. Created tables, Reports and Queries
• Creation of various data objects like tables with constraints, added relationship, created stored procedures with cursors, added indexes using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Developed web pages with data bound controls like DataGrid, DataList and DataRepeater using teh methods Data Binding
• Created and developed global custom Client side scripts using Java Script, depending on teh requirements and DHTML Scripts, CSS (Cascading Style Sheet) for User Interface and Server side scripts from Server side Validations.
• Have to use Ajax Controls for teh Partial Page Refresh extensively.
• Troubleshooting teh application in production environment without scarifying teh uptime and services.
• Code Review, Unit testing, Debugging and Integration testing of teh application. Also analyzed teh business and design teh screen flow of teh application.
• Involved in to publishing & deploying teh application. Creating end user documents.
• Involved in Developing ASP.NET Web Services using C#.NET as per teh client requirements.

Environment: C#, MS - SQL Server 2005, ASP. Net 3.5, IIS, ADO.Net 3.5, VSS, Visual Studio 2003/2008, Windows XP, Excel, MS Word

Confidential

SQL Server DBA/Developer

Responsibilities:

• Installation, configuration and maintenance of teh MS SQL Server 2000.
• Migration of SQL server 6.5 to 7 and from SQL server 7 to 2000.
• Performance and tuning of SQL servers and application issues related to migration.
• Testing of applications for performance, data integrity and validation issues.
• Data Transfers between various servers using BCP and Managing Disk space on NT systems.
• Migrated oracle8i data into SQL Server 2000.
• Scripting teh Database Consistency Checks (DBCC), scheduling teh scripts to run daily and weekly basis.
• Complete automating on NT so that teh tasks are run without user monitoring.
• Writing teh stored procedures, checking teh code for efficiency. Routine backups and restoration.
• Administrative and Production support for various applications in all environments.
• Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.

Environment: SQL Server 2000, SQL server 7, SQL server 6.5, T-SQL, Oracle PL/SQL, Query Analyzer, SQL Profiler, Windows 2000 Server, Import & Export Data, TOAD.