Sofi
Send Job descriptions to
sofimastr676@[Link]
SUMMARY
7 Years of total IT experience with over 6 Years experience in MicroStrategy 9/ 9.2/ 9.2.1/8.x,
MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy
OLAP, MicroStrategy Architect, and MicroStrategy Narrowcast Server.
Familiar with Configuration Wizard, Database Warehouse Instance, Open Database Connectivity,
and Project Creation Wizard
Good working knowledge of Data Marts and modeling techniques such as Star Schema and
Snowflake Schema.
Proficient in creating and integrating MicroStrategy reports and objects (Attributes, Views, Alias
table, Filters, Metrics, Facts, Prompts, Templates, Transformations, Custom Groups and
Consolidations etc.).
Developed Scorecards and Dashboards using Selectors, Widgets &Panel Stacks
Worked on MicroStrategy with large databases like Vertica, Teradata, Oracle, DB2 and SQL
Server.
A team player and quick learner with capability to efficiently plan and prioritize projects with strong
technical and business management skills.
SKILLS SUMMARY
____________________________________________________________________________
Reporting Tools
MicroStrategy Desktop, Architect, Web, Intelligence Server, Command Manager,
Object Manager, Narrowcast Server (8.0 to 9.2.1) and MicroStrategy Distribution Services, Tomcat
Databases
Vertica, Oracle, DB2 and SQL Server
Languages
SQL, Delphi
Operating Systems Windows family, UNIX
Office Tools MS Office
Miscellaneous
MS Project, MS Visio, Macromedia Director MX, HTML, Microsoft Front Page,
Dreamweaver
EDUCATION
____________________________________________________________________________
Bachelors of Business (Information Technology), Auckland University of Technology, NZ
WORK EXPERIENCES:
Client
:
Duration:
Role:
Visa Inc., CA
July 2013 to Oct 2014
Senior Software Engineer (Microstrategy)
Visa is a global premier payments technology company that makes it possible for the convenient and
secure payment by enabling ahead payment with a prepaid card, pay as you go with a debit card or later
payment with a credit. With one of the most advanced payment processing network, Visa offers
consumers, businesses and financial institutions convenience, security and ease, virtually anywhere in
the world, at any time.
Responsibilities:
Meet with Business users to obtain the business requirements for creating reports.
Liaise with the data team to understand the data and to identify the fields that needs to be
extracted.
Create Attributes, Views and Alias Tables and map them as required.
Create complex reports, documents and dashboards using Consolidation, Custom Groups,
Attributes, Hierarchies, Filters, Metrics, Compound Metrics, Drill Maps, Filters and Freeform SQL
if required.
Optimize the performance of the reports using the VLDB properties in MicroStrategy and by
collaborating with Database team.
Work together with the Database Team on creating Aggregate tables for better performance and
flexibility as per business requirement.
Coordinate with business, data modeling, QA, Admin and ETL team at various levels for
stabilization and accuracy of reports.
Co-ordinate with off-shore development team, delegating tasks and providing directions for fast
deliverables.
Environment: MicroStrategy 9.02, 9.3 (Desktop, Administrator, Architect, Command Manager,
Narrowcast, WEB, Oracle, Windows 7, Jira, Confluence).
Client
:
Duration:
Role:
Millennial Media, MD
Feb2013 to June 2013
BI Developer (MicroStrategy)
Millennial Media is an independent mobile advertising platform company. The companys technology,
tools and services help app developers and mobile website publishers maximize their advertising
revenue, acquire users for their apps and gain insight about their users, and the company works with
advertisers to deliver ad experiences to consumers on their mobile connected devices.
Apart from US, the company has its presence in Europe and South East Asia. Millennial Medias
customers include 23 of the top 25 Ad Age brands, and their developer base includes large mobile
publishers, such as CBS Interactive and The New York Times Co. (NYT), and large app developers, such
as Zynga Inc. (ZNGA) and Rovio.
Responsibilities:
Meet with Business users to obtain the business requirements for creating new reports and use
sql from SQL server reports to create identical reports and dashboards in Microstrategy.
Create Attributes, Views and Alias Tables and map them as required.
Create Consolidation, Custom Groups, Attributes, Hierarchies, Filters, Metrics, Compound
Metrics and Filters for complex reports, documents and dashboards.
Create and troubleshoot MicroStrategy prompt, filter, template, consolidation, and custom group
objects.
Optimize the performance of the reports using the VLDB properties in MicroStrategy and by
collaborating with Database team.
Work together with the Vertica Data Team on adding new table columns and tables in Database
for better performance and flexibility as per business requirement.
Migrate objects using Object Manager and carry out post migration validation.
Coordinate with business, data modeling and ETL team at various levels for stabilization of
reports.
Work with existing Developers, Database team, Data team and users to ensure completeness
and accuracy of reports data.
Environment: MicroStrategy 9.3 (Desktop, Administrator, Architect, DB Query, Object Manager,
WEB), Vertica, MySQL, Jasper, Windows 7, Confluence).
Client
:
Duration:
Role:
Staples Inc., CO
Jan 12 to Dec 12
BI Developer (MicroStrategy)
As the worlds largest office products company, Staples Inc. has a presence in more than 26 countries.
The success of this company lies in its multiple sales approaches such as retail, catalog, and online
sales. Staples enhance corporate performance, efficiency and productivity by deploying MicroStrategy
interactive grids and dashboards for performance of Store, Sales Representative, and Daily Product.
Using MicroStrategy tools, Staples instantly accesses multi-channel sales information to understand and
respond to rapidly changing market trends and enhance decision making and at the same time strengthen
customer relationships.
Responsibilities:
Participate in the end user meetings to obtain the business requirements for creating reports.
Assist DBAs in creating views and making changes in the Database as required for the
MicroStrategy Environment.
Work on MicroStrategy Reports by creating Custom Groups, Attributes, Hierarchies, Filters,
Metrics, Compound Metrics and Filters for complex reports.
Work with Business end users and conduct regular demos for report functionality in MSTR Web.
Develop Report Service Documents and dynamic dashboards using new data sets and widgets.
Optimize the performance of the reports using the VLDB properties in MicroStrategy.
Coordinate with business, data modeling and ETL team at various levels for stabilization of
reports.
Work with QA, testers and business users to ensure completeness and accuracy of reports data.
Environment: MicroStrategy 9.1/9.2.1/9.3 (Desktop, Object Manager, WEB, Enterprise Manager),
Oracle, DB2, MS Visio, Windows 7.
Client
:
Duration:
Role:
AstraZeneca Pharmaceuticals, Wilmington, DE
Sept10 Nov 11
Report Developer (MicroStrategy)
AstraZeneca Pharmaceuticals is a global, innovation-driven, integrated biopharmaceutical that operates
in over100 countries with employees number exceeding 57,000. The company discover, develop,
manufacture and market prescription medicines for serious illnesses such as cancer, cardiovascular,
gastrointestinal, infection, neuroscience, and respiratory and inflammation.
Responsibilities:
Designed, developed, and implemented MicroStrategy Reports, Public Objects, Schema
Objects, and Intelligence Cubes.
Designed Enterprise reports, Dashboard reports and Ad-hoc reports as per users need.
Used Narrowcast server and Distribution services to deliver reports and alerts and notification
to executives and managers.
Created dashboards in DHTML and Flash mode highlighting Key Performance Indicators
(KPIs) as per business requirements and trained end-users to navigate them.
Applied thresholds, drilling, and dynamic dates options to understand and analyse business
trends.
Managed privileges and access of users of various groups using MicroStrategy Administrator
when required.
Environment: MicroStrategy9.0.3/9.1, Architect, Desktop, Narrowcast Server, Object Manager,
Oracle, HTML
Client
:
Duration:
Role:
Apria Healthcare, CA
Jun 08 Jul10
Junior Report Developer
Apria Healthcare is the largest provider of home healthcare products and services in the United States,
offering a comprehensive range of home therapy and medical equipment services to over 2 million
patients at 550 locations in all 50 states annually.
Responsibilities:
Carried out the designing, developing, testing and implementation of MicroStrategy Public
Objects, Reports, Dashboards and documents.
Assisted in administering and managing the intelligent server to setup the security roles,
managing the caches etc.
Environment: MicroStrategy 8.1/9.0 (Administrator, Architect, Desktop), DB2, SQL server, MS Visio
Client
:
Duration:
Role:
First National Bank, Omaha
May 06 Apr 07
Technical Analyst
First National of Nebraska is the largest privately owned bank in the United States, with primary banking
operations in Nebraska, Colorado, Illinois, Iowa, Kansas, South Dakota and Texas. With more than 4,200
employees, First National Bank and its affiliates have $17 billion in managed assets.
Responsibilities:
Provide support for report generation and distribution process including analyzing and developing
business requirements for reports.
Data mining to identify trends/findings that produce actionable recommendations to the
management team.
Process all client mailings including gathering contact information into a central database and
cleansing the data.
Work together with our website provider and support users with related technical issues.
Support portfolio assistants, managers and others in their day to day technical and operational
issues with Advent, Microsoft Windows and Office and other software.
Environment: Advent Suite, Windows XP, SQL server.