SUMMARY:

• Overall fourteen years of experience in IT industry with strong backround in analysis, design and development in the field of database, data warehouse, data modeling and implementation of qlikview/qlik sense for BI applications.
• Having proven abilities in development, design, testing and production support for successful execution of projects on qlikview architecture.
• Played as a team lead providing direction to members of the development team.
• Also worked with ETL, data warehouse and infrastructure teams.

TECHNICAL SKILLS:

BI Tools: QlikView 9/10/11, Qlik Sense, SSAS Other BI Tool Cognos (familiar), Business objects

ETL: SSIS, Informatica (),Database SQL SERVER, Amazon Cloud, Oracle

Languages: SQL, C#, ASP.Net, Visual Basic. Net, HTML, VB Script Data Modeling Microsoft Visio

Operating Systems: Windows XP/NT/ 2000/2003/2008 , OS2/400 Additional Skills ITIL (foundation), Visual Studio 2005/2008, Development Studio, Data Analysis, Crystal Reports V6

PROFESSIONAL EXPERIENCE:

Confidential, Racine, WI

Senior BI Developer / Analyst

Responsibilities:

• Gathering requirements from Users and analyzing the data by querying the data sources such as Tables, views etc.
• Good working knowledge in relational data modeling and dimensional data modeling.
• Handled the large datasets, used incremental load to manage large files.
• Developed highly informative dashboards usingqlikview objects like listboxes, multiboxes, tables, charts, current selection boxes, buttons and variables, fields, calculated expressions, basic and aggregated functions.
• Involved inqlikview administration, installation and upgrading theqlikview server and publisher.
• Extracted the data from the different sources and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Analyzed the inventory and forecast data for supply chain team and architected VBA applications for data transfers and data processing between access databases.
• Developed access / excel reports with sql scripts.
• Used tools such as qlikview 11.2, SQL Server 2008R2, VB.NET, MS Access, VBA

Confidential, Lake Forest, Illinois

Senior BI Analyst

Responsibilities:

• Enhanced the global daily sales qlikview application and Achieve - IQ an opportunity assessment tool.
• These tools are used to increase sales and measure the potential sales opportunity utilizing data from SAP BW and salesforce.com
• Scheduled the jobs using qlikview management console and monitored the ETL jobs in Autosys.
• Managed team of developers and analysts involved in development and maintenance of global daily sales report qlikview application. Planned and managed allocation of resources, planning, and execution of project schedules.
• Experience in installing and setting up third party SAP connector.
• Analyzed and validated BI dashboard applications during the development process with vlookup to do the unit test.
• Conducted sessions to business on how to leverage the self-service capabilities.
• Provided support in troubleshooting and analysis of incidents, service requests, and change requests for multiple applications.
• Familiar in Qlik Sense Story Telling, Smart Data Associations, PivotTable and KPI Object.
• Used tools such as qlikview 11.2, SAP connector for qlikview, Sql server, business objects 4.0, Salesforce.com

Confidential, Chicago, Illinois

QlikView Developer

Responsibilities:

• Developed, maintained, and enhanced several applications in QlikView 11 and Teradata.
• Created dashboards such as browser reporting, browser reporting operator usage, browser reporting host usage, activation report.
• Achieved measurement of KPIs and metrics of Marketing Analytics.
• Combined data sources QVD files, Excel, binary QVW, inline, and txt files in developing QlikView data models.
• Developed SQL Scripts to load relevant data in QlikView Applications. Created Macros and Set analysis in Qlikview applications.
• Worked with tools such as Teradata, Teradata SQL Assistant, QlikView 11.

Confidential, Detroit, Michigan

QlikView Developer

Responsibilities:

• Handled the large set of Data, Used incremental load to the table size of 500 Million rows.
• Developed application enabling manufacturers and logistics providers to quickly adapt to changing market demands and satisfy customer needs.
• Performed validations of Qlikview application at base level against QVDs and Excel test files.
• Managed scheduling of different publisher tasks like reload, reduction, and distribution tasks using QEMC.
• Utilized tool such as QlikView 10, DB2, QEMC, MS Excel, .CSV Files, and Power pivot.
• Developed application enabling product planners to improve efficiency, increase productivity, and design/plan with greater accuracy.
• Delivered dashboard required for product development team using 50% of the projected time and 25% of estimated resources. This enabled the product development team in improving efficiency, increasing productivity and design accuracy.
• Performed business and data analysis on data not included in prior reports and presented proposal for new reports.
• Installed IE plug-ins, created macros to navigate between sheets and charts using buttons.

Confidential, Schaumburg, Illinois

Qlikview Associate Consultant

Responsibilities:

• Obtained Qlikview through, exam, project, and viva/project demo of completed project.
• Worked as intern at Qliktech Partner Company on internal projects involving consultant marketing analysis. Utilized tools such as Qlikview 9, AS/400.

Confidential, Pittsburgh, PA

Senior Programmer Analyst

Responsibilities:

• Architected intranet application to generate quality control documents from database.
• Designed and developed scanner-based software application using Visual Basic to expedite data entry process.
• Utilized tools such as SQL Server, ASP.NET, VB.NET, .NET Framework 3.5, 2.0, Visual Studio 2005/2008, and Crystal Reports.

Confidential, Schaumburg, Illinois

Application Developer

Responsibilities:

• Planned, coordinated testing effort and performed hands-on testing activities for customized tools and functions of packaged software, Intelec provided by Quantrax used by collection agency. Utilized tools AS/400, RPGIII, CL, and AS/400 system administration.