Technology Lead Resume
5.00/5 (Submit Your Rating)
SUMMARY
- Innovative technical professional offering 6+ years of IT experience in full SDLC from Waterfall to Agile methodologies.
- 6+ years of experience in Data Integration (DI) using Informatica Power Center (9.0.1/9.6.1 ).
- 6+ years of experience in Data Cleansing profiling, Standardization(using Address Doctor) and Matching Informatica Data Quality (9.0.1/9.6.1 ).
- 6+ years of experience in UNIX Shell Scripting (bash/korn) and strong relational database concepts like Rank, Rownumber,RowNum, Dense Rank, Lead, Lag, NVL, With etc. in PL/SQL, DB2 and Netezza
- Automated Informatica workflows using Shell Scripting, Control - M Scheduler and Automic.
- Able to work independently and contributed as Subject Matter Expert for the application during discussions with Client and external Teams.
- Extensive experience in Informatica Power Centre Development using Designer,Workflow and Monitor.
- Experience in working on Flat files (ascii and ebcidic), WSDL and relational database using Informatica.
- Built UNIX Shell scripts to call Informatica Mappings using commands like pmcmd, sed, awk etc.
- Worked on designing Stored Procedures in DB2, using the concepts of PL/SQL
- Informatica Administration: Code Migration from dev to test and to production environments using labels and queries, Server Monitoring using Admin Console.
- Delivered optimal ETL solutions involving extensive use of Data warehousing concepts ranging from Data Mart Creation to implementing batch and real-time (Webservices using WS Hubs) systems.
- Created and reviewed HLD’s for the requirements after in depth discussions with Client.
- Enhanced potential of applications by implementing performance tuning techniques resulting into better delivery and increased revenue.
- Performed proof of Concepts on Hive.
- Designed Star, Snowflake and Galaxy Schemas using SCD Type-1, Type-2 and Type-4.
- An effective leader, skilled in enlisting the support of all team members in aligning with project and organizational goals.
- Known for excellent troubleshooting skills - able to analyze and engineer well-researched, cost-effective and responsive solutions.
- Quick learner, self-motivated individual, good team player and have exposure in mentoring, providing KT sessions to team members as well as business partners.
- Passionate to perform Proof of Concepts and explore new technologies.
- Soft skills include Time management, People management, working across time zones, and excellent communication skills.
TECHNICAL SKILLS
ETL Tools: Informatica Power Center (9x), Informatica Data Quality (9x), Abinitio 1.14(Beginner)
Operating Systems: LINUX, IBM-AIX, Windows.
Database: IBM-DB2, SQL Server,Netezza
Languages: UNIX Shell Scripting, C, C++, Basic Core Java, SQL,HTML5, D3 Java scripting-Basic.
Scheduling tool: Control-M Scheduler,Automic
Office Tools: Advance MS Office (Word,Excel, Power Point)
Modeling Tools: MS Visio
PROFESSIONAL EXPERIENCE
Confidential
Technology Lead
Responsibilities:
- Amex has various customers who swipe credit cards on daily basis.
- The project deals with the day to day activities of their like card color change, product change, transactions, suspense, account cancellation, trouble debt restructuring, write-offs and charge-offs etc.
- The project follows a pre-stage, stage and DW architecture, wherein data from source is feeded into pre-stage, transformed in stage and loaded in DW after Daily delta and EOD Balancing.
- Propose technical solutions after thorough analysis and investigation along with funding estimates and timelines.
- Lead and guide the technology team to build the solution under client surveillance.
- Coordinate with client and internal offshore team on scoping, issue resolution and regular status updates.
- Ensure code quality by reviewing the deliverable and get client sign-offs.
- Ensure smooth launch and transition of the solution to client.
Confidential
Technology Analyst
Responsibilities:
- Involved in estimation, staffing analysis and solutioning activities to prepare for solution delivery of the proposal.
- Touch base with clients and business partners, get data requirements and design process for linking capability.
- Ensure quality of the product and plan for timelines of implementation of activities related to design, build and implementation of work product.
- Lead the team to build Informatica Power Center batch processes to extract data, transform according to business rules and load in DB2 tuples.
- Build Unix Scripts to automate Informatica Processes.
- Review each and every deliverable done by the team
- Perform Code Walkthroughs with Client, UAT and get Post Implementation Validation Sign-offs.