SUMMARY:

• Analyzed, designed, implemented, and tested solutions to business problems.
• Build .NET Application with Access, SQL Server, and Oracle as the backend.
• Architect, Design and develop applications to meet business needs.
• Provided technical support to users of PeopleSoft/Oracle HRMS and Salesforce
• Experienced SQL Server Reporting Services developer.
• Expert in Student Management Applications: CampusVue, Talisma CRM, Campus Portal and LMS (Learning Management Software)
• Extensive knowledge about the business domain, solution development methodologies, and business rules
• Developed customer relationship management databases using Access 2000 - 3, Visual Basic, SQL Server, ASP.NET, ADO.NET and Visual Basic.NET
• Packaged and deployed Microsoft Solutions
• Experienced in using SDLC (system development life cycle) and ERD (entity relationship diagrams) methodologies

TECHNICAL SKILLS:

Operating Systems: DOS, Windows 95, 98, Me, 2000, XP, Win 7, Windows 2000/2003/2008/ 2012 Server, Red Hat Linux, UNIX

Applications: Crystal Reports, SSIS, SSRS, SSAS, SQL Server, Oracle, FoxPro, Lotus Notes, Access, Yardi, AccPak, CampusVue, Talisma CRM, MS Office (MS Access, Excel, Power Point, Visio, Word, Outlook, Project)Programming and Code: SQL, PLSQL, ASSEMBLY, VHDL, VBA, VB.NET, C/C++, C#, VB6

Web Development: HTML, ASP, ASP.NET, XML, FrontPage, Visual Studios.NET

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead

Responsibilities:

• Create and modify store procedures, views, adhoc T-SQL queries using SQL Server 2008 R2 / SQL Server 2012.
• Work with senior DBA toimprove SQLServer2008 R2 and SQL Server 2012 performanceand scalability by optimizing queries, fine-tune indexes, perform efficient transactions, build efficient stored procedures and views, analyze and understand execution plans
• Facilitated User Acceptance Testing (UAT), ensuring that all errors were tracked and reported to development and management teams.
• Guides and reviews the work of team members
• Creates and maintains documentation of areaof specialty
• Expertise in interpreting information which requires the research, development, and testing of new methods and/or concepts of analysis
• Able to conduct proof of concepts and make recommendations for new technology
• Utilized as a resource by other groups within the department, outside of their primary Subject Matter Expertise (SME) area. Can effectively participate on cross-functional teams
• Support and maintain Talisma CRM application.
• Perform system upgrades and data load using SQL Server 2008 R2 / SQL 2012 Data definition language (DDL) and Data manipulation language (DML) statements.
• Review code of application support team members
• Write code to enhance system performance and create system reports

Confidential

Data Analyst / Report Writer

Responsibilities:

• Developed, deployed, supported, standardized and customized reports using Crystal Reports, T-SQL, Oracle, Access, Excel, Toad, Brio Query in a SAP environment
• Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR). Created test cases and test scripts
• Ensured all artifacts complied with corporate SDLC Policies and guidelines
• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met
• Performed GAP analysis of business rules, business and system process flows, user administration, and requirements
• Documented Software System Requirements (SSR) and BPR
• Updated System Change Request (SCR) forms for Product Data Management (PDM).
• Applied change requests, versions, and addendums.

Confidential

Lead Business Analyst

Responsibilities:

• Integration across business lines of CampusVue ERP with scheduling software and document imaging software
• Development of software interfaces to enhance the usability of CampusVue with homegrown and purchased software
• Analyze stakeholder requirements and translate into functional specifications
• Create business process workflows and diagrams
• Document stakeholder requirements and business process
• Analyze stakeholder issues and provide recommendations to improve process
• Strong customer service, analytical and organizational skills
• Will work with Academic Records office, Admissions, Financial Aid, faculty, and the Business office
• End user support developing SQL queries and creating new reports using Crystal Reports. Report logic is generally written within the stored procedures and Crystal Reports is utilized for presentation.
• Duties also include performance tuning of existing stored procedures to improve the speed of existing reports.
• Debug Applications and interfaces errors generally written in C#/.Net. Also, worked with applications that utilize SQL Server SSIS or SSRS

Confidential

Business Analyst / SSRS Report Writer

Responsibilities:

• Gather business requirements by gathering conducting detailed interviews with business users, stakeholders, and subject matter experts
• Communicate and interact on a regular basis with the project manager and development team during different stages of the project
• Manage schedules and collaborate with different teams working on the project
• Assumed responsibility for data integrity among various internal groups
• Established standards and best practices on SSRS
• Designed and delivered new reports using SQL Server Reporting Services 2008
• Prepared business process models; used Visio to create use case diagrams

Confidential

Data Extraction / SQL Developer

Responsibilities:

• Performing ETL’s (Extraction, Transformation, Loading) procedures analyzing and reporting of subsequent data for prospective physicians using SQL Server 2008 /2005, Access 2010, Excel 2010 Monarch Pro and various remote desktop applications.
• Developing Reports using SQL Server Reporting Services (SSRS). Developing SSIS packages and designing ETL processes. Designing OLAP cubes using SSAS. Performing optimization on already existing databases. Performing Migration from MySQL and Sybase databases to SQL server 2008 databases. Designing and developing business reports.
• Use SQL Server 2005/2008 DML and DDL statements to manipulate and modify and create reports on a day to day basis.
• Created SSIS packages to clean and load data to data warehouse.
• Created package to transfer data between OLTP and OLAP databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created a table to save dirty records.
• Extracted data from XML to SQL Server
• Created SSIS packages for data Importing, Cleansing, and Parsing etc.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
• Optimized cubes for better query performance.
• Extracted data from XML files.

Confidential

Application Specialist / Project Manager

Responsibilities:

• Administer and maintain SQL 2005 Databases across all campuses
• Create and modify SQL Stored Procedures & Views using SQL Server Management Studio, SQL Server Enterprise Manager and SQL Server Query Analyzer
• Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards
• Used SDLC methodology to plan, analyze, configure and implement application across multiple locations
• Created and administer Project Plans by using Microsoft Projects to manage timelines and deliverables to ensure deadlines were met
• Work with ASP, HTML, VBScript, XML, XSL, CSS, and MS SQL Server to develop student and staff portals
• Convert strategic goals and objectives into themes that reflect goals relating to financial performance, customer value, business operations, and human resources.
• Administer configure and maintain student management applications across all campuses (CampusVue Student, LMS -Learning Management Software & CampusVue Portal)
• Create entity relationship diagrams (ERD) to analyze requirements and create data transfer packages using SQL Server Integrated Services (SSIS)
• Conduct interviews with stakeholders to elicit information about the core system components required
• Troubleshoot and debug errors using SQL Server error logs and Windows Event Viewer
• Use alerts, performance condition alerts, and fail-safe operator in SQL Server to monitor performance
• Create, modify and maintain reports using Crystal Reports, SSIS, SQL Store procedures and SQL Views
• Manage security in CampusVue and SQL Server in a single sign-on Active Directory environment
• Write and administer custom SQL database backup packages

Confidential, Boca Rotan, FL

Support Engineer

Responsibilities:

• Troubleshoot and debug SQL Server, Crystal Reports, Dynamic CRM, Talisma CRM and CampusVue (VB) application
• Provided phone support to application users to resolve application and data bugs, and configuration issues
• Troubleshoot student and staff portals using ASP, HTML, VBScript, XML, XSL, CSS, and MS SQL Server
• Configured SQL Server Profiler Trace files to catch application errors
• Repaired and configured web portal application using ASP.NET / C#
• Debugged SQL Store Procedures & Views
• Created support documentations: User and Administrator Manuals
• Used SQL Server Profiler and System Monitor to monitor instances of SQL Server and trace and debug system & data errors
• Archived SQL Server Data and Created backup packages
• Train the Support team to use and troubleshoot TalismaCRM and CampusCRM Application
• Worked with the development team to gather the requirements to develop CampusCRM application
• Lead the TalismaCRM Support team in the rollout of the product
• Used the SDLC methodology in the design, implementation, documentation, testing, and operation of web-based application (Dynamic CRM)

Confidential

Independent System Consultant

Responsibilities:

• Analyze clients’ system needs and provide hardware and software solutions according
• Help desk support and ongoing system maintenance
• Create web-based application and windows application to fit the clients’ business requirements
• Ensure appropriate version control of all application software and hardware and recommend and perform upgrades when necessary

Confidential, Miami Lakes, FL

Consultant Database Programmer

Responsibilities:

• Created and deployed five documents control Windows Applications using Microsoft Access 2000, SQL 2000 and VBA.
• Developed business processes to in corporate user, business and IT process requirements with system needs.
• Oversee the product and user test acceptance stages of development
• Tested and resolved issues with systems developed