EXPERIENCE SUMMARY:

• More than 7 years of combined experience in financial, retail and semiconductor industries, working as a full life cycle Business Intelligence Developer using QlikView and WebFOCUS.
• Over 2 years of QlikView dashboard development experience.
• Hands-on experience in analysis, and development for global BI project solutions.
• Involved in the implementation and maintenance of high performance BI solutions.
• Worked with Information Builders WebFOCUS 7.6.4 and 7.7.3.
• Strong experience working in a fast paced industry, dynamic environment with the ability to multi-task.
• Prioritized work activities to achieve project goals in a timely manner.
• Experience working in intuitive, integrated environment of IBI WebFOCUS keeping focus on solving business problems and delivering interactive content in various formats.
• Provided flexible customization and personalization of analytical, trending and financial reporting.
• Hands on experience with MRE Managed Reporting Environment.
• Completed design and development of the most complex components of the reports.
• Trained end users on dashboards and the financial reporting features for management.
• Expertise troubleshooting and resolving technical roadblocks.
• Participated in requirements gathering and scope estimation meetings.
• Good knowledge of Business Intelligence fundamental architecture concepts and various programming languages such as SQL.
• Worked with Oracle databases to retrieve data. Gained strong knowledge of financial reporting.
• Good understanding of IT technical knowledge and BI best practices.
• Solid BI tool expertise with skills in Oracle and SQL Server.
• Versatile team player with excellent analytical and presentation skills.
• Strong ability and willingness to learn new technologies.

TECHNICAL SKILLS:

WORK EXPERIENCE:

Confidential

Senior BI Developer

• Working with Sales business users, dealing with FICC, Equites, Clients, Trading data
• Hands on experience with QlikView extensions
• Worked directly in the past with business team in all phases of application development from gathering, analyzing and documenting requirements to presenting the final product to higher management
• Improved data sources - how the data should be collected more effectively
• Gathered data into Data Model from CSV and MS Excel files
• Used differents models to put data together
• Built front-end interface using various objects charts, pivot and straight tables, buttons
• Used drill-down approach to let users see from high level to detailed level information
• Applied Set Analysis, Alternate States and Comparative Analysis
• Added an option for user to add or drop fields from the report
• Included images over 3,000 in one of the reports
• Provided the option to let user export Excel files and then use them as part of data source to the dashboard
• Scheduled jobs in Management Console

Environment: QlikView 11, Windows

Confidential

Application Developer - Senior

• Pulled data from multiple sources that included organizational Hierarchies, Balance Sheet, Inventory, Travel Enxpenses, Revenues, Risk and Head Count information
• Removed synthetic keys from data model
• Followed Star Schema by creating a Fact and multiple Dimension tables. Fact consisted of many concatednated sources
• Made use of Qlikview script qvs files and Mapping tables
• Validated data by comparing results with database
• Provided a working User Interface to Business team according to new rules
• Made use of Set Analysis
• Modified all the objects charts, multi-boxes, text boxes, buttons, container objects to connect to new data model

Environment: QlikView 11, 10, Oracle 9i/11i, Windows

Confidential

Sr Business Intelligence Developer

Project Description: Developed a dashboard for Sales team to determine the pricing of current parts depending on different factors

• Created dashboard using various components of Qlikview like List-boxes, Multi-boxes, slider, current selections box, buttons, charts and text objects.
• Provided options to export data into Excel files using VB Script
• Extracted data from Oracle system
• Applied hierarchical approach to show data in graphs
• Used various components of Qlikview to make the dashboard interactive and user friendly
• Gained experience in using QlikView functions Date and Time, Keep, Join, Mapping, input Fields etc.
• Utilized Set Analysis to create custom functionality for users
• Implemented section access to give access of these reports to only a certain number of users and developers
• Deployed these reports on the production server using Qlikview server and Publisher
• Added additional tab for customer's trend
• As a standard practice, added Help tab as a reference for users
• Wrote macros in Excel as requested by users

Environment: QlikView 11, 10, PL/SQL, Oracle 9i/11i, Windows

Business Intelligence Developer Confidential

Project Description: Involved in converting portions of already existed dashboards developed in WebFocus into QlikView environment to do a performance comparison.

• Responsible for QlikView server, IIS installation and configuration
• Setup incremental loads for data extraction
• Responsible for Access point security and administration
• Imported tables from database into QVD files, removed any synthetic keys and circular loops during data modeling
• Created and documented multi-dimensional schema models, dimensional and fact tables
• Extracted information from different data sources like excel files, QVD files by using different scripts like add, concatenate, resident, concatenate, qualify and un-qualify.
• Investigated code to find root cause of errors and corrected reports
• Developed dashboard style of layouts using List boxes, Multi-boxes, current selections box, buttons, charts and text objects QlikView components.
• Tested, maintained and supported all newly developed QlikView dashboards on on-going basis
• Collaborated with outside team members and management

Environment: QlikView 10, Oracle 9i, VBScript, SQL, MS Excel, Windows

Business Intelligence Developer Confidential

Project Description: Intersil Corporation specializes in the design, development and manufacturing of high-performance analog semiconductors for four high-growth markets Communications, Computing, High End Consumer and Industrial. Creation of a dashboard for quality/reliability group to analyze part information for any returns from customers. This gave the users an option to download reports in Excel format for further data manipulation.

• Worked with quality team to setup a job that runs four times a day refreshing data on to ensure that the real-time data can be displayed on the web page
• Worked with admin group to setup Master files and ever time approved code changes were ready to be moved to QA environment or Production
• Developed analysis tab giving users an option to select various search queries ranging form part number to problem description
• Added a preview screen to let users see if they get desired output data before downloading the whole output file
• Gave users an option to save search queries, if routine matter they would not have to enter same data repetitively
• Added an area where a user can select field s to see on the output screen
• Included an option to save/export result set into Excel so it can be used for other purposes like pivot table or generating custom graphs
• Developed a second tab, PPM Parts Per Million to shoe data in graphical as well as chart form.
• Analyzed lesser search options as compared to first tab
• Added an option to display results either by quarter or by product line
• Repeated saved search and selecting output fields options
• Included a feature on bar graph to open up Excel report for detailed information
• Developed a Help tab to serve for users as a reference for help on pressing keys, and meaning of various icons on both tabs
• Worked as a database developer to extract data from Oracle tables
• Received Intersil Energizer Award for completing this project with dedication and before time

Environment: WebFocus Developer Studio 7.7.3, SQL, Oracle 9i, Windows

Business Intelligence Developer Confidential

Project Description: Developed a dashboard for Accounting and Financial Services group to monitor Orders, Sales and Backlogs. In addition, show data for Returns and Allowance, Point of Sales, Inventory so it can be optimized, Distributor trends and other related information.

• Met with finance team to gather initial requirements
• Developed fourteen tabs within the dashboard representing data for different sub areas.
• From page that displayed overview
• All pages had filtering ability on the basis of quarters or by product group
• Front page also showed graphical summary of end market sales
• In addition, links to detailed reports for Distribution Analysis Weekly report, trend overview, Order and Sales graph
• Orders tab contained tabular information for Net Financial Orders and Order Activity for current quarter
• In addition, links to detailed reports
• Sales tab had data of Sales Trend in dollars in addition to Net Financial Sales and current quarter sales
• Backlog displaying data in multi-colored bar and line graphs
• Showed Returns, Point of Sales information, also shoed information for Inventory and Trends
• Added a Help screen for new users displaying data for day to day terminologies, and what different icons mean on these web-pages
• Worked with Oracle databases to extract data

Environment: WebFocus Developer Studio 7.7.3, SQL, VBScript, Oracle 9i, Windows

Intern - Business Intelligence Trainee/Developer Confidential

Project Description: Improve existing Opportunity and Sales, Order and Backlog dashboards. Work on existing Cost reporting application while learning over all business processes.

• Opportunity dashboard contained any opportunity for new sales or new projects with existing customers
• Enhanced new report outputs by adding new fields and corrected data by adding some formulas
• Added capability to filter on customer Tier Codes throughout application
• Tested changes in QA and Production environments
• Made improvements to reports in Sales, Orders and Backlog dashboard
• Added filters for Current Quarter Sales and Delinquent Backlog
• Provided a new way to access the Impact data in Cost application
• Added drop-down box for choosing reports
• Added a feature to do comparison between Current and Revised values keeping in mind that current Standard Cost is updated 2x a year with revised values
• Edited 18 existing reports and created some new reports
• Did work in HTML layout development
• Created Excel output option
• Attended two formal training classes by Information Builders in Orlando,
• Gained knowledge of IT development life cycle practices at Intersil
• Got introduction to Intersil's business practices

Environment: WebFocus Developer Studio 7.6.4, SQL, Oracle 9i, Windows