SUMMARY

• Over 7 years of experience in Analysis, Design, Development, Deployment in Business Intelligence and Data warehousing.
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member
• Worked in Agile environment and has knowledge 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 the 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 the life cycle development including feasibility studies, design and coding for large and medium business intelligence projects and continually provided value-added services to the clients.
• Excellent skills in the Set Analysis.
• Performed different types of loads Incremental Load, Optimized Load & Binary Load.
• Has worked on the Alternate states to do a comparative analysis. Transitioning from one application to another application using Transfer State.
• Worked on the complex requirements and also experienced in implementation of Macros in the Qlikview application.
• Excellent skills in Triggers to achieve event based requirements.
• Has strong knowledge in section access to implement data level and document level security.
• Has worked on Qlikview management console to schedule the tasks and trigger on batch execution.
• Has 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 Modeling

Operating 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 in corporate the Business requests.
• Understanding the business functionality & Analysis of business requirements.
• Creating mock up wif the sample data.
• Generated Reports using Global Variables, Expressions and Functions for the 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 the issues related to the end users
• Involved in Performance Tuning & Deployment of QlikView Applications
• Intense knowledge 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 City, 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 the 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 the 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 the 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 the 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 the users.
• Provide support analyst when internal teams has enquiries and trained business users.
• Research and troubleshoot technical problems and provided ongoingQlikViewconsultation to the development team.

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

Confidential, NYC, 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 the 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 the functionality of the 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 the test cases written for unit and integration level
• Integrating the test scripts written for individual units
• Writing Test scripts and functions wherever necessary for various units of the business modules
• Effective coordination between development team and testing team
• Writing RTMs before the test planning phaseAnalysis of the specifications provided by the users
• Generating reports using crystal reports
• Coding in C#
• Writing SQL Server database procedures, functions and triggers
• Responsible for overseeing the Quality procedures related to the 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 the specifications provided by the 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 the DTS packages to migrate the data from multiple sources to the client databases and created SSIS packages using the 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 the Quality procedures related to the 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