SUMMARY:

• Over 12 years of IT experience in the field of Information Technology with experience in implementation of all phases of Data warehouse development lifecycle, from gathering requirements to testing, implementation and support.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and Informatica and developing ETL packages.
• Experienced in Data visualization reporting tool Qlikview 9, Qlikview 10.
• Experienced in reporting tools Cognos 10.1, Cognos 10.2 and their components Cognos Framework Manager, Report studio, Query studio, Analysis studio, Power Play Transformer, Impromptu Web Reports (IWR), and Cognos Report Net 1.02/1.1.
• Experience on various RDBMS like Oracle 10g/ 9i/ 8i, DB2, SQL Server 2000, MS - Access.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

  Experience in working with Microsoft Office Programs (Word, Excel, PowerPoint, and Access).

• Extensive experience in Software Development Life Cycle (SDLC) with Agile and Test Driven Methodologies that includes Scrums, daily Stand-ups and client interaction.
• Worked on different environments using Win NT 4.0, Linux, and UNIX - Sun Solaris 2.x, IBM-AIX, and HP-UX64.
• Knowledge in Development, Testing and Implementation of client/server applications using Oracle, SQL Server, Sybase, SQL Reporting Services Reports and Microsoft Analysis Services.
• Working knowledge ODBC, OLEDB, T-SQL, SQL, PL/SQL, Stored Procedures, Functions, Packages, Triggers and scripting languages.
• Strong team player, commitment towards learning and possess excellent communication, and interpersonal skills

TECHNICAL SKILLS:

BI Tools: Qlikview 11, Qlikview 10, SQL Enterprise Manager, SQL Management Studio, Cognos 10.1, Cognos10.2, Cognos 8.4, BI tools (Report Studio, Analysis Studio, Query Studio, Cognos Connection), Framework Manager, Cognos Impromptu, PowerPlay Transformer, ReportNet 1.02/1.1, Impromptu Web Reports (IWR), Access Manager, PowerPlay Enterprise Server, Scheduler.

ETL Tools: Informatica Power Mart v6.1/5.0 & Power Center v6.1/5.0, MS-SQL Server (DTS/SSIS)

Data Modeling Tools: Erwin 4.0/3.5, MS Visio

Databases: SQL Server 2000/2005 Enterprise/SQL Server 6.5/7.0, SQL Server 2008, Oracle 8i/9i/10g, DB2, GreenPlum, Teradata

DB Tools: SQL*Plus, SQL*Loader

Languages: Java, Visual Basic 6.0, SQL, PL/SQL, T-SQL

Operating Systems: Windows 95/98/XP/NT, UNIX (Sun Solaris), Linux

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Tech Lead

Responsibilities:

• As a BI Qlikview lead, work with the Business in gathering requirements and provide accurate BRD to the BI qlikview team and then work with the Business in validating the reports and enhancements.
• Leading the BI Qlikview team in making huge business changes with respect to ABACUS migration (Business change in bringing new business concepts into JDE)
• Maintained Server for smooth QlikView development. Checked and updated environmental file, assigned task, path and triggers for QMC, QEMC.
• We follow Agile methodology holding scrum meetings every day and Retrospective Meetings every week.
• Part of my job is to work with another Vendor in gathering requirements for new as well existing Qlikview Apps.

Environment: Qlikview 10, Qlikview 11, SQL Server 2005, SQL Server 2008, SSIS, Agile Methodology

Confidential, Gainesville

Tech Lead

Responsibilities:

• We followed Agile methodology. I was part of BI team based out of Houston Headquarters working for advertising group.
• Worked directly with business team right through the requirements phase.
• Worked with the team in Qlikview Server Administration to schedule App/ reschedule on the server, and maintain the Session CALS and Named User CALS.
• Made enhancements too existing Qlikview App and developed a new Qlikview App with a dashboard and few other tabs from the scratch.
• Implemented security on the Qlikview Apps through Section Access.

Environment: Qlikview 10, SQL Server 2005, MS Excel, Agile Methodology

Confidential, Chicago

Tech Lead

Responsibilities:

• Implement Agile Methodology by being scrum master in holding scrum meetings and assigning tasks.
• Worked on gathering requirements for Qlikview Applications.
• Designed and created Qlikview applications as per user requirements
• Supported and enhanced the performance of existing Qlikview Applications.
• Used Qlikview Server to burst out reports in PDF format to Market Managers across the hotels. Created PDF push reports based on ‘loop and reduce’. Alternatively, wrote VB scripts to perform the same (based on requirement of user).
• Monthly distributed to specific user group via email, through publisher. Worked on various export options in Qlivkiew
• Worked on Cognos 10.1 migration to 10.2.
• Worked on Analysis Studio, Report Studio and Query Studio in Cognos 10.1 and 10.2
• Created and published packages in Framework Manager based on the reporting requirements.
• Extensively worked on different options in Report Studio like burst options, repeater options, master detail options etc. to meet the user requirements. Developed standard templates in Report Studio for developing reports.
• Worked on PowerPlay Transformer to create multidimensional models after importing source data IQDs and Architect Models. Enhanced the model by adjusting the dimensions, levels, creating categories, calculated measures, alternate drill downs.
• Created PowerPlay Transformer Models and Power Cubes Created daily, weekly, monthly and quarterly reports for the management team and field operation Managers using Power Play for windows.
• Tested and improved report performance, optimized cube performance by conducting incremental updates and partitioning cubes.
• Designed and created stored procedures, configuration files, tables, indexes, views, and functions; implemented best practices to maintain optimal performance.

Environment: Greenplum, Cognos 10.2, 10.1(Analysis Studio, Report Studio, Query Studio, PowerPlay Transformer), Informatica 9, Qlikview 10, Agile Methodology, MS Excel, Java sdk, Teradata

Confidential, Chicago, IL

BI Sr Developer

Responsibilities:

• Involved in requirements gathering and design of data warehouse and data mart entities.
• Built SSIS packages for loading data into fact and dimension tables.
• Worked on Analysis Studio, Report Studio and Query Studio in Cognos 8.
• Created and published packages in Framework Manager based on the reporting requirements.
• Extensively worked on different options in Report Studio like burst options, repeater options, master detail options etc. to meet the user requirements. Developed standard templates in Report Studio for developing reports.
• Worked on PowerPlay Transformer to create multidimensional models after importing source data IQDs and Architect Models. Enhanced the model by adjusting the dimensions, levels, creating categories, calculated measures, alternate drill downs.
• Created PowerPlay Transformer Models and Power Cubes and implemented Drill through to Report Studio reports and Impromptu reports.
• Created daily, weekly, monthly and quarterly reports for the management team and field operation Managers using PowerPlay for windows.
• Tested and improved report performance, optimized cube performance by conducting incremental updates and partitioning cubes.
• Designed and created stored procedures, configuration files, tables, indexes, views, and functions; implemented best practices to maintain optimal performance.
• Was part of SQL server administration, which involved developing proper maintenance and back up plans (as a part of disaster recovery).

Environment: SQL server 2005, Cognos 8(Analysis Studio, Report Studio, Query Studio), Cognos ReportNet 1.1 MR2 (Cognos Connection, Report Studio, Query Studio, Frame Work Manager), PowerPlay 7.3, PowerPlay Transformer 7.3, Power Play Enterprise Server, Access Manager, Cognos Scheduler, IIS Web Server, TOAD

Confidential

Sr Software Engineer

Responsibilities:

• Communicating with Business Analysts to resolve the requirements issues for the team.
• Developed a web application using Struts framework.
• Developed a user interface using Struts and Java server faces as the presentation layer.
• Developed the Use Cases, Activity, Sequence and Class diagrams using Rational Rose Enterprise.
• Used Front Controller, View Helper patterns for the front end development.
• Used Service Locator, Business Delegate, Session Façade, Data Transfer Object, Value List Handler and Data Access Object patterns across the application for Middle tier.
• Used XML Parsers, XSL and XSLT for Parsing, Importing Exporting Data and Transforming data in to different Formats.
• Used Rational Clear Case for source control
• Have done unit testing using Junit
• Wrote batch programs which are used to upload data into the tables.

Environment: Java/J2EE, Struts Framework, Servlets, JSP, UML, Web sphere 6.0, RAD 7, Rational Clear Case, MS SQL server 2005, Rational Rose.

Confidential

Module Lead

Responsibilities:

• Managed a team of 4 and also responsible for the overall project.
• Design and Architecture Level Contribution.
• Developed new CCR’s, PIR and also involved in task planning and task allocation.
• Involved in the designing of the modules with the architecture team (MVC architecture).
• Designed and Developed Action classes, Service classes.
• Involved in designing new tables according to the requirement.
• Wrote stored procedures for validations of data and to send data back to the database using T-SQL.
• Used JDBC/Connection Pooling to connect to the Database.
• Developed the backend using Servlet, Java Beans and JDBC.
• Integrating Java Messaging Service with applications.
• Designing and developing Data Transfer Objects.
• Used XML Parsers, XSL and XSLT for Parsing, Importing Exporting Data and Transforming data in to different Formats.
• Used JDBC, to work with Stored Procedures to accomplish Business Logic implementation on Server Side.
• Involved in developing ant Script.
• Involved in design and code review meetings
• Developed Stored Procedures for Transmission and Reconciliation module.
• The Application was deployed on Web Sphere Application Server.

Environment: Java, J2ee, EJB, Sql Server 2000, Web Sphere Application server5.1, VSS, Struts Framework

Confidential

Responsibilities:

• Was involved in formulating different tests in NCFM
• Was involved in customizing study material for the different NCFM tests
• Was part of team in conducting and evaluating NCFM tests
• Adhere to customer queries and problems through email and phone.