Sr.bi Consultant / Qlikview Developer Resume
0/5 (Submit Your Rating)
Charles Town, WV
SUMMARY
- Around 6 years of total IT experience with emphasis on development of data warehouse and Business Intelligence solutions and functionalities using Qlikviewand Business Objects tools.
- Strong knowledge & experience in all phases of Software Development Life Cycle (SDLC) such as Developing, Testing, Migrating, Administrating, Security management and production support.
- Good experience on software applications development, ETL and BI applications.
- Extensive experience in Qlikview9.0 with expertise in developing innovative applications for the business users.
- Working with End users to develop a model that best suits the business needs and achieves the desired results under given constraints.
- Hands on experience in implementing the new features of Qlik Sense like Pivot Table, KPI Object, PDF Printing etc.
- Hands on experience on Qlik Sense and N - Printing
- Excellent knowledge on Dimensional Modeling concepts like (Star Schema, Snow Flake Schema) & Loading Data from multiple sources.
- Proficient in optimizing, debugging and testing SQL queries.
- Strong experience in design & development of Business Intelligence and Data warehouse reporting.
- Strong experience in Dimensional Modeling using Star Schema, Identifying facts ad Dimensions, Physical and logical data modeling using ER-Modeling.
- Worked extensively on creating and maintaining Materialized Views.
- Hands on experience in using different relational databases such as Oracle Siebel
- Strong Data analysis to ensure accuracy and integrity of data in the context of Business functionality.
- Extensive experiences in analysis, design and development of distributed web based and desktop based applications, data modeling, ETL, reporting / data analysis systems and BI solutions.
- Good Knowledge on CRM tools like Siebel 9.0.
- Team Oriented individual with a result driven attitude, Strong interpersonal and communication skills in effective information exchanged and interaction with clients at all levels of management.
TECHNICAL SKILLS
Analytical/Reporting Tools: Qlikview, SSIS, SSAS, SSRS, Tableau, QlikSense, Cognos, Crystal Reports, Visual Studio
Languages: T-SQL, MySQL, PL/SQL, Qlikview Scripting (VB Script/ JavaScript)
Databases: Oracle 10g, SQL Server, DB2, Teradata
Operating Systems: Windows, Linux, MacOS
Servers: SSMS, Qlikview Server, Windows 2008 R2 Server
Data Modelling: Erwin, ER Studio
Methodologies: Waterfall, Agile.
PROFESSIONAL EXPERIENCE
Sr.BI Consultant / Qlikview Developer
Confidential - Charles Town, WV
Responsibilities:
- Worked as senior Qlikviewconsultant for Centre for Teaching and Learning team.
- Developed Qlikview products for liquid hub and involved in publishing the products to multiple clients.
- Involved in requirement gathering with higher level management and developed dashboard accordingly.
- Implemented QlikSense/Tableau self-service dashboards.
- Worked extensively on advanced set analysis and advanced aggregation functions.
- Automated the QV jobs using Qlikview server and publisher and defined the user access/security and data reduction.
- Defined best practices and guiding team to build optimum data model/design inQlikview.
- Worked onQlikview administration.
- Worked with senior management and business analyst to identify the business requirements for theQlikview applications.
- Developed high performance systems architecture forQlikview implementations.
- DesignedQlikview dashboard prototypes for the user demo.
- Established a secure environment usingQlikview Section Access.
- Developed data model to reflect a Star model after translating various sources into Dimension and Facts.
- Eliminated all Synthetic keys and Circular References in order to make data model efficient.
- Implemented tasks to schedule QVD generation and Dashboard refreshes at regular intervals and appropriate dependencies.
- Developed applications in the desktop as well as in the Qlik Sense Hub and shared the apps with the team through Qlik sense Cloud.
- Involved in QMC Administration, Server/Publisher installation and Configuration.
- Implemented Data security using Section access and Publisher Data Reduction.
- Create KPI's on comparative analysis by using Alternate State functions.
- DevelopedQlikview Reports for PDF Distribution via Email.
- Involved in Testing Dashboard data using extensive SQLs, Excel Pivots and Mappings
BI Consultant/QlikView Developer
Confidential - Detroit, MI
Responsibilities:
- Interacted with customers to gather business requirements and developed functional and technical specification document.
- Participated and proposed new business analysis for data which has no prior reports.
- Extracted data from the database, stored into QVD files, and wrote load scripts.
- Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) 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 usingQlikview Section Access.
- Solid understanding of QVD / QVW / QVS and QMC / QEMC management, bulk data and incremental load.
- WroteQlikview macros, variables, user friendly functions, and built reusable master framework.
- ImplementedQlikview desktop and publisher, managed user authentication, established publisher tasks, streamlined loading procedures and reviewed log.
- Worked on data modeling and developed different complex models as per given user requirement by eliminating closed loops, Synthetic tables and ambiguous relationships.
- Enhanced existing dashboards with new functionalities and tuned ETL scripts for better performance.
- Creation of reports using reports and charts as per the customer requirement depends on Quarter, monthly and analyzed the report with charts provided byQlikview.
- Provided training and supported client-in house business users.
Qlikview Developer/ Data Analyst
Confidential - Denver, CO
Responsibilities:
- Worked as a BI analyst/ Qlikview Developer- on sales applications.
- Worked with the user community and senior management to identify the business reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business.
- Developed systems architecture forQlikviewimplementation identifying the data sources and target reports match.
- Worked on differentQlikviewobjects like straight tables, line charts, bar charts and pivot tables etc. for dashboard design.
- Worked on set analysis and advanced aggregation functions.
- Writing VB Script Marcos wherever it's needed.
- DevelopedQlikviewapplications from scratch.
- Worked onQlikviewserver and publisher to automate theQlikviewtasks and apply the security.
- Analyze customer requirements and develop proposals of technical solutions as needed.
- Creating the oracle procedures, packages and functions.
- Used MS Access for smaller databases to create the tables and generate the reports.
- Created score cards with advanced set of dashboards using MS Office Performance Point Server Dashboard Designer that feature executive summary measures.
- Scheduled SQL Server Agent Jobs to run every day to update changes in the base tables.
- Resolved various performance issues by running DBCC command.
- Performed daily tasks including backup and restore from disaster recovery by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler.
Data Analyst
Confidential
Responsibilities:
- Developed SSIS to extract, transform and load data from different data sources, such as databases, CSV, Excel files into SQL Server database for reporting purpose
- Maintained dimensions/facts/data extractions jobs using SSIS
- Developed complex stored procedures to process data in SQL Server 2005/2008
- Optimized SQL queries and fine-tuned indexes to improve system performance
- Understanding SQL Server Replications, Snapshot, Transactional and Merge type
- Used SQL Developerto Load / Extract data into and from Excel files.
- Used Hints, Explain Plan, and Indexes for query tuning and optimizations.
- Conducted impact analysis and designed structures to enhance performance.
- Involved in data cleaning, merging and conversion.
- Developed processes, automation of maintenance jobs, tuning SQL Server, data validations, locks and indexes configurations.
- Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.
- Expertise in Extract, Transform and Load (ETL) using SSIS and various tools including Bulk insert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed, designed and developed for a Data Warehousing and Data Migrations.
- Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
- Cleaned the data and created fact and dimension tables, performed calculations required for the reports using SQL Server environment and accomplished data modeling.
- Created dynamic Reports from the cube using SSRS 2005, and stored procedures.
- Troubleshoot the deployment of reports in the test and production environment using SSRS.
- Documented the complete data warehouse environment, including all dimension and fact tables, the relationship between SSIS packages and the target tables, which packages were valid and in use, the relationship between the jobs and SSIS packages