AAKASH MALIK

** ************ ****

Dartmouth, NS, B2W 0J6

204-***-****

ac6eta@r.postjobfree.com

Summary of Experience: 5.5 Years of Experience in Information Technology and a wide range of progressive

experience in providing product specifications, design, analysis, development, documentation, coding, testing and implementation of the business technology solutions.

2 years of experience working in an application support and development environment on Microsoft Dynamics NAV ERP. Complete understanding of support processes and experience of their implementation and usage in an application support scenario.

Cognos Certified Professional with 4 years of working experience in Cognos BI tools using Cognos Framework Manager, Report Studio, Query Studio, Analysis Studio, Power Play Transformer, Impromptu Web Reports (IWR).

Proficient in designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 10/8/7/6, Cognos Report Net and Oracle ERP. Strong Experience in analysis, design, testing, development and implementation of various aspects of Data Management.

Strong complex reporting skills – complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports, Dashboard Reports in Cognos 8 and 10.

Extensive Experience in writing SQL, PL/SQL Packages, Stored Procedures, Functions, Triggers, Cursors as per the business needs.

Interacted with Customers for requirement gathering and experience providing end-user training.

Strong experience in client interaction for requirement gathering, effective analysis and understanding business applications, business data flow and data relations from them.

Experience with agile development methodology and Waterfall.

Experience developing, maintaining and analyzing business intelligence to determine trends and discrepancies for a fast paced, deadline oriented and quality focused environment.

Excellent communication and interpersonal skills.

Quick learner, self-motivated and results-oriented Professional with exposure to the four fundamental actions of data analysis: collection, transformation, analysis and presentation.

TECHNICAL SKILLS:

ERP:

Microsoft Dynamics NAV 2005/2009/2016/2017/2018 (Product “Wave”)

BI Tools:

Cognos 10/8/7/6 tools (Report Studio, Analysis Studio, Query Studio, Cognos

Connection), Framework Manager, Cognos Impromptu, Power Play Transformer,

Report Net 1.02/1.1, Impromptu Web Reports (IWR), Access Manager, Noetix

Databases:

MS-Access, Oracle 11i/10g/9i/8i, SQL Server 2016/2014/2008/2005/2000

Languages:

VB.NET, HTML, DHTML, Java Script, PL/SQL, C#, PowerShell, C/AL

BI/Reporting Tools studied:

BI Tools – SAP HANA, IBM Watson, SAP Lumira, SAP Business Objects, Micro Strategy

Operating System:

MS-DOS, Windows 10/8/7/VISTA/XP/2000, Unix

CERTIFICATIONS:

IBM Cognos 10 BI Author- IBM Professional Certification

International Software Testing Qualifications Board (ISTQB)

PROFESSIONAL EXPERIENCE:

Maritech Dynamics Ltd., Halifax, NS, Canada

Oct 2016 – June 2018 (1.8 Years)

Aug 2015 - Dec 2015 (4 Months)

Software Developer/ Business Analyst:

Wave & Microsoft Dynamics NAV: Maritech Wave is a complete seafood software solution fully built within Microsoft’s Dynamics NAV ERP.

Managed full life cycle implementation of Microsoft Dynamics NAV as well as supported the upgrade.

Analyzed, planned and designed the custom solutions as well as enhancements to fit the client’s specific requirements.

Monitored, coordinated and respond to support incidents as per SLA’s to fulfill Service Requests.

Supported ongoing service requests and support calls to users.

Performed root cause analysis of system defects and provided the fix as and when needed.

Demonstrated and trained the users for the custom functionalities.

Extensive experience working closely with clients and providing work estimations.

Technology/Language Used: Microsoft Dynamics NAV, C/AL, SQL Server 2016

Dell Software Canada, Halifax, NS, Canada

Aug 2015 - Dec 2015 (4 Months)

Software developer Intern(Co-op)

Projects:

Software Product Validation Tool

Implemented functionality to count number of lines of code per project/solution for Dell Products Source Code in Visual Studio.

Created the tool output to be generated in XML Format so that it can be incorporated by other internally used utilities.

Database Anonymizer Utility

This utility was created to anonymize the data present in Dell Change Auditor Database. Change Auditor allow user to get complete, real-time change auditing, in-depth forensics and comprehensive reporting on all key configuration, user and administrator changes for Active Directory, ADLDS, AD Queries, Exchange, SharePoint, Lync, VMware, NetApp, Windows File Servers, EMC, and SQL Server.

Technology/Language Used: Visual Studio 2013, Microsoft .Net Framework, C#, PowerShell Scripting, XML, SQL Server 2015, PL/SQL

BirlaSoft (India) Limited – India

Aug 2011 - Aug 2014 (3 Years)

Software Engineer – Cognos Developer

Client – General Electronics (GE, United States)

Project #1: Global Sourcing Data warehouse

Global Sourcing Datwarehouse was a technology upgrade and maintenance project. It involved upgrade of Informatica & Cognos were being used in the current application. Informatica 8x and Cognos 7 versions needed an upgrade to Informatica 9x and Cognos 8.4 version. It also had to introduce Noetix as a third-party tool to extract data from the Sourcing business ERPs.

Participated in planning for migration plan including Informatica Mappings, Cognos Reports and Database to be migrated.

Created a training document for the users guiding them how to install new version of Cognos.

Created a dashboard in GE’s own repository known as Support Central to monitor the progress of Cognos upgrade.

Worked on creating new Informatica database connections for the changed environment and ensuring the smooth run of Informatica workflows.

Worked along with the Informatica and Database team in defining the cubes, dimensions for Cognos Reporting.

Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and worked on the customization of prompt parameters.

Involved in extensive use of conditional formatting while developing reports in Report Studio.

Created List Reports, Cross tab Reports and Control Charts.

Worked on Test Plans, Test Cases and setting up Test Data for Reports Validation. Also, was responsible for execution and recording test results using HP Quality Center. Involved in Unit and Integration testing.

Technology/Language Used: Informatica 8x/9x, Cognos 7/8.4, Oracle ERP, PL/SQL, Report Studio, Query Studio, Analysis studio, Metric Studio, Frame Work Manager, Oracle 9i, Noetix.

Project #2: GE Energy - Sourcing Analytics Portal

This project was to implement a single point reporting portal for GE internal reporting purposes. GE had various sourcing businesses using different ERP systems in place such as Oracle ERP, SAP, and BAAN etc. Using Informatica data was extracted from different databases and loaded into a single Oracle database which was used for Cognos Reports.

Worked on canned reports (Purchase order reports, Accounts payable reports, Invoice reports, Inventory reports etc.)

Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.

Worked on Custom (ad-hoc reports) requested by various business units.

Created Dashboards to present critical company data in a single report.

Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio.

Experience in developing Framework Manager Models and analyzed those models in analysis studio.

Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.

Extensive experience on Structuring Metadata and Cognos Models using Framework Manager.

Technology/Language Used: Informatica 9x, Cognos 8.4, Oracle ERP, PL/SQL, Report Studio, Query Studio, Analysis studio, Metric Studio, Frame Work Manager, Oracle 9i, QlikView

Project #3: Software Governance

This project focused on finding discrepancy and non-compliance of the software installed on the machine assigned to the user as per their entitlement defined by GE Data Governance team.

Designed, Developed and maintained the software governance tool used by GE to carry out the scan on all the machines throughout the whole organization to get the information about software installed on each machine assigned to specific users.

Responsible for writing the database scripts (Functions, Stored Procedures) to Import the scan data to the database and compare the scan data against the master entitlement data to verify if users have all the software installed on their machines as per their entitlement and to verify if users are utilizing all the software installed (License) on their machine.

Worked on the Post Assessment actions through sending User Queries using Mail Merge and Workflow and Follow-ups. This was needed to let users know if they need to uninstall any software from their machine because they were either non-compliant or not utilizing the license of the software or not entitled.

Technology/Language Used: VB.NET, Microsoft SQL Server 2000/2005/2008, MS-Excel, MS-Access

Hughes Communication India Limited– India

April 2010 - July 2011 (1.3 Years)

Software Developer – In House Development Projects

Project: Custom Central and Reporting System Modules.

Customer Central module was to develop a website through which customers can manage all the services provided to them from Hughes Communication. Reporting System Module generated the usage reports for each customer site. This system queried INGRES database and write the data to the text file which then FTP to the local server. The data then uploaded to the database & reports would be generated as per the requirements.

Technology/Language Used: ASP.NET, VB.NET, C#, Microsoft SQL Server 2005/2005 and Crystal Reports 9

EDUCATIONAL HISTORY

2014-2016

Masters of Electronic Commerce (MEC)

Dalhousie University, Halifax, Nova Scotia, Canada

2006-2009

Masters of Computer Application (MCA)

Uttar Pradesh Technical University, Lucknow, India

2003-2006

Bachelor of Computer Application (BCA)

Chaudhary Charan Singh University, Meerut, India

Contact this candidate