Smita Singhal

Experience

• 

  Tata Indicom

  Sept 2006 - Feb 2007

  Trainee
• 

  Polaris S/w Lab Ltd, Chennai

  Mar 2008 - Oct 2009

  Developer

  Client: Citi Network, UKTechnology: .Net, SOA, Oracle 10g, SQL, PL-SQL, Informatica Power Center DescriptionProactive Reconciliation is a product that is mainly used to reconcile any type of transactional data in financial institutions. Source data in several formats like SWIFT, flat files etc are pulled into the database by an engine called 'Recs Engine'. The data are then used by PROactive Reconciliation application to identify discrepancies between transactions and provides functionality to manually review and fix them. This application follows the SOA structure. Business logic and rules are implemented and exposed as WCF services. Job Responsibility includes • Creating and executing queries like ‘connect by prior’, join, union• Developing various stored procedures using PL/SQL to perform various kinds of data check and audits according to bank data factory standards• Created detailed design documents, performed data source analysis and developed different validation checks which will perform data quality checks• Responsible for the daily, weekly and monthly loads monitoring (session log etc) and handling bad data• Participated in build and release activities including IUT and Regression testing Show less

• 

  LITS

  Jan 2010 - Apr 2011

  Technical Specialist

  Client: Astellas Pharmaceutical, USATechnology: Informatica Power Center 8.6.0, Oracle 10g Description:Developed system is to load data from various data sources in data warehouse and marts and create reports in Business Objects intelligence product suite for their sales force reps and managers. The project is to assist Data warehousing migration, which requires conversion of existing mappings and development of new mappings using Informatica Power Center. Job responsibilities:• Understanding and documenting business requirements• Ensuring requirements have been analyzed sufficiently so that all implicit requirements have been documented during the development phase• Designing Informatica modules and developing code to extract, load and transform data into data warehouse• Preparing Analysis documents and Approach documents• Preparing Unit and System Integration test documents• Implementing performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance• I also created Project Induction Pack for new hires Show less

• 

  Wipro Technologies

  Jun 2011 - now

  Informatica Developer

  Client: Charles Schwab, USA Technology: UNIX, Teradata, Informatica Power Center 8.6, Oracle 10g( SQL), ESP job scheduler, SFDC CloudDescription:Project is to recommend, build & support systems used by the reporting groups in SICROPS and other business users. The system provides central data integration platform to support management & regulatory reporting, business analytics and decision support application function.Job responsibilities:Development and Enhancement:• Interaction with business analyst to understand business requirements• Designing and developing Informatica jobs to extract, load and transform data from various sources such as Oracle, Flat files, Teradata, SFDC • Developing complex mappings (such as Type I and II SCD) using Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet designer• Developing and executing various Unix scripts using pre/post-session commands to schedule loads through SQL- loader utility• Debugging code from within the mapping designer to troubleshootProduction Support and Operations: • Batch process monitoring and issue fixing • Interaction with the clients for various issues and escalations• DLA (Downloading agent) maintenance and monitoring Show less

• 

  INautix Technologies

  Dec 2013 - Apr 2018

  Technical Lead