SUMMARY

• Over Seven years of professional experience as a Web/Business Analyst.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Offered best practice advise on governance and SharePoint 2013 features
• Experience of variety of Web Analytics packaged analytics tools such as Omniture, WebTrends.
• Experience with custom tag management involving updating and configuration.
• Experience in extracting data from data warehouses and creating SAS datasets from various sources like Oracle database, Access database, Excel and flat files using Import techniques.
• Experience with Web Content Management attributes like automated templates, Access control, easily editable content, Workflow management, Content virtualization.
• Strong experience in creating and publishing packages in Framework Manager.
• Experience in Cognos BI tools using Cognos Framework Manager, Report studio
• Extensive knowledge in training users and maintaining Digital Analytics and other reporting tools.
• Good knowledge of Pass through concepts of SAS Access to Databases.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Extensive experience in verification, validation (cross - functional testing) and SDLC Process.
• Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
• Experience in the e-commerce environments with knowledge of commerce ATG suite.

PROFESSIONAL EXPERIENCE

Confidential - Fort Lauderdale, FL

Web Business Analyst

Responsibilities:

• Providing WEB Analytics training to employees across the company.
• Providing web analytics reports, analysis, training & support to strategists about each Citrix product.
• Integrating web data with cross-channel marketing and customer data.
• Developing web analytics implementation & optimization roadmap.
• Extracted data from Oracle using SQL Pass through facility and generated reports.
• Reduced web analytics reporting time by 40 hours/month by report automation using Excel, Google Analytics API and GA Data Grabber & Tableau.
• Proven track record to transform non-Agile teams to Agile teams.
• Involved in WCM processing including mechanisms of Offline processing and online processing.
• Worked with business partners and implemented to use SharePoint for collaboration and WCM
• Managed aspects of enterprise-wide SharePoint 2013 installation and migration from on-premises SharePoint 2010 environment to private cloud.
• Created standard output templates (HTML and XML).
• Designed, Implemented and Maintained statistic profiles for public and private Web sites.
• Designed and Implemented the WebTrends software upgrade and solved technical problems with both internal support groups and WebTrends Technical Support.
• Developed custom reports with dashboard involving presentation and analysis of data.
• Created custom reports and documentation for internal and external clients.
• Provided internal and external customers detailed analysis of their statistics profiles.
• Developed, implemented and maintained the standard agile release of documentations such as plans, agendas, deliverables, and action item lists.
• Performance tune PL/SQL and SQL statements to help support the existing systems
• Researched functionality of SharePoint 2013 in advance of Enterprise implementation to assist organizational change
• Composed technical knowledge documentation of WebTrends configurations and Administration for use by team members.
• Utilized and implemented SEO/Paid Search best practices.
• Developed campaigns, Ads and optimized landing pages.
• Provided campaign refinement, optimization recommendations and Testing.
• Created in-depth campaign reporting and analysis.
• Executed search engine campaign management (Google, Yahoo, Bing, etc).
• Responsible for creation of optimized landing pages.
• Assisted in SharePoint 2013 Apps Model application design and development
• Set up tracking methods and codes for optimized Remarketing campaign
• Develop a proprietary investment process for managing client accounts.
• Develop quantitative models to identify investment opportunities.
• Created SAS Macros from data warehouse and modified the existing ones relating to multiple studies
• Researched, developed, and implemented new investment tools using MS Access, MS Excel, and other analytic systems
• Created a dynamic PL/SQL solution to test and verify replication of over 1200 tables between two platforms.
• Develop, refine, and support annual as well as monthly forecasts for the media channels.
• Performance tuned existing PL/SQL of the clients applications.
• Created a data collection engine that polled various data sources including the Adobe SiteCatalyst forstored the resulting data
• Experience in developing Macros using SAS procedures within data warehouse.
• Worked with Liferay involving modules Liferay Social Office, Liferay Sync.
• Experience in WCM with development of themes, new portlets and modification of the existing portal.
• Created list reports & cross tab reports using cognos 10.1
• Generate and Implement SEO strategies to improve search engine rankings for multiple websites.
• Implemented security into Cognos Transformer Models using Macros.
• Involved in Structuring Metadata and Cognos Models using Framework Manager.
• Reviewed and streamlined existing CRM processes, information, and data requirements to ensure accurate adoption metrics reporting.
• Worked collaboratively on cross team projects with Project Management, Developers, System Analyst Quality Assurance, and Database Administration to define site requirements for new and existing web development.
• Performed testing and quality assurance of web sites and web applications.
• Managed web environments, set up new environments, deployed new and existing web sites.
• Provided maintenance activities for web sites.

Confidential - Plymouth Meeting, PA

Web Analyst

Responsibilities:

• Omniture Sitecatalyst v15 and Google Analytics implementation, reporting and analysis.
• Omniture Sitecatalyst implementation of multiple sites, website tagging and testing and data validation.
• Omniture Sitecatalyst variable planning including evars, props, events.
• On site and off site search engine optimization including organic keyword rank analysis keyword and content mapping and optimization. Pay per click program management.
• Worked with Dotcms for providing support through clustering and structured content.
• Experience with Dotcms versions 2.5 and 2.3.
• Involved with marketing team in digital measures and Provided digital marketing strategy and implementation services
• Installed & Configured SharePoint 2013 on Premises (Enterprise License) using Windows 2012 & SQL 2012.
• Managed enhancements and roadmaps for product catalog, ratings & reviews, promotions and product recommendation platform.
• Wrote PL/SQL to load and process email opt-in data from third party into a database
• Implementing Agile development best practices and moving to monthly releases from point releases.
• Designed the flow and the processes involved in Agile Deployment Stages.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures
• Created website architecture and flow for both SEO and end user engagement
• Digital Strategist for marketing solutions agency. Translated client needs into digital marketing recommendations, and worked with clients for approval and implementation.
• Experience in SAS Edit checks with Automated Quarry generation
• Identify the most profitable paths through digital assets with Adobe SiteCatalyst
• Creating Microsoft Excel dashboards and reports on daily weekly basis analyzing key performance indicators.
• Measure, report, and integrate data from initiatives into a single place through Adobe SiteCatalyst
• Reduced web analytics reporting hours by 25% by creating report templates with automation and data consolidation.
• Helped other teams to reduce project hours by 80% by analyzing web analytics data and providing feedback to focus on major areas to increase return on investment.
• Responsible for the management and documentation for over 300 web statistics profiles
• Created and Maintained statistic profiles for both public and internal web sites.
• Used SAS ODS to produce HTML, PDF and RTF format files
• Worked with statisticians in generating SAS analysis datasets, data listings, summary tables, and statistical analyses associated with data warehouse
• Designed and implemented a software upgrade from WebTrends Application Software version 7.0 to 8.7d.
• Troubleshoot technical problems with NREL system administrators and with WebTrends Technical Support.
• Create and analyze detailed statistics reports for internal and external clients.
• Maintain web interface page to provide access to statistics reports.
• Taught end-users how to utilize the tools and analyze operational models, to identify opportunities for improvement and efficiencies and provide recommendations for service levels agreements.
• Worked with both internal teams and external contractors to implement and tag websites to ensure the measurability for the web site.
• Developed custom reports with WebTrends and Microsoft Excel.

Confidential - Philadelphia, PA

Web Analyst

Responsibilities:

• Provided weekly, monthly & ad hoc web analytics reports using client’s web analytics tools such as Omniture Sitecatalyst & Google analytics.
• Provided web analytics implementation, tagging, testing and data validation support.
• Assisted various clients with web analytics implementation, configuration & data validation.
• Implement WebSideStory reporting software on Comcast.com
• Create custom reports and perform actual analysis to track customer behavior on Comcast.com
• Present key analytic findings and related solutions to senior management
• Created Web Analytics & Insights team; providing technical audits & ongoing site performance consultation services for Google Analytics, SiteCatalyst & other industry leading analytics platforms
• Monitor online marketing campaigns and evaluate their effectiveness
• Develop unique consumer web pages for various business units
• Author business requirement documents for all eBusiness projects
• Lead and monitor web analytics effort for three external web properties
• Optimized Web Analytics environment for the best performance.
• Assessed Web Analytics needed licensing and server requirements
• Present key analytics findings and related solutions to senior management
• Develop, deploy and monitor online marketing campaigns
• Implemented and configured Google Analytics, Omniture SiteCatalyst, and Urchin software
• Analyzed data from web analytics tools to create customized reports calculating key performance indicators, metrics, and trends
• Identified action items to improve key website performance goals
• Evaluate marketing campaign effectiveness by leveraging web analytics applications

Confidential - Chicago, IL

Web Business Analyst

Responsibilities:

• Custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work with ATGs eCommerce suite.
• Managed/optimized PPC accounts using Google Analytics.
• Provided weekly, monthly & ad hoc web analytics reports using Google Analytics.
• Designed online banners with Adobe Flash and Photoshop.
• Managed e-mail marketing campaigns.
• Authored copy for press releases, website content, training material, and customer support resources.
• Applied Agile and Lean principles/practices to organizational issues, portfolios, and projects.
• Monitored Website performance, trends and click stream path analysis.
• Performed daily management of WebTrends analytics system.
• Developed key reports, dashboards and analysis.
• Identified enhancements to Website based on usage and traffic patterns.
• Conducted Search Engine Optimization and advice on search and display ads.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents