SUMMARY

• Around 10 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.
• QlikView with comprehensive experience in planning, designing and building BI Dashboard and Analytics Reporting solutions, utilizing BI tools (QlikView, BO, Cognos, SSIS/SSRS), Databases (Oracle, DB2, Microsoft SQL), data analytics and dashboard visualization skills, supporting evidence - based business decision making.
• Over 3 years of QlikView dashboard and Visualization experience.
• Strong Skills in QlikView 11, 10 in designing and creating dashboards and reports with various graphs and analysis
• Hands on experience in SDLC processes and methodologies in Business Intelligence domain.
• Complex Report Building experience by using native SQL, Filters, Prompts, Conditional Formatting, Dashboard Reporting using Master/Detail queries, Ranking, Drill-through, Crosstabs.
• Well versed in creating Dashboards and Customized portal tabs for various business units.
• Strong experience using SQL in development of reports, analyzing data in tables, cardinality between tables and joining tables.
• Familiar with Data warehouse and Extract, Transformation and Load (ETL) for Data Extraction using tools like Informatica, Datastage and Pentaho.
• Experience with Multiple Relational Databases including Oracle, MS SQL Server. DB2 and MS Access.

TECHNICAL SKILLS

BI tools: QlikView, Cognos BI Suite 10.1/8.x, Cognos ReportNet, PowerPlay Transformer, Impromptu Web Reports (IWR), Business Objects, Splunk

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005/2000 , MS Access, mysql, DB2, Informix

ETL tools: Informatica, Pentaho, IBM Datastage, DMExpress, SSIS

Programming: JavaScript, .NET, SQL, T-SQL, and PL/SQL, HTML, XML

OS Environments: Windows XP/2000/ NT/7, UNIX (HP, Linux)

PROFESSIONAL EXPERIENCE

Confidential

BI Data Analyst/Developer

Responsibilities:

• Collaborated with Business Intelligence team to learn current processes and practices.
• Develop database procedures, transformations, integrations, and queries to access and transform data
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Document design, development, optimize and maintain, reliable, repeatable and scalable ETL packages utilizing SSIS.
• Develop, maintain, and administer complex ETL processes using MS SQL Server 2008 (DTS and SSIS)
• Create Tables and Service broker process for asynchronous data transfer.
• Created SQL server jobs and SSIS packages.
• Involved in creating ETL tasks and jobs using DMExpress
• Developed executive dashboards inQlikViewdelivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Design, Develop, Test, debug and implementQlikViewsolutions based upon specified requirement.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimizing reports.
• UsedQlikViewFunctions (Date and Time, Keep, Join, Mapping, String & input Fields etc )
• Extract, transform and load data from multiple sources intoQlikViewapplications.
• Generated new QVD files from the EDW by writing scripts inQlikViewapplications. Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys.
• Developed KPIs, SET ANALYSIS to provide custom functionality inQlikViewApplications
• Create PDF push reports usingQlikViewreport editor
• Develop, troubleshoot and fine tune existing and new reports

Environment: MS SQL Server 2008, SSIS, DMExpress, GIT, Agile (Rally), Java, T-SQL, QlikView, Linux, Razor SQL, Informix, SVN, Microsoft Visio, XML

Confidential

QlikView Developer

Responsibilities:

• Participating in business requirements and design review sessions
• Providing input on proposing, evaluating, and selecting appropriate design alternatives which meet requirements and are consistent with our current standards and processes extracting, transforming and loading data into QlikView applications
• Extract, transform and load data from multiple data sources into the QlikView applicationby following implementation standards.
• Developing, testing, debugging QlikView applications
• Creating views, stored procedures and QVDs for QlikView app consumption
• Tuning data loads and QlikView application for efficient performance Environment: QlikView 10/11, MS SQL Server 2008, SSMS, CSV files, QlikView Enterprise Server, Tableau Agile Scrum, Java, Splunk

Confidential, Newton, MA

QlikView Developer

Responsibilities:

• Worked with the team to identify the business reporting needs and studied current reporting practices outside of QlikView through pivot tables.
• Participated in business requirement document preparation.
• Performed redesign of the existing QlikView BI associative model to improve availability, scalability and performance by eliminating Synthetic keys and Circular Loops in the data model.
• Applied Mapping Function to eliminate certain dimension tables and reduce the clutter in the QlikView data model.
• Rebuild dashboard applications on both frontend UI and backend, developing scripting templates, UI design and coding standards, design guidelines, migration strategy and implementation plan.
• Developed scripts for data reloading, mapping and transformation by using joins, concatenations, resident loads and temporary tables.
• Extensively worked on QlikView Set Analysis, Macros and advanced Aggregate Functions to provide custom functionality.
• Implemented Section Access, Section Authorization and Sheet access to make the application available to desired users.
• Utilized Loop/Reduce functionality for creating multiple documents and distributed based on Section Access user privileges both by using Field and Bookmark criteria.
• Incorporated Comparative Analysis and Adhoc Analysis as per the requirement.

Environment: QlikView 10/11, MS SQL Server, CSV files, SQL Server Integration System, SQL Server Reporting System, QlikView Enterprise Server, Ajax, JavaScript, ASP.NET, Agile Scrum

Confidential, Detroit, MI

Cognos Developer

Responsibilities:

• Conducted analysis of existing legacy reports and data extracts from current reporting system (GQL) and map data requirements to information available in EDW
• Involved in collecting business requirements, report rationalization, report groupings and consolidation and prioritization
• Collaborate with business users and analysts to validate business requirements and translate them into technical specifications.
• Document Business Requirements (BRDs) and Report specifications technical Designs (TDDs)
• Developed standard and ad hoc reports using IBM Cognos Report Studio and Business Insight Advanced tools
• Added Drill Through, Drill Up and Drill Down functionality to the reports using Report Studio
• Added advanced functionality to Prompts using Cascading property and use of style and render variable properties.
• Wrote SQL Queries for validating the reports against EDW and back end databases
• Wrote Test Cases for ETL to compare Source and Target database systems
• Provide technical assistance and analysis with troubleshooting report development issues for customer developed reports.
• Involved with the QA team to create and/or validate system acceptance and user acceptance test plans and test scripts to ensure report delivery.

Environment: Cognos 10.1, Framework Manager, Toad, SQL Developer, Datastage, Facets, Pega, Oracle 10g

Confidential, Newark, NJ

Cognos Developer

Responsibilities:

• Created different types of reports like Simple List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
• Created multiple Dashboard reports for multiple packages.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Initiated training for the users to do ad-hoc reporting using Query Studio.
• Extensive experience on Structuring Metadata and Cognos Models using Framework Manager.

Environment: IBM Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection) Oracle 10g, Informatica, SQL Server 2005

Confidential, Tallahassee, FL

Cognos Developer

Responsibilities:

• Involved in Requirement gathering from Business Users and developed Technical Documentation for the Business and IT Team.
• Installed and configured the Cognos BI single server environment, administering the Servers, troubleshooting, performance tuning and implementing security, managing users, user groups and roles in the organization.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
• Created complex Dashboards using Business Insight Advanced.
• Responsible for security at package level, data level and object level in Framework Manager and restricted usage of data at report level and folder level in Cognos Connection.

Environment: Cognos 8.4 (Cognos Connection, Report Studio, Query Studio, Analysis Studio, Framework Manager), Data Manager, Event Studio

Confidential, White Plains, NY

SQL Developer

Responsibilities:

• Writing views and stored procedures for data access to the front end
• Performance tuning of existing views and stored procs

Environment: SQL Server, .Net Frame Work, XML, MS Access, Excel, ASP .Net

Confidential

Business Analyst / QA Tester

Responsibilities:

• Responsible for interpreting, developing and implementing system enhancement to support business requirements
• Gathered, developed, and maintained various business requirements from the initial phase to the final implementation.
• Performed manual web testing, Black Box testing, Integration, System, Load testing and captured requirements in the form of Use Cases, non-functional specifications and business rules.
• Wrote and executed test plans; developed test cases and test scripts in Mercury Test management tool Test Director.

Environment: Win Runner, Load Runner, Test Director, .NET, SQL Server