SUMMARY

• 17 Years professional experience in IT Projects Management, Team Leadership, Custom Software Applications, SDLC processes, BIG DATA, Data Modeling, Data Architecture, DBA, Enterprise Data Warehousing (EDW), Master Data Management (MDM), Data Quality and Governance, Business Intelligence, Performance & Business Analytics, Data Mining, ETL & SOX practices
• Professional Experience on Execution and implementation of Industry Standards such as PMBOK, EA, TOGAF, Zachman, SCRUM, CMMI, ITIL
• Professional expertise of developing N - tier architecture and transactions oriented OLTP, ODS multilingual, multiplatform & distributed Client/Server applications for .NET based platforms
• Professionally developed expertise on using DBMS/RDBMS databases such as, Teradata, My SQL, MS Access, SQL Server 2000/2005/2008/2012/2014 and Oracle 10g/11g/12C
• Developed expertise on TABLEAU, HADOOP DATAMEER, JAVA/J2EE SSRS, Crystal Reports, ASP, ASP.NET, MVC, EF, XSD, C, C++, HTML5, Java Script, SQL, C#, XML, XSLT, VB.NET, VB6, Classic ASP, MDX, OLTP, OLAP, ETL, TSQL, PL/SQL, Triggers, stored procedures & functions and on dictionary objects, Table Partitioning, Star Schema, Parallel Query, DB Tuning
• Conducted JAD sessions and worked directly with clients regarding functional requirements and Designed & Developed Software Requirements Specifications (SRS), Presentations & Demos.
• Designed, Developed and integrated Business Intelligence, Data Warehousing solutions using SQL Services (SSRS, SSAS, TABULAR, SSIS), Power Query, Power Map, Power Pivot, Power View on SQL Server 2005/2008 R2/2012/2014 Databases and SharePoint 2010+

PROFESSIONAL EXPERIENCE

MANAGER SOFTWARE DEVELOPMENT/IT EIM

Confidential

Responsibilities:

• Defined the enterprise application landscape for TD bank and application solutions that meet business needs
• Subject matter expert regarding application architecture.
• Define enterprise application architecture standards, guidelines and principles for the Agency.
• Ensure conformity of application standards across.
• Track and advised on emerging technologies and trends in the industry that could impact the services and business.
• Advise on approaches to optimize business success.
• Advise on the design of technology - agnostic applications that deliver functionality/capabilities that satisfy corresponding business requirements.
• Define and develop enterprise application patterns with technologies JBoss, Eclipse, J2EE, SOAP, RESTful API, IBM WebSphere Participate in the Business Relationship Manager s annual review and planning of the Information Technology (IT) solutions.

Confidential

TECH LEAD/SOLUTIONS ARECHITECTURE

Responsibilities:

• Worked with the PMO office for Scrum, Scope, Time, Resource, WBS & budget estimation, and Worked with the RBC Preferred vendors to implement and acquire, resources & technologies. Worked with Users, Stakeholders, department heads and leads to give POC’s and project related Presentations. Worked with Analysis, Development, QA, Release, and Support Teams.
• Followed the Agile practices, worked as Scrum master, Designed Sprints planning, Scrum meetings, Perform daily Standoffs, Created JIRA tickets and Assigned Tickets. Managed code & automated builds.
• Implemented RBC Bank Risk Data Aggregation and Risk Reporting (RDARR) project to comply with OSFI standards BCBS 239 using the Technologies HADOOP 2.6.1, UNIX, JSON, XML, HBASE, FLUME, HIVE, DATAMEER, TABLEAU, J2EE

Confidential

TECH PM/SOLUTIONS ARCHITECTURE

Responsibilities:

• Implemented RBC Bank Liquidity Risk Management Analytics LRMA Project to comply with FSA, Basel III and OSFIstandards with MS SQL Server 2012 Power BI, Office 365, Power Pivot, Power Query, SQL BI Stack, Designed around & Integrated MDM end to end solution with LRM.
• Implemented LRMA Analytics project to Define/Determine/Calculate the various risk types for derivatives contracts such as VaR, Counterparty Risk, Market Risk and Liquidity Risk for Portfolio Risk Managers using Quantitative Analysis, MSBI, C++, Monte Carlo Algorithm, MS Excel, SSAS, SSIS & SSRS of SQL Server 2012, UNIX Shell Scripting
• Led the team & managed projects & stakeholders within RBC Bank and Capital Markets Domain. Designed POC (Proof of Concept) for projects and their integration requirements with existing systems, road maps, policies & strategieswith Senior Management and performedproject prioritization and resource allocation requirements, completed project planning and status reporting, and design and implemented the projects' deliverables.
• Transition projects with QA teams from UAT, Pre-Prod and Prod Environments, worked with EIM team &provided training on new data/systems requirements, monitoring and quality standards, Technical & ArchitecturalDesign and Direction on EIM practices.
• Led technical aspects of the projects and mentor teams on Technologies, MSBI (SSRS,SSAS, SSIS), TABLEAU, WCF, WPF, .NET (C#, VB.NET), Vertica DB, SQL Server 2012, to implement the BASEL III standards.
• Created Master lists and created custom processes for synchronizing the master lists around MDM and developed custom Analytics engine and reports on top of the master lists for CRUD (CREATE, READ, UPDATE & DELTE) cycles

MANAGER IT APPLICATIONS/DEVELOPMENT EIM

Confidential

Responsibilities:

• Worked with PMO office to prepare the project budget, resource and time estimation docs and proposals, and worked with Delivery Managers to control and update on project scope and delivery.
• Worked as Principal Consultant to take lead on EIM projects such as Enterprise Data Warehousing, Business Intelligence, MDM, Data Governance, Data Quality, Big Data Analytics, Enterprise Reporting for prestigious clients as mentioned above for Analytical decision making using the technologies such as TABLEAU, POWER BI, SHAREPOINT, MSBI, .NET C#, ADO.NET, MVC, WCF, WPF, XAML, Java/J2EE, Struts, JSP
• Conducted Scrum meetings on daily bases for project updates and milestone accomplished and roadblocks faced, controlled, administered and followed up JIRA issues with resources, SVN and Nexus repositories for Software Versioning, Control and Release
• Worked with Global Risk Management (GRM) & Capital Management teams in Banks to help design Solutions for Performance Management & determine Risk
• Developed information architecture best practices, policies and frameworks.
• Collaborated with diverse IT and business teams to achieve enterprise information architecture outcome.
• Designed DATA MODELS & strategy for BI, EDW projects using the Kimball (Bottom Up) approach and by analyzing the Departmental Data Feeds and WCF Data Services on OData Feeds.
• Designed/Modeled the CUBES for spot Analytics of TV ads/Commercials for ROGERS complete financial Analysis during a Year / Quarter / Month and Week and for Agency and Advertisers and and Integrated end to end MDM solution
• Providing Technical leadership to project and team members in the complete life cycle of the project including Design, Build, Implementation, and Deployment.
• Designed /Architect the ETL Framework, Audit Control of SSIS packages, Full Load, Incremental Load, Dynamic Configurations, Customized Logging, Restart ability, Process Automation, Deployment in UAT & Production.
• Designed and Architected the Data Marts/CUBES (SSAS TABULAR) based on the KIMBALL/BOTTOM UP approach and designed and implemented the CUBE Security at Cell Level, Dimension Level and Dynamic Level and MDX Level.
• Designed /Architected the Data Marts based on Zachman Framework methodology and created Conceptual, Logical and Physical Data Models with Erwin & generated DDL for SQL Server 2012.
• Worked with the Business Users, Business Domain Stakeholders to address the business
• Created Master lists and created custom processes for synchronizing the master lists around MDM and developed custom Analytics engine and reports on top of the master lists for CRUD (CREATE, READ, UPDATE & DELTE) cycles
• Implemented, Configured and Deployed ETL Packages (SSIS) and OLAP SSAS database and SSRS 2008 Reports, MDX, TSQL, PL/SQL scripts to manage MDM, OLTP staging and Enterprise Data Warehousing (EDW) Databases over Oracle 10g and SQL Server 2008 R2 Servers.
• Identified & recommended best vendor to meet data requirements, negotiate contracts with 3rd party data suppliers, including revenue sharing, and establish service level agreements and data quality expectations. Ensure all necessary agreements are in place with 3rd party data suppliers and vendors

SOFTWARE/DATABASE ARCHITECT

Confidential

Responsibilities:

• Worked on McCain’s B2B & B2C data acquisition business application architecture for (Europe, Australia and North America) operations.
• Designed Conceptual / Logical, Object Oriented (OOM) & Physical DATA MODELS for data acquisition application using TOAD Data Modeling Tool.
• Designed cubes with SSAS in Business Intelligence Development Studio (BIDS) which represents many to many relationship with KPIs, Calculations, Actions, Partitions, Aggregations and Translations
• Architected ETL Packages in SSIS with capabilities logging, dynamic configurations, Restart-ability, Metadata Support
• Designed, implemented, the SQL Server 2005 snapshot replication over SQL Server clustered environment and enhanced the functionalities of existing enterprise apps built in Visual Studio 2006 C#, SSRS, SSAS and SSIS for custom needs.
• Developed & maintained MDX, T-SQL scripts, T-SQL utility jobs or implement needed software for database maintenance.
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Migrated SQL Server 2000 DB’s, Business Logic, DTS packages & TSQL jobs to SQL Server 2005.
• Designed the Use Cases, Class (Static), Sequence, Activity, Deployment diagrams using MS Visio

SOLUTIONS DEVELOPER/ARCHITECT

Confidential, BC

Responsibilities:

• Led a team of 3 Database developers and a DB system Admin, Worked with Product Manager and Business Development team to analyze the Business Requirements for XoftSpy SE / Privacy Controls / RegCure, A Windows XP, 2000 based security tools to monitor & prevent malicious software activities
• Designed OO diagrams (use case, sequence, class & component) using MS Visio 2003, and created detailed database specifications document.
• Designed Conceptual, Logical & Physical DATA MODELS for the systems and generated code for SQL SERVER 2000 databases.
• Deployed and implemented the database using SQL Server 2005. Used Business Intelligence Development Studio (BIDS) tool to design, develop and integrate SSIS Services, SSRS Reports, SSAS cubes & imported Data, Schemas & DTS packages from SQL Server 2000
• Replicated the snapshot copy of the Data to remote SQL Server 2005 and implemented Data backup, restore, monitoring data tuning polices.
• Designed Logical and Physical Data Models for XOFTSPY SE portable DB and Implemented using PostgreSQL.
• Used SQL Server 2005 Management Studio, Visual Studio 2003, C# to Manage, Maintain and develop database Schemas, Stored Procedures, User Defined Functions using MDX, TSQL, developed and configured XML schemas for SQL Server.

SR. PROGRAMMER ANALYST

Confidential, Victoria, BC

Responsibilities:

• Led a team of 5 software engineers and participated in design and implementation of Point of Sale (POS) system custom to North American Retailers to manage, run and monitor the store operations with business acumen insights to Senior Management for decision making in form of web based and Power Pivot Reports.
• Designed & implemented ASP.NET C#, SSRS reports, SSAS cubes for SQL SERVER 2005 Database for Windows and *NIX Servers and Workstations.
• Designed the LOGICAL AND PHYSICAL DATA MODELS for Client/Server DB’s using Visual Basic 6.0, UML & MS Visio 2000 and Implemented them using MySQL/MySQL Administrator and MS SQL Server 2000.
• Developed SERVER side XML schemas on SQL Server 2000 database for online transactional web application.
• Developed user defined functions, Stored Procedures, Views based on TSQL quires, used SQL Query Analyzer and SQL Profiler to Run, Debug and Performance.
• Designed and Developed a DTS package to copy CSV Files and to move data to the replicated DB.
• Designed and Implemented the Web Service on private clouds to estimate the daily inventory in stores using WCF C#, ADO.NET, ASP.NET C#, MVC, HTML3, JavaScript, jQuery, AJAX, CSS3
• Designed and implemented the Inventory, sales, stock, customers, employees reports and KPIs in SSARS and provided the analytical capacity designed in SSAS and EXCEL POWER PIVOT to Senior Management on day to day store operations
• Designed a Data lake (ODS) A source of various data sources required by various custom apps running in stores to run the business, Extracted data with SSIS from SQL, ORACLE, VERTICA, MAINFRAME FILES, SYBASE & BD2

ENTERPRISE SOFTWARE ENGINEER/ARCHITECT

Confidential

Responsibilities:

• Led a team of 5 experts, designed & assigned WBS, arranged training/mentoring workshops, communicated team and project status to management, Follow up with the team to validate Work Breakdown Structure (WBS)
• Designed Human Capital Management System (HCMS) solution and implemented n-Tier architecture Visual Studio 6.0 (Visual Basic, Visual C++, Visual J++, Visual InterDev, and Visual SourceSafe).
• Engaged with different Enterprise teams on various projects and participated in design, Architecture and Implementation of the following Projects as part of Enterprise Information Management (EIM)
• Designed, implemented & architected multi-lingual, multi-platform, distributed applications for Enterprise custom needs with Visual Studio 6.0 (C++, VB)
• Designed custom MDM Modules with C++ and integrated them with OLTP and OLAP systems, client/server technology and comprehensive experience in application design using Visual Basic 6.0
• Designed & implemented Business Logic and Data Access Layers (DAL) for EIM applications using Visual C++ 6.0 for SQL Server 2000, Oracle 8i databases, integrated them with HCMS modules.
• Designed and implemented Conceptual, LOGICAL & PHYSICAL DATA MODELS using ERWin for HCMS and EIM projects

TECHNICAL SKILLS

Programming: C++, Java, Struts, JSP, OBIEE, COGNOS, C#, UML, UNIX, LINUX, SHELL SCRIPTING, EXCEL, VBA, Classic ASP, ASP.NET, MVC 2/3/4/5, AJAX, HTML/CSS/ XML/XSL, PL/SQL, T-SQL, JavaScript, VBScript, Crystal Reports 2008/2011, MS Office 365, MS Office 2013, WCF Data Services, XSD, OData, XML, Visual Studio 2008/2010/2012/2013, .NET 3.5/4, SSIS 2005/2008/2012,SSAS 2005/2008/2012, TSQL, Visual Studio, B Script, Visio, MDX, ADOMD.NET and Microsoft Team Foundation Server, HIVE, PIG, SPARK, YARN, MAPREDUCE, FLUME, IMPALA, AMBARI, HUE, HDFS

Tools: Tableau, Share Point 2010 Server, Team Foundation Server (TFS), ERWin, Visual Source Safe (VSS), Tortoise CVS, Power Designer12, Toad Data Modeler 3.6, MySQL Workbench, MS Visio 2003, MS Project, MS Office 2007 (MS Excel, MS Word, MS Power Point, MS Access, MS Outlook, MS Publisher), Toad DB Admin 10, SSMA (SQL Server Migration Assistant), MySQL Workbench 5.2