Candidates About

 

Sowmya

 

 

                                                          

                                                                                     

 

PROFESSIONAL SUMMARY:

 

·         8plus years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing /Decision support systems and Business Intelligence. 

·         Expertise in designing and modeling of QlikView Applications using QlikView with complex multiple data sources (SQL, Oracle, Flat Files, Excel and Access) relational designs. 

·         Expertise in working with   QlikView Desktop,   QlikView Enterprise Management Console (QEMC), QlikView Publisher, QlikView Web Server. 

·         Good working knowledge in all components of QlikView and interaction on Server and Publisher. 

·         Experience with   QlikView sheet objects including Pivot, List and Multi box, multiple chart types, Trends, KPI's, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting. 

·         Strong working knowledge of QlikView scripting, Set analysis, aggregation functions, multi-dimensional objects, layout and design including chart properties and formats. 

·         Strong understanding in creating Dashboards and scoreboards for the required KPI's in QlikView. 

·         Extensive experience in creating Pixel Perfect reports, Excel reports, Word reports, PowerPoint reports using NPrinting designer and automating the jobs in NPrinting Server. 

·         Hands on experience in customizing the QlikView, Qliksense and NPrinting reports as per the business requirements. 

·         Experience in designing QlikView Document/User Setting Layouts to make consistent and professional optimized look to clients. 

·         Proficient in migrating reports from different platforms (such as Excel, Crystal reports) to QlikView. 

·         Experience in database design & development, database programming, data modeling, business process analysis, and application development. 

·         Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC). Experience in Planning, Analysis, Design, Implementation and Maintenance using QlikView.

·         Strong experience in UI Design by using different  QlikView and Qliksense sheet objects including multiple charts types, Trends, KPI's, custom requests for Excel Export, and Fast Change. 

·         Ability to work in role mapping. 

·         Experience in1 tier, 2tier as well as 3 tier architecture of the QlikView.

·         Good expertise with the development and design of QlikView and Qliksense applications. 

·         Experiences on Subject Matter Expert

·         Good usage of Tableau JavaScript API for performance improvement of web page.

·         Extensive Tableau Experience in Enterprise Environment and Tableau Administrator. Experience including technical support, troubleshooting, report design and monitoring of system usage.

·         Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.

·         Involved in creating dashboards by using Level of Detail concept (LOD’s).

·         Implemented Tableau/Oracle BI security at the Data (Data security) and Object (Roles and Permissions) security.

·         Hands on experience in ADLA/ADLS, ADW and ADF

·         Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse

·         Experience in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads. 

·         Developed and scheduled reports using NPrinting tool and also implemented user security for the reports. 

·         Experience in working with Data Warehousing and business intelligence tools for developing various reports using QlikView.

·         Expertise in Installing and Configuring QlikView Desktop, QlikView Server and  QlikView  Publisher. 

·         Experience in writing SQL queries, Functions, Views and Stored procedures. 

·         Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.

·         Expertise in Installing and Configuring Qlikview Desktop, Qlikview Server and Qlikview Publisher. 

·         Experience in data modeling, data loading, data migration, data analysis.

●     Performed different types of loads Incremental Load, Optimized Load & Binary Load.

·         Strong skills in providing custom functionality using Macros, Triggers, Set Analysis.

·          Worked in close association with customers for requirement gathering and effective analysis. 

·         Performed different types of loads Incremental Load, Optimized Load & Binary Load. 

·         Experience in development of ETL scripts for Data Modeling along with resolving Synthetic Key and Circular Loop issues.  

TECHNICAL SKILLS:

 

 

 

PROFESSIONAL EXPERIENCE:

 

  Ally financial – Philadelphia, PA                                                                                  Nov 2016 – till now

QlikView Developer

Responsibilities:

·         Involved in full project life cycle implementation (requirement gathering to production) of QlikView dashboards.

·         Planned, designed, and developed QlikView BI dashboards and data integration in a highly complex global services environment, interfacing QlikView.

·         Participated in Business Processes with the Business Analyst to understand the requirement and Reviewed High Level Design Documents, Functional Specifications documents with the Technical Manager. 

·         Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMarts.

·         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.

·         Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).

·         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 advanced scripting, set analysis, VBScript macros, advanced aggregation functions and advanced charts for applications. 

·         Evaluate the relevance of the data to support a specific investigation, to analyze, to determine the performance and sensitivity of the analysis, and to project next steps for refinement, or proxies to achieve the needed results.

·         Determine appropriate tools and methods for specific projects to identify networks, predict future threats, or isolate and evaluate threat scenarios.

·         Responsible for analyzing business needs to identify and propose solutions for business problems.

·         Typically defines business requirements in the context of Data visualization tool like Qlikview, the role includes below responsibilities but not limited to Design and development of reliable, flexible, scalable and responsive Qlikview Reporting solutions

·Work with BI team and other functional teams on solution designs, business warehouse strategy and end-to-end testing

·         Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models. 

·         Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island. 

·         Created QVD's & updated on timely basis as database updates.

·         Developed ETL Scripts while loading the data, resolving loops & ambiguity joins. 

·         Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users. 

·         Research and troubleshoot technical problems and provided ongoing  QlikView consultation to the development team 

·         Created tasks for the auto reload/using create task wizard via QMC for couple of applications and Batch files (on servers) and used them to auto reload the QVW's while automating the ETL process. 

·         Used Section access and Sheet access to make the application available to desired users. 

·         Created weekly PDF report distribution for a set of users using Loop and Reduce functionality in QV Publisher. 

·         Using QlikView and QlikSense functions such as Date and Time, Keep, Join, Mapping, and String & input Fields etc.

·         Using QlikView Maps to show the reports and dash board for good visualization to the managers.

·         QlikSense app performance optimization.

·         Designed the QlikSense Governance and development cycle.

·         Configured different QlikSense roles and attribute based access control

·         Successfully performed transition of knowledge from onsite to offshore team. 

 

Environment:  QlikView 11.2, QlikView Server / Publisher, QlikView Management Console, Toad, SQL Server, Windows Server 2008, SME

 

 

Novartis Pharmaceuticals – Sacramento, CA                                                            June 2015 – sep 2016

Qliksense Developer

Responsibilities:

·         Developed proof of concept to check the functional feasibility of the QlikView implementation. 

·         Strong understanding in creating Dashboards for the required KPI's in QlikView/QlikSense. 

·         Work directly with business users to define and prototype QlikView/QlikSense Applications. 

·         Work with senior management to plan, define and clarify dashboard goals, objectives and requirement 

·         Design, Develop, Test, debug and implement QlikView/QlikSense solutions based upon specified requirement.

·         Extract, transform and load data from multiple sources into QlikView applications.

·         Created QVD's & updated on timely basis as database updates. 

·         Deploy applications on production server and set up automated data reloads 

·         Developed QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.) 

·         Created Pixel Perfect reports, Excel reports, PowerPoint reports and Word Reports using NPrinting tool.

·         Determine appropriate tools and methods for specific projects to identify networks, predict future threats, or isolate and evaluate threat scenarios.

·         Work in teams that include intel analysts, data and visualization experts, and software developers.

·         Contribute to documentation validating reasoning, certainty, and completeness in synthesized information for technical validation as well as for briefings for CBP Officers.

·         Set Analysis in providing custom functionality to QlikView Applications.

·         Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String&Input Fields).

·         Created different publisher tasks like reload tasks, reduction tasks and distribution tasks using Qlikview Enterprise Management Console.

·         Gathered & loaded data into QlikView from various data sources (Sql server 2012, Oracle 10g, .CSV and excel files).

·         Monitoring of the QVS (Access Point), QVW's and user accounts for the usage of the applications.

·         Developed User Interactive Sheets & Reports as business needs 

·         Created Dashboards style of reports using QlikView/QlikSense components like List Box, Slider, Buttons, Charts and Bookmarks 

·         Support the identification and analysis of transnational criminal organizations, their future actions, and their methods.

·         Evaluate the relevance of the data to support a specific investigation, to analyze, to determine the performance and sensitivity of the analysis, and to project next steps for refinement, or proxies to achieve the needed results.

·         Developed extensively Alerts, Variables, Input boxes, calendar & Macros 

·         Implemented Star & snowflake schema (confirmed dimensions).Writing SQL Scripts to load the relevant Data in  QlikView/QlikSense Applications 

·         Developed Macros, SET ANALYSIS to provide custom functionality in QlikView Applications 

·         Testing Applications using review checklists, Data quality for Quality Assurance before delivering to the end users.

 

 Environment:  SQL Server 2008, Excel, Windows Server 2008, QlikView11.2, QlikSense

 

 

Prudential Finance - Frankfort, IL                                                                        March 2013 – April 2015

Tableau Developer

Responsibilities:

·         Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications. 

·         Worked in Orders management team and created BI solutions to business users.

·         Crated Dashboards/Reports for different Orders/Payment portfolios.

·         Involved in creating dashboards by extracting data from different sources (Data Blending).

·         Created interactive dashboard and applied filter, highlight and URL actions to the dashboard.

·         Performed type conversion functions when connected to relational data sources.

·         Ability to authoring on Tableau server by changing mark types and adding filters.

·         Administered user, user groups, and scheduled instances for reports in Tableau.

·         Monitored and maintained incremental refreshes for data sources on Tableau server.

·         Configured Cache settings which improved the performance of the reports and Dashboards.

·         Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

·         Developed interactive dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

·         Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.

·         Involved in reviewing business requirements and analyzing data sources from Excel/Oracle, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

·         Converted charts into Crosstabs for further underlying data analysis in MS Excel.

·         Reviewed basic SQL queries and altered for better performance in Tableau Desktop.

·         Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

 

Environment:  Tableau Desktop/Server 7.0/8.1, Oracle 10g, MS SQL Server 2008, Windows Server 2012, MS Excel/Access 2007

 

 

CVS Pharmacy, clevland, OH                                                                                             jan 2012 – sep 2012

QlikView Developer

Responsibilities:

·         Followed the agile pattern of working and work execution

·         Connected to multiple data sources such as Oracle, DB2, Flat files, Excel Spreadsheet’s and prepared close to business requirement like model. (Especially star model and snowflake).

·         Established a Standard structure for Test and working files(QVW) and version controlling to maintain