Summary:

• 5 years experience as Database Developer, Data Warehouse Reporting Analyst/ DSS Developer, Data analyst on large Oracle databases (2.5 Terabytes ) to relatively smaller ones (50 GB)
• ETL processes and automation in a Data Warehouse environment using Korn Shell Scripting, AWK, DOS Batch Scripting, SQL *Loader and PL/SQL
• Worked with large datasets and used Business Intelligence tools like Business Objects to deliver reports and Universes
• Knowledge of Oracle internals, data structures, data retrieval and access mechanisms, Data Warehousing concepts
• Overall 8 years of experience in Programming, development, Business and System Analysis and Testing
• M.S. in Electrical Engineering, B.S. in Electrical and Electronics Engineering

Skills Set:

• Languages : Oracle SQL, PL/SQL, VBA for Excel and Business Objects, T-SQL( Beginner to Intermediate)
• Databases : Oracle10g, MS Access, SQL Server 2005
• Packages/Tools : Toad, SQL Developer, Business Objects, SQL*PLUS, SVN for Version Control, Cygwin
• Scripting : Korn Shell Scripting, DOS Batch Scripting

Professional Experience:

Sr. Database Developer, Confidential, Bothell, WA Mar ’07 to Present
Currently working at the AT& T Chief Security Office for the Identity and Access Management Operations Team. The ID tracking application is database centric and is approximately 100 GB. Worked with internal customers to create historic, current reports.

• ETL development using Bash Shell Scripting in Unix environment, DOS Batch Scripting in Windows environment, file pre-processing using AWK, Oracle SQL and PL/SQL and T-SQL for SQL Server 2005
• Advanced Reporting and csv file generation using advanced SQL functions (analytical, hierarchial) and Business Objects
• Used autonomous transaction concept to code stored procedures and functions to generate random and unique AT& T ids conforming to the company specific format
• DOS batch and Korn shell Scripting to automate file transfers for dynamically named files between servers using ssh clients and scp and sftp protocols
• Worked with Sun Role Manager(SRM) - a role based access control tool from SUN Microsystems to import company wide user and application user information into the SRM database ( approx. 50 GB )
• Converted OCI scripts to Oracle SQL scripts to reduce the complexity of managing feed generations
• Basic Database Administration functions like creating users and granting accesses, database copy and backups using data pump, modifying database parameter values for optimum processing, reading AWR, wait events and the dynamic performance views to identify road blocks for improving performance

Environment : Oracle 10g, Sun OS 5.1, SQL Sever 2005, Windows Server 2003

DSS Developer/Analyst, Confidential,WI Sep’05 to Feb’07
Part of DSS team to assist in the design, development and maintenance of Data Warehouse & Data Mart solutions(2.5 Terabyte and growing), which incorporates data models for Operational Data Storeand business specific Data Marts, data extraction processes, transformation, and load processing. Collaborate with reporting and data users to create predictive and historic reports via the Data Warehouse and Data Marts.

• Design, build and deploy advanced Business Objects Reports requiring complex and analytical SQL based on requirements from end users
• Perform analytical, technical, and administrative work in designing, developing, troubleshooting and deploying Business Objects universes using Designer
• Perform basic Database Administrative jobs like creating users, granting roles, altering tablespace requirements, develop ETL routines using Korn shell scripts, SQL *Loader, PL/SQL; performImport/Export of data for backups or transferring data
• Provide Helpdesk support to Business Objects and Oracle Users by assisting with SQL query validation, report creation or general data related questions on the Wisconsin Medicaid Program
• Assist and mentor users and team members to analyze and develop solutions to tune poorly performing queries

Environment : Oracle 10g, AIX 3.5, SunOS 5.8

Developer, Confidential, Columbia, MD May’05 to Aug’ 05
Worked on the Payroll Module of eFiducial Solutions with the Payroll Processing Center to design, develop and test modules and provide support to the web based application using ASP/ASP.NET and SQL 2000.

• Develop program design and testing
• Implementing enhancements and bug fixes and providing technical assistance to the computer user community
• Write Queries and Stored Procedure for SQL Server 2000

Environment : ASP, VB Script, JavaScript, ASP.Net, C#, SQL Server 2000

Associate IT Analyst,Confidential,Nov ’04 to Apr’04
Worked CARE Operations Technical Support Group to analyze and maintain day to day production data, provide production support and resolve daily member claims and service issues.

• Create Modules in VBA for Excel to assist with data isolation for analysis purposes
• Create ad-hoc Reports using SQL for oracle for error checking and production supportfor ‘Automated Enrollment of members’ program for the State of Maryland Account

Environment:VBScript, SQL, Oracle 8i; IBM Mainframe: TSO, Cobol, CICS, VSAM

Technical Business Analyst, Confidential,Madison April’03 to Oct’04
Worked as Liaison between Customer (Department of Health and Family Services, Madison) and Technical Solutions/Support groups to identify business processes, analyze subsystem impacts and gather business and product requirements for HIPAA Implementation (Health Insurance Portability and Accountability Act, 1996).

• Drafted Detailed Systems Design(DSD), High Level and Detailed Level Test plans to implement system changes based on business requirements
• Coded macros in VBA to automate the adjudication process to resolve claims
• Capture business requirements, design and create Full-client Desktop Intelligence reports on Claim Transactions using Business Objects and SQL

Environment: Oracle 9i, Windows 2000, IBM Mainframe: TSO/ISPF, Batch Cobol, CICS, JCL , VB

Software Engineer, Confidential, Associate of PEP Modular Computers, Germany Oct’98 to Jul’00
Worked on the development team to assist in the Development, commissioning and testing of applications using VB and Oracle 7.3 for different clients like ISRO Satellite Centre, Bangalore, India and Department of Atomic Energy at Kalpakkam, India.

Education:

• M.S., Electrical Engineering
• B.S., Electrical and Electronics Engineering