We provide IT Staff Augmentation Services!

Datastage Administrator Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • Support experience in 3 languages (English, French, Spanish)
  • System administration and Applicative Technical Support Experience
  • Experience in analysis, design and development of ETL, Business Intelligence applications and ERPs’
  • Natural Traits: Discerning, analytical, meticulous, attention to detail Areas of skills
  • Resolution of problems, requests and analysis demanded by clients on Oracle PL/SQL, MSSQL Server, IBM Informix SQL developer, DB2, Teradata
  • Development of databases, on IBM DB2, Teradata, PL/SQL, SQL, MS SQL (Creation of queries, stored procedures, functions, packages, and troubleshooting, Query and Environment performance optimization)
  • Quality Assurance and Integration of ETL / BI / ERP Systems
  • Technical support proprietary application
  • Contact for different teams; infrastructure, networks, Data Warehouse, Quality Assurance, business
  • Team Coordination / follow - up / Organization / Mentoring / Agile-Scrum Methodologies
  • Processus Monitoring.
  • Configuration and Administration of Networks systems / routers under Unix and Windows
  • Drafting of functional and technical specifications documentation and user manuals / guides

TECHNICAL SKILLS:

Systems: Windows, UNIX/Aix, Linux Red hat, OS/2

Languages: MS PowerShell, Python, SQL, PL/SQL, T-SQL, C, C++, VB, XML, Cobol, Scala, Assembler, Troubleshooting abilities of JAVA code, Delphi

RDBMS: TERADATA 16.20, MSSQL Server 2005/2008/2012, ORACLE 9/10g/11g, IBM DB2 (Interactions with: SAP SYBASE, INFORMIX, MS Access)

Oracle Tools: SQL Developer, SQL*Plus, PL/SQL, TK PROOF, Explain Plan

Net Protocols: Windows Server 2003/2008, development of data communication protocols, Novell, DSL, TCP/IP, configuration routers / hub / switches

ETL/BI Tools: IBM InfoSphere DataStage 11.5, 11.7 Confidential ETL (in House Developed / Similar to Informatica) ETL ETI*Extract, MS SSIS, SQL Loader, Ksh Scripts. BI Platforms, Micro Strategy 7.5 / 8.1 / 9.2, SAP BO XI 3.1 Deski / WebiBatch scheduling: Autosys, AutosysR11, Control-M

Scripting: KSH(bash), Perl, MS PowerShellOther tools: IntelliJ, CWB(Reporting Tools Confidential (.net)) SQL Server Management Studio (SSMS), MS Visual studio 2012, VMWare 5.5, Lotus/Notes, 4/R5/R6/R7/Social Edition, MS Outlook, Terminal Service, VPN, Dame Ware IEE 5+, Active Directory, Zone Labs, Integrity client, Ultra Edit, FileZilla, Clear Case (versioning), TFS(Team Foundation Server) ARS Remedy, Putty, Git (under an Agile Env)

PROFESSIONAL EXPERIENCE:

Confidential

DataStage Administrator

Responsibilities:

  • Developing DataStage installation and support guides that are consistent with IT security policy.
  • Providing third level support regarding DataStage product related issues.
  • Developing new tools and processes to ensure effective use of DataStage product.
  • The position will also be responsible for administrating and maintaining a DataStage shared environment, this includes:
  • Designing and sizing the environment. installing patches when required.
  • Monitoring and analyzing the audit usage data to ensure the optimal usage and efficient performance of the infrastructure.
  • The position will work with the application administrators and development teams to ensure the shared environment resources are optimally utilized.
  • Among other tasks we also:
  • Provide infrastructure operations support and administration of the 11.5 and 11.7 DataStage environments. This includes setting up and testing new installations of DataStage, QualityStage and Information analyzer.
  • Engineer and Install/upgrade Information Server product suite. Post install Configuration, various data sources configuration for the plug-ins, connectors as well as ODBC configurations.
  • Document Runbooks for the installs, Disaster Recovery plans etc...
  • Stop/start services, monitor logs, setting up Security, assigning roles, project permissions, Create/Delete projects, create/modify environmental parameters etc.
  • Monitor the InfoSphere suite (Data Stage/Quality Stage) servers. Kill/assist release job locks, shared memory locks, hung processes etc...
  • Apply fixes, patches and service packs as required. Ensure infrastructure and application stability through preventative maintenance, monitoring, troubleshooting, and implementing long term solutions.
  • Capacity planning for new projects in the shared environment.
  • Support and troubleshoot production incidents/problems, optimizing performance.
  • Provide technical expertise and development support for the ETL development team.
  • Good understanding of ETL Best Practices in design and implementation.
  • OnSite resource required due to frequent interaction with other engineering, operations and development teams.
  • Occasional weekend and after-hours work required to implement software upgrades.

Technical environment: Virtual Citrix Env: Windows 7/10 and UNIX AIX Bash 5.3. Linux RedHat, GitHub (Win versioning), DB2 / Oracle, Putty, Ultra Edit, Notepad ++, Citrix VM, KSH Shel Scripts, MS PowerShell, AutosysR11, All within an Agile scrum environment.

Confidential

BI Analyst - Developer / DB Developer

Responsibilities:

  • Our team is responsible for monitoring the databases of our application perimeter and their proper functioning. We also troubleshoot technical problems of the batch executing during the day, and month end.
  • I also worked closely with the bank s Business Analysts (BAs) in NYC and New Jersey. I collected the prerequisites and proceed to the functional study of the requirements and develop the necessary solution to the application evolutions, and new features.
  • Finally, we deliver in QA, UAT and production environments, our solutions and improvements
  • Once all these steps were completed and accepted by the customer. I proceed to create the documentation of the solution for its deployment in production as well as its maintenance and for support purposes

Technical environment: Virtual Citrix Env: Windows 7/10 and UNIX AIX Bash 5.3. Linux RedHat, GitHub (Win versioning), MS SQL Server / DB2 / Teradata, ELCABALLO (In House ETL Developed, CWB Controllers Workbench reporting Tools (.net)), Putty, Ultra Edit, Notepad ++, Citrix VM, KSH Shel Scripts, MS PowerShell, AutosysR11, IntelliJ, Scala(Java). All within an Agile environment.

Confidential

BI Analyst - Developer / DB Developer

Responsibilities:

  • One of my responsibilities has also been to solve production problems in our integration processes as well as data transformation.
  • Our team is responsible for monitoring the databases of our application perimeter and their proper functioning. We also troubleshoot technical problems of the batch executing during the day.
  • I also worked closely with the bank s Business Analysts (BAs) in NYC and New Jersey. I collected the prerequisites and proceed to the functional study of the requirements and develop the necessary solution to the application evolutions.
  • Finally, we deliver in QA and production environments, our solutions and improvements
  • Once all these steps were completed and accepted by the customer. I proceed to create the documentation of the solution for its deployment in production as well as its maintenance and for support purposes

Technical environment: Windows 7 and UNIX AIX Bash 5.3. SVN (Win versioning), MS SQL Server 2012/2014, SSIS, SSRS, FileZilla, Putty, Ultra Edit, Notepad ++, Citrix VM, KSH Shell Scripts, MS PowerShell, Autosys, TIBCO BW, TFS.

Confidential

BI Analyst - Design and Development

Responsibilities:

  • One of my responsibilities is also to produce and create solution for production issues of our processes.
  • Our team was responsible for the DB operations within our perimeter. We had to troubleshoot any arising Database technical issues, and find solution to communicate to the DBA team.
  • The range of my responsibilities comprehended also the requirements gathering process and functional study of the solution passing thru the development of the required software solution or evolution.
  • Finally, we deliver in the production environments our enhancements and solutions.
  • Once all these steps are completed and accepted by the client. I proceed to the documentation drafting of the solution provided for its deployment in production and for recording and supporting the context of the application and its evolution

Technical environment: Windows 7 and UNIX AIX Bash 5.3. CVS (Win versioning) and TFS (Team Foundation Server) MS SQL Server, SSMS, SSIS, FileZilla, putty, Ultra Edit, Citrix VM, KSH Shell Scripts, Python

Confidential

BI Analyst - Functional study engineer, design and development

Responsibilities:

  • I collaborate in the drafting and/or modification of the documents in the requirement gathering from client. To proceed to the functional study of the request for the application’s evolution and/or development. Subsequently, under the conduct of the business analysts’ and the scrutiny of the client’s requirements, I draft new technical or new organic analysis documentation.
  • Draft files on cost and estimates for developments and evolutions
  • Draft exploitation documents
  • I develop packages for data Extraction, Transformation and Loading (ETL processes), the process is done by several means starting by Shell KSH scripts and Oracle technologies: PL/SQLv3.20 via scripts, packages, ORA stored procedures and functions, SQL Loader
  • I assist and follow-up the functional validation phase from Analyst
  • I provide correction of anomalies to issues at the functional audit, and deployment testing phase
  • I take part to the hot fixing of incidents in production
  • I supervise and certify the chronogram processing delivery
  • I play a part in the improvement of the overall software solution operations
  • I draft documentation of the development process
  • I produce BI reporting solutions and development on the SAP Business Objects (BO XI) platform
  • Environment and Queries Optimization (database 20TB)
  • Master of Oracle tools (SQL Plus/SQL Loader)
  • UNIX environment and development shell (ksh) expertise
  • Knowledge of the versioning tool Windows and command line Tortoise
  • Knowledge of ETL tools (ETI*extract, MS SSIS)
  • Understanding of SAP BO XI, WEBI and DESKI management and fix of anomalies of the QA phase to
  • Researching, solving and applying hot fixes in production etc.…
  • I have good negotiation skills to: be able to propose technical solutions to optimize the processes and to propose the best technical solution
  • I have a good interpersonal skills: which assist me in collaborative work within the department and inter-operational groups
  • I am capable to manage multiple projects at the same time
  • I am Autonomous. Particularly I know how to find the information using the documentation and existing tools as well as the web

Technical environment: Windows 7 and AIX Bash 5.3. Tortoise (Win versioning) SQL developer, PL/SQL, Oracle 10g, 11g, SAP BO XI, FileZilla, putty, UltraEdit, Citrix VM, Autosys, SAP Sybase IQ, Shell/Perl Scripts

Confidential

BI Developer, engineer

Responsibilities:

  • The drafting of functional documents DCDI (Dossier de Conception Détaillé en Informatique) under the conduct of Business Analysts reflecting the client’s requirements into technical documentation
  • The study of the impacts and the costs estimates
  • The drafting of the documentation of exploitation
  • The Development of application of data loading and data extraction of the data warehouse (predominantly by an ETL, the rest of the development uses shell scripts KSH and Oracle technologies: PL/SQL via stored packages ORA, SQL Loader)
  • The assistance and follow-up of the functional validation phase
  • The correction of anomalies after return of functional verification, integration tests
  • The hot fix of incident in Production
  • The supervision and the Chronogram validation of delivery
  • The application optimization
  • The documentation of the process of development
  • End of Mission Contributed to the migration to new technologies Teradata DW, and ETL Data Stage
  • Knowledge of relational databases (SQL), in particular Oracle 10g, 11g (PL/SQL). A knowledge of query optimization is desirable (volumetric of the database to 6TB)
  • Master of Oracle tools (SQLplus / SQLLoader)
  • Master of the UNIX environment and development shell (ksh)scripts
  • Knowledge of a tool of versioning command line (Clear Case)
  • Knowledge of an ETL (ETI*Extract)
  • Reactivity and flexibility: be able to move, without any specific order, from:
  • To the functional Analysis and document drafting phase
  • To the development phase
  • To the management of anomalies returns of the QA process
  • To the correction of issues in production
  • Capacity of Proposal: To be able to recommend technical solutions to optimize the treatment and to suggest the best technical solutions
  • Good relationship: collaborative work within the department and inter-operational groups
  • Adaptability: the skill to manage multiple projects in parallel
  • Autonomy: especially identify the required information using documentation and existing tools as well as the web.

Technical environment: Windows 7 and AIX Unix Bash 5.3.12.1, Hummingbird, Clear Case(versioning) SQL developer, PL/SQL, Oracle 10g,11g, Shell/Perl Ksh Scripts, FileZilla, putty, Ultra Edit, C/C++ Programming languages

Confidential

Responsibilities:

  • The technical support of the integration tests of plasma, on the environments of development, qualification, and production.
  • The Develop and analysis of the requirements, creation of environments, interfaces with other applications such as SIBES (mainframe application)
  • Guarantee the coordination of the technical teams of development, qualification and deployment in the framework of the recurring activities: installation, upgrade, qualification, benchmarks, tests, detection and reproduction of anomalies and incidents.
  • Improve the management of the technical environments by the adoption of a suitable governance and the enrichment of the documentation of plasma for its installation and operation
  • Solve / analyse / research issues or problems, related to the BI MicroStrategy system or to improve queries in reports that are too slow or too complex under MS SQL server.
  • Responsible of the BI MicroStrategy technologies software and hardware infrastructure as well as of their maintenance and upgrades
  • Ensure the validity of the technical choices regarding the BI platform and its components
  • Maintenance and evolution of the life cycle of the applications, process under my responsibility more in particular the BI Platform: MicroStrategy BI platform and VMware virtual environment (Windows Server 2008).
  • In my role as the MicroStrategy administrator I managed the licenses pool for exploitation,creation, deletion and maintenance and troubleshooting of user’s pool.
  • Technical support for complex problems of 2nd and 3rd level issues, regarding the BI Platform.
  • Participate in the development and improvement of standards and procedures for application infrastructure
  • I participated in the implementation of the required MicroStrategy environment components (like: functions, filters, KPI, etc.) for the reports analysis and creation.
  • I gather and analyze client’s requirement and requests for new MicroStrategy reports, charts, dashboards. within the scope of MicroStrategy platform
  • I created the required MicroStrategy reports in assistance with business analyst to model and translate technical client’s requirements into financial reports and also production reports for the company’s CFO office consumption
  • I lead a MicroStrategy technical team for the platform environment upgrade for two different upgrades from version 7.5 upgrading to version 8.1
  • Analyze problems of level 2 and 3 of the ERP application concerning the queries, materialized views, tables, functions, stored procedures, etc. with Oracle debugging tools as; Explain Plan, TK proof, SQL Trace
  • Create loading tests as well as stress test in PLSQL to certify the capacity on the use of databases in moments of high demand
  • Do in-depth analysis and tests using PL/SQL language to write (SQL queries, functions, procedures and packages)
  • Perform specialized analysis to corroborate the technological choices
  • Oversee the maintenance and the evolution of the technological infrastructure; application upgrades to the databases of the Oracles customers

Technical Environment: UNIX and Windows, Oracle 9/10/11G, PL/SQL, SQL develop, Tortoise SVN, Delphi

Confidential

Responsibilities:

  • Analyze different sort of problems with the software developed by Scancode Inc. on the production environments of clients (Rodgers Communication Inc. 2ieme telecommunications company in Canada)
  • Problems must be analyzed with several tools at our disposal as: log files, codes of error message, SQL scripts, SQL Queries, and Scancode debugging tools.
  • Problems come from several sources: Programming errors, bad setup or incorrect configuration, problems of integration, Licenses versions dates of files expired, problems linked to the hardware used, problems not related to the application Scancode or its databases, problems related to the network.
  • Working in close collaboration with the following teams: Logistical experts’/database administrators, experts in XML Messaging, rate groups, group of carrier’s compliance (FedEx, UPS etc), Quality Assurance.
  • Close communication with the client at all times is vital to share with them our advances and the approximate time of resolution

Technical Environment: ERP owner Scancode Logistics, UNIX/AIX, Linux/RedHat and Windows, Novell, Informix (procedures, queries, troubleshooting…), Visual Basic

Confidential

Site Administrator

Responsibilities:

  • Manage the IT and related equipment as well as solve problems related to the computers on clients premises
  • PC and Laptops’ systems configurations.
  • Operate scheduled Servers backups
  • Configurations of network equipment. switch and routers.
  • Check that all systems are working fine and without faults for users.
  • Keep communication channels open with team leaders to track problems generated or found on or off-site or LAN/WAN.
  • Provide basic to users on equipment and software specific to each CSC client’s users.
  • Develop small applications: Macro Excel, Word.

Technical environment: Windows, AS400/mainframe, Shell, LAN/WAN, TCP/IP, Active Directory, Novell

Confidential

Responsibilities:

  • Manage the team of developers.Network and data communication Concordia University Montreal, Canada)
  • Develop several communication protocols in a client - server environment, protocols of the TCP/IP family suite
  • WinSock application, in a Windows NT environment, Netware, Visual Basic C++Developing of the didactical Operating System (U.C. Berkeley, N.A.C.H.O.S.)
  • Manage the development team of 3 people.
  • Develop an scheduling policy for the operating system,
  • Develop a system to manage the operating system service calls.
  • Develop an OS synchronization system for the processes in the execution mode.Work carried out in a programming language C and C++ in a Unix environment
  • Coordinate the design and architecture process of the project.
  • Manage the development team.
  • Design and develop an information system to manage the data of customers and employees of the fictitious Bank.
  • Produce a Relational database RDBMS using Oracle and create all queries using SQL Plus.
  • Develop the graphical user interface (GUI) using Oracle Forms.

We'd love your feedback!