SUMMARY

• Over 7years ofITexperiencein system analysis, design, development of software applications and in the field of ETL methodologies, Business intelligence and data Warehousing principles and architectures including concepts, designs and usage of data warehouses.
• Strong Knowledge & experience in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production support.
• Solidunderstandingof Data Warehousing concepts.Strong experience in design & development ofBusiness Intelligence / Data warehousereporting.
• Efficient in Optimizing, Debugging and testingSQL queries.
• Experience in using different databases likeOracle10g/9i, MS SQL Server, DB2 and MS Access.
• Goodunderstandingin ETL.
• Strong experience in designing and developing dashboards using QlikView by extracting data from multiple sources (Oracle, Flat files, Excel, Access).
• Extensive experience with QlikView sheet objects, scripting, and optimizing applications and building qvd’s and qvw’s.
• Hands on Experience with QlikView Architecture in development and deployment.
• Experience in setting up server, publisher configurations and security/ authorization at different levels.
• Strong understanding of Dimensional Modeling technique, Multi Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Automation and Macros interface, Section Access, Set Analysis in QlikView and DW concepts.
• Strong Data analysis to ensure accuracy and integrity of data in the context of Business functionality.
• Job roles include gathering Business requirements, establishing functional specifications, translating them to design specifications.
• Excellent understanding of financial statements and corporate finance principles with solid training in valuation, financial analyses, budget forecasting and portfolio management.
• Team orientedindividual with a results driven attitude, strong interpersonal and communication skills in effective information exchange and interaction with clients at all levels of management.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte

QlikView Developer

Responsibilities:

• Involved in understanding Business requirement and development of technical specification documents.
• Developed different dashboard with a complex database system which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Connected to different ODBC, OLE DB data sources Oracle and flat files to create and schedule different complex reports as per given Business requirement by leveraging the basic components of QlikView.
• Developed different KPI’s as per requirement using advanced set analysis.
• Implemented section access so as to enable specific data and sheets to specific users.
• Worked on building up the data model as per Business requirements.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
• Automated and scheduled daily data loads of QVW documents using QlikView Publisher.
• 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.
• Implemented section access which allows user to see by default their Region’s data and population attached to a particular Region.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front - end, improving layout structure.
• Enhance existing dashboards with new functionalities and Tune ETL scripts for better performance.
• Research and troubleshoot technical problems and Provided ongoing QlikView consultation to the development team

Environment: QlikView 10, Oracle 10g, PL/SQL Developer

Confidential, Chicago

Qlikview Developer

Responsibilities:

• Created QlikView dashboard user interfaces as per the business requirements.
• Consolidated data into QlikView from various data sources (SQL Database, Oracle Databasetext files and excel files).
• Developed KPI’s and set analysis expressions.
• Created QVD’s & updated on timely basis as database updates.
• Created and scheduled Complex reports by leveraging the basic components of QlikView.
• Handling user security using section access.
• Providing support analyst when internal teams have enquiries.
• Research and troubleshoot technical problems.

Environment: QlikView 9, Oracle 9i/10g, SQL Server, HTML, Windows 2003 Server.

Confidential

SQL Developer

Responsibilities:

• Involved in analysis, design and development of the system.
• Created database Objects Tables, Indexes, Views, Synonyms.
• Created stored Procedures, Functions, Triggers by generating the specified reports.
• Tuning of the SQL queries using Explain Plan, SQL*Trace ..
• Created the database from full export for the Table space point in time recovery.
• Modifying the database design and structure, as necessary, from time to time upon information given by application users and developers.
• Implemented integrity Constraints on database tables.
• Involved in preparing documentation, Testing and debugging.
• Modified report wherever needed as per the suggestions given by business analyst and Analyzed the existing Actuate.

Environment: Sun Solaris 7, Oracle9i, Oracle Enterprise Manager, SQL*LOADER, Erwin.