Technical Lead /developer Resume
SUMMARY:
- Highly adaptive and seasoned IT - professional with 10 years of diverse problem solving experience in software development, maintenance, integration and implementation of IT projects
- Experienced in Data integration and migration using ETL approach
- Experienced in developing ETL solutions using Informatica Powercenter tools
- Proficient in planning and completing projects to high standards in critical time situations.
- Experience using TeraData, Oracle 11g/10g, DB2, MS SQL Server, VSAM, UnixScripting
- Expertise in Power Center tools - Mapping Designer, Workflow Manager,Workflow Monitor and Repository Manager
- Sound experience in Informatica ETL, COBOL programming
- Proficiency in developing complex SQL with different databases Teradata, Oracle, MS SQL Server and DB2.
- Experience in creating views, SQL performance tuning
- Strong communication and analytical skills
- Strong ability to understand business process
- Proven ability to quickly grasp client business needs and develop solutions
- Experienced in leading a team and possess ability to work with diverseworkforce.
TECHNICAL SKILLS:
ETL Tools: Informatica Powercenter Tools (Designer, Workflow manager,workflow monitor,Repository manager),Informatica Powerexchange
Version Control: Endeavor, ChangeMan, VSS, Sharepoint,SVN
Programming Languages: COBOL, JCL, Unix scripting
Defect Tracking: HP ALM, Quality Center
Familiarity with: PL SQL, Teradata Procedures, BTEQ, OBIEE, C, C++, Unix, MQSeries, ESP Scheduler, Salesforce IntegrationPowercenter CDC
Database: Teradata, Oracle, DB2,IMS,Informix
Modeling Tools: MS Visio
Other Tools: Oracle SQL developer, Toad for Oracle, Terradata SQL Assistant, Toad for DB2, SQL Server Management studio, Putty, WinSCP,Razor SQL
PROFESSIONAL EXPERIENCE:
Confidential
Technical Lead /Developer
Responsibilities:
- Deployment and support for Code Releases
- Maintaining and Supporting Informatica, Oracle, Teradata Code base
- Understanding business functionality, Build and testing coordination.
- Performance tuning & optimization of informatica and SQL
- Expert Developer skills in Database including Oracle,Teradata, SQL-Server
- Data Integration to Salesforce Systems
- Informatica Powercenter CDC for Real Time data capture
Technical Lead
Responsibilities:
- Design and create Fact tables for business reporting requirements
- Create Adhoc reports as per business requirements for executives
- Deployment and support for Code Releases
- Maintaining and Supporting Informatica, Teradata Code base
- Understanding business functionality, Build and testing coordination.
- Performance tuning & optimization of components specially using PDO.
- Expert Developer skills in Teradata RDBMS, initial Teradata DBMS Environment setup,development and production DBA support, use of FASTLOAD, MULTILOAD, and Teradata SQL and BTEQ Teradata utilities.
Senior COTS Functional Consultant
Responsibilities:
- Estimation, Integration interface Design
- Participate in Team meetings and design ETL approach to extract data
- Code changes, testing, Test plan review, Code Reviews, Offshore coordination
- Responsible for system test set up and UAT
- Implementation and post implementation support
- Leading the offshore & onshore team, providing daily & weekly updates to the client
- Worked on Informatica version based environment and used deployment groups to migrate components to higher environments
- Analyzing data from multiple systems, drawing conclusion & developing recommendations for extracting data
- Performance tuning of SQL queries and views using partition pruning, creating indexes
- Performance tuning & optimization of components
- Mentor and train new team members
- Working with QA team for system & UAT testing
Senior COTS Functional Consultant
Responsibilities:
- Create AS-IS,TO-BE system diagrams
- Code changes, testing, Test plan review, Code Reviews
- Responsible for risk management and scheduling JAD sessions with stakeholders to address issues.
- Responsible for system test set up and UAT
- Responsible for development of the project modules
- Weekly project planning and allocation
Technical Consultant
Responsibilities:
- Perform estimation, impact analysis and requirements gathering
- Research for the mapping of various attributes
- Review, Code Reviews, implementation tasks and implementation support
- Responsible for system test set up and UAT
- Responsible for deployment of the project modules
- Weekly project planning and allocation
Senior Technical Lead
Responsibilities:
- Design and build during the development phase
- Implementation support during the implementation phase
- Performed Bug Fixing and follow-up testing
- Code Review and implementation task follow ups
- Quick Analysis and Resolution for the issues faced during Implementation
- Responsible for Schedule Adherence in deliveries of Change requests to meet SLA goals.
Team Member
Responsibilities:
- Impact Analysis, Design, Build, Unit testing for the project
Module leader
Responsibilities:
- Root Cause Analysis, Design, Build and code review.
- Impact Analysis and Detail design for Enhancements.
- Configuration controller for the project.
- Knowledge transfer to teammates.
Team Member, Module leader
Responsibilities:
- Root Cause Analysis, Design, Build of Code fixes for issues in the application.
- Impact/Feasibility Analysis
- High Level & Detail Level Designs
- Design and Code Reviews
- Configuration controller for the project.
- Responsible for Schedule Adherence in deliveries of Change requests to meet SLA goals