SUMMARY

• A highly enthusiastic and motivated individual with a strong technical and business background and over 7+ years of professional experience in the areas of content management, data warehousing, business intelligence, and data and business process analysis.
• Strengths are requirements analysis, data transformation and synchronization (ETL), business reports generation, and systems configuration management. Also have successful experience in eliciting, analyzing, and documenting the requirements for business processes, policies, and information systems.
• Worked as a liaison among business stakeholders to understand business problems and opportunities in the context of requirements and recommend solutions.
• Over 7+ years of experience in IT Software Development Life cycle involving Business Requirement Analysis, ETL, Data Modeling, Development and Implementation of Data Warehousing principles and Architecture, and Database Business Systems
• Expertise in ETL (Data Extraction, Transformation & Loading), Data modeling, Report and Performance Tuning using QlikView.
• Used Qliksense to generate immediate analyses and insights for reporting from mobile platform.
• Expertise in working with Data Warehousing and business intelligence tools for developing various reports using QlikView BI.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back - end testing and strong Database Development skills using SQL Server 2008
• Capable of gathering Requirement Specifications, performing Requirement Analysis
• Strong working knowledge of QlikView scripting, Set analysis, aggregation functions, multi-dimensional objects and layout including chart properties and formats.
• Strong knowledge in basic components of QlikView Enterprise like List Boxes, Multi Boxes, Tables, Charts, Current Selection Boxes, Buttons, Containers etc.. And experience in editing scripts for creating variables, fields, and calculated expressions, basic and aggregated functions.
• Experience in optimizing existing QlikView reports with a focus on usability, performance, flexibility, testability, and standardization.
• Develop of QlikView applications using QlikView Data (QVD) files, different Databases and creating reusable variables.
• Trained the end users effectively to use the reporting tool (QlikView), to build and customize their ad-hoc reports.
• Used QlikView publisher to schedule data load, distribute QlikView application, and manage security and access through Active Directory integration.
• Experience in monitoring, debugging and troubleshooting BI Solutions
• Experience in creating ETL Applications for QVD’s and QlikView Scripting variables and File, Date, System, Mapping and Table functions.
• Expertise knowledge in Set Analysis, Advanced aggregations, synthetic keys and circular references.
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI’s, Custom requests for Excel Export, Fast Change and other objects for Management Dashboard reporting.
• Experience with QlikView Management Console (QMC).
• Proven ability to work effectively in a team environment and capable of learning new technologies and adapting to a new environment quickly.
• Ability to work in tight schedules with high quality and efficient in meeting deadlines.
• Strong experience in understanding Business Applications, Business Dataflow and Data relations; Exception ability to quickly master new concepts and capable of working in-group as well as independently.
• Excellent communication, presentation, interpersonal, intuitive, analysis and leadership skills.

TECHNICAL SKILLS

BI Tools: QlikView 11.0 /10.0/9.0/8.5 , Cognos, SAP Business Objects 4.0, Crystal Reports

Languages: SQL, PL/SQL,T/SQL, C,C++

Databases: MS Access 2000, DB2, MS SQL Server 2005,2012 and Oracle, Excel & CSV Files

ETL TOOLS: Informatica Power Center, SSIS, SSRS, Data Services

Operating systems: Windows 2003, Windows XP, 7/8,Ubuntu,Unix

Project Methodologies: RUP, Waterfall, Agile (SCRUM)

Domains: Financial, Banking, Healthcare, Services, Retail

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

QlikView Developer

Responsibilities:

• Understanding the requirements from the business users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Work directly with business users to define and prototype Qlikview Applications.
• Work with senior management to plan, define and clarify dashboard goals, objectives and requirement.
• Design, Develop, Test, debug and implement Qlikview solutions based upon specified requirement.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Developed KPI’s and set analysis applications.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc...)
• Extract, transform and load data from multiple sources into Qlikview applications.
• Implemented Security & involved in Deployment of Qlikview Applications.
• Developed Macros, SET ANALYSIS to provide custom functionality in Qlikview Applications.
• Create PDF push reports using Qlikview report editor.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins
• Developed User Interactive Sheets & Reports as business needs.
• Created Dashboards style of reports using Qlikview components like List Box, Slider, Buttons, Charts and Bookmarks.
• Performed architecture redesign of QlikView BI platform running 60+ dashboards that improving availability, scalability and performance to accommodate high-volume data
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Implemented Star & snowflake schema (confirmed dimensions).Writing SQL Scripts to load the relevant Data in Qlikview Applications.
• Developed Macros, SET ANALYSIS to provide custom functionality in Qlikview Applications.
• Experience in using Qliksense to generate immediate analyses and insights for reporting and work collaboratively in both office and mobile platform.
• Design, Build, Test, Debug the Qlikview application in QV Test server environment.

Environment: QlikView11.2, QlikView Server/Publisher, Oracle 10, Business Objects, MS-excel, Windows Server 2008.

Confidential, Phoenix, AZ

Qlikview Developer

Responsibilities:

• Requirements gathering from the business and application teams
• Created Project Management and Business Requirements Document (BRD) and created test cases and memory foot print (RAM usage) for few applications. Set up NPrinting for distribution of Reports.
• Code deployments from development to stage and production environments
• Involved in Scrum calls daily with architects, designers, developers, QA and the customer/users.
• Creating QlikView Applications using qvd files from user analytical/Business purpose.
• Served as QlikView application developer for various ad-hoc analysis requests.
• Developed data models based on the client requirements and without any ambiguous or Synthetic tables.
• Re-use the existing QVDs, new tables as QVDs and scripts to generate appropriate fields that help in modeling the data according to the requirements.
• Develop dashboard using the various sheet objects Current selection, list boxes, search, Straight table, Pivot table, Bar chart, Line Chart, Pie Chart, Combo chart and so on.
• Demo of QlikView dashboard to users to enhance their knowledge on all the key capabilities of Distribution QlikView application
• Worked on Automation & scheduled QVW document refreshments using QlikView Publisher and use of external OPSWISE tool as a scheduler.

Environment: QlikView 11, SQL Server 2012, Oracle 10g, Windows Server 2003, Windows XP.

Confidential, Windsor, CT

Qlikview developer

Responsibilities:

• Developed complex multi-sheet QlikView applications incorporating show hide functionality, set analysis, lists boxes, multi boxes, pivots tables, straight tables, sliders, buttons, cyclic and drill down groups, input variables, pass through and transfer state functionality,
• Developed QlikView OLE DB and ODBC data loading strategies including buffer loads, QVD’s, resident, binary loads, mapping, inline tables, concatenations, and renaming.
• Created QlikView formulas, functions, event triggers and variables.
• Provided ongoing maintenance and support to existing QlikView documents.
• Using formulas, variables, cycles, conditions, recipients, vlookup, tasks and scheduler, developed reports used to provide printable legal financial reports.
• Published developer and users process and procedures guides.

Environment: QlikView 10/9, My SQL, Windows Server 2003, Windows XP, Microsoft Visio.

Confidential, Milwaukee, WI

Business Analyst/BI

Responsibilities:

• Business Analyst in application projects that involved data migration, internal integration, and 3rd party integration.
• Documented and presented business requirements using traditional business requirement documents, wireframes, and prototypes which allowed stakeholders to experience the application changes prior to development while working with stakeholders and developers to determine project scope and deployment timelines..
• 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
• 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 utilizing QlikView solutions to develop complex reports and executive dashboard.
• Create and manage ETL script generation using QlikView Script.
• 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.

Environment: QlikView 10/11.0, Windows 2003 Server/XP, MS SQL Server, QlikView Server/Publisher 10 SR3, Oracle 10g, MS Access 2007, MS Excel 2010

Confidential

Business Analyst/BI

Responsibilities:

• Involved in requirements gathering and worked on Functional and Technical Detail Design based on the Business Requirements.
• Exposed and worked on Agile Processing, which have multiple sprints in parallel.
• Involved in multiple scrum meetings to reach the deadlines and attended daily stand up meetings.
• Extracted data from multiple sources and loaded the data in to SQL server box using SSIS.
• Performed Data extraction, Cleansing, De-duplication, Standardization, Conversion and transforming and loading the data in to SQL Server.
• Responsible for all activities required to ensure data integrity of data base in production environments, in line with the requirements.
• Accomplishment: Twice Received Performance awards as "Employee of the month”

Environment: Microsoft Visio, MS SQL Server 2005/2000, SQL Server Integration Services (SSIS), SQL Server Reporting, Windows XP, MS Excel.

Confidential

Business Analyst/BI

Responsibilities:

• Wrote the “Business Requirements/System Design “documentation to automate their Dialer system for their point-of-sale web based system
• Worked heavily with the off-shore development teams and the SMEs to get the business rules and UAT, System, and Integration testing
• Execute data mining, data cleansing, data profiling and data mapping of key data elements of their non-integrated systems
• Worked heavily doing SQL scripts and MYSQL for analysis
• Created and executed SQL statements in both SQL production and development environments
• ETL deployment with AGILE methodologies working with the off-shore developers to get it into the weekly sprints.
• Worked quite heavily with SSRS and Micro Strategy for reporting
• SAS for analytics of the data; along with using SQL queries to bring the data into Microsoft Access database.

Environment: MS SQL Server 2005/2000, SSRS, SAS, SQL Server Reporting, Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.