Sameer Ashfaq Email & Phone Number

Team lead to define data delivery protocols and processes.Involve in defining and implementing Big Data BI reports and data marts.Define SQL syntax against Cloudera Impala, to pull data from Hadoop for reporting needs.Create and maintain Tableau reports based on Big Data requirements.Collaborate in defining how Big Data should look for Datawarehouse team.Create an end to end solution using DataStage for MonthEnd Process including Invoicing and reportingCreate and maintain Oracle PL/SQL for all reporting needs.Work with ETL team to provide solution is loading external data.Collaborate with business users to meet their reporting needs.Provide level 2 support for all BI reporting needs.Work with data architect to help enhance data warehouse objects.Administer and maintain all in-house applications that are used for processing and posting reports.Collaborate with other teams to stand up new BI infrastructureEstablish a BI process and security measures for daily and monthly reporting needs.Architect BI security solution working closely with network team.Develop new report solutions based on company objectives.Maintain and update existing reports based on customer requirements.Provide BI training to end users on new BI technologies.Develop MSSQL stored procedures to be implemented with new BI reports.Migrate and convert MSSQL stored procedures to Oracle PL/SQLCreate and maintain month end reporting process and reports. Maintain and update MS Reporting Services Reports.Create new Cognos Cubes based on Cognos Framework Models.Implement reports based on new BI technologies such as Active Reports.Develop proof of concept for report bursting and mobile solutions.Provide data analytics.Manages contractors who were hired to assist with BI projects.

Collaborate with integration teams as a Subject Matter Expert (SME) on Cognos 8 Installed Cognos 8 on IBM AIX servers in both single and distributed design architect.Team lead on Cognos 8.4 upgrade. To meet the OLAP reporting needs of new projects, we upgraded the environments from Cognos 8.3 to Cognos 8.4. Cognos 8.4 offered PowerPlay capabilities that would meet the OLAP reporting requirements. As lead on the upgrade I ensured that all mandatory steps were executed and documented. System and regression testing were done with successful results to ensure that the production environment is stable.Developed and implemented a non-STAR schema Cognos 8 Framework Manager model to meet customer reporting requirements. Developed pre-defined queries within Cognos 8 Framework Manager model that addressed ad-hoc reporting needs of the project. Created and deployed model level filters to meet and/or exceed customer expectations.Troubleshoot and provide support on Cognos Reports and PowerPlay cubes developed in Cognos Series 7.Developed a home grown application to improve the security process for Cognos 7.Re-authored ReportNet reports to Cognos 8 using Query Studio and Report Studio.Partner with database team to resolve data and security discrepancies.Partner with UNIX team on servers maintenance and implementation of Cognos troubleshooting tools.Partner with business users and analyst on report retirement and data archiving. Helped establish year end reporting processes for sales force team.Collaborate with Cognos support to troubleshoot challenges that surface during model and report design phase of a project. Develop reports using Cognos Query and Report studio.Helped establishing Business Intelligence Competency Center (BICC). Collaborated in creating documents for tool matrix, install guides and admin guide and best practice guide.Work with business analysts to determine new business processes and enhance existing ones.

Developed an application in Microsoft Visual Basic 2005 for data extraction and customer billing.Implemented DTS packages in SQL Server for data warehousing projects. Developed an in-house billing application leveraging SQL Server and SQL Store Procedures to automate medical claim payments.Provided level 2 support for claims and financial applications. Deployed Crystal Report v11 (Server Edition) and converted reports built in Crystal Report v8 to Crystal Report v11. Provided user training on new report. Authored documentations on reporting and other in-house processes.Developed and Implemented VB scripts on data conversion from Diamond claims application to GBAS claims application.Collaborated with GBAS vendor to ensure accurate data conversion. Processed reports using Cognos Impromptu from GBAS claims application.Developed application/script that would replicate or enhance multiple processes on GBAS. Developed scripts in MS-VBA for replicating Cognos Impromptu Reports from GBAS.

Provided maintenance on Clientele 7.0 CRM application.Developed new features and forms in Clientele CRM application. Developed an online web interface for HJS customers to work with Clientele. Worked on migrating data from CRM application to an ERP application (Softrax) Developed and implemented new reports in Crystal Reports v10. Maintained existing reports developed in Crystal Report v8.5.Implemented installation of Crystal Enterprise v10 on Windows 2003 Server .Developed applications in VB or ASP to meet business needs. Developed database applications using MS Access 2000 for rapid application deployment.

Developed and designed a custom billing application in MS Visual Basic 6.Developed and designed custom database in Oracle 8i for the billing application.Worked with MS SQL 2000 Server on implementing a new billing system (Platypus).Worked on Fox Pro as the front end for MS SQL 2000.Designed and created ERD, DFD in Oracle 8i.Maintained Oracle database and in-house billing application.Developed and designed reports and invoices for customers using Crystal Report 8.5. Converted and Imported data from MySQL and MS Access databases into Oracle8i. Maintained existing databases built in MySQL and MS Access .Maintained and enhanced billing system in ASP and PHP. Enhanced the in-house billing application by developing new features.Created and designed dynamic reports in PHP for accounting. Collaborated with team members on networking issues and hardware configurations. Troubleshoot customer related issues with web mail and dial-up connectivity. Provided level 2 support to Customer Service and Tech Support.

Designed and developed an equipment tracking database using Access 2000 Maintained and added additional features to existing databases

Managed operations for a better environment and service for the customers Supervised fifteen student employees Balanced and deposit daily cash receipts

exams and assignments for introduction classes to Computer Science Developed homepage for Dr. Hamed Sallam

Performed troubleshooting for Windows 95/98, Office 97, and other software

B.Sc, Computer Information Science

Computer Science

Bachelor Of Science (Bs), Computer Science