| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Jericho NY Street Address
Tel: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLEEDUCATION New York University, NYB.S., Computer ScienceSKILLS Software: Microsoft Office, My SQL, SQL Server, Domo, Dashboard, Macromedia Flash MX, Dreamweaver MXOperating systems: Unix, WindowsProgramming languages: SQL, FrontPage, HTML, JavaCERTIFICATION CompTIA A+ Certification professional operating systemCognos 8 BI Report Authoring Part 1& 2Cognos 8 BI Metadata Modeling Part 1 & 2EXPERIENCE6/2013-Present Modivcare Corp, NYData AnalystWorking with various teams within the organization to maximize productivity and optimize operations. Present data from all groups to executives to gauge business operation health and productivity. Gather data, track system performance, and provide analysis to recommend necessary changesTechnical tasks including:Write queries in SSMS / My SQL and performing ad-hoc analysisCreated Packages using Execute SQL Task, Data Flow Task and automate the import and export of data in SSIS ETL toolDeveloped SSIS packages to transfer data across heterogeneous data sources (Excel, Flat File), Import data from SQL into excel to generate reportsEstablished a connection between Excel and SQL Server to automate data population throughout ExcelDeveloped and automated data bridge between HHAeXchange and ADPCreated MS Access database with ODBC connection to data warehouseImplemented and optimized stored procedures in SQL server, performed SQL query tuning, and developed test scripts for store procedure validationImplemented stored procedures using SQL server, involved in writing SQL-stored procedures for database transactions and performed SQL query tune up, developed test scripts to test stored proceduresLed Domo implication and development initiativesEnvironments: Windows, HHAeXchange, HHAeXchange AWS, SQL Server, Microsoft Suite5/2004-5/2013 Time Warner Cable, NYTechnical AnalystWorked with teams across the organization to understand their analytics need and produce dashboards and analytics solutions that allow them to execute more efficiently. Work with business executives to define key metrics and build reporting to monitor performance along those metrics. Reconciled discrepancies in reports by validating data, support and analytics, resolving end-to-end data quality issues that impact businessTechnical tasks including:Created and generated regionalized ad-hoc reports, PivotTables, macro, excel functions, charts, models and queries for all regions using Cognos ReportNet, excel, Access, Visio, Word and Power PointPeopleSoft reporting-General ledger, query reporting and creation, Account Payable reporting, OPEX reporting, P&L reporting, analysis of financial dataEnter PRs, track and review POs for different accounts from PeopleSoftSupport Business Operations and Capital Management teams to ensure the overall efficiency of reporting across business units.Aggregated data from all Network Operations and Engineering group and generate finance and engineering reports for senior managementCommunicated and presented departmental financial results and findings to company upper management and various departmentsCreated and analyzed daily, weekly and monthly reports on productivity, service calls, repeat calls, and equipment using Cognos ReportNet and Score Card PMT applicationsUtilized the Manpower Access database and synchronized the data with WorkAssure(Arris) and PeopleSoftMonitored, analyzed and performed quality controls on operational data and assigned projectsPrepared Business Requirements documents (BRDs), defined project plans and wrote system requirements specificationsOptimized and maintained existing reports, database and queries using Cogons and AccessUtilized the CSG billing system to analyze data as a quality controlDSAM server administrator, DSAM meter quality controlCoordinated with field managers running diagnostic test on customer equipmentPerformed diagnostics using various measurement tools (CMIT, NSM, OMSE, Stargus, Set top Diagnostics )Troubleshooting of problems with customer equipmentProvided knowledge of all analog and digital information, policies, and proceduresEnvironments: Windows, SQL, Cognos, Microsoft Suite, CMIT, NSM, CSG, ARRIS, INR, OMSE, Stargus, Set top Diagnostics, Score Card PMT, Big Brother, PeopleSoft8/2001-4/2004 Hotelsroom.com, NYWeb DesingerTranslated users need into technical specificationDeveloped website using Macromedia Flash MX, Dreamweaver MX, Photoshop and HTMLCreated users manual for applications being implemented onto the live siteInstalled and updated software; upgraded existing computersCreated documents and presentations using Microsoft OfficeEnvironments: Windows, Microsoft Suite, Macromedia Flash MX, Dreamweaver MX, HTML |
