Technical Lead/project Manager Resume
Mclean, VA
SUMMARY:
- Contribute to technical account management and communications as well as customer satisfaction and implementation success. Responsible for timely deliverables and overall satisfaction of the customer in the development of several web and mobile applications from conception through full deployment
- Proven project management experience; analytical, conceptual, and problem - solving abilities: Managed a national website with 2500 members and a data warehouse hosting data for 150 institutions; administered MicroStrategy environment serving 700 mobile users
- Excellent communication and organization skills, able to anticipate and communicate activities or problems during a development cycle and work those issues through to resolution
- Experience working with several partners (communication, policy, institutional research, and knowledge development groups) while collaboratively developing custom web data tools and applications to provide web and data services for institutions participating in a national initiative
- Strong understanding of relational database structures, theories, principles and practices; able to troubleshoot complex data issues and implement solutions
- Extensive experience in the design, testing, development and implementation of complex database systems and system interfaces for process control, quality control, data collection and longitudinal data analysis for national data sets (The Integrated Postsecondary Education Data System (IPEDS), The Achieving the Dream National Data Set)
- Strong interpersonal skills in leadership, communication both written and oral, motivation, conflict resolution and fostering a team atmosphere among subordinates and coworkers
- Ability to build and deliver presentations to all levels of management to effectively explain complex issues and concepts in simple, understandable language
- Experience with Business Intelligence, Data Warehousing, Corporate Dashboards, Mobile Applications and Ad-hoc Reporting development
- Project Manager/Technical Lead for the implementation of several mobile and web reporting platforms on several industries: Pharmaceutical, Insurance and Investment Management, Automotive Marketplace, including the global insurance industry
- Technical Lead for the implementation of Mobile Applications integrating complex Pharmaceutical data sets: Commercial Analytics, Sales Ops and Aggregate Spend
- Managed the Entire Software Development Life Cycle for several Custom Web-based Data Applications for Higher Education
- Technical Lead for the implementation of a Business Intelligence Institutional and Benchmarking Dashboard reporting system
- Optimized database architecture to maximize efficiency and reduce transaction time: longitudinal data studies (higher education), pharmaceutical data and patient data.
- MicroStrategy Certified Project Designer, Certified Report Developer, Certified Document Developer, Certified Platform Administrator, Certified Engine Specialist, MicroStrategy Certified Developer, MicroStrategy Certified Engineer, MicroStrategy Certified Engineer Principal
TECHNICAL SKILLS:
- MicroStrategy 10.3
- Project Management Professional
- MicroStrategy Mobile Applications/Transactional Services
- SQL Server, Oracle, Netezza, Teradata, MS Access
- Toad, SQL*plus, PL - SQL, SQL Stored Procedures, SQL-Loader, Database Engine Tuning Advisor SQL Server
- ETL: SSIS, Informatica, and Tidal job scheduling.
- C++, Java, ASP. NET
- SQLJ, SQL, XML
- Linux, Unix, Windows, Virtual Environments, Tidal Jobs
- Data Warehouse Modeling and Design - Star and Snowflakes
- Data Interfacing/Transport/Tidal Jobs
CHRONOLOGICAL SUMMARY OF EXPERIENCE:
Confidential, Mclean, VA
Technical Lead/Project Manager
Responsibilities:
- Technical Lead on the development of a web dashboard with highly complex metrics on the enforcement department of the Confidential .
- Provide technical oversight on the implementation of functional requirements, providing guidance as for MicroStrategy best practices.
- Provide inputs for project management activities, managing daily risks, tasks and communications.
Confidential, Dallas, TX
MicroStrategy Project Manager/Technical Lead
Responsibilities:
- Managed a couple of teams of MicroStrategy resources which support the development of web and mobile dashboards and reports for the Commercial and Finance departments
- Managed the development of a multi-tenant reporting platform to provide analytics on key performance indicators on the insurance industry across several countries providing key performance indicators for Insurers, Manufacturers and Repairer Shops
- Project Management activities and technical lead role on the development of two mobile applications for the finance department. Managed daily technical calls, resources, tasks, risks and communications.
Confidential, Bethesda, MD
MicroStrategy Technical Lead
Responsibilities:
- Designed and developed a mobile survey application to gather patient’s information and based on patients’ survey responses provide medical and psychological resources to patients
- Led the development team on the implementation of web/mobile reporting application, including installation of software and specs recommendations for servers (mobile, web and intelligence server)
- Provided technical guidance on the design and implementation of a mobile survey application to gather patient’s insights and provide medical, psychological and educational resources based on their responses
Confidential, Radnor, PA
MicroStrategy Project Manager/Technical Lead
Responsibilities:
- Gathered requirements, designed and developed 100+ mobile/web dashboards for external and internal wholesalers
- Led development and provided technical oversight on the Territory Visualizer - an industry-leading mobile app - designed to provide wholesalers with immediate access to firm-level details, market share data and individual advisor activities. The Territory Visualizer also offers data aggregation and mapping features which gives Lincoln’s wholesalers a competitive edge by giving them an immediate, comprehensive view of their territories - pooling current sales data, produces profiles and key metrics all into one simple-to-use application. Lincoln Wholesalers spend less time studying data and spend more time supporting advisors.
- Designed and developed 30+ cubes which run on a daily basis in a timely manner
- Implemented a complex security model to allow for different levels of access (managers vs. wholesalers) and benchmarking; being able to compare user’s performance metrics versus team’s performance metrics. Users having access only to their business groups.
- Managed a team of Global Delivery Consultants.
Confidential, Chantilly, VA
MicroStrategy Technical Lead
Responsibilities:
- Designed and developed the brand new SoundBite MicroStrategy reporting platform to provide analytics on multi-channel campaigns, data being accessed through a custom portal.
- Architected MicroStrategy Logical Model based on business data mart. Created Schema Objects (Attributes and Facts), Metrics, Filters, Prompts.
- Gathered requirements, Mocked, Designed and Developed Dashboards and Reports
- Designed security to support OEM model on a custom portal
Confidential, Mclean, VA
MicroStrategy Senior Consultant
Responsibilities:
- Developed a Customer Business Profile newsletter (PDF Delivery report), leveraging existing MicroStrategy schema objects and metrics to automate a report which is distributed to hundreds of customers (sellers), using state of the art MicroStrategy visualizations for best display of loan and credit performance data.
- Consolidated dozens of MicroStrategy reports to a single PDF report; utilizing best practices for document development and consolidating data sets with complex metrics for Confidential customers and geographical peer groups.
Confidential, Mclean, VA
MicroStrategy Senior Consultant
Responsibilities:
- Helped retain the account by redesigning the overall look and feel of the Ad-hoc dashboard and making it user friendly, incorporating state of the art MSTR graphs and visualizations. Implemented consistent use of corporate Confidential color and design standards and guidelines.
- Improved the Confidential Ad-Hoc dashboard performance to a sub-30 second response time regardless of prompts selected. This was done by tuning all MSTR datasets: Reviewing all MSTR objects (attributes and metrics) and redesigned using best practices.
- Successfully improved performance of web based MicroStrategy Dashboard by fine tuning SQL Server 2008 database: Analyzing SQL queries, advising and creating SQL Server indexes, reviewing MSTR architecture and fine tuning MicroStrategy VLDB settings
Confidential, Mclean, VA
MicroStrategy Project Manager/Technical Lead
Responsibilities:
- Contributed to technical account management and communications as well as customer satisfaction and implementation success. Responsible for timely deliverables and overall satisfaction of the customer on the successful implementation of Mobile Applications integrating complex Pharmaceutical data sets: Commercial Analytics, Sales Ops and Aggregate Spend. Participated in the full project life cycle taking ideas from concept through full deployment of Mobile Applications: Strategic Growth Initiatives, VP USA
- Oversaw the implementation of best practices as for MicroStrategy technology and architecture. Managed complex implementation, integration, enhancement projects
- Built a cost effective and manageable Informatica ETL system to bring data from CSV files to a Netezza data mart. Designed and developed the Netezza Data mart and MicroStrategy Mobile Application
- Led the requirement gathering phase and development of the Mobile VP USA project, efficiently translating complex data requirements to business and capturing data elements into a data mart. Designed and developed data mart model and physical data mart in MS SQL 2008 and implemented a transactional services application for users to interact using a MicroStrategy mobile application.
- Provided technical oversight of a GDC team, leading daily technical calls and reviewing and assigning technical tasks.
- Led the requirements gathering phase and provided technical advice on the Data mart design and development of all projects
- Led the development of the web based aggregate spend dashboard. Re-designed the Aggregate Spend Data Mart in Netezza to capture changes made on the ETL process and incorporated those changes to the MSTR semantic layer (attributes and metrics). Managed dashboard migrations among different environments (development/test/production) and conducted meetings and presentations with stakeholders.
- Demonstrated the ability to efficiently produce mobile dashboards and data solutions - ad hoc reports - by producing customized mobile dashboards, web based ad hoc reports and graphics for the Commercial Analytics project.
- Administered MicroStrategy environment serving 700 mobile users. Administered web server, mobile server, and intelligence server. Managed migrations, user accounts and groups (including security).
Confidential, Mclean, VA
MicroStrategy Consultant/Architect
Responsibilities:
- Managed the design, development and implementation of a custom dashboard to measure - ranking and trend - metrics on the use of social applications using state of the art visualizations such as time series sliders, data clouds, fish eye selectors and interactive bubble graphs
- Demonstrated the ability to produce dashboard and data solutions efficiently by producing customized graphs and widgets which display data in an accurate, an insightful, and an user friendly manner by making use of MicroStrategy derived metrics features such as rankings and moving averages and MicroStrategy view filters
- Demonstrated the ability to translate customer requirements into dashboard solutions from scratch
- Worked with client personnel to establish design specifications and task priorities for customizations and enhancements of existing dashboards
- Presented a prototype application to demonstrate dashboard capabilities to stakeholders
- Designed, developed and implemented custom reports which allow users to access and report on data via different means such as web interactive reports and custom PDF files