SUMMARY

• SDLC: Over 8+ Years of IT experience with expertise in Analysis, Design, Development, Customization, Implementation and Testing of various Software applications and generation of reports using Various Databases in the Warranty, financial, Sales, Insurance domain and HealthCare.
• Over 4 + years of ETL experience using Pentaho Data Integration(also called as Kettle)
• ETL: Hands - on experience with Pentaho Data Integrator(6.0.1), Data stage (8.5), ODI 11.1.1.7.
• Cognos BI: Over 2+ years of extensive experience in working with Cognos 10.x,Cognos 8.x, Report Net 1.1, Report Studio, Query Studio, Analysis Studio, Impromptu, Transformer, Power play, Cognos 8 (IBMCognos Framework Manager, Report studio, Query Studio, Analysis Studio and Cognos connection). Installed and configured Cognos 8.2 BI, BI modeling, Report Studio, Query Studio and Analysis Studio. Cognos8.3, Cognos 8.2, Report Net, Query Studio, Report Studio, Impromptu, Transformer, Power play, upfront, scheduled the Reports based on the database events using Triggers and Customized Reports using HTML and Java Scripts.
• Data Modeling: Experience in Dimensional Data modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical data modeling, Erwin 7.3/4.0/3.x and Oracle Designer
• Data Warehousing: Experience in deployment, scheduling, automated report bursting & delivery via email. Design and building cubes in Power Play Transformer. Good knowledge of ETL and Active and Passive Transformations.
• RDBMS: Database experience using Oracle 10g/9i/8.x, DB2, MS SQL Server, MS Access, Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written in Oracle and SQL Server, Relational database design concepts and in depth knowledge of OLAP solutions and DB2, and Windows server 2003/2000, SQL Server2008/2005, TOAD, AS/400, Access Manager, IIS, Oracle Streams, Active Directory, Oracle Access Manager Sybase IQ.
• Testing: Experience in developing Test cases, developing Test scripts and analyzing bugs using extensive knowledge in Manual, QTP and Test Director.
• Hands-on experience on Tableau (10.2), Pentaho report designer (5.3).
• Knowledge & experience of Software Development Life Cycle including system analysis and design, system development, integration, installation, deployment, client interaction, software development process.
• Quick learner with good analytical and communication skills coupled with a proactive attitude and good team spirit.

TECHNICAL SKILLS

Programming: C, C++, VBScript, ASP SQL, PL/SQL, SQL*Plus, Visual Basic 6.0/5.0, Java 2.0, HTML, DHTML, UNIX Shell Scripting

ETL: Pentaho (6.0.1), Data stage (8.5), ODI 11.1.1.7

BI Tools: Congo’s 10.2/8.4, Report Net1.1, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Manager, Metrics Designer, Congo’s EP Series (Impromptu, Power Play, Transformer, Cognos IWR administration, Power Play Enterprise Server and Upfront), Business Objects XI 3.1, Crystal Reports. TM1(Architect, PerspectiveTurbo Integrator and Web). Pentaho Report Desinger(5.3),(6.0.1)PentahoMetadataEditor(5.3,6.010),Pentaho Schema work bench(5.3,6.0.1).

Data Modeling: Data Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling, Erwin 4.0/3.5, Oracle Designer, Framework Manager

Operating Systems: Windows NT/2000/XP/98/95,AIX and UNIX

Web/Scripting: HTML, DHTML, VBScript, and JavaScript

Front Ends: Visual Basic, Power Builder, Developer 2000

RDBMS/DBMS: Oracle 11G DB,10G/8i/9i, MS SQL Server 2008/05/, Windows 2003/2000, T-SQL,DB2,TeraData, TOAD, Sybase, SQL Server Management Studio

Testing Tools: Manual Testing, QTP and Test Director

Presentation Tools: Ms Power Point, VISIO and Ms-Office

PROFESSIONAL EXPERIENCE

Confidential, FL

Software Engineer

Environment: Pentaho Kettle 5.3,6.0.1, SQLSERVER (2012),TOAD.

Responsibilities:

• Analyzed the functionality and business requirement and transformed the Functional Design Document into Technical Design Document.
• Used Pentaho Data Integration Designer 5.3 to create all ETL transformations and jobs.
• Created new tables, views, indexes and user defined functions .
• Used different types of input and output steps for various data sources including Tables, EXCEL.
• Worked very closely with Manager to understand the requirement of ETL and reporting solutions to be built.
• Participated in Business Analysis & Requirement collection. Interacted with Product owner on requirements clarifications.
• Created Mapping documents to define and document one-to-one mapping between source data attributes and entities in target database.
• Migrating Existing the SSRS reports to Pentaho reports.
• Developed various reports for the client using Pentaho Report Designer.
• Used Pentaho Schema Workbench to create Cubes.
• Developed Interactive models as per client requirements using Pentaho Metadata Editor.
• Worked closed with team members to define technical specifications and ETL design/coding standards.
• Created single value as well as multi-value drop down and list type of parameters within the reports.
• Worked on Conditional formatting for the Pentaho reports as per business requirement.
• Implement Security in Interactive models by assigning permissions to specific users.
• Tuned Report Queries running against Sql server to get optimal Performance.

Confidential, NJ

Software Consultant

Environment: Pentaho Data Integration (PDI v3.2 and v4.3.0, also called as Kettle),Oracle 9i/10g, Cognos Access Manger, Windows 2003 Server, Cognos 10.1.1 Suite (Cognos Connection, IBMCognos Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio)

Responsibilities:

• Worked with DBAs to archive the old data to get more performance on the loads.
• Good experience in using various PDI steps in cleansing and load the data as per the business needs.
• Good experience in configuration of Data integration server to run the jobs in local, remote server and cluster mode.
• Made use of different steps in PDI designer to cleanse and manipulate source data like Database Lookup & Join, Generate rows, Row normalizer, Java Script, Add constant, Add Sequence etc.
• Scheduled the jobs using Pentaho Scheduler.
• Created sessions, workflows, database connections, scheduled using Pentaho.
• Provided technical support to other developers and coordinated escalation of issues.
• Implemented ETL’s with dynamic schemas.
• Analyzing the requirements with Business Analysts and Reporting Team Lead.
• Develop the jobs and transformations for initial load and incremental load in to staging and DW as per the requirements.
• Created related models and schemas, joins, namespaces, query subjects, filters and calculated fields in Framework Manager
• Built Framework Manager Model, and established the cardinalities to suit the business needs.
• Created packages in Framework Manager to publish cubes to Analysis Studio.
• Customized Cognos Connection with appropriate reports and security measures.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Implemented security for Data access, Object level access and Package access.
• Modifying the existing report based upon the change request by the user.
• Created drill through reports from multidimensional summary reports to detail relational reports.
• Resolving the Performance issues of the Reports.
• Deployment of reports from Development to Production.
• Experience with conditional blocks and conditional layouts.
• Involved in Performance Tuning of Cognos Models/Reports.
• Experience in Developing Dashboards using cognos work space and cognos workspace Advanced.
• Experienced with migration of Cognos code (reports/models/ frameworks) from one environment to another.
• Sound Skills on Developing Score Card Applications using Metric Manger and Metric Studio
• Trained business users on Query Studio for ad hoc reporting.

Confidential, CA

Associate Consultant

Environment: Cognos 10.1 Report Studio, Analysis Studio, Query Studio, DB2, Pentaho Kettle(3.2).

Responsibilities:

• Analyzed the functionality and business requirement and transformed the Functional Design Document into Technical Design Document.
• Gathering the Information to create Business Process Bus Matrix.
• Creating ETL transformations and jobs using Pentaho Kettle Spoon.
• Made use of different steps in PDI designer to cleanse and manipulate source data like Database Lookup & Join, Generate rows, Row normalizer, Java Script, Add constant, Add Sequence etc.
• Created mapping documents to define and document one-to-one mapping between source data attributes and entities in target database.
• Saved Pentaho jobs in enterprise repository and scheduled them to run in production on daily basis.
• Extracted the data from different Sources like Excel, XML, CSV etc.
• Expert in design and development of jobs to capture CDC (Change Data Capture) from source systems.
• Involved in ETL Job Analysis.
• Using the data Integration tool Pentaho for designing ETL jobs in the process of building Data warehouses and Data Marts.
• Good experience in design the jobs and transformations and load the data sequentially & parallel for initial and incremental loads.
• Monitoring loads on Production environment.
• Deployment of ETL code from Development to QA instance.
• Developing Packages through Cognos FM Model .
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Implemented security for Data access, Object level access and Package access.

Confidential, Ohio

BI Developer

Environment: PentahoKettle (3.2),Cognos 10.2.1 (Framework Manager, Report Studio, Query Studio, Analysis Studio)

Responsibilities:

• Migrated Reports from Actuate reports to Cognos.
• Creating cross-tab reports and chart reports using multiple queries and drill down capabilities in a single report to meet the business needs.
• Creating ETL transformations and jobs using Pentaho Kettle Spoon.
• Expert in design and development of jobs to capture CDC (Change Data Capture) from source systems.
• Used Stored procedure to create Reports as per Requirement.
• Built Power Play Reports in Report Studio and Analysis Studio based on cubes published to Cognos8 Server.
• Built Power Play Reports in Report Studio by replicating the powerplay functionality in Report Studio using dynamic Measure selection, Dynamic Sorting, ranking.
• Created Dashboard Reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
• Customize the Cognos connection portal using existing portlets and customized tabs.
• Worked on complex reports using Static Prompt and mdx functions and union conditions.
• Used Cognos Office Connection to publish the reports in PowerPoint and format them for business presentation.
• Guided the customer to create custom reports in report studio by using Warehouse packages.

Confidential, Chicago

SQL Developer / BI Analyst

Responsibilities:

• Development of Report as per Functional document.
• Created List and Chart Reports.
• Involved in Report testing.
• Prepared the test cases as per functionality.
• Migrated Cubes, Reports from Version 7 to C8 using the migration utilities.
• Upgraded the environment from Cognos 8.1 to Cognos 8.2
• Creating cross-tab reports and chart reports using multiple queries and drill down capabilities in a single report to meet the business needs.
• Used Dimensional functions to build crosstab reports from cube datasource.
• Built several reports in Report Studio and Analysis Studio based on cubes published to Cognos 8 Server.
• Created Dashboards by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
• Customized the Cognos Connection portal using portlets and custom tabs.
• Created complex reports using Static Prompt and mdx functions and union conditions.
• Used Cognos Office Connection to publish the reports in PowerPoint and format them for business presentation.

Confidential

Analyst

Responsibilities:

• Development of Report as per Functional document.
• Created List and Chart Reports.
• Involved in Report testing.
• Prepared the test cases as per functionality.
• Creating cross-tab reports and chart reports using multiple queries and drill down capabilities in a single report to meet the business needs.
• Used Dimensional functions to build crosstab reports from cube datasource.
• Built several reports in Report Studio and Analysis Studio based on cubes published to Cognos Server.
• Created Dashboards by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.

Confidential

Associate Analyst

Responsibilities:

• Migrated Reports from Actuate reports to Cognos.
• Creating cross-tab reports and chart reports using multiple queries and drill down capabilities in a single report to meet the business needs.
• Built Power Play Reports in Report Studio and Analysis Studio based on cubes published to Load Server.
• Used Dimensional functions to build crosstab reports from cube datasource.
• Built several reports in Report Studio and Analysis Studio based on cubes published to Cognos Server.
• Involved in Report testing.
• Prepared the test cases as per functionality.