Resume

Sign in

Data Engineer

Location:
Riverview, FL
Posted:
January 08, 2020

Contact this candidate

Resume:

Professional Summary:

Six+ years of IT industry experience in Application Development, Maintenance, Testing, Support and Production projects.

Extensive experience with analysis, design, development, customizations and implementation of software applications.

Proficient in analyzing business requirements.

Good knowledge in DataStage, Abinitio, Oracle, Unix and Data warehouse knowledge.

Good knowledge on Microsoft Excel, Word and Powerpoint

Handled roles – Technical consultant, Application Developer, Associate system engineer, Environment support, Production support and Business analyst.

Executed software projects for Banking and Insurance industry.

Excellent understanding and experience in complete project life cycle (design, development, testing and implementation).

Ability to transform data according to the client requirement.

Experience in troubleshooting the issues related to data.

Proven Experience in working on UNIX Shell scripts.

Extensive experience working with Oracle and My SQL database.

Hands on experience in Putty

Worked with IBM Info sphere Data Stage 7.5

Excellent knowledge in complete life cycle of an Enterprise Data warehouse.

Involved in testing the developed jobs by other employees and self-developed.

Good knowledge in data warehouse concepts like Star Schema, Snow Flake Schema Dimension and Fact tables.

Expertise knowledge in all components of Data Stage.

Experience in designing Sequencer jobs.

Knowledge in writing test cases.

Used Data Stage Developer to Develop the jobs

Used Data Stage Director to monitor the jobs.

Used Data Stage manager to Export and Import the jobs.

Used GIT Versioning tool to Maintain the versions of code

Mapping the data to appropriate fields to the output after transformation.

Extensively worked on Join, Lookup, Transformer, Sort, Filter, Funnel, Row-generator, Column generator etc.

Participating in team stand-up meetings and Peer reviews

Team player with good communication skills, interpersonal skills, self-motivated, quick learner, team player, and also a self-motivated individual with exemplary analytical and problem-solving skills.

Education:

Bachelor of Technology in Information Technology from Malla reddy Institute of Technology Hyderabad India

Technical Skills:

Professional Experience:

COMPANY: INFOSYS Aug 2019 to Dec 2019

CLIENT: CITI GROUP

POSITION: Business Analyst

LOCATION: TAMPA, FLORIDA

Environment: Windows 10, Microsoft Excel, Word and Powerpoint. Description: The Citi Finance Transformation is focused on improving its efficiency and effectiveness while also putting it in a better position to meet increasing regulatory, informational and Analytical demands. This transformation is critically dependent on establishing a global, common operating model, based upon a foundation of data standards and on enabling technology infrastructure. To this end, Citi Finance is launching a global initiative that will leverage and expand upon the GENESIS program already underway.

Financial Full suite is a comprehensive, process-enabling infrastructure which manifests data and process standards in support of global, common operating model. Full Suite will serve all of the Citi Finance as well as the functions such as Franchise Risk & Strategy that require an anchor to financials encapsulated within a set of standard processes. By enabling multi-GAAP books, daily processing and granular data organized by legal entity, this streamline reporting and meet today's increased demand for information.

ETL Tools IBM Infosphere DataStage 8.1, DataStage 7.5, Abinitio Databases SQL Server, Oracle, Netezza

Query Languages SQL, Unix Shell Scripting, PL/SQL

Operating System Windows 98/2000/XP/7/10 and UNIX

Responsibilities:

Worked with business stakeholders and other SMEs to assess current capabilities, understand high-level business requirements and applied technical background/ understanding in the development of Functional Requirements documents

Worked with the IT Specialists (Solution Designers, Configuration, Data Modeler, Test) to translate user and/or Business requirements into functional technical specifications

Support testing teams in translating requirements and use cases into test conditions and expected results for product, performance, user acceptance, and operational acceptance testing; participate in the testing of developed systems/solutions

Conducted stakeholder sessions to complete and document detailed Functional requirement documentation

Adhere to existing processes/standards including the system development life cycle

(SDLC) and project management methodology (PMLC), business technology architecture, risk and production capacity guidelines and escalate issues as required

Participate in quality management reviews, in particular reviews of the designs, prototypes and other requirements work products to ensure they fulfill the requirements COMPANY: IBM

CLIENT: CITI GROUP Oct 2016 - Aug 2019

POSITION: ETL Support

LOCATION : TAMPA, FLORIDA

Environment: Abinitio, Tectia, Putty, SQL server, Windows 10, UNIX, Shell Scripting. Description: Faem Extension Facilitates adjustment capture by using templates, Validation of adjustments, routing them for approval and Real-time feedback of completion status. It aims to consolidate Faem as single point of entry for all adjustments to closing platforms like smart. Caters legacy systems in a consistent and independent manner. Delivers enhancements to current manual process of uploading adjustments into SMART via direct posting of files from FAEM EXTENSION to Genesis and other systems.

Faem Extension facilitates: Online Capture, upfront validation, routing for approval and posting, Threshold enforcement, compliance with adjustments directive it will bring significant improvement on adjustment data upon submission rather than at a later stage. Will eliminate duplicative effort of adjustments into legacy systems. Will improve control given approval routing and audit trail functionality. Added customer value for requestors to better manage the month end close process.

Responsibilities:

Involved in Data verification to determine the data was accurately translated in to the new system

Help users with FAEM validation Issues during adjustment upload.

Provide resolution for DA validation and Enrichment issues.

Resolve User entitlements and access issues.

Involved in User support

Give feedback to seniors to contribute to the nonstop improvement of test procedures in changed environment without any overheads

High level and Low level Documentation.

Participated Performance tuning of Data stage jobs, Unix scripts and SQL statements

Did data validation across the environment.

Monitored the jobs and provided the support to all.

Handled the issues from the new environment by modifying jobs. Also ensured the jobs ran without any load balancing issues.

Involved in enhancing existing UNIX shell scripts to obtain desired outputs.

Being Team Lead, Provided Knowledge transfer to team mates and helped achieve acquired results.

Documents architecture decisions, design standards, documentation templates and checklists for development.

Work with program management to track program status, perform technical reviews and provide inputs to software testing.

Analyze software defects, perform alternate analysis of software issues and create remediation designs.

Perform implementation readiness reviews, capture key indicators for implementation and deploy software for clients.

Work with clients for continuous maintenance of the software and apply product upgrades as needed.

COMPANY: IBM Jun 2014 to Oct 2016

CLIENT: CITI GROUP

POSITION: ETL Support

LOCATION: HYDERABAD, INDIA

Environment: Abinitio, Tectia, Putty, SQL server, Windows 2000/XP, UNIX, Shell Scripting. Description: The Citi Finance Transformation is focused on improving its efficiency and effectiveness while also putting it in a better position to meet increasing regulatory, informational and Analytical demands. This transformation is critically dependent on establishing a global, common operating model, based upon a foundation of data standards and on enabling technology infrastructure. To this end, Citi Finance is launching a global initiative that will leverage and expand upon the GENESIS program already underway.

Financial Full suite is a comprehensive, process-enabling infrastructure which manifests data and process standards in support of global, common operating model. Full Suite will serve all of the Citi Finance as well as the functions such as Franchise Risk & Strategy that require an anchor to financials encapsulated within a set of standard processes. By enabling multi-GAAP books, daily processing and granular data organized by legal entity, this streamline reporting and meet today's increased demand for information.

Responsibilities:

Collection of data from various sources

Transforming and enriching the data collected.

Loading the data to the Sub GL/GL in form of Journal files.

Identify, analyze and fix the issues in the production system.

Interface with various clients to understand the business issues related to the same and convert it to technical solutions.

Generate Reports for various applications based on their run statistics.

Reports are generated weekly/monthly or quarterly.

Track various ETL application run status and assist in activities to meet the daily SLA for business users.

Interface with business users to understand reporting requirements and assist creating new analytical reports.

Provided on call support for the client. Activity includes fixing and attesting issues post normal working hours.

Accept incidents and work towards fixing the issues in the mission critical applications. COMPANY: IBM Mar 2013 to May 2014

CLIENT: COMMON WEALTH BANK

POSITION: ETL Developer

LOCATION: BANGALORE, INDIA

Environment: Data Stage, Tectia, Putty, SQL server, Windows 2000/XP, UNIX, Shell Scripting. Description: Program Unlock is seeking to transform the business landscape in regard to the claims process. One of the key concepts defined in the program’s TCD was the creation of a Policy ODS. It is seen as a strategic application that will enable easy data integrations for the current systems and also enable easier data flows for future COMM Insure projects. The objective of this project was to integrate data from 3 source systems and move them to conformed view tables according to business requirements. Responsibilities:

Collection of data from various sources.

DataStage jobs development.

Deployment of code into various environments.

Transforming and enriching the data collected.

Loading data into Polilcy Ods and Conformed view tables.

Prepared Test cases

Preparing release notes for production releases.

Monitoring jobs running daily in all environments.

Fixing defects in code, when detected.

Maintenance of code across all environments.

Maintenance of versions of code using Git versioning tool.

Partner with clients to understand their business requirements and translate them to technical specifications.

Analyze, reverse engineer business applications and perform gap assessment to recommend strategic target state of business and technology architecture.

Synthesize requirements, apply best practices, and identify architectural components of the system.

Identify IBM products and services that best fit the technical requirements and design applications for architectural components.

Generate data models, application integration pattern and create technical instance specifications for development.



Contact this candidate