Tuesday, 19 June 2012

HOT LIST -------QA,SQL SERVER DBA , OBIEE Developer,Oracle BI Apps,Network Engineer,Business Analyst ,Microstrategy


Good morning,

The following consultants possess above good technical abilities, solid communication skills, and most are open for relocation. Please feel free to contact me for additional information.

 

Thanks!

Satya

 

Name

Primary Skills

Total/US Exp

Mallikarjun Chinnam

OBIEE ,OBIEE Administration tool, Informatica, Database, Financials, Oracle Applications E-Business Suite ,Reports, interfaces , conversions , extensions , Supply Chain Analytics, Dimensional Modelling ,LAP,AR,OM,PO,INV,HR ,Dynamic Dashboards ,BI Server, BI Answers, BI Dashboards ,BI Delivers ,

SQL Developer, SQL * Loader, SQL * Plus, Data Loader, TOAD ,PL/SQL, Developer 2000 , Oracle Discoverer 10g/4i, XML Publisher 5.6.3/5.6.2

7+Yrs/5+Yrs

Heta Raval

Java, C, C++ ,  EJB, RMI, CORBA and COM/DCOM, XML, HTML, Ajax, Java Script, VB Script, ASP, JSP and Java Servlets, PHP ,  IBM WebSphere, BEA WebLogic, Tomcat, and IIS,  WinRunner, LoadRunner, Test Director, ManualTesting,J2ee Mercury Diagnostics, QTP, Bugzilla, Quality Center, SOAP UI, Crystal reports, Reports 2.5, SQR, Windows NT, Windows 2000 Server, Solaris, HP Unix, Linux and Citrix, SQL and PL/SQL, ORACLE, SQL Server, Sybase and DB2, ETL, SWING, Jbuilder, Eclipse, WSAD J2EE, JMS, JNDI, Java Mail, Web Services, Struts.

6+Yrs/5+Yrs

Rekha Poreddy

Java, C#, ASP.NET, VB.NET,JSP, JDBC, JDOM, XML, VB,C, C++, Java Script-SQL, PL/SQL , MS SQL Server 2000/2005/2008 R2, MYSQL 5.0, Oracle, MS Access, DTS, SSIS, Informatica , Visual Studio 2005, Visual Source safe, Microsoft Visio, MS Excel,  Win Runner 7.5, Load Runner 7.0, Rational Suite, QTP 8.0, Test Director, Web Tools(Dream weaver), Macromedia Flash 2004, Siebel MS expression web and MS SharePoint designer , SQL*Plus, SQL*Loader, TOAD, SQL Navigator, SQL Developer

6+Yrs/4+Yrs

Srikanth

Oracle Financials E-Business suite R12/11i (Order Management, Inventory, Purchasing, General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Cash Management, AOL, System Administrator, OBIEE10.1.3.x, Siebel Analytics 7.5/7.7/7.8, Oracle Reports 10g/6i/4i, Oracle BI Apps 7.9.x Oracle Forms 10g/6i/4i, Discoverer 10g/6i/4i, XML Publisher 5.6.3/5.6.2, TOAD 9.7.3/8.x, SQL*PLUS, Data Loader, SQL*Loader, SQL  Developer , Informatica Power Center 8.1.1, 7.1, 6.2, 5.1,DAC 7.8.5v, SQL, PL/SQL, C, C++, C#, HTML, XML , Oracle 10g/9i/8i, MS Access, SQL Server 7.x, 2000.

8+Yrs/5+Yrs

 

  • Please scroll down and view more information about consultant.
  • Please feel free to contact me for additional information.

 

Regards,
Satya

RAPISOURCE LLC
Sourcing IT Talent

Direct:  512-430-4553 
Fax:      512-287-4047

Email: Satya@idolsoftconsulting.com

 

Consultant List

Name

Mallikarjun Chinnam - OBIEE Developer

Primary Skills

OBIEE ,OBIEE Administration tool,Informatica,Financials,Oracle Applications E-Business Suite ,Reports, interfaces , conversions , extensions , Supply Chain Analytics, Dimensional Modelling ,LAP,AR,OM,PO,INV,HR ,Dynamic Dashboards ,BI Server, BI Answers, BI Dashboards ,BI Delivers , SQL * Loader, SQL * Plus, TOAD ,PL/SQL, Developer 2000 , Oracle Discoverer 10g/4i, XML Publisher 5.6.3/5.6.2

     Summary

Over 7 years of experience Complete Software Development Life Cycle (SDLC)

Over 5 + years of experience in BI Implementation.

Installation and configuration of Financials, Supply Chain Analytics, Procurement Analytics and Spend Analytics and Migration of RPD.

Experience in using Data Warehouse Administration Console (DAC).

Expertise in design, development, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modelling, RPD , ETL .

Proficient within the Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration tool.

Technical expertise in GL,  AP,  AR, OM, PO, INV, HR .

Experience in configuring Interactive Dashboards with drill-drown capabilities using global and local filters .

Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.

Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.

Extensively worked on BI Server, BI Answers, BI Dashboards and BI Delivers (iBots)

Proficient in Oracle Tools and Utilities such as SQL Developer, SQL * Loader, SQL * Plus, Data Loader, TOAD and UTL_FILE.

Involved in development of RICE objects for the Oracle Applications E-Business Suite .

Experience in PL/SQL, Developer 2000, Oracle Discoverer 10g/4i , XML Publisher 5.6.3/5.6.2.

Designed Report Templates using XML/BI publisher.

 

  Total Exp: 7+ yrs,   US Exp: 5 Yrs,   Available: Immediate,  Current Location : Charlotte, NC ,   Relocation: Open

Receive Resume by EMail    

       Name

 Heta raval - QA Tester

Primary Skills

Java, C, C++ ,  EJB, RMI, CORBA and COM/DCOM, XML, HTML, Ajax, Java Script, VB Script, ASP, JSP and Java Servlets, PHP ,  IBM WebSphere, BEA WebLogic,

Tomcat, and IIS,  WinRunner, LoadRunner, Test Director, ManualTesting,J2ee Mercury Diagnostics, QTP, Bugzilla, Quality Center, SOAP UI, Crystal reports, Reports 2.5,

 SQR, Windows NT, Windows 2000 Server, Solaris, HP Unix, Linux and Citrix, SQL and PL/SQL, ORACLE, SQL Server, Sybase and DB2, ETL, SWING, Jbuilder, Eclipse,

WSAD J2EE, JMS, JNDI, Java Mail, Web Services, Struts

Summary

Over 6 years of diverse experience in Software Testing and Quality Assurance.

Strong Manual Testing  BI / Data Warehouse Testing, SQL Database experience.

Working knowledge of  Micro Strategy, SOAP UI, Websphere,Weblogic experience, Teradata & Retail industry experience.

Proficient with HP Quality Center for creating scripts, tracking defects, and reporting , Automated testing, JMeter, Load Runner

Experience in writing Test strategy, Test scenario, Test plan, Test cases, Bug reports and developing Test scripts.

Expert in Data Conversion, Batch, integration, regression, functional & UAT tests.

Experience in the areas of GUI, Functional, Integration, System, Front-end, Regression & Web Services testing for Client Server and web applications.

Experience in reproducing and reporting software problems and defects using different bug tracking systems (ClearQuest, HP Test Director, Compuware QA Director, Bugzilla, etc.)

Experience in Regression Testing by designing Automation Test-Suites involving a comprehensive and Time-Effective Automation Framework using HP-Quick Test Professional (QTP) and Compuware Test Partner .

Expertise in Risk Analysis, preparation of RTM & Prioritize Test case.

Familiar with Oracle, PL/SQL and MS SQL Server Databases.

Independent Verification & Validation of software product/process compliance to standards, policies, Procedures & output/behavioral requirements.

Professional experience in designing test cases and test scripts for Windows, Java and UNIX environments.

Working Knowledge  of TFS Application .

Did ATM simulator, and device handler testing.

Experienced in distributed testing, multi-user testing and database testing.

Strong skills in Batch & back-end testing using SQL queries on SQL Server 2000 and Oracle.

Ability to work independent or as a team member, excellent written and verbal communication skills.

Excellent interpersonal skills and ability to work in a cross-functional environment.

Excellent problem solving and multitasking. Quick learner and able to work under pressure to meet deadlines.

 

  Total Exp: 6 years,   US Exp: 5+ Years,   Available: Immediate ,  Current Location : Charlotte, NC ,   Relocation: Open

Receive Resume by EMail    

Name

Rekha Poreddy - SQL Server DBA

Primary Skills

C#, ASP.NET,JSP, JDBC, JDOM, XML,C, C++, Java Script-SQL, PL/SQL , MS SQL Server 2000/2005/2008 R2, MYSQL 5.0, Oracle, MS Access,

DTS, SSIS, Informatica , Visual Studio 2005, Visual Source safe, Microsoft Visio,  Win Runner 7.5, Load Runner 7.0, Rational Suite, QTP 8.0, Test Director,

Web Tools(Dream weaver), Macromedia Flash 2004, Siebel MS expression web and MS sharepoint designer , SQL*PLUS, SQL*LOADER, TOAD,

SQL NAVIGATOR .

   Summary

Around 7 years of  IT Professional experience in Development, Analysis, Database Design, Testing and Support and presentation using SQL Server 2000/2005/2008.

Extensive working experience in various industries including banking, financial, marketing services, and healthcare industry.

Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, 2005 and 2008 R2 on both Cluster and Stand-alone Environment.

Database Design in Full, Bulk Logged, Simple Recovery Modes, Restoring Databases with Point in Time Recovery,Replication, Snapshot Replication and Merge Replication .

Experience in Log Shipping  Servers in SQL Server 2005.SQL Server Integration Services.

Worked on various SSIS/dts packages for data import/export/transformations from different OLEDB/Flat source to SQL 2005/SQL 2008.

Good understanding of High availability techniques Database Mirroring and Clustering .

Extensive experience in Creating alerts for SQL Server Performance.

Extensively worked on Active-Active and Active-Passive Clustering.

Optimization and Maintenance tasks including Re-indexing, Updating Statistics, Shrinking Databases and Recompiling Stored Procedures.

Experience in working with Linked Servers, Distributed Transactions, and Federated Databases.

Experience with  performance tuning, managing indexes and locks, troubleshooting deadlocks.

Running of Traces using SQL Profiler tool, Performance Monitoring & Tuning using Performance Monitoring Tool, Query Optimization, Client / Server Connectivity.

Excellent skills in implementing ETL Packages using DTS and SSIS 2005/ 2008.

Involved in implementing transactional replication in a high OLTP environment.

Creating and Maintaining Databases, Adding Users, Roles and Groups and assigning privileges according to the project needs.

Expertise in T-SQL, Stored Procedures, Functions, Cursors and Triggers etc.

Used Indexes for improving query performance, lower storage and maintenance cost.

Excellent communication skills, Proactive, independent and easy-going.

 

  Total Exp : 6 + yrs,   US Exp: 4+ yrs,   Available : Immediate,   Current Location : St Paul, Minnesota .   Relocation : Open

Receive Resume by EMail    

      Name

Srikanth - Sr BIApps Consultant

  Primary Skills

Oracle Financials E-Business suite R12/11i (OM, Inv, PO, GL, AR, AP, FA, Cash Management, AOL,System Administrator,

 OBIEE10.1.3.x, Siebel Analytics 7.5/7.7/7.8,Oracle Reports 10g/6i/4i, Oracle BI Apps 7.9.x Oracle Forms 10g/6i/4i, Discoverer 10g/6i/4i,

XML Publisher 5.6.3/5.6.2,TOAD , SQL*PLUS, Data Loader, SQL*Loader, SQL  Developer , Informatica Power Center 8.1.1, 7.1, 6.2, 5.1,

DAC 7.8.5v, SQL, PL/SQL, C, C++, C#, HTML, XML ,Oracle 10g/9i/8i, MS Access, SQL Server 7.x, 2000

Summary

Implemented Financials, Supply Chain and Procurement & Spend Analytics.

Worked on end-to-end implementation of BI Applications, Configured DAC and Informatica along with BI Apps domain files.

Customized and extended Informatica mappings and out of the box reports for Financial Analytics (AP, GL, AR). Customized and extended mappings using Oracle recommended methodologies.

Analyze, Design and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.

Custumizing the existing informatica repository and adding new mappings and workflows based on the requirements.

Created Dimension hierarchies to achieve the drill down functionality.

Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.

Designed and Developed Custom Mappings, Workflows and Registered in DAC.

Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse (OLAP) system.

Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC.

Implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.

Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool. Migrated Analytics RPD and Web catalog from one environment to another.                   

Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.

Implemented the single sign on (SSO).           

Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.                   

Involved in setting up IBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.

Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.

Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.

Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.

Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.

Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.      

Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.

Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.

Imported and Exported Execution Plan in DAC from one Instance to other Instance.

Involved in Integrating Oracle BI Presentation Services with BI Publisher.          

Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.

Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.

Adding new Tables,Tasks and rebuilding the subject areas in DAC based on the changes done to the informatica repository.

Configuring the Anlaytics repository(RPD) and implementing the security to authenticate and authorize Oracle EBS users.

 

  Total Exp: 8 Yrs ,   US Exp: 5 Yrs,   Available: Immediate , Current Location : Gentex, MI.   Relocation: Open

Receive Resume by EMail    

 

Good morning,

The following consultants possess above good technical abilities, solid communication skills, and most are open for relocation. Please feel free to contact me for additional information.

 

Thanks!

Satya

 

Name

Primary Skills

Total/US Exp

Mallikarjun Chinnam

OBIEE ,OBIEE Administration tool, Informatica, Database, Financials, Oracle Applications E-Business Suite ,Reports, interfaces , conversions , extensions , Supply Chain Analytics, Dimensional Modelling ,LAP,AR,OM,PO,INV,HR ,Dynamic Dashboards ,BI Server, BI Answers, BI Dashboards ,BI Delivers ,

SQL Developer, SQL * Loader, SQL * Plus, Data Loader, TOAD ,PL/SQL, Developer 2000 , Oracle Discoverer 10g/4i, XML Publisher 5.6.3/5.6.2

7+Yrs/5+Yrs

Heta Raval

Java, C, C++ ,  EJB, RMI, CORBA and COM/DCOM, XML, HTML, Ajax, Java Script, VB Script, ASP, JSP and Java Servlets, PHP ,  IBM WebSphere, BEA WebLogic, Tomcat, and IIS,  WinRunner, LoadRunner, Test Director, ManualTesting,J2ee Mercury Diagnostics, QTP, Bugzilla, Quality Center, SOAP UI, Crystal reports, Reports 2.5, SQR, Windows NT, Windows 2000 Server, Solaris, HP Unix, Linux and Citrix, SQL and PL/SQL, ORACLE, SQL Server, Sybase and DB2, ETL, SWING, Jbuilder, Eclipse, WSAD J2EE, JMS, JNDI, Java Mail, Web Services, Struts.

6+Yrs/5+Yrs

Rekha Poreddy

Java, C#, ASP.NET, VB.NET,JSP, JDBC, JDOM, XML, VB,C, C++, Java Script-SQL, PL/SQL , MS SQL Server 2000/2005/2008 R2, MYSQL 5.0, Oracle, MS Access, DTS, SSIS, Informatica , Visual Studio 2005, Visual Source safe, Microsoft Visio, MS Excel,  Win Runner 7.5, Load Runner 7.0, Rational Suite, QTP 8.0, Test Director, Web Tools(Dream weaver), Macromedia Flash 2004, Siebel MS expression web and MS SharePoint designer , SQL*Plus, SQL*Loader, TOAD, SQL Navigator, SQL Developer

6+Yrs/4+Yrs

Srikanth

Oracle Financials E-Business suite R12/11i (Order Management, Inventory, Purchasing, General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Cash Management, AOL, System Administrator, OBIEE10.1.3.x, Siebel Analytics 7.5/7.7/7.8, Oracle Reports 10g/6i/4i, Oracle BI Apps 7.9.x Oracle Forms 10g/6i/4i, Discoverer 10g/6i/4i, XML Publisher 5.6.3/5.6.2, TOAD 9.7.3/8.x, SQL*PLUS, Data Loader, SQL*Loader, SQL  Developer , Informatica Power Center 8.1.1, 7.1, 6.2, 5.1,DAC 7.8.5v, SQL, PL/SQL, C, C++, C#, HTML, XML , Oracle 10g/9i/8i, MS Access, SQL Server 7.x, 2000.

8+Yrs/5+Yrs

 

  • Please scroll down and view more information about consultant.
  • Please feel free to contact me for additional information.

 

Regards,
Satya

RAPISOURCE LLC
Sourcing IT Talent

Direct:  512-430-4553 
Fax:      512-287-4047

Email: Satya@idolsoftconsulting.com

 

Consultant List

Name

Mallikarjun Chinnam - OBIEE Developer

Primary Skills

OBIEE ,OBIEE Administration tool,Informatica,Financials,Oracle Applications E-Business Suite ,Reports, interfaces , conversions , extensions , Supply Chain Analytics, Dimensional Modelling ,LAP,AR,OM,PO,INV,HR ,Dynamic Dashboards ,BI Server, BI Answers, BI Dashboards ,BI Delivers , SQL * Loader, SQL * Plus, TOAD ,PL/SQL, Developer 2000 , Oracle Discoverer 10g/4i, XML Publisher 5.6.3/5.6.2

     Summary

Over 7 years of experience Complete Software Development Life Cycle (SDLC)

Over 5 + years of experience in BI Implementation.

Installation and configuration of Financials, Supply Chain Analytics, Procurement Analytics and Spend Analytics and Migration of RPD.

Experience in using Data Warehouse Administration Console (DAC).

Expertise in design, development, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modelling, RPD , ETL .

Proficient within the Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration tool.

Technical expertise in GL,  AP,  AR, OM, PO, INV, HR .

Experience in configuring Interactive Dashboards with drill-drown capabilities using global and local filters .

Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.

Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.

Extensively worked on BI Server, BI Answers, BI Dashboards and BI Delivers (iBots)

Proficient in Oracle Tools and Utilities such as SQL Developer, SQL * Loader, SQL * Plus, Data Loader, TOAD and UTL_FILE.

Involved in development of RICE objects for the Oracle Applications E-Business Suite .

Experience in PL/SQL, Developer 2000, Oracle Discoverer 10g/4i , XML Publisher 5.6.3/5.6.2.

Designed Report Templates using XML/BI publisher.

 

  Total Exp: 7+ yrs,   US Exp: 5 Yrs,   Available: Immediate,  Current Location : Charlotte, NC ,   Relocation: Open

Receive Resume by EMail    

       Name

 Heta raval - QA Tester

Primary Skills

Java, C, C++ ,  EJB, RMI, CORBA and COM/DCOM, XML, HTML, Ajax, Java Script, VB Script, ASP, JSP and Java Servlets, PHP ,  IBM WebSphere, BEA WebLogic,

Tomcat, and IIS,  WinRunner, LoadRunner, Test Director, ManualTesting,J2ee Mercury Diagnostics, QTP, Bugzilla, Quality Center, SOAP UI, Crystal reports, Reports 2.5,

 SQR, Windows NT, Windows 2000 Server, Solaris, HP Unix, Linux and Citrix, SQL and PL/SQL, ORACLE, SQL Server, Sybase and DB2, ETL, SWING, Jbuilder, Eclipse,

WSAD J2EE, JMS, JNDI, Java Mail, Web Services, Struts

Summary

Over 6 years of diverse experience in Software Testing and Quality Assurance.

Strong Manual Testing  BI / Data Warehouse Testing, SQL Database experience.

Working knowledge of  Micro Strategy, SOAP UI, Websphere,Weblogic experience, Teradata & Retail industry experience.

Proficient with HP Quality Center for creating scripts, tracking defects, and reporting , Automated testing, JMeter, Load Runner

Experience in writing Test strategy, Test scenario, Test plan, Test cases, Bug reports and developing Test scripts.

Expert in Data Conversion, Batch, integration, regression, functional & UAT tests.

Experience in the areas of GUI, Functional, Integration, System, Front-end, Regression & Web Services testing for Client Server and web applications.

Experience in reproducing and reporting software problems and defects using different bug tracking systems (ClearQuest, HP Test Director, Compuware QA Director, Bugzilla, etc.)

Experience in Regression Testing by designing Automation Test-Suites involving a comprehensive and Time-Effective Automation Framework using HP-Quick Test Professional (QTP) and Compuware Test Partner .

Expertise in Risk Analysis, preparation of RTM & Prioritize Test case.

Familiar with Oracle, PL/SQL and MS SQL Server Databases.

Independent Verification & Validation of software product/process compliance to standards, policies, Procedures & output/behavioral requirements.

Professional experience in designing test cases and test scripts for Windows, Java and UNIX environments.

Working Knowledge  of TFS Application .

Did ATM simulator, and device handler testing.

Experienced in distributed testing, multi-user testing and database testing.

Strong skills in Batch & back-end testing using SQL queries on SQL Server 2000 and Oracle.

Ability to work independent or as a team member, excellent written and verbal communication skills.

Excellent interpersonal skills and ability to work in a cross-functional environment.

Excellent problem solving and multitasking. Quick learner and able to work under pressure to meet deadlines.

 

  Total Exp: 6 years,   US Exp: 5+ Years,   Available: Immediate ,  Current Location : Charlotte, NC ,   Relocation: Open

Receive Resume by EMail    

Name

Rekha Poreddy - SQL Server DBA

Primary Skills

C#, ASP.NET,JSP, JDBC, JDOM, XML,C, C++, Java Script-SQL, PL/SQL , MS SQL Server 2000/2005/2008 R2, MYSQL 5.0, Oracle, MS Access,

DTS, SSIS, Informatica , Visual Studio 2005, Visual Source safe, Microsoft Visio,  Win Runner 7.5, Load Runner 7.0, Rational Suite, QTP 8.0, Test Director,

Web Tools(Dream weaver), Macromedia Flash 2004, Siebel MS expression web and MS sharepoint designer , SQL*PLUS, SQL*LOADER, TOAD,

SQL NAVIGATOR .

   Summary

Around 7 years of  IT Professional experience in Development, Analysis, Database Design, Testing and Support and presentation using SQL Server 2000/2005/2008.

Extensive working experience in various industries including banking, financial, marketing services, and healthcare industry.

Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, 2005 and 2008 R2 on both Cluster and Stand-alone Environment.

Database Design in Full, Bulk Logged, Simple Recovery Modes, Restoring Databases with Point in Time Recovery,Replication, Snapshot Replication and Merge Replication .

Experience in Log Shipping  Servers in SQL Server 2005.SQL Server Integration Services.

Worked on various SSIS/dts packages for data import/export/transformations from different OLEDB/Flat source to SQL 2005/SQL 2008.

Good understanding of High availability techniques Database Mirroring and Clustering .

Extensive experience in Creating alerts for SQL Server Performance.

Extensively worked on Active-Active and Active-Passive Clustering.

Optimization and Maintenance tasks including Re-indexing, Updating Statistics, Shrinking Databases and Recompiling Stored Procedures.

Experience in working with Linked Servers, Distributed Transactions, and Federated Databases.

Experience with  performance tuning, managing indexes and locks, troubleshooting deadlocks.

Running of Traces using SQL Profiler tool, Performance Monitoring & Tuning using Performance Monitoring Tool, Query Optimization, Client / Server Connectivity.

Excellent skills in implementing ETL Packages using DTS and SSIS 2005/ 2008.

Involved in implementing transactional replication in a high OLTP environment.

Creating and Maintaining Databases, Adding Users, Roles and Groups and assigning privileges according to the project needs.

Expertise in T-SQL, Stored Procedures, Functions, Cursors and Triggers etc.

Used Indexes for improving query performance, lower storage and maintenance cost.

Excellent communication skills, Proactive, independent and easy-going.

 

  Total Exp : 6 + yrs,   US Exp: 4+ yrs,   Available : Immediate,   Current Location : St Paul, Minnesota .   Relocation : Open

Receive Resume by EMail    

      Name

Srikanth - Sr BIApps Consultant

  Primary Skills

Oracle Financials E-Business suite R12/11i (OM, Inv, PO, GL, AR, AP, FA, Cash Management, AOL,System Administrator,

 OBIEE10.1.3.x, Siebel Analytics 7.5/7.7/7.8,Oracle Reports 10g/6i/4i, Oracle BI Apps 7.9.x Oracle Forms 10g/6i/4i, Discoverer 10g/6i/4i,

XML Publisher 5.6.3/5.6.2,TOAD , SQL*PLUS, Data Loader, SQL*Loader, SQL  Developer , Informatica Power Center 8.1.1, 7.1, 6.2, 5.1,

DAC 7.8.5v, SQL, PL/SQL, C, C++, C#, HTML, XML ,Oracle 10g/9i/8i, MS Access, SQL Server 7.x, 2000

Summary

Implemented Financials, Supply Chain and Procurement & Spend Analytics.

Worked on end-to-end implementation of BI Applications, Configured DAC and Informatica along with BI Apps domain files.

Customized and extended Informatica mappings and out of the box reports for Financial Analytics (AP, GL, AR). Customized and extended mappings using Oracle recommended methodologies.

Analyze, Design and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.

Custumizing the existing informatica repository and adding new mappings and workflows based on the requirements.

Created Dimension hierarchies to achieve the drill down functionality.

Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.

Designed and Developed Custom Mappings, Workflows and Registered in DAC.

Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse (OLAP) system.

Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC.

Implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.

Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool. Migrated Analytics RPD and Web catalog from one environment to another.                   

Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.

Implemented the single sign on (SSO).           

Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.                   

Involved in setting up IBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.

Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.

Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.

Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.

Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.

Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.      

Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.

Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.

Imported and Exported Execution Plan in DAC from one Instance to other Instance.

Involved in Integrating Oracle BI Presentation Services with BI Publisher.          

Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.

Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.

Adding new Tables,Tasks and rebuilding the subject areas in DAC based on the changes done to the informatica repository.

Configuring the Anlaytics repository(RPD) and implementing the security to authenticate and authorize Oracle EBS users.

 

  Total Exp: 8 Yrs ,   US Exp: 5 Yrs,   Available: Immediate , Current Location : Gentex, MI.   Relocation: Open

Receive Resume by EMail    

 


No comments:

Post a Comment