SUMMARY:

Seeking the role of a SQL Engineer or Sr Data Analyst at a reputable company where I would put to use the knowledge gained in the field of Data Analytics as well as my technical aptitude.

COMPUTER SKILLS:

Confidential SQL Server. SSIS, SSRS, SSAS, Business Intelligence Development Studio, Data Modeling, SAP, T - SQL, PARS, PC and Mac Literate, WordPerfect, Power BI, MS Word, Allscripts, MS Access, MS Excel, MS PowerPoint, Publisher, EMR software, CorDaptix, Confidential Expression, Alice2, Azure data lake, Outlook, Internet Explorer, Salesforce, Tableau, Google Analytics, HTML, JAVASCRIPT, Big Data, Teradata, Data Visualization.

PROFESSIONAL EXPERIENCE:

Sr Digital technical analyst

Confidential

Responsibilities:

• Ensuring data integrity using SQL and CRM (SAP). Implementing database security and permissions.
• Extracting data from Azure Data Lake for querying. Ensuring Data integrity by cross referencing between SAP and SQL Server.
• Creating Ad Hoc reports using Power Pivot and SQL Server.
• Documenting analysis, designs and results. Performing data analysis in various applications.
• I am the Subject matter expert of business data, database structures and reporting.
• Leading several projects simultaneously while maintaining SLA on my workload.
• Analyzing and developing new schema and code for supporting various stages of technical requirements.
• Often meet with internal customers to understand data requests, work with them to identify and close requirements gaps. Analyze data for discrepancies and inconsistencies such as duplicates.
• Use SQL or PL - SQL to retrieve, test and deliver data in a timely and efficient manner.
• Create technical documentation for a data request on an as-needed basis.
• Identifying opportunities for creating new analytics data structures to improve efficiency
• Coordinate code reviews with Jr analysts to ensure quality of data.
• Scheduling and automating repetitive processes related to data and analytics.
• Integrating new and existing reporting into an automated production system.
• Assisting in the conversion of legacy reporting to new formats as enterprise reporting platforms are upgraded.
• Working with the data architecture team to ensure that data models support the reporting needs of the business.
• Works with the business to determine reporting schedule and production SLAs

Sql server support engineer

Confidential

Responsibilities:

• Troubleshooting system, software, and networking problems
• Reproducing customer issues in a lab environment
• Contributing documentation to internal and customer facing knowledge base systems
• Creating escalation requests and submitting product defect reports to Engineering
• Testing of patch releases and product updates
• Create test automation jobs using Excel.
• Serving as an advanced technical resource for customers
• Communicate with business clients via telephone and written correspondence regarding technical questions and issues related to SQL Server technologies.
• Resolve SQL Server issues related to TSQL programming, data integrity/corruption, backup/restore, setup/upgrade and add/remove components, Database mirroring, Cluster failover analysis, hangs or unresponsive servers, SQL Server administration tools, auditing issues, database maintenance plans and exceptions (access violations/AVs,) related to SQL Server for SQL On-Premise and in Windows Azure Virtual Machine (IaaS) environments.
• Providing a high level of technical support for SQL engine performance (plan forcing and plan guides, index tuning, query plans/tuning), performance tools (profiler, Nexus, SQLDiag, Database Engine Tuning Advisor), concurrency (locking), memory and SQL OS (SOS). Also supports replication, memory, service broker, DTS, notification services and full text search for SQL On-Premise and in Windows Azure Virtual Machine environments (IAAS). Aspx
• Serving as an expert related to issues internal to Azure SQL Database (including customer databases on Premium SKU). Including query performance, TSQL syntax, query performance, throttling, Management Portal, Management Studio, administration, data loss, failover and customers using the Import/Export service plus BACPAC errors.

BI developer/ Sr data analyst

Confidential

Responsibilities:

• Initiated the use of SQL Server to manipulate data using T-SQL. Analyzed Big Data in Blue Sky.
• Used Power BI Desktop and Service to analyze data and provide reports.
• Queried over 1mm lines of data daily. Created macros in Excel to automate certain processes.
• Automated the initial data analysis process to make it more efficient.
• Worked daily in SAP (CRM) to update customer data and ensure accuracy.
• Build databases in SQL Server and Access. Create Packages in BIDS. Data Modeling.
• Designed and planned BI solutions using SSIS for ETL and SSAS for analysis.
• Debugged, monitored and troubleshooting BI solutions
• Creating and deploying reports using SSRS. Provided Data Visualization with SSRS.
• Writing relational and multidimensional database queries
• Configuring, deploying and maintaining database servers
• Compare data gathered from bottlers in MS Access with accounts in CRM to confirm accuracy of information.
• Create and maintain databases in access.
• Analyze bottler sales information to create forecasting models.
• Create queries and tables in Confidential access and SQL Server in order to perform mass data comparisons.
• Research and analyze customer data to correct discrepancies.

SR master data analyst

Confidential

Responsibilities:

• Identify and collect data associated with the configuration management system and maintain
• Implemented SQL Server and used T-SQL to improve data analysis.
• Worked in SAP daily to update Licenses and handle case issues from SalesForce.
• Updated customer accounts with all data needed in order to bill correctly.
• Track and update expiring medical licenses using MediTouch and other software.
• Collect, compile and analyze complex information and data, specifically related to licensing.
• Analyze customer service case data in Tableau and other data sources and provide insights and recommendations to improve efficiency. Used Tableau for data visualization.
• Support the administration of task requirements, configuration change control and configuration management as required.
• Perform routine configuration management tasks.

Billing/QA analyst

Confidential

Responsibilities:

• Research and analyze un-invoiced contracts and perform corrections, including re-bills, adjustments, and clearing of transaction and billing failures.
• UAT testing for various system applications. Performed V-lookups, Pivot tables, UAT testing using Excel.
• Billed over 30,000 customers monthly. Texas electric market research
• Utilize outputs from MS Access databases and Excel spreadsheets to manually create bills and invoices.
• Collection of delinquent accounts.
• Used CRM (SAP) to solve BPEM cases and correct invoices.
• Created balance sheets and invoices.
• Resolved billing exceptions produced in nightly batches by CARE (including questionable meter readings or accounts with non-billable status)