TECHNICAL SKILLS

Languages: C#, VB .NET, VB6, SQL, HTML,HTML5, JavaScript, Java, XML, C++,CSS, R,XAML

Internet Technologies: IIS, ASP.NET, Ajax, XML, JQuery, Bootstrap

Systems: Windows Server 2003,XP, 7, Confidential EComm Server

Frameworks: .NET 1.1, 2.0, 3.5, 4.0,4.5,5.0,5.1,6.0

Related Technologies: TFS, ADO.NET, LINQ, WCF,WPF, Rally, Team Forge, Jira

Databases: SQL Server 2000, 2005, 2008,R2,2012, 2014,2016, DB2, Oracle, MySQL

Software and Packages: SSRS,SSIS,SSAS, Visual Studio, MS Office, MS Project, MS Visio, Crystal Reports, Red Gate Data and Schema Compare Packages, Wherescape Red, Toad, Power BI Desktop, Tableau 9/10, SAP Crystal Reports 11, QlikView, Sisense, Power Query, Power Map, MySQL workbench.

PROFESSIONAL EXPERIENCE

Confidential, Fort Lauderdale, FL

Software Developer

Responsibilities:

• After 3 months of contract to hire with GlobalBoz was hired for permanent Developer Lead1 Position.
• Worked closely with company management to examine and analyze business requirements and workflows for Medicaid, Medicare, Insurance applications.
• Developed multiple database objects (tables, views, triggers, stored procedures, functions, jobs) using SQL Server 2016 and Visual Studio 2015.
• Designed and implemented multiple SSIS dts packages using SSIS data tools 2016.
• Created new and modified existing reports, subscriptions and dashboards based on SSRS 2012/2016 and Power BI Desktop, powerPivot and powerMap.
• Worked for operations team to fix incoming errors supporting existing company customers.
• Provided tuning and performance optimization for multiple queries.
• Participated at all phases of SDLC including design, implementation and deployment of multiple web applications.
• Trained end - users on using Web and BI applications and reports.
• Modified and coded web applications using C#, ASP.NET MVC, JavaScript, Bootstrap, HTML5, CSS3.
• Participated in team meetings and provided project management for development team using Jira for agile development, created multiple user stories, tasks and subtasks.
• Worked with data warehouse providing ETL and data modeling, retrieval of multidimensional data for multiple reports and visualizations.
• Provided data analysis for financial databases.
• Worked with QA team to create unit tests and help testing development of multiple applications.
• Created multiple documents and artifacts for company applications and reports using MS Project and MS Office.

Confidential, Fort Lauderdale, FL

Developer

Responsibilities:

• Worked closely with internal and external clients to analyze data flows, development requirements and business models for medical applications and reports.
• Maintained and developed multitenant ASP.NET C# cloud web applications based on C# 4.0, ASP.NET, JQuery, JavaScript, SQL Server 2012, Bootstrap, HTML5, CSS3.
• Developed database objects (tables, views, stored procedures, triggers, types, functions) using SQL Server 2012
• Maintained and created multiple SSRS Reports based on SSRS 2010 and SSRS 2017.
• Maintained, designed and developed multiple SSIS packages for ETL and data movements based on SSIS 2015.
• Provided Database Administration and development including creating database objects (queries, tables, views, stored procedures, triggers, replications), jobs, tasks, queries optimization.
• Assisted company management with selecting requirements for reports and dashboards based on company structure and business knowledge.
• Created multiple dashboards based on PowerBI Desktop.
• Maintained and created new data marts and cubes based on SSAS 2016, modeled several multidimensional objects.
• Trained end-users on using BI applications and reports.
• Participated in team meetings and provided project management for selecting perspectives of future development of company BI and Software Architecture.

Confidential, Miami, FL

Developer

Responsibilities:

• Modified and coded web components and applications using VB.NET, ASP.NET, JavaScript, Bootstrap, HTML5, CSS3.
• Worked closely with company management to examine and analyze business models, data flows, reporting and dashboard requirements.
• Developed BI Architecture for cloud based E-Commerce organization including creating new staging, tabular and multidimensional (kimball cube) environments. Provided estimation of required resources, designed servers architecture, created data warehouse and all related components (cube, dim, fact tables) using SSAS 2014 and SQL Server 2016.
• Designed and implemented ETL incremental process using SSIS 2014.
• Created new and modified existing reports and dashboards based on SSRS 2014 and Power BI Desktop.
• Assisted company management with selecting requirements for reports and dashboards based on company structure and business knowledge.
• Provided Database Administration and development including creating database objects (queries, tables, views, stored procedures, triggers, replications), jobs, tasks, queries optimization.
• Trained end-users on using BI applications and reports.
• Participated in team meetings and provided project management for selecting perspectives of future development of company BI and Software Architecture.

Confidential, Miami Lakes, FL

SQL BI Developer

Responsibilities:

• Worked closely with internal clients to examine and analyze data flows, reporting requirements and business models.
• Developed database objects (tables, views, materialized view, stored procedures, functions) using SQL Server 2012 and Toad for Oracle 11g and tabular multidimensional models (Kimball Tabular Schemas)
• Developed multiple SSRS and OBIEE reports and Tableau dashboards using SQL Server 2012 and Toad (TSQL, Oracle 11g)
• Maintained the Business Intelligence repository and catalogs
• Worked closely with data architects, data analysts and a variety of end users to ensure technical compatibility and user satisfaction
• Ensured that budgets were adhered to and deadlines were met
• Developed test scripts for ETL processes and reports, created and modified SSIS packages
• Trained end-users on usage of Business Intelligence applications
• Identified and fixed performance issues regarding SSRS and OBIEE reports
• Overseen the deployment of reports, dashboards, and scheduling agents
• Developed and maintained repository metadata dictionaries
• Participated in Team Meetings

Confidential, Miami, FL

Senior Developer

Responsibilities:

• Developed multiple database objects for several departments (schemas, tables, scripts, views, stored procedures,triggers, functions) based on MS SQL Server 2012/2016 and TSQL.
• Maintained,modified and developed new multidimensional cubes using SSAS and Wherescape Red.
• Created multiple SSIS ETL Packages for data transformation and data movement between databases using SSIS 2012, Oracle Toad.
• Create multiple visualizations using Tableau10,QlikView,Power Bi, Sissense and SQL Server 2012.
• Provided SQL Database Tuning and Optimization for MS SQL Server
• Re-engineered and created new reports using SSRS, Crystal Reports11
• Created testing environment for company applications and databases based on Visual Studio 2015 (C#, VB.NET, MS Test, WF), MS SQL Server 2016, Oracle Toad, MySQL workbench, SSIS, SSRS, SSAS, Tableau, QlickView, Power Bi, SharePoint, Crystal Reports11
• Maintained, designed, developed multiple Windows and Web data applications based on Visual Studio 2015 (VB.NET, C#, SQL, XML)

Confidential, Deerfield Beach, FL

Software Engineer

Responsibilities:

• Developed multiple database objects for Order Management System(schemas, tables, scripts, views, stored procedures,triggers, functions) based on SQL Server 2012 and TSQL.
• Provided analysis and modeling of data using ER Studio. Provided multidimensional design and modeling of data using SSAS.
• Created multiple SSIS ETL Packages for data transformation and data movement between databases using SSIS 2012 and SSAS 2012.
• Create multiple visualizations using Tableau9 and QlikView and SQL Server 2012.
• Created,supported and modified multiple reports based on SQL Server 2012/2014 and MS SSRS and MS Excel.
• Provided support and solved bugs reported by company customers.
• Used Jira and Team Foundation with Visual Studio 2013 for Agile Scrum team collaboration.

Confidential, Medley, FL

SQL BI Developer

Responsibilities:

• Developed database architecture and objects for CI Invoicing (schemas, tables, views, stored procedures, functions) based on SQL Server 2012 and DB2.
• Created ETL Process for migrating historical data using SSIS 2012
• Analyzed, modified and created new Web and Windows Services and Web APIs based on SOA Architecture, WCF 2012, C#
• Provided support for legacy systems and applications based on C# 2.0/3.5 and SQL Server

Confidential

BI Data Developer

Responsibilities:

• Supported and modified company Data Marts based on SQL Server 2008. Created and modified Star Schema table, dimensional tables, dimensions, constraints, DMX stored procedures for data retrievals from data marts.
• Created multiple SQL Queries for Data Fulfillments and Data Collecting for several company clients.
• Designed, implemented, coded, tested, deployed several modules and code libraries for Diablo Data Processing System based on C#, ASP.NET, Ajax, IIS7, SQL Server 2012, XML, JQuery, Telerik Components, WCF
• Designed, developed, implemented modules for LTL Data System based on C#, ASP.NET, IIS7, SQL Server 2012, SSRS, SSIS, WCF.
• Designed, developed and implemented multiple web parts and code libraries for CoreStore Data System.
• Reviewed, analyzed, modified, supported legacy Data and Web Applications and Systems using C# 2005/2008, ASP.NET 2.0, XML, JavaScript, JQuery, SOAP Web Services, WCF, SSRS 2005, SSIS2005, DTS
• Developed multiple database objects (tables, views, stored procedures, functions, transactions, jobs) using SQL Server 2012
• Designed, implemented multiple business reports based on SSRS2012Designed, implemented, supported multiple data packages based on SSIS2008
• Participated in Agile/SCRUM software development lifecycle based on Team Forge and Core Base system, managed sprints, phases, user stories, tasks and defects.
• Coordinated, trained and mentored other technical staff members and managers regarding deliverables, and processes.
• Participated in Company meetings and online discussions, reviewed several technology and technical questions for company personnel.

Confidential, Sunrise, FL

Senior BI Developer

Responsibilities:

• Interfaced with business managers and personnel to receive required information regarding their requests and to provide business objects and logic modeling
• Reviewed, analyzed, and modified multiple Web Application using C#2010, ASP.NET 4.0, XML, JavaScript, JQuery, SOAP Web Services, WCF and Reporting Services 2005.
• Implemented new, modified and supported old Web Services based on WCF and SOAP
• Developed multiple database objects (tables, stored procedures, functions, types, triggers, transactions) using SQL Server 2008
• Designed, implemented, modified, and supported multiple reports based on SSRS2005 (subscriptions, reports, ETLs, and more) and IS packages based on SSIS 2005.
• Provided performance optimization, database monitoring and improvement of execution plans for multiple stored procedures.

Confidential

DBA/Developer

Responsibilities:

• Played a key role in design and development of several phases of E-Solutions Web Application based on TFS 2010, VB.NET2010, ASP.NET 4.0, WCF, Telerik Components.
• Participated in agile/SCRUM software development lifecycle. Played role of SCRUM Master based on Rally and TFS2010. Managed sprints, phases, user stories, task and defects using Rally platform.
• Reviewed, analyzed, and modified E-Solution Web Application using VB.NET 2010, ASP.NET 4.0, WCF and Reporting Services 2008.
• Developed multiple database systems (tables, stored procedures, functions, types, triggers, transactions) using SQL Server 2008 R2 and Red Gate Data and System tools
• Provided database administration including writing maintenance plans, data and performance optimization, database monitoring and improvement of execution plans for stored procedures
• Researched and provided on-boarding for new award year changes based on ED documentation
• Designed and implemented multiple reports based on SSRS2008 and SSAS.
• Coordinated and mentored other technical staff members and managers regarding deliverables, and processes.- Implemented new and supported existing WCF services used for integration and communication between various financial aid applications and databases.
• Implemented new audit system used for control of changes on database tables using Service Broker and asynchronous triggers
• Improved old and implemented new components for page and component based information security system (including encryption and decryption algorithms, application, database, and network security modules)

Confidential, Sunrise, FL

Senior Developer

Responsibilities:

• Played a key role in design and development of next generation web and windows applications based on C# 2005/2008, ASP.NET 2/3.5, Ajax, and JavaScript.
• Implemented web and windows applications and participated in full software development lifecycle.
• Led development of NetMinder2.0, NetMinder1, Encore, FDA, and BSO applications.
• Reviewed, analyzed, and modified programming systems using C#, ASP.NET 3.5, Ajax, JavaScript, and SSRS 2005/2008
• Coordinated with other technical staff members and managers regarding deadlines, deliverables, and processes.
• Designed and coded complex enhancements based on specifications and user requirements
• Translated customer requirements into system specifications for NetMinder2.0, PE, and Encore, BSO applications.
• Provided full support and maintenance of NetMinder1, BSO, and PE applications.
• Developed multiple web components using C#, ASP.NET, XML, Ajax, and JavaScript
• Developed graphical enhancement of existing and new web and window applications using Adobe Photoshop CS4
• Designed, corrected, and modified databases (included creating new and modifying existing tables, stored procedures, views, and triggers)

Confidential, Pompano, FL

Developer

Responsibilities:

• Provided business systems design, analysis and programming services to modify existing and write new programs (included Windows and Web applications, components and Web services, AJAX-enabled Composed Components on base of Telerik Components)
• Set up data from a variety of sources and medium and converted received data into usable formats for PII applications (includes transferring data to a live relational database environment)
• Set up and maintains business logic for multiple data sets included completing address processing and standardization (merge/purge, ACE and grouping multiple addresses into a single household)
• Designed, corrected or modified databases (included creating tables and finding the proper indexes and primary keys based on their entities and relations
• Collected specifications from project managers and program applications that support the overall customer program.- Developed applications that create production schedules for use by various solutions and production personnel using C#, ASP.NET, XML, AJAX
• Developed applications that provide information to PII s internal accounting system
• Queried, retrieved, manipulated, displayed data for the purpose of internal or ad hoc reporting as requested by the customers or project managers (includes Crystal Reports, Excel, and Visual FoxPro7.0)
• Maintained Microsoft Windows and Web based applications by retrieving and modifying code to enhance the usability and performance of applications and tools that gain greater efficiency and quality using C#, VB.NET, ASP.NET, AJAX
• Tested programs to ensure they work properly and to determine that programs meet user needs. Corrected any problems encountered during testing.
• Provided end user support to personnel that utilize programmed applications.
• Provided technical documentations on applications including flow charts, specific
• Researched and provided presentation of HIPAA/Marketing compliance for HealthCare nitch team.