SUMMARY

• IT professional with over 13 years of experience in consulting, software implementation and data architecture.
• Highly versed in designing and developing custom enterprise solutions and integration systems using agile methodology.
• Strong background in software design, release engineering, application analysis and full SDLC process
• Team spirit with successful track record building scalable, timely, and highly available data platforms
• Proficient with data profiling, data modeling, data integration, architectural guidelines and best practices
• Extensive experience in SQL and ETL development with diverse OLTP RDBMS and OLAP data stores
• Hands - on implementation of complex Business Intelligence, Business Analytics and Big Data initiatives
• Particular interest in deriving and visualizing deep, meaningful and actionable informations from data
• Results-driven, customer-focused, versatile and self-motivated with outstanding communication skills
• Highly adaptable in fast paced environment contexts with strong organizational and analytical skills
• Proven ability to handle multiple tasks, meet stringent deadlines and provide high quality deliverables

PROFESSIONAL EXPERIENCE

SR. IT Consultant

Confidential

Responsibilities:

• Trigger Based Marketing Automation/BI Rationalization Projects/AI and Advanced Analytics initiatives
• Principal Data Architect reporting to senior management / architecture direction and responsible for:
• Working closely with Enterprise Architecture to define Data Architecture target state and roadmap
• Producing reference architecture documents along with high level conceptual and logical data models
• Evaluating current system implementation to identify and remediate process and technology gaps
• Guiding solution architects to ensure proposals compliance with data management best practices
• Designing logical and physical dimensional data models as part of the legacy BI DW refactoring
• Driving key technology investments to meet business requirements and promote future scalability
• Providing business oriented advisory to assess data visualization and analytics tools at corporate level
• Overseeing proof of concept and market scan activities and making appropriate technology choices
• Taking part of a cloud migration assessment strategy: IaaS, PaaS, SaaS from data integration standpoint
• Redefining the use cases and capabilities of current and future enterprise data stores: ODS, DW, DL
• Delivering coexistence strategy between traditional BI stream and new data lake to promote agility
• Owning and maintaining deliverables from high level blue prints to detailed solution architecture

Environment: Windows, Microsoft Azure, Power BI, SQL Server, SSIS, Informatica, SQL, Kimball Dimensional Modeling, Erwin Data Modeler, Sparx Enterprise Architect, MS Office

SR. IT Consultant

Confidential

Responsibilities:

• Assessing business requirements for big data streams and recommending implementation alternatives
• Setting up a master data management plan providing a consistent view of dispersed reference data
• Designing and developing integrated dimensional data models serving as the single source of truth
• Owning and managing all changes to the data models and providing end to end technical guidance
• Strategically incorporating functional experts feedback to produce sustainable data lake solution
• Defining and enforcing naming standards and data dictionary across multiple data storage systems
• Creating solution designs and data architecture documentation for complex cross channels platforms
• Implementing ETL based data aggregation strategies and refining dataflow optimization process
• Writing and automating SQL scripts to perform regular datasets validation, cleansing and archiving
• Maintaining the end-to-end vision of the enterprise dataflow to build a unified data processing model
• Consolidating BI and Analytics platform optimizing data sources, server structure and report contents
• Applying data-source performance-tuning techniques and improving customer reporting experience
• Leveraging tableau dashboards, rich visualization, workbooks and data development best practices
• Ensuring team compliance with data quality standards, best practices and architectural guidelines

SR. IT Consultant

Confidential

Responsibilities:

• Production Sensitive Data masking for Legal Security Compliance project - ETL
• Principal Data architect reporting to senior management and responsible for:
• Leading Proof Of Concept phase, closely working with different internal and external stakeholders
• Contribution to project management activities (Planning, effort estimation, risk identification)
• Requirement gathering for functional and non-functional use cases: end users and conformity
• Working with analysts from multiple business lines to define and translate client business needs
• Architectural data design to implement business rules and maintain inter-systems data integrity
• Producing and presenting high level dataflow diagrams for management and executive teams
• Owning architecture deliverables for data management strategies and designed dataflow solution
• Parsing high-level business design specification to simple ETL procedures and mapping standards
• Ensuring TEMPeffective communication with the customers and leading different consulting activities
• Development of SQL scripts and PL/SQL stored procedure and packages to process business data
• Defining data quality metrics, data patterns and designing masking functionalities accordingly
• Developing and maintaining data quality controls and interoperability to manage corporate risk
• Performance tuning of extraction/masking packages (access definition, conversion and data load)
• Planning and leading full testing cycle from unit testing to integration and user acceptance testing
• Design, development and maintenance of technical documentation on SharePoint site

Environment: Windows 7, Linux, Oracle, SQL, PL/SQL, SQL Developer, IBM Data Studio, IBM Info Sphere, Shell Scripts, PostgreSQL, DB2/AS400 (iSeries V5R1), Sql Server 2008, PG Admin v1.18.1, Putty, SVN, Autosys, Crontab, Talend Data Quality, Jira, MS Office, Agile/Scrum

SR. IT Consultant

Confidential

Responsibilities:

• Managing analysis and reporting software development as well the reporting team of 6+ people
• Ensuring TEMPeffective communication with the clients to has in deep understanding of functional need
• Translating business requirement to development recommendations and implementation alternatives
• Providing advisory, mentorship, technical support and driving data base development best practices
• Preparing customer trainings and workshops on BI reports, dashboards and analytics platforms
• Third level technical application support for BI product on pre-production/production environments
• Performing data base design, join/primary/secondary indexes, PPI, collect stats and data skew
• Design and creation of materialized views and generating Data Warehouse Reports (Star Schema)
• Coordinating with data base end users and management team on developing performance metrics
• Implementation of PL/SQL stored procedures, functions according to the business requirement
• Building ETL architecture and Source to Target mapping for the client inbound/outbound systems
• Hiring and direct supervision of Jr. staff, contribution to delivery planning and effort estimation
• Contributing to pre sales activities, bringing technical expertise to support new BIDS and RFPS
• Creating and maintaining SharePoint documentation for Analytics and Reporting deliverables
• Ensuring dat the problems encountered by the client are understood, tracked and timely resolved
• Acting as Scrum Master following and promoting Scrum methodology and agile framework
• Documenting data integration and ETL strategies for data flows and source to target mappings
• Tuning ETL procedures and STAR schemas to optimize load and query reports Performance
• Performing unit, point-to-point testing and integration testing to confirm ETL code integrity
• Hydro Quebec Advanced Metering Infrastructure Deployment
• Sr. Data Analyst /ETL developer reporting to senior management and responsible for:
• Functional specification analysis: dataflow interface messages, new type data and solution design
• Defining and framing end to end dataflow between client and partners through the SaaS application
• Coordination with front end design team to provide them with required insights into the data base
• Development of PL/SQL stored procedures, functions and packages to implement business logic
• Assisting Jr. Consultants to understand the dataflow and perform product quality assurance activities
• Design and development of Import/Export Shell scripts controlling file transfer over SESP servers
• Build generation, database upgrade, release versioning and deployment to different environments
• Leading presentations and client custom workflow demonstrations during user acceptance stage
• Creating and maintaining standard specs and technical documentation for internal and external use
• Performing data profiling and analysis to retrieve and extract reporting and analytics relevant data
• Post-rollout white/black box testing of new releases: Integration, system and user acceptance tests
• Third level support: Investigation, troubleshooting and problem solving on production environment
• Designing of normalized logical and physical database models to develop OLTP system prototype
• Enhancement of product performance and data base tuning: Optimization of complex SQL queries
• Development of batch job data validation, cleansing and automated job monitoring system activity
• Queue Management for tickets / service and change requests on Test and Pre production environments
• Contribution to project management activities: delivery optimization, effort, time and risk estimations

Environment: Windows, Linux, Oracle, SQL, PL/SQL, Mondrian MDX, SP, TOAD, Kimball Dimensional Modeling, Power Designer, Pentaho RD, Pentaho BI Analysis/Data Integration, Perl, Shell scripts, XML, UML, PostgreSQL, PG Admin, SVN, Nagios Monitoring, Autosys, Jira, MQ Series, Talend Open Studio, MS Office suite, Agile (Scrum)

SR. IT Consultant

Confidential

Responsibilities:

• Collaborating with key partners and stakeholders to identify the requirements and design the dataflow
• Evaluate current data model and implement best practices in data modeling, integration and data quality
• Contribution to the research and development activities made to implement new customer requirements
• Performing regular data profiling and data cleansing activities in order to detect data inconsistencies
• Creation and maintenance of specification and technical design documentation on SharePoint portal
• Providing oversight and recommendations to integrate data sources into the enterprise data warehouse
• Planning, documentation and execution of end to end integration and user acceptance test cases

Environment: Windows XP, Linux, putty, SQL, T-SQL, XML, UML, Python, Visual studio 2005, Jira, Shell Scripts, Python, SSIS, SSAS, SSRS, MS Office, Agile-Scrum

SR. IT Consultant

Confidential

Responsibilities:

• Leading the progressive and corrective maintenance of HR Post Payroll Solution and data lake structure
• Owning and governing project delivery in terms of data processing, metadata management and artifacts
• TEMPEffectively communicating with the client to identify functional needs and evaluate solution alternatives
• Producing detailed technical design documents based on client business requirements and specifications
• Design and implementation of end to end post payroll dataflow: interim funding and bank reconciliation
• Meeting business requirements by development and integration of automated Oracle PL/SQL Packages
• Design, testing and automating stored procedures in different environments: dev, test, pr-prod and prod
• Performing detailed unit, quality assurance and regression test in order to validate production readiness
• Fine-tuning of complex SQL queries, revision and refactoring of existing code to improve performance
• Monitoring daily production data loads, troubleshooting ETL failures, identifying and fixing data issues
• Onboarding new data sources with periodic refresh and integration with existing dimensional models
• Reviewing and enhancing data visualization modules and outlining more value out of the reporting data
• Data Integration of product migrated entities from R7.2 to R8 and assistance in functional testing cycle

Environment: Windows XP, Linux, SQL/PL-SQL, ORACLE, TOAD, OBIEE, ODI, XML, UML,HRD STUDIO, COBOL, shell script, Crontab, SVN, Erwin Data Modeler, Microsoft Office, Agile-Scrum

IT Consultant

Confidential

Responsibilities:

• Gathering and integrating multi-platform data to set up the relational strategy and action type settings
• Estimating work effort and complexity for delivering new artifacts supporting the current data model
• Analyzing relevant data for marketing and sales actions monitoring such as payment tracking
• Performing data source discovery through reverse engineering and defining source to target mappings
• Developing and maintaining views, stored procedures, user-defined functions and SQL Agent Jobs
• Writing and automating data cleansing scripts to check up new data entries, detect and report anomalies
• Performing root cause analysis, and developing TEMPeffective solutions to existing data compatibility issues
• Applying standard data definitions, transformations and business rules to extend the Data Warehouse
• Fine tuning the ETL pipeline mappings by removing the bottlenecks and improving data load balancing
• Managing the evolution of logical and physical data models and maintaining related documentation
• Implementing the business decision process using SQL Server BI Studio and data mining techniques

Environment: Windows XP/Server, Linux, SQL/T-SQL, MDX, SQL Server (Enterprise Manager, Query Analyzer), MS BI Stack: SSIS, SSAS, SSRS, Shell Script, XML, UML, ERWIN, Postgres, Putty, SVN

IT Consultant

Confidential

Responsibilities:

• Contributing to the design and implementation of the new call manager dataflow, by-passing the CTI
• Development of stored procedures, shell scripts and custom SQL code for data retrieval / persistence
• Extending and maintaining logical and physical data models and related metadata to support solution
• Design and development of new re-usable ETL components to support existing ETL packages
• Reviewing full ETL pipeline and performing unit, regression, and full end-to-end data integration tests
• Extracting, processing, tracking and analyzing data to generate standard and custom cross tab reports
• Developing detailed functional and technical design documents, test cases and support documentation

Environment: Windows, Linux, SQL/T-SQL, MDX, SQL Server, SSIS, SSAS, SSRS, Visual Studio, Shell Scripts, Python, Genesis, IVR, CTI, JDBC, UML, Erwin Data Modeler, Microsoft Office