OBJECTIVE:

• To obtain a position as a Data Architect (Business Intelligent), SQL Server Develop using Data Tools (Like SSIS, SSRS and SSAS) to Create ETL solutions for customer, .Net developer /SQL Programmer, Data Analyst, PL/SQL Developer, C# developer,Webservice, SharePoint, Report Programmer, Programmer Analyst, Publishing reports on SharePoint and Trainer & Team Leader

SUMMARY:

• Over 17 years of experience in computer programming
• Excellent skills with Tableau report development
• Hadoop, Hive, Spark and Kafka
• ETL with Talend
• BI Solution (ETL, SSRS, Tableau, SSIS, SSAS)
• Excellent Knowledge of R Language
• Excellent knowledge with ETL processes and application (SSIS, SSRS, SSAS)
• Strong .NET skills, C#,.Net Web forms and creating style sheet
• Fluent in French and English
• Excellent knowledge in Data Analyst with SSAS, SSRS, SSIS
• Strong organization, planning and communication skills
• Flexible, quick learner, honest, responsible, with great ability to handle multiple task
• Superb knowledge of T - SQL, MDX, PL/SQL, Oracle database, custom reporting and programming using SQL, Ms Access, Excel VBA
• Good Knowledge of PowerBuilder
• Good Knowledge of JAVA programming, Jquery, HTML coding programming language
• Excellent knowledge in SOAP, WSDL, XML, WEBService, Java, C++, C on UNIX environment.
• XAML programmer.
• Excellent knowledge SQL Server 2005 and 2008, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) and SSAS.
• Excellent knowledge with VB.Net, C#, ASP.Net and C programming languages
• Excellent knowledge of MS Office, statistics, crystal report (V10, V9 and Enterprise, Business Object), Excel report, pay@work reporting, people@work reporting, report smith reporting tools, Publishing reports on SharePoint
• Manage sharepoint
• Experienced in using ERP system as an end-user to fetch info and make analysis

PROFESSIONAL EXPERIENCE:

Sr.Data Architect

Confidential

Responsibilities:

• Hadoop, Hive, Spark and Kafka
• ETL with Talend
• Application maintenance and installation (ETL Process)
• Executed multiple Hadoop data lake projects (streaming real time data) and led the developers’ team.
• Experience in Agile methodology.
• Create ETL solutions for customer order processing using Microsoft SQL Server Integration Services and Reporting Services;

Data Architect

Confidential

Responsibilities:

• Hadoop and Hive
• My responsibilities included, Create report using SSRS and Tableau, Create and Maintian database, publish and maintain reports,gathering reports requirments, Writing SQL queries
• Write reports using Tableau, SSRS, T-SQL
• Application maintenance and installation (ETL Process)
• Create ETL solutions for customer order processing using Microsoft SQL Server Integration Services and Reporting Services;
• Data Loading

Data Architect

Confidential

Responsibilities:

• Write reports using Tableau, SSRS, T-SQL
• Application maintenance and installation (ETL Process)
• Create ETL solutions for customer order processing using Microsoft SQL Server Integration
• Services and Reporting Services;
• Create effective test plans and test developed solutions ensuring high quality deliverable;
• MS SQL Server Integration Services, relational Database modeling, MS SQL Server Reporting
• Services, SQL Scripting, Stored Procedures and Triggers;
• Using Visual Studio .NET, XML, JavaScript, HTML, PowerBuilder, .NET MVC, JQuery,
• WCF, PVCS.Integrating data using SSIS
• Data Architect Using T-SQL, SSAS

Data Architect, Business intelligence/Database Administrator/ SQL Programmer (Contract Position)

Confidential

Responsibilities:

• My responsibilities included, Create report using SSIS, Create and Maintian database, publish and maintain reports,gathering reports requirments, Writing SQL queries/MDX quieries,
• Write reports using Tableau, SSRS, T-SQL
• Application maintenance and installation (ETL Process)
• Publishing reports on SharePoint
• Manage sharepoint
• Integrating data using SSIS
• Data Analyst Using T-SQL, SSAS
• Project worked on ODS and Music Mark
• Tableau Reporting Tools

Data Architect/Database Administrator/ SQL Programmer (Contract Position)

Confidential

Responsibilities:

• Create and Maintain cubes, publish and maintain reports, gathering reports requirements,
• Manage the financial database Chang School, Writing SQL queries/MDX queries, Write reports using Tableau, SSRS, T-SQL
• Application maintenance and installation (ETL Process)
• Manage sharepoint, administration and report publishing
• Create ETL solutions for customer
• Publishing reports on SharePoint
• Integrating data using SSIS
• Data Analyst Using T-SQL, SSAS
• Tableau Reporting building and modifications

SQL Programmer (Contract Position)

Confidential

Responsibilities:

• My responsibilities included. Writing SQL scripts, Writing report using T-SQL
• Web Application maintenance
• Using T-SQL
• Web Application maintenance

Programmer and Data analyst

Confidential

Responsibilities:

• My responsibilities included. Writing report using SSRS, SSAS,T-SQL
• Application maintenance for SSCM Project using VB.net and C#.Net
• Data Analyst Using Crystal Reporting and SSRS, SSIS and SSAS

Data Architect/ Programmer Analyst

Confidential

• OS: Windows 7, Oracle 11 Database, SQL Server
• Created report using SQL and Oracle PL/SQL
• Programmed reports using PL/SQL, T-SQL, pay@work, people @ work, SSRS and SSAS
• Environment used to create report was SSRS for Microsoft and TOAD for Oracle
• Used C# to create upgrade PGTed Application
• Languages used: C# and .Net, ASP.Net, T-SQL, Oracle PL/ SQL
• Other Tools used: MS office, MS Excel, SQL server 2008/2005
• Skills used: problem analyzing, solving and troubleshooting, communication, interpersonal, presentation skills and support critical business requirements.

Data Architect/ Programmer Analyst

Confidential

Responsibilities:

• My responsibilities include. Data Analyst Using SSAS and SSRS
• Create ETL solutions for customer
• Supported in French and English
• Programmed reports using PL/SQL, T-SQL, SSRS and SSAS
• Writing dimension and cube using SSAS.
• DB programmer using SQL Server 2008
• Using C# and ASP.Net environment to update the business logic
• Used SQL Server to store data and Query information
• Used ETL process for data manipulation and transformation (SSIS, SSRS,SSAS)
• Programmed with PowerBuilder
• Programmed reports using SSRS
• Java, T-SQL, Pl/SQL, C# and ASP.Net,SOAP, Webservice

Programmer and Data Analyst

Confidential

Responsibilities:

• Programmed reports using PL/SQL, T-SQL, pay@work, people @ work, SSRS and SSAS
• Trained client in French and English
• Database Used SQL server and Oracle Database, VB.Net
• Received specs from the client
• Build reports as per client‘s request.
• Used SSIS during the ETL process to merge the data, transformed and load data.
• Used reporting tools like Crystal Report 9/10/11 and Report Smith to setup custom report
• Programmed custom utilities in Microsoft visual basic
• Trained client on how to use in house products
• Collected specification from clients to build custom reports

Programmer and Technical Support Analyst

Confidential

Responsibilities:

• Programmed point of sale terminals using VB 6 and C/C++, J2EE/Java language
• Supported in French and English
• Programmed terminals with custom functionality
• Setup new client and offered technical support to all TD Merchants
• Accurately recorded all information associated with each call (using Tracker system)
• Responsible for troubleshooting technical issues and initiated appropriate action
• Generated paperwork appropriate for each situation promptly and handled charge back situations effectively
• Supported clients with financial issues, troubleshot point of sale terminals and dispatched onsite assistance when needed

Programmer and Technical Support Analyst

Confidential

Responsibilities:

• Provided support to CIBC and National Bank customers for both, incoming and outgoing calls
• Supported in French and English
• Programmed point of sale terminals using VB 6 and J2EE/Java/language.
• Programmed terminals with custom functionality and setup new merchant
• Accurately record various information associated with each call (Tracker system)
• Troubleshot customers’ situations and initiated appropriate action
• Generated paperwork appropriate for each situation promptly, legibly and accurately
• Handled charge back situations, financial problems, troubleshot point of sale terminals and dispatched technician when necessary

Administrator and System Developer

Confidential

Responsibilities:

• Developed a user interface using C++, VB, J2EE/Java/ technology guidelines
• Designed and coded Congo2000 web site
• Conducted technical support for the software
• Developed a Database System using Access2000 Technology for a retail store and conducted program testing
• Took care of customers’ needs and created statistics reports

Software Developer

Confidential

Responsibilities:

• Programmed a Tax Software for HR-Block by using C++, Visual Basic and J2EE/Java/
• Handled customers’ inquiries and concerns by offering appropriate technical support for the software
• Represented the company to the Government of Quebec
• Followed all requirements and guidelines for Revenue Canada
• Worked in a team environment
• Completed all assignments on time

Customer Support Representative

Confidential

Responsibilities:

• Provided excellent Customer Care
• Created paging phone messages via software to customers
• Used ERP system as an end user to capture, monitored equipment reliability and maintenance data for various statistical analyses
• Answered customer inquiries and billing issues
• Performed data entry and maintained data base
• Created sales leads and up-sold company products and services