SUMMARY

A professional Datawarehouse and Business Intelligence Specialist with extensive hands-on experience in databases: datawarehousing and business intelligence commercial applications databases oriented.

Worked primarily in the fields of Home Retail, Hospitality, Financial Services, Telecommunications Services, Oil Company applications. Consistently maintain primary focus on meeting business requirements through the delivery of quality, on-time products.

SKILLS Operating Systems

UNIX, Windows, IOS, Android.

Languages

Oracle PL/SQL, SQL Server, Unix Shell scripting, Unix Korn Shell scripting. HTML, XSL, XML. DB2 SQL scripting. Teradata SQL scripting. Teradata utlilities: mload, fload, fexport. Visual Basic. C.

Databases

Oracle, Teradata, SQL Server, DB2.

Software Tools

Microsoft SQL Server Management Studio. Oracle Designer. Oracle Navigator. Oracle PL/SQL Developer. ERWIN. Visio. Microstrategy Intelligence Server and Narrowcast Server. Appworx. MS-Access.

EXPERIENCE

Confidential

Microstrategy Architect/Developer

• Architecture in Microstrategy: creation of all objects that conform the metadata: tables, facts, metrics, attributes, transformations, prompts, custom groups, cubes, datasets. Wrote code for populating transformation tables: previous day, previous week, previous month, previous quarter, previous year, week to date, month to date, quarter to date, year to date. Dashboards: built new dashboards and modifications of already existing ones.
• Built datasets, cubes and dashboards to replace current SQL Server SSRS reports.
• Technology: Microsoft SQL Server, Microstrategy Intelligence Server 9.4.1.: Architect, Desktop, Report Services, Dashboards, OLAP, Object Manager and Command Manager.
• Darden Restaurants, Orlando, FL Fortune 500 company, NYSE: DRI, 180000 employees, Olive Garden, Longhorn, Season's 52, Bahama Breeze, The Capital Grille, Eddie V's, Yardhouse

Confidential

Senior Programmer Analyst

• Analysis, mapping, conceptual systems design, and technical analysis of reports for the datawarehouse of the company Conceptual system design, data modeling architecting the star/snowflake design of the relational multidimensional database.
• Development in Microstrategy: creation of all objects that conform the metadata: tables, facts, metrics, attributes, hierarchies of attributes defining their corresponding relationships filters, transformations, prompts, consolidations, custom groups, reports, documents, dashboards, scorecards, report drilling up and down, slicing and dicing. Star/snowflake relational multidimensional schema modeling, sorting and ranking functions within reporting/documents/graphs/charts for the different datamarts of the datawarehouse. Microstrategy technical support, and user/server administration. Intelligent cubes for better performance with aggregated levels of information. VLDB database settings.
• Microstrategy 9.4.1: Intelligence Server, Architect, Desktop, Report Services, OLAP, Object Manager, Integrity Manager, Narrowcast and Command Manager.
• Technology: Oracle 11g, Microstrategy Intelligence Server 9.4.1.

Confidential

BI Consultant

• Analysis, mapping, programming and technical analysis of ETL procedures for the datawarehouse of the company for reports for the Tax Exemption government requirement for the consolidated accounts. Informatica ETL. Development of teradata stored procedures to produce information reports for the Marketing Department: High Speed Center agent productivity to determine key performan ce indicators and agent handle time. These metrics will be used to create a productivity scorecard at the end of each month. Freeform sql reports. Dashboards.
• Development in Microstrategy: metrics, attributes, hierarquies of attributes defining their corresponding relationships filters, transformations, prompts, consolidations, custom groups, , reports, documents, dashboards, scorecards, report drilling up and down, slicing and dicing. Star/snowflake relational multidimentional schema modeling, sorting and ranking functions within reporting/documents/graphs/charts for the different datamarts of the datawarehouse. VLDB database. Microstrategy user support. Project leading.
• Microstrategy modules: Desktop, Report Services, OLAP, Object Manager, Integrity Manager, and Command Manager.
• Technology: Teradata, Microstrategy Intelligence Server 8.1.1. Narrowcast. SQL Server.
• Achievements:
• - Analyzed, mapped and maintained datawarehouse projects in the DSS tool, -Microstrategy.Teradata ETL programmed stored procedures.

Confidential

Programmer Analyst

• Analysis and programming of loading procedures of the datawarehouse databases and its corresponding datamarts. Analysis, design and construction of the metadata, administration and user support of Microstrategy Intelligence Server and Microstrategy Narrowcast Server.
• Development in Microstrategy: metrics, attributes, hierarquies of attributes defining their corresponding relationships filters, transformations, prompts, consolidations, custom groups, reports, documents, scorecards, report drilling up and down, slicing and dicing. Star/snowflake relational multidimentional schema modeling, sorting and ranking functions within reporting/documents/graphs/charts for the different datamarts of the datawarehouse. VLDB database.
• Microstrategy modules: Desktop, Report Services, OLAP, Object Manager, Integrity Manager, and Command Manager.
• Technology : Unix Sun Solaris, Oracle Database 9i, Oracle PL/SQL programming, Oracle SQL/Loader, Oracle Designer. Microstrategy Intelligence Server 8.01 and Narrowcast Server. Windows NT. Progress. Appworx tasks scheduler.
• Achievements
• - PL/SQL programmed ETL procedures.
• - Analyzed, modeled and maintained various datawarehouse projects.
• - Administration and user support of Microstrategy Intelligence Server and Narrowcast Server.
• Repsol-YPF, Buenos Aires, Argentina
• largest oil company in Argentina, like American company EXXON Mobile

Confidential

Programmer Analyst

• Data modeling, analysis and programming of the datawarehouse databases and its corresponding datamarts. Analysis, design and construction of the metadata, administration and user support of Microstrategy Intelligence Server and Microstrategy Narrowcast Server. VLDB database.
• Microstrategy modules: Desktop, Report Services, OLAP, Object Manager, Integrity Manager, and Command Manager.
• Technology : Unix Sun Solaris, Oracle Database, Oracle PL/SQL programming, Oracle SQL/Loader, Oracle Designer. Microstrategy Intelligence Server and Narrowcast Server. HTML, XML and XSL within Narrowcast Server. Windows NT. Visual Basic 6.0.
• Achievements
• - PL/SQL programmed ETL procedures.
• - Analyzed, modeled and maintained various datawarehouse projects.
• - Administration and user support of Microstrategy Intelligence Server and Narrowcast Server.
• - HTML, XML and XSL programmed within Narrowcast Server.