Application Development Senior Analyst Resume

SUMMARY

Senior Informatica Developer with 6+ years of extensive hands on experience on ETL Informatica.
Excellent problem solving, fast Learning, presentation and analytical skill with the ability to work in both independent and team environments.
Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
Experience in integration of various data sources like Oracle, flat files into staging area,Teradata.
Implemented various Data Transformations using Slowly Changing Dimensions.
Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
Extensive Experience on Teradata database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables with in committed timelines.
Developed various dashboard on Tableau desktop for insurance and banking clients.
Strong business understanding of verticals like Banking, investment and insurance.

TECHNICAL SKILLS

Operating Systems: Unix, Windows

Software/Applications: MS 2000, MS Word, MS Excel, MS Access, Outlook, PowerPoint.

Database: SQL Server, TeraData, Oracle 11g

ETL: Informatica PowerCenter 9.6, Informatica PowerExchange 9.6

Language: SQL, Shell Script

Tools: Oracle SQL developer, Toad, Tableau

PROFESSIONAL EXPERIENCE

Application Development Senior Analyst

Confidential

Responsibilities:

Perform extensive database programming and tuning of SQL queries.
Create ETL (Extract, Transform and Load) workflows for data mining, data cleansing, data load into a relational and non - relational database that include creating database tables and views.
Worked on Teradata tools and utilities (BTEQ, Fast load, Multi Load, Fast Export, and TPUMP).
Profound knowledge about the architecture of the Teradata database and experience in Teradata Unloading utilities like Fast export.
Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
Extensive Experience on Teradata database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables with in committed timelines.
Experience in working with Unix commands.
Working with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options

Senior Associate

Confidential

Responsibilities:

Creating mappings using different transformations and loading the stage tables.
Generate the files and Sftp to Sigfig drop box. Perform health check on the files and send reports to end users. Perform reconciliation for position and balances files generated within UBS and files send by Sigfig.
Coordinating with the onshore team to manage application and to address issues changes on a daily basis.
Creating Autosys jobs for scheduling.
Worked in AGILE development environment using JIRA and Confluence.
Monitoring and managing QA defects in ALM.
Schedule extract refresh for weekly and monthly reports.
Creating SCR and deployment notes to migrate the code to higher environments.
Involved in cleansing of data and designing the data modeling part.