SUMMARY:

• An accomplished IT professional with 12+ years of proven experience leading high - value technology, engineering, and development projects for large enterprises. Expert in managing the end-to-end project lifecycle, from requirements gathering to development, deployment, and user support. Adds value by partnering cross-functionally with internal and external stakeholder groups to deliver the highest levels of quality, productivity, and efficiency, leveraging data to support business growth.
• 12+ years of experience in building Data Warehouse, Data Modelling and Business Intelligence providing end to end solutions to largescale industry firms like Parks and Resorts Marketing, Health Insurance and Financial sectors.
• Proven experience as project management, Data analyst, Systems Administration, Programmer/Analyst encompassing Requirement study, Analysis, Design, Programming, Process automations, Testing & Implementation.
• Administrative experience with Adobe Campaign tool, setting up external accounts for Teradata using FDA, SFTP accounts, SAS Metadata Management, Unix, Teradata, Maestro Scheduling, and Global Scape a file transfer tool
• Has Solid Experience Setting up SAS environment, creating metadata and data repositories on various operating environments
• 12+ years of demonstrated ETL experience with SAS Programming using SAS/BASE, SAS/SQL, SAS/MACROS, various SAS PROCS, SAS/ETL and SAS/ACCESS to Teradata, Oracle, Hadoop, DB2, Informix, Sybase, Siebel CRMM and traditional PC files
• Experienced in building segment using K-Means Clustering with SAS/STAS procedures.
• Has the knowledge of implementing, managing integration process using SAS® Data Integration Studio, SAS BI Solutions, Tableau
• Has hands on experience with data migration between the databases (Oracle To Teradata), migration of SAS applications across the platforms and across the versions
• Experienced in both back-end programming and front-end programming
• Excellent project management, communication, documentation and interpersonal skills.
• Excellent and proven, analytical, written and oral communications skills
• Hands on experience with Statistical analysis, data science and machine learning
• Highly motivated, self-learning, team player or independent worker with an interest in working in high-paced environment
• Proven troubleshooting skills and experience; Ability to quickly resolve technical issues
• Has good MIS consulting capabilities
• Strong Domain knowledge
• SAS Certified Advanced Programmer (Year 2007)

TECHNICAL SKILLS:

Operating Systems: UNIX, LYNIX, WINDOWS

Data Bases: Teradata, Oracle, MSSQL, INFORMIX

Open Sources: Big Data HDFS

Programming: SAS, SQL, Hive, Python, Scala, Unix shell scripting

Tools: SAS, SAS Data Integration Studio, Tableau, Hadoop, Teradata Administrator, Teradata SQL Assistant, TOAD Datapoint, Github, Global Scape EFT, Hue, Adobe Campaign Manager

PROFESSIONAL EXPERIENCE:

Confidential, Orlando, FL

Senior Business Intelligence developer and SAS Administrator

Responsibilities:

• Developed and implemented the ETL process using SAS, Teradata, and Hadoop to access data from various sources to populate data repository.
• Created data schemas by mapping respective tables in Teradata repository in Adobe campaign management, further utilized by workflow managers.
• Oversaw Teradata, Adobe Campaign, SAS, UNIX, and Global Scape EFT environment to ensure all systems were up and running so business partners were not impacted.
• Created BI environment with SAS/EG and SAS Information portal.
• Integrated data from various sources (Teradata, Hadoop, Greenplum, Oracle, ODBC) and different forms of write back data to enable users to access and visualize using SAS and Tableau.
• Managed metadata, including setting up to access various diversified data sources and open source data.
• Performed user management, setting up access controls for SAS users on UNIX, using SAS Management console based on roles and responsibilities.
• Took the lead in creating various stored processes to support users with the handling of projects efficiently; wrote UNIX Shell and SAS Scripts to automate jobs and SFTP files.
• Created a centralized data repository into Adobe campaign management applications so campaign managers could quickly generate workflow, visualize messaging, and deploy data to email/direct/SMS service providers
• Successfully designed and deployed the data repository on Teradata for easily accessible data to Adobe campaign environment; migrated 10TB of data and database objects from one Teradata environment to another.

Confidential

Responsibilities:

• Leveraged a strong understanding of the complete business process to gather requirements and develop a data model that met strategic objectives.
• Designed, developed, and completed the ETL process, and implemented using SAS scripts.
• Maintained key involvement in the process and data migration from Oracle to Teradata, as well as the design and development of an intranet security system for OLAP applications and MIS reports.
• Utilized advanced Tableau features: data blending, quick filters, actions, hierarchies, LOD calculations, and custom geocoding.
• Created multidimensional OLAP cubes and published using SAS portal for Business Analysts and marketing executives.
• Defined new projects based on user requirements and modifications to the existing projects with SAS Enterprise guide, resulting in a new reporting and analysis environment.
• Automated complete processes with integration of UNIX Shell and SAS Scripts; converted Informix SQL scripts to SAS programs.
• Provided end user support on an ongoing, day-to-day basis through administration and maintenance of metadata and data repository using SAS Enterprise Guide.
• Configured Apache web server and tomcat application for SAS/IntrNet and SAS/WebAF applications.

Confidential, Tampa, FL

Enterprise Wide Data Warehouse

Responsibilities:

• Created routines to load data warehouse for Professional, Institutional, and Pharmacy claims; additionally, created SAS routines for edit check, range checks, and other validation processes adhering to existing business rules in UNIX.
• Simplified programming complexities for other developers by writing various parameter-driven generic macros.
• Played a key role on multiple cross-functional teams, driving quality audits and training and administering users on software implementation.
• Oversaw the development and reporting of time sensitive, quarterly, monthly, and weekly reports to business partners and government agencies in a range of formats.
• Led monitoring and provided ongoing support of critical data warehouse load processes, ensuring 100% compliance with Sarbanes-Oxley (SOX) regulations.
• Compiled detailed documentation for programmatic logic used for automating the data validation and loading process.