Lead Microstrategy Architect And Developer Resume
Long Island, NY
SUMMARY:
- I am a dedicated technology leader in Business Intelligence and data visualization. I have delivered numerous successful large - scale BI and Data visualization projects which also included leading engagement teams with offshore developers and working with software vendors.
- I have over 15 years of diverse experience and numerous full life-cycle implementations.
- Developed Enterprise reporting system for generating over 60,000 daily internal and external customer reports, which documented over 240 million dollars of money movement per day in a multi-node, multi-volume cluster environment.
- I have expert level knowledge and experience with several Business Intelligence tools like: MicroStrategy, Tableau, QlikView and, Actuate with 10 + years of consulting experience with interest in business process and operational efficiency improvement, and adding value by introducing simple, actionable/measureable, and potent solutions.
- My experience includes managing, delivering, evaluating, implementing, and supporting business critical applications across health care, manufacturing, retail, higher education, financial services, telecom and energy industries.
- I am highly analytical with “big picture” vision and possess the ability to work with key decision makers to convert complex requirements into actionable project plans.
- I have created significant value for the business by implementing and managing enterprise class systems with focus on Enterprise Data Warehouse, Business Intelligence and Reporting, Data Architecture and Integration. I am experienced in technical architecture of BI delivery platforms including ETL strategy, BI Delivery Strategy, repository design—ODS, data warehouse, data mart, changed data capture (CDC), date transformation, data and metadata internationalization, multiple currency solutions, versioning and slowly changing dimensions (SCD). I am well versed in both relational and multidimensional architecture.
- BI Reporting Solutions
- Mobile Intelligence
- Cubes Design and Implementation
- Dynamic Visualization Dashboards
- Visual Analytics
- BI Server Configuration and Administration
- BI Architecture and Solution Design
- BI Strategy and Roadmap
- Logical and Physical Data Modeling
- Application Development
- Project Management,
- Enterprise Data Warehouse Design
- Data Integration and Migration
- Data Governance and Master Data Management
- Retail Store Operations analytics and reporting,
- Business Continuity and Disaster Recovery Planning,
- Data Warehousing, Data Modeling, Data Architecture
- Forecasting and Planning Applications
- Team management/leadership
- Strategy, Planning & Development
- Process Modeling & Data Flow
- Lead multi site/off-shore, large scale projects
- Manufacturing
- Healthcare
- Energy
- Retail
- Higher - Ed
- Financial Services
- Telecommunications
- Plant Operations and Management
- Merchandise Planning
- Retail Data Warehousing
- Store Operations
- Real-time Higher-Ed BI
TECHNICAL SKILLS:
Microstrategy 7, 8 & 9
Tableau 7 & 8
QlickView
Actuate 7, 8 & 9
Crysta
JSP PeopleSoft
Eclipse
WebLogic
IIS,Tomcat/ Apache
WebSphere
Oracle
DB2 UDB and Z/OS
Teradata
PL/SQL
SQL Server
SPSS
Erwin
Unix (AIX/HP-UX/Sun-Solaris)
Red Hat 5.4/5.5 Linux
Windows Server 2003, 2008 R2
AS400
JAVA
Visio
Microsoft Project
XML
EXPERIENCE:
Confidential, Long Island, NY
Lead MicroStrategy Architect and DeveloperResponsibilities:
- Developed plan and strategy to upgrade from Tableau version 7 to Tableau version 8
- Upgrade Tableau server 7 to version 8
- Implement a clustered environment
- Configure Tableau server 8 and conduct a brief seminar on the new features on Tableau 8
Confidential, Jersey City, NJ
Senior Business Intelligence (BI) Implementation Advisor
Responsibilities:
- Assist in outlining short falls in moving the reporting data warehouse from Oracle to Netezza;
- Help in the installations of new MicroStrategy environments;
- Participate and make recommendations on new project designs and data modeling designs;
- Assist with analyzing new report requirements
Confidential, NJ
Technical Lead -Tableau
Responsibilities:
- Work with business to gather requirements
- Installed and configured Tableau servers
- Architect data model as per requirements and data integration and migration
- Developed Interactive visualization dashboards and reports
Confidential, Jersey City, NJ
Senior BI Architect and Developer
Responsibilities:
- Illustrate the capacity to convert complex Actuate customized reports and provide existing Actuate functionalities in MicroStrategy;
- Demonstrate how Confidential Actuate Single Sign-On security would be implemented in MicroStrategy;
- Show how MicroStrategy reports would be integrated into Confidential existing web portal
- Design and develop a Logical Model, Schema model and a physical model to showcase the conversion of three groups of Actuate reports rated as, Difficult, Moderate and, Easy;
- Generate document that outline project development timeline and required resources.
Confidential, Horsham, PA
Lead MicroStrategy Architect and Developer
Responsibilities:
- Analyze the Actuate report design and review Actuate source codes;
- Rate the Actuate reports conversion difficulty level;
- Designed plan to convert the Actuate Enterprise reporting platform to MicroStrategy;
- Work closely with business to capture additional requirements and on MicroStrategy additional functions on Desktop, Web, and Mobile
- Implement performance analysis tool and configure server properties to enhance reports performance
- Work closely with Data warehouse team and team to assure required data source are available
- Installed and configured MicroStrategy iServer, Mobile, and Web Server
- Lead effort in creating new Logical and Schema models
- Designed new Logical data Model
- Create MicroStrategy Project
- Convert Actuate report to MSTR Grid reports, Documents and, interactive Dashboards
- Trained junior developers at Confidential on intelligence Cube development and deployments
Confidential, Chadds Ford, PA
Lead MicroStrategy Architect and Developer
Responsibilities:
- Lead MicroStrategy Version 9.01 installation and configuration and creating new projects, reports, and dashboard using MicroStrategy Desktop, Web and Mobile
- Installed and configured MicroStrategy iServer in Development and Production
- Deployed and configured MicroStrategy Web Server
- Implement and configured MicroStrategy Mobile
- Lead effort in designing new logical data Model
- Direct effort in designing new Physical Schema
- Supervises MicroStrategy Developers and implement Best Practice rules that assure maximum performance
- Create and Design Intelligence Cube to support reporting requirements
- Created new project, reports
- Performed object migration
- Configured LDAP in MicroStrategy iServer
- Configured MicroStrategy Distribution Services
Confidential, Melville, NY
Lead MicroStrategy System Administrator and Developer
Responsibilities:
- Work on performance tuning
- Made configuration adjustments in MicroStrategy Web and MicroStrategy iServer
- Assist on implementing report and object level security
- Implement clustered environments
- Troubleshoot report, iServer, and web server problems
- Implement MicroStrategy knowledge transfer with junior developers
- Create new reports and Dashboards
Confidential, Phoenix, AZ
Lead MicroStrategy Architect and Developer
Responsibilities:
- Install and configure MicroStrategy iServer, NarrowCast, server, Mobile, and Web Server
- Work closely with business in gathering requirements
- Develop logical and schema models
- Create MicroStrategy project
- Design MicroStrategy Reports, Documents and Interactive Visual Dashboards
- Deploy MicroStrategy Mobile
Confidential, Freeport, NY
Lead MicroStrategy Developer, Actuate Developer
Responsibilities:
- Create dynamic Flash Dashboard using visualize interaction flash widgets
- Install and configure MicroStrategy version 9 iServer, Desktop and, Web components
- Install and implement Actuate iServer, Report Server Security Extension (RSSE), Active Portal, and Actuate Library
- Develop and implement complex Actuate reports using Actuate version 9
- Maintain and support Actuate production environment
- Implement dynamic report scheduling and content delivery using Actuate 9 server API
Confidential, White Plains, NY
Senior Architect/Senior Business Intelligence Developer
Responsibilities:
- Performed version upgrade from MicroStrategy 8 to 9;
- Implement Single Sign-on and application integration;
- Portal design and implementation (SDK);
- Employ content security and content delivery system.
- Installed and Configured MicroStrategy version 9
- Convert Actuate 9 reports to MicroStrategy reports, documents and Dashboards
- Installed, configured Actuate 9 iServer in Unix, Actuate Active Portal
- Develop Dynamic job scheduling and report delivering system using Server Integration API solutions in Actuate 9
- Develop project plan for Datacenter move for BI solutions, Actuate 9 and MicroStrategy 9
- Maintain and support Actuate and MicroStrategy Production
- Develop and implement QA testing for Actuate 9 reports.
- Implement single sign-on solution for Actuate 8 and 9 Active Portal
- Maintain MicroStrategy 8 Narrowcast content delivery system
- Create and configure MicroStrategy portals using Java, JSP, XML
- Designing global reporting solutions in MicroStrategy 9
- Hands-on implementation of Datacenter moves of Apps and Web servers for my Department.
Confidential, Wilton, Connecticut
Senior Architect/Software Application Engineer
Responsibilities:
- Functioned as the lead architect and senior developer for upgrading MicroStrategy 7 to version 8 and developing a global web-base reporting enterprise application using MicroStrategy iServer, Narrowcast, MicroStrategy iPortal and API, and Oracle 10g database
- Developed plan and strategy to upgrade from MicroStrategy 7 SP2 to 8 SP1
- Upgrade MicroStrategy 7 SP2 reports to 8 SP1
- Upgrade two highly customized MicroStrategy Portals
- Designed architecture for reporting application infrastructure and reports’ framework design
- Installed, configured, and implemented MicroStrategy iServer, iPortal, Narrowcast.
- Designed and developed a report templates that generates over 400 reports
- Developed highly customized MicroStrategy Portal to seamlessly integrate with an existing enterprise online web application
- Designed and developed MicroStrategy API interface using SOAP API in Java to perform various report server functionalities
- Analyzed the end-user requirement for the reports and translate that into MicroStrategy report templates, layouts, components and features like hyperlink, non-demand report generation, dynamic reporting, and export data to Excel / PDF
- Designed templates / MicroStrategy components to effectively utilize the power of MicroStrategy in developing complex reports
- I configuration/resources to get the best performance for the end users and the report application.
Confidential, New York, NY
Senior Architect and MicroStrategy Developer
Responsibilities:
- Developing an enterprise web base reporting application using MicroStrategy Desktop
- Installed and configured MicroStrategy iServer in Unix;
- Customized and developed MicroStrategy Portal and Narrowcast content delivery;
- Assigned dynamic security at run-time at object and user level as required by requirements;
- Integrate MicroStrategy reporting application with an existing J2EE application.
Confidential, NY
Senior Architect and Developer
Responsibilities:
- Developed and maintained data warehouse using Oracle database;
- Implemented enterprise reporting application using MicroStrategy BI reporting platform;
- Designed, developed and integrated Web Interface application using JSP (Java);
- Customized Dynamic report delivering system;
- Developed personalized user interface
Confidential, New York, NY
Senior Associate and MicroStrategy Developer
Responsibilities:
- Managed offshore MicroStrategy developers and developed standard look and feel for all reports by developing global templates and re-usable components to also lessen development time;
- Installed, configured, MicroStrategy iServer, Narrowcast and MicroStrategy Desktop version 7 and provided dynamic and scheduled batch processes;
- Developed database connection property files which enable any report at run time to run against any environment (production, development or QA) and to point, at run time, to any database (Oracle, Sybase, MSSQL Server and AS400) without the need to recompile or change any of the report source code. Wrote SQL code (PL/SQL, T-SQL) and stored procedures;
- Using SOAP API, created Java classes to connect to the MicroStrategy iServer and execute scheduled reports;
- Customized Narrowcast to disseminate Email attached with MicroStrategy reports to users
- Manufacturing
- Healthcare
- Energy
- Retail
- Higher - Ed
- Financial Services
- Telecommunications
- Plant Operations and Management
- Merchandise Planning
- Retail Data Warehousing
- Store Operations
- Real-time Higher-Ed BI
TECHNICAL SKILLS:
- Microstrategy 7, 8 & 9
- Tableau 7 & 8
- QlickView
- Actuate 7, 8 & 9
- Crysta
- JSP PeopleSoft
- Eclipse
- WebLogic
- IIS,Tomcat/ Apache
- WebSphere
- Oracle
- DB2 UDB and Z/OS
- Teradata
- PL/SQL
- SQL Server
- SPSS
- Erwin
- Unix (AIX/HP-UX/Sun-Solaris)
- Red Hat 5.4/5.5 Linux
- Windows Server 2003, 2008 R2
- AS400
- JAVA
- Visio
- Microsoft Project
- XML