Sirisha Mohan

Having 2 years of Data warehousing experience using Informatica Power Center 9.x and Cognos 8 and 10.2.1. Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files. Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.

Strong experience in Data Warehousing and ETL using Informatica Power Center 9.X. Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes. Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.

Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages). Well versed in UNIX shell scripting. Expert in Business Intelligence Applications using Cognos Tools such as Cognos 8.x and 10.2.1 BI (Report Studio, Query studio).

Experience in creating end user reports (like Cross tab, list, chart etc.) using Cognos Report Studio and Cognos Query Studio. Hands on experience in creating Cascading Prompts, Filters, Grouping, Sorting, Section and Conditional Blocks. Handled complete project life cycle of reporting from requirements gathering to go live.

Worked as a Cognos administrator for migration of objects and monitoring servers. Excellent problem solving skills with a strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.

INFORMATICA Developer at Deloitte Consulting Ltd (Present)

Informatica Developer at Well Point Insurance (2016-03 – Present)

Project: Anthem LO. Team Member on Informatica and Teradata project with team size of 10.

• Monitoring Jobs scheduled and troubleshooting the errors that occurred during execution.
• Making enhancements in the existing design.
• Effectively worked on Onsite and Offshore work model.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Used Teradata utilities like BTEQ, fast load, fast export, multi load for data conversion.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.
• Thoroughly tested the Sql scripts by validating the data and cross comparing the data.
• Used UNIX to navigate around the system and check for specific files, the files' content, change permissions and see who the current users are.

Cognos Administrator and Developer at GE Aviation, US (General Electric) (2014-07 – 2016-01)

Project: Aviation Cognos operations. Team Member on Cognos project with team size of 7.

• Provide administrating support to data warehousing, database and server technologies.
• Involved in installation, configuration and maintenance of Cognos Administration tool – 10.2.1.
• Migrating objects from one environment to another.
• Identify technical need of the organization and the project requirement.
• Ensure maintenance and control continuity of the Cognos environment.
• Administered several projects and completed them successfully through 'Cognos Administration' tool.
• Prepared report and maintained database of application and processes through Cognos.
• Engaged in project planning, controlling, and writing technical documentation.
• Arrange all project solution and transfer it to the testing and production unit.
• Ensured proper scheduling and administration of Cognos connection.
• Evaluated the overall performance of Cognos suite to meet the business needs.

Informatica and Cognos Developer at GE Aviation, US (General Electric) (2014-01 – 2014-10)

Project: Aviation Platform and Product Service Data Warehouse – Informatica (OPS DWH). Team Member on Informatica, Oracle, and Cognos project with team size of 7. This project was to maintain 2 years of Informatica operational data in data warehouse by using Informatica and analysis on informatica objects to find performance issues by creating following reports in Cognos: 1. AV Infa Non EC Run Statistics 2.

Sessions Succeeded Vs

Failed 3. Top 15 Long Running Workflows & Sessions 4. Top 15 Most Running Workflows & Sessions.

• Attended the calls with client to gather requirements and data modelling.
• Created the tables in DB according to requirements and maintain the naming convention.
• Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations Developer.
• Created mappings using Informatica Designer to build business rules to load data.
• Used flat file and Oracle as the source and the target is Oracle database.
• Used the Workflow Manager, to create the session.
• Developing and modifying changes in mappings according to business logic.
• Created the reports in Cognos 8 Report studio according to client requirements.
• Raised tickets in GE Service now for Schema creation, Package creation in cognos, migrate the ETL, DB and Cognos objects to QA and Prod.
• Performing Unit Testing.

B.Tech – Aditya Engineering college

Intermediate in M.P.C – Aditya Junior college

SSC – Little Buds School