SUMMARY:

• Over 8+ years experience in IT industry in the field of Business Intelligence such as SSRS and Data visualization such as Qlikview for Healthcare, Banking and Financial institutions.
• 5+ years experience providing End - to-End Solutions using Qlikview from Requirement gathering to Final deliver
• Strong analytical database design and DataModeling (Star Schema, Snow Flake Schema) skills in QlikView.
• Experience in MS SQL Server (BI) and SQL Programming.
• Good Understanding of Relational and Dimensional Database Concepts.
• Excellent understanding of data warehouse specific Architecture, Design and Procedures, ETL and workflow development, data cleansing, data quality validation and unit testing.
• Expertise in QlikView 11.0 SR1/10.0 SR3 installation and upgrading existing version.
• Expertise in designing in QlikView with complex multiples data sources (SQL, Flat Files) relational designs and optimizing applications by using QVD's, removing non-key fields and script variables (Loading phase).
• Developed User Interactive Sheets & Reports as business needs.
• Developing SQL Scripts to load the relevant Data in QlikView Applications.
• Developed set analysis to provide custom functionality in QlikView Applications
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Data Island
• Experience with QlikView sheet 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.
• Experience in creating ETL Applications for QVD's and QlikView Scripting variables and File, Date, System, Mapping, and Table functions.
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional Implemented Best Practices & Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys in QlikView and designing an optimized Data model.
• Developed link tables, &incremental loadingOptimized Load & Binary Load on the needed basis.
• Proficient experience in working with QlikView Functions and Expression Scripts and Streamlining Reporting operations of QlikView Applications
• Design of QlikView applications using QlikView Data(QVD) files, different Databases and creating reusable variables.
• Proficient in SET ANALYSIS to provide customized functionality in QlikView Applications.
• Worked on FI, SD, MM, OPS,HCM/HR and CRM Data sources and also used BI content HCM cubes for reporting.
• Exposure to Strategey Management Tool. Involved in creating Dimensions, Measures for PAS, Scorecardand Initiatives.
• Extensively involved in analyzing, creating requirements and developing advanced Xcelsius Dashboards and WEBI reports for business users in Marketing, Sales, Finance and Operations. Expertise in advanced Excel programming for analytical models and Xcelsius dashboards. Achieved data acquisition using QAAWS, Live Office, XML Data connection and Flash Variables.
• Also worked with business areas like PLM, xRPM-PPM, Supplier Portal.
• Created and Build BIA indexes for the Cubes for NW2004s.
• Experience in developing Statistical Queries from the new Technical Content in BI 7.0.
• Worked extensively on APD (Analysis process Designer).

TECHNICAL SKILLS:

BI Tools: QlikView 9/10(SR3/4)/11.2(SR2), Tableau.

Data bases: Oracle9i/10g/11g, SQL Server, Teradata, MySQL, DB2

Database Tools: SQL * PLUS, Toad for Oracle Base (10.6.1.3)

ETL Tools: Informatica, Data Stage, MSBI

Office Tools: MS Word, Excel, Access, Outlook, Power Point

Operating Systems: Windows/XP/2002/2003/7, Unix.

PROFESSIONAL EXPERIENCE:

Confidential, Secaucus, NJ

Sr. QlikView Developer

Responsibilities:

• Involved in the Requirements gathering, analyzing, and documenting business requirements and data specifications.
• Understanding source systems and Designing Data Modeling and Loading data from Multiple Data sources.
• Connected to Oracle using OLE DB and ODBC data sources connector and tables.
• Created POC to the client based on their requirement.
• Developed SQL Scripts, database objects, procedures, functions and packages.
• Designed and developed extensive QlikView reports using combination of charts and tables.
• Developing Set Analysis to provide the custom functionality in QlikView Applications.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources like SAP BW, Sales force, Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships.
• Mainly designed and developed QlikView software applications and complex server-based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives.
• Created link tables on the needed basis and as per the data.
• Created Master Calendar and worked with date fields as per the user needs.
• Applied mapping function to look up and fetch the required field
• Used advanced scripting, set analysis, VBScript and JScript macros, advanced aggregation functions and advanced charts for applications.
• Creating complex expressions for dynamic aggregation and Actions and triggers, Document Chaining & linking experience.
• Hands on experience to leverage mapping GIS providers in QlikView for multi-layer maps and data source integration and advanced GUI development in Qlikview.
• Designed a comprehensive and easy to use Mortgage analysis dashboard for client to keep track of Sales representative performance, and efficiency of converting customer leads into revenue and Optimization of data model for performance.
• Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Developed link tables, & incremental loading on the needed basis.
• Published dashboards on Access point. Deployed QVW’s on the production server, Created Reload and Distribution tasks on QlikView Server/publisher.
• Extensively implemented section access for row, object, column and sheet level security.
• Automated QlikView jobs in QlikView Publisher and rolled out to QlikView Access Point and administered Security using Active Directory.
• Wrote SQL Scripts to load relevant data in QlikView Applications.
• Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team.

Environment: QlikView 10/11.0/11.2, Oracle, SQL Server, Informatica Power center, Toad /PLSQL Developer, SQL Loader and Sun Solaris.

Confidential, Redmond, TX

QlikView Developer

Responsibilities:

• Conducted Business meetings with Users to gather Requirements in creation of data model & reports.
• Gathered data from data sources such as QVD files and Excel in developing the QlikView Data Models.
• Extensively used QlikView Functions (Joins, Concatenate, Keep, Apply Map etc) in creation of QlikView application.
• Designed & Developed QlikView applications.
• Resolved synthetic keys and circular loops in QlikView Data Models.
• Developed various charts including Bar charts, Straight Tables, Pivot Tables, Pie charts and Radar chart.
• Created different types of sheet objects like List boxes, Buttons, Multi-box etc.
• Extensively used Variables when necessary to meet customer requirements.
• Implemented document event trigger and field event triggers is created.
• Incremental reloading is implemented.
• Handling user security using section access.
• Moved the application to the production server.
• Created tasks in Publisher for the application from making the QVD’s to the whole application reload.
• Give production support to the existing applications.

Environment: QlikView 10 SR2 Desktop/11, QEMC, Teradata SQLConnector, Oracle 10G, Windows 7, Windows Server 2008, Teradata, Flat files.

Confidential, New York, NY

QlikView Developer

Responsibilities:

• Requirement gathering for various users, interviewing them, and satisfying their exact needs.
• Involved in the completeLife cycle of the Project and in thedata analysis process
• Gather the various requirement matrices from the business analysts.
• Worked with Master Data Management.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Involved in Performance Tuning of an QlikView Applications
• Created Inline tables to load data manually to QlikView.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using QlikView Publisher and notified load status by email.
• Handled data coming from multiple fact Tables by creating link/Key tables.
• Utilized Interpretation & formatting Date functions to generate master calendar.
• Created dashboard style of layouts using various components of QlikView like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Developed Macros, SET ANALYSIS to provide custom functionality in QlikView Applications.
• Implemented Security & involved in Deployment of QlikView Applications.
• Conduct Design reviews with the business analysts, content developers and DBAs to ensure the feasibility of the designs.
• Used Erwin for developing data model and forward engineer the data model.
• Reverse engineer the data base in to physical data model by using Erwin.
• Developed entities and relationships using Sybase Power Designer.
• Developed Data Migration and cleansing rules for the integration architecture.
• Developed data mapping documents between legacy, production and user interface systems.
• Designed different type of STAR schemas like detailed data marts, Plan data marts,
• Used Erwin for monthly summary data marts and inventory data marts.
• Designed ER Diagrams, star schema and snow flake schema.
• Created and modified of Attributes, Facts, Metrics, Filters and other report objects.
• Conducted data validation testing to ensure data quality.
• Active Participation in checking the data at database level and at SSRS level in case of displaying wrong data.

Environment: Informatica, QlikView, Cognos, Power Designer, PL/SQL, Oracle9i, TOAD, UML, Microsoft Office Suite ( Word, Excel, Power Point, Visio).

Confidential, Rye, NY

Sr. QlikView Developer

Responsibilities:

• Involved in the Requirements gathering, analyzing, and documenting business requirements and data specifications.
• Understanding source systems and Designing Data Modeling and Loading data from Multiple Data sources.
• Developed SQL Scripts, database objects, procedures, functions and packages.
• Designed and developed extensive QlikView reports using combination of charts and tables.
• Developing Set Analysis to provide the custom functionality in QlikView Applications.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources like SAP BW, Sales force, Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC
• Working closely with the Business users to get the requirements for managing Qlikview Server and publisher.
• Extracted information from different data sources like Oracle, Teradata and flat files, etc…by using different scripts like add, concatenate, resident, qualify, unqualify, etc.
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Writing and tuning of PL/SQL code like Procedures, Functions, Database Triggers, Packages and SQL queries to improve the application and reports performance.
• Modifying existing PL/SQL code in Packages, database triggers, procedures and functions to add new functionality according to the requirements.
• Participate in enterprise DW / BI strategy/Dash boarding.
• Involved in utilizing Qlikview solutions to develop complex reports and executive dashboard.
• Involved in administration using Qlikview server using Task Management, Resource distribution and Job Scheduling.
• Created Architectural Conceptual documentation and Technical Specification Documents.
• Involved in organizing meetings to know the needs of clients for the Enterprise solution Implementation.
• Involved in design and development of QlikView Platform integrated with Expandable Databases
• Modified existing production reports to in corporate weighted average sales data.
• Created report context calculations to satisfy client's long-standing report requirement.
• Researched and fixed erroneous report calculations.
• Coordinate with Production Support team to develop accurate documentation for production reports.
• Built and modified reports to enable manual and scheduled data refresh.
• Provided reporting to development team and business staff.

Technologies Used: QlikView 10 SR2 Desktop/11, QEMC, Teradata SQLConnector, Oracle 10G, Windows 7, Windows Server 2008, Teradata, Flat files.

Confidential

ETL Developer

Responsibilities:

• Analyzed business requirements by interacting with the business users and application development teams
• Designed and developed the ETL architecture to build and populate the data marts using Informatica
• Designed and developed Informatica mappings for data loads that included Source Qualifier, Aggregator, Joiner, Lookup, Filter, Router, Update Strategy, Expression and Sequence Generator transformations.
• DevelopedETL mappings,transformationsusingInformatica Power Center
• Designed Parameter driven Informatica sessions and workflows for extracting, cleansing, transforming and loading the data from the heterogeneous sources into the data warehouse by using parameter files.
• Worked with complex Cognos reports in Report Studio using master-detail relationship, drill through, drill up and drill down, burst options, and Prompts.
• Implemented SCD Type 2 strategy to update the Slowly Changing Dimensions and maintain the OLAP tables storing history in the data mart star schema
• Developed Informatica mappings to cleanse and remove duplicate rows from source data
• Programmed Oracle SQL, T-SQL Stored Procedures, Functions, Triggers and Packages as back-end processes to create and update staging tables, log and audit tables, creating primary keys
• Used workflow manager for session management, database connection management and scheduling of jobs
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Performed Unit Testing and assisted QA team in Quality Assurance Testing, Load Testing and UAT,Performance estimation testing
• Ensured the execution of UAT test cases and documentation of test results.
• Analyzing business and functional requirement to design SIT and UAT Test Cases
• Prepared functional and technical specification documents for the ETL standards and strategy
• Developed views necessary for structured and ad-hoc reporting
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Handled Full load and refresh load via staging tables in the ETL Layer.
• Involved in Designing ERD using Star schema.
• Involved in Design and Data Modeling using Star schema.
• Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize, and monitor ETL process.

Confidential

ETL Developer

Responsibilities:

• Developed various kinds of mappings by using different transformations like Source Qualifier, Expression, Filter, Router, Lookup, and Update Strategy for populating target table in efficient manner.
• Written SQL overrides in Lookup Transformation to fetch according to business requirements
• Developed various Sessions, Batches for all Mappings for loading from Source flat files to Target tables.
• Used Workflow Manager to design Sessions, Decision, Event-Wait, Event-Raise and Assignment tasks to execute mappings.
• Used tuning of mappings to improve better performance.
• Implemented Slowly Changing dimension Type2 methodology for accessing the full history of accounts and transaction information.
• Involved in identifying the bottlenecks and performance tuning of the Informatica mapping
• Involved in Unit Testing as per specification.

Environment: Informatica Power Center 7.1.2, Toad, SQL Server 2005, DB2 7.2, Oracle 9i, SQL, Windows XP.