Shankar reddy seelam Skills

Please use this table to list the skills noted in the Required/Desired section of the requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

Employment History

Confidential

Informatica/BI Developer

Responsibilities:

• Interacted with the business users in order to understand the business and functional requirements.
• Designing the data base objects using SQL Server management studio as per the project specifications.
• Involved in building the database and created stored procedures, triggers to maintain the referential Integrity, functions, view to handle business logic and functionality of various modules.
• Experience with full SDLC, Agile methodologies.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes
• Users provide the source data in flat files and loading into stage tables using ETL process.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Developed standard Target mappings and mapplets using various transformations like expression, aggregator, joiner, router, sql and lookups.
• Wrote T-SQL Overrides and used filter conditions in source qualifier thereby improving the performance of the mappings.
• Developed various ETL workflows with event waits, assignments, conditional flows, and email and command tasks.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows.
• Wrote windows batch scripts for file checking, indirect file creation and archiving the source files.
• Also wrote Shell scripts to execute custom Cognos class files to be triggered via DataStage
• Assisted in Website .NET development in stored procedures and code review process.
• Data validation from sources through the dashboards.
• Responsible for unit and integration testing.
• Skybot tool implementation in Dev and QA environments and testing.
• Scheduling of informatica jobs using Skybot tool according to the data flow.
• Migration of informatica objects to different environments.
• Closely working with reporting team to address the data requirements for dashboards.
• Maintained naming standards and data warehouse standards for future application development, and also created functional and technical specification documents.
• Fast paced ETL component development for data availability in both Website UI and Tableau dashboard adhoc POC visualizations development due to parallel development project strategy.
• Responsible for solving the ITSM Tickets for the business/end users.
• Deployed the Informatica workflows to the OBIEE DAC and created dependency and dependent hierarchical tasks and monitored all the tasks in the execution plans. Involved in debugging the failed runs using Informatica Workflow monitor.

Environment: Informatica Power center 9.1, Business Objects XI R2, MS SQL Server 2008 R2, Oracle 10g, Windows Server 2008, Toad 11.5, Flat files, T-SQL, Tableau 8.0 and Skybot Scheduler, OBIEE and DAC 10.1.3.4

Confidential

Informatica Developer/ BI Developer

Responsibilities:

• Review the specification documents provided by the business users and preparing mapping documents accordingly.
• Developed Target mappings and mapplets accordingly to meet the business rules.
• Extensively worked with Transformations such as Filter, Aggregator, Lookup, Update Strategy, Sorter, Sequence generator for building the mappings.
• Wrote SQL queries in source qualifier while pulling the source data and hence increased the mapping performance.
• Experience with full SDLC, Agile methodologies.
• Worked on Data stage server and Parallel Extender
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• The target files txt files are generated as per the EDFacts Specifications.
• Created and configured sessions, command tasks and built workflows to generate the various data files for EDFacts.
• Workflows are scheduled with informatica scheduler with run on demand option.
• Toad is utilized to load the source data into the data warehouses.
• Worked on existing mappings for the performance tuning to reduce the total ETL process time
• Deployment of informatica workflows and mappings to different environments.
• Target flat files generated on the UNIX machines are accessed by Reflection Ftp client tool.
• Prepared technical and functional documents for the operations of EDFacts project.

Environment: Informatica 8.6.1, Oracle 11g 11.2.0.2 , Business Objects XI R2, Toad 11.5.0, Excel and flat files, Reflection FTP client 14.1.70, UNIX AIX 5.3

Confidential

Informatica/ Data Quality Developer/ BI Developer

Responsibilities:

• Interacted with subject matter experts and data management team to get information about the business rules for data cleansing.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Worked with various developer modules like profiling, standardization and matching.
• Designed various Target mappings and mapplets using different transformations such as key generator, match, labeler, case converter, standardize and lookup.
• Worked extensively with address validator to cleanse the address elements. Created input and output templates.
• Experience with full SDLC, Agile methodologies.
• Used the Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Analyzed the source data coming from Oracle, Teradata and Excel files. Worked with Data Warehouse team in developing Dimensional Model.
• Exported the IDQ Mappings and Mapplets to power center and automated the scheduling process.
• Worked extensively with CSV flat-file and Oracle systems.
• The target data are extensively tested by various test cases.
• Prepared micro and macro level documents for the ETL process and also the operational documents.

Sales and Operations:

Confidential

Responsibilities:

• Interacted with the business users in order to understand the business and functional requirements.
• Source data comes in the form of flat files and target systems are built in Oracle.
• Developed standard Target mappings and mapplets using various transformations like expression, aggregator, joiner, router and lookups
• Wrote SQL Overrides and used filter conditions in source qualifier thereby improving the performance of the mappings.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Created Shell Scripts, which will intern call the Data Stage jobs with all paths to Source and targets and even with connection information
• Developed various ETL workflows with event waits, assignments, conditional flows, email and command tasks
• Maintained naming standards and warehouse standards for future application development, and also created functional and technical specification documents.

Environment: Informatica Power center 9.1, Informatica Developer IDQ , Analyst IDE , ORACLE 11.2.0.3, Windows Server 2008, Business Objects XI R2, Flat files, PL/SQL, TOAD 9.7 and Robot Scheduler.

Confidential

Responsibilities:

• Worked with business analysts to identify appropriate sources for Data warehouse and documented business needs for decision support data.
• Agile approach is followed including Programming, Test-Driven Development and daily Scrum.
• Extensively worked with the sources which are extracted from Greenplum tables and Flat files.
• Involved in developing the data model and the tables required for the design.
• SAS programs are analyzed and the business logic is developed to replace SAS environment.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Worked extensively on Source Analyzer, Mapping Designer, Target Designer and Transformation Developer.
• Designing the Target Schema definition and Extraction, Transformation and Loading ETL using Data stage.
• Experience with full SDLC, Agile methodologies.
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.
• Configured and used FTP connection on workflow manger to access source file.
• The ETL jobs are scheduled daily and monthly by Opswise scheduling tool.
• Written Postgre SQL override queries in source analyzer to customize Target mappings.
• Created, scheduled sessions and tasks. Involved in the performance tuning of Informatica mappings.
• Migration of Informatica objects from Development to testing and then to production and setting up the UNIX directories for Parameter files and Logs.
• Documentation of the project activity all along the course of the project along with Failure Recovery plans.

Environment: Informatica 8.1, Greenplum 3.0, UNIX, Business Objects XI R2, Flat files, Postgre SQL, SAS 9.2, PgAdmin 1.12.1, MS Access 2007, Teradata Sql Assistant 7.1,Opswise 1.7, Filezilla 3.5, Remedy ITSM

Confidential

Responsibilities:

• Worked with business analysts to identify appropriate sources for Data warehouse and to document business needs for decision support data.
• Extensively worked with the sources which are extracted from Oracle, Flat files and XML files.
• Star Schema was used to design the warehouse.
• Worked extensively on Source Analyzer, Mapping Designer, Target Designer and Transformation Developer.
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.
• Extensively used Ascential Datastage for creating Datastage jobs.
• Extensively used almost all Transformations such as Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sorter, Sequence generator transformations for developing the mappings to apply the business logic.
• Designed, developed and deployed new data marts along with modifying existing marts to support additional business requirements.
• Configured and used FTP connection on workflow manger to access source and target files.
• Schedule, Run and Monitor sessions by using Informatica Scheduler.
• Used PL/SQL whenever necessary inside and outside the mappings.
• Created, launched scheduled sessions and tasks. Involved in the performance tuning of Informatica mappings.
• Wrote PL/SQL Packages and stored procedures to implement business rules and validations.
• Experience with full SDLC, Agile methodologies.
• Utilized UNIX scripts to schedule the Informatica workflows, which were in turn used by the scheduling team to schedule the workflows using the Control M.
• Migration of Informatica objects from Development to QA and from QA to production and setting up the UNIX directories for Parameter files and Logs.
• Created Repository folders, User accounts and assigned privileges using Repository Manager.
• Closely interacted with the reporting team which uses Cognos for generation of reports.
• Developed the Dashboard reports using Cognos Report Studio.

Environment: Informatica 8.6.1/8.1, ORACLE 10g, Business Objects XI R2, UNIX, XML, Flat files, PL/SQL, TOAD, Cognos 8 BI Report studio, Framework Manager , Control M.

Confidential

ETL Developer/ BI Developer

Responsibilities:

• Participated in reviews and meetings to evaluate documents, plans, code, requirements and specifications.
• Analyzed the source data coming from Oracle, Teradata and Excel files. Worked with Data Warehouse team in developing Dimensional Model.
• Worked closely with the user decision makers to develop the transformation logic to be used in Informatica.
• Extensively ran Batches on the Data Stage using Data Stage Director
• Responsible to tune ETL procedures, STAR schemas optimizing, load and query performance.
• Designed and developed Star Schema and created Fact and Dimension Tables for the Warehouse using Erwin.
• Dealt with SSIS Import/Export wizard to move data in and out of SQL Server.
• Used Informatica Designer to create mappings using different transformations to move data to Data marts and Data Warehouse.
• Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Union, Joiner, Rank and stored procedure.
• Implemented Slowly Changing dimension SCD methodology for accessing the full history of accounts and transaction information.
• Worked with Teradata stand alone load and unload utilities Mload and Fastload.
• Scheduled the informatica workflows using the scheduler tool Autosys.
• Identified the Bottlenecks and resolved performance the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Worked on Prompts to build Interactive Dashboards/reports with drill-down capabilities.
• Experience with full SDLC, Agile methodologies.
• Developed Analysis Studio views of analysis from dimensional modeled packages.
• Provided 24/7 Support for the Production that has Daily, Weekly and monthly refresh for production OLTP instance.

Environment: Informatica Power Center 8.1/7.1, Business Objects, Oracle 10g, Teradata V2R5, UNIX, Erwin 4.0, Toad, SQL Server 2005, SQL Loader, Autosys, Cognos 8 BI.