PROFESSIONAL SUMMARY:

• Around 9 years of total IT experience in Software Development
• 3+ years of working experience in QlikView as a Qlikview Developer
• Expertise in Full Software Development Life Cycle including Planning, Analysis, Design, Implementation and Maintenance by using Qlikview
• Good Confidential working with Data Warehousing and business intelligence tools for developing various reports using Qlikview BI
• Well versed with all BI and DWH concepts and architecture
• Worked on Extract, transform and load datafrom multiple sources into QlikView
• Implemented incremental loading for QVD’s in Qlikview Applications
• Experience in custom development for Dashboard Analysis and Report Statistics
• Worked on BI Publisher by importing data from multiple data sources and delivered Reports, common dashboards, security, calculation, caching and intelligent request generation services
• Good in validating the BI reports/dashboards by preparing the Test Plans & Cases
• Strong knowledge and Experience in multiple Databases such as Oracle, MySQL and SQL Server
• Experience in working with different operating systems like UNIX, Windows and MacOS
• Experienced in testing Web Services by using SoapUI and knowledge in SOA (Service Oriented Architecture) concepts
• Worked on Clear Case, Stash/Bitbucketand Subversion as Versioning Tools
• Extensively involved in Demos, Presentations, Meetings and Interaction with Senior Management
• Coordinated and acted as a liaison between the business groups and the IT department.
• Excellent communication & interpersonal skills and broad understanding of business operations, requirements and analysis
• Self - motivated and enjoy working in a technically challenging environment.
• Excellent work ethics, quick learner and very good team player
• Skilled in translating business requirements into technical designs and specifications

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, Linux and MacOS

ETL and BI Tools: Qlikview v11, Qlikview Publisher (10/11) Qlik Sense, Qlikview Server, NPrinting, Informatica and Tableau

Languages: SQL, PL/SQL, XML, WSDL, HTML

Databases: Oracle, SQL server, MySQL

IDEs: Toad, Oracle SQL Developer, DB Visualizer, SoapUI

Design & Requirements Tools: Rational Rose Modeler, MS Visio and DOORS

Database Tools: TOAD, SQL Developer, SQL Editor, Rapid SQL

Bug Tracking Tools: Rational ClearQuest, Jira, Bugzilla

Configuration Tools: Rational ClearCase, CVS, WinCVS, WinMerge, CVS - Linux, PVCS, VSS, Subversion, WIKI

Other Tools: Putty, WinSCP, WinMerge, Cygwin

PROFESSIONAL EXPERIENCE:

Confidential, Troy, MI

Qlikview Developer

Responsibilities:

• Gathered, documented requirement from the users and developed Complex graphical User Interactive reports using various QlikView Objects.
• Worked with Incremental Loading & QlikView document Versioning
• Build Data Models and connected to different sources of data.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Dashboards served to track inventory and sales as well as to monitor Various KPIs. Dashboards included customer detail drilldowns, threshold gauges.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled Jobs for QVD extracts and report reload.
• Developed different complex models eliminating closed loops, Synthetic tables and ambiguous relationships
• Worked on requirement specifications for the strategic KPI's that drive performance and profitability in the division Waterfall methodologies followed during course of the project
• Performed analysis, documentation for calculation for various attributes
• Performance tuning of dashboards was carried out to limit the response time towell under 10 seconds.
• Implemented Section access and Hidden scripting for the Application Security
• Performed testing of dashboards for functionality, data, performance, look and feel
• Migrated dashboards to higher environments and manage user access.
• Developed Heat map charts for data visualization
• Developed KPI’s, User Interactive Sheets as business needs
• Developed systems architecture for QlikView implementation identifying the data sources and target reports
• Analyzed end user requirements and developed technical solutions
• The project initially used Tableau but migrated to QlikView during the 2nd phase of development

Environment: Tableau, Qlikview 11.0, My SQL, SQL Server, HTML, Excel, windows, putty, TOAD, Jira, Linux

Confidential, Rochester, NY

Qlikview Developer

Responsibilities:

• Involved in requirement gathering by working with Users, Understanding Business requirements, stakeholder management
• Analyzed the requirements and design class diagrams, sequence diagrams using UML and prepared high - level technical documents
• Dashboard designing as per Business requirements with various levels of complexity including different kinds of charts and extensions
• Build data models to connect to multiple data sources such as Oracle, SQL Server, flat files
• Handled the end-to-end implementation of Qlikview dashboard deployment
• Worked with Sheets and Sheet Objects in QlikView
• Created Dashboards style of reports using Qlikview components like List Box, Slider, Buttons, Charts, and Bookmarks etc..
• Created the reports using charts like Pie, Bar, Line etc.. Charts are used in making reports user-friendlier in analysis purposes
• Handled large data volume by periodic backup taken by using incremental load of QVDs
• Created report task and scheduled them to run Confidential specific interval in Qlikview Enterprise Management Console.
• Reduced data using simple reduce, loop, and reduce in Qlikview Publisher
• Built dashboard using complex expressions, set analysis, variables and functions
• Optimised Dashboard with help of QlikView best practices and Techniques
• Provided custom functionality by using Macros and SETANALYSIS to in Qlikview Applications
• Handled Maintenance and support issues
• Monitored the QVS, QVW's and user accounts for application usage
• Implemented Security in Qlikview Publisher and Qlikview desktop

Environment: MySQL, Qlikview v11 Sr2, SSIS, VMware, Flash, Macromedia Flash, SQL, MS-Excel, PowerPivot, Macromedia Dreamweaver Oracle 11g, Windows 8

Confidential, NY

Qlikview Developer

Responsibilities:

• Involved in gathering & analyzing business requirements
• Involved in Extracting, Transforming and Loading data from different data source
• Implemented Star schema data modeling and removed complex synthetic keys in the existing data modeling of various dashboards.
• Worked extensively on the Oracle database and imported SQL scripts into Qlikview
• Implemented security using section access that dynamically hides selected areas of the dashboard depending upon user privileges
• Implemented Sheet level security to limit access based on user groups
• Dynamically show/hide sheets, handled Null Values
• Developed QlikView Dashboards using Drill Down & Cyclic Grouping
• Developed KPI’s and set analysis applications.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping)
• Preformed Dashboard data testing by using SQL queries in Editor and Excel files
• Created optimized QVDS, which loads faster and helps to improve the performance
• Created pop up text box on button click, which will prevent it working where user can navigate to that sheet only after making required selections in that page.
• Distributed QlikView Reports in NPrinting PDF format via Email
• Handled the end-to-end implementation of QlikView Dashboard deployment

Environment: Qlikview 11, Oracle 11g, Toad, SQL Developer, Windows 2008 Enterprise, QualityCenter, NPrinting, SQL Server Data Tools (SSDT) visual Studio

Confidential, Malvern, PA

QA Engineer

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes
• Analyzed the requirements, creating and executing test cases
• Involved in ETL process testing using Informatica ETL tool
• Test Case Execution and Adhoc testing.
• Performed Integration, End-to-End, system testing.
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
• Performed data validation testing writing SQL queries
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica
• Worked with data analysts to implement Informatica mappings and workflows and stored procedures to meet business requirements
• Involved in communication between UAT team members, business leaders, and IT
• Participates in application release planning and status sessions
• Used Agile-testing methodology for achieving deadlines in UAT testing

Environment: Informatica, SQL, DB2, Oracle, Windows XP, HP QualityCenter, Rational ClearCase, Rational ClearQuest, Remedy, Microsoft Office

Confidential, Richmond, VA

QA Analyst

Responsibilities:

• Tested GUI’S of various Billing Data of Confidential & Confidential
• Organizing and Documented test process like Developing Test Conditions, Test Scripts.
• Involved in System Testing, Interface Testing and Integration Testing
• Tested user interface inconsistency and application functionality
• Used XMLin conjunction with an object oriented and is made influenced to view, process, transport and manage the data in Extensible, Structured &validating possibilities.
• Regression testing done by using QTP
• Responsible for reporting bugs to the corporate bug tracking system and verified known bugs against new builds.
• Also initiated and participated in Conference Calls, Walkthrough and Review Meetings.
• Involved in Developing of Defect Reports by using PVCS Tracker and Test Director

Environment: QTP, Test Director, PVCS Tracker, Java, XML, Oracle, SQL, UNIX, Windows XP, Web logic

Confidential, Silver Spring, MD

QA Analyst

Responsibilities:

• Participated in planning meetings for current and next iteration
• Analyzed change requests/requirements and provided Level of Effort (LOE) estimates for test case development, test data preparation, and test execution to Test Lead/PM
• Attended user stories/requirements walkthroughs
• Developed test cases based on User Stories/requirements/Business Rules and reviewed test cases with stakeholders
• Developed test cases and linked test cases to requirements in HP QualityCenter for RTM.
• Generated Requirements Traceability Matrix (RTM) Coverage and Gaps reports and reviewed
• Executed targeted test cases, regression test cases, documented defects in HP Quality Centre with adequate information, and participated in defect review meetings
• Actively participated in end-to-end testing with Broadview application, which includes the deals/seasons/ series/episodes information flow between systems
• Performed shakeout testing in test environments after deployment and in production during the implementation
• Performed GUI, Functional, Integration, System, Interface, End-to-End, Regression, Black Box and Back-End Database testing
• Participated in daily jump-up status meetings
• Created and executed SQL queries to validate data between UI and database
• Validated out-going XML request files and in-bound XML response files as part of interface testing between systems
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables
• Validated the responses of web services by passing various requests in SOAP UI
• Worked on multiple releases/tasks in parallel based on priority/ urgency
• Assisted Test Lead in preparing Risk Based Test Matrix (RBTM) to identify right set of regression test cases
• Developed Regression Suite from scratch, maintained and executed regression test suites
• Ensured to meet the Project timelines and escalate the risk identified during the testing process
• Participated in retrospective meetings to identify things done well, things to improve, and actions to apply

Environment: Java, JSP, Oracle, HP QualityCenter, SOAP UI, XML, Windows XP, SDLC, Load Runner, SharePoint