PROFESSIONAL SUMMARY:

• 8years of experience in Business Intelligence Tools (Qlikview, OBIEE), ETL Tasks and Data Warehousing.
• 2+ years of most recent experience in Qlikview Desktop, Qlikview Server & Qlikview Publisher in aspects of development, deployment and administration.
• Ability to offer end - to-end solution starting from requirement gathering, design, development & deployment of Business Intelligence applications. Experienced with Agile Development Methodology in providing quick analysis and visualizations for business users.
• Expert in extracting, transforming, analyzing, visualizing, and presenting data from diverse business areas in novel and insightful ways to enable Directors, Vice Presidents, and CEOs to take informed action.
• Hands on experience with integration of Hadoop, Teradata & other Big Data technologies with Qlikview.
• Experience with QlikView 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.
• Created QVD’s & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Involved in Optimizing existing QlikView dashboards with a focus on usability, performance, long-term, flexibility, and standardization.
• Experience in working with Qlikview extensions such as Quick Map, Word Cloud, Word Map.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Qlikview.
• Experience running complex and high volume ETL processes.
• Excellent working knowledge in Data Warehousing Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
• Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys & Modeling Issues.
• Expertise in optimizing, Debugging and testing SQL queries.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.
• Attention to detail & ability to work in a pressurized time sensitive environment.

TECHNICAL SKILLS

Business Intelligence Tools: QlikView10.0/11.2, OBIEE 4.0, Crystal Reports, Tableau, Qlik Sense

Languages: SQL, PL/SQL, C, Java

Database Technologies: Oracle SQL Developer 3.0.04, Oracle11g/10g, MS SQL Server 2012/2008, Teradata14/13x, Netezza, DB2

Operating Systems: Windows HyperV, Windows 7/8, Cent OS, Ubuntu,, Unix Shell Scripting

Domains: Financial, Banking, Healthcare, Services, Manufacturing, Social Media

Big Data Tools: Cloudera, Hortonworks, Hive,Hadoop

Programming GUI: Unix, Putty 0.63, WINSCP 5.1.7

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and dimensions tables, Physical and Logical Data Modeling

Methodologies: SDLC, Agile Software Development, Six Sigma Implementation, Business Intelligence best practicesEDUCATION

PROFESSIONAL EXPERIENCE

Confidential MI

QlikView Developer

Responsibilities:

• Designed & developed QlikView dashboards for Operations & Marketing business groups.
• Involved in full project life cycle implementation (requirement gathering to production) of QlikView dashboards.
• Used Publisher and Server to automate the reports to perform Reload, Reduce and Distribute QlikView Application.
• Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team.
• Connected to different various data sources like Hive, Spark Oracle, SAP BW and flat files to create and schedule different complex reports.
• Hands on retrieving of external data to QlikView Dashboard in terms of QVDs by making connection through ODBC and OLEDB.
• Developed QlikView Dashboards using Chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box and Calendar & Date Island.
• Using QlikView functions such as Date and Time, Keep, Join, Mapping, String& input Fields etc.
• Designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Working experience with SQL/Server T-SQL, SSIS and SSRS (MSBI).
• Working on Microsoft Excel, Access to automate the process by creating/modifying Macros as per the requirements
• Conducted User Acceptance Testing as part of SDLC process.

Environment:SQL Server 2008 R2, Excel, Windows Server 2008, QlikView 11.2 sr2, Hive, Hadoop.

Confidential, Chicago, IL

QlikView Developer

Responsibilities:

• Designed & developed QlikView dashboards for Distribution, ShippingOperations& Marketing business groups.
• Involved in full project life cycle implementation (requirement gathering to production) of QlikView dashboards.
• Connected to various data sources like Oracle, SAP BW and flat files to create and schedule different complex reports.
• Hands on retrieving of external data in terms of incremental loading of extract scripts for QVDs by making connection through FTP, ODBC and OLEDB.
• Sound understanding of relational, object and dimensional databases.
• Developed QlikView Dashboards based on DAR(Dashboard Analysis & Reporting) principle using Chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box, Calendar, Date Island etc.
• Using QlikView functions such as Date and Time, Keep, Join, Mapping, String& input Fields etc.
• Identifying Key Performance Indicators and metrics.
• Created Ad-Hoc report generation functionality in Qlikview applications adding flexibility to end users analysis.
• Working experience with extensions such as QuickMap for deploying geographical location based metrics.
• Identifying opportunities to employ Qlikview solutions to meet customer reporting requirements.
• Designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Designed Qlikview applications of various resolutions for IPad and LCD Screen displays using Flat UI Design and monochrome colors.
• Checking of supplied data for sense, consistency and accuracy.
• Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team.
• Documenting work processes, establish procedures to ensure reliable production of reports, transfer knowledge to other reporting team members.
• Conducted User Acceptance Testing as part of SDLC process.
• Participated in daily scrums meeting and sprint cycles.
• Strong team player working on all the areas of the project.

Environment:Oracle Client 11g, Excel, Toad for Oracle 11.6, QlikView 11.2 SR7

Confidential, North Carolina

Cognos BI Consultant

Responsibilities:

• Effectively partnered with finance customers; ensured consistent and accurate flow of the information from business project sponsors to application/database developers.
• Communicated with business users, business analysts to analyze, design, developed the Cognos reports, dashboards, and DMRs.
• Implemented dimensional modeling and star schema grouping in Framework managers from a Cognos planning database.
• Developed using Report Studio, advanced functionalities such as building complex prompt pages, render variables; parameters and parameter passing, master-detail, drill downs vs. drill through, various calculations, union and join queries and generated and troubleshooting report SQL.
• Worked extensively on various report layouts such as chart, list, crosstab and repeater for presenting the data in efficient manner in Report Studio.
• Performed data analysis for verifying Regional Data Warehouse (RDW) data, by generating and comparing reports from RDW with reports from existing legacy systems.
• Created the data level security for various objects like PandL, market summary, and Fact Query subjects in the Cognos Framework mangers to restrict users to access the level of data.
• Involved in the generation of different reports for different sets of data to target customer segments, in order to slice and dice and drill-through data for multidimensional OLAP analysis.
• Prepared end user documentation on models, packages, and reports for end users that help in using the developed reports and build ad-hoc reports using Query Studio.

Environment: Cognos 8.2 and 8.4 (Framework Manager, Cognos Connection, Report Studio, Query Studio), Cognos Planning, PowerPlay Transformer 7.3, PowerPlay Enterprise Server 7.3, Oracle 9i, TOAD, HTML, JavaScript

Confidential

Cognos Developer

Responsibilities:

• Created Framework Manger Models and created and published packages into the portal.
• Created Standard Reports using Report Studio and Ad- Hoc Reports using Query Studio.
• Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
• Created standard and Ad hoc reports using Cognos Impromptu Designed catalogs and defined User Classes, Security and Privileges.
• Created Multi-dimensional reports by implementing Multi-Dimensional Cubes using Power Play and Transformer.
• Provided security for Cubes of various User classes. Used Date Wizard to create time dimension in Transformer for creating cubes and Power Play reports.
• Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
• Created Impromptu Web Reports and published them on the web server and later on upfront.
• Created News boxes in Upfront and customized the environment. Set Security for News Item and New boxes in Upfront. Set Privileges for user classes by defining News Index Admin

Environment: Oracle 9i, Cognos 8.1, Cognos ReportNet1.1 MR3 (Framework Manager, Cognos Connection, Query Studio, Report Studio),Cognos Impromptu Admin/User, Power play Transformer, Power play for Web/Windows, Cognos Report net 1.1, Windows 2000