PROFESSIONAL SUMMARY:

• Over 7+ years of extensive experience in the IT industry as a MS SQL Developer/BI Developer, Qlikview Developer.
• Extensively worked in various domains verticals such as Hospitality, Healthcare, Insurance, Finance, Banking etc.
• Experienced in RBMS Concepts, Database Management Systems, and Database Physical and Logical design& Data Modeling and good knowledge of software development life cycle.
• Highly proficient in the use of SQL Server and T - SQL in constructing triggers, tables, user functions, Stored Procedures, views, indexes, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in tuning the performance of database and queries by creating indexes, views.
• Highly proficient in high level design of ETL SSIS/DTS packages for integrating data from heterogeneous sources (Excel, Xml, Oracle, flat file, Text Format Data) to MS SQL Server.
• Experienced in deploying and enhancing the SSIS Packages from development server to production server.
• Expertise in working with Data Warehousing, Data Modeling(star schema and snow schema) and business intelligence toolsfor developing various reports usingSSRS/QlikView.
• Expertise in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, compiling and testing.
• Excellent knowledge in Implementation of Relational Database (OLTP), Data warehousing systems (OLAP) and Data Marts.
• Expertise in Creating Dashboards using QlikView 11.0 using different data sources like DB2,Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per the user requirement
• Strong working knowledge of QlikView scripting, Set analysis, aggregation functions, multi-dimensional objects and layout including chart properties and formats, Fast Change and other objects for Management Dashboard Reporting.
• Strong knowledge in basic components of QlikView Enterprise like List Boxes, Multi Boxes, Tables, Charts, Current Selection Boxes, Buttons, Containers etc.. And experience in editing scripts for creating variables, fields, and calculated expressions, basic and aggregated functions.
• Experience in optimizing existing QlikView reports with a focus on usability, performance, flexibility, testability, and standardization.
• Develop 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.
• Proven ability to work effectively in a team environment and capable of learning new technologies and adapting to a new environment quickly.
• Involved in scheduling the dashboard in the Qlikview Management Console (QMC) and added the users and users groups to the distribution list.
• Ability to work in tight schedules with high quality and efficient in meeting deadlines.
• Proven ability to work effectively in a team environment and capable of learning new technologies and adapting to a new environment quickly.
• 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, interpersonal, intuitive, analysis and leadership skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2008 Server, Windows NT / XP, UNIX, Z/OS,OS/390

Databases / RDBMS: DB2,TERADATA,Oracle 9i, 10g, MS SQL Server, PL/SQL

Reporting Tools: Qlikview 11,Business Objects XI R2, XI3.1,SSRS

ETL: Informatica, SSIS

Tools: & Utilities: TOAD, SQL plus

Others: COBOL, SAS, EZYTRIEVE, MQSERIES,XML,JCL

PROFESSIONAL EXPERIENCE:

Confidential -Birmingham,Al

QlikView/ BI Developer

Responsibilities:

• Designed Frontend objects like Line, Bar, Pie, Straight, Pivot Tables and other sheets objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Kept an active participation in business requirement and design review session as well as kept a close interaction with other developers/designers
• Pulled data from multiple databases and build a data model by removing circular loops and synthetic tables.
• Created different publisher tasks like reload tasks, reduction tasks and distribution tasks using QlikView Management Console
• Wrote SQL Scripts with preceding Loads to extract relevant data in QlikView Applications.
• Performed analytics as per the requirement using advanced charts and tables.
• Designed graphs and visuals to summarize data, identify outlying data points, and perform other exploratory data analysis.
• Used appropriate functions like Apply Map, Resident Load, Concatenate, Variables and so on.
• Extensively worked with advanced scripting, set analysis, VBScript, as well as advanced aggregation functions
• Used functions Date and Time, Keep, Join, Mapping, and String & input Fields etc.
• Created User Conditions and Filters to improve application user experience
• Effectively identified and troubleshot any technical issues.

Environment: MS SQL Server 2012, MS SQL Reporting Services 2012,QlikView 11, Oracle 9i, Flat files, MS Excel, Windows 8

Confidential - Dallas, TX

BI / QlikView Developer

Responsibilities:

• Designed and developed QlikView software applications and server-based QlikView dashboards from scratch to support BI initiatives
• Created mock-ups showing the intended functionality, visual aspects of the dashboards to be developed
• Extensively worked with Set Analysis.
• Assisted in server maintenance and upgrades
• Used to Submit Weekly and Monthly Status Reports to higher management
• Created automatic schedulers to reload the data as per requirements.
• Created Set Analysis for Comparison analysis eliminating additional complex coding.
• Designed and developed the incremental loads strategy where applicable.
• Maintained both File and Data Level Security and implemented Data Reduction.
• Created different complex sheets and sheet objects based on client requirements.
• Created List boxes, Statistic boxes, bar charts, pie charts, Pivot Table, Combo Chart etc. to show the statistics of the sales held on different products in different years.
• Maintained user guides and documentation for QlikView applications
• Participated in Scrum stand up meetings.
• Assisted in server related tasks like service restarts, upgrades and troubleshooting.

Environment:Business Intelligence Development Studio, QlikView 11, SQL server, Access DB, SQL developer.

Confidential - St. Louis, MO

QlikView/ BI Developer

Responsibilities:

• Developed a procedure that helped the Application where the customer reside whether in Transactional data Storage (OLTP) or had stored in the Historical Data Storage based on the business logic customers are needed to pullback in the Transactional data storage for the business.
• Worked with development teams in the design of physical databases and in modification.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Drillthrough and Sub-Reports using ReportDesigner and ReportBuilder based on the business requirements.
• Project requirement gathering, coordination with business analyst and pre sales teams
• Involved in designing of Qlikview solutions&full lifecycle implementations
• Implemented the QVW files in a 3 tier architecture by loading the data from various external data sources thereby creating optimized QVD’s and then building applications using transformed QVD’s
• Develop efficient Qlikviewdata models using flat files, SQL 2008, MS access and Oracle
• Setting up of tasks, reloading data and refreshing the applications on a scheduled basis using Qlikview Management Console
• Developed Qlikview Dashboards which comprises various charts,Objects,Drill down & Cyclic grouping, Alerts,Variables,Input boxes, Calendar & macros
• Experience in using Qlikview functions (AGGR,PICK,MATCH,Date and time,Keep,Join,Mapping)
• Experienced incremental loading,PDF report generation and auto emailing of reports
• Extensive use of SET analysis expressions in charts and shown the critical KPI’s in gauge charts
• Implemented security and involved in deployment of Qlikview applications,used windows scheduler,batch files for refreshing QVD and QVW
• Utilized QlikViewPublisher andQlikViewServer capabilities though QEMC tool

Environment: SQL Server Qlikview10/11, QEMC,Oracle,, Toad 9.6.1/SQL Developer, SQL Loader and Windows 2007.

Confidential, Lynchburg, VA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple T-SQL queries.
• Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
• Designed Monitoring and Tuning Report performance by analyzing the execution plan of the report.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Managed extract, transform, and load data into the repository and Created Complex Stored procedure, Functions, Views, and Indexes for the Logic package.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers

Environment: SQL Server 2008, SQL BI Suite (SSIS, SSRS),, MS Office Suite 2003 (Word, Excel, Access, PowerPoint and Outlook), SSIS 2008, SSRS 2008.

Confidential, Flemington Hills, MI

SQL Server Developer, SSRS/ SSIS Developer

Responsibilities:

• Create User Defined Functions, Stored Procedures, and Triggers.
• Performed data conversions from Flat filesinto a normalized database structure.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
• Experience in collecting the user requirements and documenting by creating the use case and flow activity diagrams
• Responsible for creating constraints, Indexes, and Views.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Created triggers, views, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Managed upgradation ofDTS packages to SSIS packages.
• Identified and worked with Parameters for parameterized reports in SSRS.
• Used Database Maintenance Wizard to make necessary changes and to keep the performance of the server at acceptable levels.
• Configured Server for sending automatic mails to when a DTS process fails or succeeds.
• Transformed data from various data sources using DTS packages.
• Created Crystal Reports on daily, weekly and monthly basis for manager’s review.
• Responsible for MS SQL Server 2008in Production, Test, Development and Replication&Cluster Server Environments

Environment: SQL Server 2008, SQL BI Suite (SSIS, SSRS), Windows 2000 Advance Server, Windows 2003 Server, XML, T-SQL, MS Excel, MS Access,VB.NET 3.0 and DTS.

Confidential, Indianapolis, IN

SQL Server Developer

Responsibilities:

• Worked on various tasks of SSIS like Transform Data Task, Execute SQL Task, and Bulk Insert Task etc.
• Deployed reports to Report Manager and Troubleshooting for any errors during the execution.
• Experience in Performance analysis using index tuning, Query optimizer, Query Execution plan.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Created Indexes to increase the performance.
• Performed migration and data transformation from existing database to the new implemented database structure using SSIS.
• Created numerous complex stored procedures and T- SQL scripts involving self joins, subqueries techniques for diverse business requirements.
• Developed robust stored procedures and triggers to implement IRB patient approvals for researchers and senior management notification purpose.
• Used SQL Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary
• Managed historical data from various heterogeneous data sources (i.e. Excel, Access, text files).

Environment: SQL Server 2008 R2, SQL BI Suite (SSIS, SSRS), MS Office 2007, MS Project, MS VISIO& Windows Server2003,MS SQL.