SUMMARY:

Experienced Programming Business Analyst/Data Analyst. Experience analyzing and developing Functional specifications for various software developments, maintenance release and project releases. 9 plus years experience in web - based and client/server environments. Strong analytical and logical skills with ability to follow project Standards and procedures as per client specifications.

TECHNICAL SKILLS:

Web Tools: SSIS, SSRS, ASP, XML, VB.Net, Dream Weaver

Requirements Management: Microsoft Excel 2007, Microsoft Word 2007

Databases: Oracle 9i/10g, SQL Server 2003/2005/2008 R2, MS-Access

Operating Systems: UNIX (AIX, HP-UX), Windows 2003-Win7, Linux

Web Servers Coding: Microsoft IIS 4.0, Java, Web Server, PHP, JavaScript, Fireworks, C#, PowerShell

Other Tools: C++, Java, VB,J2EE, SharePoint 2007/2010, Active X, Solarwinds, Active Directory, BMC/Numara Track-IT Numara AdministratorCustomer Relation Management(CRM) GoldMine

EXPERIENCE:

Confidential, Charlotte, NC

Programming Application Developer

Responsibilities:

• SharePoint 2010 architecture/ Administrator including Web Applications, Site Collections, Content Databases, Service Applications
• Proficient in SharePoint designer 2010 capabilities specifically workflows, master pages, and page layouts.
• Well versed with "out of the box" web parts.
• Strong knowledge of Calendar, list, and library settings. Strong knowledge of filters, columns, forms (both Info path and out of the box) and views.
• Strong knowledge of SharePoint authorization such as permission levels, groups, and user profiles.
• Experience with SharePoint Enterprise Search services, crawler configuration, and scopes.
• Experience with configuration of ULS logging settings, Health Analyzer rules, Auditing, and Web Analytics Usage reporting. Advanced troubleshooting skills utilizing correlation id's and Developer Dashboard.
• Provide technical support and troubleshoots system issue associated with SharePoint related activities
• Set up and provided day-to-day end-user support in collaborative team environment
• Providing documentation and conducted end-user training using how-to guides, tips and tricks, live and recorded presentations, and job aids focusing on ease of use and best practice procedures
• Creating custom SharePoint applications that utilize Workflow and InfoPath functionality with SharePoint designer 2010
• Develop user application in Visual Studio 2010 front end and SQL 2008 R2 backend, coding application in C# and JavaScript
• BA responsibilities, gathering SharePoint application requirements from end user before creating applications.
• Creating Test Case for new SharePoint application
• Crystal Reports 2011, SQL Server Management Studio, Excel Pivot tables, Access reports and forms, database and table structures, Data configuration and transfer database and table structure.
• Crystal Reports 2011 developing reports using Crystal Reports Designer 2011 that included multiple Sub-Reports, Parameters, SQL
• Expressions and Crystal/Basic Syntax Formulas
• Knowledge in publishing/scheduling reports to Crystal Enterprise 10 using publishing Wizard as well as Crystal Management Console.
• Business Analyst and Project management roles in training end users, business users and customers on how to Create modify and interpret reports
• Strong process modeling using UML (Use Cases, Sequence Diagrams, Activity Diagrams, etc.) Team player to work in conjunction with testers (QA), developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects.
• Experience in Requirement Analysis, JAD sessions, Business and Systems reviews and working sessions to understand the requirements and system design.
• Well versed in Requirements/Change Management, Impact Analysis and Gap Analysis.
• Strong Analytical and Problem Solving skills, Multi-Tasking abilities, with proven experience in utilizing people and process knowledge to assist enterprises in making critical decision.
• Interviewed clients and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Technical writing skills to create Business Requirements Document (BRD)
• Developing SSIS/ETL packages.
• Operations and Support -Perform daily system monitoring, verifying the integrity and availability of server resources SharePoint Farm and SAP Crystal Reports, systems and key processes, reviewing system and application logs, and verifying completion with Solarwinds
• BMC/Numara Track-IT Numara Administrator.
• CRM Goldmine Administrator manages every relationship in with business community.

Confidential

BI Platform Vendor Analytic

Responsibilities:

• Identify all spend with the supplier group and put the data in one data repository (SQL Server)
• T-SQL and Stored Procedure development and usage
• OLAP cube development and usage creating reports
• Involved in Business Analysis and Requirements collection. Creating presentations and procedural documentation.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Involved in the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Data management.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse and maintenance.
• Trouble shooting/Resolutions of problems by checking sessions and error logs
• Creating SSIS packages with SQL Server Business Intelligence Development Studios
• Creating multifunction Stored Procedures in SQL Server Management Studio
• Share Point reporting site reporting
• Creating management reporting in SSRS
• Working with internal clients to create adhoc reporting based on multiple dataset information
• Designed and developed end-to-end ETL process for Business Intelligence Vendor Analytics
• DTS to SSIS package conversion and impact analysis of Package consolidation and re-factoring effort of data warehouse ETL logic.
• Cleanup and archival processing of retired packages.
• Created SQL jobs scripting necessary to automate daily processing
• Designed and developed various custom defined reports using SQL Server Reporting Services (SSRS) and deployed them on SharePoint 2007/2010 Portal Web part Viewer.
• Created Technical support process to track technical incidents as it is opened by a customer, investigated by a support engineer, routed to technical experts, resolved, and added to a knowledge base. Utilizing SharePoint Workflows.

Confidential, Tennessee

Programming Analysts

Responsibilities:

• Utilized numerous data feeds from SAS to create daily reports for National Customer Service Dept Using Excel, Access.
• Building database solutions. The solutions were implemented using either SQL Server or Microsoft Jet back ends. The user interfaces were created using Microsoft Access Data Project tools (.adp) or Microsoft Access architecture (.mdb). I have a working knowledge of all aspects of the database development cycle. Experience includes requirements analysis, database design, upgrades, ongoing maintenance and support. extensive use of SQL and Visual Basic for Applications (VBA).
• Hands on experience in creating Tables and Views as well as writing Stored Procedures, Functions, indexes using T-SQL and PL/SQL/ SQL Enterprise Manager version 2005
• Experience in Creating Packages using SSIS/DTS to import/export data and schedule tasks to move data from log tables.
• Automated processes to assist with reporting outputs Macros and VBA Code
• Partnered with senior management to create and maintain departmental procedures
• Assisted clients in achieving process goals with Microsoft applications & gathering requirements
• Utilized Java, ASP, ASP.NET & JavaScript to create internal application for ticket tracking
• Administered SharePoint creating user accounts with specified permissions.
• Application development using SharePoint, .NET Framework, C#, VB.NET, ASP.NET, Technologies.
• Worked through all the phases of Software Development Life Cycle (SDLC) including Requirements Gathering, Analysis, Design, Development, Testing, UAT, Production and Post-production Support.
• Customizing forms using InfoPath and published them to SharePoint Form Library
• Created Technical support process to track technical incidents as it is opened by a customer, investigated by a support engineer, routed to technical experts, resolved, and added to a knowledge base. Utilizing SharePoint Workflows.
• Setting up ODBC connection for SharePoint projects
• Created internal sites. Maintained a unique look and feel across the portal by using Master Pages, CSS and HTML. Additionally designed and manipulated these pages using SharePoint Designer 2007.
• Created Web Parts using SharePoint Designer 2007 to display live feeds by consuming web services.
• Implemented custom built web parts using Visual Studio 2005 for the users to select the currencies involved, deal expiration date
• Designed and implemented Data Grid Web Parts to display data from SQL Server 2005 database utilizing Business Data Catalog features

Technical/Programming Analyst

Confidential

Responsibilities:

• Performed process analysis to identify production support opportunities
• Increased department productivity with creation of Robo-Rep which allowed opportunity for more efficient use of technical resources utilizing VB Script, SAS
• Developed online data tracking application in ASP.NET
• Managed partner data for operational functions with SQL Enterprise Manager version 2005
• Created User Interface applications using ASP.NET
• Created and maintained project status reports SharePoint
• Maintain update and grant permissions in SharePoint
• Created training decks for new applications Power Point & Word 2000 and up
• Web application development and maintenance utilizing Active X

Technical Analyst/Developer

Confidential

Responsibilities:

• Performed gap analysis by researching data with SQL
• Reconciled data with Excel(VLOOKUP, Pivot table)
• Created dynamic web pages for data tracking. This was accomplished using ASP as the front end and SQL back end.
• Created volume and productivity reports
• Automated Microsoft Excel, Microsoft Access, and web reports
• Developed and maintained online User Interface used for training feedback and reporting
• Created and updated training decks for new applications using Power Point
• Created and maintained online intranet reporting website for department analysis
• Created Ad-hoc reports for daily operation analysis using Excel & Access
• Completed data mapping and produced account level reporting
• Worked with UNIX based Sun SOLARIS Concerto dialer, analyzing dialing strategies and call mixes