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 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.
• 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 the end users effectively to use the 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 the reporting requirements with the business users and came up with the 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 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.
• Migrated existing QlikView 10 dashboards to QlikView 11 environment, also added new QV11 features to the 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 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.
• Having knowledge 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 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.
• Designed the Data-Model using data from various sources like Oracle 10g Database and flat files.
• 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.
• Done metadata management by implementing the 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 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.
• 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.
• Generated/Developed Reports based on SSRS, Report Builder, Qlikview
• Participating in pre-sales activity working with prospective client and assisting with technical contributions to help 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 the 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 the 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 the user created and system databases in the production environment using the 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 the development team before releasing them into the 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 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.

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 the location of data, index, and Transaction log files on disks.
• Setting up backups for the Applications
• Providing support to the Application developers on the 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 the architecture of the solution
• Gathered requirements from the 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 the .NET GUI for the 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 the methods Data Binding
• Created and developed global custom Client side scripts using Java Script, depending on the 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 the Partial Page Refresh extensively.
• Troubleshooting the application in production environment without scarifying the uptime and services.
• Code Review, Unit testing, Debugging and Integration testing of the application. Also analyzed the business and design the screen flow of the application.
• Involved in to publishing & deploying the application. Creating end user documents.
• Involved in Developing ASP.NET Web Services using C#.NET as per the 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 the 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 the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Complete automating on NT so that the tasks are run without user monitoring.
• Writing the stored procedures, checking the 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.