SUMMARY:

• Over 20 years in IT and Financial Industry concentrating on business data warehousing, data modeling, design and development, with focus on implementing business intelligence (Expert in MicroStrategy and Crystal Reports).
• Successfully performed requirements gathering, business analysis, creating specifications for software design and development.
• Always shared knowledge with colleagues and advised best practices as a subject matter expert.
• Reliable team player with proven problem solving skills and ability to work independently on the most complicated parts of the projects.
• Quick self - starter and learner with proven ability to master deliverables as required by the project tasks in a short period of time.
• Communicate effectively with all levels in the organization.
• Demonstrate consistent ownership and commitment.

TECHNICAL SKILLS:

BI: MicroStrategy, Crystal Reports, Tableau

DATABASES: Sybase, MS SQL Server

LANGUAGES: SQL, Transact-SQL, Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

BI Architect

• Mitigate risk factors through the careful analysis of the existing application to improve the application performance and efficiency, while making upgrades transparent to the end user.
• Simplify maintenance by replacing hardcoded values with dynamic solutions, eliminating redundant schema objects, and normalizing the database structure.
• Improve usability by reducing the number of dashboards from 53 to 15 that significantly improved the performance of the application.
• Automated and improved process for handling requests from business partners by using the transaction services web interface.

Confidential, New York, NY

Principal Software Engineer

• Worked closely with the business users to understand the requirements, evaluated and reviewed business rules and suggested the appropriate BI solutions. Initiated communication between different cross functional teams existing in the business as a means to define Business measures that were modeled in the MicroStrategy schema.
• Served as a primary MicroStrategy developer/architect for the full lifecycle of the data warehousing project from requirement gathering from the business users to testing and deployment to production in a timely manner.
• Reviewed system capabilities with a focus on enhancing existing processes and implementing new ones the most efficient way. Coordinated evaluation testing and change management processes end-to-end while using solid project management skills documenting requirements, establishing scope and objectives and determining strategy for implementing systems that achieve business goals.
• As a team lead was responsible for planning, documenting, implementing, and testing the upgrade from MicroStrategy version 9.2 to 10.4 including connectivity to the multiple data sources, metadata upgrade.
• Performed administrative tasks that involved MicroStrategy and Tableau installation, configuration, I-Server administration and installation using Configuration Wizard, memory settings, performance monitoring and VLDB settings, users’ setup, granting security roles, ODBC settings, server clustering, object management, cache management, creating metadata repository, etc.
• Supported business users in identifying and troubleshooting Tableau issues, crating and publishing workbooks, configuring and installing Tableau and performed all of the related administration tasks.
• Successfully worked on MicroStrategy reports tuning, customization, troubleshooting, and optimization that reduced the execution time by 90% on average.
• Worked on existing projects to identify missing relationships and optimizing data model for faster performance by suggesting proper indexing and normalizing data.
• Installed, configured and supported Narrowcast Server. Created services, schedules and dynamic subscription sets for the event driven report distribution to the external clients.
• Built MicroStrategy public and schema objects like complex metrics, prompts, filters, freeform SQL reports, custom groups, logical views, attributes, facts, etc.
• Extensively used Object Manager to move the objects between development and production environments.

Confidential, Warren, NJ

Senior MicroStrategy Developer

• Managed projects through entire system development cycle. At the POC stage of the project, created and delivered multiple presentations to the business users.
• As a MicroStrategy analyst, performed business requirements gathering and analysis. Created technical and functional specifications, including design of the complex reports and dynamic dashboard documents with multiple panel stacks, selectors and customized widgets.

Confidential, New York, NY

Senior MicroStrategy Developer / Administrator

• PIER - Maintained and supported legacy PowerBuilder application. Managed PIER system conversion from PowerBuilder to MicroStrategy through the entire system development life cycle. Made a number of presentations to the business users.
• Preformed an I-Server and Narrowcast administrative and development role, created and managed load processes, reports scheduling and distribution via Narrowcast.
• UBS - Created and implemented stored procedures to automate data reconciliation, developed invoices using Crystal Reports, performed unit testing and system integration.
• MFA - Participated in dimensional data modeling and design, data management, created complex MicroStrategy reports, load processes, Perl and UNIX shell scripts for the data file processing and load scheduling.