| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Phoenix, AZ Street Address PHONE NUMBER AVAILABLE EMAIL AVAILABLE
Senior Software Developer /ETL DeveloperUS Citizen
Professional SummaryAccomplished Senior Software Developer and ETL Developer with 20 years of experience leading projects by acting as architect, developer and programmer analyst in both production support and development environment. Proficient in supporting project deliverables and maintaining releases. Strong leader in guiding support teams and solving complex issues. Steadfast in planning and implementing effective development strategies based on industry best practices. Personable Lead Software Developer accustomed to heading up successful development teams through agile direction and careful delegation. Willing to direct large-scale teams or work hands-on to complete extremely difficult projects. Brings both cutting-edge programming expertise and exceptional interpersonal skills to leadership roles. Software Developer talented at translating customer requirements into testable engineering plans. Maintains exceptional development quality from conception through distribution. Works alongside clients and colleagues through all stages of development to produce exceptional final products. Experienced Senior Software Developer knowledgeable about SQL,PL/SQL, Pro*C software development processes and methodologies. Veteran programmer fully-versed in Oracle at completing projects according to tight deadlines. Achievement-oriented professional with solid background of overseeing system architecture, defining goals and managing project progress with both local and remote teams. Organized and systematic team player with development experience in Agile development environments and Scrum methodology. Expert Informatica ETL Development exiperence in Datawrehousing projects.Accomplishments Served as Lead Programmer on Datawarehouse Project Marriott Vacation Club Resort Booking System.Skills Software Documentation Control Data Storage and Retrieval Scrum Methodology RDBMS Development and SQL Continuous Integration Systems Organization and Time Management SQL PL/SQL Pro*C TSQL Java J2EE Javascript HTML XML API PL/SQL C C++ Java Cobol Foxpro Erwin Toad Software Development Standards Informatica 7.x 8.x 9.x and 10.x UNIX Linux Windows OS Shell scripts Oracle Sybase Microsoft SQL
Server
Work HistorySenior Software Developer 04/2020 to Till date Genentech | South SFO, CA Involved in development of full life cycle implementation of ETL using Informatica, Oracle, helped with designing the Date warehouse by defining Facts, Dimensions and relationships between them, and applied the Corporate Standards in Naming Conventions. Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica. WAR is a data mart on WDM Teradata Platform. It makes use of several source databases in WDM to build customer tables and views to support multiple groups across multiple LOBs. Identified PII (Personal Identifiable Information) columns in the databases and applied encryption rules. Created FSD for the encryption item. Analyzed the existing OLTP system Followed the organization defined Naming conventions for naming the Flat file structure, Informatica mappings, Workflows, sessions and daily batches for executing the Informatica workflows. Developed TPT scripts to load data from files to database and have automated the process. Participated in BCP exercise and was the sole responsible for the application. Created request and made sure code maintained in GitHub, deployment happens through Jenkins and uDeploy. Preparing complex Teradata SQL and PL/SQLs scripts to verify the ETL transformation logic and perform data validation to ensure the integrity of ETL code and Data loads as per the business requirements. Writing UNIX commands and Shell scripts to execute and validate the data. Created several procedures as per business requirement and talking to upstream partners to get data and communicate to downstream consumers. Worked in Tech Refresh Project - 540 to 1075 servers. Worked on the password reset process using SQL Assistant for PROD and BCP servers. The creation of Global Banking Analytics allows for Management Reporting which provides daily, weekly and monthly information to support expansion of products globally and increase market penetration. GBBA is a shared platform application that serves Middle Market Banking analytical and Reporting needs. Support Monthly Offshore Data Processing for Profitability application. Create HIVE queries to join multiple tables of a source system and load them into Elastic Search Tables and used HIVE QL scripts to perform the incremental loads Successfully accomplished TFS-GIT migration. Worked in SSIS 2017 migration Automated the OSDP execution by writing Autosys scripts and scheduled as per the business need. Worked on Year end reporting changes for downstream partners - as they consume latest 5 years data Created several SSIS packages using Visual studio to load the data from files and applied transformation logics. Migrated Mappings, Sessions, Workflows from Development to Test and then to Production environment Worked on some of the POCs on some Tableau reports such as sunburst graph, count validations between different environments etc. Created presentation on Tableau Desktop Vs Tableau web authoring.Senior Software Developer 05/2005 to 03/2020
Marriott Vacation Club | Orlando, FL (onsite/WFH/Remote)
Developed databases, programs and processes for integration and implementation across enterprise. Created and implemented development strategies for impactful projects. Consulted regularly with internal customers on application development project status, new project proposals and software-related technical issues. Gathered and defined customer requirements to develop clear specifications for project plans. Met with project manager and team members to provide detailed project reports and milestone updates. Written PL/SQL stored procedure triggers Pro*C and SQL Loader script. Monitored ongoing operation of assigned programs and responded to problems by diagnosing and correcting logic and coding errors. Orchestrated efficient large-scale software deployments. Used Informatica ETL tool extensively for data migration between databases . Create Mapping Change Mapping Workflow using PowerCenter Installed and Setup Informatica Client and Server Schedule to run Mapping Worked in Datawarehouse Team doing production support development. Worked once a month weekend on-call in production support environment. Testing scripts before going to production environment. Data Migration from Sybase to Oracle MS SQL Server to Oracle and Load files to Oracle db. Using Informatica Loading files automatically in various formats to Oracle database in production environment using Informatica.
Written and updating technical documents. Used Erwin for data modelling. Written Unix shell scripts. Used TOAD to write SQL scripts Written TSQL scripts like stored procedures when migrating from Sybase and Microsoft SQL server. Monitoring of day to day operations of data warehouse jobs and troubleshooting the failed jobs.Senior Software Developer 01/2000 to 01/2005
GTSI | Chantilly, VA
Developed databases, programs and processes for integration and implementation across enterprise. Created and implemented development strategies for impactful projects. Consulted regularly with internal customers on application development project status, new project proposals and software-related technical issues. Gathered and defined customer requirements to develop clear specifications for project plans. Met with project manager and team members to provide detailed project reports and milestone updates. Monitored ongoing operation of assigned programs and responded to problems by diagnosing and correcting logic and coding errors. Orchestrated efficient large-scale software deployments. Adjusted design parameters to boost performance and incorporate new features.Software Developer 04/1998 to 02/2000
MCI Worldcom | Chantilly, VA
Revised, modularized and updated old code bases to modern development standards, reducing operating costs and improving functionality. Developed software for both desktop and mobile operating systems. Collaborated on stages of systems development lifecycle from requirement gathering to production releases. Collaborated with project managers to select ambitious, but realistic coding milestones on pre-release software project development. Gathered and defined customer requirements to develop clear specifications for project plans. Introduced agile methodologies and development best practices to division to enhance product development. Designed and maintained streamlined, reusable and reliable code for use within distributed cloud environments.Senior Faculty Member 05/1991 to 05/1998
Aptech Computer Education | Bangalore India, Karnataka
Graded quizzes, tests, homework and projects to provide students with timely academic progress information and feedback. Evaluated and supervised student activities and performance levels to provide reports on academic progress. Applied innovative teaching methods to encourage student learning objectives. Built strong rapport with students through class discussions and academic advisement. Created materials and exercises to illustrate application of course concepts. Conducted engaging in-class discussions to facilitate learning and encourage participation. Created excitement and enthusiasm in classroom by delivering engaging subject matter. Giving assignments to students to complete Guiding students through course project work.EducationDiploma in Oracle Database / Programming | Computer Science And Programming 01/1997
SSI , Bangalore India
Post Graduation Diploma in Computer Science | Information Technology Computer Science 06/1991
National Institue of Information Technology, Bangalore India
Bachelor of Science | Electronics 05/1991
St Josephs College of Arts & Science, Bangalore India
. |
