Graduate Teaching Assistant Resume Charlotte, NC - Hire IT People

SUMMARY

Graduate student in Computer Science with nearly 3 years of IT experience as ETL developer and Support analyst.
Experience in analysis, design, development, implementation, testing and support of Datawarehouse using DataStage and Cognos Reporting tool. Proficient in writing complex SQL, PL/SQL, T - SQL queries in various RDBMS environments such as Oracle 11g and SQL Server.
Working knowledge in Informatica, SSIS, Qlikview and Tableau.
Strong knowledge of Data Warehousing concepts and Dimensional modelling like Star schema and Snowflake schema. Self- motivated, quick learner with analytical and problem-solving skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2008 R2, Oracle 11g.
ETL Tools: DataStage 9.1, Informatica Powercenter 9, SQL Server Integration Service(SSIS).
Reporting Tools: Cognos 10.2, Qlikview 10, Tableau.
Programming Languages: Java, C, C++, SQL, PL/SQL, T - SQL, Python, R, UNIX, Android Programming(Android Studio)
Web Programming & Others: D3, HTML, CSS, XML, JavaScript, JSP, Servlets, Bootstrap, PHP, MS Office, GIT, Firebase, Realm, SQLite.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Graduate Teaching Assistant

Responsibilities:

Working as Teaching Assistant for the course Object Oriented Systems at undergraduate level and Mobile Application Development at graduate level.
Work with students on individual basis to reinforce learning concepts, help complete assignments and improve performance.
Proved an approachable teaching assistant by enhancing learning using real world and academic experiences.

Confidential

Software Engineer

Responsibilities:

Involved in development of DataStage jobs with required transformations like Aggregator, Filter, Funnel, Join, Lookup, Merge, Sort, Transformer etc.
Involved in creating parallel jobs for existing server jobs to enhance the performance of Datastage sequence jobs.
Developed Cognos Transfomer Models and analyzed the data by generating adhoc reports based on user requirements.
Generated various List reports, Grouped reports, Cross tab reports, Chart reports, Drill-Down and Drill-Through Reports.
Created and managed the daily/weekly/monthly schedules and user access using Cognos Administration.
Designed/Reviewed test cases and performed system testing before deploying code to production environment.
Validated the data reflected in Cognos reports with Oracle database using SQL queries.
Responded to users with solution in a complete and concise manner for the issues reported by them within SLA.
Independently performed complex troubleshooting, root-cause analysis and solution development for issues in production.
Experience in debugging ETL jobs to check for errors associated with job runs.
Worked on enhancements in application by modifying existing ETL jobs and Cognos models to support business needs.
Involved in performance tuning of jobs, SQL queries so that the data is available to users within agreed time.
Experience in SQL, SQL*PLUS, Toad and worked on Stored Procedures, Indexes, Triggers and Packages.