SUMMARY

• 7+ Years of IT Experience in Business Intelligence Tools and Database Design
• Over 3+ years of diverse progressive experience in Information Technology, with emphasis on Business Analysis using QlikView. A motivated, quick - learner, detail-oriented team player with excellent communication, analytical and interpersonal skills and an ability to effectively interact with technology as well as business counterparts
• Good exposure to the complete life cycle of Business Intelligence Qlikview Projects such as requirement analysis, High & Low Level design, development of reports/dashboards using QlikView, User Acceptance Testing, Go-Live, Support.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Knowledge on Data Warehousing concepts like, Star Schema, Snow-Flake, Fact and Dimension Tables, Master Data Management.
• Developed executive dashboards using QlikView 10.0/11.0 and delivered through the web.
• Good understanding ofQlikViewArchitecture. Extracting, Transforming and Loading data from different data source. Incremental loading is implemented.
• Design of QlikView applications using QlikView Data (QVD) files generated by ETL logic.
• Expertise in designing and modeling of QlikView with complex multiple data sources (SQL, Flat Files, Excel and Access, SAP) relational designs.
• Functioned as the Onsite / Offshore coordinator for a team.
• Extensive experience in gathering, managing and documenting business and functional requirements, communicating effectively with upper management, developers and QA engineers.
• Excellent in writing QlikView Scripts, expressions, set analysis & macros.
• Working on Qlikview which connects to multiple data sources (via MS SQL Server, Oracle and MS Access)
• Experience in complete Project Life Cycle including documentation, analysis, development and testing
• Knowledge of Industry Best practices in both Business Management and Technology Domain
• Adept at solving complex problems through systematic approach that uses innovations and partnering combined with Project Management Principals to maximize ROI.

TECHNICAL SKILLS

DBMS/RDBMS: MS-SQL Server 2012/2008R2/2005/2000, QlikView, T-SQL, PL/SQL.

ETL: SQL Server Integration Services (SSIS), T-SQL Stored Procedures

Operating System’s: Windows server 2003/XP/NT 6.0/98/Vista,7,8, Ubunto.

Data Modeling: Microsoft Visual Studio 2008, SSAS.

Office Tools: MS Word, PowerPoint, Excel, One note, MS Operations Manager.

PROFESSIONAL EXPERIENCE

Confidential, BEDFORD, MA

QLIKVIEW BUSINESS INTELLIGENCE DEVELOPER

RESPONSIBILITIES:

• Collaborated with Business users and functional teams to develop business requirements documents, define the Key performance Indicators and identified the various source systems to fetch the required data in order to build the data model in the Qlikview.
• Developed QlikView load scripts in 3 Tier Architecture - Source Layer(Database), Transformation Layer(QVD), Presentation Layer according to the requirements of the End User.
• Ensured the data model is efficient and solved synthetic keys and closed loops formed while building the data model.
• Established the connection string and extracted the data from several source systems like Oracle, Linked servers in the SQL and Excel sheets.
• Worked on implementing the Incremental Load strategy to improve the loading performance.
• Built the front end Qlikview Dashboard by using various in built and widely accepted components which fulfills the requirements of the users.
• Emphasized on data integrity to good chart aesthetics.
• Designed intuitive visuals utilizing; containers, sliders, charts, pivot tables, etc.
• Gave a presentation for the End users about the functionality of the Qlikview and walkthroughs on how to use the features and how to access the dashboard from the Access point.
• Implemented Section Access and hidden scripting for the Application Security.
• Performed testing the dashboard functionality, loading performance, data performance in order to display on the charts and look and feel of the entire dashboard.
• Involved in the deployment of the dashboard from Dev to QA and tan to production.
• Performed unit testing and Regression testing across all the systems and took sign off from the required users at each stage before deployment.
• Involved in scheduling the dashboard in the Qlikview Management Console (QMC) and added the users and users groups to the distribution list.
• Also involved in the developing the ad-hoc dashboards by using Excel as the Source.
• Worked on the documenting the complete project and a point of contact for the status tracking and deployment for all the tickets related to Qlikview.

ENVIRONMENT: Qlikview 11, MS SQL Server 2012, Oracle 10, SQL Azure, SSRS

Confidential, CA

QLIKVIEW DEVELOPER

RESPONSIBILITIES:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data Specifications about the financial systems.
• Analyzed the Infrastructure, ETL processes including staging areas, log tables, job schedule time and generated Reports.
• Developed Drill Down through Dashboard reports which enabled users to drill between Summary to detail Web reports, templates and personalization.
• Designed and developed the Data mart for the QlikView dashboards in star schema/snow-flake schema. Identified various sources and designed the data transfer and transformations with in QlikView.
• Creation of reports using reports and charts as per the customer requirement depends on Quarter, monthly And analyzes the report with charts provided by Qlikview.
• Developed SET ANALYSIS to provide custom functionality in Qlikview Applications.
• Implemented Section access and Hidden scripting for the Application Security.
• Created User Conditions and Filters to improve report generation & readability and SQL tuning of report and displayed the summary of data by creating Charts by using QlikView. Worked with business users to gather in-dept business requirements
• Developed complex stored procedures comprised of stock market and commodity metrics
• Developed and designed complex user defined functions focusing on foreign currency compatibility
• Created and implemented enterprise reporting solutions using SSRS
• Designed Enterprise business applications which managed accounting, client history and global market trends using SSRS
• Designed, developed and deployed SSRS reports that include; parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, sub reports
• Created unique data driven email subscriptions within report manager
• Developed hierarchy managerial email subscriptions to managers, business users and share holders
• Maintained version control through report manager and sharepoint.

ENVIRONMENT: QlikView 10(SR4), Oracle 10g, SQL server, Access DB, SQL developer, MS SQL Server 2008/2005, Reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS)

Confidential

MS SQL Developer

Responsibilities:

• Responsible for installation, configuration and maintenance of MS SQL Server on various environments
• Created various complex stored procedures for ETL as well as maintenance of the database
• Developed stored procedures and T-SQL code to accomplish various tasks
• Created the different user defined functions in the application
• Created triggers, UDF, views, tables and generated T-SQL script for application and indexes for better performance
• Tuned SQL statements and Stored Procedures
• Posted HTML files to server and updated database and returned the response back to ASP.NET.
• Involved in designing and creating Web UI screens using ASP.Net
• Transformed data from various data sources using OLE DB connection by creating various DTS packages
• Combined a few simple, unrelated Database Accesses to improve performance
• Managing disk space on Windows NT systems
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications

Environment: MS SQL Server 2000, DTS, .NET Framework, HTML, MS Excel, MS Access, SQL, Visual Basic 5.0, and ASP/VB.NET.

Confidential

SQL Developer

RESPONSIBILITIES:

• Gathering user requirements and designing Database accordingly which involves creating Logical Data model and Physical Data modeling.
• Used Oracle PL/SQL for implementing business rules and do performance tuning procedures.
• Creating many physical objects (table, constraints, index, function) to facilitate the smooth data retrieval
• Loading data into the intermediate tables using UTL FILE and Sql Loader.
• Designing, Developing & Fine Tuning data-retrieval & data-migration scripts.
• Involved in Interacting with users, error fixing by enhancing PL/SQL packages, stored procs & functions.
• Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.
• Developed comprehensive reports, cross reference listings and statistical reports using Oracle Reports/Graphics, complex SQL queries (with all kind of joins and groupings, etc.) and analytical functions feature built into Oracle9i.
• Created custom folders, item classes in Discoverer Administration, cross tab, page detail reports, conditions, parameters, sharing of workbooks in Desktop edition of 4i.
• Trained End User’s to familiarize with Discoverer Plus and Viewer Tool.
• Designed and developed the user interfaces in Forms 6i to maintain sale transactions, receipt generation and dealer wise reports.
• Closely worked with DBA in monitoring the performance related issues using SQL Trace and TKPROF utility
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Environment: Windows, Linux, Toad, ER Win, Sql Developer and SQL * Loader.