Resume

Sign in

Sql Server Data

Location:
Marietta, Georgia, United States
Posted:
December 30, 2015

Contact this candidate

Resume:

Amardo Cohall

678-***-**** acsyiq@r.postjobfree.com

Summary of Qualifications

Dynamic, skilled IT professional with comprehensive business/technical skill set and expertise in business process

Automation/management (BPM), enterprise application integration (EAI), process improvement (Six Sigma), systems

integration, requirements analysis, workflow design, SAP methodologies, leadership, process modeling,

testing/quality assurance, Business Intelligence, software development, customer service, project management, estimating and vendor relationships.

Expert Level Business Objects Developer versions 6.x-XIR3

Proficiency in the development and maintenance of multi-terabyte sized databases in Microsoft SQL using Access, OLAP and .Net methodologies.

Development of systems, methodologies and requirements using SDLC in SCRUM and Agile.

Maintenance and support of reporting solutions using Crystal Reports and Crystal Reports Enterprise Manager.

Strong background in the development and delivery of high-impact presentations using verbal acuity and technical proficiencies. Exceptional record of consistently meeting or exceeding company goals and objectives.

Areas of Expertise

Business Process Engineering

• Business Process Management System (BPMS) • Enterprise Application Integration (EAI) concepts • Performance Measurement• ERP

• Critical Success Factors (CSFs) • Business Process Measurement • Process Improvement • Solution Planning

Software Applications

• Business Objects Xi/Crystal Reports • Xcelsius • Exchange/Active Directory/Sharepoint • Banner • MS Office

• Windows Server 2008/NT • SSRS/SSAS/SSIS • SAP • ODBC • ETL • MSSQL 2012/2008/2005 • Data Integrator

• Microsoft .NET/Visual Basic • All Windows Platforms through Windows 8 • SAS • Teradata • Toad • Oracle • XML

• CRM

Professional Work History

Niche Digital Brands- Atlanta, GA September 2015-Current

Data Architect 4 Months

Integration of third-party analytical, KPI and E-Commerce modules into a streamlined, scalable business solution including InfusionSoft, Cyfe and Google Analytics.

Created technical documents for process improvement in CRM, Data Management and scalability.

Implemented custom process for HRIS integration in QuickBooks with supply chain.

Designed SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and MS Access to SQL Data Tools.

Built user interface using MS Access.

Optimized queries using Database Engine Tuning Advisor, execution plan, and SQL Profiler.

Worked with different control flow items like Execute Package, Execute SQL, Send mail and Bulk Insert tasks.

Extensively used derived column, union all, conditional split, audit, script, lookup, SCD, row count, fuzzy lookup and fuzzy grouping transformations in SSIS packages.

Responsible for creating SSIS packages to load data to dimension and fact tables in SQL Server data warehouse.

Created configuration files and enabling logging and error handling in SSIS, and using user defined variables to dynamically configure packages during runtime in SSIS.

Responsible for scheduling SSIS jobs using SQL Server Agent, and created alerts for successful and unsuccessful completion of Scheduled Jobs.

Subject Matter Expert in SAP systems and Microsoft Business Intelligence Projects

ArrowCore Group - Atlanta, GA November 2014-August 2015

Senior Business Objects Developer 9 Months

Provide technical leadership and hands-on support for the design, development, implementation, and maintenance of Business Objects reports, dashboards, and universes

Subject Matter Expert in SAP systems and Microsoft Business Intelligence Projects

Conversion of company reports from the Microsoft stack to Business Objects reports

Creation and maintenance of Universes

Client facing with internal end-users and external users to gather and translate business requirements into technical specifications/solutions

Creation of subscriptions and event objects in CMS

Maintenance of ETL packages

Developed scripts to use stored procedures created in MS SQL as data sources for Business Objects universes

Creation of ETL design documents including database structure, error handling and refresh

Georgia Medical Care Foundation - Atlanta, GA December 2013-October 2014

Data Architect 11 Months

Creation and streamlining of reporting processes through analysis of Cube infrastructure and code

Subject Matter Expert in Microsoft Business Intelligence Projects

Policy creation for analysts and report developers

Headed team of 2 SSRS developers, .Net developer and 2 SharePoint developers to scale out business architecture and planning.

Designed and develop complex reports and dashboards to meet the business needs.

Architect schema objects, built grids, graphs, standard reports and dashboards. Created and enhanced report objects, metrics, filters and prompts. Liaised with business partners to define requirements and reporting specifications and provide technical assistance Performance tuning reports, validation of SQL and maintaining BI best practices to ensure optimal end-user experience.

Cube Development

Used expertise in Powerpivot for trending analysis and forecasting project.

Environment: SSAS, SSRS, SSIS, MS SQL Server 2008/2012, MS Access, MS Excel, MS Office Access, Oracle, Visual Studios 2010/2012/2013

The Home Depot - Smyrna, GA October 2012-December 2013

Senior Inventory Planning and Replenishment Developer/Data Architect 14 Months

Worked in concert with Directors in Supply side Analytics to streamline Supply chain management and product workflows

Subject Matter Expert in Microsoft Business Intelligence Projects

Planning phase for user training of Junior Analysts

MicroStrategy Administration including supporting business analytical and reporting needs.

Designed and develop complex reports and dashboards to meet the business needs.

Exported MicroStrategy data into flat files and using that data to create complex Heat Maps. Architect schema objects, built grids, graphs, standard reports and dashboards. Created and enhanced report objects, metrics, filters and prompts. Liaised with business partners to define requirements and reporting specifications and provide technical assistance Performance tuning reports, validation of SQL and maintaining BI best practices to ensure optimal end-user experience.

Project Lead for the development and implementation of Source control and management of backlog projects.

Cube Development and training of Junior Analysts in Data Warehouse methodologies.

Used expertise in Powerpivot for trending analysis and forecasting project.

Management of Cube Data and Development of Reports in Pro Clarity Analytics Server

Environment: MicroStrategy, ProClarity, SSRS, MS SQL Server 2008/2005, MS Access, MS Excel, MS Office Access, Teradata, Oracle, Tableau, Business Objects

Resolution Technologies for Fleetcor/Mastercard - Atlanta, GA April 2012-September 2012

Business Intelligence Developer 6 Months

Installation and configuration of SQL Server Enterprise manager tools and Visual Studios.

Installation and configuration of Visual Studios 2010.

Preparation of Technical Requirements and Requirements gathering and streamlining of report process

Creation of complex stored Procedures, User Defined Functions, Views, T-SQL Scripting for complex business logic.

Integration of business processes for transforming RDL files to RDLC formats.

Configuration of logic for globalization including language and currency considerations.

Extensive use of Joins and sub-queries for complex queries involving multiple tables from different databases.

Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets. Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS. Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using XML in BIDS

Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.

Environment: SSIS, SSRS, MS SQL Server 2008, Crystal Reports/Business Objects, Visual studio 2008, MS Access, MS Excel 2010, MS Office Access 2010, SAS

Odyssey Healthcare - Atlanta, GA January 2012-April 2012

Senior Business Intelligence Developer 3 Months

Creation of SSIS packages for data management.

Querying Oracle databases in Toad to update location metrics.

Management of PeopleSoft data for conversions between formats.

Performed an integral role in weekly Management and Decision Support strategy meetings.

Performance of multivariable statistical analysis.

Data administration and error correction using Data Integrator.

Metadata analysis in Business Objects administration Best Practices.

Creation, modification and maintenance of stored procedures to streamline reporting processes.

Use of elevated permissions for Production support.

Use of materialized views in Business Objects XI to incorporate complex changes in data and scheduler for reports.

Environment: SSIS, SSRS, MS SQL Server 2008, Crystal Reports/Business Objects XIR3, Visual studio 2008, MS Access, MS Excel 2010, MS Office Access 2010, SAS

North Highland for International Hotels Group - Atlanta, GA October 2011-January 2012

SAS/Senior Business Objects Developer 3 Months

Complex Analysis of data in SAS.

Predictive and Inferential Analysis in SAS

Performed data mining of Teradata database using SAS/Access Interface.

Gathered requirements from Revenue Management user groups to create market specific dashboards in Business Objects xi.

Creation of ad-hoc reports in WebI for trending.

Used my expertise in SAS to analyze and coordinate hotel revenue and financial data into cogent and powerful reports and graphs.

Use of SAS best practices to validate derived datasets.

Expertise in Universe designing, developing and generating complex, ad-hoc, dashboard Reports, Business views, List of values.

Extensive use of Business Objects xi reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

Environment: SAS Base 9, 9.3, Crystal Reports/Business Objects, MS SQL Server 2008, MS Access, MS Excel 2010, MS Office Access 2010, Toad, Oracle, People Soft

North Highland for Hunter Technologies - Atlanta, GA April 2011-September 2011

Data Architect 6 Months

Queried complex cube data to create operational reports.

Preparation of Technical Requirements and Requirements gathering.

Creation of stored Procedures, User Defined Functions, Views, T-SQL Scripting for complex business logic.

Export of SQL query results for the creation of Power Pivot reports

Linear regression of SAS datasets. Designed and developed tablix reports with drill down, drill through and drop down menu option using SSRS. Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.

Use of views to restrict access to data in a table for security.

Creation of web-accessible dashboards in Crystal Reports. Experience with the SharePoint 2010 to upload the SSIS packages in to Web portal

Managed OLAP cubes and provided user groups with ad hoc data

Deployed and tested the Crystal Reports on Crystal Enterprise

Installed and administered Business Objects modules both full-client modules (Business Objects XIR2 Designer, Desktop intelligence and Central Management Console) for user Community and server-side modules (Web Intelligence).

Experience in building Universes, Stored Procedures, Free Hand SQL methods and creating Complex and Ad-Hoc Reports using Business Objects.

Environment: SSIS, SSRS, MS SQL Server 2008, Crystal Reports/Business Objects, Visual studio 2008, MS Access, MS Excel 2010, MS Office Access 2010, SAS

Georgia Pacific - Atlanta, GA November 2010-April 2011

Business Intelligence Developer 6 Months

Installation and configuration of SQL Server Enterprise manager tools and Visual Studios.

Creation and maintenance of Sharepoint 2010 sites and libraries.

Preparation of Technical Requirements and Requirements gathering and streamlining of report process for the creation of Wood Products deliverable.

Creation of stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.

Export of SQL query results for the creation of Power Pivot reports

Lead a team of SSRS developers for implementation of Wood Products development initiative.

Created combination component to combine data extracted from different database servers and in different formats

Performed parse function and eliminated unnecessary and corrupted files from the database

Creation of reports using Business Objects designer, Web Intelligence, Crystal Reports and Crystal Xcelsius tools.

Extensive use of Joins and sub-queries for complex queries involving multiple tables from different databases.

Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets. Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS. Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.

Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.

Created views to restrict access to data in a table for security. Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.

Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB. Experience with the Share point 2010 to upload the SSIS packages in to Web portal.

Environment: SSIS, SSRS, MS SQL Server 2008/2005, C#, Business Objects, Visual studio 2010, MS Access, MS Excel, MS Office Access 2010

AT&T - Atlanta, GA July 2008-November 2010

Business Intelligence Developer 2+ Years

Data Migration

Designed, performed analysis, development, testing and implementation of universes in Business Objects.

Creation of reports in Crystal Reports XI from data warehouses

Creation of canned /Ad Hoc Reports using Business Objects designer, Web Intelligence, Crystal Reports and Crystal Xcelsius tools.

Clinical modeling in SAS

Developed client-specific reports in Crystal Reports VIII-XII as well as daily ad hoc and development tools and deployed them using Crystal Server and Visual cut scheduler.

Creation of reports and Dashboards using MicroStrategy 7.i/7.5/8.0/8.1/9.0/9.0.1, Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MDX Adapter, Office, MicroStrategy Intelligence Server and MicroStrategy Architect.

Maintenance of standards in reporting per client requisition

Liaised with end users and directors to develop user requirements document.

Use of SSIS and SSRS tools for information management.

Integration of Data using SSIS wizards and subsequent creation of reports in SSRS.

Management of OLAP cubes in SSAS

OLAP/Report Model Design & Advanced SQL/MDX Development

Incremental cube refreshes, Dimensional security Implementation

Use of MDX queries for ad hoc information against hospital cubes

Dimensional modeling and analysis of architecture.

Use of Aggregation to streamline performance of BI tools

Used Report Definition Language to generate reports in Excel and PDF formats.

Web and application analysis to highlight critical success factors.

Subject matter expert/Ensured Business Intelligence best practices per client.

Development, oversight and organization of databases in SQL 2008

Environment: SSIS, SSRS, MS SQL Server 2008/2005, Business Objects, Microstrategy, MS Access, MS Excel, MS Office Access, SAS

Ajilon Consulting - Atlanta, GA March 2008-July 2008

Business Objects Developer /SQL Analyst 5 Months

Iterative Root Cause Analysis

Trend estimation from data extrapolated using MS SQL Server 2005 to isolate heterogeneous sample data.

Data Mastery/Data Management of using SAS methodologies

Interviewed subject matter experts and individual users to develop requirements.

Drafted clear written documentation for users and DBAs.

Liaised with physicians and directors to develop user requirements document.

Performed research that lead to the understanding of past and prevention of repeated query lag and server unavailability. The documentation of this outcome became an addendum to new employee training.

Process Improvement by documenting the steps of installing and configuring Crystal Enterprise for the Network administrators to build the servers when new releases became available.

Streamlined the reporting process for the State of Missouri by the creation and maintenance of Pay for Performance data and ad hoc reports.

Use of Report Manager in SSRS for the development and delivery of Ad-Hoc reports.

Data mining and Data dredging using queries and SAS to define and analyze data.

Creation of web-accessible dashboards in Crystal Reports derived from Access Database.

Creation of interactive dashboards for dynamic data.

Loaded Data Warehouses in ETL/maintenance of ETL reporting processes.

Migrated data from MS Access and Excel databases into Crystal Reports.

Repaired the State of Missouri Database and simplified its reporting with the creation of Transact SQL queries, stored procedures and triggers for real time analysis of Provider metrics and Medicaid member eligibility.

Involved in complete life cycle of the project from interacting with end users right to collecting requirements to production support.

Performance of data modeling, movement and management.

Performed implementation and maintenance of reports and Web applications pulling from MS SQL database applications.

Migration of Hospital data from Seagate Reports VIII to XII as well as updating code on a client specific basis.

Developed client-specific reports in Crystal Reports VIII-XII as well as daily ad hoc and development tools and deployed them using Crystal Server and Visual cut scheduler.

Support of Human Capital Management (HRIS) and state-specific applications.

Extensive Use of Query analyzer in MS SQL 2005 and MS Access for performance tuning.

Examined Crystal Reports parameters and dependencies to evaluate efficacy of report formulas.

Streamlined reporting process for Hospital subsidiaries to meet company metrics.

Assessed subsidiary profiles and rebuilt reports to include exempted data.

Ground up design of Client Database.

Cumulative servicing updates for Microsoft .NET subcomponents.

Queried relational data and stored results in XML formats.

Developed cube schema in OLAP and Access and maintained ETL and EDI programs.

Environment: Crystal Reports/Business Objects, SSRS, MS SQL Server 2008/2005, MS Access, MS Excel, MS Office Access

IBM - Atlanta, GA November 2006-March 2008

GSSC Systems Specialist/Crystal Reports Developer 16 Months

Performed proactive iterative analysis .

Defined causal relationships between client problem and brand performance using web-based tools.

Use of the "5 Whys" to establish root cause.

Use of Six Sigma methodologies for process improvement by elimination of variance in Blade system support.

Documented and analyzed consumer needs to improve usability of devices.

Used Business Objects and SSRS software to create reports to analyze the routing of ACD data to streamline tasks for 3000, 5000, and Blade systems.

Maintenance of mainframe topologies and application virtual machines in .Net framework.

Consistently topped IBM metric by exceeding 91st percentile for call queuing models.

Used self guided Algorithms to analyze parsed data for bug labs and Server errors.

Long Distance Data Distribution of registry and error and process information.

Creation of multi-variable dashboards in Xcelcius.

Creation of reports and analysis of data in Cognos.

Loaded Excel Data into Xcelcius to build 'what if' models.

Ensured requirements traceability for all deliverables.

Modification of existing functionality within SAP framework.

Provided Web Analysis of end user downloads and client support requests to maintain company best practices.

Used Business Objects Enterprise system for hosted shared data to create reports for regressive data to analyze, explain and prevent repeat downtime for client servers. Also maintained channel report analysis across companies 4 zones.

Optimized Crystal Reports IX performance for large reports.

Installation and maintenance of firmware.

Memory management and security maintenance of .NET virtual machines/mainframes.

Performed Linear Regression and devised strategy in SAS for Customer Relationship Management.

Sourcing and Management of data in SAS 9.1.3

Analyzed real time reporting of inventory, supply side data and warranty information.

SQL Database/data layer development including reporting, analytics, stored procedures and database optimization.

Environment: Crystal Reports/Business Objects, SSRS, MS SQL Server, SAS, MS Access, MS Excel, MS Office Access

HEWLETT-PACKARD - Atlanta, GA 2004-2006

Business Analyst 2 Years

Regressive Analysis of Company/Vendor data to streamline sales processes.

Development, unit testing and maintenance of custom end user reports in Crystal Reports VIII and SSRS.

Documenting and analyzing consumer needs to improve usability of devices.

Trained salespeople at multiple locations on standard process.

Certified in the troubleshooting and use of all current HP PCs, Laptops, Printers and Digital Equipment

Environment: Crystal Reports, SSRS, MS SQL Server, MS Access, MS Excel, MS Office Access

OITC - Atlanta, GA 2000-2005

Systems Specialist 5 years

Responsible for the research, planning and use of processes and software to analyze and meet company needs.

System based root cause analysis of intranodal and network functionality to streamline helpdesk performance.

Installation and maintenance of several hundred node network. Integral in campus-wide move to Windows 2000 and then to Windows XP. Configuration of servers within domain, knowledge and performance in TCP/IP topologies, LAN, WAN, configuration of GHOST protocols and the creation and maintenance of images, terminal server, routers.

Provided technical phone support for end users. Successfully resolved customer issues regarding connectivity, peripheral compatibility, and standard software usage questions for products for: Windows XP, 2000, NT Server, Windows NT Workstation, Windows 95, Windows 3.x, MS-DOS and Mac OS.

Use of Banner Power Campus for support of university topologies including HRIS, student, registration and financial aid.

Maintenance of Banner Portal for location specific reporting and student centered processes.

Creation and support of knock down thin client topologies.

Created daily ad hoc reports using Crystal Reports VIII and Microsoft reporting services.

Creation of Active X controls and objects in as well as GUI's to enhance end user support in Visual Basic. Supported 35 routers (CISCO 3800 and 7200 series) as well as HP ProLiant/tc Series and HP Blade System Servers.

Successfully delivered LAN/WAN/telecommunication connectivity and security.

Maintained network connectivity and equipment implementation, integration, and troubleshooting for servers, routers, remote access, storage devices, and printers.

Administered MS Exchange e-mail system and Internet Information Server to meet all management and employee requirements.

Collaborated to create a SharePoint Portal for University end user Support

Use of SQL Server 2000 including stored procedures, views and triggers for database support.

Environment: Crystal Reports, MS SQL Server, MS Access, MS Excel, MS Office Access

Education

CLARK ATLANTA UNIVERSITY- Physics, 1997-2001



Contact this candidate