SUMMARY

• Over 8 years of IT experiencein 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.
• Solid understanding of Data Warehousing concepts.Extensive 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 ETLprocessusingInformatica with expert level skills.
• Strong experience in Scripting, developing and designing 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.
• Experience with Sopheon Accolade Process Manager, Product Portfolio Management.
• Strong Data analytical skills 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.

TECHNICAL SKILLS

Business Intelligence Tools: QlikViewDesktop,Server & Publisher 11.2/10.0/9.0/8.5 , Sopheon Accolade APM, PPM, Microstrategy 9, SSIS, SSRS

ETL Tools: Informatica Power Center 8.x/7.x (Source Analyzer, Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation Developer).

Data Modeling Tool: Erwin, Toad.

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/05, IBM DB2, Sybase, MS Access 2000.

Programming tools: C, SQL, PL/SQL, HTML and Java - Scripts, VB Scripting, putty, ASP.Net.

Operating Systems: Windows XP/NT/2000, Windows Vista, Unix.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr. QlikView Developer

Responsibilities:

• Played a pivotal role in gathering the business requirements and preparing Business requirement specification (BRS).
• Worked as SPOC (Single Point of Contact) for QlikView environment in Mortgage LOB (Line of Business).
• Prepared Technical design document for all the dashboards to facilitate smoother transition to newer designs.
• Involved in setting up the QlikView environment for the Mortgage LOB by installing the desktop client and getting the access to various data sources by establishing the odbc and oledb connections.
• Created an efficient data model for the dashboards.
• Involved in extracting, transforming and loading the data from various data sources for the dashboards development.
• Worked on ‘Code Refactoring’ for the Originations and Fulfillment Dashboard enhancement.
• Responsible for Creating, designing and maintaining various mortgage QlikView analytical Dashboards by identifying the data sources.
• Provided continuous production support by reviewing QlikView log files and recertifying any errors.
• Involved in performance, load and unit testing followed by troubleshooting and immediate production releases.
• Worked with QlikView Center of Excellence (QlikView Admin team) whenever there is task failures for any of the Mortgage LOB related dashboard reload.

Environment: QlikView 11.0/11.2, SQL server, DB2, Oracle 11.2.

Confidential, Vienna, VA

Sr. QlikView Developer

Responsibilities:

• Interacted with customers to gather business requirements and developed functional and technical specification document
• Participated and proposed new business analysis for data which has no prior reports
• Extracted data from the database, stored into QVD files, and wrote load scripts
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports
• Eliminated Synthetic keys, ambiguous relationships and closed loops
• Designed proficient dashboards according to the requirements
• Established a secure environment using QlikView Section Access.
• Wrote QlikView macros, variables, user friendly functions, and built reusable master framework
• Implemented QlikView desktop and publisher, managed user authentication, established publisher tasks, streamlined loading procedures and reviewed log.
• Enhanced existing dashboards with new functionalities and tuned ETL scripts for better performance.
• Implemented Sopheon Accolade APM to create Dashboards for design and deployment to measure and improve the product performance with DoD 5000 modeling for Life Cycle Cost Estimating (LCCE) process.
• Data integration for Product Lifecycle Management (PLM) was done by using the Sopheon and also the ERP planning, Product data management, Project management.
• Worked with Product Portfolio Management (PPM) for a new product investment and for aligning resources for strategic growth of the company.
• Provided training and supported client-in house business users

Environment: QlikView 10.0, Sopheon Accolade Process Manager(APM), Sopheon Product Portfolio management(PPM), DoD 5000, Oracle, SQL server, Toad SQL Developer.

Confidential, Marysville, OH

Sr. QlikView Developer

• Involved in Business requirement gathering and Participated in Joint Application Development (JAD) process with different Business Segments in designing QlikView Applications.
• Involved in exploring solutions for data inconsistency.
• Developed a metadata monitoring tool using the QVD files generated to provide stats on daily loads
• Developed SQL Scripts, database objects, procedures, functions and packages.
• Worked on data modeling and developed different complex models as per given user requirement by eliminating closed loops, Synthetic tables and ambiguous relationships.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources like SAP BW, Sales force, Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Worked with Microstrategy for data migration to QlikView.
• Designed and created dimensional, data marts /aggregate tables to support the Microstrategy reporting needs.
• Involved in designing the data model, analyzing the sources and creating the specifications for Microstrategy report generation.
• Mainly designed and developed QlikView software applications and complex server-based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives.
• Used advanced scripting, VBScript macros, advanced aggregation functions and advanced charts for applications.

Environment: QlikView 9.0, Microstrategy 9x, Oracle, SQL Server, Informatica 8.6, Toad 9.6.1/SQL Developer, SQL Loader and Sun Solaris.

Confidential, Chicago, IL

Sr.BI Consultant/QlikView Developer

Responsibilities:

• Involved ingathering,analyzing, anddocumentingbusiness requirements, functional requirements and data Specifications about the financial system.
• Designed, developed and managedUniversesin Business Objects Designer for generating the pay roll
• DevelopedDrill thrusDashboard reports which enabled users to drill between SummaryQlikViewto detail Webi reports, templates and personalization.
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs.
• Creation of reports usingreports and chartsas per the customer requirement depends on Quarter, monthly And analyzes the report with charts provided byQlikView.
• Created User Conditions and Filters to improve report generation & readability andSql tuningof report and displayed the summary of data bycreating Chartsby usingQlikView.
• Created Dashboard Reports usingQlikViewforSecuritiesData mart and using Security DM Universe as data Provider .

Environment: QlikView 8.5, SQL server, Oracle 10g, SSIS.

Confidential, Wilmington, DE

ETL Developer

Responsibilities:

• Analyzed the logical model of the databases and normalizing it when necessary.
• Involved in identification of the fact and dimension tables.
• Extensively used Informatica-Power Center for extracting, transforming and loading into different databases.
• Wrote PL/SQL stored procedures and triggers for implementing business rules and transformations
• Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.
• Created Source and Target Definitions in the repository using Informatica Designer Source Analyzer and Warehouse Designer.
• Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Rank, Lookup, Stored procedure, Sequence generator.
• Used Mapping Designer to create mappings.
• Replicated operational tables into staging tables, to transform and load data into the enterprise data warehouse using Informatica.
• Created and scheduled Worklets, configured email notifications.
• Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Used salesforce CRM application for performing data mapping as per project requirement.
• Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse
• Documented Data Mappings/ Transformations as per the business requirement.
• Performed testing, knowledge transfer and mentored other team members

Environment: Informatica Power Center 7.1.3, Oracle 9i, PL/SQL, Toad, SQL Plus, Erwin, UNIX, Tivoli.

Confidential, Raleigh, NC

SQL Developer

Responsibilities:

• Incorporated complex business logics by using stored procedures/triggers.
• Designed and wrote test cases for QA.
• Wrote APIs using PL/SQL procedures and functions
• Used DB export/import and SQL Loader utilities to transfer data from the main db to the reporting db.
• Performed validation, extraction of multi field values and populating it in application tables.
• Developed complex queries using inline views, correlated sub queries, complex joins, merge, cursors, Ref Cursors and grouping/ aggregation functionality.
• Wrote shell scripts to automate the process to identify the records to reconcile and their migration using the interfaces
• Wrote unit test programs to verify interface functionalities.
• Gap analysis, Impact Analysis, Requirements gathering by consulting users for enhancements.

Environment: Oracle 9i (SQL*PLUS, SQL, PL/SQL, Developer 2000 Oracle Forms 6i, Reports 6i, Designer 2000, SQL Loader), Windows NT, Unix.

Confidential

Programmer \ Web Developer

Responsibilities:

• Involved in Software Development Life Cyclefor multiple projects.
• Designing the modules, database tables, front-end screens, coding and reports.
• Involved in writing middle-tier components using Visual Basic 6.0 and ActiveX Data Objects (ADO) that interacts with the database.
• Writing server-side scripts using ASP that provides dynamic web pages for the user requests.
• Implementation of web interfaces using ASP, VB script on the Server-side and Java Script on the client side
• Writing SQL Stored Procedures accessed by the Components.
• SQL Server SQL Programmer analyst responsible for a variety functions including SQL Server Architecture, logicaland physical design.
• Involved in creating design documents & test cases. Involved in the integration of the Project. Testing the application.

Environment: ASP, HTML, JAVA Script, VB Script & SQL Server, Windows, IIS.

Confidential

Program Analyst

Responsibilities:

• Interacted with business customers to gather functional requirements and translated them into technical design
• Worked on all phases of software development support and production cycle
• Implemented front end design using Visual Basic forms
• Designed Conceptual Data Model and Physical Data Model using Erwin
• Extensively used SQL stored procedures and functions to fetch data from the database
• Executed complex queries and sub queries to update and insert data into the database
• Wrote unit test cases to verify interface functionalities
• Key performer during the production process
• Dealt with daily maintenance issues

Environment: SQL, VB scripting, Oracle 9i, Erwin data modeling tool