Data Software Engineer

Hem Naidu

Ph: 952-***-****

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

PROFESSIONAL SUMMARY

Innovative Data Warehousing/ETL Architect/Developer with an expertise for

transforming complex business requirements into workable and sustainable

solutions. Over 12 years experience in working with cross-functional, cross-

organizational teams both onshore and offshore. Diverse experience base

including Java Architect/Developer and Data Warehousing Architect/Developer

roles. Proven ability, based on an extensive background of varied technical

skills, to devise and suggest practical and cost effective solutions to

clients. Superior communication skills including the ability to explain

technical concepts to non-technical audience. Excellent project management

skills and a can-do attitude ensuring successful, on time and budget,

project completions.

EXPERIENCE

Digital River Inc, MN

Jun 2008 -

Present

Global $1.5B E-Commerce solution provider for Software publishers and

Consumer Electronics

Technical Architect/Developer- Designed and Implemented Enterprise

Marketing Data warehouse (EMD) with MDM, Star and Snowflakes schema

methodology to serve various cubes and data marts. Integrated with third

party data sources via HTTPS/FTP/SFTP mechanism to exchange the marketing

and commerce data for various marketing systems. The EMD serves the

automated/manual reports for external/internal clients for ROI tracking of

different marketing programs.

. Interviewed executives to understand corporate reporting needs and

conducted reporting workshops with various departments to gather high

level reporting requirements, which helped to prepare scalable and

extendable architecture.

. Performed data profiling, data modeling, fact and dimension tables,

grain analysis, and modeling of data at all the three levels: view,

logical & physical.

. Prepared the source to target design documents based on the data

model and technical requirements design document, auditable and

efficient development process.

. Extensively used transformations like Java Transformation, Lookup,

Router, Sorter, Joiner, Filter and Update strategy to address complex

data transformations.

. Created daily reports from fact and dimension tables and validated

data, answered the queries and addressed any problems generated.

. Developed primary production supports to the jobs which enabled

proactively fixing any failures and escalating issue to relevant

teams.

. Created detailed standards operations manual that included restart

logic and instructions needed for the future support of the jobs

creation.

. Created the deployment plan for migration of the code to production

environment from QA after the UAT was successfully completed.

. Created controls of health of the system and alert mechanism to

respective audiences on various thresholds.

Technical Architect/Developer 2006-2008

Designed and Implemented commerce order, clients, products, payment

activity, contracts, vendor XML data feeds into SAP PI system with data

cleansing process via Trillium using Informatica from different commerce

systems. Created and maintained the repository of XSDs for different data

feeds into SAP. Monitored different data feeds processes and tuned to

perform faster, frequent intervals and parallel sessions of data loads.

. Implemented Change control process to minimize scope changes for SAP

implementation.

. Led the technical design of sales dimensional model and analytics for

Enterprise Data warehouse system as commerce SME and application data

understanding was critical.

. Designed new client payment process flow to generate accurate invoice

reports/feeds to the clients.

. Identified and centralized some of the frequently used lookup and data

cleaning rules using maplets.

. Developed and automated data retention policies on archiving and

destroying the data files that were being created in different data

exchange integrations.

Senior Software Engineer 2004-2006

Designed and Implemented data warehouse for sales data from multiple

commerce systems. Created and maintained Meta data information for entire

data warehouse and self service reporting portal for real time and bulk

reports processes (offline). The data marts also served other reporting

systems for internal and external client's customer reports.

. Performed extensive data profiling on data coming from multiple

sources systems. Identified and fixed inconsistencies before it was

sent to the mart which reduced inconsistencies of final reports.

. Managed the entire ETL process involving the access, manipulation,

analysis, interpretation and presentation of information from both

internal and external data sources to client.

. Utilized transformations like aggregator and update strategy for

hourly loads on data grouped by certain fields and also updated delta

data daily.

. Used Informatica Work Flow Manager/Monitor to create tasks and run

sessions and performed Unit Testing on the designed mappings

. Designed and Developed flexible querying portal to produce bulk

reports.

. Responsible for monitoring all the sessions that are scheduled,

running completed and failed. Involved in debugging the Mappings that

failed.

. Performed database connections, SQL joins, cardinalities, loops,

aliases, views, aggregate conditions, parsing of objects and

hierarchies.

. Scheduled and coordinated Informatica tasks using UNIX cron and Perl

scripts. Email and paging facilities were also utilized at key points

in the process for its status visibility.

Senior Software Engineer 2001-2004

Designed and implemented various core components of e-commerce system

including Digital Rights Management, Custom CD/DVD integration, Product

Export Controls and Denied Parties Screening, Fraud Screening,

International Payment Processing and Centralized Payment Gateway using SOA

architecture.

. Subject matter expert in all aspects of B2B and B2C retail e-commerce

systems

. Managed development team capacity plan, operational issues and

prioritization of tasks.

. Established a reputation of leading and designing complex projects

with record breaking timelines

. Provided solutions to ecommerce best practices for enhancing customer

shopping experience (Increased 2% payment authorization success rate)

. Proactively planned technical roll out of new payment methods and

commerce features to existing clients and new clients.

Software Consultant 1999-2001

Executed web based RMA processing solution for Fujitsu. Analyzed,

technical architecture and implemented using Java technology. Designed

database model, Data ETL automation, UI design for web based solution. Also

trained users on the new the system/features to ensure consistent, accurate

procedures.

. Led technical architecture, database design and managed development

tasks and operational issues

Sunflower Information Technologies Inc, MN

Oct 1997 - Jan 1999

ERP solutions provider

Associate Consultant - Provided an Intranet solution for Sunflower

Information Technologies. The Intranet includes the 'Proans' application

which is an automated timesheet showing time usage of Sunflower

Consultants, Generated periodical report on the analysis of timesheets,

which was useful for the management for its efficient operations.

Summary of Technical Expertise

Technology Keywords

Data Warehouse Informatica 8.X, Data Modeling (Logical and Physical)

and SAP using ERWin, Visio, Power Designer, 2NF, 3NF, CDC, SCD,

Integration(ETL) Data Cleansing and MDM, Star Dimensional/Facts and

Snowflakes methodologies. Data streams into SAP via XML

and data out of SAP BW. Designing cubes and data marts

for various reporting systems. Performance tuning of

sessions and queries using various techniques.

J2EE Java, XML, OC4J, Tomcat, XSLT, Struts, Spring, JDO,

technologies Hibernate, Design patterns, System Architecture, UML,

Test Driven Development, RUP/EUP/Agile methodology and

Service Oriented Architecture(SOA)

Databases Oracle, ETL Scripts, MySQL, MS SQL Server, PL/SQL, Data

model design and tuning.

Web technologies Apache load balancing, Perl, CSS/HTML

Other MS Project Management, Eclipse, Shell Script, SAS, Unix

Summary of Functional Expertise

Industry Functional Areas

e-Commerce/Retail Shopper side (Shopping cart and Checkout), Catalog

maintenance, B2B client integrations, Accounting,

Fulfiller integrations, ETL, Digital Rights

Management, Single-Sign-On, Email notifications,

Content Management, Localization and

Internationalization. Retail data warehousing and

dimensional schemas.

Travel Itinerary management, invoicing, excursion plans

Payment, Billing Global Payment methods, foreign exchange,

and costing localization, contracts and costing

Educational Perceptional assessments, course assessments,

Assessment longitudinal assessments

Compliance PCI regulations, NASD/FINRA 3070 regulations

Management

Education

University of St Thomas St Paul/Minneapolis

. Master of Science (M.S.) in Software Engineering (OOAD and Database

Design major)

University of Mysore Mysore, India

. Bachelor of Science (B.S.) in Computer Science and Engineering

Contact this candidate