We provide IT Staff Augmentation Services!

Application Systems Engineer Resume

Charlotte, NC

SUMMARY

  • 14 years of experience in IT in the areas of analysis, design, development in client server environment with focus on Data warehousing applications using ETL/OLAP tools like Informatica with Oracle, SQL Server, DB2, Netezza and Teradata.
  • Involved in complete software development life cycle (SDLC) of project with experience in domains like Healthcare Insurance, Automobile, Financial, Banking and Telecom.
  • Experience in business requirements gathering, define and capture metadata for business rules, system analysis, design, development, production support, testing, user training, and strategic decision making, problem solving associated with the ETL processes by working closely with BI team.
  • Experience in developing Enterprise level datawarehouse, Data marts and Operational databases.
  • Excellent knowledge and experience in data warehouse development life cycle, requirements analysis, dimensional modeling, implementation of STAR, Snowflake schemas, Incremental loads, Change Data Capture and slowly changing dimensions.
  • Experience in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica 10.2/9.x/8.x/7.x/6.x.
  • Experience in writing complex sub queries, PL/SQL programs (functions, procedures, packages), and shell scripting to run pre session and post session commands.
  • Worked with heterogeneous data sources like Oracle 11g/10g/9i/8i, SQL Server 2012/2008/2005 , Netezza, flat files, XML files, DB2 UDB, Main Frames, COBOL files, SFDC CRM, Web Services and Lotus Notes.
  • Extensively worked on IDE for data profiling and IDQ for data and quality analysis.
  • Experience in performance tuning of sources, transformations, targets, mapplets, mappings, worklets, workflows, sessions and batches
  • Experience in working with Logical and Physical data models.
  • Expertise in using GUI tolls like Erwin, Toad, SQL Developer, SQL Navigator and SQL *Loader.
  • Excellent communication skills, team player, ability to work individually and meet tight deadlines.
  • Experience in Waterfall, Agile and KanBan development methodology

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.2/9.x/8.x/7.x/6.x, Informatica Power Exchange 5.1/4.7/1.7, IDE, IDQ, Informatica Power Connect and Metadata Manager.

Databases: Oracle 11g/10g/9i, DB2 UDB 8.1, MS SQL Server 2012/2008/2005 , Teradata V2R5.1 and Netezza 6.0/4.x.

Operating Systems: UNIX (Sun - Solaris, HP-UX), Windows NT/XP/Vista/7, MSDOS

Reporting Tools: Business ObjectsXIR2/6.5, Tableau and MicroStrategy.

Modeling Tools: Erwin 4.1 and MS Visio

Other Tools: SQL Navigator, Rapid SQL for DB2, Quest Toad for Oracle, SQL Developer 1.5.1, Autosys, Serena Dimensions Version Manager, MS SharePoint, Mercury Quality center, Team Track, Clear Quest, Aginity for Netezza and Autosys

Methodologies: Ralph Kimball and Bill Inmon

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Application Systems Engineer

Responsibilities:

  • Design, develop and maintain Data warehousing environment to meet Business requirement
  • Implemented Kanban methodology by educating and working closely with team members.
  • Work closely with Offshore team to manage Development and testing efforts .
  • Prepare detailed SDLC documents to keep track of project activities and manage releases.
  • Creates and Updated Autosys scripts to match the user requirements for job scheduling .
  • Perform detailed data analysis for user/LOB enquires during production runs.
  • Involved with the support for the production jobs that run on a monthly schedules.
  • Resolved issues that cause the production jobs to fail by analyzing the log files created by the failed jobs and submit a work order to issue instructions to support team for resolution .
  • Interacted and coordinated closely with the Support Team i n resolving issues that lead to production job failures.

Environment: Informatica Power Center 10.2, SQL Server 2017, Teradata 15.10, Autosys, Sharepoint, OneNote, SVN, JIRA and PAC2000 .

Confidential, Charlotte, NC

Sr Application Developer

Responsibilities:

  • Implemented Informatica Architecture with Netezza database to build a new consolidated data model for reporting.
  • Implemented Agile and Kanban methodology.
  • Analyzing existing T SQL’s queries and build equivalent Netezza SQL’s and prepared design document.
  • Worked extensively on data comparisons between Teradata and Netezza.
  • Used TPT and Fast Export connections in Informatica to source data from Teradata.
  • Worked on converting Business logics and Transformations from Teradata Bteq scripts into Netezza SQLs and Informatica codes.
  • Tuning of SQL statements using Explain plan, analyzing the data distribution among AMPs, collect statistics, definition of indexes, revision of correlated sub queries, usage of functions in joins, etc.
  • Worked closely with business users to identify and address issues before the code moved to higher environment.
  • Experienced in working with business users, IT leads and developers in analyzing business requirements and translating requirements into functional and technical specifications.

Environment: Informatica Power Center 9.6, Netezza Twinfin 6.0 and Stiper 4.0, Teradata 14, Aginity, WinSQL, Microstrategy, Python and Windows operating System.

Confidential, Charlotte, NC

Application Developer

Responsibilities:

  • Designed, developed and maintained ETL Code to meet the requirements of the Business Users .
  • Involved with the support for the production jobs that run at particular schedules.
  • Resolved issues that cause the production jobs to fail by analyzing the ETL code and log files created by the failed jobs on the Informatica server.
  • Performed daily maintenance operations on the Informatica Servers like monitoring the size of log files and cleaning files that are older than a particular period using shell commands and scripts.
  • Creates and Updated Autosys scripts to match the user requirements for job scheduling .
  • Involved with migrating ETL code from Dev to SIT and from SIT to UAT and P roduction.
  • Interacted and coordinated closely with the Support Team i n resolving issues that lead to production job failures.

Environment: Informatica Power Center 9.6, SQL Server 2012 and Autosys.

Confidential, Charlotte, NC

Sr Application Developer

Responsibilities:

  • Implemented Informatica Architecture with Netezza database to build a new Reporting data model.
  • Implemented Agile and Kanban methodology.
  • Analyzing existing data base structure and preparing Technical design document.
  • Extensively used Bulk Reader/Writer to significantly reduce ETL load times.
  • Extensively used Full Pushdown Optimization in Informatica to performance for Netezza DB loads.
  • Thorough understanding of External tables, Organize on, Distribution, Zone maps and other features of Netezza.
  • Used TPT and Fast Export connections in Informatica to source data from Teradata.
  • Involved in design and creation of complex tables, which are capable of handling millions of data every day without impacting the system performance.
  • Responsible for creating workflows, Created Session, Event, Command, and Control Decision and Email tasks in Workflow Manager.
  • Worked closely with BI report developers to build Views so that report performance is optimized.
  • Worked closely with testing team to identify and address issues before the code moved to higher environment.
  • Involved in scheduling jobs using Command Center.

Environment: Informatica Power Center 9.5.1, Netezza Twinfin 6.0 and Stiper 4.0, Teradata 14, Aginity, WinSQL, Tableau and Windows operating System.

Hire Now