Data Software Developer

Nadeem Bashir

Kitchener, ON 416-***-**** ******.********@*****.*** LinkedIn: https://www.linkedin.com/in/nadeem-bashir

PROFESSIONAL SUMMARY

w20+ years of experience in Systems Analysis, Application Software Design, Development, Coding, Maintenance, and Application Support; 2 years of experience with ServiceNow platform in developer, configuration and administration.

wTeam Lead with an end-to-end grasp of the software development life cycle (SDLC), including Analysis, Design, Development, Coding, Testing, and Maintenance of software applications.

wHands-on experience in database designing, programming, reporting and complex queries, data modeling and stored procedures using Oracle 10/11g, Oracle Designer and MS SQL Server 2005/2008/2016.

wCurrent experience in ASP.NET, VB.NET, VB6, C#, SQL, T-SQL, PL/SQL, CSS, HTML, XML, Crystal Reports, SQL SSRS, SSIS, Power BI, Excel, Access, Visual Studio, SAS, BizTalk (2006/2010) and Automation Anywhere (AA).

wProven experience in legacy systems, including COBOL, Powerhouse, QTP, QUIZ, Qdesign, OpenVMS and DCL.

wSelf-motivated and independent team player who utilizes interpersonal and communication skills to work in harmony with others with minimal supervision and contributes to group relationships and effectiveness.

wWell-demonstrated problem solving and analytical thinking skills with great attention to detail in recognizing and resolving issues. Strong Project Management skills.

PROFESSIONAL EXPERIENCE

Manulife Bank

Development and Reporting Consultant Nov 2017 – Sep 2020

Designed, coded, and supported software solutions with a focus on scalability, depending on client needs using ASP.net, HTML, CSS with source code in C#. Leading the software upgrades BSD Connect application using C# and SQL

Support in systems design and architecture in business systems applications, Business Intelligence, Reporting, web programming, data extracts, and systems interfaces.

Built and managed data feed from various sources and created reports for BSD, CX Reports and KPI Reports.

Build and automated reports from Excel, SAS to SSRS/SSIS through reverse engineering.

Created and Maintained SSRS reports. Created report dashboard.

Created monthly stats and KPI reports from various sources in SSRS and BI for senior managements.

Scheduled automatic refresh and scheduling refresh in power BI service.

Developed Power BI model used for financial reporting. Developed SQL stored procedures and data sets for SSRS.

Created stored procedures and SQL queries to pull data into power pivot model.

Created SSIS packages to import data from excel, XML, OLE DB source and text files.

Collaborate with your partners to gather and analyze business requirements to develop new BI Applications.

Manage, investigate, and resolve data quality issues in enterprise applications.

Provide recommendations for appropriate methodologies for migration, cleansing, execution management

Performed data mining, drawing correlations within datasets.

Interacted with stakeholders to understand requirements and investigated application/data/reporting issues.

Investigated and resolved application functionality related issues and provided support and troubleshooting.

Performed ad-hoc data extraction from SQL server and Oracle data barn and developed reports as required.

Developed business cases for automation and RPA solution; Developed automation processes by creating BOTS in Automation Anywhere (AA).

Technologies: ASP.NET, C#, SQL Server2012, T-SQL, SSRS, SSIS, SAS, Visual Studio, Report Builder, Power BI, QlikView, Excel, Macros, JIRA, Confluence, SAS, XML, JavaScript, Oracle Databarn, SharePoint, RPA, Automation Anywhere, Process Robot.

SOROC Technologies

Senior Software Developer/Analyst Apr 2013 – Jun 2017

Developed, tested, maintained and supported of software applications utilizing various technologies, including VB.NET, C#, VB6, ASP.NET, Crystal Reports, Visual Studio 2010, and T-SQL.

Migrated legacy VB6 application to VB.NET web-based solution.

PROFESSIONAL EXPERIENCE - CONTINUED

Senior Software Developer/Analyst - Continued

Gathered, reviewed and analyzed user requirements, completed data and process modelling, systems design, implementation and test planning for systems, recommending optimum solutions.

Worked with internal/external clients (Scotia Bank, CIBC and Canadian Tire) to design/develop/implement solutions.

Provided technical analysis and guidance for production-related issues.

Build integration for various applications using BizTalk. Build Orchestrations, Schemas and Maps.

Migrated Applications from BizTalk2006 to BizTalk2010; configured and mapped EDI transactions (850, 856, 810).

Migrated SQL 2000 legacy databases to SQL 2008 to optimize performance.

Set up the Report Server and moved the existing SQL 2005 reports to Server using SSRS.

Developed Web Services using WCF framework and VB.NET for share data with external applications.

Investigated and resolved application functionality related issues and provided support and troubleshooting

Configured and customized the ServiceNow Application as per business requirements; developed UI actions, scripts, business rules, notifications, SLA workflow and update sets.

Developed system integrations and process automation within ServiceNow and other applications using web services.

Technologies: ASP.NET, VB.NET, C#, VB6, SQL Server2005/2008/2012, T-SQL, MySQL, Biztalk2006, Crystal Reports, SSRS, SSIS, Visual Studio, JavaScript, JSON, XML, ServiceNow, JavaScript, CSS, HTML, Web-Services, SOAP, WSDL.

The Regional Municipality of Durham

Systems Analyst Jun 1997 – Mar 2013

Maintained and enhanced various legacy applications in COBOL, Powerhouse, and VAX/VMS environment.

Supported, maintained and enhanced Payroll and HR system using Cognos Powerhouse and COBOL.

Developed various web-based and desktop business applications in ASP.NET, VB.NET and C#.

Worked as Team Leader to develop a web-based application using VB.NET and Oracle at the backend.

Migrated legacy HR and Payroll applications to PeopleSoft HCM.

Migrated code from VB6 to VB.NET and applications from Visual Studio 2003 and 2005 to Visual Studio 2010.

Developed various reports such as drill down reports, parameterized reports, sub reports, link reports, and matrix reports using MS SQL server reporting services.

Integrated Lagan CRM with symphony CMS via web services (SOAP) so that requests for services made through the website could be logged as cases in Lagan CRM.

Completed analysis and detailed system design and specifications for enhancement requests and interface.

Developed functional specifications and user interfaces for new functionality and obtain user sign off.

Defined business requirements and develop user acceptance testing strategies, test plans and execution in support of small to medium projects.

Technologies: COBOL, Powerhouse, VAX/OpenVMS, DCL, ASP.NET, VB.NET, VB6, C#, SQL Server2005/2008, SQL, Oracle10g, PL/SQL, HTML, XML, Crystal Reports, BI Reports, Visual Studio, VSS, Web Services, IIS, CSS, JavaScript, SharePoint 2007.

Previous Experience

University Scholarship Trust Foundation

Senior Programmer 1996 – 1997

Canadian Scholarship Trust Foundation

Programmer Analyst 1992 - 1996

EDUCATION & TRAINING

Diploma, Computer Programming University of Information Technology, Durham College

Course Name, Organization Course Name, Institute Course Name, Institute

Contact this candidate