Venkata Rakesh Barthala

• Collaborated with cross-functional teams to define data requirements, resulting in accurate and timely delivery of business-critical data.
• Developed complex mappings, workflows, and sessions to meet project objectives and deadlines.
• Streamlined data extraction, transformation, and loading for improved overall system performance.
• Tuning the ETL code in mapping level , session level and database level
• Unit testing of the mappings
• Migrating Informatica objects to SIT,CERT environments.

• Effectively worked on onshore and offshore work model.

• Communicated with customers to discuss the business requirements and issues.

• Involved in all phases of SDLC from requirement gathering, development and testing.

• Worked with address doctor to validate the addresses.

• Developed the mappings using needed transformations in Informatica tool according to technical specifications.

• Performed data manipulations using various Informatica transformations like Filter, Expression, Lookup, Aggregate, Joiner, Router, Sorter.

• Performed optimizing performance tuning at source, target, mapping and session level.

• Involved in deploying objects from dev to prod.

· Involved in Migrating objects from Microsoft SQL Server to Snowflake.

· Used Temporary and Transient tables on different datasets.

· Created File formats for CSV, XML, JSON source files.

· Have knowledge on data sharing between two snowflake accounts.

· Involved in creating Error Handling tables.

· Used COPY, LIST, PUT and GET commands for validating the internal stage files.

· Created clone objects to maintain zero-copy cloning.

· Involved in testing data after migrating to cloud

· Experience in using Snowflake Merge, Clone and Time Travel.

· Ability to write SQL queries against Snowflake.

· Ability to use Snowpipe for continuous data load.

· Ability to provide production support for Data Warehouse issues such data load problems, transformation/translation problems .

• Responsible in gathering Requirements and IT review. Interacted with Business Users in the design of technical specification documents.

• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and modularity.

• Within specified time, projects are delivered making sure all the requirements gathering, business analysis and designing of the data marts.

• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.

• Extensive knowledge on debugging of Informatica mapping/workflows, unit testing of the mapping/workflows.

• Used assignment, command and exclusive tasks in Informatica Workflow Manager.

• Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, XML, Normalizer and update strategy to meet business logic in the mappings.

• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.

• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput.

• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.

• Created Test cases for the mappings developed and then created integration Testing Document.

• Experience in using Automation Scheduling tool Stone branch.

• Involved in deploying objects from dev. to prod.

• Followed Informatica recommendations, methodologies and best practices.

• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.

• Migrated Crystal Reports to Cognos Reports.

• Scheduled Reports Using Cognos Connection Web Portal.

• Created Dash Board Reports.

• Developed multi page, multi query and sophisticated reports by using different report templates like list, crosstab and chart.

• Developed reports with multiple prompts, conditional formatting and calculated columns.

• Created reports using conditional blocks.

• Involved in creation of Drill-Through and Master-Detail reports.

• Implemented Tab Functionality using radio Buttons.

• Created UNION Reports.

• Created Reports using SQL.

• Involved in unit testing of the reports.

• Migrated 8.3, 8.4 reports to Cognos 10.2.1.

• Redesigned Cognos 7.3 to 10.2.1.

• Created data source connection for the Target Cognos Database.

• Scheduled Reports Using Cognos Connection Web Portal.

• Involved in developing the Relational Model using Framework Manager.

• Involved in creation of joins, filters, calculations and derived query items in Framework Manager.

• Used extensively Cognos 10.2.1 Report Studio while development of Reports.

• Developed reports by using value prompts, Date & Time prompts, Text box prompts and Cascading prompts.

• Developed reports with multiple prompts, conditional formatting and calculated columns.

• Created Filters, Prompts and Calculations as per the report specs to develop the reports in Report Studio.

• Created reports using conditional blocks and Hyperlinks.

• Involved in creation of Drill-Through and Master-Detail reports.

• Involved in validating source and target reports using LCM.

• Created Cubes using Packages.

• Created Bubble Chart Report.

• Installed Cognos 10.2.1.

• Created data source in Cognos connection.

• Involved in developing the Relational Model using Framework Manager.

• Involved in creation of joins, filters, calculations and derived query items in Framework Manager.

• Created Reports using conditional block variable.

• Developed reports with multiple prompts, conditional formatting and calculated columns.

• Created Filters, Prompts and Calculations as per the report specs to develop the reports in Report Studio.

• Involved in creation of Drill-Through and Master-Detail reports.

• Involved in deploying the content Store from one environment to another environment.

• Configured LDAP using ADS.

• Created user’s and applied the Security.

• Migrated BO Reports to Cognos Reports.

• Migrated BO Universe to Framework Manager Packages.

• Scheduled Reports Using Cognos Connection Web Portal.

• Involved in developing the Relational Model using Framework Manager.

• Involved in creation of joins, filters, calculations and derived query items in Framework Manager.

• Involved in Burst Reports.

• Created Dash Board Reports.

• Involved in Configurations and Deployment.

• Developed multi page, multi query and sophisticated reports by using different report templates like list, crosstab and chart.

• Developed single select and multi select cascading prompts.

• Developed reports with multiple prompts, conditional formatting and calculated columns.

• Created reports using conditional blocks.

• Involved in creation of Drill-Through and Master-Detail reports.

• Implemented Tab Functionality using radio Buttons.

• Created UNION Reports.

• Created Reports using SQL.

• Involved in unit testing of the reports.