Sunil Reddy Kalluri

• Design, develop, automate and support complex applications to extract, transform, and load data.
• Analyze impact to regulatory reporting applications when incorporating new requirements and changes to architecture.
• Develop effective solutions to new and existing data reporting requirements and data issues primarily using DataStage.
• Perform root cause analysis and address existing issues identified during data delivery to FHFA.
• Find gaps in the existing processes, constantly improve the processes/procedures, automate manual tasks, and provide stability to the applications.
• Thoroughly test and document the developed solutions in multiple environments to meet the user expectations.
• Participate in analysis of agile user stories, prototype, if necessary, set expectations and timelines.
• Automate the developed solutions through UNIX, SAS and other automation tools.
• Coordinate with multiple teams to get the code deployments successfully done and make them live.
• Constantly monitor and maintain the regulatory reporting applications in production.
• Interview candidates for DataStage, UNIX, SQL expertise whenever there is a resource requirement.
• Work on delta and historical extracts. Used SAS programs/DataStage to extract data from upstream.
• Work with Data Validation System for validating the extract file data as per business rules.
• Work on type 2 loads maintaining history for all loans and properties.
• Work as a developer/tester as per need in wrapping up JIRA stories.
• Work extensively with flat files and command line while dealing with flat files.
• Written shell scripts to compress and SCP flat files to external FHFA servers.
• Used Autosys for scheduling purposes and GIT EYE for code versioning.

Environment: Infosphere DataStage 11.5 (Administrator, Director, Designer), DB2, Sybase Putty, Autosys, RapidSql, GIT, SQL, JIRA, SAS.

• Worked as an ETL developer in McKesson’s Medical & Surgical Sales IT department.
• Supported the implementation of data transfer from various McKesson’s acquired companies to McKesson’s Medical & Surgical Datamart.
• Worked on SCD Type 2 customer dimension loads.
• Worked on debugging various issues during development and testing phases and helped in identifying multiple production bugs.
• Worked on enhancing the ETL code for existing tables when there is a change requested from users.
• Helped fixing the production defects quickly.
• Helped fix complex SQLs to reduce the latency and performance tune the ETL jobs.
• Installed and monitored new control M jobs when there is a need for new job scheduling.
• Worked extensively on Sequencers with Notification activity, User variable activity, Execute command activity, etc.
• Updated the design documents and supported UAT testing and Production deployments.

Environment: Infosphere DataStage 11.5 (Administrator, Director, Designer), Oracle, Putty, control M, TOAD.

• Worked as a developer and an on-Call production support person.
• Worked extensively on Reusable jobs and shared containers.
• Created and updated the source to target Documents for every new table which describes the Business need, Source feed info and target info.
• Worked with various Vendors for the data flow and integrating the company’s batch jobs.
• Used SFTP setup and jobs to push/pull data between servers.
• Used Control M to automate the batch jobs. Created control M jobs and scheduled them and set cross project dependencies.
• Used loop variables and other functions to organize unformatted data in flat files.
• Written shell scripts to SCP files from other servers onto ETL servers and Implemented loops in shell scripts to consume data in case of multiple source files.
• Developed jobs using stages ODBC Connector, DB2 Connector, Look-up, Join, Funnel, Aggregator, Remove Duplicates, Filter, Copy, Sort, Peek, Surrogate key generator, Dataset, Sequential File, Modify, Pivot and Transformer.
• Helped Level 2 support in fixing various production failures.

Environment: Infosphere DataStage 11.5 (Administrator, Director, Designer), Flat files, Datasets, DB2, Oracle, Putty, control M, GIT EYE, Squirrel SQL.

• Worked on DataStage migration from v 8.5 to 11.5.
• Created, updated and reviewed SDLC life cycle documents like Functional requirement specification, Software development specification, Test Strategy, Test Specification, Change Request, Impact Analysis.
• Extensively used Sequential file, DB2, Join, Lookup, transformer, datasets, filter, Merge, Sort, remove duplicate stage for designing the jobs in the Data Stage Designer.
• Worked with data feeds from various source systems from flat files, XML files, DB2 databases.
• Using the partitioning techniques in the jobs to improve the performance.
• Involved in analyzing and modifying the existing scripts.
• Developed Sequences and used different Stages like Execute Command, Job Activity, Notification Activity, User variables Activity and Wait for File Activity stages.
• Data stage jobs were edited for performance tuning and ease of implementation.
• Defined test cases as a part of user testing and drove testing cycle execution of both SIT and UAT. Also documented the results for test cycles.
• Identified, resolved source file format issues for production loading & data quality.
• Enhancements are made to jobs as per the requirements and Unit testing of the jobs.
• Fix the QA defects within the time lines.
• Involved in production support activities.

Environment: Infosphere DataStage 11.5/8.5 (Administrator, Director, Designer), Flat files, DB2, Rapid SQL, Putty, Autosys scheduler, Sybase, MS Visio, GIT EYE.

• Identified source systems, their connectivity, related tables and fields and ensured data suitability for mapping.
• Prepared Data Mapping Document and Design the ETL jobs based on the DMD with required Tables in the Dev Environment.
• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements& Design.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the IBM DB2 database.
• Experience in Teradata RDBMS using Fast Load, Multiload, Fast Export, Teradata SQL Assistant and BTEQ.
• Designed and Developed Data stage Jobs to Extract data from various sources, applied transformation logics to extracted data and Loaded into Data Warehouse.
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
• Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool Autosys using JILs.
• Coordinated with team members and administer all onsite and offshore work packages.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• 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.
• Performed Performance testing with different sets of node configuration, different queue and different volumes.
• Prepared the DML's for maintenance tables, review, and test and execute them. Used Tortoise SVN version control tool for version controlling and movement of code to upper environments like SIT, UAT, Pre production and Production.

Environment: IBM Web Sphere DataStage 8.5, Director, Administrator, Microsoft Visio, IBM AIX 4.2/4.1, SQL Server, IBM DB2, ORACLE 11G, TERADATA, Autosys Scheduler, Unix, Windows.