SUMMARY

• A Highly dedicated and task Oriented professional with IT experience in Analysis, Design, Development, Testing, Administration and Support of Databases/Data warehouses
• Expert knowledge and experience using Unica Campaign Suite.
• Experience in Campaign Management and vendor processing through reports and documentation
• Extensive experience in data acquisition, data propagation and data transformation strategies.
• Extensive Performance & Tuning experience in both Database and Application (SQL, PL/SQL) tuning experience. Actively interact with development teams suggesting best practices, implementing standards in view of performance.
• Expertise in writing UNIX shell scripts.
• Extensive database experience using MS SQL Server2000/7.0, Oracle 11G/10g/9i/8.x, MS Office Suite.
• Sound knowledge in data loading, data modelling, data normalization, and database administration.
• Proficient at Enterprise Database Integration and Management. Well versed in Enterprise Database Integration and Data Migration among MS SQL Server, Oracle, and MS Access.
• Experience in Dimensional Modelling and Designing and building the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying.
• ETL Data warehousing experience using Informatica Power Mart 7.1/6.2/5.1, Informatica Power Center 7.1/6.2/5.1.
• Well versed with Software Development Life Cycle (SDLC), application design and testing.
• Ability to lead teams in high performance environment. Excellent focus on customer service and client relations. Good inter - personal and organizational skills.

TECHNICAL SKILLS

Hardware: HP Servers (T500, K570/580,D370), Sun Enterprise E10K, 5500/4500 Server, Sun Sparc/20, IBM-RS 6000, Compaq ProLiant, Intel based PCs

Operating systems: Sun Solaris 5.1, Red Hat Enterprise Linux ES R3, Windows 200X/ NT 4.0,XP

Development: SQL, PL/SQL, Unix Scripting

RDBMS: Oracle 8/8i/9i/10g/11g, SQL Server 2005, DB2 9x

Tools: & Oracle Products: OEM (Oracle Enterprise Manager), LogMiner, SQL Navigator, Toad, SQL Loader

ETL Tools: Informatica PowerCenter 7.1/8.6

OLAP Tools: Unica 7.2/8.x, Business Objects XI

Database: ORACLE 8i/9i/10g/11g

PROFESSIONAL EXPERIENCE

Confidential, Northbrook, IL

Unica Specialist

Responsibilities:

• Designed process flow for receiving data mined events, and processing events in Unica for Allstate marketing. Performed business and data discovery for online quote process. Created physical database design documents, and data rollups for reporting/campaigns. Performed analysis on Online quotes ADW Datawarehouse for partial and full quotes. Worked with architecture team in consolidating Facta customer information with marketing MDM repository.
• Performed GAP analysis for Unica server upgrade for handling email campaigns and call campaigns.
• Worked with the team in developing ETL data loading scripts.
• Worked with the team on automating campaign jobs using Tivoli job scheduler. Identified process dependencies, SLAs and escalation procedures.
• Created table catalogsIn Unica for Allstate Insurance marketing campaigns.
• Architected process and flowchart design in Unica for RTC (Reason to contact) campaigns. Used agile development model to facilitate the marketing strategy team in testing the campaign success and make any necessary modifications for more ROI.
• Optimized Unica campaigns and tuned costly database queries to run efficiently. Recommended table partitioning, creating clustered indexes, materialized tables, and query hints for increasing SQL performance substantially.
• Developed pivot table reports for opportunity counts for various ad-hoc campaigns.

Environment: Windows XP/UNIX, Oracle 10g, Unica 7.2/8.x, Sun Solaris, UNIX shell script, MS Office Suite

Confidential

Unica Developer

Responsibilities:

• Developed cross-sell campaign in Unica for cross selling DSL product for long distance voice customers.
• Worked closely with development team in creating welcome kit campaign in Unica for new customer’s signup with Talk America.
• Extracted information from Billing database about customer products and package information and sent it to print vendor.
• Worked extensively for tuning of long running campaigns in Unica.
• Worked with team on automating jobs to generate reports for business owners.
• Developed control files for ETL data loads using sql loader tool.
• Performed extensive data analysis for resolving campaign related issues.
• Developed pivot table reports for opportunity counts for various ad-hoc campaigns.
• Involved in enhancements and modifications of existing production campaigns.
• Involved in gathering business user requirements, understanding the business model (E-R diagrams), database table and query design, extracts and use of report query tools and Identify technical risks, assumptions, and dependencies.

Environment: Windows XP/Unix, Oracle 10g, Unica 7x, Sun Solaris, Unix shell script, MS Office Suite

Confidential - Chicago, IL

Project Lead

RESPONSIBILITIES:

• Worked in Campaign operations team, involves applying statistical tools and techniques for strategic Marketing for various products of the company
• Using Affinium Campaign (Unica’s data mining and strategic marketing tool) SQL, Oracle 11g
• Responsible for Technical Analysis, Development and prepares design for Unica Mapping document
• Database Marketing - Campaign development and co-ordination, end user needs
• Analytical design, execution and developing marketing campaigns
• Development of Unica flowcharts performance and tune flowcharts
• Creating Base and Dimension Tables
• Select, Snapshot, Extract, Mail list, Segment, Sample, Merge, Audience, Derived Fields and User Variable process configuration
• Working with extensively with latest Unica technologies and working all system upgrade process
• Developed all Unica batch jobs
• Worked in agile and iterative fashion to convert findings from data to business insights and recommendations