OBJECTIVE:

Looking for a senior position as a Software Application Architect or Data Warehouse Architect or Senior Developer that allows telecommuting .

SUMMARY:

• More than 12 year of extensive experience as a developer working on Web applications and Database Management Systems.
• Experience in the design and development of E - Commerce and Security applications.
• Experience in working in Multilanguage applications and localization/Internationalization of web applications.
• Experience in the design, development and administration of SQL Server Data Bases
• Design and development of Data warehouse solutions (Ralph Kimball method)

TECHNICAL SKILLS:

SQL 2000/2005/2008 R2/2014 server administration, Oracle, DTS, SSIS,SQL Reporting Services, SQL Analysis Services,, WhereScape RED (tool to aid in ETL developments), ANSI SQL, T-SQL, PSQL,Crystal Reports C, C++, COM,DCOM, COM+, C#,ASP.NET,ASP.NET MVC, ASP.NET WEP API,Java, Java2EE, Struts,Spring, HTML,HTML 5, XML, Javascript,Jquery,Jquery mobile,Jquery UI, Angular.js,Node.js, Hadoop, sqoop, hive, pig, zookeeper, Powershell, Unix shell scripting (bash), Coldfusion MX,xx86 Macro Assembler, Z80 and MC 8051 Assembler, CISCO routers and switches configurations, Windows networks installation troubleshooting and configuration

WORK EXPERIENCE:

Confidential, Lake Forest, IL

Responsibilities:

• Management of a group of twelve javascript/.net developers in India. Use of Agile scrum methodology and remote management using an onshore/offshore process.
• Participate on initial requirements gathering to build a new extensible and flexible multinational/multilanguage Confidential Latam logistic system intended to be used initially by five different Latin American countries.
• Participate as one the application architects of a new multinational/multilanguage Confidential Latam logistic system .Implementation platform was asp.net 4.5 using owin framework and dapper ORM on the server side and Javascript using Bootstrap, Angularjs, kendo UI, HTML 5 on the client side. The four main layers in the server side were an asp.net mvc application for presentation, a asp.net web api application serving as request token secured restful api to encapsulate domain logic, an Confidential based authentication application and a SQL server 2014 backend. In the client site MVVM pattern was used through a combination of angular and Kendo UI.
• Design and Implementation of a flexible and configurable authorization mechanism for a new multinational/multilanguage Confidential Latam logistic system. This component consisted of 254 predefined permissions to secure access to the restful web apis . The predefined permissions can be configured to create duties and roles that can then be assign to user/groups in order to secure access to each of the asp.net mvc views in a very granular and flexible way according to the needs of each country/company using the system.
• Design and implementation of a custom rendering mechanism of SSRS rdl files in order to avoid the use of the SSRS Report server service. The approach parse any SSRS rdl xml file and through reflexion extract the sql queries, run them and finally render the document/report on a web interface using the SSRS engine runtime.
• Design and implementation of a framework and web components library based on Angularjs, Kendo UI and Bootstrap to simplify development of rich client side functionality.
• Participate on design and implementation of infrastructure to encapsulate and abstract out plumbing functionality of server side for ASP.NET WEB API applications. Infrastructure targets: versioning, data access layer using dapper ORM, transaction and exception management, localization and internationalization among other cross cutting concerns
• Management of a group of six BI and SQL developers in India. Use of Agile methodologies and remote management using an onshore/offshore process
• Requirements gathering for a new Confidential Latam data warehouse to answer questions related to seven business processes covering the whole business cycle present in Confidential Latam.
• Lead dimensional design of Confidential Latam data warehouse spanning twelve data marts and twenty one conformed dimensions following top down Ralph Kimball methodology
• Lead design of ETL for Confidential Latam data warehouse based on a very granular and flexible approach using thirty five SSIS master/child packages. The two main data sources were Confidential Latam new logistic system backend and Dynamics AX.
• Lead design and implementation of presentation layer for Confidential Latam data warehouse. SSAS was the platform used. Multidimensional database consisted mainly of seven cubes and twenty one conformed dimensions.
• Implementation of a calculation dimension to simplify and give flexibility to the time based Confidential formulas hosted on the SSAS cubes
• Design and implementation using SSIS of Data migration from several legacy systems to populate a new logistic system developed for Confidential Latam

Confidential, Newton, MA

Responsibilities:

• Design and implementation of an approach to show real time progress of oozie etl workflows.
• Implementing custom mappers using java mapreduce Hadoop libraries to overcome limitations of hive joins on datasets with skewed data distributions.
• Implementation of a framework on .NET to perform custom QA tests at the end of the commerce cube processing ;commerce cube is a Microsoft analysis services cube that holds multiple measure groups and metrics to aid business partners on making informed decisions when bidding for hotels and accommodations online.
• Redesign two datamarts of the commerce Data warehouse into equivalents clean star schemas. This included redesigning centipede fact tables and highly normalized dimension tables into one dimension table tied to fact tables at the lowest grain, this way leading to a natural de normalized design to source the SSAS commerce cube. A total of 1 SSIS master packages and 12 child packages were developed based on initial set of SSIS templates which optimize too the handling of slowly changing dimension generated by the SSIS SCD Confidential .
• Creation of a utility dimension in the commerce cube to hold common generic complex and optimized time based Confidential calculations.
• Design and implementation in SSAS commerce cube of right relationships to handle chain cascading many-to many relationships in the UDM
• Design a way to handle Type II SCD in SSAS commerce cube. This included adding intermediate hidden attributes in order to maintain the many-to-one relationships in place while allowing for optional historical analysis.
• Design and implementation of new ranking measure group in the commerce cube;commerce cube is a Microsoft analysis services cube that holds multiple dimension, measure groups and metrics to aid business partners on making informed decisions when bidding for hotels and accommodations online.
• Performance tuning of the processing job for the commerce cube, processing time went down from 5 hours to 1 hour and a half as result of changing among other things: partitioning strategy of various measure groups, tuning of network access to the sql server 2008 R2 data source and several server and database level configuration settings.
• Implementation of a cache warming strategy in the commerce cube to avoid using aggregations when possible. Due to the size of the data, where the minimum measure group incremental daily data is more than 100 million per day and the fact that most of the relationships in the hierarchies are not rigid, implementing aggregations affect performance of processing ostensibly. The implementation automate the profiling of the daily most expensive end users Confidential queries which are added to a table in sql server from where one sql agent powerShell step read it and query the cube at the end of the processing job. This way the caches are warmed at the end of the cube processing
• Implementing an ETL process using SSIS to synchronize the commerce cube sql server datasource of the development and QA environments from the one in production. The implementation consisted on a set of reusable SSIS templates (following Ralph Kimball best practices) that encapsulate the necessary plumbing to get logging, transactional behavior, and inter package communications out of the box. A total of two master packages and 45 child packages were developed based on the initial set of templates.

Confidential, Des moines, IA

Responsibilities:

• Lead development of third and fourth stages of outbound tracker application. This is a web application that track scheduling, allocation and updates of outbound calls by Agents of call centers located in different parts of USA. This application was implemented originally in Java (Eclipse Framework) and was completed translated to .NET. The development of these two stages were related to the presentation layer using the jquery and jquery mobile Ajax client side frameworks, Server side development using the asp.net MVC, Localization of the application to Spanish Latin and English US and the creation of a WCF library to expose core logic to the enterprise.
• Tune the performance of the modules already translated to ASP .NET MVC for the outbound tracker application adding catching and synchronization logic for the main datasets and performance tuning of the offending SQL queries in the backend to allow high concurrency and scalability.
• Develop a WCF layer to communicate to a SSAS cube using the XMLA protocol. This cube holds key statistics used in daily operations of the call centers.
• Translation to J2EE of a ASP.NET admin web site . websphere application server was used to host the final application . The site allow administration of 80 percent of the intranet applications in house
• Implementation of an Single Sign On (SSO) design to allow seamlessly login capabilities in the J2EE admin site
• Redesign and implementation of the presentation layer of an intranet site for the claims department using ASP.NET 4.0 JQuery, JQuery UI and JQuery mobile
• Design and implementation in Microstrategy 9 and Microsoft Reporting Services of a centralized reporting solution to support Call center and Claims department operations for different lines of business
• Design ETL to process incoming data from Progressive and THI cleaning and conformed the data according to in house business rules and existing dimensions. The whole implementation was done in SSIS. The target backend was an Oracle database.
• Design additional Data Mart for and Oracle backend to gather transactions records that need to be manually mapped due to exceptions generated in the ETL. Three fact tables and two additional dimensions tables were added to the physical model of the Data Warehouse. Toad data modeler was used to do the modeling and generate the code.
• Design and Implement a Sql Analysis Services (SSAS ) cube to concentrate data from different business partners and all call centers of Confidential . The operational data source of the cube is an Oracle database. An SSIS package was developed to update the cube on a daily basis according to complex and versatile business rules
• Configure Microstrategy 9 to connect to an OLAP data source (SSAS cube) and architect projects with multisource option. Developed multiple reports, documents and dashboards in Microstrategy 9 to meet different business needs of multiples business processes.
• Develop a data mining model in SSAS to determine the optimal call back period to use in the call centers. The model was developed using the decision trees algorithm. The PMML of the model was imported in Microstrategy 9 to generated predictive metrics. An SSIS package was developed to update the model according to a predetermined period.
• Design and implementation of a progressive pruning algorithm to aid in a market basket analysis related to the coverage dimension in the Policy Transaction data mart. The ETL was developed in SSIS and SQL server 2008
• Design and implementation of a sliding window partitioning strategy in SQL server 2008 to aid in near real time reporting needs for the different claim business lines
• Use of codesmith and net.tiers templates to develop presentation and business logic for a web application.
• Develop integration of different data sources using SSIS.
• Developing partitioning strategy (rolling window) for big tables in SQL Server 2005 databases
• Troubleshooting of permission issues in SQL Server 2005 databases
• Performance tuning of SQL Server 2005 servers and databases

Confidential, Miami, FL

Responsibilities:

• Design and development of billing system to automate the settlement process of the gift card program. The application consisted of a C# ASP.NET 2.0 web application that allows operators to make dollar adjustments at the store level and automate complex business logic depending of different business processes to do the settlement at the end of the Confidential week. The integration in the back end was done using SSIS as ETL tool. Windows authentication was used throughout the entire application.
• Design and development of a web services library to allow the data access layer of the main web site of the company to access functionality hosted behind a firewall. The library was developed in C# and was updated later to use WCF when transitioning to the .NET 3.5 platform
• Design and development of a custom authentication mechanism in ASP.NET 2.O to allow a common authentication mechanism regardless of the user belonging to a windows domain or not. This module allows users not to register in the main web site of the company if they already are members of the company windows forest. The module was developed in C# using WCF to communicate with different parts of the enterprise.
• Design and development of a browser agent to extract and parse information found in an external web site. This application runs in a daily basis .It connects to one of the partners web site and download a series of HTML pages. The Information after downloaded is parsed and imported in one of the company‘s SQL Server DB. It was implemented using C# and the following namespaces from the .NET framework: System.NET and System.Text.RegularExpresions.
• Design and development of two data marts related to two of the main business processes of the company: Gift card Program and Finance. The whole full cycle of the Kimball approach was used. Toad Data Modeler was used to generate the model and a combination of SSIS and Wherescape RED was used to implement the ETL. Microstrategy 8.1 was used as BI tool. The Data Warehouse spanned a size near to 2 TB.
• Development of interface to integrate two ETL tools: SSIS and WhereScape RED. The intention behind this was to allow SSIS launch and control jobs implemented in Wherescape Red and allow both environments to share auditing information.
• Design and Implement testing framework to test all the future Data Warehouse developments. A set of SSIS templates were developed that after tailored for specific situations generate a comparison at the lowest grain between each measure and its dimensions against the corresponding dataset from the related source system.
• Design and implement partitioning of the main tables related to the gift card program back end.
• Contribute to installation, setup and design of metadata of MicroStrategy 8.1 BI solutions .Two projects were design and implemented to allow Report designers and end users write reports against two of the main data marts of the company warehouse.
• Design and Development of a SSAS cube for the gift card aging process. The cube allows business executives to see which sales channel generated more profit related to money left in the gift cards after a period of time. The cube was connected to Microstrategy 8.1 through IIS, it is partitioned by month and loaded in an incremental mode. Proactive caching is used to lower latency.
• Design and development of billing system to automate the settlement process of the gift card program.
• Maintenance and enhancement of all source systems related to the whole supply value chain of Confidential restaurants. All the source systems applications run SQL Server in their back end and .NET in the presentation, business and data access layer.
• Design and Development of several SSRS Reports to support daily decisions and operations
• Performance tuning and maintenance of clusters of SQL Servers engines to support daily operations

Languages, frameworks and technologies: C#, VB.NET, ASP.NET 2.0, .NET 3.5, SQL SERVER 2005, SSIS, SSAS, SSRS, Microstrategy 8.1, WhereScape RED (tool to aid in agile ETL developments)

Confidential, Miami, FL

Responsibilities:

• Development of different ETL processes, database development and reports to aid the business functions of the company.
• Maintenance of internal web applications.

Languages, frameworks and technologies: ASP.NET, Javascript,DHTML C#, DTS,SSISSQL Reporting Services, Visio,Sourcesafe(control source system)

Confidential, Florida

Responsibilities:

• Work on Development of different modules of the Medicare PartD system.
• Responsible for writing all kind of Reports for the Company in the Medicare PartD system.
• Worked on Implementation of credit card processing module using the Confidential network as payment gateway
• Implementation of a customized Report Management system.

Languages, frameworks and technologies: ASP.NET, Javascript,DHTML C#, COM,Transact-SQL,SQL Reporting Services,OLAP,ACT,Visio,Sourcesafe(control source system)

Confidential, Fort Lauderdale, FL

Responsibilities:

• Part of the development team responsible for developing a Key Recovery Web Service and Business Object for Confidential Password ManagerVersion 4.0.
• Responsible for developing a Crypto API, which use DPAPI AND 3DES algorithms, for other components of Confidential Password Manager Version 4.0.
• Extended mod aspdotnet module in the XTE service (XTE is a Confidential variant of Apache) to allow windows authentication and impersonation in .NET.
• Localized web side of the application generating satellite assemblies to localize web and custom controls according to the user browser default Language settings.
• Worked closely with the test team to debug, track, and address issues.

Languages, frameworks and technologies: Visual C++.NET, C#, COM+, perforce (control source system)

Confidential, Albany

Responsibilities:

• Design and Implementation of E-Commerce applications to sell e-learning courses ( payment integration with Paypal and LinkPoint) .
• Design using IBM Websphere studio V5.0 of a finance reporting application.
• Linking and Synchronization of three independent Learning management systems (LMS) hosted in Confidential site.
• Design of a e-learning courses web catalog with searching capabilities .
• Implementation of a reporting system for master LMS system.
• Implementation of a browser agent in C# to import information from an external LMS hosted by a different vendor.
• Participate in common Project with IBM to install and troubleshoot computers networks in New York state Youth prisons facilities
• Installation and maintenance of computers network and windows services in BrighterChoice and St Casimir schools located at Albany NY.

Languages, frameworks and technologies: C++,C#,COM,COM+,.NET framework,J2SE, J2EE,Struts, Apache, Axis, Websphere, SQL 2000, Transact-SQL, Coldfusion MX, Crystal Reports,SQL Reporting Services,HTML, XML, cisco routers <2500 and 3600 series> and switches configuration, sonicwall firewall configuration, windows 2000 server services installation.

Confidential

Responsibilities:

• Designed and implemented a system for remote control of a laboratory.
• Designed and implemented a library (set of generic classes in C++) to facilitate the implementation of compilers and simultaneously to use tools to generate compiler’s code like the PCYACC of the Abraxas Software Company.
• Designed and implemented compilers for two IEC1131 (European international norm) structured programming languages of Program Logic Controller (PLC) to program Confidential (PLC made in Cuba).
• Designed and implemented a compiler for an Object Oriented Language to program the Confidential PLC.
• Designed and implemented the linker of all the implemented compilers noted above.
• Designed in assembler language of an optimized arithmetical floating point for the Confidential firmware in microprocessor Z181 (Zilog).
• Worked with and optimized the firmware code of Confidential operating system.
• Designed and implemented the off-line simulator of the PLC Confidential .

Languages, frameworks and technologies: C,C++, COM, J2SE, SQL 7.0, Z80 and MC 8051 Assembler, Transact SQ, Labview, Compilers Techniques