LiveCareer-Resume

technology architect resume example with 15+ years of experience

JC
Jessica Claire
Montgomery Street, San Francisco, CA 94105 (555) 432-1000, resumesample@example.com
Summary
Sharp, Organized & Goal-Oriented Data Warehousing solution provider with  10 years of experience providing programming and database expertise. Working as an ETL Technology Architect with experience in Data Modeling.  Organizational driver offering productivity improvements, pioneering technologies, process redesign and reengineering.
Desire a challenging lead role in building & managing Data Warehousing.
Highlights
  • Data warehousing and Business Analytics development with Dimensional Modeling
  • Performance and scalability optimization and strong decision maker
  • Excellent analytical skills, problem solving & troubleshooting abilities along with expertise in performance tuning activities.
  • Proficient in balancing multiple projects with strong ability to delegate and meet deadlines
  • Efficient in planning, comfortable with change with strong collaborative skills
  • Strong Customer relationship and communication skills
  • In depth knowledge of the full SDLC.

 

  • Teradata RDBMS & Utilities 
  • Informatica Powercenter
  • Informatica Powerexchange
  • Informatica B2B
  • Knowledge on Informatica MDM & Cloud
  • UNIX Shell scripting
  • Data Modeling
  • Maestro/WLM Job Scheduling
  • Project Proposal
  • DB2
  • Oracle
  • Knowledge on Big Data/Hadoop 
Professional Experience
09/2014 to Current Technology Architect Lumen Technologies | Weehawken, NJ,


  • Building & Managing Teradata Warehouse - As a senior developer using Teradata and it's utilities (BTEQ, FastLoad, TPT) along with Informatica Powercenter & Powerexchange, scheduling in Maestro Jobstreams
  • Engaged in requirement gathering and creation of conceptual Data Modeling
  • Managing & Tracking changes in Data Model through ERwin using Forward Engineering & Reverse Engineering and maintaining them in versions
  • Preparation of High level design documents and presenting them in the round table discussion
  • Creation of Data mapping document with the input of Project BA & Primary Data Architect 
  • Complete ownership of migrating Informatica, Teradata, Maestro & UNIX components into higher environments till Production deployment and executing them till satisfactory data loads.
  • Solution provider - Peer review of all new and enhanced ETL project designs and help them presenting through documentation
  • Creating & presenting technical solutions on upcoming Project Proposals with effort estimations
  • Helping newly built production support team in solve job failure issues
 
02/2006 to 10/2014 ETL Project Lead Cognizant Technology Solutions | City, STATE, USA

 

  • Managed 1.3 Million project with high data volume on daily basic and keeping history data with Slowly Changing Dimension concept in data warehousing.
  • Excellent concept and hands on experience of relational database management systems of DB2 and extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various legacy source systems.
  • Delivered solutions by showing extensive technical expertise and strong business understanding of US Insurance domain.
  • In depth experience in performance tuning in Informatica & Database level.
  • Outstanding knowledge in Teradata database & the utilities like BTEQ, FastExport, FastLoad & MultiLoad with 4 years of building & maintaining a complex data warehouse in Healthcare domain.
  • Participated in the creation of a robust Informatica ETL framework that facilitates object reuse, data quality control and error handling.
  • Good Knowledge of UNIX shell scripting which is used to execute the Informatica components and other regular activities.
  • Worked with XML source & Target and did proper co-ordination with multiple project layers of transferring and receiving data.
  • Extremely efficient in job scheduling through Maestro scheduling tool.
  • Worked with Data Architects & DBA to create the data model for the data warehouse.
  • Closely worked with Client Business Analyst in Requirement gathering & requirement analysis and propagate the knowledge to the all project members.
  • Provided 4 years client-facing techno-functional role with satisfying all business needs.
  • Led Data Warehousing process improvement effort to implement standardized methodologies, reusing components to improve the overall software process and lifecycle and reducing cost of learning things for new team lead and team members.
  • Created Technical Specification document covering architectural flow.
  • Good knowledge in Sybase database including stored procedure and other relational database properties.


Education
Expected in 2005 Bachelor of Science | Information Technology Kalyani Govt. Engineering. College (West Bengal University of Technology), , Kolkata, GPA:
Accomplishments
  • Leadership with Flexibility: Built a new complex data mart in Teradata with aggressive timeline and sequences of changes and achieved multiple client appreciations.
  • Recognitions: In just 4 months of joining project, received client appreciation mentioning "extraordinary work" in planning & completing critical development and helped meeting deadlines of a compliance project.
  • Process Improvement: Represented a team to improve design efficiency and reduce design timeline for entire Data Exchange horizontal which resulted in expected revenue increase of 20% in HealthCare domain.
  • Business Growth: Successfully implemented 2 US critical HealthCare Projects within very short span of time and helped continuing the business client.
Interests

During relax time - play Guitar and Racquetball. Became the part of Company Cricket & Football team members. Passion for driving.

Technical Skills

ETL Tool : Informatica 9.x/8.x/7.x/6.x

Database: Teradata 13, DB2 9.7, Oracle 9i

Scheduling Tool : Maestro, WLM 3.1

Data Modeling Tool : Erwin 9.1, Sybase Power Designer

Reporting Tool : Good knowledge on Cognos

Programming Language: UNIX Shell scripts, PL/SQL, C

Operating Systems: UNIX, Windows Family (98, XP, 2007)

SQL Frontend Tool : Teradata SQL Assistant, AQT, Toad 7.5 & SQL *PLUS

Other Skills: MS Word, Excel, MS Project, MS PowerPoint

Additional Information
People Management : As an offshore project lead managed 15 resources on their daily responsibilities and ensured proper communications with onshore counterpart. Provided timely feedback and completed their appraisal process.
 
Onshore/Offshore Training: Conducted 5 days web based training in Informatica in different onshore/offshore locations. Conducted 2 classroom trainings of 60 entry level resources guidance for 15 days for their First Real Life Projects in Informatica & Data-Stage tools.
 

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Kalyani Govt. Engineering. College (West Bengal University of Technology),

Job Titles Held:

  • Technology Architect
  • ETL Project Lead

Degrees

  • Bachelor of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: