SUMMARY

• Around 8 years of experience in Business Intelligence Reporting projects with strong background in Analysis, Design and Development and implementation of BI applications
• Good at understanding business requirements and analyzing business issues and providing possible reporting solutions to end users.
• Understanding of data modeling and dimensional modeling, and designing Star and Snowflake schemas
• Expertise in designing and modeling of data with complex multiple data sources (Oracle, SQL Server, SAP BW, Flat Files, Excel and Access, relational designs)
• Proficient in data loads, database integration/conversions, performance tuning and optimization.
• Proficient in creating data models, reports, interactive GUI and dashboard using different data sources like Oracle, Access, text files, excel documents etc. as per the user requirement.
• Good knowledge of Data Visualization, Data reporting, Data Warehousing Models, Data discovery, RDBMS concepts, SQL, PL SQL, Oracle and SQL Server.
• Expertise in Data Analysis, optimizing, Debugging and testing SQL queries.
• Excellent analytical, co - ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.
• Experience in Incremental Loading and document Versioning
• Experience in dashboard design, aggregation functions, multi-dimensional objects, set analysis, SQL scripts.
• Understanding of Unit Testing, Functional Testing, System Integration Testing.
• Utilize QlikView Publisher for client application rollout to Access Point and administrator security using Active Directory technology.

TECHNICAL SKILLS

Database: SqlServer, Oracle, Access, Excel, SAP

Languages: SQL, PL/SQL.

BI Tools: QlikView, Business Objects, MS-Office, Outlook.

Operating Systems: Windows9x/XP/NT/2000

PROFESSIONAL EXPERIENCE

Confidential, FL

Qlikview Developer /Reports Consultant

Responsibilities:

• Leveraged QlikView Software applications to create Reports & dashboards
• Extracted data from various sources (SQL Server, SAP BW, Hyperion, Access db, text files and excel documents), used ETL load scripts to manipulate, concatenate and clean source data. .
• Developed QlikView applications for ETL feeds using QlikView Data file (QVD) technology.
• Designed the data models for QlikView and development of UI for dashboards
• Developed Graphical User Interactive reports using various Objects.
• Implemented incremental Load strategy.
• Implemented data level security using Section Access feature of QlikView.
• Conducted User Training Sessions and User Manual Document.
• Helped client reporting teams migrate from traditional static Excel reporting and other existing reports to a more interactive and powerful dashboard solution.

Environment: QlikView 11, SQL Server, Microsoft Access, Windows 7.

Confidential, Atlanta, GA

Qlikview Developer / BI Developer

Responsibilities:

• Developed dashboards pertaining to Revenue and Sales monitoring using QlikView.
• Demo of QlikView dashboard to users to enhance their knowledge on all the key capabilities of QlikView application
• Designed dashboards for Project/Resource analysis application and Enterprise Key Metric application.
• These dashboards were utilized by higher management to do analysis, product development and their market share.
• Met with users to understand existing reports and issues.
• Analyzed and gained understanding of the underlying data. Enterprise Key Metric dashboard is sourced from multiple excel files.
• Created data model in QlikView desktop to get all the data in required format. Used Mapping tables, Apply Map, resident load, concatenate, variables and so on.
• Designed dashboard using the various sheet objects Current selection, list boxes, search, Straight table, Pivot table, Bar chart, Combo chart and so on.
• Used Set analysis, Set modifiers.
• Published dashboards on Access point.
• Performed UAT and successful production migrations and handover to production support to close the projects.

Environment: Qlikview10, SQL Server, MS Access, Excel, Windows XP.

Confidential, NY

MS SQL Server Developer

Responsibilities:

• Migrated heterogeneous databases to MS SQL Server 2008R2.
• Developed logical and physical data model using MS Visio and mapped the data into database objects
• Designed and created different ETL packages using SSIS from My SQL Source to SQL server 2008R2
• Created SSIS Packages to export and import data from Text files, CSV files, Microsoft Access and Excel Spreadsheets
• Designed and implemented SSIS packages for data integration
• Designed and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them
• Extensively worked on Cross Tabbed and Matrix reports using SSRS
• Designed and implemented indexing to optimize transactional and reporting performance.
• Installed SQL Server on Windows 2008R2 Server.
• Assisted in the Analysis and Design of database.
• Designed drilldown, drill through, and parameterized report using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Designed, reviewed, and created primary objects such as views, indexes, views and store procedures.
• Worked with User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least update to improve the query performance.
• Defined referential relationships with the measure groups and fact tables.
• Documented the development work and production release for future reference.

Environment: Windows OS, MS SQL Server 2008R2, 2012 MS SQL Server Reporting Services 2008R2, 2012 MS SQL Integration Services 2008R2,2012, T-SQL, Microsoft Visio, SQL profiler, MySQL.

Confidential, CA

MS SQL Server Developer

Responsibilities:

• Developed physical data models and created DDL scripts to create database schema and database objects.
• Used T-SQL to create various queries.
• Carried out a Developer’s role on MS SQL Server 2005, MS Access Databases (using DTS, Stored Procedures and Views).
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
• Daily Database backups and integrity checking.
• Created SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, Script Components, Error Handling.
• Creation/Maintenance of Indexes for fast and efficient reporting process.
• Developed SQL Scripts to Insert/Update/Delete data, satisfying the referential integrity constraints.
• Involved in Data Migration and used SSIS to import and export data into tables using SQL Server 2005, creating tables, views and Stored Procedures using SQL Server.
• Performance tuning to optimize SQL queries using query analyzer.

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).