We provide IT Staff Augmentation Services!

Senior Software Developer, Team Lead Resume

Agoura Hills, CA

SUMMARY

  • 15.2 Years of IT experience.
  • Worked in complete Software Development Life Cycle (SDLC), starting from requirement gathering, analysis, design, testing, debugging, implementation, post implementation support and till maintenance.
  • Good team player, strong interpersonal and communication skills combined with self - motivation initiative and positive attitude.
  • Good in Onsite-Offshore work co-ordination.
  • Worked on Oracle Database supporting OLTP and Data Warehouses.
  • Also worked on the ETL Tools like Informatica, Ab-Initio and Reporting tools like Cognos, OBIEE.
  • Strong experience with Informatica tools - Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository Manager, Workflow Manager and Workflow Monitor, and DAC as Scheduler tool.
  • Created worklets by grouping different sessions related to a subject area.
  • Have knowledge about the Informatica PowerExchange.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Developed effectively different type of SCD’s based on the specifications.
  • Sound experience in Performance tuning of ETL process. Reduced the execution time for huge volumes of data for a company merger project.
  • Successfully co-coordinated for the project activities in off-shore/onsite model with a team of 12 members.
  • Experience in interacting with onsite clients while being responsible for deliverables.
  • Ability to work with limited resources, capable of multi-tasking, planning works around concurrent and time sensitive deliveries.
  • Quick to learn.
  • Worked in Agile work environment.
  • Handle the work independently.
  • Had a good knowledge and completed training in Oracle Data Integrator (ODI)
  • Looking ahead for great personal and professional career in a fair working environment with opportunities to grow.
  • Organizing timely meetings with Business and other teams, then sharing the MoM based on the meeting outcome.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows XP/2003/2007/8

Languages: C, C++, Java, SQL, PL/SQL

Databases: Oracle, MS Access, DB2

Web Related: Salesforce, HTML

ETL Tools: Informatica Powercenter 10.2, Informatica Cloud 9.6, Informatica Powercenter 9.1, Informatica Powercenter 8.6, Informatica Data Quality 9.6, ESP, Ab Initio

Schedulers: DAC (Data Warehouse Administration Console), CA7 in Mainframes, Control-M, Crontab, Autosys

Reporting Tools: Cognos, OBIEE

Utilities: TOAD, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Agoura Hills, CA

Senior Software Developer, Team Lead

Responsibilities:

  • Leading ETL design and implementation to ensure smooth data extraction, transformation and load into data warehouse
  • Responsible for transforming logical business requirements into appropriate schema and data model.
  • Responsible to create both logical and physical data models using ERWIN
  • Experience with modern cloud based DWH products like AWS Redshift
  • Responsible in mapping the requirements with FDS and URS document for functional phase and develop the program respectively.
  • Managing Centralized data for entire organization at one stop
  • Experience with modeling normalized and de-normalized data structures
  • Responsible for designing and developing the ETL for consolidated reporting from Salesforce, legacy DB and other data sources into Salesforce wave.
  • Responsible for design efficiency to minimize data refresh lags between systems to report timely data.
  • Responsible to enhance the existing data warehouse star schema.
  • Tune the Oracle databases and ETL for maximum performance.
  • Responsible for Data Profiling, Data Cleansing, and Data Auditing.
  • Extensive design and development experience in Datawarehouse and data mart design
  • Experience with loading large volume of data from Salesforce and oracle-based sources (Merlin) using tools like Informatica
  • Experience of data modelling and data bases like Redshift, Oracle & MySQL
  • Experience with modern cloud based DWH products like AWS Redshift
  • Ability to decode and write complex SQL queries
  • Performance tuning of queries and data loading process
  • Experience with data analytics using tools like Salesforce
  • Lead the project with a team of ten members and mentor newly joined engineers to the optimum level of efficiency.

Environment: Informatica Cloud, Informatica Powercenter 10.2, Salesforce, Oracle 11, Unix, BitBucket

Confidential, Boston, MA

Senior Software Developer

Responsibilities:

  • Gather and analyze the requirements from Business Analysts of Confidential .
  • Prepare the technical design documents.
  • Perform project activities in compliance with the Agile/Scrum methodology.
  • Designed and created the tables by following Snowflake Schema Methodology.
  • Estimate the efforts (in terms of hours) based on the tasks assigned and plan the work accordingly.
  • Make use of the ETL tool like Informatica PowerCenter, ESP and Oracle SQL/PL-SQL appropriately in the project considering multiple factors such as optimal performance and easy maintenance of code by maintaining the industry standards.
  • Design and develop new code for bringing in new functionality as per the Business expectations
  • Providing knowledge to the code for handling multiple Business cases for a given scenario thus reducing the efforts for doing re-work.
  • Migrate the code from development to UAT
  • Do the unit testing and integration testing as per test cases.
  • Fix the bugs that get popped up during this process
  • Provide test results to Business and get their sign-off to go-ahead for further process.
  • Creating scripts in Unix for auditing and scheduling of batches by considering their dependencies
  • Deploy the code to Production following the process from end to end.
  • Track the issues and work on them on priority issues.
  • Include enhancements in the code based on the on-going business changes.
  • Preparing the documentation for easy maintenance of project.
  • Update Business and Manager about the timely status of work completion and projected timelines.

Environment: Informatica Cloud, Informatica Powercenter 10.2, Informatica Powercenter 10.1, OBIEE, SQL Server, Oracle, PL/SQL, Control-M, Unix

Confidential

Senior Informatica Developer

Responsibilities:

  • Discussed with Business users to understand their current requirements
  • Analyzed the list of existing workflows at each subject area level.
  • Prepared the technical design documents.
  • Estimated the efforts (in terms of hours) based on the tasks assigned to team and guide them accordingly.
  • Designed and developed new workflows wherein the functionality was not incorporated in existing code.
  • Purged a part of the existing code that is not required anymore and enhanced where needed.
  • Used Informatica Cloud to extract the data from Salesforce to Oracle database.
  • Track the issues and work on them on priority issues.
  • Tuned the workflows that are having performance issues by taking the statistics from the production environment.
  • Created PL/SQL procedures in the instances wherein PL/SQL works much more efficiently than Informatica
  • Prepared the test cases and got the sign-off from Business.
  • Created deployment groups and migrated the code from Dev to QA environments
  • Performed the unit testing and integration testing as per test cases.
  • Involved Business wherever needed and got necessary approvals by contacting various teams (like Business users, Informatica Admins, Change Management)
  • Deployed the code to Production following the process from end to end.
  • Update the Business and Managers about the timely status of work completion and projected timelines.

Environment: Informatica Power Center 9.6, Informatica Cloud 9.6, Informatica Power Center 8.6, Salesforce, Oracle 11, SQL Server, PL/SQL, Unix, Autosys and TOAD.

Hire Now