Halley Nikolak

Contact Please use the form
Technical Skills IBM Data Stage 8.0, 7.5.1.A, 7.0
Teradata
Cognos 8
Control M
Unix and Linux
MS Office
Niku / Clarity - Project management tool
Oracle 8i, 9i and 10g
MS SQLServer 7.0, 2000 and 2005
Sybase 11.9.2 and 12.5
DB2
FinArch
MS SQL Server Analysis Services
Meridium V2 and V3
Access
Borland Delphi 5 and 6
MS Visual Basic 6
PHP 4
ASP and IIS
JAVA, JSP, JavaScript
XML/XSL
Hyperion Designer (BRIO)
Visual Source Safe
MS Project
Crystal Reports 8, 8.5, 9 and 10
Remedy - Action Request Systems
Experience Jun/11-Present HSBC - HSBC Technology Services Europe
Senior Analyst Developer - Business Intelligence Reporting Analyst
  • Performed requirement gathering and analysis for several regulatory reports
  • Created a wide range of documents including End to End design, High Level Design and Cognos Report Layout Models. Also assisted the developers on the Low Level Design
  • Provided technical coordination between the analysis and development team identifying tasks that could be done in parallel, eliminating he gap where developers were allocated but had no tasks assigned
Apr/09-Jul/11 HSBC - HSBC Technology Services Europe
Senior Analyst Developer - Business Intelligence Technical Leader
  • Ensuring that accurate, clear, commented and efficient program code is produced from a wide range of specifications
  • Responsible for creating functional and technical design of Business Intelligence solutions and relevant documentation
  • Participated on the architecture design development of a flagship project using Teradata, DataStage and Unix
  • Responsible for developing and reviewing DataStage, Teradata and Unix code
  • Involved with unit, system and integration testing, including creation of test cases and production of associated test documentation for DataStage, Teradata and Unix codes
  • Provided technical support for UAT and Production
  • Process system data via Control-M batches
  • Coordinated development tasks for a third party
  • Assisted offshore staff on DataStage and Teradata technical development
  • Guided offshore development staff on architectural design ensuring that it would adhere with the other existing modules
  • Provided and supported development tasks with an offshore team monitoring their progress against plan
  • Provide detailed estimates for development effort from design documents
  • Ensure that work adheres to the company's and sector standards
  • Control and support the implementation of releases
Feb/08-Dec/08 HSBC - GLT Software Development Brasil
Senior Software Analyst - Project Technical Leader
  • Performed business analysis to projects financial report projects
  • Produced high level overview and technical specification to be used by business clients and developers
  • Leading an offshore development team providing technical guidance
  • Performed support activities to identify the cause for data defects within the BI environment
Aug/07-Feb/08 HSBC - GLT Software Development Brasil
Senior Software Analyst - Offshore Onsite Coordinator and Team Leader
  • Team Leader of 15 developers for BI projects allocated in Sheffield UK
  • Defined team hierarchy, internal procedures and new documentation to improve deliverables quality
  • Produced engagement chargeback recovery plan with a forecast of three months and several scenarios according to possible team changes
  • Achieved goals established with GLTb leadership regarding increasing utilization rate, cost estimation and implementing new quality procedures
  • Created several management reports and tracked different types of information to allow a tangible measurement of KPI’s
  • Recruited technical leaders and developers for offshore team
Apr/07-Aug/07 HSBC - GLT Software Development Brasil
Senior Software Analyst  - Offshore Onsite Coordinator
  • Focal person to manage interaction between BI team in UK(located in Sheffield) and GLTb team ensuring an effective communication between both teams
  • Produced resource ramp up plan of the development team
  • DataStage, ETL and SQL support contact for GLTb developers
  • Provide assistance on new projects regarding the appropriate architecture design to achieve optimal results at low complexity of BI solutions developed offshore
  • Resource manager to ensure full utilization of developers ensuring that no spare time would occur by forecasting supply and demand and supply forecast and skill set
  • Ensuring correct skill set is assigned to meet project requirements
  • Understand issues and concerns of projects escalating to the relevant parties and monitoring them until resolved
  • Identified new opportunities for BI Projects which lead to the deployment of three offshore resources to bolster an onshore lack of a key skill set, analysts
  • Assisted team in UK to create new procedures and templates to improve productivity
  • Provided weekly project status report on ongoing projects containing additional information then the standards helping project managers to identify and resolve issues before they became a risk to the project deliverables
  • Created an Intranet portal to share knowledge across GLTb team
Jun/05-Apr/07 Esso Brasileira de Petróleo - ExxonMobil
Support Analyst
  • Support of Refinery Assets Reliability System provided by the software Meridium
  • Maintenance of ETL processes using DataStage
  • PL/SQL, Unix Shell Script development
  • Auxiliary refinery safety applications development using Visual Basic 6, Access and Crystal Reports 8.5
  • Development of an internal application to manage and monitor tickets(Remedy) VB Script in MS Access helping to provide updates to the senior management
  • SQL Server Analysis Services cubes maintenance
  • Creating and maintaining system documentation
  • Team Agent for Management of a Global Organization Project
Sep/04-Jun/05 Cinq Technologies
System Analyst
  • Offshore project - Development reports and Oracle ETL (Extract Transform and Load) packages/procedures
  • Responsible for creating report and ETL process design and technical documentation
  • Developing marketing reports using Crystal Reports and data warehouse ETL processes
  • In charge of designing the architecture concept of data transformation and extraction process including several execution and integrity controls
  • Responsible for controlling code version and releases to the client
  • Responsible for installing and maintain the project environment, including Oracle DBA activities and the server administration using Linux Red Hat 9
  • Report development for Business Intelligence using Hyperion Intelligence Designer (BRIO)
Jun/01-Sep/04 PUCPR - Pergamum
Developer
  • Library Management System
  • Software development using Borland Delphi 5, Seagate Crystal Reports 8, PHP and ASP
  • Data warehouse development
  • Participant of Linux installation to use the search engine HtDig
  • SQL Stored Procedure development using Sybase 11.9.2 and 12.5, Microsoft SQL Server 7 and 2000 and Oracle 8i and 9i
Skills
  • Extensive experience performing different roles within software development life cycle, covering end to end
  • In-depth knowledge of software outsourcing models
  • Committed, dynamic, self-starter, fast learner, proactive and flexible
  • Customer-focussed and with ability to communicate at all levels
  • Know-how on team administration and management
  • User helpdesk and support experience
  • Experience with instructing internal team training
Languages English: Fluent
Portuguese: Fluent
Spanish: Basic reading and verbal understanding
Training Instructed Oracle 9i to company employees. April-2005
Instructed Crystal Reports 10 to company employees. April-2005
Instructed Hyperion Designer to company employees. May-2005
Meridium V3 training attended at Meridium Inc headquarters in Roanoke, VA, USA. Jun-2005
Working Globally - Increased cultural awareness. May-2006
Presentation Skills. September-2006
Database (Oracle) - Performance and Tuning. November-2006
Data Stage PX. May-2007
Managing IT Projects in HSBC. Feb-2008
Essentials for IBM Cognos 8 BI. Sep-2011
Education 2000-2003 Pontifícia Universidade Católica do Paraná - PUCPR
  • Bachelor degree in system analysis

2004-2004 Pontifícia Universidade Católica do Paraná - PUCPR

  • Marketing specialist - Post graduation
Right of work I am authorized to work in the UK for any employer
Interests & Hobbies Music and Musical Instruments(Drums and Guitar)
Aviation
Sports (Roller and Ice Hockey, Cycling, Football, Swimming and others)