MADHAVI PEDDAKURUMA

617-***-**** ac3etx@r.postjobfree.com

PROFESSIONAL SUMMARY:

** ***** ** ********* ******** Development Experience in Analysis, Design, Development and Production/Maintenance of Data Warehousing Applications.

Thorough knowledge of the Data Mart Development Life Cycle. Performed all dimensions of development including Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses.

Installed, tested and deployed monitoring solutions with Splunk services. Implemented forwarder configuration, search heads and indexing.

Prepare, arrange and test Splunk search strings, complex and operational strings, and provide technical services to projects, user requests and data queries.

Created and configured management reports and dashboards. Managed and maintained use cases into correlation systems. Developed, evaluated and documented specific metrics for stakeholders / groups / management. Resolved configuration based issues in coordination with infrastructure support teams.

Worked on all database management applications including open source software and executed retrieval of complex database effectively.

Extensive experience in Oracle 10g/11g/12c and scripting skills in multiple languages including Perl, AWK, SED and basic Shell Scripting. Automating various jobs and performance processes tasks by creating scripts and cron jobs. Worked on Oracle PL/SQL programming including development and tuning of applications, packages, stored procedures, functions and Unix/Linux Shell scripting.

Experience on Oracle Real Applications Clusters (RAC), support of mission-critical, high availability and highly scalable database systems. Experienced in working with data warehouse installations and knowledge of managing dimensional data, Oracle SQL tuning, Storage Management.

Designed multi-dimensional models (Star, Snow Flake schema). Experience in Data Modelling, Business Process Analysis. Expertise in handling errors using Exceptions with RAISE application clause.

Extend and maintain existing ETL processes to accommodate new or changed data feeds. Proactively diagnose research, monitor and resolve database-related faults and performance problems including high CPU, memory, blocking, deadlocking and timeouts.

Develop specifications, source to target mapping and other documentation required for development. Implement adequate monitoring, validations, data integrity, data modelling and auditing to accurately measure and trend ETL performance. Fine tune complex queries against very large databases (VLDBs).

Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.

Proficient with the most recent versions of Cognos and associated applications used in generating reports for different organizational requirements.

Exposure to Finance and banking sectors with regards to data warehouse development.

Familiarity with ETL tools like Informatica Power Centre to implement ETL processes and also Business intelligence reporting tools like OBIEE and Cognos BI, Oracle Hyperion Essbase and Comfortable with multiple database concepts, i.e. RDBMS, OODB, ODS, Warehouse.

Experience in Oracle BI Apps that include OBIEE/Siebel Analytics, ETL Tools in Banking, Financial, Pharmaceutical, Insurance and Sales & Marketing domains.

Knowledge in relational database management systems like Microsoft SQL server 2008, T-SQL, SSIS (SQL Server Integration Services for data integration and workflow apps), MySQL, Sybase, Datastage, DB2 and multidimensional database concepts like oracle Essbase Hyperion, OLAP and OLTP tools.

Review and fine tune scripts, stored procedures, functions, and triggers related to bug fixes before releasing to production and developed the Views, Synonyms, Functions, Procedures, Packages, Triggers and Cursors.

Highly motivated & target oriented team player with a can-do and will-do mind-set who enjoys working with multi-functional teams towards achieving a common goal and as well as an individual contributor.

Enthusiastic and quick to adapt new technologies that helps to enhance and give the best at work. Proficient in documenting all day-to-day administration procedures, change controls & support activities.

Experienced in handling multiple projects simultaneously and effectively.

SCHOLASTIC PROFILE / CERTIFICATIONS:

Bachelor of Technology, [Electronics & Communication Engineering], J. N. T. University, India

IBM Certified Database Associate for DB2 Universal Database V8.1

Oracle Advanced PL/SQL Developer Certified Associate (OCA)

Oracle Advanced PL/SQL Developer Certified Professional (OCP)

ITIL Foundation Certificate V3

IBM Certified Web Sphere Data Stage V8.0

Splunk Certified Architect V6.0

Certificate of Participation in AWS Solution’s Architect.

TECHNICAL SKILLS:

Operating Systems: Windows Server, Solaris, Red-Hat Linux, Cygwin

Cloud Base Support: VMware, ESX, Hyper-V, AWS EC2, S3, RDS, EBS, VPC, IAM.

Languages: PL/SQL, SQL, RMAN, Shell, Perl, C, Java, JCL, HTML, COBOL

Database: DB2, Oracle 9i & 10g, 11g, Microsoft SQL Server, IBM Datastage, Informatica PowerCenter, MySQL,

Sybase, Oracle Hyperion Essbase, OBIEE, IBM Cognos, Mongo DB.

Backup/Recovery: Rman, User Managed Backup/Recovery.

High Availability: OPS, RAC, CRS, Grid Infrastructure, DataGuard, Replication, Automatic Storage Mgmt ASM

Tuning: Operating system, network, database parameters, SQL and PL/SQL.

Tools: Oracle Enterprise Manager (EM), DBVerify, LogMiner, Tkprof, SQL*Loader, import/export, Data Pump, Automatic DB Diagnostic Monitor, OBIEE 10.1.3.x, IBM Tivoli Monitoring Suite, ITCAM, ITNM, Solarwinds, SCOM, Splunk 6.0.

IT Software: Oracle SQL Server, PL/SQL Developer, TOAD, Putty, WS-FTP Pro, Log Analyzers, Diff utilities, Notepad++, Editplus, MS Word, Excel, Power Point, Oracle golden gate, Outlook, SharePoint, Erwin, ORACLE Designer, ClearQuest.

PROFESSIONAL EXPERIENCE:

State Street Bank and Trust Company, Boston, MA JULY 2013 – Present

Role: Senior Application Developer

Project Title: Comprehensive Capital Analytics solutions (CCAS)

Operating System: Linux, Unix, Solaris, Windows XP, Windows 7

Skill Set: ETL, PL/SQL, SQL, Shell/PERL Scripting, Oracle 10g, 11g,12c, Putty, Excel, SQL Loader, IBM Infosphere Datastage 8.5, PL/SQL Developer, SQL Navigator, WS FTP Pro, WinSCP tools, SharePoint, ClearQuest.

Responsibilities:

Analyze ETL mapping document requirements for the development of DataStage Extraction, Transformation and Loading (ETL) Jobs to load data from RDR, CMS, MAN, TDR source systems into target risk authority (RAY) schema tables and enable data elements required for RAY calculations.

Analyse business reporting requirements and translated into analytical applications work on Datastage for Oracle warehouse. Modifying existing loading programming scripts as per change request. Code and Program mappings for ETLs for Oracle Data Warehouse according to client specification.

Analysis of the project scope, business rules, user requirements and performing feasibility analysis.

Exclusively involved in ETL design, development, loads and deployment, Quality assurance, status reporting, tracking time and cost in loading data warehouse.

Designed and developed Job information language(JIL’s) for automation scheduling of ETL jobs using AutoSys Scheduler. Handled Full load and partial load via staging tables in the ETL Layer for Daily RWA & monthly Advanced and standard contexts specific to particular reporting dates.

Delivering business critical RAY application generate reports on time for all pillar3, schedule 101 & HC-R,RC-R reports and responding to the requirements quickly and updating the configuration according to the requirement in the RAY(Risk authority)application.

Use ClearCase to control different Versions of the ETL jobs and deploy the configuration scripts through cloud DB deploy process. Delivering under tight deadlines and driving quality practices.

Contributing to process improvements to reduce handling time and improve output.

Upgraded the ETL datastage version including migration of code from 8.5 to 11.5 version across DEV, UAT, BUAT, PROD env’s.

Involved in technical discussions and facilitated in meeting deadlines.

Provided the directions to team to implement unit test plans for Extraction/Transformation.

Involved in data cleansing and loading of data into staging areas.

Involved in Configuration management decisions.

Extend and maintain existing ETL processes to accommodate new or changed data feeds. Proactively diagnose research, monitor and resolve database-related faults and performance problems including high CPU, memory, blocking, deadlocking and timeouts.

Involved in complete SDLC process, through all phases of project life cycle - analysis, design,

development, testing, implementation and post-production activities.

Project Description:

The objective of this project is to extract the data from different source systems and make the data available in the Risk authority repository for access. This repository is to be supplemented by a catalogue mechanism that helps in identifying the RAY tables that contain Basel 3 Advanced & standard calculations for all the regulatory products supplied by Investor Support Services. The identified data is then extracted and supplied to Navigant for further analysis and reporting and this project helps financial institutions comply with the Basel I, II, III regulatory standards on bank capital adequacy and liquidity agreed by the members of the Basel Committee on Banking Supervision.

Bank of America, Charlotte, North Carolina Sep 2010 – March 2012

Project Title: Collaborate Optimize & Manage IT (COMIT),

Role: IT Analyst

Operating System: Linux, Unix, Windows XP

Skill Set: ETL, PL/SQL, SQL, Shell/PERL Scripting Oracle 10g, 11g, Putty, Excel, SQL Loader, IBM Cognos 10.1.0,Analysis studio,Report studio,Metric studio,PL/SQL Developer, SQL Navigator, Oracle golden gate,WS FTP Pro, WinSCP tools, SharePoint, OBIEE 10.1.3.2., IBM Tivoli Monitoring, ITCAM for Applications, ITNM

Responsibilities:

Responsible for managing the IBM Tivoli environment to monitor the IT infrastructure, hardware, software, and applications environment with the Tivoli Monitoring Toolset on Linux, VMware and Windows platform. Develop and maintain an overall Enterprise Monitoring Architecture.

Act as lead liaison for interfacing technical administrators implementing a monitoring solution; specifically with Tivoli. Monitoring toolsets used in day to day operations and maintenance.

Monitor all systems/processes; escalate and assume ownership of issues as needed to ensure resolution is provided in timely manner. Design and implement application enhancements, customize monitoring solutions, and troubleshoot.

Provide technical insight for support teams in the Tivoli Monitoring environment; Troubleshoot and resolve Tivoli Monitoring issues. Participate in implementation and documentation of all monitoring activities.

Delivering business critical application generate reports on time and responding to the requirements quickly. Receiving the volumes and rates from the Business partners and calculating the costs and make them available in terms of Verification Cross Check Reports.

Install and configure performance monitoring utilities such as OEM grid control, configure ASM, create databases, instances and services.

Involved in Creating and Administering the Physical Layer, Business Model & Mapping

Layer and Presentation Layer using Oracle Business Intelligence Admin tool.

Support Oracle RAC Servers and troubleshoot operational tasks including data loads, index builds & backups.

Debugging the scripts and jobs written in UNIX Shell and PERL on Development and UAT Server.

Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.

Analyse business requirements and system specifications to understand the application processing’s.

Responsible for creating and modifying the PL/SQL Procedures, Functions according to the business requirement.

Developed reports using Cognos Report designer,Cognos framework manager,Cognos Powerplay tool.

Extend and maintain existing ETL processes to accommodate new or changed data feeds.

Implemented robust ETL processes to extract transform and load data from transactional databases to the Data marts and operational data stores.

Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.

Developed ETL specifications, source to target mapping and other documentation required for ETL development. Implement adequate ETL monitoring, validations, data integrity, data modelling and auditing to accurately measure and trend ETL performance.

Monitored periodic ETL batch application processes and resolved errors on time.

Updating the changes of Companies and cost centre information to reflect all over applications. Application maintenance and scheduled job monitor.

Integrated real-time data from numerous sources, enabling real-time business intelligence to deliver more targeted, personalized marketing initiatives and campaigns to end customers using Oracle golden gate.

Involved in extensive code-walk check and organize the client’s new requirements and tasks.

Documenting the daily tasks and updating the share point access repository with new types of issues and resolutions. Prepare daily reports and attend client calls

Updating operational processing times, production incident issues and scenario process tracking based on each application processing in SharePoint.

Updating Information related to databases, reports, and business applications in SharePoint and to help team members locate the information they need to make good decisions.

Project Description: Bank of America is a leading bank in United States of America, with its world headquarters located at Charlotte, North Carolina. Bank of America is one of the world’s largest financial institutions, serving individual consumers, small and middle market business and large corporations with a full range of banking, investing, asset management and other financial and risk-management products and services. Bank of America has recently entered into a master agreement with TATA Consultancy Services to utilize its offshore development services. It has a large international business base, being one of the five major players in the banking industry. It ranks first among the top 20 US bank holding companies by total banking assets. COMIT is a methodology for determining cost rates for specific activities of an organization.

TATA Teleservices Limited February 2010 – August 2010

Project Tittle: EPOS-Postpaid-CR

Position: Cognos Report developer

Operating System: Sun Solaris 5.9. Windows 2000/XP

Languages: PL/SQL, SQL, UNIX Shell Scripting

Software used: Oracle 9i/10g/11g, TOAD, Cognos Report Studio, Analysis Studio,Metric studio,Oracle Report Builder, SQL Loader, Oracle SQL* plus, Report Builder (6i & 9i), Edit plus, Excel, OBIEE 10.1.3.2, Oracle BI Applications 7.9.4(Sales Analytics, Order Management Analytics)

Responsibilities:

Develop reports using Oracle Report Builder and shell scripts for automating report delivery.

Performed database tuning using Explain Plan, hints, utlbstat/utlestat, Toad, PowerExplain, and Enterprise Manager.

Created complex PL/SQL packages, procedures, functions, Triggers and extensively used PL/SQL tables, cursors, user defined object types and, exception handling.

Provided on-call production database support.

Developed scripts to monitor all failover jobs and analysed logs for better performance.

Developed Technical Architecture and designed options.

Developed architecture options to address scalability and performance such as load balancing.

Installed and configured Cognos 8 BI products, tuning and testing.

Designed, developed and modified Cognos reports using Cognos Report Studio and Query Studio.

Collaborated with Cognos defined best practices for reporting architecture to evolve enterprise products.

Defined and enhanced the Cognos reporting architecture.

Creation and maintenance of PL/SQL programs and Shell Scripts. Writing ad-hoc queries and change requests queries (CR’s) based on schema knowledge for various reporting requirements.

Automating various jobs and performance processes tasks by creating scripts and cronjobs.

Performance tuned many queries and taking back up of cronjobs and shell scripts.

Debug and optimize SQL queries and stored procedures

Guiding the co-team members for solution optimization.

Assist in project planning and scheduling

Developed and supported for Interactive Tool Reports generation for clients

End-to-End Automation of Metasolv, E-POS & CRM, Cognos BI module Reports.

Developed shell scripts for Backup/recovery and management of Data Warehouse.

Project Description: Tata Teleservices Ltd. (TTSL) is a key business player in telecom sector in India offering services like Wireless, Wire line, CDMA, Leased Line, ISDN, Level DID and ISP etc. TTSL is well established in India and offering services across all states in India. Tata Consultancy Services (TCS) is involved in implementation, integration and production support of the IT Systems at TTSL to give a complete IT solution using OSS/BSS architecture. TCS has been awarded this project for the development and Maintenance of Discoverer Reports for Business Analysis and reporting needs.

TATA Teleservices Limited February 2008 – January 2010

Project Tittle: TTL Reports,

Position: BI consultant

Operating System: Sun Solaris 5.9. Windows 2000/XP

Languages: PL/SQL, SQL, UNIX Shell Scripting

Software used: Oracle 9i/10g/11g, TOAD, Cognos Report Studio, Analysis Studio,Metric studio,Oracle Report Builder, SQL Loader, Oracle SQL* plus, Report Builder (6i & 9i), Edit plus, Excel.

Responsibilities:

Developed reports using Cognos Report studio and shell scripts for automating report delivery.

Creation and maintenance of PL/SQL programs and Shell Scripts. Writing ad-hoc queries and change requests queries (CR’s) based on schema knowledge for various reporting requirements.

Automating various jobs and performance processes tasks by creating scripts and cronjobs.

Performance tuned many queries and taking back up of cronjobs and shell scripts.

Involved in DBA activities like troubleshoot Oracle reports issues and tuned reports parameters. Coordinated in improving the system performance by increasing the system specifications.

Debug and optimize SQL queries and stored procedures

Guiding the co-team members for solution optimization.

Assist in project planning and scheduling

Developed Interactive Tool Reports generation for clients

End-to-End Automation of Metasolv, E-POS & CRM module Reports.

Project Description: Tata Teleservices Ltd. (TTSL) is a key business player in telecom sector in India offering services like Wireless, Wire line, CDMA, Leased Line, ISDN, Level DID and ISP etc. TTSL is well established in India and offering services across all states in India. Tata Consultancy Services (TCS) is involved in implementation, integration and production support of the IT Systems at TTSL to give a complete IT solution using OSS/BSS architecture. TCS has been awarded this project for the development and Maintenance of Discoverer Reports for Business Analysis and reporting needs.

TATA Tele Services Limited May 2007 – January 2008

Project Title: Post-paid Data Reconciliation

Position: BI developer

Operating System: Sun Solaris 5.9. Windows 2000/XP

Languages: PL/SQL, SQL, UNIX Shell Scripting

Software: Oracle 9i, TOAD,Cognos Report Studio, Analysis Studio,Metric studio, SQL Loader, Report Builder (6i & 9i),Editplus,Excel.

Responsibilities:

Implemented the data extraction, comparison of data from different Systems like Metasolv, EPOS, HLR, BP, CRM etc. using Cognos BI and finding the discrepancies by comparing the data with different systems taking Metasolv as the base.

Finding the route cause analysis for various data discrepancies and fixing the issues in database and clearing the discrepancy data finally. The project involves with below two workflow reconciliations.

1. EPOS-MS-BP-CRM Reconciliation

2. MS-EPOS Reconciliation

Developed PL/SQL stored procedures and functions to extract the data from different systems and also code for fixing the route cause of data discrepancies.

Automated many PL/SQL programs using shell scripts in such way to get the attached excel sheets of discrepant data to the respective mail Id’s.

Attending meetings and client calls with multi-functional environmental teams.

Maintaining the dashboard for current status and repository for issues, incidents and documenting day-to-day tasks.

Project description: Tata Teleservices Ltd is a key business player in telecom sector in India offering services like wireless, wire line, mobitel, Leased line, ISDN, Level DID, and PRI. Tata consultancy service (TCS) is involved in implementing, production support and integrating the IT system of TTL to give a complete IT solution. This project involves production support for the system like order billing management (Metasolv), application (Arbor bp), customer relationship management (oracle CRM), Integration manager (TIBCO), subscriber activation system (SAS), and point of sale system (pos).

Toyota Financial Services Nov 2006 – April 2007

Position: Team Member

Operating System: Windows 2000/XP

Languages: Mainframes (JCL, COBOL, DB2)

Responsibilities:

• Interaction with client through mails

• Internal Quality Assessment

• External Quality Assessment

• Final Inspection

Project description: Maintenance and Support for Toyota Financial Services website. It concluded with the development of “Toyota Rewards Visa” application for TFS website.

Project: Initial Learning Program August 2006 to October 2006

Location: Trivandrum

Role: Team Member

Tools and Technology: Mainframes, DB2, COBOL, JCL

Description: Initial Learning Program deals with induction of a new recruit into TCS. It’s a 2 month long session which deals with various aspects of skill gathering required for a career in the IT industry.

Responsibilities:

•Attending sessions on various Software technologies (Programming languages, Operating Systems, Software engineering, TCS proprietary tools etc., Systems Engineering, Requirements Engineering, Testing and Debugging).

• Performing case studies, assignments on various software technologies.

• Attending soft skill Session.

Contact this candidate