SUMMARY:

• Accomplished, adaptable Application Developer with over 16 years of professional IT experience in System analysis, design, development, Data Warehouse/Data Mart design, skilled in the development and implementation of client server applications. Strong business understanding and knowledge of Financial, Marketing, Health Insurance, Consumer and inventory management projects.
• Experience in all phases of Software Development Life Cycle (SDLC). Proficient in transforming Large Volumes of data from various sources (flat files,XML,Oracle,DB2,Teradata,SAP,AS400,Mainframes) to Data warehouse, using IBM DataStage as ETL process and experienced in Data Analysis and BI reporting for Decision making.

TECHNICAL SKILLS:

ETL Tools: IBM DataStage 11.7/11.5/9. x/8.5/7.5x.2/7.5/7.x/6.0/5.x, INFORMATICA 10.1/8.x/7.X, AB - INITIO, MS-SSIS

Reporting Tools: Business Objects 6.1/5.1/SAP BO BI 4.2,Tableau,Hyperion, ReportNet(Cognos), SSRS,MicroStratgey

Data Modeling:  ERWIN 4.x/3.5

RDBMS: Oracle 19c/18c/12c/11g/10g/9i/8i, SQL 2005/2000,MYSQL, DB2 UDB 6.1,Sybase, MS Access,Teradata

Web Tools: Websphere, JDBC, HTTP, JSP, JSTL, Servlets, Struts, HTML, XML, Stellent, JVM and WSAS

UI Tools: Dreamweaver3.0, Frontpage2000

Web Servers: Java Web Server IIS4.0/5.0/6.x

GUI : Visual Basic 6.x/5.0/4.0, VC++

Operating Systems: Windows 10/7/XP/2000/98/95, MS-DOS, UNIX, LINUX,AIX and SOLARIS

Programming Languages: J2EE, C#, C, C++, VB, ASP, Perl, PHPS

cheduling Tools: Autosys, Control M, Automic,UC4, Appworx,CRON

Other Tools:  SAP BW ABAP,SAP BO Data Services, SAP HANA, Hadoop architecture

CORE COMPETENCIES

• Applications Development
• Database Management
• Data Conversion
• Rule Validation
• Information Analysis
• Data Modeling
• Integrations
• Technical Documentation
• Performance Tuning
• File Transfer
• Applications Architecture
• Business Intelligence
• Troubleshooting
• Cloud Computing

PROFESSIONAL EXPERIENCE:

Confidential, st Louis, MO

Lead Applications Developer

Responsibilities:

• Extensively used Data Stage designer to develop Parallel jobs to extract, cleanse, transform, integrate and load data into target tables using different built-in stages.
• Developed business rules validation jobs using Aggregator, Transformer and Filter stages, Used Lookup stage to get the code values and Join stage to combine large data streams.
• Developed user-defined transforms, Routines, Stage Variables and Stored Procedures.
• Developed UNIX scripts as required for preprocessing steps and to validate input and output data elements, along with data stage routines.
• Created Shared containers to increase object code reusability and to increase throughput of the system.
• Extensive Experience using the stages like Slowly Changing Dimension and Change Data Capture(CDC) and Change Apply Stage, Remove duplicates, Funnel, Filter, Copy, Modify, Oracle Connector/Enterprise, Surrogate Key, Aggregator, Transformer Stages.
• Extensive experience in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement or request resource allocation as needed.
• Extensively used Oracle Connector stage, ODBC Connector Stage as source and target Database.
• Worked on custom SQL queries and PL/SQL procedures for custom coding in the jobs.
• Removed Duplicate data or filter from the source system by using Remove Duplicates, Transformer stages to enhance high quality processing of the incoming data.
• Worked on source data analysis to verify Quality of the data using Information Analyzer / DataStage QualityStage
• Worked on Performance tuning of the jobs and Oracle database queries.
• Build, customize and publish interactive reports, visualizations and dashboards using BO and Cognos
• Develop dashboards and visualizations that empower decision makers
• Knowledge on creating BI reports on Tableau.
• Used Automic/UC4 to schedule and monitor job flows.
• Created Multiple Instance Jobs thereby reducing redundancy in job design.
• Debugged front end applications supporting java based platform.
• Analyzing data using Hive QL, Pig Latin and import/export data using sqoop.
• To reduce the response time, aggregated the data, data conversion and cleansed the large chunks of data in the process of transformation.
• Actively participated in the Team meetings to gather the business requirements and developing the specifications and compiling BRS(BLS).
• Obtained detailed understanding of data sources, Flat files and Complex Data Schema.
• Developed star schema data model using suitable dimensions and facts.
• Successfully Integrated data across multiple and high volumes of data sources and target applications.
• Involved in creating technical documentation for source to target mapping procedures to facilitate better understanding of the process and in corporate changes as and when necessary.
• Provisioned and operationalized MDM data with graph-based exploration of master data, transactional data and Hadoop to drive entity insight and analytics.
• Extensively used DataStage Director for Job Scheduling, emailing production support for troubleshooting from LOG files.
• Created UNIX shell scripts to invoke jobs and pre/post processing files.
• Used several stages while developing Parent, Child Sequencers like Start Loop, End Loop, User Variable Activity, Nested Condition, Routine Activity and Mail Notification stages.
• Complied change control methodologies while deploying the code from DEV to QA to UAT to Production.

Lead Administrator

Confidential

Responsibilities:

• Installed, configured, and modified systems as per business requirements.
• Upgraded the DataStage EE servers to IIS (IBM InfoSphere Information Server) 11.7.
• Enhanced and Implemented Client Server applications, ERP and Web Applications.
• Performed upgrades and implemented the various patches on the systems to ensure its effective working.
• Extensively worked with DataStage Administrator in setup, general administration and routine housekeeping of DataStage.
• Setup ODBC connections for different source databases like ORACLE,SAP HANA,SQL Server and MySQL inside DataStage.
• Performed troubleshooting for IBM, assisted the ETL team in DataStage issues.
• Coordinated with the IT team to provide the necessary support to the DataStage environment.
• Maintained a backup of the DataStage in case of emergency.
• Regulated the DataStage for optimum performance at all times.
• Installed and maintained the IBM InfoSphere Information Server in the AIX platform.
• Worked with DataStage Director to schedule running the solution, testing and debugging its components and monitoring the resulting executable versions (on adhoc or scheduled basis).
• Extensive experience developing File Transfer jobs using SCP, SFTP,FTP and PGP encryption.
• Used Automic and CRON to schedule DataStage jobs, Shell Scripts& Perl scripts.
• Ensure proper security of assigned system components, and design security rules to enforce security.

Environment: IIS DataStage 11.7.0.2/11.5/9.1/8.5/8.1/7.5.1 A, Citrix,Web Technology, LAWSON Business Intelligence, CVS, SVN, GIT,SAP Business Objects, SAP BODS,SAP HANA,Cognos, Websphere, J2EE, JDBC, HTTP, JSP, JSTL, Servlet. JeStruts, HTML, XML, Stellent, JVM and WSAS, Tomcat, Apache, IIS, MS Application Center, Jenkins, Ansible,.Net/Com+,Visual Basic, VC++, DataStage TX, Web Technology, LAWSON Business Intelligence, Oracle 19c/18c/12c/11g/10g/9i/8i,MS SQL Server,MYSQL, DBMS/RDBMS, MS ACCESS, PL/SQL, CRON, Automic/UC4, APPWORX,JAMS& MS OFFICE, WINDOWS 10/7/XP,NT,AIX/UNIX and LINUX RHEL 7.6(Maipo)/6.1/5.6.MS Azure. VMWare Sharepoint,Timeline PI,Data Robot,Orion,Maximo,Service Now