Sales Project
Resume:
Arsalan Malik
Email: *********@********.***
Address: ** ***** ** *** ****
City: Jersey City
State: NJ
Zip: 07310
Country: USA
Phone: 321-***-****
Skill Level: Experienced
Salary Range: $135,000
Willing to Relocate
Primary Skills/Experience:
See Resume
Educational Background:
See Resume
Job History / Details:
ARSALAN MALIK
*********@********.***
EXPERIENCE SUMMARY:
More than 5 years of combined experience in financial and semi-conductior environments working as a full life cycle Business Intelligence Developer using QlikView and WebFOCUS.
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:
Business Intelligence tool QlikView 11/10, WebFOCUS 7.7.3/7.6.4
Databases BI/DW Databases - Oracle 8i, 9i and 11i, MS SQL Server 2000/2005, MySQL
Scripting languages SQL, Perl, Pascal
Data modeling tools MS Visio 2003/2007
OLAP/BI tools SQLServer 2005, Oracle 9i/11i
Servers Windows 2000/2003
Operating systems Windows
Methodologies Use Case, architecture, diagrams, data modeling
Other Programming Languages Java, Microsoft .Net, C/C++, Verilog
Web Technologies ASP/ASP.NET, PHP, VB Script, Java Script, HTML
Operating Systems Windows XP, 2000, NT, 9x
Other Microsoft Visual Source Safe, Autosys, TOAD for Oracle, TOAD for SQL Server
BI WebDevelopment Dash boarding
Analytical Skills Systems Analysis and design, Quantitative Analytical skills
WORK EXPERIENCE:
Citi Group, Jersey City, NJ Oct 2012 - Present
Application Developer - Senior
Project: Rates Dashboard
Project Description: Enhanced the Rates dashboard by following newly adopted standardization approach for all the dashboards in place at Citi
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
Intersil Corporation, Palm Bay, FL May 2007 - Aug 12
Sr Business Intelligence Developer
Project: Pricing Analysis Tool Dashboard
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 (Jan 11 - Jul 11)
Project: Conversion of multiple already existing dashboards from WebFocus to QlikView
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 (May 09 - Dec 10)
Project: Quality/Reliability Dashboard
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 (Mar 08 - Apr 09)
Project: Distribution Dashboard
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 (May 07 - Feb 08)
Project: Enhance Order Management Dashboards & Cost System Reporting Application
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, FL
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
EDUCATION
UNIVERSITY OF FLORIDA
Master of Science - Decision and Information Sciences, May 2008
Gainesville, Florida
CERTIFICATIONS/TRAINING/ACTIVITIES
Certificate of Achievement for reporting - Information Builders
Certificate of Achievement for Advanced Application Development - Information Builders
8D problem Solving Process Tools Workshop
Course of instruction in Managing Time & Multiple Priorities
Graduate level courses in Managerial and Financial Accounting
Contact this candidate