SUMMARY:

• 8+ Years of IT experience in all aspects of Business intelligence applications with a strong background in Database development, Data warehousing /Decision Support Systems and Business Intelligence.
• 4+ Years of experience with Confidential Applications with some exposure to Qliksense and Dashboard development.
• Expertise in designing and modeling of Confidential with complex multiple data sources (SQL, Flat Files, Excel and Access,) relational designs.
• Experience with Confidential sheet objects including Pivot, List, Multi box, multiple charts types, Trends, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Expertise in Installation, Configuration, Clustering, Load Balancing and Multi Node installation of Confidential and QlikSense Environment.
• Experience in designing Confidential Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Expertise in working with Data Warehousing and business intelligence tools for developing various reports using Confidential /Qlik Sense BI.
• Proficient in migrating reports from different platforms (such as Excel, Actuate, SQR, Crystal reports) to Confidential .
• Excellent Experience in Confidential Dashboards using different types of Confidential Objects including multiple charts types, Trends, QlikMap, Org Chart, Whisker Pie, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and utilizing Set Analysis, Google Maps API, VB Script/ Javascript macro modules etc
• Proficient in implementing Business needs and Batch process in backend using Stored Proc and Functions.
• Experience in Oracle 10g/9i/8i/8.x, PL/SQL, SQL, TOAD, Stored Procedures, Functions, Triggers, SQL Server 7/2000.
• Created PDF push reports based on ‘loop and reduce’. Alternatively, wrote VB scripts to perform the same
• Excellent logical, analytical & debugging skills.
• Possesses good leadership qualities, good Interpersonal skills, team - working attitude, takes initiatives and very proactive in solving problems and providing best solutions.
• Strong understanding in creating Dashboards, scoreboards for the required KPI’s in Confidential .
• Developed load scripts to work with multiple data sources (SQL, DB2, AS400, Excel, and Share point site).
• Developed production-grade Confidential reports and dashboard to meet business requirements in timely manner.
• Designed an applications for to support the lending process and dashboard style of layouts using different components of Confidential Enterprise like List boxes, Multi-boxes, slider, current selections box, buttons, charts, text objects, bookmarks.
• Working knowledge of QlikSense, NPrinting, Data warehousing and Tableau Desktop 10.0.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the Confidential Publisher
• Involved in up-gradation of Confidential environment from QV 10.0, QV 11.0 versions. Did end to end Unit Testing when migrating the applications.
• Designed, developed, implemented and tuned multiple Confidential applications for the Sales, IT, Manufacturing, Purchasing and Finance Confidential applications.
• Wrote SQL Scripts, procedures and views which are required for Confidential projects.
• Experience in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Enhanced Confidential scripting and ETL Solutions across multiple data sources
• Schedule QVW reloads on server and troubleshoot errors and failures.
• Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships.
• Developed dashboard extensions for Qlik Sense using JavaScript.
• Mainly designed and developed Confidential software applications and complex server-based Confidential dashboards from scratch to support reporting and Business Intelligence initiatives.
• Worked on dashboards related to Sales Analysis, Production over time and implemented performance tuning that offers fast and flexible access to all key information across the enterprise.
• Testing dashboards and data validation.

TECHNICAL SKILLS:

Analytics/ Reporting: Confidential 9/10/11.0/11.2, Qlik Sense, Business Objects, Tableau, SSRS

DBMS/Tools: DB2, Teradata, Netezza, MS Access; Toad, DataStudio, RapidSQL, MySQL, ORACLE 9i/10g/11g, SQL Server 2005/2008/2012, MongoDBETL Tools: SSIS, DataStage, Informatica

Languages: C, C++, R, Python, SQL, PL/SQL, HTML, XML, Java Script

Change Management: JIRA, SVN, Autosys, SharePoint

Other Tools: TM1, Microsoft Office Suite, Macromedia Dreamweaver, Unified Modeling Language (UML), GIMP, Adobe Photoshop, Adobe creative suite CS6.

Operating systems: Windows7/XP/Vista, Windows 2003/2008 Server, Linux, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Morristown, NJ

Sr. Confidential / QliksenseAdmin/ Developer

Responsibilities:

• Collecting functional and reporting requirements from application stake holders.
• Developed applications in the desktop as well as in the Qlik Sense Hub and shared the apps with the team through Qlik sense Cloud.
• Created extension objects in QlikSense/ Confidential using JavaScript, AngularJS files for creating visualization extensions in Filters, Directives, Templates, and Data Binding etc.
• Dealing with composing complex Scripts to load Data in Confidential Applications.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed a road-map to successfully run the existing reports while data base migration.
• Setting up and managing security using Active Directory.
• Responsible for gathering requirements, business and technical rules, implementing Confidential and Qlik Sense applications.
• Used RequireJS to add the local JavaScript file as a dependency for loading local JavaScript files into QlikSense.
• Loaded external JavaScript files to load resources from a Content Delivery Network (CDN) in several visualization extensions since the browser does not have to load the resource all over again.
• Created Dashboards style of reports using Confidential and Qlik Sense components like List Box, Slider, Buttons, Charts and Bookmarks.
• Good knowledge of deploying Qlik Sense dashboards on the Qlik Sense Server.
• Involved in performance tuning of various Confidential and Qlik Sense applications. A master calendar was used for time related dimensions and a strong source control methodology was used for tracking changes
• Timely Monitored QEMC to avoid load fails.
• Implemented Confidential Publisher into existing Confidential server environment. Developed PDF
• Monitored and enabled logging to analyze logs after every service restart.
• Integrating data in to data marts for efficient development.
• Performed testing of dashboards for functionality, data and performance.
• Provided training sessions on the use of Confidential to analyze organizational data.
• Involved in the requirements gathering, analyzing, reporting and documenting business requirements and data specifications with International business teams.
• Extended help to troubleshoot and resolve Confidential Script errors, fixed data issues on production dashboards and ongoing consultation to the development team.
• Designed and implemented the Incremental Load using QVDs.
• Scheduling and managing Qlik Sense jobs using Qlik Sense Scheduler for Qlik Sense application dashboards.
• Managed Named CALs, Document CALs, Session CALs and Usage CALs for different users.
• Created template as per User preferences for developing advanced Confidential reports.
• Implemented security and involved in deployment of Confidential applications, used windows scheduler, batch files for refreshing QVD and QVW
• Developing SQL Scripts to load the relevant Data in both Confidential and Qlik Sense Applications.
• Automated Confidential jobs in Confidential Publisher and rolled out to Confidential Access Point for distribution and administered Security using Active Directory.
• Good Knowledge and Expertise in Qlik Sense. Developed dashboards in Qlik Sense to replicate existing Confidential Dashboards/reports.
• Experience on IIS Server services for TM1Connect.
• Involved in configuring of TM1Connect (ETL) to export budgets for Confidential .
• Used advanced scripting, Alternate states for comparative analysis, set analysis, VBScript and JavaScript macros, advanced aggregation functions, advanced charts for applications and Document chaining
• Performed Confidential to Qlik Sense Migrations by loading the script from the Confidential workbooks to QlikSense.
• Utilized Qlik Sense Scalability tools to create execute and analyze of load and performance tests.
• Communicated with IBM for several requirements in process of TM1 migration.
• Manage analyze and resolve trouble tickets via Service management tool
• Install and support a variety of software and hardware issues.
• Install, configure, map network drives, trouble shoot and backup
• Provided documentation for all the existing dashboards for future reference.
• Support Citrix user setups
• Migrated to Qliksense, maintenance of server

Environment: Confidential 11.20 SR12, QVD, ERP System(Cost Point), SQL Server 2008 R2 Service Pack 2, SharePoint, MS Excel, Windows Server 2012,TM1Connect 10.2.2, IIS Server.

Confidential, Nashville, TN

Sr. Confidential / QlikSense Developer

Responsibilities:

• Involved in full project life cycle implementation (requirement gathering to production) of Confidential dashboards.
• Created and developed SET ANALYSIS to provide custom functionalities in Confidential Applications.
• Developing trend analysis reports using complex graphs for study of data quality patterns.
• Developed user defined financial reports to provide on demand financial data analysis using SSRS
• Performed data conversions from flat files into a normalized database structure
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Implemented Application Level Section Access and configured security rules on QlikSense streams to control user actions over QlikSense hub.
• Worked on SSIS and DTS Packages, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
• The core of all extensions of applications is made up by the corresponding JavaScript (js) file. The js file is loaded in the browser when the visualizations are used by loading with RequireJS.
• Worked on large scale and data volume based applications. Worked on VBA Macros
• Confidential and Qlik Sense Data Modelling by building the Star schema and resolving loops/synthetic keys.
• Ensuring smooth onsite to offshore transition of requirements and conducting knowledge transition sessions.
• Collaborated with Business clients and cross practical groups to create Business Requirement Documents (BRD), characterized KPIs (Key Performance Indicators), and recognize data sources.
• Dashboards were served to track administrations and administration request data and to screen different KPIs.
• Dashboards included client point of interest drilldowns, limit gages and alarming components.
• Developed official dashboards in Confidential conveyed through the web, empowering to gauge the execution of the business with systematic abilities.
• Multiple tier of QVD architecture is implemented depending upon the complexity of the application and the final application reload duration was 4 Hours.
• Analyzed and short listed Critical universes and reports which can be migrated to Confidential and Qliksense
• Worked with Confidential, SQL Server, Oracle, SAP, Excel, level documents.
• There will 9 million records with 200,000/Month new records coming into framework.
• Understanding Business objectives and accordingly developing reports that substantiates the data captured.
• Business destinations and creating reports.
• Transferred Data to data warehouse and exported files in various formats based on requirements using SSIS Packages.
• Installing and testing the Tableau 10.1.1 server and Creating POC's.
• Tableau online server administration and Application on boarding management.
• Set up & configured DB mail and created jobs to send out an email whenever any SQL jobs fails.
• Developing the Confidential reports, dashboards, building semantic/data models for ado reports, (QVD) generation etc using Confidential .
• Expert in Installing, configuring and upgrading the Qlik Sense multi node clustered environment.
• Dashboards were served to track services and service order information as well as to monitor various KPIs.
• Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Developed executive dashboards in Confidential delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Expertise in using advanced scripting, set analysis, advanced aggregation functions and advanced charts for applications.
• Extract, transform and load data from multiple sources into Confidential and Qlik Sense applications.
• Design, Develop, Test, debug and implement Qlik Sense Applications based upon specified requirement.
• Worked with Confidential, SQL Server, Oracle, SAP, Excel, flat files.

Environment: QlikView12, Qlik Sense, SQL Server 2012, Tableau, Excel, SAP, Confidential 11.

Confidential, Hartford, CT

Confidential Developer

Responsibilities:

• Developed dashboards pertaining to Revenue and Sales monitoring.
• Managed and distributed application using Confidential Publisher.
• Managed the Confidential Server tasks: developing tasks, assigning license, creating user groups etc.
• Participated in Confidential server migration from one physical server to another.
• Participated in user discussions to understand the user requirements, layout, and look and feel of the dashboards to be developed.
• Performed analysis, documentation, for calculation for various attributes.
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Promoting dashboards to production environment and manage user access.
• Involved in Requirement gathering & designing Confidential applications.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the Confidential Data Models.
• Developed Confidential Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Developed Custom DATE Calendar Object and Linked with in the Model.
• Experience in Using Confidential Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.)
• Developed User Interactive Sheets & Reports as business needs.
• Writing SQL Scripts to load the relevant Data in Confidential Applications.
• Implemented Security & involved in Deployment of Confidential Applications.
• Created QVD’s & updated on timely basis as database updates.
• Sound skills in developing hide/Show Objects based on Condition & Triggers.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Experience with building applications using SAP BW.

Environment: Confidential 11.0/10.0, SAP BW, Teradata, SQL Server 2008, Oracle 10g, Access, .CSVFiles, Windows 2003 Server.

Confidential, Omaha, NE

Confidential BI Developer

Responsibilities:

• Working with the 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
• Assembled monthly report of all capital expenditures for management.
• Analyze customer requirements and develop proposals of technical solutions as needed.
• Developed SQL Scripts, database objects, procedures, functions and packages.
• Setting access permissions and assigning CALs based on users.
• Schedule QVW reloads on server and troubleshoot errors and failures.
• 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 Confidential software applications and complex server-based Confidential dashboards from scratch to support reporting and Business Intelligence initiatives.
• Worked on dashboards related to Sales Analysis, Production over time,and implemented performance tuning that offers fast and flexible access to all key information across the enterprise.
• Testing dashboards and data validation.
• The project initially used Tableau but migrated to Confidential in the 2nd week of development.
• Used advanced scripting, set analysis and VBScript, advanced aggregation functions and advanced charts for applications.
• Designed QVWs to generate QVDs for faster and efficient data reloads.
• Trained Confidential developers and users on best practices and general “how to” procedures.
• Designed Master Calendar.
• Implemented security using Confidential ‘s section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Provided ongoing Confidential consultation to the development team.
• Helped company to do a complete inventory of all assets prior to going public.

Environment: Confidential 10.0, Oracle10g, Sql, Oracle 10g, Netezza, SQL Server2008

Confidential

SQL Developer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created SQL Server database to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, optimization, normalization) and .NET data access components
• Individually designed MS SQL Server 2000 database, coded stored procedures (T-SQL).
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Developed complex Stored Procedures and Views to generate various Drill-through reports, parameterized reports and linked reports using SSRS
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS)
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Generates the report into Excel Spreadsheet form from SQL server 6.5/7.0/2000.

Environment: SQL Server 2000, T-SQL, Enterprise Manager, C#, Query Analyzer, Windows 2000 Server, MS Office 2000, Crystal Reports 7.5,VB