SUMMARY:

• Having 7 years of experience in System Analysis, Design, Functional and Business experience with accomplished process and project responsibility.
• As a QlikView/QlikSense & BI Developer, successfully justified the roles and responsibilities with detailed management and technical skills in full SDLC process.
• Extensive experience working on Lean, Agile & Waterfall techniques. Excellent capabilities to build strong relationship with business users, internal/external stakeholders and partner network.
• Extensive experience in test case design, bug tracking and defect triage.
• Expertise in QlikView, QlikSense, Microsoft SQL server, MSBI Tools (SSIS, SSRS, SSAS) and UNIX scripting.
• Worked with business groups and technical teams in analyzing large data sets.
• Responsible for scope of Data analysis, UAT Strategy formulation, review, approval & standardization in Enterprise Data warehouse.
•  Expertise in designing and developing QlikView and QlikSense dashboards, Reports and Analytical worksheets by extracting data from various sources like Sales Force, SQL Server, Oracle, SAP, Flat Files, Excel files, XML Files. 
• Experience in creating Data Extraction scripts for creating QVD's, QlikView/QlikSense Scripting variables, file, date, system, Mapping and Table functions.
• Optimizing worksheets by Query tuning and performance improvements in cases of QlikView load scripts by analyzing Subset ratio, Synthetic Keys etc.
• Extensive knowledge in Section Access, Set Analysis in QlikView and QlikSense. 
• Extensive experience in creating Pixel Perfect reports, Excel reports, Word reports, PowerPoint reports using NPrinting designer and automating the jobs in NPrinting Server.
• Created ETL packages (SSIS), OLAP cubes (SSAS), SQL scripting to develop data warehouse which is used by end users to analyze data.
• Responsible in reconcile data between source and destination systems for user analysis.
• Conducted UAT cases and reviews, resolving defects and develop user stories and tasks.
• Created and maintained data marts, ODS layers for enterprise level data warehousing sticking to all legal, privacy and affiliate mandate.
• Worked with architects to create data models and proposed feasible data models to satisfy business requirements.
• Expert in generating on - demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services, Crystal Reports and Excel spreadsheet.
• Experienced in developing SSAS projects which is used to create fast executed reports with history of data.
• Extensive experience in creating, maintaining, processing of cubes using SSAS.
• Good hands on creating calculated columns using MDX language.
• Improved SQL query performance in data warehouses using Execution plans and implementing indexes and optimizing query.
• Worked with admin teams and respective Server teams to improve the application and its system performance.
• Coordinated with Storage area network consultants for synchronizing master database copy with number of slave copy’s when the number of threshold users connects the databases at the same time.
• Migrating databases from one platform to another using third party tools.
• Writing scripts to execute batch jobs in Job Information Language to execute in Autosys.

TECHNICAL SKILLS:

Databases:  SQL Server 2008R2/2012,Tera Data, Oracle PL/SQL, IBM DB2,Big data Hive QL & Pig Latin, MS Access.

ETL:  Microsoft DTS, SQL Server Integration Services.

Reporting Tool:  QlikView, QlikSense, SQL Server Reporting Services, Cransoft Data Garage, Power BI.

OLAP:  SQL Server Analysis Services

Operating Systems:  Windows Server 2008 R2, Windows Server 2012, UNIX

Applications:  Erwin 3.5/4.1/7, Visual Studio 6.0/.NET/2005, 2008/2010/2012

Languages: C, C++, SQL, T-SQL, PL-SQL, Visual C#, Visual Basic, ASP.NET, R Language, Python

PROFESSIONAL EXPERIENCE

Confidential, NJ

QlikView & BI Developer

Responsibilities:

• Responsible for gathering, analyzing, evaluating of business needs into the framework of the new data infrastructure.
• Participated in discussions with business analysts, business stakeholders, Subject Matter Experts (SME), developers and other teams of the project in making strategies that would ensure all the business requirements reflect in the project development.
• Designing Data Models for extractions of source data, to make available of source tables for developing QlikView documents.
• Recommended the type of SCD strategies
• Developing ETL packages using SSIS to get data from open hub tables to develop a successful data warehouse of star and snowflake schema database which is used as open source to develop reports for analyzing data.
• Connected OLEDB data sources and flat files to create and schedule different complex reports in QlikView and QlikSense.
• Coding for Extracted large data sets from Source systems to analytical reporting systems using ETL packages.
• Developed T-SQL, QlikView Scripts for extraction, cleansing and transforming data sets.
• Developing load scripts and store the data as QVD by extracting data from SQL Server and designed the UI based on business/user requirements.
• Developed QlikView and QlikSense objects like Multi Boxes, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Combo charts, Scatter charts, Line objects, Pie charts, Button.
• Developed KPI dashboards, analytical/tabular/pivotal/parameterized reports in QlikView using set analysis expressions to provide custom functionality.
• Developed comparative analysis view using Alternate States.
• Developed calculated fields in QlikSense.
• Developed drill down Information by creating Groups/Cycles in QlikView.
• Performed Query tuning and performance improvements in cases of QlikView and QlikSense load scripts by analyzing Subset ratio, Synthetic Keys etc. Improved SQL query performance in data warehouses using Execution plans and implementing indexes and optimizing query.
• Conducted UAT cases and reviews, resolving defects and develop user stories and tasks.
• Developed and executing test scripts, and supporting existing production processes.
• Trained end users to develop ad use QlikView application.
• Worked with SAP ECC systems, SAP PI, SAP BW systems to reconcile the large data sets to the reporting systems.
• Converted data fields from antiquated databases structure to new database environment.

Environment: QlikView 11 SR2, QlikSense 2.0, SQL Server 2012, MS Data tools (SSIS, SSRS, SSAS).

Confidential

QlikView & BI Developer

Responsibilities:

• Gathering load files around 1 to 10 GB of data from different source systems.
• Developed ETL packages to load data from flat files to staging database and data Mart Layers. Worked with Incremental Loading that inputs into data ware house.
• Developed User defined functions, stored procedures, views on SQL server.
• Developed Load Scripts and re using scripts.
• Developed Variables, input boxes, extensively alerts and calendar.
• Developed Linked Tables, Concatenation (Resolving Loops & model ambiguity).
• Created Parameterized reports, Cross-Tab reports, Drill down reports using Qlik view.
• Developed reports which include Daily, Weekly, Monthly executable for analyzing data.
• Done performance tuning of the queries, run Unix scripts and responsible to move code between different Environments.
• Created complex expressions using Set analysis.
• Analyzed the existing QlikView data model and script logics for the existing QlikView applications.
• Maintained Warehouse Management System in tracking of stock balance, shipment details and tracking delivery in supply chain system.
• Provided support for data issues and given appropriate solutions.
• Responsible in reconcile data between source and destination systems for user analysis.
• Responsible for capacity planning, monitoring Disk I/O, CPU and memory.
• Maintained jobs, job steps and schedules.
• Implemented event handlers and error handling in ETL packages and notified process results to various user communities.

Environment: QlikView 9,SQL Server 2008R2, MSBI Stack 2008R2(SSIS,SSRS,SSAS).

Confidential

Back Office Associate & SQL Server Developer

Responsibilities:

• Developed DTS packages from SQL Legendary tasks on SQL Server Management Studio to load the data from flat files and Source tables into SQL databases
• Creating tables, reports and groups in Cransoft Data Garage.
• Scheduling reports to refresh and delivering to users using Cransoft Data Dialysis
• Working with Cransoft Interfaces to create work flows for table refresh
• Working with Cransoft teams on interfaces issues and any issues with Cransoft tools
• Implemented event handlers and error handling in DTS packages and notified process results to various user communities.