Microstrategy Consultant Resume
Weehawken, NJ
SUMMARY
- Experienced in Knowledge Discovery and Predictive modeling using large sets of Structured and Unstructured data.
- Created Data visualization using MicroStrategy enabling Supply Chain and Manufacturing process improvements.
- Experienced in DW concepts, multi - dimensional data models and ETL process.
- Experience across Manufacturing, Sales & Marketing, Finance and Industry Domains.
- Strategic thinker, problem-solver with effective leadership, analytical and communication skills; ability to learn and adapt.
- Experience in Leading teams with demonstrable improvements in loyalty, dedication and productivity improvements.
- Track record of creating increased Customer Satisfaction over the years.
- Over 20 years of Varied IT experience.
TECHNICAL SKILLS
BI: MicroStrategy 9.4.1/10.2/10.3
DW: Talend, Informatica
Databases: Oracle 11g, Teradata, Sybase
Big Data: Hadoop, Pig, Scala. Spark, Python, R, Azure Data Lake Analytics
ERP/In-Memory DB: SAP HANA Admin
Automation: TWS 8.6, Autosys 4.5.1
Models & Frameworks: Agile/Lean/ITIL v3 (Maximo)/DevOps/Jenkins
PROFESSIONAL EXPERIENCE:
MicroStrategy Consultant
Confidential , Weehawken, NJ
Responsibilities:
- Conversion of a full range of Legacy Operational and Regulatory reports using MicroStrategy 10.3.
- Multi-layered access security model, user groups, privileges roles and permissions.
- Event Based subscription schedules to correspond to the Data Warehouse loads.
- Package creation and deployment using Object Manager to support continuous BI development and integration.
- Intelligence Server configuration, Project Configuration, Web Configuration, DB configuration
- Automation using Command Manager scripts in Linux using Autosys Scheduling.
BI Architect consultant
Confidential , Greenville, SC
Responsibilities:
- Installation, configuration and administration of MicroStrategy 9.4 on 4-tier Linux Platform for various Confidential Plant Applications across North America.
- Performed Upgrade from 9.4 to 10.2 on all Confidential North American Sites.
- Installed MicroStrategy, Created Metadata Repository, performed Intelligence Server configuration, Project configuration, Web Server configuration.
- Dimensional Modelling using Star Schema/Snowflake Schema .
- Experienced in creation of MicroStrategy Schema objects (Facts,Attributes,Hierarchies,Transformations) and various Report objects (Metrics, Filters, Prompts) .
- Design & Development of Intelligent Cubes, reports, dashboards to support the Tire Manufacturing Quality data needs .
- Supported Confidential 's recent push towards Big Data Analytics.
- Collaborate with DBA teams in performance tuning and SQL optimization.
- Complete TWS management on FTAs (Fault Tolerant Agents); Installation, Configuration and management of Batch Automation of ETL processes, Cubes and Caches Refresh jobs.
- Architectural Consulting with Confidential on upcoming Industry projects.
Sr Infrastructure Consultant
Confidential, Basking Ridge, NJ
Responsibilities:
- Assisted in level 3 support with Job scheduling, issues of Autosys Administration; Batch Interfaces hold/release strategies during SAP downtime phase.
- Assisted in Conversion of Complex Batch Interfaces - Effort ranging from total migration from antiquated HP UX to Linux Platform, to using Symbolic links on NFS mounted File Systems.
- Assisted in end-to-end testing and ECC 6.0 certification of the Interfaces.
- Laid the ground work for future enhancements.
Team Lead/Account Focal
Confidential, Houston, TX
Responsibilities:
- Performed SAP Kernel upgrades and apply Support Packs as per SAP recommendations.
- SAP system copy from production to QA, Sandbox.
- Applied BSI TUB Tax Updates.
- Gathered oracle database size monthly growth data.
- Applied OSS notes as per maintenance schedule and client requirements.
- Part of 24/7 On call rotation Independently resolved SAP and Oracle DB issues based on severity level.
- Participated in Change review meetings and created Change records for SAP implementation
Team Lead/Account Focal
Confidential, Basking Ridge, NJ
Responsibilities:
- Implemented Best practices and Drove process improvements.
- Achieved cost reduction by Driving Automation using TIGER team.
- Met all SLA/SLO requirements by adhering to Team Policies and Procedures.
- Demonstrated consistent Customer Satisfaction Improvements every year.
- Engaged in Client Meetings for new Engagements as well as continuing Operations.
- Surpassed project deadlines by demonstrating flexibility and dedication.
- Successfully Lead the Transition from single-team US operation to 3-team Global Operation.
Tech Lead
Confidential, Berkeley Heights, NJ
Responsibilities:
- Complete Understanding of the Corporate Sales Compensation Plan and Business Rules.
- Extensive Unix Shell scripting, Oracle PL/SQL scripting, Unit Testing, Integration Testing, Performance Tuning and Production Support.
ETL/Data Migration/Data Warehouse
ConfidentialResponsibilities:
- Complete Understanding of the Corporate Human Resources database.
- Extensive use of Unix Shell Scripts and Teradata FastLoad/MultiLoad/BTEQ
- Unit Testing, Integration Testing, Performance Tuning and Production Support
Lead Developer
Confidential, Berkeley Heights, NJ
Responsibilities:
- Understanding of Corporate Financial Concepts
- Used MERCATOR tool to map source data (SAP) to target data(Oracle)
- Extensive use of Oracle PL/SQL, SQL Loader, Unix Shell Scripts.
Order Management System
ConfidentialResponsibilities:
- Complete Project Planning of the Application migration effort and effective personnel management.
- Conducted peer reviews, Software Quality Assurance.
- Performance tuning & Performance metrics.
Lead Developer
Confidential, Berkeley Heights, NJ
Responsibilities:
- Designed and Developed the front-end GUI user interface for Order Processing System (OPS) using PowerBuilder Client-server platform, to help track orders from the time of Order Entry to its final fulfillment and billing to the end customer; Designed and developed Batch booking, billing, shipping, forecast processing and custom sales reports using Informix for Worldwide sales tracking project CRIMS.
Lead Developer
Confidential , Bernardsville, NJ
Responsibilities:
- Designed a Billing Tracking system for the Confidential & Confidential Information Research Center (IRC) to help track IRC researcher’s areas of expertise, services rendered to customers throughout Confidential &T, and the revenue generated for the services.
Application Developer
Confidential, Red Hill, NJ
Responsibilities:
- Involved in the development of an Automatic Provisioning System for the deployment of Enhanced Echo-Canceler circuits in the Confidential & Confidential switched voice network.
- Primarily responsible for the design and development of a user interface to completely automate the deployment and provisioning of the equipment in a 12 month period using a zero-defect process.
- Implemented queries allowing users to select the circuit orders to be worked, bundling or orders and thereby minimizing the number of queries.
- Helped integrate the use of portfolio data, market data, securities information, and partner proprietary information into a single environment through development and use of an open architecture platform.
- Broad responsibilities included providing basis for reliable, high quality data storage and management environment.
- Specifically responsible for complete Sybase database administration, developing and maintaining advanced database controls.