EXPERIENCE SUMMARY

• 6 years of IT experience around 5 years of practice in health care industry/Medicaid domain in client facing roles and responsibilities
• Specialized in Data warehouse, ETL, and BI Business Intelligence services
• Worked extensively in Informatica, relational database Oracle, SQL, and stored procedures
• Proficient in Informatica mapping using transformations, building UNIX shell scripts
• Informatica Administration: Create/maintain all users, groups, folders and database connections. Migrated Informatica 9.0.1 from UNIX environment to WINDOWS environment
• Cognos Administration: Create/maintain all users, groups, folders and models.Migrated Cognos from version 8.4 to 10.2.1
• Worked extensively in Cognos Report studio/Query Studio/Framework Manager
• Training Services: Provided Cognos training and onsite technical support to clients
• Experience in designing reports, dashboards, publishing, and scheduling reports using Hyperion
• Experience in Business objects 6.5
• Experience in JIRA, SharePoint site customization, scripting and web page creation
• Experience in prepare Integration Test Plan which was used by functional team as well as development team.
• Excellent work ethics, self-motivated, quick learner and team player
• Have strong analytical and problem solving skills ability to perform in challenging environments
• Good written and verbal communication skills aptitude to perform with minimal supervision

TECHNICAL SKILLS

• Operating Systems: Windows, AIX, z/OS
• Programming Languages: Java, C, C , Java script, SQL, PL/SQL, COBOL, SAS, UNIX
• Shell Scripting
• ETL Tools Informatica 6.2, 7.1, 8.6.1, 9.0.1
• Reporting Tools Hyperion Intelligence Designer 8.3, Hyperion web portal,
• Business Objects 6.5, Cognos8.4 and 10.2.1 - Query Studio, Report studio, Framework Manager, Cognos Connection, Life cycle manager, Access Manager Cognos 7 and Apache directory studio SSRS 2008 R2
• Databases: Oracle 11g/10g/9i/8i, MS Access, MS SQL Server, Teradata
• Other Tools: VSS, TortoiseSVN, TOAD, DBVisualizer, SQL Developer, JIRA, SharePoint 2007, Badboy, Tivoli Access Manager 6.1, XlsToOra, Crystal Reports, MS Word, Excel, Outlook, ERStudio, and Visio

WORK EXPERIENCE

Confidential Informatica/ Oracle/ SSRS - Admin/Developer

Environment:

Windows 2003, AIX, Informatica 9.0.1, Oracle 10g, Oracle 11g, SQL, PL/SQL, MS Access, SharePoint, SSRS 2008 R2, TortoiseSVN, ERStudio

Responsibilities:

As Data/Business Analyst:

• Gather requirements for 13 measures. Document the business process by identifying the requirements.
• Prepare Technical specification document and modify based on customer comments which helped the development team to understand the requirements easily
• Prepared test pan document for the testing team.

As Oracle Admin/Developer:

• Created partitioned tables with necessary indexes
• Driven performance tuning activities with result driven strategy
• Created packages, stored procedures, and functions and output will be stored to the summary table
• Used DBMS scheduler, Collections, global temporary tables.

As Informatica Admin:

• Repository backup, shut down/ startup Informatica
• Designing and developing of mappings, mapplets, sessions and work flows for load the data from source to target database using Informatica Power Center and tuned mappings for better performance/efficiency

• Created mapping, session and workflow based on the business logic and requirements
• Load the required tables/columns data from Ad Hoc data warehouse to a schema.

Merged multiple tables data into one table

• Updating/fixing the data using Informatica

• Automated the Informatica job run.
• Preparing test cases and Testing to make the data load was happened based on business needs.

As SSRS Admin/Developer:

• Created User groups with required access privileges , hidden the database access information and data source and datasets
• Created Shared Data Source, Shared Dataset and reports using SSRS Business Intelligence Development Studio
• Used debugger to resolve any issues
• Build the project, deploy to the report server and access the reports using web

As Test Engineer:

• Created test plan and test cases
• Performed functional testing to reduce the error rate
• Performed system testing
• Worked with customers in user acceptance testing

Confidential Informatica/Cognos/SharePoint/Oracle - Admin/Developer

Environment:

Windows 2003, AIX, Cognos 8.4, Cognos 10.2.1, Apache directory studio, Life cycle manager, Informatica 9.0.1, Oracle 10g, Oracle 11g, UNIX, SQL, XML, Java, SharePoint, JIRA, XlsToOra, ERStudio

Responsibilities:

• As Informatica Admin/ Developer:
• Repository backup, shut down/ startup Informatica
• Designing and developing of mappings, mapplets, sessions and work flows for load the data from source to target database using Informatica Power Center and tuned mappings for better performance/efficiency.
• Add new fields to the existing table and update the mapping, session
• Updating/fixing the data using Informatica or oracle SQL
• Prepare test cases for mappings Perform unit/system/integrated testing and documentation
• Automation of the ETL processes using UNIX shell scripting
• Support production data load weekly cycle support / prod on-call
• As Cognos Admin/Developer:
• Customer facing role, requirements gathering, brainstorming sessions, discussing reporting options, technical details during ADHOC user group meeting
• Migrated Cognos 8.4 to Cognos 10.2.1. Trained users with the new features assisted the customers to resolve the issues and provided optimal solution.
• Used Lifecycle Manager to validate the content between two different versions of Cognos BI.
• Used Apache directory studio as Cognos 10.2.1 LDAP
• Resolve numerous JIRA issue tracking system tickets related to Cognos
• Create and manage Users in Cognos Access Manager
• Provide training and help the client to create reports specific to their unit
• Update Cognos framework Manager and publishing the package
• Production Support.
• Perform Stress Testing, Load Testing and performance tuning
• Develop complex reports in Cognos for business users
• Unit testing, System testing, Validation and documentation
• Enhance data warehouse system and maintenance for ongoing system changes
• Loading data from Excel to Oracle using XlsToOra tool
• Creating new reports using Crystal reports tool
• As SharePoint Admin/Developer:
• SharePoint site creation, customization, scripting and web page creation
• Create the hyperlinks on the Project home tab for the latest version of the status report, schedule and Project Charter
• Combine all the meeting minutes from various sites and display it in the home page
• As Oracle Admin/Developer:
• Create/Alter/Update/Delete table. Grant access to the tables
• Write new procedures to fix/load the data. Experience in using Oracle Explain Plan

Confidential

Environment:

Cognos 8.4, Informatica 9.0.1, Oracle 10g, UNIX, SQL, XML, Java

Responsibilities:

• As Cognos Admin/Developer:
• Report Studio training for users
• Develop complex reports using Report Studio Ad-hoc reports web using Query Studio
• Create Complex Dashboards using Cognos connection for SLA Service Level Agreement . It's been accessed by customers and fiscal agent users WIPRO Infocrossing Managers
• Deploy the Reports, Packages dashboards from test environment to production
• Develop various SAS reports in Cognos environment
• Develop/change the existing framework model and republish the packages
• Apply Security in Cognos Connection by controlling privileges for users, groups and roles to the various packages, reports dashboards. Create Jobs to Schedule multiple reports in Cognos Connection
• Develop custom templates and updated the default XML code in the Cognos install files to show the Template in welcome screen of Report studio
• Developed procedure to process external data text/xls files in Framework manager
• Unit testing, System testing, Validation and documentation
• As Informatica Admin/ Developer:
• Read the flat file and load the data into Oracle using Informatica
• Creating Complex Mappings using mapping designer and creating Sessions and workflows
• Unit/system or integrated testing and documentation
• Production data load support weekly
• Installed Informatica 9.0.1 and responsible for repository backup, shut down / startup
• As JIRA Admin/Developer:
• Integrate all issues from different bug tracking system into one by using JIRA.
• Create Projects like Enterprise Ticketing System, Mainframe, Web Apps, and Support
• Create various custom fields, schemes and customize the visibility using java script.

Confidential

Environment:

Informatica 6.2, Informatica 7.1, Oracle 9i, TOAD, Hyperion 8.3, Control-M

Responsibilities:

• As Hyperion Admin/Developer:
• Creating user account in Hyperion, setting privileges for reports
• Creating reports, Publishing jobs reports and scheduling jobs in Hyperion
• Automated the manual process of checking Control-M job status by creating Hyperion report accessing Control-M data
• Prepared functional specifications document for the Hyperion reports
• Unit testing in multiple regions
• As Informatica Developer:
• Creating Mappings staging, dimension, fact hierarchy using mapping designer/sessions
• Preparing test cases for the mappings
• Unit testing and documentation
• Code walkthroughs and Reviews

Confidential

Environment:

• Oracle 8, Business Objects 6.5
• Responsibilities:
• As BO Developer:
• Functional Design FD Analysis
• Creating Business Objects universe
• Enhancement to existing reports and creating new reports
• Code walkthroughs and Reviews
• Unit Testing and Documentation Unit Test reports