Professional Summary:
Around *+ years of experience in IT industry with strong background in Analysis, Design and Development in the field of Database, Data Warehouse, Data Modeling and implementation of QlikView for BI applications
Developed Complex Graphical User Interactive reports using various QlikView Objects
Installed & Configured QlikView Software
Experience in Incremental Loading and QlikView document Versioning
Experience in QlikView dashboard design, aggregate functions, multi-dimensional objects, set analysis, using SQL Scripts, VB Scripts to write Macros in QlikView and/or Excel
Experience with QlikView Publisher and well versed on working with hierarchical data
Experience with QlikView Development, Server setup, configuration and administration in a clustered environment
Implemented Triggers using Macros to provide custom functionality in Dashboard Applications
Involved in Performance Tuning and Deployment of QlikView Applications
Technical expertise in Microsoft Technologies such as MS SQL Server 2008/2005/2000, MS-Access, DTS and worked extensively on Reporting services (SSRS) and Integration services (SSIS)
Extensive experience on Data modeling, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT& Dimensions tables, Physical & Logical data modeling, T-SQL/SQL Development, Stored Procedures, Views, Indexes, data integrity, Error Handling, Data Analysis and Normalization.
Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports, Parameterized and distributed reports in multiple formats using SSRS.
Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
Experience in covering every aspect of the business of customer relationship management (CRM)
Provided Training Sessions on QlikView capabilities to potential clients
Implemented Best Practices & Worked on Data model/Script to resolve Circular Relationships, Synthetic Keys
Excellent analytical, communication, interpersonal skills and also have the ability to work effectively as a team member.
Education:
Bachelor's in Engineering, Acharya Nagarjuna University, India (April 2006)
MS California State University, Fresno (Dec 2008)
Technical Skills:
Operating Systems
Windows 2000/ NT/ XP/ Vista/98/ 95, UNIX/Linux, Windows 2003 server.
Programming Languages
C, C++, C#.Net, VB.Net, JAVA, SQL, T-SQL, PL/SQL, XML.
RDBMS
MS SQL Server 2008/2005/2000, Oracle 8i/9i/10g, MS Access 2000, My SQL.
Client Scripting
JavaScript, JQuery, VB Script.
Web Technologies
ASP.Net, JavaScript, HTML/DHTML, XHTML, XML.
ETL
DTS, SQL Server Integration Services (SSIS).
Analytical Tools
SQL server Analysis Service (SSAS), Performance Point Server 2007, ProClarity Analytics Server
SQL Server Tools
Query Analyzer, SQL Server Profiler, SQL Server Mail Service, Enterprise Manager, SQL Server Agent, DTS, BCP.
Versioning
Team Foundation Server (TFS), Visual Source Safe (VSS), SVN.
OLAP/Reporting Tools
SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), QlikView, SAPBO
Professional Experience:
Client: Polycom, Inc., San Jose, CA May’17- Current
During this assignment:
i.Developed “T4SLO” dashboard to track the Uncommitted Escalations within SLO (Service Level Agreement)
ii.Migrated OBIEE/ QlikView reports (Revenue, Demand Supply) to Qlik Sense self-service discovery applications
iii.Developed PMO Qlik Sense self-service discovery application
iv.Developed Engineering Quality Qlik Sense self-service discovery application
Responsibilities:
Qlik Sense Consultant
Worked with end client/users to gather requirements, documented and provided sign-off from Polycom
Worked on Design and Development of Qlik Sense Data load scripts
Involved in day to day meetings with users to gather requirements, security review, analysis of the data and requirement specifications
Mapped data and configured the connections to pull data from different sources to Qlik
Worked on developing the User Interface, validating the data and scheduling the jobs using the publisher to reload the dashboard for user consumption
As a lead QlikView developer helped other developers and business users in resolving issues with existing and new applications
Environment: QlikView 11, Qlik Sense Hub 3.1, SQL Server 2003/2008 R2, Siebel (Oracle 11g, Access), .CSV Files, Excel, Jira, Salesforce, NPrinting 17, Windows 2008 Server, Toad 12.1
Client: Fox Networks Group, Playa Vista, CA Sep’16-Apr’17
During this assignment:
i.Migrated Fox’s Pace system dashboards to OnAir System
ii.Migrated WebFOCUS dashboards to Qlik Sense self-service discovery applications
iii.Developed CAS Reporting and Sold Dollars Analysis Qlik Sense self-service discovery applications
Responsibilities:
QlikView/Qlik Sense Developer
Worked on requirements gathering, analysis, mapping, design, development, testing, deployment and production support of client’s OnAir dashboards
Analyzed business requirements related to various projects, estimated hours and communicated effectively with management, business users and technical team members
Scoped projects and Completed within fixed period of time accordingly
Trained full stack developers, Senior Executives and end users on QlikView and Qlik Sense software
Involved in the maintenance and support of QlikView applications
Supported and made enhancements to the client’s existing Neo Financial Reporting, Post Air, Market Place Analytics, Market Place Audit Report apps
Participated in Code and Data Model reviews during daily scrum and weekly BI team meetings
Worked on migrating QlikView apps from Actian (Vector), Discovery(Matrix) to Cloud (Amazon Redshift)
Created Active Directory Groups, Controlled user access to various applications using QMC
Environment: QlikView 12, SQL Server 2003/2008 R2, Oracle 12g, Access, .CSV Files, Excel, Windows 2008 Server, Db Visualizer, Qlik Sense Desktop 3.1 SR4, Qlik Sense Hub 3.1, Tableau 9.2, Actian(Vector), Discovery(Matrix), Amazon Redshift
Client: Polycom, Inc., San Jose, CA Jul’15- Aug’16
During this assignment:
Developed a dashboard named “Polycom Global Services Utilization” (PGS) to track and monitor Polycom and its subsidiaries’ work force utilization globally
Developed a dashboard named “PM Revenue Reports” to track the revenue numbers for Polycom Professional Services teams across the globe (NALA, APAC, and EMEA)
Developed a dashboard named “Service Request Dashboard/CCA” to track the flow of service requests/ tickets from PGS to Engineering
Responsibilities:
QlikView/Qlik Sense DW Lead/Sr. Developer
Worked on the analysis, design and development of Business Intelligence reports using the QlikView V11
Created new dashboards, and helped in maintenance of the existing dashboards which have been developed over time
Involved in requirement gathering, analysis, design and development of the QlikView applications/dashboards as per user requirement
Involved in day to day meetings with users to gather requirements, security review, analysis of the data and requirement specifications
Mapped data and configured the connections to pull data from different sources to QlikView
Developed Initial load scripts and built the data model as per the requirement
Worked on developing the User Interface, validating the data and scheduling the jobs using the publisher to reload the dashboard for user consumption
Worked on Proof of Concept (POC) of Qlik Sense, also migrated couple of applications to qlik sense
As a lead qlikview developer helped other developers and business users in resolving issues with existing and new applications
Environment: QlikView 11, Qlik Sense 2.2, SQL Server 2003/2008 R2, Siebel (Oracle 11g, Access), .CSV Files, Excel, Jira, Salesforce, NPrinting, Windows 2008 Server, Toad 12.1
Client: Toshiba America Information systems, Irvine, CA Dec’14-Jun’15
This project is mainly to develop an executive dashboard for the CEO of Toshiba America Electronic Component. This dashboard is used as a POC for the client to migrate their existing BO environment reports into QlikView
Responsibilities:
QlikView Expert/Sr. Developer
As the QlikView expert solely responsible for the POC and development of client’s executive dashboard to replace the existing BO report environment
Developed the proof of concept of the client’s executive dashboard.
Worked on the requirement gathering, analysis, design, development, testing, deployment and production support of the client’s executive dashboard
Worked extensively on extracting data from various data sources like QVD files, BODS(Oracle), Excel and CSV File
Worked extensively on Set Analysis to achieve the user time in analysis requirement
Trained other developers and end users on QlikView software
Helped the client’s executive team in decision making of clients QlikView software environment
Involved in the maintenance and support of QlikView server and QlikView applications
Environment: QlikView 11, SQL Server 2003/2008 R2, Oracle 10g/11g, Access, .CSV Files, Excel, Windows 2003 Server, BODS, Toad 10.6
Client: Reliance Steel and Aluminum Co., Cypress, CA Aug’12-Dec’14
QlikView Developer
This project mainly involves developing a new common dashboard to serve all the subsidiaries of the client company to facilitate decision making.
Responsibilities:
Worked on the design and development of Business Intelligence reports using the QlikView V10/V11 dashboard tool in support of the Reliance Business Intelligence initiatives
Developed new dashboards, and to also helped in maintaining the existing dashboards which have been developed over time
Worked extensively on extracting data from various data sources like QVD files, Oracle, Excel, CSV File, MDM and ODS
Worked extensively on Set Analysis, wrote and resolved complex macros issues
Worked on Server and QEMC maintenance. Scheduled jobs for incremental and full loads using publisher
Worked extensively on security
New Common Dashboard: Involved in delivering both company and enterprise focused analytic capabilities in a scaled down and simplified version of the client’s common dashboard.
BI Dashboards Migration to QlikView v11: Migrated all QlikView dashboards successfully to the QlikView Application Version 11 and migrated to new servers
Assisted in the maintenance of existing dashboards in Crystal reports and Business objects area
Environment: QlikView 10/11, SQL Server 2003/2008 R2, Oracle 10g/11g, Access, .CSV Files, Windows 2003 Server, MDM, ODS, Informix
Client: JPMC, NYC, NY
QlikView Developer Sep'10-Jul’12
The primary focus of this project is business enhancement and competitive edge using QlikView to make better business decisions. Client wanted to have Reports in Data Warehousing system for analyzing trends in business and make key strategic decisions (includes product, geographical and time based analysis)
Responsibilities:
Involved in Requirement gathering and designing QlikView applications
Worked on Gathering data from various sources like QVD files, Excel, Oracle, Teradata, Binary QVW, Inline and text files in developing the QlikView Data Models
Developed QlikView Dashboards using Chart Box (Drill Down & Cyclic Grouping), List, Input Field, Table Box, Calendar & Date Island
Developed KPI’s and set analysis applications
Worked on various QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc
Developed User Interactive Sheets and Reports as per the business requirement
Worked on writing SQL Scripts to load the relevant Data in QlikView Applications
Developed Macros, SET ANALYSIS to provide custom functionality in QlikView Applications
Implemented Security and involved in Deployment of QlikView Applications
Created QVD’s and updated on timely basis as database updates
Worked on Developing ETL Scripts while loading the data, resolving loops and ambiguity joins.
Worked on Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users
Worked on Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.
Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
Environment: QlikView 9/10, SQL Server 2005, Oracle 10g, Access, .CSV Files, Windows 2003 Server
Client: Jeffries LLC, Jersey City, NJ May'09- Jul’10
BI Developer (SSIS/SSRS)
Responsibilities:
Involved in SDLC of the project from requirements gathering to system design and database implementation of the project.
Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis,
Involved in project planning, scheduling for database module with project managers.
Developed the necessary Stored Procedures and created Views using Joins for robust and fast retrieval of data in SQL Server 2005.
Created and maintained Database Maintenance plans and also created logins, assigned roles and granted permissions to users and groups.
Implemented SSIS Import/Export Wizard, for performing the ETL operations.
Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
Migrated SQL server 2000 DTS packages to SQL Server 2005 SSIS packages using SQL Server 2005 Upgrade Advisor.
Worked on Enhancing and deploying the SSIS Packages from development server to production server.
Created the reports based on the requirements using SSRS 2005.
Developed reports using SQL Server Reporting Services (SSRS) & Security using LDAP, Active Directory.
Participated in client-server, multi-tier application (Internet/Intranet) development, and enhancement and testing. Resolved all production issues and provided the deliverables at the right time.
Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
Worked on automation of maintenance jobs, locks and indexes configurations.
Administered SQL Server security, SQL Server automatic e-mail notification.
Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handled dead lock scenarios.
Monitored the system regularly for bottlenecks (CPU, RAM, Disk I/O and Networking).
Ensured developers coordinated their efforts in managing and maintaining different application databases
Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
Environment: MS SQL Server 2008/2005, DTS, Windows 2003, SQL Server Management Studio, SSAS SSIS, SSRS, SQL Server Business Intelligence Development Studio(BIDS), SQL Server Query Analyzer, OLAP, MDX, ETL, Erwin, MS Visual Source Safe
Client: Dow Agro Sciences, Fresno, CA Apr’08-Aug’09
LIMS/Report Developer Intern
Responsibilities
• Worked on coordinating the needs of functional departments and established priorities for LIMS requirement gathering, system design and implementation
Worked on complex LIMS configuration to meet end user requirements for users
Worked on LIMS documentation and wrote test plans
Developed and configured different reports like ad hoc, tabular and pie charts
Worked on reviewing company documentation to assess the LIMS impact
Trained end users and other LIMS users
Environment: SQL Server 2000, ASP.NET1.1, C#, Microsoft Visio, DTS, Query Analyzer, Crystal Reports, Windows 2000.