More than 16 years of experience, in which nearly 15 years in diverse requirement engineering; system designing software architecture; software testing; network infrastructure operation analysis designing; technology migration from the legacy system; designing development of data warehouse, business intelligence system and master data modeling database administration; system security user support; domain expert of accounting/book - keeping of large manufacturing/trading concerns/group of companies; proficient in Inland taxes and Customs procedures,and graphic illustration experience. Good knowledge about ITIL practices and TOGAF architecture. Vast experience of software development by using .net, Sharepoint, Oracle, IBM, SAP, Microsoft tools with CISC and RISC platform running on AIX, OS/400, Windows and Linux:-

• More than eight (8) years experience in system/data architecture, data-warehouse/BI (Business Intelligence)/ETL development administration (DBA) including testing and business/data analysis with Microsoft database BI suite. Strong background in business intelligence, OLAP (multi-dimension data structure), and data warehousing deliverables including establishment of data-warehouse by using Oracle Warehouse Builder (OWB), Oracle Materialized View, ETL (Extract, Transform Loading), Data Modeling, Database Administration (DBA), Testing, Data mining, Data warehousing andcreatebusiness intelligence(BI) by using SQL Server OLAP, SSIS (SQL Integration Services), SSAS, Cubes, Fact Tables. Data cleansing, conversion, implementing business logic, extraction, transformation, loading etc. Done OLAP object programming in fact tables, dimensions, attributes, hierarchies, and cubes. Performance configuration/analysis in data partitioning, aggregations, schema optimization. Thorough knowledge of designing and development of Master Data Management System (MDM). A solid understanding of Transact-SQL Server including DTS, SQL Server Integration Services and SQL Server Reporting Services. Advanced working knowledge of T-SQL stored procedures,Functions, Triggers. Migrated data from IBM AS/400, Oracle-AIX to MS SQL Server. Deploy/Design cubes in SSAS environment Snowflake and Star Schema Develop multifaceted reporting solutions by using SSRS, Proclarity, Crystal Report/Business Objects, Performance Point (PPS) and Excel Services integrating with MOSS (Microsoft Office Sharepoint), Visual Studio Team System/VSTF, Microsoft Dynamics AX, JD Edward, GIS, GEO database, ArcGIS, SAS, OBIEE.
• Approx. three (4) years experience for business analysis, system analysis, SAP, ERP implementation. Performing business analysis to define and document needs and requirements by usingMS Visio, MS Project; Creating and maintaining business process maps; Determining organizational readiness and identify approach to address gaps; Acting as liaison between the user and development groups; Participate in the planning and execution of system test and user acceptance test activities. Provide on-going business support once functionality has been delivered to the business user(s); Implementing corporate and departmental priorities relating to all SAP modules especially PM (Plant Maintenance); Provide leadership, guidance, advice and analysis to the ERP Solutions team; Interact with internal customers to identify needs.
• Have six (6) years experience of database modeling/designing, data warehouse/ETL/business intelligence, database administration (DBA), testing and business/data analysis with Oracletoolsincluding data migration replication from legacy system (AS/400, mainframe) to generic servers, SAS, Oracle SQL/PL SQL, Store Procedure, Functions, Triggers, Backup Recovery, Oracle Developer (Forms/Reports), RMAN, Essbase/Hyperion, Performance Tuning, Replication, Partition Index Organized Table and ERP solutions. Working with user defined stored procedure, function, packages, database trigger using Advance SQL/PL SQL. Development of software to offline user through MS Access and MS Excel by using VBA.

Qualification | Experience:

Project: Confidential Oct. ’11 to till now

Shell is a global group of energy and petrochemical companies. Canada’s oil sands contain the world’s second-biggest oil resource after Saudi Arabia. Surface mining can extract around 20% of the oil and currently covers about 550km2, one third the city of Los Angeles. Shell is one of over 30 companies active in the oil sands and at Athabasca Oil Sands Project they mine the resource and separate the oil from the clay, sand and water. It represents 2.5% of shell total production.

JOB DESCRIPTION:

• Designing Data Modeling (Logical/Physical) and database design according to industry standard
• Developing Business Intelligence and Data-Warehouse solution
• Providing technical database administration, maintenance and development for Corporate System applications, including monitoring and creating interfaces between applications, and performing data audits.
• Developing and maintaining reports for stakeholders.
• Maintaining source code version control and installation software inventory.
• Technical writing, including documentation of procedures, technical requirements and reporting.
• Coordinating between the business and vendors for additional support
• Providing excellent customer service to our internal customers/users.

ENVIRONMENT: MS SQL Server, SSRS, SSIS, SAP, Sharepoint, Crystal Report/Business Objects, Erwin, Oracle

Confidential, Canada Jan. ’12 to April’12

Lead ERP Data Conversion

BURNCO is an operating group of near century-old private Companies. It is Canada’s largest independent supplier of ready-mix concrete, and a major supplier of asphalt and aggregate products along with operating a network of landscape centers in Western Canada.

JOB DESCRIPTION:

• Lead field based data collection and analysis of AS-IS state of Microsoft Dynamics ERP systems.
• Identify and drive resolution of data issues in source systems as needed
• Lead use of Profiling/Cleansing tools to support initiatives.
• Establish monitoring/auditing capability over transformed data in source systems.
• Drive definition of business rules to cleanse and complete data during conversion.
• Work with functional Process Leads to ensure that data meets quality standards
• Establish data definition requirements in conjunction with Reporting and Analytics Lead.
• Lead/conduct attribute and entity level mapping between various source systems of Microsoft Dynamics and the target JDE E1 system at a logical and physical data model level
• Collaborate with the business and IT teams to drive consensus on business rule definition
• Conduct data validation with business and IT teams for any conversion and integration processes
• Work with business and IT teams to resolve any issues with error records during conversion to ensure complete data conversion from sources to target
• Drive creation of functional specifications for converting data from each source system.
• Interface with multiple teams (internal and vendor) to drive the conversion effort to successful completion.

ENVIRONMENT: JD Edwards, Microsoft Dynamics, Hyperion, UPK (Oracle - User Productivity Kit)

Confidential, Canada Mar. ’11 to Sept. ‘11

Consultant

Calgary International Airport has come a long way since its inception in 1914. In 2008, Calgary International Airport reached new heights with passenger volume increasing 2.0 per cent to 12.5 million passengers annually, making YYC the fourth busiest airport in Canada. Over 15,000 people are part of the airport community and The Calgary Airport Authority is a major contributor to the prosperity of the Calgary region with a total GDP impact of $6 billion.

JOB DESCRIPTION:

• Providing software application maintenance and enhancements, and ongoing expertise for in-house developed and off-the-shelf application packages.
• Providing technical database administration, maintenance and development for Corporate System applications, including monitoring and creating interfaces between applications, and performing data audits.
• Developing and maintaining reports for stakeholders.
• Maintaining source code version control and installation software inventory.
• Client/server and web application installation, maintenance, configuration and upgrades
• Technical writing, including documentation of procedures, technical requirements and reporting.
• Providing technical support for all corporate-facing systems.
• Coordinating between the business and vendors for additional support
• Providing excellent customer service to our internal and external customers/users.

ENVIRONMENT: Oracle, MS SQL Server, SSRS, SSIS, Business Objects/Crystal Report, Jasper

ConfidentialAug. ’09 to Nov. ‘10

Senior Architect

Teck is a diversified resource company committed to responsible mining and mineral development with major business units focused on copper, metallurgical coal, z inc, gold and energy with interests in several oil sands development assets. The company is actively exploring in countries throughout the Americas, Asia Pacific, Europe and Africa.

JOB DESCRIPTION:

• A full implementation of Monitoring and Analytics features of MS Performance Point, Sharepoint, Proclarity, SSRS specifically the KPI dashboard (Key Performance Indicators), data analysis by using SAS.
• The tool is used to collect and consolidate data, and provide analysis of data to enhance day-to-day decision making and helping to operate more efficiently, effectively and strategically.
• Centralize data, update tracking and reporting capabilities, cut down on manual processes and automate daily business tasks and workflows.
• Design and development space of the project and its full implementation.
• Data Migration and data conversion from JD Edward (Oracle) and MS Dynamics AX (SQL Server) to data-warehouse and
• GIS Data Integration
• Develop data-warehouse, data modeling, BI and data architecture
• Develop and document a technology roadmap through collaboration with the business teams.
• Led a group of developers in architecting and building the EDW for the reporting and analytics

ENVIRONMENT: Microsoft Dynamics AX, Erwin, MS Sharepoint, Oracle, Performance Point, Proclarity MS SQL Server, SSRS, SSIS, SAS, MS Visio, MS Project, MS Excel, MS Access, AX MRO (EAM)

Confidential Dec. ’08 to Jul. ‘09

Confidential,systems is one of North America\'s largest single source providers of information technology and communications staffing and services, providing more than 20,000 professionals to client locations every day. I worked at TekSystems Montreal Solution Center, where I developed software/solution to the following clients:-

• Client: Confidential (Medical Advancement Management Systems) from Feb. ’09 to Jul. ’09 (ENVIRONMENT: SAS, Oracle, PL/SQL, Oracle OWB, Oracle Reports, ER/Studio, Linux, MS Visio, MS Project, MS Excel, MS Access)
• Client: confidential (Data Warehouse) from Dec ’08 to Jan. ’09 (ENVIRONMENT: SAS, MS SQL Server 2008, .net, Oracle, ER/Studio, Business Objects/Crystal Report, Sharepoint, Toad, Visual Studio Team Foundation (VSTF), Performance Point, Proclarity, Visio, MS Project, Excel)

ConfidentialApr ’08 to Nov. ‘08

Business Analyst Downstream - SAP

Chevron Corporation is one of the world\'s leading energy company. Headquartered in San Ramon, California, and conducting business in approximately 180 countries, the company is engaged in every aspect of the oil and natural gas industry, including exploration and production; refining, marketing and transportation; chemicals manufacturing and sales; and power generation.

JOB DESCRIPTION:

• Implement an Enterprise Asset Management Reliability system for different refineries including gaining an understanding of client business processes and improvement opportunities.
• Translate enterprise requirements into systems specifications and all aspects of technical systems design according to the TOGAF architecture.
• Data Migration of Work Order, Vendor Master, Item Master, BOM etc.
• Support system configuration, data conversion and cleansing, QA/Testing and User Training efforts.
• Lead technical guidance to less experienced team members for specific engineering and programming activities related to environment design and project implementation.
• Consult with other technical areas regarding appropriate use of the Asset Management system and integration with other line of business applications.

ENVIRONMENT: SAP, SAP-PM, IBM Maximo, Oracle, MS SQL Server (SSIS), Erwin, Visio, Crystal Report, ArcGIS,

Sharepoint, Toad, Visual Studio Team Foundation (VSTF), MS Visio, MS Project, MS Excel/Access

ConfidentialJuly ’07 to Mar. ‘08

Developed an Enterprise-wide Data Warehouse and BI reporting framework from strategy to implementation for one of the top 20 divisions of Microsoft. As an Expert, designed the standards, plans, and frameworks for EDW, ETL, BI Reporting, Dashboard, Meta-data Management, and Data Governance to ensure a successful implementation of this far reaching initiative. The project was built by using the latest Microsoft Integrated BI Offerings from SQL Server 2005/2008 BI Stack-SSIS, SSAS, SSRS, Proclarity, Sharepoint, Stratature (MDM) to Performance Point Server.

JOB DESCRIPTION:

• As a member of the BICoE (Business Intelligence - Centre of Excellence) team, I worked on broad, complex, and critical Data Warehouse engagements. I designed, architect, and manage full life cycle development of large data warehouse projects providing guidance and direction to clients and project team members. Also interacts with all levels of client technical and business management, along with various organizations in Microsoft to marshal the resources required for successful implementation.
• Provide warehouse design, architecture, and implementation/integration effort, including data sourcing and transformation. Help define process to ensure that the clients business goals and objectives are met by the proposed data warehouse architecture and design.

  Gather and write business requirements, design and architect multi location databases with data flows and synchronization mapping.

• Leverage knowledge of current data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.
• Coordinate application releases into testing environments
• Provide technical leadership to project. Design data and reporting architecture framework
• Verify and update conceptual data model. Design logical and physical data model
• Participate in and support technical tasks as required. Relational and dimensional data modeling
• Medium to large data warehouse implementations. ETL architectures and design patterns

ENVIRONMENT: MS SQL Server (SSRS, SSIS, SSAS), Visual Studio .Net, MS Sharepoint, Performance Point,

Proclarity, Business Score Card, Excel Services, Report Builder, METaL (ETL Framework) Stratature (EDM/MDM), Dynamic AX, Visual Studio Team Foundation (VSTF), MS Project, Visio, Access

Confidential

Senior Consultant

PRAL is providing solution to federal and provincial tax and revenue agencies. Since its in corporation, PRAL has been involved in the development of wide array of tax and revenue related solutions pertaining to Income Tax, Wealth Tax, General Sales Tax, Federal Excise, Customs, Capital Value Tax, Property Tax etc.

During my tenure at PRAL, I was working with number of Projects and positions/roles, as listed below:-

• Sr. Business Analyst Indirect Taxes from (ENVIRONMENT: SAP, Oracle (OLTP), SQL Server (OLAP), SSRS, SSIS, Windows, C#, Essbase/Hyperion, Erwin, Visio)
• Database Developer/DBA Sales Tax-eFiling System from (ENVIRONMENT: Oracle OLTP, MS SQL Server-OLAP, Visual Studio .Net, Excel VBA, Access VBA, Erwin)
• BI ETL Developer/DBA Federal Budgets from and (ENVIRONMENT: SAS, MS SQL Server-Windows, MS Excel, SSRS, Hyperion, Oracle-Linux, Erwin)
• Business Analyst-User Support Customs Document Processing Systems from (ENVIRONMENT: IBM iSeries, AS/400, OS/400, DB2, Query 400, Client Access, Crystal Report, Radio Modems, Mux, personal computer, Twinaxel, ASCII, RAS, Routers)
• Business/System Analyst Customs Administration Reform from (ENVIRONMENT: .net, SQL Server, Windows Server, MS Visio, Hyperion, Erwin)
• Database/ETL Developer Reporting-Management Information System from (ENVIRONMENT: Oracle, Warehouse Builder (OWB), Developer, ETL, MS SQL Server (OLAP) Access, Excel, Erwin)
• Technical Analyst Infrastructure Network Modernization of Customs from
• DBA/Data warehouse Developer TEPI- Trade, Export, Promotion and Industry from Dec. 00 to

ENVIRONMENT: Oracle, Warehouse Builder (OWB), Developer, Access, Excel, Erwin)

Confidential

Unicorn International is a joint venture/sister concern of group of companies comprising from paper board, to textile, import export, power cabling, real-estate, investment and restaurant businesses.

During my tenure at Unicorn, I was working with number of Projects and positions/roles, as listed below:-

• Database Administrator ERP from (ENVIRONMENT: Oracle (Database), Linux O/S, Oracle Developer (Forms/Reports))
• Software Development Engineer - Test Restaurant Management System from (ENVIRONMENT: Oracle, Oracle Developer, Windows NT)
• Programmer Export Documentation Management System from (ENVIRONMENT: Oracle, Visual Basic, Windows NT)

Confidential

First Textiles Ltd. -FTL is a diversified textile weaving company produce number of products for export business. During my tenure at FTL, I served number of positions/roles:-

• Junior System Analyst from (ENVIRONMENT: Oracle, Linux O/S)
• Assistant System Administrator Inventory Management System from (ENVIRONMENT: Intel Hardware, Windows OS, LAN, Dialup)