Application Developer V Resume
NJ
OBJECTIVE:
- Performance - driven SAS certified project lead with strong communication and interpersonal skills and over nine years of experience in data analysis, development, and implementation looking for a challenging full time position.
SUMMARY
- Nine plus years of technical experience catering data and analytical services to marketing, finance, sales and manufacturing business units on Windows, Linux and UNIX platforms.
- Project Management skills towards managing and coordinating projects.
- Interacted with salesforce email cloud for email deployment.
- Built internal and external relationships with business partners, IT managers, Project Management Office, external vendors and their technical representatives.
- Knowledge of hardware sizing and configuration and procurement.
- Worked on different data domains such as Campaign, Contact, Booking, opportunity, propensity etc.
- Working knowledge of Teradata and Oracle databases.
- Extensive working knowledge of vendor data such as Dun and Bradstreet (DnB), Harte Hanks, Axiom, InfoGroup etc.
- Experience in creating data-marts as well as ad-hoc reports.
- Experienced working with international data types represented by Double Byte Character Set (DBCS) and Unicode (UTF-8).
- Working knowledge of SAS EBI server functions and administration.
- Experienced in installing and configuring SAS (9.1, to 9.4) server on various platforms.
- Expertise on using Reflection X on UNIX and Linux platforms.
- Abilities to support a variety of SAS applications such as Base SAS, Enterprise Guide, Enterprise Miner, and Forecast Studio in PC and UNIX/Linux/UCS environments.
- Self-motivated and effective team player with strong technical and analytical skills.
TECHNICAL SKILLS
Operating Platforms: Microsoft Windows 98/2000/NT/XP, UNIX, Linux
Databases: TeradataV2R6, Oracle 9i, MS SQL Server 2000/7.0/6.5, MS Access
Programming Languages (Statistical): SAS 9.4, E-views, S.P.S.S., EViews and Gauss
Programming Languages (General): SQL, Java, HTML, Assembly Language, Cand UNIX
SAS Skills: SAS 9.4 Enterprise Guide, CI Studio
Other Skills: MS Office (Word, Excel, Power Point, Access,)
PROFESSIONAL EXPERIENCE
Confidential -NJ
Application Developer V
Responsibilities:
- Developed and maintained the SAS Customer Intelligence (CI) campaign management environment
- Created multichannel campaigns (mail, phone, robo-calls, email, digital, text)
- Developed and tested campaign metrics including AB testing
- Develop and maintain Information Maps (IM) for campaign design
- Influence marketing department to develop campaign strategy
- Maintain SAS Common Data Model (CDM) database
- Own marketing and producer (broker system) database
- Consult on development of acquisition and retention campaigns for different market segments
- Established best practices
- Performed sanity checks and fixed bugs
- Create on-demand custom codes to support multi-channel campaigns
- Build solutions including one to select best possible email address
- Create platform specific opt-outs (preference management process)
- Schedule campaigns
- Coordinate with vendors
- Manage vendor relationships
- Assess, track and coordinated changes
- Work towards creating a digitalization plan for marketing campaigns
- Help implement the salesforce email cloud
- Designed installed and configured SAS Platform with SAS Customer Intelligence and Visual Analytics
- Secure funding for development as well as installation and configuration
- Coordinate efforts for hardware sizing and professional installation
- Work with vendor management and procurement teams
- Coordinate with hardware and Operating Systems (OS) teams to install and configure
- Led CRM projects
- Manage Project from inception, development to completion
- Coordinate with ETL, testing, architecture, DBA and EPMO for project management responsibilities
- Assess budgets and lead projects to success
- Document, test and coordinate deployments
- Collaborate with other teams and deliver cost effective solutions
- Administered the SAS EBI Server with Campaign Automation
- Apply hot-fixes
- Maintain data integrity and security
- Schedule jobs
- Fix bugs and work with platform support teams
- Coordinate training programs
- Control access and act as a data steward
Environment: Linux 64bit, Windows 2008 Server, Oracle, SAS v9.4, SAS/SQL, SAS/Macro, SAS/Base, SAS/Connect, SAS/STAT, SAS/EBI, SAS/CI Studio, SAS/DI Studio.
Confidential
Lead Developer/ Administrator
Responsibilities:
- Planned and coordinated projects with senior management, on resources, progress, timelines and implementation.
- Took projects through software lifecycle of development such IT testing, ST testing, QA testing, approvals and finally production
- Managed contingent workers to achieve project and organization goals.
- Documented, tested and coordinated deployments.
- Implemented projects to segment customer portfolios.
- Helped with migration of SAS server from AIX to UCS platform.
- Fix production bugs for SAS codes
- Led a cross-functional IT development team to undertake a conversion project from Informatica to DataStage.
Environment: Windows XP, UNIX-AIX, Linux/UCS, Teradata, Oracle, SAS v9.1, SAS/SQL, SAS/Macro, SAS/Base, SAS/Connect, SAS/STAT, SAS/EBI.
Confidential
Sr. SAS Application Developer/ Analyst
Responsibilities:
- Build an application that supports all home mortgages and contact database systems.
- Cater new loan process using data from various sources.
- Maintain and support an ETL process to bring in data from Freddie Mac and Fannie Mae.
- Generate a list of leads to support the mortgage campaign.
- Analyze loans processed by Washington Mutual and Confidential .
- Documented, tested and coordinated deployments.
Environment: Windows XP, UNIX-AIX, BD2, SAS v9.1, SAS/SQL, SAS/Macro, SAS/Base, SAS/Connect, SAS/STAT.
Confidential
Lead Data Analyst
Responsibilities:
- Create scoring and training cohorts as a part of advanced analytics team for predictive analysis such as wallet calculation and propensity to buy models.
- Create listings of contacts, leads, seminars from past campaigns and create actionable listings for future campaigns.
- Find ways to make the IT data more usable for marketing campaigns.
- Use SFDC (sales force dot com) data to analyze and help create campaigns for US, Canada, Europe and the APAC.
- Make use of the DNB and SFDC information to find new companies in different verticals for increased bookings.
- Coordinated and developed a monthly ETL process consisting of SAS codes and UNIX shell scripts to extract more than 130 million plus DnB (Dun and Brad Street) records from DnB ftp server.
- Coordinate with business users, application developers, DBA, and architects for new developments, bug-fixes and enhancements.
- Assisted D&B in finding data anomalies.
- Gathered requirements from various marketing and sales teams and implemented projects.
- Performed data analysis, data migration, data preparation, validation and Documentation.
- Coordinated with internal partner teams and business clients to resolving data anomalies and improve data quality in the data warehouse.
- Developed and Implemented logic to find the true employee count of D&B companies to run better campaigns.
- Implemented AMI (Actionable Market Intelligence) tier logic and populated the data for Marketing, and updated as required.
- For econometric analysis of Cisco vital metrics, developed and scheduled ETL’s consisting of time series data.
- Excellent working with marketing data types (Bookings, Campaigns, Contacts, Opportunities, partners, etc.)
- Developed and Maintained ETL scripts to refresh SAS data mart with daily, weekly, monthly and quarterly refreshes from Teradata and Oracle, and scheduled as necessary.
- Used SAS Access to connect to the databases such as Teradata and Oracle.
- Worked on projects to exploring new coding techniques and maintaining existing dataset.
- Supported the SAS community in installing SAS software and fixing coding bugs as well as in removing o/s complications arising from third party software.
- Supported marketing data miners by developing new coding techniques and processing methods.
- Helped debugging and troubleshoot the SAS BI suite.
- Debugged Forecast Studio and Enterprise minor issues.
- Extremely comfortable with loading Double Byte Character Set data (German, Russian, Asian languages, etc.,) into SAS, and onto other databases.
- Administered the SAS EBI Marketing server (start and stop SAS services, spanners, clean spool space, etc.).
- Assigned permanent libraries using the SAS management Console (SAS, Oracle and Teradata).
- Created additional SAS servers from the Management Console and added users as requested.
- For data security, assigned UNIX groups to different SAS users as per their authorization level.
- Coordinated with finance controller and team managers on data governance and implement the level of authorization for users.
- Created, assigned and validated UNIX groups to different SAS users as per the data governance rules.
- Worked with other system administrators (Oracle, Teradata and backup) to Install SAS 9.1.2 and 9.2 with UNIX and Linux /UCS platform.
- Performed cross platform data migration from Windows to UNIX and from UNIX to UCS for SAS data as well as Enterprise Miner and Forecast studio projects
- Helped test the Information report studio and web report studio.
Environment: Windows XP, UNIX/Linux-UCS, TeradataV2R6, SAS v9.1, SAS/SQL, SAS/Macro, SAS/Connect, SAS/Base, SAS/STAT, SAS/EBI.
Confidential
Graduate Assistant
Responsibilities:
- Worked with the economics department faculty on data gathering, analytical processes, and documentation.
- Collectedgenderspecific revenue and expenses data for basketball and football for NCAA Division I teams.
- Graded examination and homework assignments.
- Proctored examinations.