CV of SRINIVAS
Srinivas Konduru Email: ******@*****.***
Professional Summary
• More than Eight years of Information Technology experience using ETL – Informatica, SQL & worked on different Data warehouse applications.
• Have worked on Project life cycle across different domains and worked in different phases of Datawarehouse projects using Informatica Power Center.
• Have a good exposure in giving the estimations and collecting the requirements from the clients.
• Capable to handle the team more efficiently and ready to take new responsibilities.
• Have good understanding of the Agile Methodology and also used in various projects.
• Excellent teamwork, communication and collaboration skills, providing an equally productive resource as both an individual performer and group contributor.
• Natural affinity for technology, with the demonstrated ability to move easily among various systems and rapidly adopt new tools.
Technical Skills
Hardware IBM Compatible/Pentium
Operating Systems DOS, Windows 95, 98, Windows 2003, NT, Windows XP, UNIX
Languages SQL, SQL Navigator
Databases Oracle 9.0/10g, Teradata 6.2.
ETL Tools Informatica 7.1.3, Informatica 8.1, Informatica 8.6
Domain Knowledge Banking, Retail, Logistics, Energy & Utilities
Logica India Pvt Ltd. Since Dec 2007
Project Lead
NOKIA - NDW (Nokia Datawarehouse)
Nokia is engaged in the manufacturing of mobile devices and in converging Internet
and communications industries, with over 132,000 employees in 120 countries, sales in
more than 150 countries and global annual revenue of over €42 billion and operating
profit of €2 billion as of 2010.
NDW is built on a scalable, large, cross functional platform. The Sales Planning Simulation (SPS), UI provides the user capability to perform multiple multi-dimensional simulation and analytic tasks on Nokia channel economics data. The business logic and UI has been iteratively designed with Local Sales Units within SPS and Channel Economics projects during 2007 to 2009. Users will be able to understand and improve the contribution of channels through management of all customers and products in a way that optimizes Nokia’s and channel partners’ profitability.
Responsibilities
• Have been worked extensively in requirement gathering, analysis, design and coding ETL process using Informatica.
• I was involved Database Design phases and performance tuning activities.
• Having good experience in Agile methodology and been conducting meetings and was acting as a scrum master, sprint review too.
• Have been allocating the Change Requests to the team members and make sure that the delivery will happen within the time frame.
CANAL plus
Canal plus is a French premium pay television channel. It has more than 10.5 million subscriptions to all offers. The BI tools used (Informatica-ETL, Harry as Reporting) which supports various applications and used for different needs which includes Customer, marketing Services, Sales Network, Logistics, Commissioning, Interactive Services (Departments), etc.
Worked in France (Montpellier) and understood the business and involved in some development tasks and assigning the Change Requests to the team.
Responsibilities:
• As a Project lead my role was to assist team members to work independently.
• To allocate the Change Requests to the team member and make sure that delivery will happen within the time frame.
• Have been participated in Bidding for other projects and given the estimations for BI operations.
DP-DHL (Deutsche Post)
DP-DHL (Deutsche Post) is a World’s leading Logistics group. The application gathers information from the various legacy applications and has multi vendor BI systems strategy. Each of these BI systems has its own means of entry for the users to access the data (reports, CUBES).
In this project we are using the Informatica to encapsulate the logical transformation and the standardization of the process, with regard to accountability, transparency, monitoring, reuse and recovery. Cognos and Business Objects for the reporting and java for the interfaces. This 24X7 support project and we are doing the enhancements based on the requirements.
Responsibilities:
• As a Lead & configuration manager, I was responsible to maintain all the project documents, team registry, leave plans etc.
• To prepare estimations, status reports and to plan the deployment and implementation of some changes requests and also to resolve the user queries.
• To maintain the uniformity of work and guiding the team.
Environment: Informatica 8.6.1, SQL, Teradata, Shell scripting, Remedy.
CIBER Sites Inc. Mar 2007 to Dec 2007
Home Depot Supply (US)
HD Supply is the wholesale distribution division of The Home Depot, the world's largest home improvement retailer. We offer products and services primarily to builders, contractors, government entities, industrial businesses and maintenance professionals. As one of the top diversified distributors in the country, the breadth of our product line enables us to supply a project end-to-end - from infrastructure to construction to maintenance, repair and remodel. Backed by The Home Depot and a $69 billion supply chain, HD Supply provides unmatched access to the products and services our customers need to succeed.
Responsibilities:
• Support the Jobs weekly, checking the workflow monitor and notifying the Production Jobs.
• Enhancement, Modification and Testing will be done, if client insisted to do.
• Resolving the issues, as per checking the Service Center Client. So approximate time has given to complete the job according to severity levels.
• Status report to be submitted to Project Manager on weekly basis.
Environment: Ascential Datastage PX, Teradata, Shell scripting.
Oracle India Pvt. Ltd. (NAIO), India (Genisys Software) May 2006 to Dec 2006
American Express, Phoenix, USA
American Express is sponsoring the review of its financial management systems in order to better position them to achieve their corporate goals and maximize shareholder value. As part of the OFI (Oracle Financials Implementation) program, American Express is deploying its corporate ledger unit, unit 021, on to an Oracle General Ledger instance. The project provides deliverable value points and budget checkpoints each year based on best practices and measured results such as “Replace legacy operational General Ledger”, “Consolidate Corporate data into single source of financial information” with a timeline that considers how much concurrent change the organization can absorb each year.
Responsibilities:
• Extracting source data from legacy systems and moving into Staging area - Oracle10g.
• Developing mappings (MDM, GL Inbound, GL Conversion and GL Layer) and reusable transformations using Informatica Designer according to business logic to load data.
• Created various stored procedures for moving the data from stage to target - Oracle Apps.
• Created Mapping Parameters, sessions and workflows.
• Analysis of Functional specification.
• End-End Testing i.e. Performing UTC and Involved in SIT.
Environment: Informatica 7.1.3, SQL, Shell scripting, Win SCP.
Info Services (IBM India Pvt Ltd) Jan 2003 – April 2006
System Administrator
I was associated with IBM through Info Services as a contractor and was involved into various Desktop services and as well as performing the role of System Administrator. Used to setup new machines for the new users like configuring, installing the software’s and to update the Anti-virus. Hardware and software troubleshooting, checking the network related issues. Various administration tasks like (User Administration, Log Administration, Security Administration and Patch Administration)
Responsibilities:
• Quickly arrange repair for hardware in occasion of hardware failure.
• Proper maintenance of the systems of the organization.
• Setting up standard installation packages for all the systems to ensure uniformity.
• Create a backup and recovery policy.
• Monitor network communication
• Update system as soon as new version of OS and application software comes out.
• Implement the policies for the use of the computer system and network
• Setup security policies for users. To maintain computer security (e.g. firewalls and intrusion detection systems).
• Ensure proper connectivity to all the end users in the organization.
Environment: Windows 2000, 2003 Server.