SUMMARY:

Advancing Company Technology with Quality Software Development . Award Winning Senior Software Developer with experience driving design, development, and implementation of production releases and complex software / database initiatives. Expertise with C and database internals, Confidential DBS development, reporting systems in data warehousing using Business Objects, debugging, testing, and project / team leadership. Worked in Solaris, Linux, HP - UX, and Windows environments. Ability to forge meaningful stakeholder relationships and lead / influence teams. Certified as a Confidential Professional.

CORE COMPETENCIES:

• Software Development
• Agile Methodology
• Team Leadership
• Project Management
• Technology Improvement

TECHNOLOGIES:

Processors: SUN-SPARC, Intel x86 (Both 32-bit and 64-bit)

OS: Windows, Unix, Sun Solaris 2.6, HP-UX and RedHat Linux

Languages: C, C++

Technologies: Database Development, Debugger Development

Databases: Oracle

Tools: Clearcase, CVS, GDB, DBX, XML, Erwin, Expect

Test Framework: DejaGNU

BI Tools: Business Objects XI, Web intelligence, XCelsius, Informatica, SAS, R, Hadoop, Hive

PROFESSIONAL EXPERIENCE:

Confidential

Software Engineer

Responsibilities:

• Implemented the alter table SQL statement to include map changes for a given user table, user defined function to display all the contiguous AMPs in the system, and HASHAMP and HASHBAKAMP to retrieve the AMP number for the hash values.
• Defined small tables to only live on 1-few AMPs and increase the number of AMPs whenever required.
• Reduced downtime by allowing almost all online reconfiguration by keeping user tables on the legacy AMPs and changing the reconfigure process to redistribute those tables online to a larger configuration.
• Enabled configure nodes with extra memory to run special purpose applications like SAS, R or QueryGrid.

Confidential

Responsibilities:

• Tested changes with data feed from Hadoop system.
• Performed upgrade / migration testing and code reviews.
• Allowed the Unicode surrogate pair code points to pass through at session level supported by the hash system to maintain data uniqueness and ensure no skewed data distribution of supplementary characters.
• Supported more than one million characters recognized by Unicode consortium.
• Clearly documented the detailed design in DFES/HLSDS.
• Handled 1840 normalizations and 123 case pairs.
• Organized data in GDO shared within the entire system by examining code points in normalizations and applying the appropriate data structures.
• Improved ease of work by developing scripts for operational tasks like conversion of scalar to surrogate pairs, extracting case pairs, extracting normalizations from millions of code points in the Unicode standard, and grouping and organizing normalizations into different categories.
• Developed detailed test cases for the code changes including isolated surrogates, non-characters, plane 14 code points and the remainder of the surrogate planes.
• Supported supplementary character hashing of multiple hash functions with / without Japanese support.

Confidential

Responsibilities:

• Conducted testing / code reviews, upgrades and migrations.
• Converted the AR table or dictionary table into a partitioned primary index (PPI) table to overcome the lock contentions and improve performance.
• Developed an ID2BIGINT function to run as a SQL to convert a table id or database id into a big integer.
• Design, coded, and implemented parts of the extended object names (EON) feature working with more than 20 other developers.
• Tested and fixed bugs. Communicated status in weekly meetings.
• Involved in enhancing stored procedure related system tables to accommodate extended object names.
• Wrote Unix scripts to automate SQL testing procedures and validate results.

Confidential

Responsibilities:

• Conducted sensitive data collection and identification of associated ETL maps with Informatica and Business Objects XI.
• Designed masking transformations for different categories of sensitive data like names, numbers, date ranges, credit card, SSN details, address, etc.
• Reviewed implemented transformations and ETL maps and tested Business Objects reports.

Confidential

Isolation Project Support

Responsibilities:

• Implemented the remote debugging of multithreaded programs using GDBserver which involved coding and unit testing in a XI LINUX, i386 Intel platform, an GDB 5.1.1 environment.
• Automated test case and testing for this feature.
• Posted code to open source GDB community.
• Led a three-member team to isolate the Business Objects universe and reports for Confidential Ohio sales database extracting from the complete integrated database within Business Objects 6.5, Oracle, Toad, and Informatica environments.
• Handled requirement specifications, and universe and report design.
• Created a new BO Universe for Ohio sales, new user groups, and subgroups with specific access rights and new web intelligence reports for Ohio sales.
• Migrated the sales data universe, desktop and web intelligence reports from an integrated sales database to separate the data for the Ohio division.

Confidential

Responsibilities:

• Managed a four member team working in database and ETL map design, ETL mappings, SQL override reviews, and verification with Toad for data correctness.
• Created multiple user groups and subgroups, specifying different user access rights.
• Gathered business requirements, translated the business information to database terms, ETL design, user design with security locks, and universe and report design.