Programmer Analyst Resume
AR
SUMMARY
- 7 years of IT experience in system analysis, design, development and migration of Data warehouse applications and business intelligence.
- Extensive experience in ETL development using IBM InfoSphere Information Server Datastage 9.1/8.5/8.1.
- Excellent experience in retail industry.
- Extensive hands - on experience working on relational database platforms (RDBMS) like Oracle, SQL Server, DB2 and Teradata.
- Proficiency with data analysis, data integration, dimensional modeling and database design and development.
- Strong experience in writing PL/SQL, stored procedures, functions and database triggers.
- Proficieny with Teradata utilities like BTEQ and FastExport.
- Demonstrated experience in defining and documenting business requirements, migration rules and preparing technical specification architecture documents.
- Deep knowledge in developing a unified view of the business for better decisions using Datastage.
- Solid experience in analyzing query performance issues. Extensive experience in loading huge volume of data.
- Advanced experience in Unix programming.
- Experienced in working with scheduling tools like Autosys and TWS.
- Experienced in Quality Assurance and creating test cases to ensure the data meets the business requirements.
- Ability to formulate concepts; communicate technical information to a non-technical audience; communicate business information to a technical audience.
- Proven experience in working with Agile/scrum methodology.
- Capable of working under high stress environment with resource constraints.
- Experience in mentoring junior developers.
- Ability to lead teams of individuals in a matrix organization.
- Excellent experience and ability in managing multiple assignments simultaneously.
- Excellent analytical, communication, and facilitation skills with the ability to gain consensus across multiple teams.
TECHNICAL SKILLS
ETL Tools: IBM Infosphere Information Server 9.1/8.5/8.1, QualityStage, IS Import/Export Manager, GRID, LSF.
BI Tools: OBIEE, Oracle RPAS (Retail predictive application server)
Programming/SQL: Unix Shell scripting, SQL, SQL Plus, PL/SQL, XML, HTML
Operating systems: Windows 2003/2007, UNIX, IBM AIX, Mainframes
Databases: Oracle 11g/10g, Teradata 12/13, DB2, SQL Server 2008
Tools: SQL Developer, Autosys, TWS, Excel, Visio, TOAD, Oracle RPAS v13.0.3
Other: SFTP/FTP, SVN repository, Clear case, Clear quest, WinSCP, Reflection, SAN/NAS, Remedy 7, MS Office
PROFESSIONAL EXPERIENCE
Confidential, AR
Programmer Analyst
Responsibilities:
- Interacted with business users to analyze requirements and translate into ETL data migration rules. Served as business analyst to internal clients.
- Produced detailed business process flows, functional requirement specifications and data models and communicated the requirements to the design and build teams.
- Ensured that the delivered solution fulfills the needs of the business.
- Involved with senior management in terms of supplying key inputs for design and architecture decisions, as well as work estimation and resource planning.
- Built and managed relationships with cross functional teams required in delivering solutions to customers.
- Experienced in partnering with staff deployed globally, including direct staff, vendors, and offshore partners.
- Worked in an Agile/Scrum methodology to deliver high-quality software releases every 2 weeks through Sprints.
- Assisted in determining the data integration system project scope, time and required resources.
- Provided support and analysis of data collection and mapping functions.
- Conducted cost & benefit assessments of the functionality requested by end-users.
- Designed ETL jobs with complete understanding of GRID technology and suggested design changes to reduce the job wait time in the queue before the jobs gets submitted to the compute node.
- Done unit testing and end-to-end testing of the components designed.
- Experience taking complex business requirements and building a test suite to validate against the system design.
- Developed test automation of test plans, scenarios and scripts, and manage test artifacts/deliverables.
- Log software defects in the defect tracking tool (JIRA/HP ALM) and track to closure.
- Managed defects from identification to completion.
- Wrote complex FastExport script to extract data from Teradata source.
- Developed BTEQ scripts to transform data, do record count validation, generate reports and export tables.
- Created PL/SQL procedures to execute a complete set of business logic for validation and to run collect stats on the tables.
- Responsible in designing various business scenarios that defines all possible business outcomes and provided QA team a basis for their more detailed test scripts.
- Ensuring timely delivery of required ETL tasks and set priorities for the team to ensure task completion.
- Prepared the implementation documentation for the production install.
- Developed diagnostic jobs to help verify the connectivity to source and target databases, SFTP connection to Mainframes before running actual flow in production.
- Troubleshoot production issues post release deployment.
Environment: InfoSphere Information Server 9.1/8.5/8.1, Rally, Jenkins, JIRA, HP ALM, Mainframes, GRID, Platform LSF, Oracle 11g, Teradata, View point, Linux, QueryMan, CA7 Scheduler, SQL developer.
Confidential, AR
Programmer Analyst
Responsibilities:
- Responsible for integration of Oracle Retail modules in the retailer’s system landscape.
- Analysed and translated stakeholder requirements into various documentation deliverables such as functional specifications, use cases, workflow/process diagrams, and test scenarios.
- Involved in project planning and tracking and management.
- Written shell scripts to generate reports in html formats that depicts information on budgets and projections for the calendar year which is used by business for analysis.
- Have designed the RPAS workbooks and have written scripts for auto purging when they exceed the limit.
- Extensively used RPAS commands like exportData, usermgr, stopRPASDataService, and stopRPASODBCAgent, DomainDeamon to export the data, add/delete the users, start and stop the ODBC drivers, load the measures data, copy user styles.
- Worked with Oracle on RPAS configuration issues and auto purging of the workbooks on the global domain.
Environment: Oracle RPAS v13, DB2, Teradata, Linux, IBM AIX, QueryMan, CA7 scheduler.
Confidential, AR
Programmer Analyst
Responsibilities:
- Conducted and participated in the requirements and design walk through meetings with the client for the data warehouse data requirements.
- Responsible for designing ETL processes and the use of the DataStage ETL tool throughout the project lifecycle. Develop solutions to leverage ETL tools and suggest process improvements.
- Worked closely with the development and business teams to ensure that the solutions meet the business and non-functional requirements.
- Assist with design and implementation of data warehouses, planning applications and reporting solutions.
- Performed troubleshooting on issues with the implementation of the solution.
- Driven UAT activities with business partners to ensure solutions meet business requirements.
- Provided the peer review for the code developed.
- Wrote Linux scripts to facilitate ETL scheduling processes.
- Assist in the final implementation and go-live activities planning.
- Provide ongoing maintenance and support of assigned ETL flows and their target applications.
Environment: IIS Datastage 8.5, GRID, LSF, DB2, Teradata, Linux, Windows Server 2003, QueryMan, CA7 scheduler.
Confidential, AR
Senior DataStage Developer
Responsibilities:
- Involved in business requirements analysis and with the stake-holders.
- Worked closely with subject matter experts on the requirement analysis, source/target data analysis.
- Prepared the technical design documents and low-level design documents for the technical specs.
- Co-ordinated and lead the offshore team.
- Designed ETL jobs with complete understanding on how GRID works and how to reduce the job wait time in the queue before the jobs gets submitted to the compute node.
- Used CDC (Change Data Capture) stage to capture the new records and updated records and implemented SCD type 2.
- Utilized IS tool Manager for Import/Export.
- Extensively used DataStage Director for emailing production support for troubleshooting from log files; collected full summary logs files from the Director for additional debugging.
- Created the shell scripts for pre/post processing of the files.
- Processed the files received from the business and ensured that the downstream team is able to consume the data.
- Worked along with Mainframe team, used JCL scripts for scheduling the DataStage jobs.
- Provided code approvals after peer review of the DataStage jobs and conducted impact analysis.
- Fine tuned DataStage jobs for better performance to bring design parallelism.
- Executed SFTP by opening a command shell from within DataStage. Also made sure that any number crunching or SFTP s will be farmed-off to the compute nodes inorder to reduce the overhead on head nodes.
- Used CA7 Scheduler to schedule the DataStage jobs.
- Performed end-to-end testing of the flow.
- Prepared the implementation plan for the code migration to QA/Production.
- Implemented the job retry logic in DataStage through trigger script.
- Supported through Production for successful execution.
- Supported DataStage specific problems on call rotation 24/7.
Environment: Datastage 8.1, GRID, LSF, DB2, Teradata, SQL server 2008, Mainframes, Windows Server 2003IBM Rational Software Architect, QueryMan, CA7 scheduler.
Confidential, CA
Datastage Developer
Responsibilities:
- Worked extensively on data warehousing, extensively used DataStage an ETL tool to design mappings to move data from source to target database.
- Obtained detailed understanding of data sources, flat files and complex data schema.
- Designed parallel jobs using various stages like Aggregator, Join, Transformer, Sort, Merge, Filter and Lookup, Sequence, ODBC, Hash file.
- Broadly involved in data extraction, transformation and loading (ETL process) from source to target systems using DataStage PX.
- Extensively used DataStage Designer and Director for creating and implementing jobs.
- Involved in creating technical documentation for source to target mapping procedures to facilitate better understanding of the process and incorporate changes as and when necessary.
- Automation of ETL processes using DataStage job sequencer and transform functions.
- Extensively used DataStage Director for job scheduling, emailing production support for troubleshooting from log files.
- Involved in performance tuning on the source and target at DataStage level and data loading.
- Developed PL/SQL stored procedures for source pre load and target pre load to verify the existence of tables.
- Performed unit testing of all jobs. Used Peek stage for debugging.
- Perform testing sessions for reports and dashboards.
- Strictly followed the change control methodologies while deploying the code from DEV to QA and Production.
- Assisted both the development and testing offshore teams.
- Involved in 24/7 ETL production support, maintenance, troubleshooting, problem fixing and ongoing enhancements to the data mart.
- Installed Datastage 8.1 clients for new team members.
- Added users for Datastage project and given appropriate permissions for developers and operators.
- Released Datastage job locks from Universe.
- Killed old and phantom dsapi sessions and processes.
- Re-designed the already developed Datastage jobs for enhancing job performance and execution.
- Participated in meetings with IBM to discuss better ways to build Datastage environment.
Environment: IBM DataStage v8.1, QualityStage, Oracle 11g, PL/SQL, Windows Server 2003, Erwin, TOAD,UNIX Shell Scripting, TWS.