Srinivas Nemani

Name: Srinivas Nemani

Email Id:************@*****.***

336-***-****(C)

Work Status: EAD

SUMMARY:

• Thirteen plus years of experience in design, development and maintenance of projects in Client - Server Technologies on UNIX and Windows Platforms with Retail companies like USPS, LOWE’S, GEMS, and Finance companies like JP Morgan Chase, TIAA-CREF, and Bank of America.

• Involved in design, enhancement, and development of applications for OLTP, OLCP, and DSS using dimension modeling with Teradata, Oracle, Sybase ASE, and Microsoft SQL Server.

• Involved in developing the UNIX scripts for Informatica Workflows using parameter files and monitoring the workflows on production environment.

• Involved in creating source to target mapping, edit rules and validation, transformations, and business rules.

• Involved in SQL Optimizations, Performance Analysis, and future growth analysis for OLTP and data warehouse applications.

• Involved in designing the Database tables using Normalizations, implementing data integrity constraints, and Data validations at Database/application levels.

• Involved in system development life cycle from database design, front-end GUI design, Coding, testing and implementation.

• Developed applications in UNIX, and Windows using C/C++ with Embedded SQLS using Sybase, Oracle and Teradata.

TECHNICAL SKILLS:

Operating Systems Windows, Sun Solaris 2.5.1, 2.6, 8, 10, AIX 4.3, 5L

DBMS Teradata, Oracle, Sybase ASE, and SQL Server.

Database Utilities mload, fastload, tpump, bteq, sqlplus, exp, imp, sqlldr, isqlplus, and bcp.

Programming Languages C, C++.

Middle ware DCE 3.1, Encina TXSeries 4.3, CORBA (Visibroker).

Tools & Utilities Shell Scripts (Korn, Perl), AutoSys, Informatica, Erwin, Crystal Reports, T.O.A.D, Trilogy SC Products 3.1x, Purify for Sun Solaris, Microsoft Visual studio 6.0, Visual Basic 6.0, Visual Work Shop 6.0 (Forte),Visual age 6.0

IT PROJECTS PROFILE

BANK OF AMERICA, Charlotte, NC (Mar 2008 – May 2009)

Project Title: CRMS, GCIB AML Repository (GAR), WCRMS

Role:

• Involved in modifying the logical design for staging data, reporting data for new enhancements using Erwin as a modeling tool for GAR schema.

• Developed the DDL/DML scripts for GAR and CED schemas for ACP, GRCC, and KRAF enhancements.

• Developed UNIX scripts and AUTOSYS scripts to load extract files in to staging tables using sqlldr.

• Developed PL/SQL Packages to transform/load the staging data into GAR schema using business logic.

• Developed PL/SQL exception reports which will be sent to DMO for review for data exceptions, automated email notifications for job failures.

• Developed UNIX scripts for WCRM ETL workflows to load the data in to staging tables using pmcmd and parameter files. Involved in monitoring the daily data loads using Informatica Work flow monitor and resolving the job failure issues

• As part of Capacity Optimization and Planning team involved in identifying the top resource consuming

• SQLS and remediation of them.

• Involved in monitoring the PMON for the performance of the Teradata Production and Report Servers and requesting for VIP to meet SLA for EOD, EOM data loads.

• Involved in performance tuning for SAS SQLS and ETLS using Explain Plan, Index creation, Optimizer hints, Statistics gathering, AmpUsage, DBQL and PMCPINFO

• Developed SSA Revenue Goals System which will export the data from EDW RDM/ADM and sends to Oracle database Server using AFT. Implemented Restart ability and error logging and used standard ETL functionality

Environment: Windows, Sun Solaris 10, Korn Shell Scripting, Teradata V2R6, PMON, Oracle 10g, Informatica 8.0

TIAA-CREF, Charlotte, NC (Feb 2006 – Feb 2008)

Project Title: Institutional Reports on the Web (IRW):

Role:

• Involved in logical design for staging data, reporting data, meta data, and security user using Erwin as a modeling tool.

• Designed and Developed the DDL scripts for OMNI (staging tables which are exact copy of extract files) and IR tables (report tables).

• Designed and developed Informatica Mappings to load data from different Source systems to Data ware house.

• Developed IRW ETL workflows to load the data in to staging tables using pmcmd. Involved in monitoring the daily data loads using Informatica Work flow monitor and resolving the job failure issues.

• Developed bteq, fastload, mload, fexp scripts to load/unload the data into staging, report databases and to collect statistics.

• Developed UNIX scripts to load extract files in to staging tables using sqlldr. Developed views and PL/SQL packages to load the data from staging tables into report tables using the business logic.

• Developed PL/SQL security package, Partition Package, Data Loads/Delete Package, Reports Packages for IRW application.

• Involved in defect fixes and enhancements for existing PL/SQL packages and performance tuning of PL/SQL packages and testing them in development and System test environments and moving to production environment.

• Developed Unix Shell scripts for Automation Jobs that will check the data files and Oracle tables for data loads for System test and Production environment.

• Involved in production support for daily data loads.

Environment: Windows, Oracle 10g, Teradata V2R6, Informatica 8.0., T.O.A.D, Oracle 9i Client, Erwin, Star Team.

Lowe’s, Wilkesboro, NC (Jun 2003 – Jan 2006).

Project Title: DMS and Stores

• Involved in logical database and physical design according to application requirements and designed developed DDL, DML scripts to implement logical design enhancements.

• Involved in designing and developing P/SQL and TSQL Stored procedures, Embedded SQLs, Referential Integrity constraints, triggers to enforce the business rules.

• Involved in designing and developing data entry screens for SOS Express, LMS, Lowe’s Credit Card, and Store Visibility.

• Developed informatica ETL workflows, fastload, mload, tpump scripts to load the data from OLTP applications (Sybase, Oracle) to DSS applications (Teradata).

• Involved in tuning the application at Data design, application design, and logical structure of the Database.

• Developed standard reports for all applications and provided stand alone and menu driven functionality for reports.

• Involved in identifying the top resource consuming SQLS and tuning the SQLS by analyzing explain plans and remediation of them.

• Developed Korn shell scripts to perform store operations and DMS operations.

Environment: AIX 4.3, 5.2, Visual age 6.0, Sybase ASE, Oracle 9i, Teradata V2R6, fastload, mload, bteq, Informatica 7, MQAPI.

Production Support/Development, CINGULAR Wireless, Atlanta. (Sep 02 – May 03).

Project Title: SAIL

Role:

• Involved in developing scripts for loading data from text files into Oracle database staging tables using SQL loader utility.

• Developed PL/SQL stored procedures and triggers to enforce the business rules, and to load data from staging tables in to EIM Siebel tables.

• Involved in Development and maintenance of Korn Shell Scripts for monitoring Siebel Application Servers and Oracle Database Servers running on Unix Systems.

Environment: Sun Solaris 8, Windows NT Work Stations, ORACLE 8i, T.O.A.D, Siebel 6.3

Programmer/Analyst, JP Morgan Chase, New York (Oct 2000 – Aug 2002).

Project Title: MDL

Role:

• Developed Code for spEngine++ Libraries (C++ libraries) and tested with purify on Solaris 2.5.1, 2.6 and 2.8 and on Windows NT.

• Developed applications in Multi threaded environment using Connection Pool technique on both Solaris and Windows NT using Cobra (Visibroker) and used Rogue wave Tools Library.

• Developed applications (creation of MAS in 2 and 3 tier architectures using Enconsole) with DTM XA functionality in Sybase ASE 12.0.0.3 using DCE Version 3.1 Patch 4 / Encina - TXSeries 4.3.0.3 on Solaris 2.5.1 and 8 using STL and Rogue Wave tools.h++ libraries.

• Developed DAM (Distributed Application Management) packages using Korn Shell for MDL.

• Involved in Bug fixing, maintenance and Production Support for MDL.

Environment: Sun Solaris 2.5.1, 2.6, 2.8, Windows NT 4.0, SUNWspro C/C++ 4.2, 5.0, STL, Rogue wave Tools, Visual C++ 5.0, Sybase ASE 12, DCE ENCINA, Rational Rose 2001a, purify 4.0, 5.2, gcc 2.7.2, 2.9.3.

Programmer/Analyst, General Electric Medical Systems, Milwaukee (April 1999 – Sep 2000).

Project Title: Cobra 1.7

Role:

• Involved in developing PL/SQL Stored Procedures Triggers to enforce the business rules.

• Involved in tuning the Database ESQL optimizations using Oracle Optimizer hints, rewriting effective SQL statements, and using EXPLAIN PLAN.

• Involved in SQL statement tuning with restructuring the indexes, restructuring the statements, and restructuring the data.

• Responsible for designing, coding and testing of Configuration module.

• Developed Screens for Config, Quote and Help modules with Visual Basic 6.0.

• Performed Unit, System, and Integration testing for Config, Quote, and RFA modules.

Environment: Visual Basic 6.0, MS Access, Trilogy SC Products 3.1, Oracle 8i, T.O.A.D.

S/W Engineer, G5CS CTCSD, Japan (July 1997 – March 1999).

Project Title: G5cs Client-Server Data Base Entry System

Role:

• Designing, coding and testing of G5CS Enhancements that include some additional functionality to the original system (G5EX) in the migrated system (G5CS) in C/C++ using SUNWspro 4.0.

• Developed complete standalone G5CS system for Windows NT using Visual C++.

• Developed GUI Screens for the modules used by supervisors for Data Entry Unit using Visual Basic 3.0

• Involved in developing TSQL stored procedures to for reports generation.

• Involved in designing and developing DDL, DML, TSQL Stored procedures for standard and ad-hoc reports.

Environment: SUNWspro C/C++ 4.0, Sun Solaris 2.5.1, Visual C++ 2.0/4.0, MS SQL Server, Crystal Reports, Visual Basic 3.0, Windows NT 4.0 Work Stations.

S/W Engineer, NFCL, India (May 1995 – June 1997).

Project Title: Store Management System

Role:

• Responsible for designing of Database tables using Normalization techniques.

• Involved in developing PL/SQL Stored Procedures to enforce the business rules.

• Involved in implementing Referential Integrity constraints for data validations

• Designing of Data Entry for Material Request Note, Material Inward Note, Goods Invoice Note, and Purchase Order Screens.

• Developed standard and ad-hoc reports.

Environment: Pro *C/C++, DRS 6000, UNIX System V Release 4.0, Oracle 7.1, SQL 3.0, Forms4.5, Reports2.5, Crystal Reports 2.5, and Windows 95.

EDUCATIONAL QUALIFICATION:

Bachelor of Technology (Electronics & Communications Engineering), JNTU, Kakinada, India.

Oracle 10g Certified Administrator Associate.

Teradata Certified Professional V2R5.

Contact this candidate