We provide IT Staff Augmentation Services!

Sr. Software Developer Resume

SUMMARY

  • 12+ years in IT working in Data Warehouse & Business Intelligence solutions with an emphasis in Data Integration, Data Quality Management including ETL, Data Profiling, Enrichment as a developer and team lead.
  • A track record in providing technical expertise, delivery and consulting across Business Intelligence, Data Warehousing, Data Migration and Data Integration projects.
  • Developing and supporting enterprise ETL implementations in business critical applications with a demonstrated ability to be the subject matter expert in designing, developing, supporting, maintaining, and administering complex ETL projects.
  • Working in technical roles on a combination of operational support and development/project based work.
  • Various problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction.
  • Ability to multitask in a fast paced environment and deliver on tight/agile time frames.
  • Willingness to adapt and learn new skills/technologies.

TECHNICAL SKILLS

Industry Domains: Banking and Finance, Manufacturing, Automobile, Media and Entertainment, Health Care

Operating Systems: Windows, UNIX, LINUX

Scripting Languages: Apache Hive, SQL, HTML, Unix Shell Scripting

Databases: Oracle, Teradata, SQL Server, Netezza, DB2

ETL Tools: IBM InfoSphere Information Server 11.7 (and below), Informatica 6.1, IBM Datastage Flow Designer

Data Quality: IBM QualityStage (Data Cleansing, Data Standardization)

Data Profiling: IBM - InfoSphere Information Analyzer

Scheduling Tools: Autosys, Crontab, Control - M, Zena

Tools & Utilities: Teradata Load and Unload utilities, HP Quality Center (For testing/defect tracking), Toad, ALM (Application LifeCycle Management), Jira, GitLab

Project Management Methodology: Waterfall, Agile (Scrum)

PROFESSIONAL EXPERIENCE

Confidential

Sr. Software Developer

Responsibilities:

  • Modified all DS jobs to point to new directory structures.
  • Exported jobs to new DS 11.7 environment
  • Migrated code to upper environment using GitLab CI/CD process.
  • Planned and conducted ETL unit and development tests; monitored results and took corrective action.
  • Created a generic automated process for comparing Datasets for regression testing.
  • Responsible for creating documentations related to regression testing.
  • Responsible for modifying Control-M flow.

Confidential

Application Developer 

Responsibilities:

  • Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of projects using IBM Web Sphere software
  • Work closely with business & IT stakeholders and understand ETL requirements and build end to end ETL framework using IBM DataStage tool.
  • Coordinating with vendors/project team, downstream systems and offshore team for project completion.
  • Design overall ETL framework & data flow.
  • Provided recommendations on techniques to improve data quality, ETL processing & data loading times.
  • Requirement gathering.
  • Unit testing of newly built framework.
  • Assist UAT/SIT testing.

Confidential

Sr. ETL Developer

Responsibilities:

  • Developed ETL process that facilitates Data Movement between internal/external sources and the enterprise by integrating different data formats into a structure that conforms to the business information model and standardize for consumption by enterprise data stores, data marts and 3rd parties.
  • Planned and conducted ETL unit and development tests; monitored results and took corrective action.
  • Created a custom DQ process to maintain data integrity end to end and automated process to collect controls evidence and run time details to load into the audit table.
  • Created automated process for Schema reconciliation.
  • Responsible for loading out/Inbound files to Hive tables.
  • Documented ETL mapping documents.
  • Developed Control-M flow to schedule ETL batch.

Confidential

App Dev Sr.Specialist

Responsibilities:

  • Responsible for creating business rules by using Information analyzer per the specification to support Data Quality Initiative.
  • Import data in Information Analyzer meta data from the production environment.
  • Profiled data in IBM InfoAnalyzer using rules and column analysis against source files.
  • Developed exception management process for reporting using IBM Datastage.
  • Created projects, add data sources, write, configure and execute rules/rule sets within Information Analyzer.
  • Profiled and analyzed data in IBM InfoAnalyzer using rules and column analysis.
  • Based on IA reports, standardized data using Quality stage.
  • Created 1100+ rules and 400+ rule definitions for checking syntax, date time, cross reference validations.

Confidential

Sr. Associates

Responsibilities:

  • Responsible for loading data from 3rd party vendors into the Data Lake housed on the Hadoop file system and from data lake to staging databases and then to Enterprise Data warehouse tables for analytics.
  • Developed ETL process that facilitates Data Movement between internal/external sources and the enterprise by integrating different data formats into a structure that conforms to the business information model and standardize for consumption by enterprise data stores and data marts.
  • Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, prepared test data for testing, error handling and analysis.
  • DDL creation for the additional attribute identified for generating the Summary reports and performing the data load.
  • Created a load process using Teradata Parallel Transporter utility to load a huge file of 250 gb into Teradata table.

Confidential

Sr. ETL Developer

Responsibilities:

  • Built, tested and deployed scalable, highly complex and reusable Datastage parallel and Quality stage jobs.
  • Created the High Level Design and Low level design documents for the DataStage and Quality stage components.
  • Achieved 80% data matches with existing production data, 15% improved data than existing production data and remaining 5% new data added which were missing in the old system.
  • Developed data profiling solutions, run analysis jobs and view results, and create and manage data quality controls using Information Analyzer.
  • Reduced manual efforts of Business analysts by around 60% by improving quality of data using Quality stage.
  • Created local and shared containers to facilitate ease and reuse of jobs.

Confidential

Datastage Administrator/Developer

Responsibilities:

  • Performed troubleshooting and performance tuning, analyzing defects, bug fixing for ETL jobs.
  • Installation and configuration of IBM Information Server 9.2 and patch management.
  • Performed administration tasks like role setup, connectivity, security, configuration of projects, user registries, create or update users and groups, mapping credentials, configuring DSN and TNS entries, parallel, compiler, reporting, operator and user-defined environment variables, Linux Mounts create,RFC Deployment, Log clean up, Code Backup, Server Patching, Schedule Changes.
  • Monitor the InfoSphere suite (Data Stage/Quality Stage) servers 24*7.
  • Kill/assist release job locks, shared memory locks, hung processes etc .
  • Apply fixes, patches and service packs as required to the InfoSphere suite (DataStage/QualityStage/IA).
  • Scheduled Datastage jobs sequence using Director and Crontab.
  • Management of the Datastage servers with security compliance, product licensing, making sure that the number of CPU/LPAR is matching with the number licensed.

Confidential

Assistant Consultant

Responsibilities:

  • Added Data Quality improvement with Data Profiling, Standardization, Cleansing, Deduplication and Enrichment as per business requirements.
  • Create a detailed proposal for the ETL process.
  • Requirement documentation, developing functional and technical specifications, DW and ETL design document, developing detailed mapping specifications, DFD's, scheduling charts.
  • Designed, developed, tested and attuned Datastage jobs. Analyzed and modified existing ETL objects in order to incorporate new changes in them according to the project requirements.
  • Designing and developing SCD Type I & II jobs
  • Designed staging and Error handling tables keeping in view the overall ETL strategy.
  • Developed UNIX scripts to perform multifarious data processing tasks and automation functions.
  • Automated the business process to save 40 hrs/quarter of manual efforts of Business Analyst.

Confidential

Datastage Developer

Responsibilities:

  • Performed Project Requirements Gathering, Requirements Analysis and creating requirement specification and analysis of requirements.
  • Define the total number of Interfaces developments/enhancements required for the business request.
  • Developing design strategy and jobs based on the requirement
  • Developed Unix scripts, to perform multifarious data processing tasks and automation functions.
  • Performed Unit and Integration testing and validated the test cases by comparing the actual results with expected results Peer review.
  • Designed job sequences to automate the process and document all the job dependencies, predecessor jobs, and frequencies to help the Sustain people better understand the job runs.
  • Prepared Release Document.

Confidential

Analyst Programmer

Responsibilities:

  • Developed Data stage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Data Warehouse Databases.
  • Created shell script to run data stage jobs from UNIX and then scheduled this script to run data stage jobs through a scheduling tool.
  • Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
  • Involved in the migration of Datastage jobs from development to QA and then to production environment.
  • Production Support

Hire Now