SUMMARY

• Having 6+ years of experience in IT industry.
• Experienced professional in gathering and writing detailed business requirement and translating them into technical specifications/ System Requirement Specifications (SRS) and design.
• Well equipped with using Dimensional Data Modeling, Star Schema Modeling, Snow - Flake Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling.
• Skilled in creating Logical Tables and Columns, Dimensional Hierarchies, Level Based Measures, Time Series Data.
• Expert in QlikView, Teradata, Oracle, SQL Server, Access, Informatica, SSAS, SSIS, SSRS, UNIX, Toad, SQL, MS Visio, MS Project, Microsoft Office Suite.
• Competent in writing SQL queries, Stored Procedures, database tuning, query optimization as well as resolving key performance issues.
• Designed and created various analytical reports and Dashboards to help users identify critical KPIs and facilitate strategic planning in the organization.
• Sound Knowledge of QlikView sheet objects including different kinds of charts, Trends, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard Reporting.
• Experienced in Loading Data using Scripts like automate QVD’s, Calendar Object as well as Custom Scripting to implement SQL Functionalities.
• Skilled in using different types of load balancing techniques to install & configure QlikView Server & Publisher in both clustered and non-clustered environments.
• Exposed to different types of loads such as Incremental, Optimized & Binary.
• Implemented various levels of File/Document and Data level Security.
• Experienced with Performance Tuning & Deployment of QlikView Applications.
• Experienced in using Section Access, Sheet Access and Set Analysis.
• Possess strong interpersonal skills and have extensively presented demos and trained end users on QlikView application.
• Designed data conversion strategies, developed data mappings and proposed Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Expert in Unit, System and User Acceptance Testing and performed Data Validation for all the reports and dashboards generated from various database sources.
• Have extensively worked with senior management to identify strategic goals, objectives, scope, budgets and processes for internal and external development as well as formulate risk analysis and mitigation plans, status reports, and client presentations.
• Experienced in Reverse-Engineering as well as a Business Rules Extraction.
• Expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and plan.
• Enthusiast professional with the ability to work alone as well as a team player with excellent communication skills and leadership abilities to effectively develop creative solution for challenging requirement of client.

TECHNICAL SKILLS

BI Tools: QlikView(11.x/10.x), IBM Cognos 10.1.1, 10, 8.4, 8.3, Report Net MR2/MR1, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Dashboards, PowerPlay Transformer(7.3, 7.4, 8.4), Impromptu, RTM MicroStrategy, Microsoft SQL Server Reporting Services

Data Integration Tools: Informatica, SQL Server Integration Services ( SSIS)

SQL Tools: Teradata SQL Assistant, Toad, PL/SQL Developer, Rapid SQL

RDBMS: Teradata, Oracle, SQL Server,DB2, MySQL, Access

Documenting and Data Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio, MS Project, MS Office(Word/ Excel/ Access/ Power Point), MS SharePoint, Documentum.

Scheduling Tools: Autosys, Control M

Defect Management/Testing Tools: Mercury Test Director, HP Quality Center

Change/ Service Management Tool: HP Service Manager, CA Service Desk Manager, Lotus Notes

Scripting/Lang.: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, and XML

Operating Systems: Windows XP/ Net/2000/ Vista/7, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, DALLAS, TEXAS

QLIKVIEW DEVELOPER / ANALYST

Responsibilities:

• Collaborated with the Customer Support group for domain requirements gathering.
• Extensively used Visio to create Use Cases Diagrams and Activity Diagrams.
• Used the agile methodology to define the whole project life cycle.
• Examined the business requirements and classified them into high and low level.
• Gathered requirements from end users, and modified various technical & functional specifications.
• Worked with Project Manager to develop project timeline and resource estimations.
• Used MS Visio to develop and maintain high level overview of the data flows.
• Thoroughly analyzed the current architecture, databases and designed schemas.
• Used QlikView Desktop to create and modify Business Intelligence analytical reports/ dashboards.
• Installed and deployed QlikView application to create dashboard.
• Implemented Star Schema & Snow Flake for Dimensional Data Modeling in QlikView.
• Used OLE DB/ODBC connections to imported data from different sources like SQL Server, Teradata, MS Access, XML files and flat files.
• Administered schedules and reloading of QlikView data model QVDs and QVWs through QlikView server.
• Utilized QlikView sheet objects like List Box, Input Box, Buttons, Text Input, Slider, Bookmarks, Charts (Pivot/Straight tables, Pie, Bar, Line Charts etc.) to create user interface reports.
• Generated and published QlikView reports for business steering committee.
• Created complex Dashboard utilizing Drill function which enabled the users to drill down between dimensions.
• Worked with Set Analysis to develop essential KPIs.
• Used Sheet access and Section access to maintain security of the application.
• Presented the statistics in bar charts and pie charts as per the client needs.
• Worked on SQL Tuning and Optimization of the reports.
• Facilitated load testing and benchmarking of the developed product with the specified performance standards.
• Created Unit Test Cases and documented its results.
• Participated and provided valuable inputs in clarification meeting with the clients.
• Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
• Managed Onsite & Offshore coordination to ensure the completeness of deliverables.

Environment: QlikView, Tableau, Teradata, Teradata SQL Assistant, Fast Load, SQL Server, SQL, PL/SQL, SQL Developer, Informatica Power Center, DB2, Oracle, Control-M, MS Project.

Confidential, MINNEAPOLIS, MN

Sr. BI QLIKVIEW CONSULTANT

Responsibilities:

• Worked closely with Business Analyst to understand the requirement and reviewed High Level Design Documents.
• Experienced in the designing, developing reliable end user applications including dashboards, reports, monitors, and graphic presentation (Information Visualization & Analysis) using QlikView BI platform.
• Collaborated with business analysts and data architect to resolve the business issues and data challenges.
• Excellent multi-tasking skills and capable of prioritizing in a fast paced and agile work environment.
• Used various scripts like add, concatenate, resident, qualify, unqualified etc to extracted information from different data sources
• Wrote SQL queries and created ad hoc queries to perform data validation and analysis.
• Created QVD files to hold data from data sources and updated the QVD files on timely basis as the source database updates.
• Used data from various sources like QVD files, MS SQL DB, Excel, and Flat Files to developed QlikView Application.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMarts.
• Designed suitable UI for reports to achieve user requirement in simple and user-friendly manner.
• Created Dashboards and designed appropriate User Interface using QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields, etc.) as per the business/ user requirement.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Current Selection Box, Buttons, Multi Box and Calendar & Date.
• Created QlikView reports and publishing them as per clients’ request.
• Skilled in using Section access and Sheet access to make the application available to desired users.
• Customized and tweaked the scripts and necessary data transformation.
• Used Set Analysis to created both simple and complex expressions.

Environment: QlikView 10/11.x, Oracle 11g, TOAD, Netezza, SQL Server, Teradata, Tortoise, Windows.

Confidential, DALLAS, TEXAS

QLIKVIEW DEVELOPER / BUSINESS ANALYST

Responsibilities:

• Assisted in compiling Business Requirement and development of technical specification documents.
• Used complex database system which included extracting data from database, storing into QVD files, writing load scripts as well as developing UI to develop appropriate dashboards.
• Connected to different ODBC, OLE DB data sources Oracle and flat files to fetch data and create and schedule various complex reports as per the business requirement.
• Used Set Analysis to develop different KPI’s as per requirements.
• Implemented section access to make specific data and sheets available only to specific users.
• Worked on building up the data model as per Business Requirements.
• Used QlikView Publisher to carry out different tasks like repeat tasks, reload tasks and distribution tasks.
• Utilized QlikView Publisher to automate and scheduled daily data loads of QVW documents.
• Maintained and administered source documents, source documents sets, and user profiles and executed resource management services like access point resources, distribution folders and email servers.
• Changed scripts to load data in optimized way to achieve reduction of loading time, simplified complex expressions in the front-end as well as improved layout structure.
• Enhanced existing dashboards with new functionalities and Tune ETL scripts for better performance.
• Provided continuous QlikView consultation to the development team, researched and troubleshoot technical problems.

Environment: QlikView 10, Oracle 10g, PL/SQL Developer, SQL Server, Windows, Teradata

Confidential

BUSINESS ANALYST

Responsibilities:

• Evaluated existing e-Commerce applications to diagnose areas of improvement and program enhancements and modifications.
• Analyzed and designed e-Commerce applications to meet business process initiatives.
• Developed and reviewed prototypes, and conducted walk-through with the client to get a sign off.
• Heavily involved in Requirements Management and Use Case Modeling.
• Identified user and business roles, data groups, constraint types and constraint values for defining security for different applications
• Used Sequence Diagrams, Collaboration Diagrams, and Activity Diagrams in UML to elaborate business processes.
• Edited documents using live link content management.
• Used pseudo logic to describe algorithms.
• Converted business needs into developer oriented specifications and designs.
• Analyzed business users’ requirements and communicated them to the rest of the data warehouse team.
• Assisted in identification of potential sources of data for data warehouse.
• Collaborated with data analyst to analyze existing reports and identify iteration metrics.
• Outlined database model based on different business logic and business-to-consumer relationship.
• Oversaw Quality Control methodologies and hosting services.
• Formulated application Test Scripts and engaged in Verification and Validation.
• Lead defect reviews during test calls and/or defect meetings.
• Developed and ran ad hoc SQL queries to verify the data in the databases.

Confidential

BUSINESS ANALYST

Responsibilities:

• Responsible for continuous process improvement and for identifying and maintaining a clear and measurable development process that is deployable throughout the enterprise using RUP.
• Developed prototype of new information processing application.
• Facilitated collection of functional requirements from system users and prepared business requirement documents using Rational RequisitePro which provided appropriate scope of work for technical team to develop prototype and overall system.
• Defined the scope, analyzed financial projections and performed cost/benefit analysis
• Operated as an liaison between the users and different teams involved in the application development to achieve a better understanding between the business and IT processes
• Formed a bridge between the Project Manager and different teams by demonstrating effective presentations skills.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and insured that critical requirements were not missed.
• Created Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams by adopting UML based methods.
• Using RUP, provided technical leadership and expertise in reorganization of a complex End-to-End Testing effort and performed System Analysis and organizational review of existing QA process
• Assisted the data modelers to prepare models, and review models to ascertain the data warehouse requirements
• Prepared Logical Process and Data Models that contained sets of diagrams and supporting documents of essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze business data requirements.
• Framed Business Process Models that incorporated modeling of all the business activities from the conceptual to the procedural level.