SUMMARY:

• 8 Years of IT experience in all aspects of Business Intelligence applications with a strong background in Database development, Data warehousing /Decision Support Systems and Business Intelligence.
• 5+ Years of experience in QlikView Development and knowledge on Qliksense.
• Expertise in Creating Dashboards using Qlikview 11.2/11.0/10 using different data sources like Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per the user requirement.
• Good experience in design, development and maintaining Dashboards and BI applications using Qlikview.
• Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.
• Having Knowledge in Database structuring, database application design & development, Entity Relationship Modeling (ERM), Data export/import, SQL programming &ETL procedures.
• Design of Qlikview applications using Qlikview Data (QVD) files generated by ETL logic.
• Experience in designing Qlikview Document/User Setting, Layouts to make consistent and optimized look to clients.
• Strong experience in Data Warehousing concepts - Star Schema, Snow Flake Schema and Data Modeling( Normalization/De normalization, ER Diagrams, Keys).
• Strong knowledge in basic components of QlikView Enterprise like List Boxes, MultiBoxes, Tables, Charts, Current Selection Boxes, Buttons, etc.. And experience in editing scripts for creating variables, fields, and calculated expressions, basic and aggregated functions.
• Sound knowledge in writing SQL Queries and Database Development skills using SQL Server 2008, 2010 & Oracle 10g.
• Having fair Knowledge on Qliksense Dashboards and visualization.
• Designing creative and visually effective user interfaces that address Key Performance Indicators
• Knowledge of industry standard best practices in both Business Management and technology domains
• Successful design and implementation of multiple conceptual, logical and physical data models
• Excellent presentation, summarization, structuring and refinement skills
• 2+ years of total experience in SAP R/3 implementations and post implementation.
• Involved in 3 Full Life Cycle Implementations.
• Expertise in SAP HR implementation and configuration with emphasis on HCM: US Payroll, Organization Management, Time Management, Benefits and Personnel Management Modules.
• HR ABAP Techno-functional Expertise includes: PA & PY modules, PNP & PNPCE logical databases, Info type creation, Clusters, Macros and Function modules, Schema, PCR and Operations.
• Experience in complete project life cycle including documentation, analysis, and development and testing.
• 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 SKILL SET:

Business Intelligence Tools: QlikView 10 & 11

ERP: SAP R/3 HR, SAP R/3 HR-ABAP

Platforms: Windows 95/98/2000 Server/ Advanced Server, Windows XP, Windows 7

Databases: Oracle9i/10g/11g, SQL Server, Teradata, MySQL, DB2 9.5, DB2 10.5.

Others: MS Access, MS-Excel, MS InfoPath, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, Ct

QlikView Tech Lead

Environment: QlikView 11.2, SQL Server 2008/2010, MS Access, Windows 7, SQL Programming

Responsibilities:

• Involved in requirement gathering and designing QlikView Dashboards for CIO's and CFO's.
• Participated in business requirement document, functional design document and technical design document preparation.
• Involved in creation of mockups of the dashboards based on business user requirements.
• Proposed solutions by performing feasibility analysis for the requirments.
• Performed redesign of QlikView BI platform to improve availability, scalability and performance to accommodate high volume of data with numerous dashboards for different domains like HR, Finance, IT Operations etc.
• Direct and independent interaction with stake holders and clients on daily basis, requirement gathering, requirement analysis, work estimations, design, development, testing and production support of QlikView reports
• Developed different dashboards with complex database system which included extracting data from the database, storing into QVD files, write load scripts and develop UI according to user requirements.
• Rebuilt dashboard applications on both front-end and back-end UI, developing scripting template, UI design and coding standards, design guidelines, migrations strategy and implementation plan.
• Connected to different ODBC, OLE DB data sources (SQL server) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.
• Implemented Incremental Loads, Optimized Loads & Binary Loads for required scenarios.
• Created variables, triggers and logic to make dynamic dashboards.
• Removed synthetic keys, ambiguous relationship and circular loops.
• Developed link tables, concatenation and solved loop issues
• Experience in designing different types of charts such as Bar charts, Line charts for Trend Analysis, Straight Tables, Pivot Tables, Pie charts etc.
• Used QMC to perform different tasks like schedule, reload and distribution.
• Built self service analytics(Adhoc) for different dashboards.
• Effectively scheduled QVD and Dashboard reloads on server and eliminated errors and failures using troubleshoots.
• Design, Build, Test, Debug the QlikView application in QV Test server environment.
• Prepared the test cases for System Integration testing and User Acceptance testing.
• Worked on Performance testing of Dashboard and also data validations using independent queries.
• Prepared the technical manual for the end users illustrating the back end information regarding relative tables and fields based on the application they use.

Confidential, NYC

BI Developer, QlikView

Environment: QlikView 11.2, SQL Server 2008/2010, MS Access, Windows 7, SQL Programming

Responsibilities:

• Involved in scripting/Designing of the project.
• Data Fetch from different sources like Xml, SQL, MS Access
• Creation and Loading of QVD & Dashboard creations
• Developed Dashboards pertaining to Revenue and Sales monitoring using QlikView 11.2.
• Managed company-wide system of QlikView BI solutions to ensure optimization of both data models and front-end UIs.
• Roles and responsibilities include developing, enhancing, re-engineering, maintaining and supporting QlikView applications
• Defined KPI visualizations based on user requirements and related data points on various lines of business; creates detailed and summary reports for executive review
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks.
• Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in the scripts.
• Used QlikView Scripting and Complex SQL coding for loading, and transforming.
• Created Set Analysis for Comparison analysis eliminating additional complex coding.
• Designed and developed the incremental loads where applicable.
• Produced graphs and visuals using charts and pivot tables to summarize data, identify outlying data points, and perform other exploratory data analysis
• Maintained both File and Data Level Security and implemented Data Reduction.
• Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques.
• Published Client application using QlikView Publisher and rolled out to Shared Drive with security permissions using Active Directory features.
• Experience with QlikView Enterprise Management Console.

Confidential

QlikView Developer

Environment: QlikView 11, SQL Server 2008/2010, MS Access, Windows 7, SQL Programming

Responsibilities:

• Responsible for data analysis and documentation.
• Worked with the Business Managers in procuring and defining the requirements for developing the application.
• Performed requirements gathering, including KPI selection and BRD development.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Multi Box and Calendar.
• Implemented advanced scripting techniques such as set analysis, VBscript macros, aggregation functions and advanced charts for applications.
• Analyzed requirements, design functional and technical specs from documentation of Qlikview application requirements from end users
• Managed Qlikview reporting environment that is the QlikView Server, Qlikview Publisher.
• Developed user interactive sheets and reports as business needs and for writing SQL scripts to load the relevant data in QlikView applications.
• Designed and developed scripts to support UI visualization, ETL processes, automation, workflow and dashboard presentation framework
• Extracted data from the database, stored into QVD files, and wrote load scripts.
• Connected to different ODBC, OLE DB data sources (SQL Server) and flat files to create and schedule different complex reports.
• Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Designed proficient dashboards according to the requirements.
• Established a secure environment using Qlikview Section Access.
• Developed complex Qlikview scripts to build model, to support various KPI’s with time over time and trending analysis.

Confidential, NJ

BI Developer, QlikView

Environment: QlikView 10/11, Oracle 10g, Toad for Oracle 9.1, Windows XP

Responsibilities:

• Participated in user discussions to understand the user requirements, layout, and look and feel of the Dashboards to be developed.
• Worked closely with users to understand data sources and requirements to build the best data model for QlikView applications
• Developed different dashboard with a complex database system which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs
• Performing analytics as per the requirement using charts and tables.
• Developed various tabs with tables, bar charts, pie charts, etc. reflecting the current selections in the report using set analysis techniques
• Developed KPI’s and Set Analysis applications.
• Developed User Interactive Sheets & Reports as business needs.
• Involved in Performance Tuning of QlikView dashboard.
• Manage daily QlikView jobs that update QVD files and Dashboards.
• 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.
• Created QVD generator load scripts.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Created data model in QlikView desktop to get all the data in required format. Used Mapping tables, Apply Map, Resident Load, Concatenate, and so on.
• Implemented section access which allows user to see by default their Region’s data and population attached to a particular Region
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Performed analysis, documentation, for calculation for various attributes.

Confidential, Colorado

SAP ABAP-HR Techno Functional Consultant

Environment: SAP R/3 ECC 6.0

Responsibilities:

• Analyze and Design Phase: analyze and design business processes and application Requirements to implement SAP PA and OM modules.
• Organization structure for branches departments, jobs, positions and tasks.
• Created enterprise structure by defining the personnel areas, sub areas, and subgroup groupings for employee group and subgroup.
• Responsible for setting up of work schedule rules and generate monthly work schedules.
• Defined attendance, Absences, substitutions, overtimes and availability as per the client requirements.
• Configured Payroll Procedures using IMG by defining the parameters of payroll module - payroll periods, period modifiers, date modifiers and payroll past period etc.
• Help in defining how country- specific legal requirements can be managed through SAP HR.
• Participated in the configuration effort for Personnel Administration and Organizational Management.
• Coordinate with the other Project Leader to communicate HR integration points with other SAP main modules.
• Involved in post Go-Live support
• Resolved issues related to US Payroll and Time Management.
• Modified SAP Standard reports according to client requirements.
• Participating Teleconference and technical discussions with the Client.
• Coordinating with the onsite team in resolving the issues.

Confidential

SAP HR Consultant

Environment: SAP R/3 ECC 6.0

Responsibilities:

• Maintained Employee master data.
• Documented the process, reviewed, and training of end-users.
• Maintained personal data, organizational data, basic settings PA40 for hiring of employees and responsible for hiring actions, creating new personal actions, personal data org- assignment, planned working time and basic pay.
• Involved in unit testing for various master data and personnel actions.
• Worked on Employee master data and maintaining number ranges for personnel numbers.
• Created enterprise structure by defining the personnel areas, sub areas, sub area groupings, employee group, and subgroup groupings employee group and subgroup groupings.
• Defaulting features ABKRS, TARIF, LGMST, specified Allowance Grouping, Payroll Calendar Generation, Date Modifiers, Control Record setup.
• Defined public holiday calendar for personnel sub areas
• Defined employee groups and subgroups with respect to time management: subgroup grouping for work schedule rules absence counting, absence counting
• Generated payroll accounting areas and their corresponding control records
• Resolved the HR Interface issues.
• Developed Interface for Export Applicant Wise Employee IDs to New joins from HR online (Dot net) to sap using dot net connecter.
• Developed SAP HR Interfaces for leave creation, leave cancellation and recruitment.

Confidential

ABAP-HR Techno Functional Consultant

Environment: SAP R/3 ECC 6.0

Responsibilities:

• Implemented the basic HR system with searching and previewing the staff and their work schedules.
• Involved in basic payroll processing, Involved in setting up of the HR section for HR division.
• Maintaining personnel actions
• Configuration of holiday calendar and work schedule rules.
• Defined wage types and wage type characteristics.
• Defined pay scale types and areas for each personnel area.
• Time wage types and selection rules and time valuation with clock times.
• Integration of OM with PA.
• Customization of personal data like maintenance of residence addresses status, family addresses, bank details etc.
• Defined attendance, absences, substitutions and availability as per the client requirements.
• Developed absence reports for quota reporting.
• Reports were developed to display Claims.
• Developed Earnings and Deductions report.