Summary:

• Around 10 years of IT experience providing expertise in design, development and support of applications Windows environments.
• Expertise in working with Data Warehousing and business intelligence tools for developing various reports using QlikView BI.
• Experience in full life cycle project development, including design, coding, testing and implementation with ongoing product support.
• Strong analytical database design and Data Modeling skills in QlikView.
• Experience on Oracle9i and PL/SQL Programming.
• Good Understanding of Relational and Dimensional Database Concepts.
• Extensive experience in end-to-end implementation of Business Intelligence BI projects, especially in scorecards, reports dashboards.
• Excellent understanding of data warehouse specific Architecture, Design and Procedures, ETL and Workflow Development, data cleansing, data quality validation and unit testing.
• Expertise in QlikView 11.0 SR1/10.0 SR3 installation and upgrading existing version.
• Expertise in setting up server, publisher settings and configurations.
• Expertise in designing in Qlikview with complex multiples data sources SQL, Oracle, Flat Files relational designs and optimizing applications by using QVD's, removing non key fields and script variables Loading phase .
• Experience with Qlikview sheet objects including multiple charts types, Trends, KPI's, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI's.
• Experience in creating ETL Applications for QVD's and Qlikview Scripting variables and File, Date, System, Mapping, and Table functions.
• Experience in designing Qlikview Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Interacted with Customers for requirement gathering and effective analysis.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.

Technical Expertise:

Databases : Oracle 9i, 10g, MS SQL Server 2005,Postgresql and Teradata

Languages : C, Java, SQL, PL/SQL

BI Tools : Qlikview 11.0/10.0/9.0

Operating Systems : Windows XP/2000, Windows 2003 Server

Web Technologies : HTML, XML, Java Script, VB Script

Database Tools : Microsoft Visio 2003, SQL Loader, SQL Plus, Oracle Enterprise Manager, Oracle Designer 9i, TOAD, Autosys, Oracle Forms 10g, Oracle Reports 10g

Others : Office 2003/2007, Edit Plus, Apache Tomcat 5.0, Dreamweaver, Visual Basic 6.0

Professional Experience

Confidential

Oracle Developer

Roles Responsibilities:

• Gathering business requirements and created functional and technical specs and Worked with business clients to confirm and clarify requirements and business logic.
• Hands-on experience in the design, development of end user applications for the data presentation and analytics, including scorecards, dashboards, reports, monitors, and graphic presentation Information Visualization Analysis using QlikView 11 BI platform.
• Extracted information from different data sources like Teradata, SQL Server, MS Access and flat files, etc by using different scripts like add, concatenate, resident, qualify , unqualify etc
• Wrote SQL queries and created ad-hoc queries to perform data validation and analysis
• Designed reporting packages for report authors and ad-hoc packages to be used by end users in Query studio.
• Worked extensively on data modeling and built QVDs as per business requirement. Optimizing applications by using QVD's, removing synthetic keys and circular loop.
• Created dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Customized and tweaked the scripts and necessary data transformation, created simple and complex expressions using Set Analysis .
• Developed QlikView applications based on Incrementally Load Transactions using QVD files.
• Involved in daily standup with business analysts and data architect to resolve the business issues and Data challenges. Worked independently and capable of multitasking prioritizing in a fast paced and agile work environment.

Environment: Qlikview 11.0, Sql Server, Postgresql, SQL, Windows XP/2003 server, HTML, VB Script Java Script.

Confidential

Oracle Developer

Roles Responsibilities:

• Involved in business requirement gathering and development of functional and technical specification documents.
• Developed different dashboard with a complex database system behind it, which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Connected to different ODBC, OLE DB data sources SQL Server, Oracle and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of Qlikview.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the Qlikview publisher.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using Qlikview Publisher and notified load status by email.
• Maintained and administered source documents, source documents sets, and user profiles and executed resource management services like Access point resources, distribution folders and email servers. Monitor user access to manage the limited number of licenses.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Enhance existing dashboards with new functionalities and Tune ETL scripts for better performance.
• Build reusable macros to control Qlikview objects for ease of use by the users.
• Provide support analyst when internal teams have enquiries and trained business users
• Research and troubleshoot technical problems and Provided ongoing Qlikview consultation to the development team

Environment: Qlikview 9.0, Web Intelligence, Info View, TOAD, Oracle 9i/10g, SQL, Windows XP/2003 server, HTML, VB Script Java Script.

Confidential

Oracle Developer

Roles Responsibilities:

• Involved in business requirement gathering and development of functional and technical specification documents.
• Developed different dashboard with a complex database system behind it, which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Connected to different ODBC, OLE DB data sources SQL Server, Oracle and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of Qlikview.
• Performed subsequent alterations using SQL to make any changes on adhoc requirements.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the Qlikview publisher.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using Qlikview Publisher and notified load status by email.
• Maintained and administered source documents, source documents sets, and user profiles and executed resource management services like Access point resources, distribution folders and email servers. Monitor user access to manage the limited number of licenses.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Enhance existing dashboards with new functionalities and Tune ETL scripts for better performance.
• Build reusable macros to control Qlikview objects for ease of use by the users.
• Provide support analyst when internal teams have enquiries and trained business users
• Research and troubleshoot technical problems and Provided ongoing Qlikview consultation to the development team

Environment: Qlikview 9.0/10.0,TOAD, Oracle 9i/10g, SQL, Windows XP/2003 server, HTML, VB Script Java Script.

Confidential

Oracle Developer

Roles Responsibilities:

• Imported data from multiple data sources including Web files, MS SQL Server and MS Excel through OLEDB and ODBC connections and modeling data as per user requirements.
• Participate in enterprise DW / BI strategy/Dashboarding.
• Qlikview 9.0 implementation and integration.
• Involved in utilizing Qlikview solutions to develop complex reports and executive dashboard.
• Created Architectural Conceptual documentation and Technical Specification Documents.
• Create and manage ETL script generation using QlikView Script.
• Creating complex data models without synthetic tables and circular loops.
• Developed Qlikview applications creating expressions using set analysis.
• Created and scheduled Complex reports by leveraging the basic components of Qlikview.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
• Involved in organizing meetings to know the needs of clients for the Enterprise solution Implementation.
• Involved in design and development of QlikView Platform integrated with Expandable Databases.

Environment: Qlikview 9.0, Windows 2003 Server/XP, Oracle 10g, MS Access 2007, MS Excel 2007.

Confidential

Oracle Developer

Roles Responsibilities:

• Participating in the design and analysis phases.
• Performing the impact analysis and provide inputs to Business manager.
• Attending meetings with client/Business users to understand and collect the requirements to convert into business logic to develop the application.
• Participating in unit testing and documentation of requirements.
• Generating web based user interfaces Screens and reports using Oracle Forms, Reports, Oracle Designer 9i and Oracle Web Tool kit.
• Attending the weekly meetings and provide updates on the development to Project Manager and team.
• Tuned SQL queries to improve the application and reports performance.
• Modifying and writing Unix shell scripts to schedule batch jobs to run on everyday midnight to process large number of records on the database to change the client status based on certification dates.
• Clearing the log files from the test environment UNIX box on periodical basis to allow space.
• Working with DBA to identify and resolve the performance and user privilege related issues.
• Participation on rollout of the new application versions Both Client server and Web based to all Business users.
• Providing application support to end users.
• Providing support to Business users and QA team for User Acceptance and Beta testing.
• Participating in all phases of development life cycle.

Environment: Oracle Forms 10g, Oracle Reports 10g, Oracle Designer, Web tool kit, Windows Server 2003, C ,UNIX, Excel/VBA.

Confidential

Oracle Developer/ C Developer

Roles Responsibilities:

• Prepared the Database Design, Technical Design Low level Design of some modules based on the approved functional design document.
• Enhanced the physical data model using Microsoft Visio.
• Created database links to transfer data from one database to another.
• Performed tuning and optimization on SQL queries.
• Developed automated Korn shell scripts to schedule the loading of flat files.
• Used composite partitioning schema Range-Hash partitions to partition very large transaction tables, range partitioning and hash sub-partitioning.
• Developed SQL scripts using Sybase to perform data retrieval for a range of business criteria's.
• Produced scripts to cleanse source data, ETL process Extract, Transform Load data with business rules, and built re-usable Mappings.
• Devised the test strategies and prepared the unit test plans.
• Used Remedy to log the design defects, bugs or review defects.

Environment: Oracle 9i, TOAD, Putty, Autosys GUI, OEM, C , Excel/VBA,.Net