* Provide software development and software maintenance services to Apotex Mexico. * Technology: C#, ASP.NET MVC, Kendo UI, MS SQL Server, Web Services
* Responsible for designing applications, enhancing the architecture of the existing applications, finding areas of improvement, and improving the quality of code. * Responsible for designing and developing web applications using C#, ASP.NET MVC 5, and Kendo UI. * Provide training to a team of developers. * Prepare guidelines for naming conventions and best practices of software development. * Technology: C#, ASP.NET MVC, SQL Server, Visual Studio.
* Apotex Mexico: Designed and developed Confirma, an expense reporting application that allows users to upload their ``electronic bills'' (CFDI), verifies the transaction with the SAT (Mexican government tax administration) web services, separates expenses into different accounts, and loads them into SAP using SAP .NET Connector. * Planned, designed, developed, implemented, and maintained a variety of complex enterprise web applications that support ongoing business activities at Apotex using C#, ASP.NET MVC (MVC 2 to MVC 5), and Kendo UI. * Collaborated with other developers and web designers to develop mobile applications using Telerik AppBuilder. * Developed RESTful Web Services using ASP.NET Web API to be consumed by web and mobile applications. * Developed test projects for unit testing of ASP.NET MVC and ASP.NET Web API applications. * Developed Windows Services to connect to Excelleris Web Services to pull Electronic Health Records and load them into Microsoft Dynamics CRM. * Supported and maintained a group of legacy applications developed with Classic ASP. * Supported and maintained SAP Portal applications developed with SAP NetWeaver (Java). * Prepared technical documentation (requirements documents, test cases, implementation checklists, etc.) as part of the software development life cycle. * Technology: C#, ASP.NET MVC, ASP.NET Web API, Kendo UI, AngularJS, Bootstrap, RESTfull, MS SQL Server, JSON, AJAX, Javascript, SAP .NET Connector, Web Services, XML, XSLT, XSD, Java, Web Dynpro, VBscript, Classic ASP, Microsoft Dynamics CRM.
* Responsible for developing a Machine Condition Monitoring software application using C#. * Designed the application's Object Model and implemented the application in three modules of Data Acquisition (DAQ), Data Analysis, and Decision Making. * Developed the software application using Visual Studio 2008 and C#. * Designed the application's Data Model and developed the back-end SQL Server database. * Designed and developed User Controls and Components to wrap the Data Acquisition device objects and scan the DAQ device. * Used open source class libraries and developed wrapper classes and components for making the complex mathematical calculations such as FFT (Fast Fourier Transform). * Technology: C#, SQL Server, Visual Studio
* Served as tool SME in support of a customized version of OPX2 R4 developed based on the requirements of Sprint. * Participated in preparing and implementing a data migration plan to migrate data from OPX2 R3 to OPX2 R4. * Responsible for gathering requirements and preparing a design document for creating an Oracle reporting database. * Created complex Stored Procedures and Views on the Oracle database to provide the database users with easy access to the data. * Responsible for the administration of the OPX2 R4 intranet. * Responsible for automating the report generation process using Crystal Reports and VBA programming. * Technology: OPX2, Oracle, VBA, Crystal Reports, MS Access.
Paragon Technology GroupOctober 2003 - October 2006
Sprint-Nextel: Responsible for developing and automating data reports for analysis support. * Responsible for the administration of several applications including OPX2 R3. * Participated in preparing a data migration plan for migrating data from a SQL Server database to the back-end of OPX2 (an Oracle database). * Participated in the requirements gathering effort for the next release of OPX2. * Created Linked Tables in MS Access using ODBC Connections to SQL Server and Oracle databases. * Developed complex multi-join queries using the MS Access query designer and/or SQL Server T-SQL language. * Retrieved data from different sources such as SQL Server, Oracle, and Excel spreadsheets to create the reports. * Used Visual Basic for Applications (VBA) for developing Macros in MS Excel to automate the reports. * Extensively used Crystal Reports to create complex nested reports. Moni Inc.: Designed and developed a web-based invoicing application. * Used SQL Server 2000 to design the database. * Created tables and stored procedures in SQL Server 2000 using T-SQL. * Used Microsoft DTS for migrating data from Excel spreadsheets to SQL Server tables. * Used Visual Basic.NET and ASP.NET WebForms for developing the application's front-end on the company's intranet. Designed and developed Paragon's internal infrastructure to facilitate demonstration and prototyping of Business Objects' BI platform. * Installed and configured the end-to-end Business Objects platform. * Extensively used Business Objects Supervisor module for creating repository, creating users, and managing their access permissions. * Designed data marts using star schema and snowflake schema models. * Used Business Objects Designer module to create Universes. * Responsible for loading the data from different data sources (SQL Server and Oracle) to the Data Mart using Business Objects Data Integrator, and SQL Server DTS Packages. * Generated reports based on functional specifications using Business Objects and WebIntelligence. * Used Broadcast Agent Server for auto scheduling of Business Objects' Documents. Developed a SharePointdocument management website for Paragon Technology Group. * Installed Windows SharePoint Services on a Windows 2003 server. * Used Templates to create special purpose websites inside the main SharePoint site. * Used MS FrontPage to customize the SharePoint pages. * Created Document Libraries inside the websites. * Maintained the Security of the system by managing Users and their access rights. * Responsible for all the administrative tasks of the system. Technology: OPX2, Oracle, Crystal Reports, MS Access, VBA, Windows Sharepoint Services, Windows 2003 Server, MS FrontPage, SQL Server 2000, Visual Basic.NET, ADO.NET, ASP.NET
* Designed and developed applications using Visual Basic. * Designed application's relational data model and implemented the application's back-end using SQL Server 2000. * Responsible for all the administration tasks of the SQL Server 2000 database, including backup creation, security management, and performance tuning. * Used DTS to extract, clean and load the data from the legacy into the database. * Converted a complete Microsoft Access 2002 application front-end to Visual * Basic 6.0 and migrated the back-end of the application to a SQL Server database. * Used Microsoft Access 2002 and VBA to create an asset management application. * Developed T-SQL stored procedures and used DTS packages to support creating of reports in MS Excel. * Technology: SQL Server 2000, Visual Basic 6, VBA, MS Access
* Developed an Inventory Management application using Visual Basic 6.0 and SQL Server 7. * Used DTS to import data from flat files and FoxPro database files into the SQL Server database. * Technology: SQL Server 7, Visual Basic 6, FoxPro.
Web API, Web development, Web Dynpro, Web Services, ASP.NET Web API, Oracle Applications, Microsoft Dynamics CRM, Software Development, ADO, CRM
Databases
SQL Server 2000, Microsoft SQL Server 7.0, Oracle, Microsoft SQL Server, ADO.NET, PostGreSQL, SQLite, FoxPro, MS Access, Visual FoxPro
ERP&CRM
SAP
Other
RESTFull, Persian, SAP SAPNET, Visio, MS SQL Server, SAP SAP Portal, Visual Basic.NET, Mobx-State-Tree, SAP .NET Connector, Data Warehousing, OPX2, Business Use Case Model, BusinessObjects Web Intelligence, Kendo, Windows Sharepoint Services, Data Transformation Services, Back End, software maintenance, SQL Server 7, SAP SAP NetWeaver, Requirements Gathering, English, Microsoft Windows, Microsoft Visual Studio, Scrum Methodology, Classic ASP, Microsoft C-SHARP, Microsoft .NET Technology, Cascading Style Sheets, Microsoft Windows 2000 Server, Microsoft Access, Microsoft ASP.NET, Apple MacOS, Application design, Front End, Data Modelling, RESTful, Seagate Crystal Reports, Microsoft SQL Server 2000, Microsoft Visual Studio.NET, BusinessObjects Data Integrator, Microsoft Transact-SQL, Microsoft Visio, Object Oriented Analysis/Design, Visual Basic .NET, Machine Condition Monitoring
As Pentalog’s Talent Sourcing branch, SkillValue relies on a pool of 400,000+ Tech & Marketing Specialists – including 15,000+ Freelancers, a comprehensive catalog of IT assessments, available projects and job opportunities. Our SkillValue consultants are always ready and willing to help you boost your career.
A Pentalog account allows convenient access to our global price catalog featuring competitive prices for top software engineering and digital profiles.
Our catalog contains everything you need to build and scale a high-performing agile development team.
Why create a Pentalog account?
View transparent pricing for world-class developers
Build and price your development “dream team”
Compare pieces across 3 continents & 8 countries
Receive updates on available devs and special offers
Pro tip: Talk to a Pentalog Solution Specialist for help with technical profiles not listed in the catalog.