SUMMARY

• Solutions - focused data professional wif 7 years of experience in researching, gathering, storing, analyzing, and managing data.
• Experienced wif Data Warehousing and Business Intelligence tools for developing various reports using QlikView. Expertise in Installing and Configuring QlikView Desktop, QlikView Server and QlikView Publisher.
• Designed and developed higher number of reports using Nprinting
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Installed, Configured and deployed the application on QlikView server and Imported data from different sources like Oracle, SQL Server, Teradata Database, DB2, XML files, QVDs and flat files using OLE DB/ODBC. Designed QVWs to generate QVDs for faster and efficient data reloads.
• Trained QlikView developers and users on best practices and general “how to” procedures. Implemented security using QlikView‘ s section access dat dynamically hides selected areas of the dashboard depending upon user privileges. Experienced in Requirements Gathering, Data modeling and QlikView Application development.
• Managed QlikView reporting environment which includes QlikView Server, QlikView Publisher and QlikView Desktop. Loaded data into QlikView from Database, text file and also from excel file. Interacted wif Customers for requirement gathering and effective analysis. Developed interactive dashboards for mobile professionals while disconnected from network.
• Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services. Strong Experience in Data Mart/database design and development. Sound skills in writing SQL Scripts, Pl/SQL Stored Procedures.
• GUI (Graphical User Interface) programming in Visual Basic for desktop application. Strong Database Development skills using SQL Server 2012/2014 & Oracle 10g. Resolving the Issues in Production Environment. Provided Training Sessions on QlikView capabilities to potential clients User Groups. Business Analysis experience wif excellent communication & interpersonal skills and broad understanding of business operations and requirements.
• Self-motivated and enjoy working in a technically challenging environment. Excellent work ethics, self-motivated, quick learner and team oriented. Continually provided value added services to the clients through thoughtful experience and excellent communication skills.

TECHNICAL SKILLS

Languages and Web Technologies: C, C++,R, Python, JavaScript, XHTML, CSS, XML, XSD, XSLT,PHP

ETL Tools: SSIS, SSRS, DTS

Reporting Tools: QlikView 10/11.0/11.2, SSIS/SSRS, Crystal Reports

RDBMS: MySQL, ORACLE 9i/10g/11g, SQL Server 2005/2008/2012 MongoDB, MS Access

Servers: WebSphere, WebLogic, Apache, Tomcat

Development Tools: Eclipse, Microsoft Visual Studio

Tools: MS Visual studio 2008, MS BIDS, Toad, Excel, Notepad++, Sublime Text

Operating Systems: Windows XP/7/8,8.1,10, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Qlikview Developer

Responsibilities:

• Developed highly customized QlikView dashboard applications.
• Designed and developed a wide variety of charts and associated sheet objects to satisfy complex business requirements.
• Created a navigational system dat utilized QV hierarchy dat used weights to identify values.
• Used Nprinting tool for advanced report generation and distributing the reports on Emails.
• Back traced data to make sure it works cohesively as well as accurately by looking for discrepancies such as duplicates, rescinded information etc.
• Involved in developing dashboards using QlikSense. Migrated dashboards from QlikView to QlikSense.
• Was given the task to define major KPI so analyzed, brainstormed the needs of the company and created a trigger system dat alerted higher ups in problems wif any unit of measure they are measuring or would fall under their jurisdiction to know the status of.
• Wrote Complex set analysis statements.
• Used SQL Server Management Studio, TOAD to run SQL queries and validate the data in Data warehouse and Data Marts.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Code review as well as fine tuning of applications as well as fixing data model.
• Scheduled tasks in server and Trouble shooted application in access point as well provided maintenance.
• Dealt directly wif CEO, CFO as well as all managers on day to day basis to create an effective system and dat tailored to each person moreover primarily focused on CEO needs.
• Educated different user groups and peers wif QlikView functionality.

Environment: QlikView 11.0 SR3,Windows Server 2003, Oracle 11g, MS Access 2005, MS SQL Server 2008, MS Office.

Confidential, El Segundo, CA

Qlikview Developer

Responsibilities:

• Focused on Template Design UI-friendly and implemented section access using Windows NT autantication.
• Designed and implemented mapping tables to support data transformation during data load.
• Extensively utilized native QlikView functions wifin load scripts and charts to streamline application design.
• Designed (ETL) processes for extracting, transforming and loading vendor sales data into Oracle tables.
• Created a relevant data model and front end to satiate the requirements.
• Implemented section access to enforce row-level data security.
• Utilized alternate states to simplify application design and reduce on-going maintenance.
• Created trigger actions to provide custom functionality such as setting variable values and default filter selections.
• Written QlikView Scripts, macros, design Dashboard and Reports for different user groups
• Deployed the QlikView Application to the server and automated the jobs.
• Managed QlikView Licenses User CAL, Document CAL, Server Licenses, Publisher Licenses.
• Held weekly meetings to track progress along wif to optimize efficiency.

Environment: QlikView 11, Teradata, SQL Server 2005, Oracle 10g, Access, .CSV Files, Windows 2003 Server, Sun one LDAP, SAP HRMS.

Confidential, CA

Sr. QlikView Developer

Responsibilities:

• Worked wif the user community and senior management to identify the business reporting needs and developed proposals of reports needed. Developed ETL Scripts while loading the data, resolving loops & ambiguity joins. Coordinated wif ETL team and performed integration testing to check data discrepancies.
• Automated QlikView jobs in QlikView Publisher and rolled out to QlikView Access Point and administered Security using Active Directory. Analyzed the existing QlikView data model, script logics and the ETL business logic for the existing QlikView applications.
• Tested Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Used advanced scripting, set analysis, VBScript and Script macros, advanced aggregation functions and advanced charts for applications. Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Implemented Security features in the Report for external as well as internal users & involved in Deployment of QlikView Applications. Developed Custom DATE Calendar Object and Linked wif in the Model. Strong Experience in Working wif Charts (Table Box, Pivot, Straight, Pie, Line Gauge, Trillies).
• Designed Executive Sales Analysis Dashboard dat offers fast and flexible access to all key information across the enterprise. Designed a Mortgage analysis dashboard for client to keep track of Sales representative performance, and efficiency of converting customer leads into revenue.
• Trained End Users on Using QlikView Tools. Scheduled jobs on QlikView Enterprise Management Console. Developed QlikView reports using various sheet objects like charts, pivot table, drop down box, radio button, and slider.
• Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques. Published Client application using QlikView Publisher and rolled out to Shared Drive wif security permissions using Active Directory features.

Environment: QlikView 10.x, Oracle, SQL Server, Informatica 9.1, Toad 9.6.1/SQL Developer, SQL Loader, Sun Solaris

Confidential, NY

QlikView Developer

Responsibilities:

• Developed QlikView applications by analyzing business data as per client requirements. Created schema objects like tables, views, indexes. Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Written new stored procedures, functions and T-SQL queries and modifying existing ones as per new business requirements. Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.
• Worked wif QlikView administrator to optimize QlikView performance. Worked on Automation & scheduled QVW document refreshments using QlikView Publisher. Analyzed the reporting requirements wif the business users and came up wif the technical specifications.
• Developed Canned Reports, Customized Reports, On-Demand Reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in SSRS. Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Created Drill down reports which give all the details of various transactions like closed transactions, pending approvals, and summary of transactions and scheduled this report to run on quarterly basis using SSRS (Reporting services).
• Designed application for Sales & Marketing Modules dat Generates GUI Report for easy access through the data.

Environment: QlikView 9/10, MS SQL Server 2008 R2, SSIS, SSRS, T-SQL, PL/SQL, Oracle 10g, SQL, UNIX, MS Access 2010, VB Script.

Confidential

SQL Server Developer

Responsibilities:

• Supported Application Development team wif any database issues, updates or new releases and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Developed SQL scripts to Insert/Update and Delete data in T-SQL database tables.
• Generated T-SQL scripts for application development.
• Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
• Created Stored Procedures and User Defined functions.
• Worked in Grouping, Summing, totaling, Case Limits, Common Table expressions
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database.
• Participated in the designing and development of software using agile development practices
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, database bottlenecks, or network latency
• Scheduled Jobs and Alerts using SQL Server Agent.
• Worked wif various Delivery mechanisms of Reports including Email /PDF/Schedules etc
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Maintained system entries and handled customer product qualification activities.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Implemented indexes for performance tuning.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated
• Data loaded into the database using SSIS 2005 from flat files.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Developed several types’ reports and Deployed to the end users using SSRS

Environment: SQL Server 2000/2005/2008, SQL Server Query Analyzer, SSIS, SSRS, Windows 2000/XP