Swapnil Das

Long Beach, California Mobile No: 562-***-**** E-Mail: acz7fo@r.postjobfree.com

Career Objective

To use my abilities, skills and knowledge in a professional environment with long term career growth possibilities.

Education

California State University, Long Beach

Master’s in Computer Science, expected graduation date: 05/2017 National Institute of Technology, Raipur

Bachelor of Technology in Computer Science, 06/2014 Technical Skills

Languages: C, C++, C#, JAVA, Microsoft SQL, HTML scripting, PL/SQL. PowerShell, WMI Query Language Tools: NetBeans IDE, Informatica Cloud Services, Informatica Power Center 9.5x, Autosys, TOAD, Putty, IBM Cognos, SSAS.

Certification: Training in Core Java from BIOS, training in Web application development in Servlet and JSP from NIIT, Bhopal.

Operating Systems: UNIX, Windows Sever 2012, Windows 10, MacOS 10.x Related Experience

University Relations & Development, California State University Long Beach Student Assistant Technical Support (10/2015-present)

• Act as a single point contact for the client for all workstation issues and ensure client satisfaction by responding to all escalations regarding client issues.

• Used IIS and WSUS to ensure all changes were implemented in client systems with a proper change record and after implementations to ensure that service norms committed to customer are met.

• Played a key role in the review and implementation of compliance standards while deploying application packages, software updates and OS deployment in System Center Configuration Manager 2012(SCCM).

• Responsible for planning, execution and coordination of software deployment strategies to deliver software product to client workstations.

• Played a key role in the review and implementation of security and compliance standards for all supported clients.

• Conduct periodic reviews of information security policies, procedures, and compliance including employee access rights to corporate servers. Prepare reports of findings for review by management.

• Created packet filter configuration file for customizing firewall rules in Apple systems to ensure complete remediation of all the potential security threats and assist with the investigation, documentation, and response to all suspected information security events. Infosys

Systems Engineer (Dec 2014-July 2015)

• Interacted with client teams for providing regular updates, problems and analyzing the error in job failure and fixing it within a fixed time-line.

• Assisted team members with developing SQL queries using databases Oracle 10g and SQL server to extract the data from various sources such as flat files, Oracle database and load to a single platform.

• Developed and used ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica PowerCenter 9.5x.

• Played a significant role in Extraction, Transformation, Load (ETL) data from various sources such as Oracle, flat files etc. into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor and Repository Manager).

• Developed, implemented and maintained mappings and workflows in Informatica according to business requirement.

• Conducted periodic audits of various implementation strategies in existing mapplets and mappings in Informatica.

• Performed V5 mapplet testing to test the mapplets upgraded from older version to newer version.

• Lead an initiative on making autosys whole box jobs to schedule the jobs so that it can run on timely basis to get the data.

• Was responsible for delivering procurement from DEV to PROD environment end to end, including QA and UAT signoff.

• Developed and optimized coding implementations according to SDLC standards involving Application development and ETL/OLAP processes.

• Developed and distributed reports that include findings and recommended remediation steps while developing and analyzing UNIX scripts and commands. Systems Engineer Trainee (May 2014-Nov 2014)

• Trained in communication abilities for client interactions.

• Created ready-to-launch application platform for mobile users using Informatica, Cognos and SSAS tools.

• Trained in C, C++, C#, JAVA, HTML scripting and UNIX shell scripting. Achievements

Business Management: Came 2nd in business plan for a computer hardware manufacturing company. Created budget, marketing expenses and resource management for it. Music management: Was a member of Musical committee management team for 2013-14. Computer Workshops: Attended workshops in Robotics and in Computer components and Description. Extra-curricular Activities

Performed in SHRUTI’12 –a musical eve.

Organized DOODLES 2.0 event in annual cultural festival-ECKLETIKA’11

Contact this candidate