ETL Developer

Syed Usman Ali Shah

*** **** ***, ***** *** Francisco, CA 94080 (415) -272-0276 ac17yh@r.postjobfree.com

PROFILE An enthusiastic Bachelors level IT graduate with 4 years of credible experience in IT. Through my career till date I have gained an extensive experience and understating of Microsoft technologies and Databases, Virtualization and integration of ETL technologies. Have a proven track record of holding positions of importance requiring a high degree of competence and responsibility. Respected team player who is willing to do what it takes to get the job done

EDUCATION

Bachelor of Science (Computer Information)

San Francisco State University (SFSU)

TECHINCAL SKILLS

Programming Languages: Java, C++, HTML, .NET, PHP, JavaScript, XML, CSS, Groovy and Grill, SQL, T-SQL, UNIX shell scripting and K-Shell

Development Tools: Netbeans7.0, Eclipse, Visual Studio, Sql Developer

Databases: Oracle 10g, JDBC, TOAD, Trillium, TeraData 6, DB2 UDB 6.x,7.x,8.x

Web Servers: Tomcat, Glassfish

Operating Systems: Windows 7/8, UNIX

ETL Tool: Informatica Power Center 9.x/8.x/7.x, Ab-initio GDE 1.15/3.25

EXPERIENCE

ETL Developer/Data Analyst Jan 2017– Current

Kiser Permanente, Baton Rouge, LA

Hands-on practical experience with various Ab Initio components such as Join, Rollup, Scan, Reformat, Partition by Key, round robin, gather, merge, Dedup sorted, FTP etc.

Well versed with various Ab Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism and Multi File System (MFS) techniques.

Hands on experience in end-to-end of Data warehousing ETL routines, which includes developing Ab Initio graphs, stress testing, and data quality process.

Designed and deployed well-tuned Ab Initio graphs (Generic and Custom) for unix environment.

Practical experience with working on multiple environments like production, development, testing.

Thorough understanding of the issues involved in mappings, development and integration of a software product.

Experience in requirement analysis, client interaction, development, testing and security.

Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like checkin and checkout were used for this purpose.

Maintained locks on objects while working in the sandbox to maintain the privacy

Used inquiry and error functions like is_valid, is_defined, is_error, is_defined and string functions like string_substring, string_concat and other string_* functions in developing Ab Initio graphs to perform data validation and data cleansing.

Developed Complex XFRs to derive new fields and solve various business requirements.

Worked on multiples Releases for Enhancement and defects related to the code.

Perform/responded on the Impact assessment related to Applications/Jobs.

Provided resolution within the SLA (Service Level Agreement).

Performed shake-out testing on server/Database upgrade.

Review loan files to ensure compliance with investor guidelines, credit quality, and data integrity.

Identify any potential red flags or areas of risk concern and escalate them for additional verification or investigation.

Ensure monthly audits are completed as outlined in the Quality Assurance Plan.

Validated system generated reports for source to target comparison and reports created by the data correction.

HONORS:

Client value award Q4

Manger’s Choice Award

Programmer Analyst II May 2014 – Nov 2014

Stowers Institute for Medical Research, Kansas City, MO

Worked on web based application using php symfony and JavaScript with Extjs.

Created modules for both the client and server.

Used Jira tools to meet the responsibilities for the Project.

Used Sql to support client related request.

Stored and merge the code changes using github.

Environment: PHP Storm 4.8, Symfony 4.2, JavaScript ExtJs 4.2, Oracle 10g, SQL Server 2005, Windows XP, UNIX, Github 11.10.12.

Computer Lab Assistant Aug 2010 – Dec 2012

San Francisco State University

Supporting University students & staff with application software, including Microsoft Office, Outlook, Visio, and SharePoint.

Good understanding of the ITIL framework and processes in places to support IT operations.

Monitor and respond to support requests using the ticketing system, providing appropriate responses or escalate problems as necessary.

Network Administration of the TCP/IP, DHCP, DNS and Wireless configuration.

Secured and managed the networks using McAfee anti-virus protection.

Perform numerous NT Administrative duties including creating users in AD, creating shared directories, assigning user rights and monitoring performance.

Installation, configuration and maintenance of local and network printers in the university.

Responsible for maintaining the software license and IT asset Register.

Robotic Team, Academic Project Aug 2012 – Nov 2012

SFSU, San Francisco, CA

Created an operating system for a robot that will pick a ball using Microsoft Kinect

Make use of the Ubuntu to install operating system on beagle board, Eclipse

DST BASS Scheduler GUI, Academic Project Aug 2012 – Nov 2012

SFSU, San Francisco, CA

Working with a team of 5 to create a website for the DST company for their database

Make use of Groovy and grills to develop that website

The Pouch, Academic Project

SFSU, San Francisco, CA Aug 2011 – Nov 2011

Working with a team of 5 to create an Android application which helps the freshman student find their class room, parking place and computer labs at SFSU.

Make use of Android SDK, Eclipse, Oracle 9i to develop the application.

Contact this candidate