PROFESSIONAL SUMMARY

• Around 5 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.
• Database structuring and database application design and development.
• Designed and implemented proof of concepts for clients in the Pharmacy, Financial and Manufacturing sectors.
• Developed Complex Graphical User Interactive reports using various Qlikview Objects.
• Strong Skills in Data Modeling ( Star Schema, Snow Flake Schema) & Loading data from Multiple data sources.
• Installation & configuration Of Qlikview Software.
• Experience in Incremental Loading & QlikView document Versioning.
• Experience in Migration from Microstrategy to Qlikview
• Strong Experience in Data Mart/database design and development.
• Sound knowledge in writing SQL Queries, Pl/SQL Stored Procedures.
• Strong Database Development skills using SQL Server 2005, 2008 & Oracle 10g.
• Good ETL skills ,Data modeling, Dimensional Modeling knowledge with experience in developing data movement, data cleansing and data integrity
• Experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), SSIS, BCP, Bulk Insert).
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS.
• Hands-on experience covering every aspects of the business of customer relationship management (CRM)
• Provided Training Sessions on QlikView capabilities to potential clients
• Involved in Performance Tuning & Deployment of QlikView Applications.
• A team player with good interpersonal skills and work independently.
  

TECHNICAL Skills
Database: Teredata, SQL SERVER 2005, Oracle 10g, MS Access, Excel & .CSV Files.
Languages: SQL, VisualBasic,.Net
BI TOOLS: QlikView 8.5/9.0/10.0/11.0, Business objects 3.1, Microstrategy
Data Modeling: Erwin, Microsoft Visio
Operating System: Windows95/98, Unix, Windows2008/Windows 2003/NT/XP,MS DOS

EDUCATION:
Bachelors in Electronics
Certified in QLIKVIEW (Designer and Developer)

PROFESSIONAL EXPERIENCE:

Client: Confidential, Mountain View, CA April 2012 – Till Date
Title: QlikView Developer

• Design, develop and implement QlikView applications
• Analyzing the system requirements and advising on logical and physical design of the database.
• Business Understanding, Prepared SRS, Data Understanding.
• Table Understanding, Developing User Interface.
• Working closely with all levels of business, with varying levels of technical knowledge, to gather accurate and actionable business and technical requirements
• Analyze reporting requirements to architect appealing supportable reporting solutions
• Conduct validation of existing reporting and new solutions to ensure continuous accuracy, and front end ease-of-use
• Data Modeling, Analysis, Reporting, Data Testing.
• Co-ordinate with Testing team for QA and UAT
• Prepared Technical Specification Document, Migration Documentation
• Involved in Client Meeting and Discussion
• Trained users (where ever required)

Environment: QlikView 10/11,Qlikview Publisher, Teredata, Oracle, Sql server,Flat Files, Windows 2008 Server.

Client: Confidential, Raleigh, NC Aug 2011 – Mar 2012
Title: QlikView Developer
Confidential employees serve US communities by discovering, developing, and delivering new medicines, vaccines, and other healthcare products to help people do more, feel better, and live longer.

• Develop effective QlikView data models
• Develop front end applications using QlikView technology
• Migration from Microstrategy to Qlikview
• Analyze business requests and partner with the Analytics Department to provide a strategic solution
• Provide input on proposing, evaluating, and selecting appropriate design alternatives which meet requirements and are consistent with our current standards and processes
• Provide scripting support for the Analytics Department to meet complex business requirements
• Utilize QlikView Publisher capabilities
• Extract, transform, and load data from multiple data sources into the QlikView application
• Design, Build, Test, Debug, Monitor, and Troubleshoot QlikView solutions
• Follow implementation standards
• Utilize source control tools
• Follow deployment process
• Serve as an escalation point for any issues that may arise
• Develop documentation and transfer of knowledge
• Work with business support and technical experts as required

Environment: QlikView 9/10, Teredata, Access, .CSV Files, Windows
2003 Server.

Client: Confidential, Lincoln, NE Sep 2010 – July 2011
Title: QlikView Developer
Confidential is the wireless phone provider that owns and operates the second largest mobile telecommunications network in the United States, based on a total of 94.1 million U.S. subscribers
Involved in Requirement gathering & designing QlikView applications.

• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Developed KPI’s and set analysis applications.
  Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc...)
• Developed User Interactive Sheets & Reports as business needs.
  Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Developed Macros, SET ANALYSIS to provide custom functionality in Qlikview Applications.
  Implemented Security & involved in Deployment of Qlikview Applications.
• Created QVD’s & updated on timely basis as database updates.
  Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• 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 8.5/9, SQL Server 2005, Oracle 10g, Access, .CSV Files, Windows
2003 Server.

Client: Confidential, New York Apr 2008 – Aug 2010
Title: QlikView Developer
Confidential is a full-service commercial bank, providing a broad mix of financial services to businesses and individuals. The bank also offers investment and financial management, trust services, private banking, insurance services, and global custody services

• Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reporting using Qlikview 8.5.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Implemented Star schema & snow flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation and solved the loops issues.
• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files).
• read and gather Qlikview Planning requirements.
• Used to solve the issues related to the end users.
• Installation/Configuration of Qlikview 8.5.
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.

Environment: QlikView 8.5, SQL Server 2005, Oracle 10g, Windows Server 2003, Windows XP, Microsoft Visio.

Client: Confidential
Location: O Fallon, MO
Title: Visual Basic / SQL Developer Nov 2007 – Mar 2008
Confidential is a mutual company owned by our policyholders. Our 68,000 employees and nearly 18,000 Agents service 81 million policies and accounts throughout the U.S. and Canada.

• Responsibilities implementing database objects.
• Documenting models with metadata
• Experience writing Complex SQL queries and PL/SQL.
• Leadership, project management and time management.
• Created SQL Server database to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, optimization, normalization) and .NET data access components
• Individually designed MS SQL Server 2000 database, coded stored procedures (T-SQL).
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Developed complex Stored Procedures and Views to generate various Drill-through reports, parameterized reports and linked reports using SSRS
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS)

Environment: Oracle 8i, Teredata, ODBC, Windows NT, UNIX, MS Visual Studio .NET