SUMMARY:

• Software Developer with 7+ years of experience providing solutions needs in Media, Financial, Transport and Logistics, Consumer Products Industry with emphasis on design, development, implementation, and management of projects.
• Strong experience in all phases of Software development lifecycle (SDLC) - requirement analysis, design, development, and testing.
• Strong working knowledge of SQL Server 2000/2005/2008/2012/2014/2016, ORACLE, DB2.
• Excellent T-SQL Developer skills including Stored procedures, Views, Indexes, Cursors to facilitate efficient data manipulations as per business rules.
• Extensive experience in developing scalable, reliable, and efficient enterprise applications using Java, XML, SQL, Python
• Strong software experience in design, development and deployment of web based Client-Server business applications using OOP, Java technologies and working on complete Software Development Lifecycle (SDLC)
• Experience in IBM Info Sphere Data Stage and Quality Stage 8.7,8.5,8.1 and 7.5
• Experience in client/server and Business systems with Data Warehousing experience on Extraction, Transformation and Loading (ETL) processes using Ascential Data Stage 7.5 using components like DataStage Designer, DataStage Manager, DataStage Director, DataStage Administrator and Parallel Extender and IBM Info Sphere 8.7/8.5, Web Sphere 8.1 (Data Stage, Information Server, Information Analyzer, Metadata Server).
• Experience in ETL tools, such as DataStage Parallel Extender/EE for Parallel Processing to improve job performance while working with bulk data sources. Worked with most of the parallel stages applying different partitioning techniques.
• Experience in SSIS tools like Import and Export wizard, Package Installation and SSIS Package Designer.
• Good knowledge and experience in developing and designing reports through SSRS.
• Developed many Server jobs for extracting, transforming, integrating, and loading data to targets.
• Experience in using Quality stage with investigate, standardize, match frequency, and survive.
• Experience in using Information analyzer with column analysis, primary key, foreign key, cross domain, and baseline analysis
• Good experience in developing strategies for Extraction, Transformation and Loading using DataStage.
• Experience in using Stages like Aggregator, Merge, Join, Hashed File, Lookup, Transformer, Switch, Modify and Slowly Changing Dimensions.
• Experience in design, development and deployment of Web based Client-Server business applications using OOP, Java/J2EE technologies
• Experience in designing user interfaces for web applications using various web technologies such as HTML, CSS, XML, JavaScript and JQuery
• Experience in application/web server like Apache Tomcat
• Expertise in implementation of Core Java concept of Java/J2EE
• Good working knowledge in Microsoft SQL Server and UNIX
• Knowledge of XML and related technologies like XSL, XSLT
• Experience working with Log4J
• Sound knowledge of Design patterns like Model View Controller (MVC) architecture
• Experience in SSIS tools like Import and Export wizard, Package Installation and SSIS Package Designer.
• Good knowledge and experience in developing and designing reports through SSRS.
• Efficient in in corporation of various data sources such as Oracle, MS SQL Server and DB2, Teradata, XML, and Flat files into the staging area.
• Experience in Designing, Compiling, Testing, and Scheduling and Running DataStage jobs.
• Expertise in data migration projects with (target - source) same database as well as with heterogeneous databases.
• Experience in Debugging, Troubleshooting and Performance tuning.
• Handled large volumes of data warehouse database
• Ability to adapt to new technologies and environments quickly.
• Good experience in Agile Methodologies, Test Driven Development(TDD).
• Good team player, Strong Interpersonal, Organizational and Communication skills.
• Excellent Presentation and Customer handling skills.

TECHNICAL SKILLS:

ETL Tools: Web Sphere 8.7/8.5 (DataStage, Information Server, Quality Stage, Information Analyzer, Metadata Server), Ascential DataStage 7.5/6.0XE/5.0(Designer, Manager, Director, Administrator and Parallel Extender)

Operating Systems: Windows 98/2000,2003, Windows NT 4.0, HP-UX, Linux, AS400 and IBM AIX 4.0, MS Access 2000/2003

Databases: Oracle 10g/9i/8i, DB2 7.2, Teradata V2R6/V2R5, and SQL Server 2016/2014/2012/2008/2005/2000

Languages: XML, XSLT, PL/SQL, SQL, Sun Solaris 5.8/2.7, JAVA

Database Tools: SQL developer, Toad, SQL*Loader, Import, Export

Other Tools: Altova XML Spy, ERwin 7.0/4.1/4.0/3.5, Toad 8, Autosys 3.0, SQL*Loader, SQL *Plus, IBM Tivoli 8.2, Sterling Commerce, Yantra, Netezza, JIRA, Jenkins

Reporting Tools: COGNOS, SSRS

Version Control: SVN, GIT, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta

Software Developer

Responsibilities:

• Involved in understanding Business Process and coordinating with Business-users to gather the requirements discuss and resolve integrity issues with ETL and reporting.
• Worked extensively on Designing Dimensional Model (Star schema and Snowflake schema), database administration, slowly changing Dimensions
• Worked on SQL stored procedures, triggers, table partitions and experience in loading data in to Data warehouse/data marts using DataStage
• Created numerous simple to complex queries involving self-joins, sub queries for diverse business requirements.
• Migrated data from Oracle to SQL Server and converted PL/SQL procedures to T-SQL procedures.
• Migration of data from staging Areas into EBI to store reliable data for decision support system using DataStage as ETL tool
• Created ETL jobs/Stored procedures for truncate of table individually as well as schema level, to refresh any materialized views and to update the audit columns for daily incremental loads
• Identified existing bugs in IBM DataStage tool 8.7/8.5 and had taken necessary precautions to avoid data issues
• Preparing the low-level design and mapping document based on the Solution provided by the Architect team
• Working on designing, developing the ETL job based on the mapping document.
• Created Datastage jobs for the reconciliation processes Between ERP (source) and EBI in such a way that if there would be any data discrepancy it would notify by email
• Fully involved in the Performance Tuning of the Datastage jobs using different methodologies like configurations of the environment variable file, designing and editing configurations, increasing the reading as well as the writing speed while fetching or loading data to files or database
• Designed job sequences in Control-M to automate the process using JCL scripts and document all the job dependencies, predecessor jobs and frequencies to help the production support people to better understand the job runs
• Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
• Analyzed massive and highly complex datasets, performing ad-hoc analysis and data manipulation using T- SQL.
• Worked extensively on Error Handling and data validation.
• Created Python scripts for analyzing large quantities of data.
• Integrated Python with SQL queries and automated these using Airflow.
• Migrated data from Oracle to SQL Server and converted PL/SQL procedures to T-SQL procedures.
• Used the SQL Server Profiler tools to monitor the performance of SQL Server to analyze the performance of stored procedures.
• Designed and Developed automated jobs -Talend jobs, Airflow DAGs, SSIS package for the automation of the pricing model analysis datasets.
• Created unit tests and validated results based on Test Driven Development, participated in peer code reviews.
• Extensively involved in debugging, testing and data validation.
• Reviewed Data Stage jobs and test cases before delivering to client.
• Worked with complex logics as per the business requirement to integrate in the ETL jobs
• Involved in Production support for the delivered projects
• Write the technical documentation
• Created units tests and validated results based on Test Driven Development, participated in peer code reviews.
• Used Agile methodology for all the projects and used JIRA for project management.

Environment: IBM Web sphere Data stage 8.7/8.5/8.1/8.0, Windows NT 2003, Unix SOLARIS, Toad, Oracle 11g/10g/9i, SQL, ERwin, Quality Center, Contorl-M, JCL, SQL Server 2016.

Confidential, Atlanta

Programmer Analyst

Responsibilities:

• Participated in all stages of the development life cycle including requirement analysis, design, development and implementation (SDLC) of the system.
• Designed and Developed T-SQL structures to implement business logic with CTEs, table variables, temporary tables and join functions to support database applications.
• Developed and maintained complex T-SQL scripts for data retrieval and manipulations.
• Regression testing was performed after each new build of the application
• Created the DataStage Projects that uses ODBC Stage and configured the ODBC settings.
• Imported and exported Repositories across DataStage projects.
• Extensively worked on Parallel jobs Enterprise Edition Environment for splitting bulk data into subsets and to dynamically distribute to all available processors to achieve best job performance.
• Established best practices for DataStage jobs to ensure optimal performance, reusability, and restart ability.
• Defined and documented the required data validation rules on the source feed files that were used in ETL.
• Created shared containers and multi instance jobs to enhance the performance by using more modular components.
• Customized UNIX scripts as required for preprocessing steps and to validate input and output data elements, along with DataStage routines.
• Prepared the test cases for system test.
• Used Quality Stage to parse and standardize the data according to the business requirements.
• Developed Quality stage jobs like investigate, standardize, matching frequency and survive.
• Extracted data from multiple databases like Oracle and Teradata and loaded into Oracle tables.
• Followed Star Schema and Snowflake Schema to develop data marts.
• Extracting, cleansing, transforming, integrating and loading data into data warehouse using DataStage Designer.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Used DataStage Director and the runtime engine to schedule running the parallel jobs, monitoring and debugging its components for performance and events such as error conditions.
• Developed server jobs using server jobs stages like ODBC, Merge, Sort, Hashed file, Transformer, XML input, XML output, XML Transformer, Web Services Client
• Involved in the testing of the various jobs developed and maintaining the test log.
• Used Autosys to schedule, run and monitor DataStage jobs.
• Used Clear Case for version control and Clear Quest for bug tracking.
• Worked on troubleshooting, performance tuning and performance monitoring for enhancement of DataStage jobs.
• Designed and developed Servlet components.
• Exposed and consumed SOAP based Web Services to communicate between systems.
• Used Maven for building the application locally and deploying it to local DEV servers.
• Developed various Web Services using Eclipse IDE.
• Worked on reading data from XML files and parsing the XML document.
• Worked on coding, implementation of front end using AJAX, HTML, CSS and JavaScript.

Environment:: IBM Info Sphere Information Server DataStage 8.5, Quality Stage 8.5, MDM, Oracle 10g/9i, IBM DB2 9.5, Erwin 7.0/4.0, TOAD 9.6, Windows XP, IBM AIX 5.3/5.1, Microsoft Visio, XML, XSLT, SQL, PL/SQL, Unix, SQL Server, Stored Procedures, DB2 UDB, Rational Clear Case and Rational Clear Quest, XML, Java, Maven, Web Services, AJAX, HTML, CSS, JavaScript.

Confidential, Amherst

Research/Teaching Assistant

Responsibilities:

• Using the Model View Controller architecture designed a web application for schools that host’s courses and educational materials. Application is configurable to use a specific database on a user-supplied hostname.
• Designed and developed complex T-SQL stored procedures for data manipulation.
• Worked extensively on Error Handling and Data Validation.
• Used SQL Server Profiler tools to monitor the performance of SQL Server to analyze the performance of the stored procedures.
• Designed and Developed automated Talend Jobs for the automation of various analysis datasets.
• Involved work in UNIX and Windows environment.
• Worked as a lab assistant and assisted students in developing complex queries using SQL including cursors, creating views, synonyms, and indexes.
• Assisted students with creating DDLs and DMLs.
• Evaluated, graded, and maintained student records, successfully completed various academic projects during this tenure.
• Coordinate, lead and assist in the instructional process in preparation and direct interaction with students in lab or problem sessions.

Confidential

Assistant Design Engineer

Responsibilities:

• Worked with the Business analysts for requirements gathering, business analysis, testing, and project coordination.
• Involved in creating functional and scope documents for ETL processes.
• Identified and documented data sources and transformation rules required to populate and maintain data warehouse.
• Developed DataStage parallel jobs to load data from sequential files, flat files and Oracle.
• Used DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts .
• Used several stages like Sequential file, Hash file, Aggregator, Funnel, Change Capture, Change Apply, Row Generator (debugging stage), Peek, Remove Duplicates, Copy, Lookup and RDBMS during the development process of the DataStage jobs.
• Created parameter sets to group DataStage job parameters and store default values in files to make sequence jobs and shared containers faster and easier to build.
• Performed through data profiling by using the Investigate stage of Quality Stage and also by writing PL/SQL queries to identify and analyze data anomalies, patterns, inconsistencies etc.
• Used multiple invocation ids to run multiple instances of jobs at the same time.
• Designed job sequences to automate the process and document all the job dependencies, predecessor jobs, and frequencies to help the production support people better understand the job runs.
• Migrated jobs from the development instance to testing environment.
• Performed Unit and Integration testing and validated the test cases by comparing the actual results with expected results.
• Used the DataStage Director and its run-time engine to schedule and run the parallel jobs, testing and debugging its components and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Created Autosys JIL (BOX, CMD, and FWT) Scripts to schedule UNIX Shell scripts.
• Involved in documenting Documents Inspection (DI) results to present to the BA.
• Extensive usage of Toad for analyzing data and writing SQL, PL/SQL scripts performing DDL operations.

Software Environment : IBM Info sphere Information Server 8.1/8.0(Data Stage, Quality Stage), IBM DB2, UNIX, Windows XP, Teradata, Oracle 9i, Erwin.

Confidential

Data Stage Developer

Responsibilities:

• Developed Source to Target Mapping documentation based on business requirement specifications.
• Deployed solutions that maximize consistency and re-usability of the Data Stage Jobs.
• Designed ETL jobs to load data into Staging Tables, CODS Core Model, and CODS Consumption Model.
• Developed jobs in IBM Info Sphere Parallel Extender PX v8.1 using different stages like Transformer, Aggregator, Lookup, Join, Merge, Modify, Remove Duplicate, Oracle Enterprise, Sort, Peek, Filter, Copy, Sequential File, Data Set, Surrogate Key Generator etc.
• Designed Data stage sequences to specify Job execution order.
• Designed ETL jobs to identify and remove duplicate records using remove duplicate stage and Generated IDs for the Unique records using Surrogate key Generator Stage.
• Used parallel-shared containers for reusability in other jobs.
• Designed Some Data stage Server Jobs also.
• Extensively used Data stage Director for monitoring and debugging of jobs and sequences.
• Created source to target mapping documents from source to staging area, Staging to CODS Core and Cods Core to Cods Consumption Model mapping Documents.
• Worked on SQL for extracting the data from the Oracle source and Wrote Oracle stored procedures & called the stored procedure in Data Stage.
• Tuned Data stage jobs to obtain better performance.
• Unit Test Data stage Jobs in development including creating the appropriate test data.
• Proactively evaluated the quality and integrity of data required by the users to satisfy their business needs.
• Created and stored the parameters using parameter sets.
• Self-documenting ETL Jobs to comply with Metadata standards.
• Used Autosys Scheduler Tool to schedule Data stage jobs.
• Finally had knowledge transfer meetings to make new team familiar with the project for future Development.
• Worked on Star Schema and Snowflake Schema Models.

Environment: IBM Info Sphere Information Server V8.1 Suite Data Stage and Quality Stage , Autosys, Oracle10g, SQL, PL/SQL, SQL Loader, TOAD, SQL Plus, UIX-HP, Windows-XP.