SUMMARY

• Over 7 years of experience in Analysis, Design, Development, Deployment in Business Intelligence and Data warehousing.
• As part of teh team, extensively involved through teh Software Development Life Cycle (SDLC) from initial planning through implementation of teh projects. Capable of handling responsibilities independently as well as a proactive team member
• Worked in Agile environment and have noledge on scrum.
• Experience in developing complex stored procedures, efficient triggers, required functions, creating indexes and indexed views for performance
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging
• Expertise in TSQL - DDL/DML/TCL/DCL, perform most of teh SQL Server Management Studio functionality using T-SQL Scripts.
• Experience in report designing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading parameterized, and drill through, Table, Matrix, ad-hoc and Sub Reports
• 3+ years of experience as a Qlikview Developer.
• Involved wif every phase of teh life cycle development including feasibility studies, design and coding for large and medium business intelligence projects and continually provided value-added services to teh clients.
• Excellent skills in teh Set Analysis.
• Performed different types of loads Incremental Load, Optimized Load & Binary Load.
• Have worked on teh Alternate states to do a comparative analysis. Transitioning from one application to another application using Transfer State.
• Worked on teh complex requirements and also experienced in implementation of Macros in teh Qlikview application.
• Excellent skills in Triggers to achieve event based requirements.
• Have strong noledge in section access to implement data level and document level security.
• Have worked on Qlikview management console to schedule teh tasks and trigger on batch execution.
• Have implemented maps using extensions in Qlikview.
• Excellent skill in writing/debugging/fine tuning SQL queries.
• Experience wif dashboard development, Business Intelligence, KPI Development, Data Loading/Migration.
• Designed data models for QlikView and development of UI for dashboards.
• Created complex reports by linking data from various data sources.
• Experience in writing stored procedures and functions (PL/SQL).
• Analyzed Script to eliminate synthetic keys and circular loops.
• Implemented database schemas including Star schema and Snowflake schema used in relational and dimensional modeling.

TECHNICAL SKILLS

Tools & Technologies: Qlikview 11 Developer Console, Qlikview Management Console, Qlikview Access Point, SSIS,SSRS

Languages: SQL, T-SQL, PL/SQL, C#, C, C++

RDBMS: DB2,Oracle, SQL Server

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data ModelingOperating systems: Windows7/XP/Vista, Windows 2000/2003/2008 Server, Linux, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Dublin, Ohio

Qlik view Developer

Responsibilities:

• Requirements gathering, Impact Analysis and solution designing to incorporate teh Business requests.
• Understanding teh business functionality & Analysis of business requirements.
• Creating mock up wif teh sample data.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Assist wif schema design and development of ETL processes.
• Collaborated wif Business Leaders to share and gather QlikView Planning requirements
• Implemented Star Schema & Snow Flake for Dimensional Data Modeling in QlikView
• Created user interface reports using QlikView sheet objects like List Box, Input Box, Buttons, Text Input, Slider, Bookmarks, Charts (Pivot/Straight tables, Pie, Bar, Line etc.)
• Created QVDs and developed Dashboard style of reports as per business needs
• Developed extensively Variables, Input boxes, Triggers, Macros
• Created Set Analysis for Comparison analysis eliminating additional complex coding
• Wrote SQL Scripts to load relevant data in QlikView Applications
• Created and schedules tasks for reloading and distribution of Data in QlikView Publisher
• Automated jobs in Publisher & rolled out to QlikView Access point & maintained security
• Gathered & loaded data into QlikView from various sources of data like SQL SERVER 2005, Oracle 10g, .CSV and excel files
• Maintained both File and Data Level Security and implemented Data Reduction
• Used to train and solve teh issues related to teh end users
• Involved in Performance Tuning & Deployment of QlikView Applications
• Intense noledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Management Console

Environment: QlikView 9.0, QlikView Server 9, QlikView Enterprise Management Console, SQL Server 2005, Windows Server 2003, Salesforce (.d11 adaptor), Oracle 10g, SQL Scripting

Confidential, Foster, CA

Qlik View Developer

Responsibilities:

• Involved in business requirement gathering and development of functional and technical specification documents.
• Developed different dashboard wif a complex database system behind it, which includes extracting data from teh database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging teh basic components ofQlikView.
• Performed subsequent alterations using SQL to make any changes on adhoc requirements.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using theQlikView publisher.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents usingQlikView Publisher and notified load status by email.
• Maintained and administered source documents, source documents sets, and user profiles and executed resource management services like Access point resources, distribution folders and email servers. Monitor user access to manage teh limited number of licenses.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in teh front-end, improving layout structure.
• Enhance existing dashboards wif new functionalities and Tune ETL scripts for better performance.
• Build reusable macros to controlQlikView objects for ease of use by teh users.
• Provide support analyst when internal teams have enquiries and trained business users.
• Research and troubleshoot technical problems and provided ongoingQlikViewconsultation to teh development team.

Environment: Qlikview, Excel (Pivot Tables, VLookups), Microsoft SQL Server 2008 and 2012, Operating Systems: Linux and Windows.

Confidential, NY

SQL Server Developer

Responsibilities:

• Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SSIS.
• DDL Scripts for generating Tables, Views, Functions.
• Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Performance tuning, query optimization and execution plan of queries for better performance.
• Configured IIS and Deployed Reports and Analysis Project in to server
• Extended Data to XML and Excel Spread Sheet
• Developed reports using SSRS 2005 and Crystal reports, used table control, matrix control for cross tab reports
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder
• Managed existing indexes in ROLAP to optimize teh performance of reports accessing it as well as all other BI applications
• Scheduling Jobs, Backups and Restore database
• Assisted end users in UAT, by explain all teh functionality of teh data warehouse and its applications.
• Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing
• Writing and testing stored procedures

Environment: Visual Studio 2005, SQL Server Management Studio, T-SQL Stored Procedures, SQL Server reporting services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Crystal Reports, Office, Excel.

Confidential

System Analyst

Responsibilities:

• Developing test plan and test strategy
• Review of teh test cases written for unit and integration level
• Integrating teh test scripts written for individual units
• Writing Test scripts and functions wherever necessary for various units of teh business modules
• Effective coordination between development team and testing team
• Writing RTMs before teh test planning phaseAnalysis of teh specifications provided by teh users
• Generating reports using crystal reports
• Coding in C#
• Writing SQL Server database procedures, functions and triggers
• Responsible for overseeing teh Quality procedures related to teh project

Environment: C#.Net, Windows 2000 operating system, Microsoft SQL Server 2000 server, Microsoft Excel, Microsoft Word,Visual Source Safe

Confidential

Software engineer

Responsibilities:

• Analysis of teh specifications provided by teh capital road lines users
• Actively involved in Normalization of database.
• Designed DDL and DML for MS SQL Server 2005.
• Creating tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Create joins and sub-queries for complex queries involving multiple tables.
• Worked on SQL/T-SQL Queries and Stored Procedures in an effective way.
• Optimizing query performance by creating indexes and involved in writing SQL batch scripts.
• Design & Develop of front end screens using VB
• Generating reports using crystal reports
• Worked on creating teh DTS packages to migrate teh data from multiple sources to teh client databases and created SSIS packages using teh transformations like lookup transformation, multicast transformation etc…
• Created tabular and matrix reports using SSRS.
• Writing SQL queries to use in reports, and application development
• Writing SQL queries and generating manual reports on Ad hoc requirements
• Unit testing & integration testing
• Responsible for overseeing teh Quality procedures related to teh project

Environment: Windows 2000 operating system, MS SQL Server 2000/2005, DTS, SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS), Microsoft Excel, Microsoft Word, Visual Source Safe