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.